diff options
Diffstat (limited to 'src/test')
| -rw-r--r-- | src/test/regress/expected/alter_table.out | 24 | ||||
| -rw-r--r-- | src/test/regress/expected/fast_default.out | 4 | ||||
| -rw-r--r-- | src/test/regress/expected/oidjoins.out | 2 | ||||
| -rw-r--r-- | src/test/regress/sql/alter_table.sql | 8 | ||||
| -rw-r--r-- | src/test/regress/sql/fast_default.sql | 4 |
5 files changed, 23 insertions, 19 deletions
diff --git a/src/test/regress/expected/alter_table.out b/src/test/regress/expected/alter_table.out index 86666b83ae5..346f594ad02 100644 --- a/src/test/regress/expected/alter_table.out +++ b/src/test/regress/expected/alter_table.out @@ -2164,8 +2164,9 @@ select relname, c.oid = oldoid as orig_oid, case relfilenode when 0 then 'none' + when c.oid then 'own' when oldfilenode then 'orig' - else 'new' + else 'OTHER' end as storage, obj_description(c.oid, 'pg_class') as desc from pg_class c left join old_oids using (relname) @@ -2174,10 +2175,10 @@ select relname, relname | orig_oid | storage | desc ------------------------------+----------+---------+--------------- at_partitioned | t | none | - at_partitioned_0 | t | orig | - at_partitioned_0_id_name_key | t | orig | child 0 index - at_partitioned_1 | t | orig | - at_partitioned_1_id_name_key | t | orig | child 1 index + at_partitioned_0 | t | own | + at_partitioned_0_id_name_key | t | own | child 0 index + at_partitioned_1 | t | own | + at_partitioned_1_id_name_key | t | own | child 1 index at_partitioned_id_name_key | t | none | parent index (6 rows) @@ -2197,8 +2198,9 @@ select relname, c.oid = oldoid as orig_oid, case relfilenode when 0 then 'none' + when c.oid then 'own' when oldfilenode then 'orig' - else 'new' + else 'OTHER' end as storage, obj_description(c.oid, 'pg_class') as desc from pg_class c left join old_oids using (relname) @@ -2207,10 +2209,10 @@ select relname, relname | orig_oid | storage | desc ------------------------------+----------+---------+-------------- at_partitioned | t | none | - at_partitioned_0 | t | orig | - at_partitioned_0_id_name_key | f | new | parent index - at_partitioned_1 | t | orig | - at_partitioned_1_id_name_key | f | new | parent index + at_partitioned_0 | t | own | + at_partitioned_0_id_name_key | f | own | parent index + at_partitioned_1 | t | own | + at_partitioned_1_id_name_key | f | own | parent index at_partitioned_id_name_key | f | none | parent index (6 rows) @@ -2558,7 +2560,7 @@ CREATE FUNCTION check_ddl_rewrite(p_tablename regclass, p_ddl text) RETURNS boolean LANGUAGE plpgsql AS $$ DECLARE - v_relfilenode int8; + v_relfilenode oid; BEGIN v_relfilenode := relfilenode FROM pg_class WHERE oid = p_tablename; diff --git a/src/test/regress/expected/fast_default.out b/src/test/regress/expected/fast_default.out index 0a35f333f63..91f25717b5a 100644 --- a/src/test/regress/expected/fast_default.out +++ b/src/test/regress/expected/fast_default.out @@ -3,8 +3,8 @@ -- SET search_path = fast_default; CREATE SCHEMA fast_default; -CREATE TABLE m(id BIGINT); -INSERT INTO m VALUES (NULL::BIGINT); +CREATE TABLE m(id OID); +INSERT INTO m VALUES (NULL::OID); CREATE FUNCTION set(tabname name) RETURNS VOID AS $$ BEGIN diff --git a/src/test/regress/expected/oidjoins.out b/src/test/regress/expected/oidjoins.out index af57470f93e..215eb899be3 100644 --- a/src/test/regress/expected/oidjoins.out +++ b/src/test/regress/expected/oidjoins.out @@ -74,11 +74,11 @@ NOTICE: checking pg_type {typcollation} => pg_collation {oid} NOTICE: checking pg_attribute {attrelid} => pg_class {oid} NOTICE: checking pg_attribute {atttypid} => pg_type {oid} NOTICE: checking pg_attribute {attcollation} => pg_collation {oid} -NOTICE: checking pg_class {relam} => pg_am {oid} NOTICE: checking pg_class {relnamespace} => pg_namespace {oid} NOTICE: checking pg_class {reltype} => pg_type {oid} NOTICE: checking pg_class {reloftype} => pg_type {oid} NOTICE: checking pg_class {relowner} => pg_authid {oid} +NOTICE: checking pg_class {relam} => pg_am {oid} NOTICE: checking pg_class {reltablespace} => pg_tablespace {oid} NOTICE: checking pg_class {reltoastrelid} => pg_class {oid} NOTICE: checking pg_class {relrewrite} => pg_class {oid} diff --git a/src/test/regress/sql/alter_table.sql b/src/test/regress/sql/alter_table.sql index a67eb5f982a..9f773aeeb94 100644 --- a/src/test/regress/sql/alter_table.sql +++ b/src/test/regress/sql/alter_table.sql @@ -1478,8 +1478,9 @@ select relname, c.oid = oldoid as orig_oid, case relfilenode when 0 then 'none' + when c.oid then 'own' when oldfilenode then 'orig' - else 'new' + else 'OTHER' end as storage, obj_description(c.oid, 'pg_class') as desc from pg_class c left join old_oids using (relname) @@ -1498,8 +1499,9 @@ select relname, c.oid = oldoid as orig_oid, case relfilenode when 0 then 'none' + when c.oid then 'own' when oldfilenode then 'orig' - else 'new' + else 'OTHER' end as storage, obj_description(c.oid, 'pg_class') as desc from pg_class c left join old_oids using (relname) @@ -1639,7 +1641,7 @@ CREATE FUNCTION check_ddl_rewrite(p_tablename regclass, p_ddl text) RETURNS boolean LANGUAGE plpgsql AS $$ DECLARE - v_relfilenode int8; + v_relfilenode oid; BEGIN v_relfilenode := relfilenode FROM pg_class WHERE oid = p_tablename; diff --git a/src/test/regress/sql/fast_default.sql b/src/test/regress/sql/fast_default.sql index 819ec40fdaf..16a3b7ca51d 100644 --- a/src/test/regress/sql/fast_default.sql +++ b/src/test/regress/sql/fast_default.sql @@ -4,8 +4,8 @@ SET search_path = fast_default; CREATE SCHEMA fast_default; -CREATE TABLE m(id BIGINT); -INSERT INTO m VALUES (NULL::BIGINT); +CREATE TABLE m(id OID); +INSERT INTO m VALUES (NULL::OID); CREATE FUNCTION set(tabname name) RETURNS VOID AS $$ |