diff -U3 /home/postgres/postgres/src/test/regress/expected/vacuum.out /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/vacuum.out --- /home/postgres/postgres/src/test/regress/expected/vacuum.out Tue Apr 28 17:21:11 2026 +++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/vacuum.out Tue Apr 28 17:24:10 2026 @@ -231,7 +231,7 @@ SELECT pg_relation_size('vac_truncate_test') > 0; ?column? ---------- - t + f (1 row) SET vacuum_truncate = false; @@ -251,7 +251,7 @@ SELECT pg_relation_size('vac_truncate_test') > 0; ?column? ---------- - t + f (1 row) RESET vacuum_truncate; @@ -259,7 +259,7 @@ SELECT pg_relation_size('vac_truncate_test') > 0; ?column? ---------- - t + f (1 row) VACUUM (DISABLE_PAGE_SKIPPING) vac_truncate_test; diff -U3 /home/postgres/postgres/src/test/regress/expected/updatable_views.out /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/updatable_views.out --- /home/postgres/postgres/src/test/regress/expected/updatable_views.out Tue Apr 28 17:21:11 2026 +++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/updatable_views.out Tue Apr 28 17:24:14 2026 @@ -2529,28 +2529,25 @@ INSERT INTO rw_view1 VALUES(3,4); -- ok INSERT INTO rw_view1 VALUES(4,3); -- should fail -ERROR: new row violates check option for view "rw_view1" -DETAIL: Failing row contains (4, 3). INSERT INTO rw_view1 VALUES(5,null); -- should fail -ERROR: new row violates check option for view "rw_view1" -DETAIL: Failing row contains (5, null). UPDATE rw_view1 SET b = 5 WHERE a = 3; -- ok UPDATE rw_view1 SET b = -5 WHERE a = 3; -- should fail ERROR: new row violates check option for view "rw_view1" DETAIL: Failing row contains (3, -5). INSERT INTO rw_view1(a) VALUES (9); -- ok INSERT INTO rw_view1(a) VALUES (10); -- should fail -ERROR: new row violates check option for view "rw_view1" -DETAIL: Failing row contains (10, 10). SELECT * FROM base_tbl ORDER BY a, b; - a | b ----+---- - 1 | -1 - 1 | 2 - 2 | 3 - 3 | 5 - 9 | 10 -(5 rows) + a | b +----+---- + 1 | -1 + 1 | 2 + 2 | 3 + 3 | 5 + 4 | 3 + 5 | + 9 | 10 + 10 | 10 +(8 rows) MERGE INTO rw_view1 t USING (VALUES (10)) AS v(a) ON t.a = v.a WHEN NOT MATCHED THEN INSERT VALUES (v.a, v.a + 1); -- ok @@ -2571,9 +2568,12 @@ 1 | -1 2 | 3 3 | 5 + 4 | 3 + 5 | 9 | 10 + 10 | 10 10 | 11 -(6 rows) +(9 rows) DROP TABLE base_tbl CASCADE; NOTICE: drop cascades to view rw_view1 @@ -2602,17 +2602,15 @@ (1 row) INSERT INTO rw_view2 VALUES (-5); -- should fail -ERROR: new row violates check option for view "rw_view1" -DETAIL: Failing row contains (-5). INSERT INTO rw_view2 VALUES (5); -- ok INSERT INTO rw_view2 VALUES (15); -- should fail -ERROR: new row violates check option for view "rw_view2" -DETAIL: Failing row contains (15). SELECT * FROM base_tbl; - a ---- - 5 -(1 row) + a +---- + -5 + 5 + 15 +(3 rows) UPDATE rw_view2 SET a = a - 10; -- should fail ERROR: new row violates check option for view "rw_view1" @@ -2643,25 +2641,22 @@ INSERT INTO rw_view2 VALUES (-10); -- ok, but not in view INSERT INTO rw_view2 VALUES (20); -- should fail -ERROR: new row violates check option for view "rw_view2" -DETAIL: Failing row contains (20). SELECT * FROM base_tbl; a ----- + -5 5 + 15 -10 -(2 rows) + 20 +(5 rows) ALTER VIEW rw_view1 SET (check_option=here); -- invalid ERROR: invalid value for enum option "check_option": here DETAIL: Valid values are "local" and "cascaded". ALTER VIEW rw_view1 SET (check_option=local); INSERT INTO rw_view2 VALUES (-20); -- should fail -ERROR: new row violates check option for view "rw_view1" -DETAIL: Failing row contains (-20). INSERT INTO rw_view2 VALUES (30); -- should fail -ERROR: new row violates check option for view "rw_view2" -DETAIL: Failing row contains (30). ALTER VIEW rw_view2 RESET (check_option); \d+ rw_view2 View "public.rw_view2" @@ -2685,10 +2680,15 @@ SELECT * FROM base_tbl; a ----- + -5 5 + 15 -10 + 20 + -20 30 -(3 rows) + 30 +(8 rows) DROP TABLE base_tbl CASCADE; NOTICE: drop cascades to 2 other objects @@ -2716,8 +2716,6 @@ INSERT INTO rw_view2 VALUES (-2); -- ok, but not in view INSERT INTO rw_view2 VALUES (2); -- ok INSERT INTO rw_view3 VALUES (-3); -- should fail -ERROR: new row violates check option for view "rw_view2" -DETAIL: Failing row contains (-3). INSERT INTO rw_view3 VALUES (3); -- ok DROP TABLE base_tbl CASCADE; NOTICE: drop cascades to 3 other objects @@ -2730,8 +2728,6 @@ WITH CHECK OPTION; INSERT INTO rw_view1 VALUES (1, ARRAY[1,2,3]); -- ok INSERT INTO rw_view1 VALUES (10, ARRAY[4,5]); -- should fail -ERROR: new row violates check option for view "rw_view1" -DETAIL: Failing row contains (10, {4,5}). UPDATE rw_view1 SET b[2] = -b[2] WHERE a = 1; -- ok UPDATE rw_view1 SET b[1] = -b[1] WHERE a = 1; -- should fail ERROR: new row violates check option for view "rw_view1" @@ -2739,8 +2735,6 @@ PREPARE ins(int, int[]) AS INSERT INTO rw_view1 VALUES($1, $2); EXECUTE ins(2, ARRAY[1,2,3]); -- ok EXECUTE ins(10, ARRAY[4,5]); -- should fail -ERROR: new row violates check option for view "rw_view1" -DETAIL: Failing row contains (10, {4,5}). DEALLOCATE PREPARE ins; DROP TABLE base_tbl CASCADE; NOTICE: drop cascades to view rw_view1 @@ -2754,8 +2748,6 @@ WITH CHECK OPTION; INSERT INTO rw_view1 VALUES (5); -- ok INSERT INTO rw_view1 VALUES (15); -- should fail -ERROR: new row violates check option for view "rw_view1" -DETAIL: Failing row contains (15). UPDATE rw_view1 SET a = a + 5; -- ok UPDATE rw_view1 SET a = a + 5; -- should fail ERROR: new row violates check option for view "rw_view1" @@ -3483,11 +3475,7 @@ WITH CHECK OPTION; INSERT INTO v2 VALUES (2, 'two', 20); -- ok INSERT INTO v2 VALUES (-2, 'minus two', 20); -- not allowed -ERROR: new row violates check option for view "v1" -DETAIL: Failing row contains (-2, minus two, 20). INSERT INTO v2 VALUES (3, 'three', 30); -- not allowed -ERROR: new row violates check option for view "v2" -DETAIL: Failing row contains (3, three, 30). UPDATE v2 SET b = 'ONE' WHERE a = 1; -- ok UPDATE v2 SET a = -1 WHERE a = 1; -- not allowed ERROR: new row violates check option for view "v1" @@ -3547,8 +3535,6 @@ CREATE OR REPLACE VIEW v1 AS SELECT * FROM t1 WHERE a > 0 WITH CHECK OPTION; INSERT INTO v1 VALUES (1, 'ok'); -- ok INSERT INTO v1 VALUES (-1, 'invalid'); -- should fail -ERROR: new row violates check option for view "v1" -DETAIL: Failing row contains (-1, invalid). DROP VIEW v1; DROP TABLE t1; -- check that an auto-updatable view on a partitioned table works correctly diff -U3 /home/postgres/postgres/src/test/regress/expected/reloptions.out /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/reloptions.out --- /home/postgres/postgres/src/test/regress/expected/reloptions.out Tue Apr 28 17:21:11 2026 +++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/reloptions.out Tue Apr 28 17:25:28 2026 @@ -136,7 +136,7 @@ SELECT pg_relation_size('reloptions_test') > 0; ?column? ---------- - t + f (1 row) SELECT reloptions FROM pg_class WHERE oid = diff -U3 /home/postgres/postgres/src/test/regress/expected/tuplesort.out /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/tuplesort.out --- /home/postgres/postgres/src/test/regress/expected/tuplesort.out Tue Apr 28 17:21:11 2026 +++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/tuplesort.out Tue Apr 28 17:25:32 2026 @@ -231,8 +231,8 @@ -------+--------------------------------------+--------------------------------------+--------------------------------------+-------------------------------------- 1 | 00000000-0000-0000-0000-000000000000 | 00000000-0000-0000-0000-000000020000 | 00000000-0000-0000-0000-000000000000 | 00009991-0000-0000-0000-000000020000 2 | 00000000-0000-0000-0000-000000000001 | 00000000-0000-0000-0000-000000019999 | 00000001-0000-0000-0000-000000000001 | 00009990-0000-0000-0000-000000019999 - 3 | 00000000-0000-0000-0000-000000000002 | 00000000-0000-0000-0000-000000019998 | 00000002-0000-0000-0000-000000000002 | 00009989-0000-0000-0000-000000019998 20004 | 00000000-0000-0000-0000-000000000002 | 00000000-0000-0000-0000-000000019998 | 00000002-0000-0000-0000-000000000002 | 00009989-0000-0000-0000-000000019998 + 3 | 00000000-0000-0000-0000-000000000002 | 00000000-0000-0000-0000-000000019998 | 00000002-0000-0000-0000-000000000002 | 00009989-0000-0000-0000-000000019998 4 | 00000000-0000-0000-0000-000000000003 | 00000000-0000-0000-0000-000000019997 | 00000003-0000-0000-0000-000000000003 | 00009988-0000-0000-0000-000000019997 (5 rows) @@ -242,11 +242,11 @@ ORDER BY ctid DESC LIMIT 5; id | abort_increasing | abort_decreasing | noabort_increasing | noabort_decreasing -------+--------------------------------------+--------------------------------------+--------------------------------------+-------------------------------------- - 0 | | | | - 20002 | | | | 20003 | | | | - 20001 | 00000000-0000-0000-0000-000000020000 | 00000000-0000-0000-0000-000000000000 | 00009991-0000-0000-0000-000000020000 | 00000000-0000-0000-0000-000000000000 + 20002 | | | | + 0 | | | | 20010 | 00000000-0000-0000-0000-000000020000 | 00000000-0000-0000-0000-000000000000 | 00009991-0000-0000-0000-000000020000 | 00000000-0000-0000-0000-000000000000 + 20001 | 00000000-0000-0000-0000-000000020000 | 00000000-0000-0000-0000-000000000000 | 00009991-0000-0000-0000-000000020000 | 00000000-0000-0000-0000-000000000000 (5 rows) ROLLBACK; @@ -274,8 +274,8 @@ id | abort_increasing | abort_decreasing | noabort_increasing | noabort_decreasing -------+--------------------------------------+--------------------------------------+--------------------------------------+-------------------------------------- 0 | | | | - 20002 | | | | 20003 | | | | + 20002 | | | | 1 | 00000000-0000-0000-0000-000000000000 | 00000000-0000-0000-0000-000000020000 | 00000000-0000-0000-0000-000000000000 | 00009991-0000-0000-0000-000000020000 2 | 00000000-0000-0000-0000-000000000001 | 00000000-0000-0000-0000-000000019999 | 00000001-0000-0000-0000-000000000001 | 00009990-0000-0000-0000-000000019999 (5 rows) diff -U3 /home/postgres/postgres/src/test/regress/expected/stats.out /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/stats.out --- /home/postgres/postgres/src/test/regress/expected/stats.out Tue Apr 28 17:21:11 2026 +++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/stats.out Tue Apr 28 17:25:31 2026 @@ -1988,7 +1988,7 @@ SELECT * FROM check_estimated_rows('SELECT * FROM table_fillfactor'); estimated | actual -----------+-------- - 1000 | 1000 + 1024 | 1000 (1 row) DROP TABLE table_fillfactor;