diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/matview.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/matview.out --- /tmp/cirrus-ci-build/src/test/regress/expected/matview.out 2025-10-18 23:27:17.647891955 +0000 +++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/matview.out 2025-10-18 23:34:48.127718599 +0000 @@ -141,6 +141,11 @@ CREATE SCHEMA mvtest_mvschema; ALTER MATERIALIZED VIEW mvtest_tvm SET SCHEMA mvtest_mvschema; \d+ mvtest_tvm + List of relations + Schema | Name | Type | Owner | Persistence | Size | Description +--------+------+------+-------+-------------+------+------------- +(0 rows) + \d+ mvtest_tvmm Materialized view "public.mvtest_tvmm" Column | Type | Collation | Nullable | Default | Storage | Stats target | Description diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/identity.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/identity.out --- /tmp/cirrus-ci-build/src/test/regress/expected/identity.out 2025-10-18 23:27:17.627744579 +0000 +++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/identity.out 2025-10-18 23:34:47.807713250 +0000 @@ -607,6 +607,11 @@ Sequence for identity column: public.itest8.f4 \d itest8_f5_seq + List of relations + Schema | Name | Type | Owner +--------+------+------+------- +(0 rows) + DROP TABLE itest8; -- typed tables (currently not supported) CREATE TYPE itest_type AS (f1 integer, f2 text, f3 bigint); diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/psql.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/psql.out --- /tmp/cirrus-ci-build/src/test/regress/expected/psql.out 2025-10-18 23:27:17.672068808 +0000 +++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/psql.out 2025-10-18 23:35:28.075644385 +0000 @@ -5176,7 +5176,6 @@ ------+------ (0 rows) -\dA: extra argument "bar" ignored \dA+ List of access methods Name | Type | Handler | Description diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/dependency.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/dependency.out --- /tmp/cirrus-ci-build/src/test/regress/expected/dependency.out 2025-10-18 23:27:17.615656153 +0000 +++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/dependency.out 2025-10-18 23:35:52.987227875 +0000 @@ -86,6 +86,11 @@ -- table was dropped \d deptest + List of relations + Schema | Name | Type | Owner +--------+------+------+------- +(0 rows) + -- Test REASSIGN OWNED GRANT ALL ON deptest1 TO regress_dep_user1; GRANT CREATE ON DATABASE regression TO regress_dep_user1; diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/alter_table.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/alter_table.out --- /tmp/cirrus-ci-build/src/test/regress/expected/alter_table.out 2025-10-18 23:27:17.595508776 +0000 +++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/alter_table.out 2025-10-18 23:36:13.242987996 +0000 @@ -3877,6 +3877,11 @@ DROP TABLE test_add_column; \d test_add_column* + List of relations + Schema | Name | Type | Owner +--------+------+------+------- +(0 rows) + -- assorted cases with multiple ALTER TABLE steps CREATE TABLE ataddindex(f1 INT); INSERT INTO ataddindex VALUES (42), (43); diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/compression_lz4.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/compression_lz4.out --- /tmp/cirrus-ci-build/src/test/regress/expected/compression_lz4.out 2025-10-18 23:27:17.603567726 +0000 +++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/compression_lz4.out 2025-10-18 23:36:15.582965321 +0000 @@ -16,9 +16,19 @@ CREATE INDEX idx ON cmdata_pglz(f1); INSERT INTO cmdata_pglz VALUES(repeat('1234567890', 1000)); \d+ cmdata + List of relations + Schema | Name | Type | Owner | Persistence | Size | Description +--------+------+------+-------+-------------+------+------------- +(0 rows) + CREATE TABLE cmdata_lz4(f1 TEXT COMPRESSION lz4); INSERT INTO cmdata_lz4 VALUES(repeat('1234567890', 1004)); \d+ cmdata1 + List of relations + Schema | Name | Type | Owner | Persistence | Size | Description +--------+------+------+-------+-------------+------+------------- +(0 rows) + -- verify stored compression method in the data SELECT pg_column_compression(f1) FROM cmdata_lz4; pg_column_compression @@ -169,6 +179,11 @@ ALTER TABLE cmdata_pglz ALTER COLUMN f1 SET COMPRESSION lz4; INSERT INTO cmdata_pglz VALUES (repeat('123456789', 4004)); \d+ cmdata + List of relations + Schema | Name | Type | Owner | Persistence | Size | Description +--------+------+------+-------+-------------+------+------------- +(0 rows) + SELECT pg_column_compression(f1) FROM cmdata_pglz; pg_column_compression -----------------------