Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit68c3549

Browse files
committed
Update oidjoins regression test for 9.5.
New FK relationships for pg_transform. Also findoidjoins now detects a fewrelationships it didn't before for pre-existing catalogs, as a result ofnew regression tests leaving entries in those catalogs that weren't therebefore.
1 parent6fcb337 commit68c3549

File tree

2 files changed

+108
-0
lines changed

2 files changed

+108
-0
lines changed

‎src/test/regress/expected/oidjoins.out

Lines changed: 72 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -545,6 +545,30 @@ WHEREextnamespace != 0 AND
545545
------+--------------
546546
(0 rows)
547547

548+
SELECTctid, fdwowner
549+
FROMpg_catalog.pg_foreign_data_wrapper fk
550+
WHEREfdwowner != 0 AND
551+
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_authid pk WHERE pk.oid = fk.fdwowner);
552+
ctid | fdwowner
553+
------+----------
554+
(0 rows)
555+
556+
SELECTctid, srvowner
557+
FROMpg_catalog.pg_foreign_server fk
558+
WHEREsrvowner != 0 AND
559+
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_authid pk WHERE pk.oid = fk.srvowner);
560+
ctid | srvowner
561+
------+----------
562+
(0 rows)
563+
564+
SELECTctid, srvfdw
565+
FROMpg_catalog.pg_foreign_server fk
566+
WHEREsrvfdw != 0 AND
567+
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_foreign_data_wrapper pk WHERE pk.oid = fk.srvfdw);
568+
ctid | srvfdw
569+
------+--------
570+
(0 rows)
571+
548572
SELECTctid, indexrelid
549573
FROMpg_catalog.pg_index fk
550574
WHEREindexrelid != 0 AND
@@ -609,6 +633,22 @@ WHERElanvalidator != 0 AND
609633
------+--------------
610634
(0 rows)
611635

636+
SELECTctid, loid
637+
FROMpg_catalog.pg_largeobject fk
638+
WHEREloid != 0 AND
639+
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_largeobject_metadata pk WHERE pk.oid = fk.loid);
640+
ctid | loid
641+
------+------
642+
(0 rows)
643+
644+
SELECTctid, lomowner
645+
FROMpg_catalog.pg_largeobject_metadata fk
646+
WHERElomowner != 0 AND
647+
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_authid pk WHERE pk.oid = fk.lomowner);
648+
ctid | lomowner
649+
------+----------
650+
(0 rows)
651+
612652
SELECTctid, nspowner
613653
FROMpg_catalog.pg_namespace fk
614654
WHEREnspowner != 0 AND
@@ -945,6 +985,38 @@ WHEREspcowner != 0 AND
945985
------+----------
946986
(0 rows)
947987

988+
SELECTctid, trftype
989+
FROMpg_catalog.pg_transform fk
990+
WHEREtrftype != 0 AND
991+
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.trftype);
992+
ctid | trftype
993+
------+---------
994+
(0 rows)
995+
996+
SELECTctid, trflang
997+
FROMpg_catalog.pg_transform fk
998+
WHEREtrflang != 0 AND
999+
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_language pk WHERE pk.oid = fk.trflang);
1000+
ctid | trflang
1001+
------+---------
1002+
(0 rows)
1003+
1004+
SELECTctid, trffromsql
1005+
FROMpg_catalog.pg_transform fk
1006+
WHEREtrffromsql != 0 AND
1007+
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.trffromsql);
1008+
ctid | trffromsql
1009+
------+------------
1010+
(0 rows)
1011+
1012+
SELECTctid, trftosql
1013+
FROMpg_catalog.pg_transform fk
1014+
WHEREtrftosql != 0 AND
1015+
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.trftosql);
1016+
ctid | trftosql
1017+
------+----------
1018+
(0 rows)
1019+
9481020
SELECTctid, tgrelid
9491021
FROMpg_catalog.pg_trigger fk
9501022
WHEREtgrelid != 0 AND

‎src/test/regress/sql/oidjoins.sql

Lines changed: 36 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -273,6 +273,18 @@ SELECTctid, extnamespace
273273
FROMpg_catalog.pg_extension fk
274274
WHEREextnamespace!=0AND
275275
NOT EXISTS(SELECT1FROMpg_catalog.pg_namespace pkWHEREpk.oid=fk.extnamespace);
276+
SELECTctid, fdwowner
277+
FROMpg_catalog.pg_foreign_data_wrapper fk
278+
WHEREfdwowner!=0AND
279+
NOT EXISTS(SELECT1FROMpg_catalog.pg_authid pkWHEREpk.oid=fk.fdwowner);
280+
SELECTctid, srvowner
281+
FROMpg_catalog.pg_foreign_server fk
282+
WHEREsrvowner!=0AND
283+
NOT EXISTS(SELECT1FROMpg_catalog.pg_authid pkWHEREpk.oid=fk.srvowner);
284+
SELECTctid, srvfdw
285+
FROMpg_catalog.pg_foreign_server fk
286+
WHEREsrvfdw!=0AND
287+
NOT EXISTS(SELECT1FROMpg_catalog.pg_foreign_data_wrapper pkWHEREpk.oid=fk.srvfdw);
276288
SELECTctid, indexrelid
277289
FROMpg_catalog.pg_index fk
278290
WHEREindexrelid!=0AND
@@ -305,6 +317,14 @@ SELECTctid, lanvalidator
305317
FROMpg_catalog.pg_language fk
306318
WHERElanvalidator!=0AND
307319
NOT EXISTS(SELECT1FROMpg_catalog.pg_proc pkWHEREpk.oid=fk.lanvalidator);
320+
SELECTctid, loid
321+
FROMpg_catalog.pg_largeobject fk
322+
WHEREloid!=0AND
323+
NOT EXISTS(SELECT1FROMpg_catalog.pg_largeobject_metadata pkWHEREpk.oid=fk.loid);
324+
SELECTctid, lomowner
325+
FROMpg_catalog.pg_largeobject_metadata fk
326+
WHERElomowner!=0AND
327+
NOT EXISTS(SELECT1FROMpg_catalog.pg_authid pkWHEREpk.oid=fk.lomowner);
308328
SELECTctid, nspowner
309329
FROMpg_catalog.pg_namespace fk
310330
WHEREnspowner!=0AND
@@ -473,6 +493,22 @@ SELECTctid, spcowner
473493
FROMpg_catalog.pg_tablespace fk
474494
WHEREspcowner!=0AND
475495
NOT EXISTS(SELECT1FROMpg_catalog.pg_authid pkWHEREpk.oid=fk.spcowner);
496+
SELECTctid, trftype
497+
FROMpg_catalog.pg_transform fk
498+
WHEREtrftype!=0AND
499+
NOT EXISTS(SELECT1FROMpg_catalog.pg_type pkWHEREpk.oid=fk.trftype);
500+
SELECTctid, trflang
501+
FROMpg_catalog.pg_transform fk
502+
WHEREtrflang!=0AND
503+
NOT EXISTS(SELECT1FROMpg_catalog.pg_language pkWHEREpk.oid=fk.trflang);
504+
SELECTctid, trffromsql
505+
FROMpg_catalog.pg_transform fk
506+
WHEREtrffromsql!=0AND
507+
NOT EXISTS(SELECT1FROMpg_catalog.pg_proc pkWHEREpk.oid=fk.trffromsql);
508+
SELECTctid, trftosql
509+
FROMpg_catalog.pg_transform fk
510+
WHEREtrftosql!=0AND
511+
NOT EXISTS(SELECT1FROMpg_catalog.pg_proc pkWHEREpk.oid=fk.trftosql);
476512
SELECTctid, tgrelid
477513
FROMpg_catalog.pg_trigger fk
478514
WHEREtgrelid!=0AND

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp