diff options
Diffstat (limited to 'src/test/regress/sql/oidjoins.sql')
| -rw-r--r-- | src/test/regress/sql/oidjoins.sql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/src/test/regress/sql/oidjoins.sql b/src/test/regress/sql/oidjoins.sql index 5e8323bc11..d822aaf4e5 100644 --- a/src/test/regress/sql/oidjoins.sql +++ b/src/test/regress/sql/oidjoins.sql @@ -65,6 +65,10 @@ SELECT ctid, amopclaid FROM pg_catalog.pg_amop fk WHERE amopclaid != 0 AND NOT EXISTS(SELECT 1 FROM pg_catalog.pg_opclass pk WHERE pk.oid = fk.amopclaid); +SELECT ctid, amopsubtype +FROM pg_catalog.pg_amop fk +WHERE amopsubtype != 0 AND + NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.amopsubtype); SELECT ctid, amopopr FROM pg_catalog.pg_amop fk WHERE amopopr != 0 AND @@ -73,6 +77,10 @@ SELECT ctid, amopclaid FROM pg_catalog.pg_amproc fk WHERE amopclaid != 0 AND NOT EXISTS(SELECT 1 FROM pg_catalog.pg_opclass pk WHERE pk.oid = fk.amopclaid); +SELECT ctid, amprocsubtype +FROM pg_catalog.pg_amproc fk +WHERE amprocsubtype != 0 AND + NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.amprocsubtype); SELECT ctid, amproc FROM pg_catalog.pg_amproc fk WHERE amproc != 0 AND |