Skip to content

Commit 158d615

Browse files
tglsfdctglsfdc
committed
Update oidjoins regression test for 9.5.
New FK relationships for pg_transform. Also findoidjoins now detects a few relationships it didn't before for pre-existing catalogs, as a result of new regression tests leaving entries in those catalogs that weren't there before.
1 parent dd7a8f6 commit 158d615

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 @@ WHERE extnamespace != 0 AND
545545
------+--------------
546546
(0 rows)
547547

548+
SELECT ctid, fdwowner
549+
FROM pg_catalog.pg_foreign_data_wrapper fk
550+
WHERE fdwowner != 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+
SELECT ctid, srvowner
557+
FROM pg_catalog.pg_foreign_server fk
558+
WHERE srvowner != 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+
SELECT ctid, srvfdw
565+
FROM pg_catalog.pg_foreign_server fk
566+
WHERE srvfdw != 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
SELECT ctid, indexrelid
549573
FROM pg_catalog.pg_index fk
550574
WHERE indexrelid != 0 AND
@@ -609,6 +633,22 @@ WHERE lanvalidator != 0 AND
609633
------+--------------
610634
(0 rows)
611635

636+
SELECT ctid, loid
637+
FROM pg_catalog.pg_largeobject fk
638+
WHERE loid != 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+
SELECT ctid, lomowner
645+
FROM pg_catalog.pg_largeobject_metadata fk
646+
WHERE lomowner != 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
SELECT ctid, nspowner
613653
FROM pg_catalog.pg_namespace fk
614654
WHERE nspowner != 0 AND
@@ -945,6 +985,38 @@ WHERE spcowner != 0 AND
945985
------+----------
946986
(0 rows)
947987

988+
SELECT ctid, trftype
989+
FROM pg_catalog.pg_transform fk
990+
WHERE trftype != 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+
SELECT ctid, trflang
997+
FROM pg_catalog.pg_transform fk
998+
WHERE trflang != 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+
SELECT ctid, trffromsql
1005+
FROM pg_catalog.pg_transform fk
1006+
WHERE trffromsql != 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+
SELECT ctid, trftosql
1013+
FROM pg_catalog.pg_transform fk
1014+
WHERE trftosql != 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
SELECT ctid, tgrelid
9491021
FROM pg_catalog.pg_trigger fk
9501022
WHERE tgrelid != 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 @@ SELECT ctid, extnamespace
273273
FROM pg_catalog.pg_extension fk
274274
WHERE extnamespace != 0 AND
275275
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_namespace pk WHERE pk.oid = fk.extnamespace);
276+
SELECT ctid, fdwowner
277+
FROM pg_catalog.pg_foreign_data_wrapper fk
278+
WHERE fdwowner != 0 AND
279+
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_authid pk WHERE pk.oid = fk.fdwowner);
280+
SELECT ctid, srvowner
281+
FROM pg_catalog.pg_foreign_server fk
282+
WHERE srvowner != 0 AND
283+
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_authid pk WHERE pk.oid = fk.srvowner);
284+
SELECT ctid, srvfdw
285+
FROM pg_catalog.pg_foreign_server fk
286+
WHERE srvfdw != 0 AND
287+
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_foreign_data_wrapper pk WHERE pk.oid = fk.srvfdw);
276288
SELECT ctid, indexrelid
277289
FROM pg_catalog.pg_index fk
278290
WHERE indexrelid != 0 AND
@@ -305,6 +317,14 @@ SELECT ctid, lanvalidator
305317
FROM pg_catalog.pg_language fk
306318
WHERE lanvalidator != 0 AND
307319
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.lanvalidator);
320+
SELECT ctid, loid
321+
FROM pg_catalog.pg_largeobject fk
322+
WHERE loid != 0 AND
323+
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_largeobject_metadata pk WHERE pk.oid = fk.loid);
324+
SELECT ctid, lomowner
325+
FROM pg_catalog.pg_largeobject_metadata fk
326+
WHERE lomowner != 0 AND
327+
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_authid pk WHERE pk.oid = fk.lomowner);
308328
SELECT ctid, nspowner
309329
FROM pg_catalog.pg_namespace fk
310330
WHERE nspowner != 0 AND
@@ -473,6 +493,22 @@ SELECT ctid, spcowner
473493
FROM pg_catalog.pg_tablespace fk
474494
WHERE spcowner != 0 AND
475495
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_authid pk WHERE pk.oid = fk.spcowner);
496+
SELECT ctid, trftype
497+
FROM pg_catalog.pg_transform fk
498+
WHERE trftype != 0 AND
499+
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.trftype);
500+
SELECT ctid, trflang
501+
FROM pg_catalog.pg_transform fk
502+
WHERE trflang != 0 AND
503+
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_language pk WHERE pk.oid = fk.trflang);
504+
SELECT ctid, trffromsql
505+
FROM pg_catalog.pg_transform fk
506+
WHERE trffromsql != 0 AND
507+
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.trffromsql);
508+
SELECT ctid, trftosql
509+
FROM pg_catalog.pg_transform fk
510+
WHERE trftosql != 0 AND
511+
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.trftosql);
476512
SELECT ctid, tgrelid
477513
FROM pg_catalog.pg_trigger fk
478514
WHERE tgrelid != 0 AND

0 commit comments

Comments
 (0)