diff options
Diffstat (limited to 'src/test/regress/expected/oidjoins.out')
| -rw-r--r-- | src/test/regress/expected/oidjoins.out | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/src/test/regress/expected/oidjoins.out b/src/test/regress/expected/oidjoins.out index 21628b6e69..feb912b87f 100644 --- a/src/test/regress/expected/oidjoins.out +++ b/src/test/regress/expected/oidjoins.out @@ -233,6 +233,14 @@ WHERE relam != 0 AND ------+------- (0 rows) +SELECT ctid, reltablespace +FROM pg_catalog.pg_class fk +WHERE reltablespace != 0 AND + NOT EXISTS(SELECT 1 FROM pg_catalog.pg_tablespace pk WHERE pk.oid = fk.reltablespace); + ctid | reltablespace +------+--------------- +(0 rows) + SELECT ctid, reltoastrelid FROM pg_catalog.pg_class fk WHERE reltoastrelid != 0 AND @@ -281,6 +289,14 @@ WHERE conproc != 0 AND ------+--------- (0 rows) +SELECT ctid, dattablespace +FROM pg_catalog.pg_database fk +WHERE dattablespace != 0 AND + NOT EXISTS(SELECT 1 FROM pg_catalog.pg_tablespace pk WHERE pk.oid = fk.dattablespace); + ctid | dattablespace +------+--------------- +(0 rows) + SELECT ctid, classid FROM pg_catalog.pg_depend fk WHERE classid != 0 AND |