aboutsummaryrefslogtreecommitdiff
path: root/src/test/regress/sql/oidjoins.sql
diff options
context:
space:
mode:
Diffstat (limited to 'src/test/regress/sql/oidjoins.sql')
-rw-r--r--src/test/regress/sql/oidjoins.sql10
1 files changed, 9 insertions, 1 deletions
diff --git a/src/test/regress/sql/oidjoins.sql b/src/test/regress/sql/oidjoins.sql
index 7a072d4fd3d..2e5400f133b 100644
--- a/src/test/regress/sql/oidjoins.sql
+++ b/src/test/regress/sql/oidjoins.sql
@@ -1,5 +1,5 @@
--
--- This is created by pgsql/contrib/findoidjoins/make_oidjoin_check
+-- This is created by pgsql/src/tools/findoidjoins/make_oidjoins_check
--
SELECT ctid, aggfnoid
FROM pg_catalog.pg_aggregate fk
@@ -21,6 +21,10 @@ SELECT ctid, aggtranstype
FROM pg_catalog.pg_aggregate fk
WHERE aggtranstype != 0 AND
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.aggtranstype);
+SELECT ctid, amkeytype
+FROM pg_catalog.pg_am fk
+WHERE amkeytype != 0 AND
+ NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.amkeytype);
SELECT ctid, aminsert
FROM pg_catalog.pg_am fk
WHERE aminsert != 0 AND
@@ -461,6 +465,10 @@ SELECT ctid, typmodout
FROM pg_catalog.pg_type fk
WHERE typmodout != 0 AND
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.typmodout);
+SELECT ctid, typanalyze
+FROM pg_catalog.pg_type fk
+WHERE typanalyze != 0 AND
+ NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.typanalyze);
SELECT ctid, typbasetype
FROM pg_catalog.pg_type fk
WHERE typbasetype != 0 AND