diff -U3 /tmp/cirrus-ci-build/contrib/pg_visibility/expected/pg_visibility.out /tmp/cirrus-ci-build/build/testrun/pg_visibility/regress/results/pg_visibility.out --- /tmp/cirrus-ci-build/contrib/pg_visibility/expected/pg_visibility.out 2024-03-27 22:35:12.787946000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/pg_visibility/regress/results/pg_visibility.out 2024-03-27 22:53:24.691835000 +0000 @@ -8,6 +8,7 @@ SELECT 'droppedtest'::regclass::oid AS oid \gset SAVEPOINT q; DROP TABLE droppedtest; RELEASE q; SAVEPOINT q; SELECT * FROM pg_visibility_map(:oid); ROLLBACK TO q; +WARNING: 01000 ERROR: XX000 -- ERROR: could not open relation with OID 16xxx SAVEPOINT q; SELECT 1; ROLLBACK TO q; @@ -30,6 +31,7 @@ (1 row) SELECT * FROM pg_visibility_map(:oid); +WARNING: 01000 ERROR: XX000 -- ERROR: could not open relation with OID 16xxx ROLLBACK; @@ -130,14 +132,17 @@ create table regular_table (a int, b text); alter table regular_table alter column b set storage external; insert into regular_table values (1, repeat('one', 1000)), (2, repeat('two', 1000)); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree vacuum (disable_page_skipping) regular_table; select count(*) > 0 from pg_visibility('regular_table'); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree ?column? ---------- t (1 row) select count(*) > 0 from pg_visibility((select reltoastrelid from pg_class where relname = 'regular_table')); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree ?column? ---------- t @@ -145,12 +150,14 @@ truncate regular_table; select count(*) > 0 from pg_visibility('regular_table'); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree ?column? ---------- f (1 row) select count(*) > 0 from pg_visibility((select reltoastrelid from pg_class where relname = 'regular_table')); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree ?column? ---------- f @@ -159,14 +166,17 @@ create materialized view matview_visibility_test as select * from regular_table; vacuum (disable_page_skipping) matview_visibility_test; select count(*) > 0 from pg_visibility('matview_visibility_test'); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree ?column? ---------- f (1 row) insert into regular_table values (1), (2); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree refresh materialized view matview_visibility_test; select count(*) > 0 from pg_visibility('matview_visibility_test'); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree ?column? ---------- t @@ -176,24 +186,28 @@ insert into test_partition values (1); vacuum (disable_page_skipping) test_partition; select count(*) > 0 from pg_visibility('test_partition', 0); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree ?column? ---------- t (1 row) select count(*) > 0 from pg_visibility_map('test_partition'); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree ?column? ---------- t (1 row) select count(*) > 0 from pg_visibility_map_summary('test_partition'); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree ?column? ---------- t (1 row) select * from pg_check_frozen('test_partition'); -- hopefully none +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree t_ctid -------- (0 rows) @@ -213,6 +227,7 @@ copy copyfreeze from stdin freeze; commit; select * from pg_visibility_map('copyfreeze'); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree blkno | all_visible | all_frozen -------+-------------+------------ 0 | t | t @@ -220,6 +235,7 @@ (2 rows) select * from pg_check_frozen('copyfreeze'); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree t_ctid -------- (0 rows) @@ -234,6 +250,7 @@ copy copyfreeze from stdin freeze; commit; select * from pg_visibility_map('copyfreeze'); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree blkno | all_visible | all_frozen -------+-------------+------------ 0 | f | f @@ -242,6 +259,7 @@ (3 rows) select * from pg_check_frozen('copyfreeze'); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree t_ctid -------- (0 rows) @@ -254,6 +272,7 @@ copy copyfreeze from stdin freeze; commit; select * from pg_visibility_map('copyfreeze'); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree blkno | all_visible | all_frozen -------+-------------+------------ 0 | t | t @@ -262,6 +281,7 @@ (3 rows) select * from pg_check_frozen('copyfreeze'); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree t_ctid -------- (0 rows)