diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2004-08-04 20:33:49 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2004-08-04 20:33:49 +0000 |
| commit | e84c71b4e6b0744fd66c3f5b0ead8c6020c610e4 (patch) | |
| tree | cd46a95da7061d03510c99f7b122e05706577e92 /src | |
| parent | bb892cecf96b68186286435d4e2026e9229b8224 (diff) | |
| download | postgresql-e84c71b4e6b0744fd66c3f5b0ead8c6020c610e4.tar.gz postgresql-e84c71b4e6b0744fd66c3f5b0ead8c6020c610e4.zip | |
Update oidjoins regression test to match current catalog structure.
Diffstat (limited to 'src')
| -rw-r--r-- | src/test/regress/expected/oidjoins.out | 16 | ||||
| -rw-r--r-- | src/test/regress/sql/oidjoins.sql | 8 |
2 files changed, 24 insertions, 0 deletions
diff --git a/src/test/regress/expected/oidjoins.out b/src/test/regress/expected/oidjoins.out index 21628b6e69b..feb912b87fe 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 diff --git a/src/test/regress/sql/oidjoins.sql b/src/test/regress/sql/oidjoins.sql index d822aaf4e55..9df84436bf1 100644 --- a/src/test/regress/sql/oidjoins.sql +++ b/src/test/regress/sql/oidjoins.sql @@ -117,6 +117,10 @@ SELECT ctid, relam FROM pg_catalog.pg_class fk WHERE relam != 0 AND NOT EXISTS(SELECT 1 FROM pg_catalog.pg_am pk WHERE pk.oid = fk.relam); +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); SELECT ctid, reltoastrelid FROM pg_catalog.pg_class fk WHERE reltoastrelid != 0 AND @@ -141,6 +145,10 @@ SELECT ctid, conproc FROM pg_catalog.pg_conversion fk WHERE conproc != 0 AND NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.conproc); +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); SELECT ctid, classid FROM pg_catalog.pg_depend fk WHERE classid != 0 AND |