PostgreSQL Patch Tester

Current commitfest | Next commitfest | FAQ | Statistics | Highlights

Highlight type: all assertion compiler core linker panic regress sanitizer tap test

Time range: current 7-day 30-day 90-day

This robot generates gigabytes of CI logs every week. Here is an attempt to search for "highlights", so it's easier to find actionable information quickly. New ideas for what patterns to search for are very welcome. "Current" shows only the most recent results from each submission. The wider time ranges also show information about historical versions, which may be useful for flapping tests, and also for hunting for bugs in master.

57/5975	When deleting the plpgsql function, release the CachedPlan of the function
	FreeBSD - Meson
regress	diff -U3 /tmp/cirrus-ci-build/src/test/isolation/expected/insert-conflict-specconflict.out /tmp/cirrus-ci-build/build/te... --- /tmp/cirrus-ci-build/src/test/isolation/expected/insert-conflict-specconflict.out 2025-12-29 18:45:18.066535000 +000... +++ /tmp/cirrus-ci-build/build/testrun/isolation-running/isolation/results/insert-conflict-specconflict.out 2025-12-29 1... @@ -230,324 +230,7 @@ t (1 row) -s1: NOTICE: blurt_and_lock_123() called for k2 in session 1 -s1: NOTICE: acquiring advisory lock on 2 -step controller_unlock_2_3: SELECT pg_advisory_unlock(2, 3); -pg_advisory_unlock ------------------- -t -(1 row) - -s2: NOTICE: blurt_and_lock_123() called for k2 in session 2 -s2: NOTICE: acquiring advisory lock on 2 -step controller_show: SELECT * FROM upserttest; -key\|data ----+---- ...
regress	diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/fast_default.out /tmp/cirrus-ci-build/build/testrun/regress-runn... --- /tmp/cirrus-ci-build/src/test/regress/expected/fast_default.out 2025-12-29 18:45:18.193303000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/regress-running/regress/results/fast_default.out 2025-12-29 18:53:01.289538000 +0... @@ -1,938 +1,2 @@ --- --- ALTER TABLE ADD COLUMN DEFAULT test --- -SET search_path = fast_default; -CREATE SCHEMA fast_default; -CREATE TABLE m(id OID); -INSERT INTO m VALUES (NULL::OID); -CREATE FUNCTION set(tabname name) RETURNS VOID -AS $$ -BEGIN - UPDATE m - SET id = (SELECT c.relfilenode - FROM pg_class AS c, pg_namespace AS s - WHERE c.relname = tabname - AND c.relnamespace = s.oid - AND s.nspname = 'fast_default'); ...
	NetBSD - Meson
regress	diff -U3 /home/postgres/postgres/src/test/regress/expected/foreign_key.out /home/postgres/postgres/build/testrun/pg_upgr... --- /home/postgres/postgres/src/test/regress/expected/foreign_key.out 2025-12-29 18:45:44.986506850 +0000 +++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/foreign_key.out 2025-12-29 18:47:45.260... @@ -971,2489 +971,10 @@ -- This shouldn't (mixed up columns) CREATE TABLE PKTABLE (ptest1 int, ptest2 inet, ptest3 int, ptest4 inet, PRIMARY KEY(ptest1, ptest2), FOREIGN KEY(ptest3... ptest4) REFERENCES pktable(ptest2, ptest1)); -ERROR: foreign key constraint "pktable_ptest3_ptest4_fkey" cannot be implemented -DETAIL: Key columns "ptest3" of the referencing table and "ptest2" of the referenced table are of incompatible types: ... --- Nor should this... (same reason, we have 4,3 referencing 1,2 which mismatches types -CREATE TABLE PKTABLE (ptest1 int, ptest2 inet, ptest3 int, ptest4 inet, PRIMARY KEY(ptest1, ptest2), FOREIGN KEY(ptest4... -ptest3) REFERENCES pktable(ptest1, ptest2)); -ERROR: foreign key constraint "pktable_ptest4_ptest3_fkey" cannot be implemented -DETAIL: Key columns "ptest4" of the referencing table and "ptest1" of the referenced table are of incompatible types: ... --- Not this one either... Same as the last one except we didn't defined the columns being referenced. -CREATE TABLE PKTABLE (ptest1 int, ptest2 inet, ptest3 int, ptest4 inet, PRIMARY KEY(ptest1, ptest2), FOREIGN KEY(ptest4... -ptest3) REFERENCES pktable); -ERROR: foreign key constraint "pktable_ptest4_ptest3_fkey" cannot be implemented -DETAIL: Key columns "ptest4" of the referencing table and "ptest1" of the referenced table are of incompatible types: ... --- ...
57/6031	UPDATE with invalid domain constraint
	FreeBSD - Meson
regress	diff -U3 /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out /tmp/cirrus-ci-build/build/testrun/postgres... --- /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out 2025-12-29 16:28:00.891846000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/postgres_fdw-running/regress/results/postgres_fdw.out 2025-12-29 16:36:20.4301250... @@ -12696,8 +12696,7 @@ FROM postgres_fdw_get_connections(true); server_name \| closed \| remote_backend_pid -------------+--------+-------------------- - loopback \| f \| t -(1 row) +(0 rows) -- After terminating the remote backend, since the connection is closed, -- "closed" should be TRUE, or NULL if the connection status check @@ -12713,8 +12712,7 @@ FROM postgres_fdw_get_connections(true); server_name \| closed \| remote_backend_pid -------------+--------+-------------------- - loopback \| t \| t -(1 row) +(0 rows) ...
57/6128	GIN pageinspect support for entry tree and non-leaf posting tree
	Linux - Debian Trixie - Meson
regress	diff -U3 /tmp/cirrus-ci-build/src/test/modules/brin/expected/summarization-and-inprogress-insertion.out /tmp/cirrus-ci-b... --- /tmp/cirrus-ci-build/src/test/modules/brin/expected/summarization-and-inprogress-insertion.out 2025-12-29 13:13:25.1... +++ /tmp/cirrus-ci-build/build/testrun/brin/isolation/results/summarization-and-inprogress-insertion.out 2025-12-29 13:1... @@ -1,51 +1,4 @@ Parsed test spec with 2 sessions starting permutation: s2check s1b s2b s1i s2summ s1c s2c s2check -step s2check: SELECT * FROM brin_page_items(get_raw_page('brinidx', 2), 'brinidx'::regclass); -itemoffset\|blknum\|attnum\|allnulls\|hasnulls\|placeholder\|empty\|value -----------+------+------+--------+--------+-----------+-----+-------- - 1\| 0\| 1\|f \|t \|f \|f \|{1 .. 1} -(1 row) - -step s1b: BEGIN ISOLATION LEVEL REPEATABLE READ; -step s2b: BEGIN ISOLATION LEVEL REPEATABLE READ; SELECT 1; -?column? --------- - 1 -(1 row) - ...
regress	diff -U3 /tmp/cirrus-ci-build/contrib/pageinspect/expected/page.out /tmp/cirrus-ci-build/build/testrun/pageinspect/regre... --- /tmp/cirrus-ci-build/contrib/pageinspect/expected/page.out 2025-12-29 13:13:23.486909589 +0000 +++ /tmp/cirrus-ci-build/build/testrun/pageinspect/regress/results/page.out 2025-12-29 13:17:08.088000180 +0000 @@ -1,4 +1,5 @@ CREATE EXTENSION pageinspect; +ERROR: extension "pageinspect" has no installation script nor update path for version "1.14" -- Use a temp table so that effects of VACUUM are predictable CREATE TEMP TABLE test1 (a int, b int); INSERT INTO test1 VALUES (16777217, 131584); @@ -6,207 +7,177 @@ -- The page contents can vary, so just test that it can be read -- successfully, but don't keep the output. SELECT octet_length(get_raw_page('test1', 'main', 0)) AS main_0; - main_0 --------- - 8192 -(1 row) - +ERROR: function get_raw_page(unknown, unknown, integer) does not exist +LINE 1: SELECT octet_length(get_raw_page('test1', 'main', 0)) AS mai... ...
	macOS - Sequoia - Meson
regress	diff -U3 /Users/admin/pgsql/src/test/modules/brin/expected/summarization-and-inprogress-insertion.out /Users/admin/pgsql... --- /Users/admin/pgsql/src/test/modules/brin/expected/summarization-and-inprogress-insertion.out 2025-12-29 13:13:11 +++ /Users/admin/pgsql/build/testrun/brin/isolation/results/summarization-and-inprogress-insertion.out 2025-12-29 13:16:... @@ -1,51 +1,4 @@ Parsed test spec with 2 sessions starting permutation: s2check s1b s2b s1i s2summ s1c s2c s2check -step s2check: SELECT * FROM brin_page_items(get_raw_page('brinidx', 2), 'brinidx'::regclass); -itemoffset\|blknum\|attnum\|allnulls\|hasnulls\|placeholder\|empty\|value -----------+------+------+--------+--------+-----------+-----+-------- - 1\| 0\| 1\|f \|t \|f \|f \|{1 .. 1} -(1 row) - -step s1b: BEGIN ISOLATION LEVEL REPEATABLE READ; -step s2b: BEGIN ISOLATION LEVEL REPEATABLE READ; SELECT 1; -?column? --------- - 1 -(1 row) - ...
regress	diff -U3 /Users/admin/pgsql/contrib/pageinspect/expected/page.out /Users/admin/pgsql/build/testrun/pageinspect/regress/r... --- /Users/admin/pgsql/contrib/pageinspect/expected/page.out 2025-12-29 13:13:10 +++ /Users/admin/pgsql/build/testrun/pageinspect/regress/results/page.out 2025-12-29 13:16:24 @@ -1,4 +1,5 @@ CREATE EXTENSION pageinspect; +ERROR: extension "pageinspect" has no installation script nor update path for version "1.14" -- Use a temp table so that effects of VACUUM are predictable CREATE TEMP TABLE test1 (a int, b int); INSERT INTO test1 VALUES (16777217, 131584); @@ -6,207 +7,177 @@ -- The page contents can vary, so just test that it can be read -- successfully, but don't keep the output. SELECT octet_length(get_raw_page('test1', 'main', 0)) AS main_0; - main_0 --------- - 8192 -(1 row) - +ERROR: function get_raw_page(unknown, unknown, integer) does not exist +LINE 1: SELECT octet_length(get_raw_page('test1', 'main', 0)) AS mai... ...
	Windows - Server 2022, VS 2019 - Meson & ninja
regress	diff --strip-trailing-cr -U3 C:/cirrus/src/test/modules/brin/expected/summarization-and-inprogress-insertion.out C:/cirr... --- C:/cirrus/src/test/modules/brin/expected/summarization-and-inprogress-insertion.out 2025-12-29 13:13:28.096647900 +0... +++ C:/cirrus/build/testrun/brin/isolation/results/summarization-and-inprogress-insertion.out 2025-12-29 13:22:00.626496... @@ -1,51 +1,4 @@ Parsed test spec with 2 sessions starting permutation: s2check s1b s2b s1i s2summ s1c s2c s2check -step s2check: SELECT * FROM brin_page_items(get_raw_page('brinidx', 2), 'brinidx'::regclass); -itemoffset\|blknum\|attnum\|allnulls\|hasnulls\|placeholder\|empty\|value -----------+------+------+--------+--------+-----------+-----+-------- - 1\| 0\| 1\|f \|t \|f \|f \|{1 .. 1} -(1 row) - -step s1b: BEGIN ISOLATION LEVEL REPEATABLE READ; -step s2b: BEGIN ISOLATION LEVEL REPEATABLE READ; SELECT 1; -?column? --------- - 1 -(1 row) - ...
regress	diff --strip-trailing-cr -U3 C:/cirrus/contrib/pageinspect/expected/page.out C:/cirrus/build/testrun/pageinspect/regress... --- C:/cirrus/contrib/pageinspect/expected/page.out 2025-12-29 13:13:23.709018200 +0000 +++ C:/cirrus/build/testrun/pageinspect/regress/results/page.out 2025-12-29 13:21:40.380911700 +0000 @@ -1,4 +1,5 @@ CREATE EXTENSION pageinspect; +ERROR: extension "pageinspect" has no installation script nor update path for version "1.14" -- Use a temp table so that effects of VACUUM are predictable CREATE TEMP TABLE test1 (a int, b int); INSERT INTO test1 VALUES (16777217, 131584); @@ -6,207 +7,177 @@ -- The page contents can vary, so just test that it can be read -- successfully, but don't keep the output. SELECT octet_length(get_raw_page('test1', 'main', 0)) AS main_0; - main_0 --------- - 8192 -(1 row) - +ERROR: function get_raw_page(unknown, unknown, integer) does not exist +LINE 1: SELECT octet_length(get_raw_page('test1', 'main', 0)) AS mai... ...
	Windows - Server 2022, MinGW64 - Meson
regress	diff --strip-trailing-cr -U3 C:/cirrus/src/test/modules/brin/expected/summarization-and-inprogress-insertion.out C:/cirr... --- C:/cirrus/src/test/modules/brin/expected/summarization-and-inprogress-insertion.out 2025-12-29 13:13:20.016656600 +0... +++ C:/cirrus/build/testrun/brin/isolation/results/summarization-and-inprogress-insertion.out 2025-12-29 13:22:39.180564... @@ -1,51 +1,4 @@ Parsed test spec with 2 sessions starting permutation: s2check s1b s2b s1i s2summ s1c s2c s2check -step s2check: SELECT * FROM brin_page_items(get_raw_page('brinidx', 2), 'brinidx'::regclass); -itemoffset\|blknum\|attnum\|allnulls\|hasnulls\|placeholder\|empty\|value -----------+------+------+--------+--------+-----------+-----+-------- - 1\| 0\| 1\|f \|t \|f \|f \|{1 .. 1} -(1 row) - -step s1b: BEGIN ISOLATION LEVEL REPEATABLE READ; -step s2b: BEGIN ISOLATION LEVEL REPEATABLE READ; SELECT 1; -?column? --------- - 1 -(1 row) - ...
regress	diff --strip-trailing-cr -U3 C:/cirrus/contrib/pageinspect/expected/page.out C:/cirrus/build/testrun/pageinspect/regress... --- C:/cirrus/contrib/pageinspect/expected/page.out 2025-12-29 13:13:15.464869700 +0000 +++ C:/cirrus/build/testrun/pageinspect/regress/results/page.out 2025-12-29 13:22:15.613677900 +0000 @@ -1,4 +1,5 @@ CREATE EXTENSION pageinspect; +ERROR: extension "pageinspect" has no installation script nor update path for version "1.14" -- Use a temp table so that effects of VACUUM are predictable CREATE TEMP TABLE test1 (a int, b int); INSERT INTO test1 VALUES (16777217, 131584); @@ -6,207 +7,177 @@ -- The page contents can vary, so just test that it can be read -- successfully, but don't keep the output. SELECT octet_length(get_raw_page('test1', 'main', 0)) AS main_0; - main_0 --------- - 8192 -(1 row) - +ERROR: function get_raw_page(unknown, unknown, integer) does not exist +LINE 1: SELECT octet_length(get_raw_page('test1', 'main', 0)) AS mai... ...
	OpenBSD - Meson
regress	diff -U3 /home/postgres/postgres/src/test/modules/brin/expected/summarization-and-inprogress-insertion.out /home/postgre... --- /home/postgres/postgres/src/test/modules/brin/expected/summarization-and-inprogress-insertion.out Mon Dec 29 13:13:3... +++ /home/postgres/postgres/build/testrun/brin/isolation/results/summarization-and-inprogress-insertion.out Mon Dec 29 1... @@ -1,51 +1,4 @@ Parsed test spec with 2 sessions starting permutation: s2check s1b s2b s1i s2summ s1c s2c s2check -step s2check: SELECT * FROM brin_page_items(get_raw_page('brinidx', 2), 'brinidx'::regclass); -itemoffset\|blknum\|attnum\|allnulls\|hasnulls\|placeholder\|empty\|value -----------+------+------+--------+--------+-----------+-----+-------- - 1\| 0\| 1\|f \|t \|f \|f \|{1 .. 1} -(1 row) - -step s1b: BEGIN ISOLATION LEVEL REPEATABLE READ; -step s2b: BEGIN ISOLATION LEVEL REPEATABLE READ; SELECT 1; -?column? --------- - 1 -(1 row) - ...
regress	diff -U3 /home/postgres/postgres/contrib/pageinspect/expected/page.out /home/postgres/postgres/build/testrun/pageinspect... --- /home/postgres/postgres/contrib/pageinspect/expected/page.out Mon Dec 29 13:13:28 2025 +++ /home/postgres/postgres/build/testrun/pageinspect/regress/results/page.out Mon Dec 29 13:18:08 2025 @@ -1,4 +1,5 @@ CREATE EXTENSION pageinspect; +ERROR: extension "pageinspect" has no installation script nor update path for version "1.14" -- Use a temp table so that effects of VACUUM are predictable CREATE TEMP TABLE test1 (a int, b int); INSERT INTO test1 VALUES (16777217, 131584); @@ -6,207 +7,177 @@ -- The page contents can vary, so just test that it can be read -- successfully, but don't keep the output. SELECT octet_length(get_raw_page('test1', 'main', 0)) AS main_0; - main_0 --------- - 8192 -(1 row) - +ERROR: function get_raw_page(unknown, unknown, integer) does not exist +LINE 1: SELECT octet_length(get_raw_page('test1', 'main', 0)) AS mai... ...
	NetBSD - Meson
regress	diff -U3 /home/postgres/postgres/src/test/modules/brin/expected/summarization-and-inprogress-insertion.out /home/postgre... --- /home/postgres/postgres/src/test/modules/brin/expected/summarization-and-inprogress-insertion.out 2025-12-29 13:13:3... +++ /home/postgres/postgres/build/testrun/brin/isolation/results/summarization-and-inprogress-insertion.out 2025-12-29 1... @@ -1,51 +1,4 @@ Parsed test spec with 2 sessions starting permutation: s2check s1b s2b s1i s2summ s1c s2c s2check -step s2check: SELECT * FROM brin_page_items(get_raw_page('brinidx', 2), 'brinidx'::regclass); -itemoffset\|blknum\|attnum\|allnulls\|hasnulls\|placeholder\|empty\|value -----------+------+------+--------+--------+-----------+-----+-------- - 1\| 0\| 1\|f \|t \|f \|f \|{1 .. 1} -(1 row) - -step s1b: BEGIN ISOLATION LEVEL REPEATABLE READ; -step s2b: BEGIN ISOLATION LEVEL REPEATABLE READ; SELECT 1; -?column? --------- - 1 -(1 row) - ...
regress	diff -U3 /home/postgres/postgres/contrib/pageinspect/expected/page.out /home/postgres/postgres/build/testrun/pageinspect... --- /home/postgres/postgres/contrib/pageinspect/expected/page.out 2025-12-29 13:13:25.382192160 +0000 +++ /home/postgres/postgres/build/testrun/pageinspect/regress/results/page.out 2025-12-29 13:15:45.400280813 +0000 @@ -1,4 +1,5 @@ CREATE EXTENSION pageinspect; +ERROR: extension "pageinspect" has no installation script nor update path for version "1.14" -- Use a temp table so that effects of VACUUM are predictable CREATE TEMP TABLE test1 (a int, b int); INSERT INTO test1 VALUES (16777217, 131584); @@ -6,207 +7,177 @@ -- The page contents can vary, so just test that it can be read -- successfully, but don't keep the output. SELECT octet_length(get_raw_page('test1', 'main', 0)) AS main_0; - main_0 --------- - 8192 -(1 row) - +ERROR: function get_raw_page(unknown, unknown, integer) does not exist +LINE 1: SELECT octet_length(get_raw_page('test1', 'main', 0)) AS mai... ...
	FreeBSD - Meson
regress	diff -U3 /tmp/cirrus-ci-build/src/test/modules/brin/expected/summarization-and-inprogress-insertion.out /tmp/cirrus-ci-b... --- /tmp/cirrus-ci-build/src/test/modules/brin/expected/summarization-and-inprogress-insertion.out 2025-12-29 13:13:15.3... +++ /tmp/cirrus-ci-build/build/testrun/brin/isolation/results/summarization-and-inprogress-insertion.out 2025-12-29 13:1... @@ -1,51 +1,4 @@ Parsed test spec with 2 sessions starting permutation: s2check s1b s2b s1i s2summ s1c s2c s2check -step s2check: SELECT * FROM brin_page_items(get_raw_page('brinidx', 2), 'brinidx'::regclass); -itemoffset\|blknum\|attnum\|allnulls\|hasnulls\|placeholder\|empty\|value -----------+------+------+--------+--------+-----------+-----+-------- - 1\| 0\| 1\|f \|t \|f \|f \|{1 .. 1} -(1 row) - -step s1b: BEGIN ISOLATION LEVEL REPEATABLE READ; -step s2b: BEGIN ISOLATION LEVEL REPEATABLE READ; SELECT 1; -?column? --------- - 1 -(1 row) - ...
regress	diff -U3 /tmp/cirrus-ci-build/contrib/pageinspect/expected/page.out /tmp/cirrus-ci-build/build/testrun/pageinspect/regre... --- /tmp/cirrus-ci-build/contrib/pageinspect/expected/page.out 2025-12-29 13:13:13.770051000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/pageinspect/regress/results/page.out 2025-12-29 13:16:23.378997000 +0000 @@ -1,4 +1,5 @@ CREATE EXTENSION pageinspect; +ERROR: extension "pageinspect" has no installation script nor update path for version "1.14" -- Use a temp table so that effects of VACUUM are predictable CREATE TEMP TABLE test1 (a int, b int); INSERT INTO test1 VALUES (16777217, 131584); @@ -6,207 +7,177 @@ -- The page contents can vary, so just test that it can be read -- successfully, but don't keep the output. SELECT octet_length(get_raw_page('test1', 'main', 0)) AS main_0; - main_0 --------- - 8192 -(1 row) - +ERROR: function get_raw_page(unknown, unknown, integer) does not exist +LINE 1: SELECT octet_length(get_raw_page('test1', 'main', 0)) AS mai... ...
57/5879	amcheck: support for GiST
	macOS - Sequoia - Meson
regress	diff -U3 /Users/admin/pgsql/contrib/amcheck/expected/check_gist.out /Users/admin/pgsql/build/testrun/amcheck/regress/res... --- /Users/admin/pgsql/contrib/amcheck/expected/check_gist.out 2025-12-29 11:37:36 +++ /Users/admin/pgsql/build/testrun/amcheck/regress/results/check_gist.out 2025-12-29 11:42:27 @@ -143,3 +143,5 @@ (1 row) +-- cleanup +DROP TABLE toast_bug;
	Windows - Server 2022, MinGW64 - Meson
regress	diff --strip-trailing-cr -U3 C:/cirrus/contrib/amcheck/expected/check_gist.out C:/cirrus/build/testrun/amcheck/regress/r... --- C:/cirrus/contrib/amcheck/expected/check_gist.out 2025-12-29 11:37:40.388868700 +0000 +++ C:/cirrus/build/testrun/amcheck/regress/results/check_gist.out 2025-12-29 11:48:32.382348000 +0000 @@ -143,3 +143,5 @@ (1 row) +-- cleanup +DROP TABLE toast_bug;
	Windows - Server 2022, VS 2019 - Meson & ninja
regress	diff --strip-trailing-cr -U3 C:/cirrus/contrib/amcheck/expected/check_gist.out C:/cirrus/build/testrun/amcheck/regress/r... --- C:/cirrus/contrib/amcheck/expected/check_gist.out 2025-12-29 11:37:39.316200100 +0000 +++ C:/cirrus/build/testrun/amcheck/regress/results/check_gist.out 2025-12-29 11:45:42.714200900 +0000 @@ -143,3 +143,5 @@ (1 row) +-- cleanup +DROP TABLE toast_bug;
	Linux - Debian Trixie - Meson
regress	diff -U3 /tmp/cirrus-ci-build/contrib/amcheck/expected/check_gist.out /tmp/cirrus-ci-build/build/testrun/amcheck/regress... --- /tmp/cirrus-ci-build/contrib/amcheck/expected/check_gist.out 2025-12-29 11:37:44.191187065 +0000 +++ /tmp/cirrus-ci-build/build/testrun/amcheck/regress/results/check_gist.out 2025-12-29 11:42:30.883119617 +0000 @@ -143,3 +143,5 @@ (1 row) +-- cleanup +DROP TABLE toast_bug;
	NetBSD - Meson
regress	diff -U3 /home/postgres/postgres/contrib/amcheck/expected/check_gist.out /home/postgres/postgres/build/testrun/amcheck/r... --- /home/postgres/postgres/contrib/amcheck/expected/check_gist.out 2025-12-29 11:37:50.460245377 +0000 +++ /home/postgres/postgres/build/testrun/amcheck/regress/results/check_gist.out 2025-12-29 11:40:49.105849505 +0000 @@ -143,3 +143,5 @@ (1 row) +-- cleanup +DROP TABLE toast_bug;
	Linux - Debian Trixie - Autoconf
regress	diff -U3 /tmp/cirrus-ci-build/contrib/amcheck/expected/check_gist.out /tmp/cirrus-ci-build/contrib/amcheck/results/check... --- /tmp/cirrus-ci-build/contrib/amcheck/expected/check_gist.out 2025-12-29 11:37:40.364011247 +0000 +++ /tmp/cirrus-ci-build/contrib/amcheck/results/check_gist.out 2025-12-29 11:40:30.859978159 +0000 @@ -143,3 +143,5 @@ (1 row) +-- cleanup +DROP TABLE toast_bug;
	OpenBSD - Meson
regress	diff -U3 /home/postgres/postgres/contrib/amcheck/expected/check_gist.out /home/postgres/postgres/build/testrun/amcheck/r... --- /home/postgres/postgres/contrib/amcheck/expected/check_gist.out Mon Dec 29 11:37:45 2025 +++ /home/postgres/postgres/build/testrun/amcheck/regress/results/check_gist.out Mon Dec 29 11:43:30 2025 @@ -143,3 +143,5 @@ (1 row) +-- cleanup +DROP TABLE toast_bug;
	FreeBSD - Meson
regress	diff -U3 /tmp/cirrus-ci-build/contrib/amcheck/expected/check_gist.out /tmp/cirrus-ci-build/build/testrun/amcheck/regress... --- /tmp/cirrus-ci-build/contrib/amcheck/expected/check_gist.out 2025-12-29 11:37:54.092831000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/amcheck/regress/results/check_gist.out 2025-12-29 11:41:02.925024000 +0000 @@ -143,3 +143,5 @@ (1 row) +-- cleanup +DROP TABLE toast_bug;
57/6185	Add pg_get_type_ddl() to retrieve the CREATE TYPE statement
	NetBSD - Meson
regress	diff -U3 /home/postgres/postgres/src/test/isolation/expected/timeouts.out /home/postgres/postgres/build/testrun/isolatio... --- /home/postgres/postgres/src/test/isolation/expected/timeouts.out 2025-12-29 11:23:38.311164247 +0000 +++ /home/postgres/postgres/build/testrun/isolation/isolation/results/timeouts.out 2025-12-29 11:27:16.015776334 +0000 @@ -57,7 +57,7 @@ step sto: SET statement_timeout = '10ms'; step update: DELETE FROM accounts WHERE accountid = 'checking'; <waiting ...> step update: <... completed> -ERROR: canceling statement due to statement timeout +ERROR: canceling statement due to user request starting permutation: wrtbl lto update step wrtbl: UPDATE accounts SET balance = balance + 100;
57/6207	Fix socket handle inheritance on Windows
	NetBSD - Meson
regress	diff -U3 /home/postgres/postgres/src/test/regress/expected/tsdicts.out /home/postgres/postgres/build/testrun/pg_upgrade/... --- /home/postgres/postgres/src/test/regress/expected/tsdicts.out 2025-12-29 10:25:42.542480701 +0000 +++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/tsdicts.out 2025-12-29 10:27:29.9876933... @@ -1,723 +1 @@ ---Test text search dictionaries and configurations --- Test ISpell dictionary with ispell affix file -CREATE TEXT SEARCH DICTIONARY ispell ( - Template=ispell, - DictFile=ispell_sample, - AffFile=ispell_sample -); -SELECT ts_lexize('ispell', 'skies'); - ts_lexize ------------ - {sky} -(1 row) - -SELECT ts_lexize('ispell', 'bookings'); - ts_lexize ----------------- ...
57/6059	Improving the names generated for indexes on expressions
	NetBSD - Meson
regress	diff -U3 /home/postgres/postgres/src/test/regress/expected/temp.out /home/postgres/postgres/build/testrun/regress/regres... --- /home/postgres/postgres/src/test/regress/expected/temp.out 2025-12-28 19:15:45.376581759 +0000 +++ /home/postgres/postgres/build/testrun/regress/regress/results/temp.out 2025-12-28 19:22:30.833590961 +0000 @@ -1,568 +1 @@ --- --- TEMP --- Test temp relations and indexes --- --- test temp table/index masking -CREATE TABLE temptest(col int); -CREATE INDEX i_temptest ON temptest(col); -CREATE TEMP TABLE temptest(tcol int); -CREATE INDEX i_temptest ON temptest(tcol); -SELECT * FROM temptest; - tcol ------- -(0 rows) - -DROP INDEX i_temptest; -DROP TABLE temptest; ...
57/5714	Allow to collect statistics on virtual generated columns
	Windows - Server 2022, VS 2019 - Meson & ninja
regress	diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/generated_virtual.out C:/cirrus/build/testrun/pg_upgrad... --- C:/cirrus/src/test/regress/expected/generated_virtual.out 2025-12-28 17:39:00.495424800 +0000 +++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out 2025-12-28 17:42:35.116725700 +... @@ -1519,7 +1519,7 @@ select count(*) from pg_stats where tablename = 'gtest32'; count ------- - 5 + 6 (1 row) -- Ensure that nullingrel bits are propagated into the generation expressions
regress	diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/generated_virtual.out C:/cirrus/build/testrun/recovery/... --- C:/cirrus/src/test/regress/expected/generated_virtual.out 2025-12-28 17:39:00.495424800 +0000 +++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out 2025-12-28 17:45:23.014327300... @@ -1519,7 +1519,7 @@ select count(*) from pg_stats where tablename = 'gtest32'; count ------- - 5 + 6 (1 row) -- Ensure that nullingrel bits are propagated into the generation expressions
regress	diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/generated_virtual.out C:/cirrus/build/testrun/regress/r... --- C:/cirrus/src/test/regress/expected/generated_virtual.out 2025-12-28 17:39:00.495424800 +0000 +++ C:/cirrus/build/testrun/regress/regress/results/generated_virtual.out 2025-12-28 17:42:30.722185100 +0000 @@ -1519,7 +1519,7 @@ select count(*) from pg_stats where tablename = 'gtest32'; count ------- - 5 + 6 (1 row) -- Ensure that nullingrel bits are propagated into the generation expressions
	macOS - Sequoia - Meson
regress	diff -U3 /Users/admin/pgsql/src/test/regress/expected/generated_virtual.out /Users/admin/pgsql/build/testrun/pg_upgrade/... --- /Users/admin/pgsql/src/test/regress/expected/generated_virtual.out 2025-12-28 17:38:59 +++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out 2025-12-28 17:41:36 @@ -1519,7 +1519,7 @@ select count(*) from pg_stats where tablename = 'gtest32'; count ------- - 5 + 6 (1 row) -- Ensure that nullingrel bits are propagated into the generation expressions
regress	diff -U3 /Users/admin/pgsql/src/test/regress/expected/generated_virtual.out /Users/admin/pgsql/build/testrun/recovery/02... --- /Users/admin/pgsql/src/test/regress/expected/generated_virtual.out 2025-12-28 17:38:59 +++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out 2025-12-28 17:42:35 @@ -1519,7 +1519,7 @@ select count(*) from pg_stats where tablename = 'gtest32'; count ------- - 5 + 6 (1 row) -- Ensure that nullingrel bits are propagated into the generation expressions
regress	diff -U3 /Users/admin/pgsql/src/test/regress/expected/generated_virtual.out /Users/admin/pgsql/build/testrun/regress/reg... --- /Users/admin/pgsql/src/test/regress/expected/generated_virtual.out 2025-12-28 17:38:59 +++ /Users/admin/pgsql/build/testrun/regress/regress/results/generated_virtual.out 2025-12-28 17:41:36 @@ -1519,7 +1519,7 @@ select count(*) from pg_stats where tablename = 'gtest32'; count ------- - 5 + 6 (1 row) -- Ensure that nullingrel bits are propagated into the generation expressions
	Linux - Debian Trixie - Meson
regress	diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out /tmp/cirrus-ci-build/build/testrun/pg_upgr... --- /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out 2025-12-28 17:39:06.726137777 +0000 +++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out 2025-12-28 17:43:56.... @@ -1519,7 +1519,7 @@ select count(*) from pg_stats where tablename = 'gtest32'; count ------- - 5 + 6 (1 row) -- Ensure that nullingrel bits are propagated into the generation expressions
regress	diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out /tmp/cirrus-ci-build/build/testrun/recover... --- /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out 2025-12-28 17:39:06.726137777 +0000 +++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out 2025-12-28 17:45:1... @@ -1519,7 +1519,7 @@ select count(*) from pg_stats where tablename = 'gtest32'; count ------- - 5 + 6 (1 row) -- Ensure that nullingrel bits are propagated into the generation expressions
regress	diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out /tmp/cirrus-ci-build/build/testrun/regress... --- /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out 2025-12-28 17:39:06.726137777 +0000 +++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/generated_virtual.out 2025-12-28 17:43:56.858580614 +0000 @@ -1519,7 +1519,7 @@ select count(*) from pg_stats where tablename = 'gtest32'; count ------- - 5 + 6 (1 row) -- Ensure that nullingrel bits are propagated into the generation expressions
	Windows - Server 2022, MinGW64 - Meson
regress	diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/generated_virtual.out C:/cirrus/build/testrun/pg_upgrad... --- C:/cirrus/src/test/regress/expected/generated_virtual.out 2025-12-28 17:39:01.366490500 +0000 +++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out 2025-12-28 17:45:46.015329400 +... @@ -1519,7 +1519,7 @@ select count(*) from pg_stats where tablename = 'gtest32'; count ------- - 5 + 6 (1 row) -- Ensure that nullingrel bits are propagated into the generation expressions
regress	diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/generated_virtual.out C:/cirrus/build/testrun/recovery/... --- C:/cirrus/src/test/regress/expected/generated_virtual.out 2025-12-28 17:39:01.366490500 +0000 +++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out 2025-12-28 17:48:26.065138900... @@ -1519,7 +1519,7 @@ select count(*) from pg_stats where tablename = 'gtest32'; count ------- - 5 + 6 (1 row) -- Ensure that nullingrel bits are propagated into the generation expressions
regress	diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/generated_virtual.out C:/cirrus/build/testrun/regress/r... --- C:/cirrus/src/test/regress/expected/generated_virtual.out 2025-12-28 17:39:01.366490500 +0000 +++ C:/cirrus/build/testrun/regress/regress/results/generated_virtual.out 2025-12-28 17:45:41.316114100 +0000 @@ -1519,7 +1519,7 @@ select count(*) from pg_stats where tablename = 'gtest32'; count ------- - 5 + 6 (1 row) -- Ensure that nullingrel bits are propagated into the generation expressions
	OpenBSD - Meson
regress	diff -U3 /home/postgres/postgres/src/test/regress/expected/generated_virtual.out /home/postgres/postgres/build/testrun/p... --- /home/postgres/postgres/src/test/regress/expected/generated_virtual.out Sun Dec 28 17:39:07 2025 +++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out Sun Dec 28 17:43:... @@ -1519,7 +1519,7 @@ select count(*) from pg_stats where tablename = 'gtest32'; count ------- - 5 + 6 (1 row) -- Ensure that nullingrel bits are propagated into the generation expressions
regress	diff -U3 /home/postgres/postgres/src/test/regress/expected/generated_virtual.out /home/postgres/postgres/build/testrun/r... --- /home/postgres/postgres/src/test/regress/expected/generated_virtual.out Sun Dec 28 17:39:07 2025 +++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out Sun Dec 28 17:4... @@ -1519,7 +1519,7 @@ select count(*) from pg_stats where tablename = 'gtest32'; count ------- - 5 + 6 (1 row) -- Ensure that nullingrel bits are propagated into the generation expressions
regress	diff -U3 /home/postgres/postgres/src/test/regress/expected/generated_virtual.out /home/postgres/postgres/build/testrun/r... --- /home/postgres/postgres/src/test/regress/expected/generated_virtual.out Sun Dec 28 17:39:07 2025 +++ /home/postgres/postgres/build/testrun/regress/regress/results/generated_virtual.out Sun Dec 28 17:43:01 2025 @@ -1519,7 +1519,7 @@ select count(*) from pg_stats where tablename = 'gtest32'; count ------- - 5 + 6 (1 row) -- Ensure that nullingrel bits are propagated into the generation expressions
	Linux - Debian Trixie - Autoconf
regress	diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tm... --- /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out 2025-12-28 17:38:58.005846897 +0000 +++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/generated_virtual.out 2025-12-28 17:47:26.937266520 +0000 @@ -1519,7 +1519,7 @@ select count(*) from pg_stats where tablename = 'gtest32'; count ------- - 5 + 6 (1 row) -- Ensure that nullingrel bits are propagated into the generation expressions
regress	diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out /tmp/cirrus-ci-build/src/test/recovery/tmp... --- /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out 2025-12-28 17:38:58.005846897 +0000 +++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/generated_virtual.out 2025-12-28 17:48:35.605202565 +0000 @@ -1519,7 +1519,7 @@ select count(*) from pg_stats where tablename = 'gtest32'; count ------- - 5 + 6 (1 row) -- Ensure that nullingrel bits are propagated into the generation expressions
regress	diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out /tmp/cirrus-ci-build/src/test/regress/resu... --- /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out 2025-12-28 17:38:58.005846897 +0000 +++ /tmp/cirrus-ci-build/src/test/regress/results/generated_virtual.out 2025-12-28 17:44:39.805383912 +0000 @@ -1519,7 +1519,7 @@ select count(*) from pg_stats where tablename = 'gtest32'; count ------- - 5 + 6 (1 row) -- Ensure that nullingrel bits are propagated into the generation expressions
	NetBSD - Meson
regress	diff -U3 /home/postgres/postgres/src/test/regress/expected/generated_virtual.out /home/postgres/postgres/build/testrun/p... --- /home/postgres/postgres/src/test/regress/expected/generated_virtual.out 2025-12-28 17:39:12.679707108 +0000 +++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out 2025-12-28 17:42:... @@ -1519,7 +1519,7 @@ select count(*) from pg_stats where tablename = 'gtest32'; count ------- - 5 + 6 (1 row) -- Ensure that nullingrel bits are propagated into the generation expressions
regress	diff -U3 /home/postgres/postgres/src/test/regress/expected/generated_virtual.out /home/postgres/postgres/build/testrun/r... --- /home/postgres/postgres/src/test/regress/expected/generated_virtual.out 2025-12-28 17:39:12.679707108 +0000 +++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out 2025-12-28 17:4... @@ -1519,7 +1519,7 @@ select count(*) from pg_stats where tablename = 'gtest32'; count ------- - 5 + 6 (1 row) -- Ensure that nullingrel bits are propagated into the generation expressions
regress	diff -U3 /home/postgres/postgres/src/test/regress/expected/generated_virtual.out /home/postgres/postgres/build/testrun/r... --- /home/postgres/postgres/src/test/regress/expected/generated_virtual.out 2025-12-28 17:39:12.679707108 +0000 +++ /home/postgres/postgres/build/testrun/regress/regress/results/generated_virtual.out 2025-12-28 17:42:07.764088188 +0... @@ -1519,7 +1519,7 @@ select count(*) from pg_stats where tablename = 'gtest32'; count ------- - 5 + 6 (1 row) -- Ensure that nullingrel bits are propagated into the generation expressions
	FreeBSD - Meson
regress	diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out /tmp/cirrus-ci-build/build/testrun/pg_upgr... --- /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out 2025-12-28 17:39:06.715911000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out 2025-12-28 17:42:32.... @@ -1519,7 +1519,7 @@ select count(*) from pg_stats where tablename = 'gtest32'; count ------- - 5 + 6 (1 row) -- Ensure that nullingrel bits are propagated into the generation expressions
regress	diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out /tmp/cirrus-ci-build/build/testrun/recover... --- /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out 2025-12-28 17:39:06.715911000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out 2025-12-28 17:43:5... @@ -1519,7 +1519,7 @@ select count(*) from pg_stats where tablename = 'gtest32'; count ------- - 5 + 6 (1 row) -- Ensure that nullingrel bits are propagated into the generation expressions
regress	diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out /tmp/cirrus-ci-build/build/testrun/regress... --- /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out 2025-12-28 17:39:06.715911000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/generated_virtual.out 2025-12-28 17:42:30.900141000 +0000 @@ -1519,7 +1519,7 @@ select count(*) from pg_stats where tablename = 'gtest32'; count ------- - 5 + 6 (1 row) -- Ensure that nullingrel bits are propagated into the generation expressions
54/5829	VCI (columnar store extension)
	Linux - Debian Trixie - Meson
regress	diff -U3 /tmp/cirrus-ci-build/contrib/vci/expected/vci.out /tmp/cirrus-ci-build/build/testrun/vci/regress/results/vci.ou... --- /tmp/cirrus-ci-build/contrib/vci/expected/vci.out 2025-12-28 17:23:12.272715902 +0000 +++ /tmp/cirrus-ci-build/build/testrun/vci/regress/results/vci.out 2025-12-28 17:30:06.405846930 +0000 @@ -88,41 +88,7 @@ INSERT INTO testtable (key, cond, c01a, c01b, c02, c03, c05, c06, c07, c08, c09, c10, c13, c15, c16, c17, c18, c19, c20... -- Create an index which uses VCI index access method CREATE INDEX testindex ON testtable USING vci (key, cond, c01a, c01b, c02, c03, c05, c06, c07, c08, c09, c10, c13, c15,... --- We expect VCI plans are chosen here -EXPLAIN (ANALYZE, TIMING OFF, COSTS OFF, SUMMARY OFF, BUFFERS OFF) -SELECT key, count(*) AS count_star, count(c05) AS count_c05 FROM testtable WHERE NOT cond = 0 GROUP BY key ORDER BY key... - QUERY PLAN ------------------------------------------------------------------------------------------------- - Sort (actual rows=14.00 loops=1) - Sort Key: key - Sort Method: quicksort Memory: 25kB - -> Custom Scan (VCI HashAggregate) (actual rows=14.00 loops=1) - Group Key: key - -> Custom Scan (VCI Scan) using testindex on testtable (actual rows=10221.00 loops=1) - Filter: (cond <> 0) - Rows Removed by Filter: 476 ...
57/6343	Reuse data from readRecordBuf in XLogDecodeNextRecord
	Windows - Server 2022, MinGW64 - Meson
regress	diff --strip-trailing-cr -U3 C:/cirrus/contrib/test_decoding/expected/rewrite.out C:/cirrus/build/testrun/test_decoding/... --- C:/cirrus/contrib/test_decoding/expected/rewrite.out 2025-12-28 14:54:47.970847200 +0000 +++ C:/cirrus/build/testrun/test_decoding/regress/results/rewrite.out 2025-12-28 15:12:13.372852000 +0000 @@ -116,49 +116,7 @@ -- make old files go away CHECKPOINT; SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1... - data ... ------------------------------------------------------------------------------------------------------------------------... - BEGIN - table public.replication_example: INSERT: id[integer]:2 somedata[integer]:2 text[character varying]:null - table public.replication_example: INSERT: id[integer]:3 somedata[integer]:3 text[character varying]:null testcolumn1[i... - COMMIT - BEGIN - table public.replication_example: INSERT: id[integer]:4 somedata[integer]:3 text[character varying]:null testcolumn1[i... - table public.replication_example: INSERT: id[integer]:5 somedata[integer]:4 text[character varying]:null testcolumn1[i... - COMMIT - BEGIN - table public.replication_example: INSERT: id[integer]:6 somedata[integer]:5 text[character varying]:null testcolumn1[i... - COMMIT ...
	Windows - Server 2022, VS 2019 - Meson & ninja
regress	diff --strip-trailing-cr -U3 C:/cirrus/contrib/test_decoding/expected/rewrite.out C:/cirrus/build/testrun/test_decoding/... --- C:/cirrus/contrib/test_decoding/expected/rewrite.out 2025-12-28 14:54:57.287978300 +0000 +++ C:/cirrus/build/testrun/test_decoding/regress/results/rewrite.out 2025-12-28 15:05:18.820000100 +0000 @@ -116,49 +116,7 @@ -- make old files go away CHECKPOINT; SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1... - data ... ------------------------------------------------------------------------------------------------------------------------... - BEGIN - table public.replication_example: INSERT: id[integer]:2 somedata[integer]:2 text[character varying]:null - table public.replication_example: INSERT: id[integer]:3 somedata[integer]:3 text[character varying]:null testcolumn1[i... - COMMIT - BEGIN - table public.replication_example: INSERT: id[integer]:4 somedata[integer]:3 text[character varying]:null testcolumn1[i... - table public.replication_example: INSERT: id[integer]:5 somedata[integer]:4 text[character varying]:null testcolumn1[i... - COMMIT - BEGIN - table public.replication_example: INSERT: id[integer]:6 somedata[integer]:5 text[character varying]:null testcolumn1[i... - COMMIT ...
	NetBSD - Meson
regress	diff -U3 /home/postgres/postgres/contrib/test_decoding/expected/rewrite.out /home/postgres/postgres/build/testrun/test_d... --- /home/postgres/postgres/contrib/test_decoding/expected/rewrite.out 2025-12-28 14:55:26.420491309 +0000 +++ /home/postgres/postgres/build/testrun/test_decoding/regress/results/rewrite.out 2025-12-28 15:07:43.723945490 +0000 @@ -116,49 +116,7 @@ -- make old files go away CHECKPOINT; SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1... - data ... ------------------------------------------------------------------------------------------------------------------------... - BEGIN - table public.replication_example: INSERT: id[integer]:2 somedata[integer]:2 text[character varying]:null - table public.replication_example: INSERT: id[integer]:3 somedata[integer]:3 text[character varying]:null testcolumn1[i... - COMMIT - BEGIN - table public.replication_example: INSERT: id[integer]:4 somedata[integer]:3 text[character varying]:null testcolumn1[i... - table public.replication_example: INSERT: id[integer]:5 somedata[integer]:4 text[character varying]:null testcolumn1[i... - COMMIT - BEGIN - table public.replication_example: INSERT: id[integer]:6 somedata[integer]:5 text[character varying]:null testcolumn1[i... - COMMIT ...
	FreeBSD - Meson
regress	diff -U3 /tmp/cirrus-ci-build/contrib/test_decoding/expected/rewrite.out /tmp/cirrus-ci-build/build/testrun/test_decodin... --- /tmp/cirrus-ci-build/contrib/test_decoding/expected/rewrite.out 2025-12-28 14:54:46.322929000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/test_decoding/regress/results/rewrite.out 2025-12-28 15:01:35.538699000 +0000 @@ -116,49 +116,7 @@ -- make old files go away CHECKPOINT; SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1... - data ... ------------------------------------------------------------------------------------------------------------------------... - BEGIN - table public.replication_example: INSERT: id[integer]:2 somedata[integer]:2 text[character varying]:null - table public.replication_example: INSERT: id[integer]:3 somedata[integer]:3 text[character varying]:null testcolumn1[i... - COMMIT - BEGIN - table public.replication_example: INSERT: id[integer]:4 somedata[integer]:3 text[character varying]:null testcolumn1[i... - table public.replication_example: INSERT: id[integer]:5 somedata[integer]:4 text[character varying]:null testcolumn1[i... - COMMIT - BEGIN - table public.replication_example: INSERT: id[integer]:6 somedata[integer]:5 text[character varying]:null testcolumn1[i... - COMMIT ...
	Linux - Debian Trixie - Autoconf
regress	diff -U3 /tmp/cirrus-ci-build/contrib/test_decoding/expected/rewrite.out /tmp/cirrus-ci-build/contrib/test_decoding/resu... --- /tmp/cirrus-ci-build/contrib/test_decoding/expected/rewrite.out 2025-12-28 14:54:48.393190003 +0000 +++ /tmp/cirrus-ci-build/contrib/test_decoding/results/rewrite.out 2025-12-28 15:00:55.796591862 +0000 @@ -116,49 +116,7 @@ -- make old files go away CHECKPOINT; SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1... - data ... ------------------------------------------------------------------------------------------------------------------------... - BEGIN - table public.replication_example: INSERT: id[integer]:2 somedata[integer]:2 text[character varying]:null - table public.replication_example: INSERT: id[integer]:3 somedata[integer]:3 text[character varying]:null testcolumn1[i... - COMMIT - BEGIN - table public.replication_example: INSERT: id[integer]:4 somedata[integer]:3 text[character varying]:null testcolumn1[i... - table public.replication_example: INSERT: id[integer]:5 somedata[integer]:4 text[character varying]:null testcolumn1[i... - COMMIT - BEGIN - table public.replication_example: INSERT: id[integer]:6 somedata[integer]:5 text[character varying]:null testcolumn1[i... - COMMIT ...
57/6299	New grouping strategy - Index Aggregate
	Linux - Debian Trixie - Meson
regress	diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/partition_aggregate.out /tmp/cirrus-ci-build/build-32/testrun/pg... --- /tmp/cirrus-ci-build/src/test/regress/expected/partition_aggregate.out 2025-12-28 07:10:18.583187857 +0000 +++ /tmp/cirrus-ci-build/build-32/testrun/pg_upgrade/002_pg_upgrade/data/results/partition_aggregate.out 2025-12-28 07:2... @@ -1010,7 +1010,7 @@ -------------------------------------------------------------------- Sort Sort Key: pagg_tab_m.a, (sum(pagg_tab_m.b)), (avg(pagg_tab_m.c)) - -> Finalize IndexAggregate + -> Finalize HashAggregate Group Key: pagg_tab_m.a Filter: (avg(pagg_tab_m.c) < '22'::numeric) -> Append
regress	diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/partition_aggregate.out /tmp/cirrus-ci-build/build-32/testrun/re... --- /tmp/cirrus-ci-build/src/test/regress/expected/partition_aggregate.out 2025-12-28 07:10:18.583187857 +0000 +++ /tmp/cirrus-ci-build/build-32/testrun/recovery/027_stream_regress/data/results/partition_aggregate.out 2025-12-28 07... @@ -1010,7 +1010,7 @@ -------------------------------------------------------------------- Sort Sort Key: pagg_tab_m.a, (sum(pagg_tab_m.b)), (avg(pagg_tab_m.c)) - -> Finalize IndexAggregate + -> Finalize HashAggregate Group Key: pagg_tab_m.a Filter: (avg(pagg_tab_m.c) < '22'::numeric) -> Append
regress	diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/partition_aggregate.out /tmp/cirrus-ci-build/build-32/testrun/re... --- /tmp/cirrus-ci-build/src/test/regress/expected/partition_aggregate.out 2025-12-28 07:10:18.583187857 +0000 +++ /tmp/cirrus-ci-build/build-32/testrun/regress/regress/results/partition_aggregate.out 2025-12-28 07:21:56.616292981 ... @@ -1010,7 +1010,7 @@ -------------------------------------------------------------------- Sort Sort Key: pagg_tab_m.a, (sum(pagg_tab_m.b)), (avg(pagg_tab_m.c)) - -> Finalize IndexAggregate + -> Finalize HashAggregate Group Key: pagg_tab_m.a Filter: (avg(pagg_tab_m.c) < '22'::numeric) -> Append
	OpenBSD - Meson
regress	diff -U3 /home/postgres/postgres/src/test/regress/expected/brin.out /home/postgres/postgres/build/testrun/pg_upgrade/002... --- /home/postgres/postgres/src/test/regress/expected/brin.out Sun Dec 28 07:10:15 2025 +++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/brin.out Sun Dec 28 07:14:34 2025 @@ -539,53 +539,10 @@ -- vacuum actually removes the TOAST rows. Creating an index concurrently -- is a one way to achieve that, because it does exactly such wait. CREATE INDEX CONCURRENTLY brin_test_temp_idx ON brintest_3(a); -DROP INDEX brin_test_temp_idx; --- vacuum the table, to discard TOAST data -VACUUM brintest_3; --- retry insert with a different random-looking (but deterministic) value --- the value is different, and so should replace either min or max in the --- brin summary -WITH rand_value AS (SELECT string_agg(fipshash((-i)::text),'') AS val FROM generate_series(1,60) s(i)) -INSERT INTO brintest_3 -SELECT val, val, val, val FROM rand_value; --- now try some queries, accessing the brin index -SET enable_seqscan = off; -EXPLAIN (COSTS OFF) -SELECT * FROM brintest_3 WHERE b < '0'; ...
regress	diff -U3 /home/postgres/postgres/src/test/regress/expected/brin.out /home/postgres/postgres/build/testrun/recovery/027_s... --- /home/postgres/postgres/src/test/regress/expected/brin.out Sun Dec 28 07:10:15 2025 +++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/brin.out Sun Dec 28 07:16:37 2025 @@ -363,229 +363,10 @@ END LOOP; END; $x$; -RESET enable_seqscan; -RESET enable_bitmapscan; -INSERT INTO brintest SELECT - repeat(stringu1, 42)::bytea, - substr(stringu1, 1, 1)::"char", - stringu1::name, 142857 * tenthous, - thousand, - twothousand, - repeat(stringu1, 42), - unique1::oid, - format('(%s,%s)', tenthous, twenty)::tid, - (four + 1.0)/(hundred+1), - odd::float8 / (tenthous + 1), ...
regress	diff -U3 /home/postgres/postgres/src/test/regress/expected/brin.out /home/postgres/postgres/build/testrun/regress/regres... --- /home/postgres/postgres/src/test/regress/expected/brin.out Sun Dec 28 07:10:15 2025 +++ /home/postgres/postgres/build/testrun/regress/regress/results/brin.out Sun Dec 28 07:14:30 2025 @@ -539,53 +539,10 @@ -- vacuum actually removes the TOAST rows. Creating an index concurrently -- is a one way to achieve that, because it does exactly such wait. CREATE INDEX CONCURRENTLY brin_test_temp_idx ON brintest_3(a); -DROP INDEX brin_test_temp_idx; --- vacuum the table, to discard TOAST data -VACUUM brintest_3; --- retry insert with a different random-looking (but deterministic) value --- the value is different, and so should replace either min or max in the --- brin summary -WITH rand_value AS (SELECT string_agg(fipshash((-i)::text),'') AS val FROM generate_series(1,60) s(i)) -INSERT INTO brintest_3 -SELECT val, val, val, val FROM rand_value; --- now try some queries, accessing the brin index -SET enable_seqscan = off; -EXPLAIN (COSTS OFF) -SELECT * FROM brintest_3 WHERE b < '0'; ...
57/6054	let ALTER COLUMN SET DATA TYPE cope with POLICY dependency
	Windows - Server 2022, MinGW64 - Meson
regress	diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/rowsecurity.out C:/cirrus/build/testrun/recovery/027_st... --- C:/cirrus/src/test/regress/expected/rowsecurity.out 2025-12-27 19:41:00.174756900 +0000 +++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/rowsecurity.out 2025-12-27 19:51:14.513953900 +0000 @@ -378,15 +378,15 @@ --------------------+----------+-------+----------------------------------------------+-------------------+------------... regress_rls_schema \| category \| table \| regress_rls_alice=arwdDxtm/regress_rls_alice+\| \| \| \| \| =arwdDxtm/regress_rls_alice \| \| - regress_rls_schema \| document \| table \| regress_rls_alice=arwdDxtm/regress_rls_alice+\| \| p1: ... - \| \| \| =arwdDxtm/regress_rls_alice \| \| (u): (dle... + regress_rls_schema \| document \| table \| regress_rls_alice=arwdDxtm/regress_rls_alice+\| \| p1r (RESTRI... + \| \| \| =arwdDxtm/regress_rls_alice \| \| (u): (cid... + \| \| \| \| \| to: regre... + \| \| \| \| \| p1: ... + \| \| \| \| \| (u): (dle... \| \| \| \| \| FROM uac... \| \| \| \| \| WHERE (ua... \| \| \| \| \| p2r (RESTRI... \| \| \| \| \| (u): ((ci... - \| \| \| \| \| to: regre... - \| \| \| \| \| p1r (RESTRI... ...
	macOS - Sequoia - Meson
regress	diff -U3 /Users/admin/pgsql/src/test/regress/expected/rowsecurity.out /Users/admin/pgsql/build/testrun/regress/regress/r... --- /Users/admin/pgsql/src/test/regress/expected/rowsecurity.out 2025-12-27 19:41:03 +++ /Users/admin/pgsql/build/testrun/regress/regress/results/rowsecurity.out 2025-12-27 19:44:20 @@ -378,15 +378,15 @@ --------------------+----------+-------+----------------------------------------------+-------------------+------------... regress_rls_schema \| category \| table \| regress_rls_alice=arwdDxtm/regress_rls_alice+\| \| \| \| \| =arwdDxtm/regress_rls_alice \| \| - regress_rls_schema \| document \| table \| regress_rls_alice=arwdDxtm/regress_rls_alice+\| \| p1: ... - \| \| \| =arwdDxtm/regress_rls_alice \| \| (u): (dle... + regress_rls_schema \| document \| table \| regress_rls_alice=arwdDxtm/regress_rls_alice+\| \| p1r (RESTRI... + \| \| \| =arwdDxtm/regress_rls_alice \| \| (u): (cid... + \| \| \| \| \| to: regre... + \| \| \| \| \| p1: ... + \| \| \| \| \| (u): (dle... \| \| \| \| \| FROM uac... \| \| \| \| \| WHERE (ua... \| \| \| \| \| p2r (RESTRI... \| \| \| \| \| (u): ((ci... - \| \| \| \| \| to: regre... - \| \| \| \| \| p1r (RESTRI... ...
	FreeBSD - Meson
regress	diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/rowsecurity.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/00... --- /tmp/cirrus-ci-build/src/test/regress/expected/rowsecurity.out 2025-12-27 19:41:00.686965000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/rowsecurity.out 2025-12-27 19:43:58.791472... @@ -378,15 +378,15 @@ --------------------+----------+-------+----------------------------------------------+-------------------+------------... regress_rls_schema \| category \| table \| regress_rls_alice=arwdDxtm/regress_rls_alice+\| \| \| \| \| =arwdDxtm/regress_rls_alice \| \| - regress_rls_schema \| document \| table \| regress_rls_alice=arwdDxtm/regress_rls_alice+\| \| p1: ... - \| \| \| =arwdDxtm/regress_rls_alice \| \| (u): (dle... + regress_rls_schema \| document \| table \| regress_rls_alice=arwdDxtm/regress_rls_alice+\| \| p1r (RESTRI... + \| \| \| =arwdDxtm/regress_rls_alice \| \| (u): (cid... + \| \| \| \| \| to: regre... + \| \| \| \| \| p1: ... + \| \| \| \| \| (u): (dle... \| \| \| \| \| FROM uac... \| \| \| \| \| WHERE (ua... \| \| \| \| \| p2r (RESTRI... \| \| \| \| \| (u): ((ci... - \| \| \| \| \| to: regre... - \| \| \| \| \| p1r (RESTRI... ...
57/6176	Batching in executor, part 1: add batch variant of table AM scan API
	FreeBSD - Meson
regress	diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/explain.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg... --- /tmp/cirrus-ci-build/src/test/regress/expected/explain.out 2025-12-27 15:11:14.246699000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/explain.out 2025-12-27 15:16:47.793093000 ... @@ -844,10 +844,9 @@ Seq Scan on batch_test (actual time=N.N..N.N rows=N.N loops=N) Filter: (a > N) Rows Removed by Filter: N - Batches: N Avg Rows: N.N Max: N Min: N Planning Time: N.N ms Execution Time: N.N ms -(6 rows) +(5 rows) -- With LIMIT - partial scan shows fewer batches select explain_filter('explain (analyze, batches, buffers off, costs off) select * from batch_test limit 100'); @@ -855,10 +854,9 @@ ---------------------------------------------------------------------- Limit (actual time=N.N..N.N rows=N.N loops=N) -> Seq Scan on batch_test (actual time=N.N..N.N rows=N.N loops=N) - Batches: N Avg Rows: N.N Max: N Min: N ...
regress	diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/explain.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stre... --- /tmp/cirrus-ci-build/src/test/regress/expected/explain.out 2025-12-27 15:11:14.246699000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/explain.out 2025-12-27 15:18:21.16033500... @@ -832,10 +832,9 @@ explain_filter ---------------------------------------------------------------- Seq Scan on batch_test (actual time=N.N..N.N rows=N.N loops=N) - Batches: N Avg Rows: N.N Max: N Min: N Planning Time: N.N ms Execution Time: N.N ms -(4 rows) +(3 rows) -- With filter select explain_filter('explain (analyze, batches, buffers off, costs off) select * from batch_test where a > 5000'); @@ -844,10 +843,9 @@ Seq Scan on batch_test (actual time=N.N..N.N rows=N.N loops=N) Filter: (a > N) Rows Removed by Filter: N - Batches: N Avg Rows: N.N Max: N Min: N ...
regress	diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/explain.out /tmp/cirrus-ci-build/build/testrun/regress/regress/r... --- /tmp/cirrus-ci-build/src/test/regress/expected/explain.out 2025-12-27 15:11:14.246699000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/explain.out 2025-12-27 15:16:47.958916000 +0000 @@ -844,10 +844,9 @@ Seq Scan on batch_test (actual time=N.N..N.N rows=N.N loops=N) Filter: (a > N) Rows Removed by Filter: N - Batches: N Avg Rows: N.N Max: N Min: N Planning Time: N.N ms Execution Time: N.N ms -(6 rows) +(5 rows) -- With LIMIT - partial scan shows fewer batches select explain_filter('explain (analyze, batches, buffers off, costs off) select * from batch_test limit 100'); @@ -855,10 +854,9 @@ ---------------------------------------------------------------------- Limit (actual time=N.N..N.N rows=N.N loops=N) -> Seq Scan on batch_test (actual time=N.N..N.N rows=N.N loops=N) - Batches: N Avg Rows: N.N Max: N Min: N ...
57/6198	Change initdb default to the builtin collation provider
	NetBSD - Meson
regress	diff -U3 /home/postgres/postgres/contrib/citext/expected/citext_utf8.out /home/postgres/postgres/build/testrun/citext/re... --- /home/postgres/postgres/contrib/citext/expected/citext_utf8.out 2025-12-27 12:19:29.757083715 +0000 +++ /home/postgres/postgres/build/testrun/citext/regress/results/citext_utf8.out 2025-12-27 12:22:22.641893727 +0000 @@ -30,7 +30,7 @@ SELECT 'À'::citext = 'à'::citext AS t; t --- - t + f (1 row) SELECT 'À'::text = 'à'::text AS f; -- text wins. @@ -64,7 +64,7 @@ SELECT 'i'::citext = 'İ'::citext AS t; t --- - t + f (1 row) ...
regress	diff -U3 /home/postgres/postgres/src/test/modules/test_regex/expected/test_regex_utf8.out /home/postgres/postgres/build/... --- /home/postgres/postgres/src/test/modules/test_regex/expected/test_regex_utf8.out 2025-12-27 12:19:36.401027436 +0000 +++ /home/postgres/postgres/build/testrun/test_regex/regress/results/test_regex_utf8.out 2025-12-27 12:22:46.522251024 +... @@ -152,7 +152,7 @@ test_regex ----------------- {0,REG_ULOCALE} - {xᔀሷ} + {x} (2 rows) select * from test_regex('[[:lower:]]+', E'x\u1500\u1237', 'L'); @@ -166,7 +166,7 @@ test_regex ----------------- {0,REG_ULOCALE} - {xᔀሷ} + {x} (2 rows) ...
57/6334	Remove header lock BufferGetLSNAtomic() on architectures with 64 bit atomic operations
	Linux - Debian Trixie - Meson
regress	diff -U3 /tmp/cirrus-ci-build/contrib/pageinspect/expected/page.out /tmp/cirrus-ci-build/build/testrun/pageinspect/regre... --- /tmp/cirrus-ci-build/contrib/pageinspect/expected/page.out 2025-12-26 12:48:58.569952566 +0000 +++ /tmp/cirrus-ci-build/build/testrun/pageinspect/regress/results/page.out 2025-12-26 12:55:05.404107130 +0000 @@ -62,227 +62,7 @@ ERROR: invalid block number SELECT tuple_data_split('test1'::regclass, t_data, t_infomask, t_infomask2, t_bits) FROM heap_page_items(get_raw_page('test1', 0)); - tuple_data_split -------------------------------- - {"\\x01000001","\\x00020200"} -(1 row) - -SELECT * FROM fsm_page_contents(get_raw_page('test1', 'fsm', 0)); - fsm_page_contents -------------------- - 0: 254 + - 1: 254 + - 3: 254 + - 7: 254 + - 15: 254 + ...
57/6322	Error position support for ComputeIndexAttrs
	Windows - Server 2022, MinGW64 - Meson
regress	diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/collate.windows.win1252.out C:/cirrus/build/testrun/rec... --- C:/cirrus/src/test/regress/expected/collate.windows.win1252.out 2025-12-25 17:59:54.009123400 +0000 +++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/collate.windows.win1252.out 2025-12-25 18:09:16.089... @@ -845,6 +845,8 @@ CREATE INDEX collate_test1_idx4 ON collate_test1 (((b\|\|'foo') COLLATE "POSIX")); CREATE INDEX collate_test1_idx5 ON collate_test1 (a COLLATE "C"); -- fail ERROR: collations are not supported by type integer +LINE 1: CREATE INDEX collate_test1_idx5 ON collate_test1 (a COLLATE ... + ^ CREATE INDEX collate_test1_idx6 ON collate_test1 ((a COLLATE "C")); -- fail ERROR: collations are not supported by type integer LINE 1: ...ATE INDEX collate_test1_idx6 ON collate_test1 ((a COLLATE "C...
regress	diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/collate.windows.win1252.out C:/cirrus/build/testrun/reg... --- C:/cirrus/src/test/regress/expected/collate.windows.win1252.out 2025-12-25 17:59:54.009123400 +0000 +++ C:/cirrus/build/testrun/regress/regress/results/collate.windows.win1252.out 2025-12-25 18:06:08.793604700 +0000 @@ -845,6 +845,8 @@ CREATE INDEX collate_test1_idx4 ON collate_test1 (((b\|\|'foo') COLLATE "POSIX")); CREATE INDEX collate_test1_idx5 ON collate_test1 (a COLLATE "C"); -- fail ERROR: collations are not supported by type integer +LINE 1: CREATE INDEX collate_test1_idx5 ON collate_test1 (a COLLATE ... + ^ CREATE INDEX collate_test1_idx6 ON collate_test1 ((a COLLATE "C")); -- fail ERROR: collations are not supported by type integer LINE 1: ...ATE INDEX collate_test1_idx6 ON collate_test1 ((a COLLATE "C...
	Windows - Server 2022, VS 2019 - Meson & ninja
regress	diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/collate.windows.win1252.out C:/cirrus/build/testrun/rec... --- C:/cirrus/src/test/regress/expected/collate.windows.win1252.out 2025-12-25 17:59:54.100819900 +0000 +++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/collate.windows.win1252.out 2025-12-25 18:06:09.877... @@ -845,6 +845,8 @@ CREATE INDEX collate_test1_idx4 ON collate_test1 (((b\|\|'foo') COLLATE "POSIX")); CREATE INDEX collate_test1_idx5 ON collate_test1 (a COLLATE "C"); -- fail ERROR: collations are not supported by type integer +LINE 1: CREATE INDEX collate_test1_idx5 ON collate_test1 (a COLLATE ... + ^ CREATE INDEX collate_test1_idx6 ON collate_test1 ((a COLLATE "C")); -- fail ERROR: collations are not supported by type integer LINE 1: ...ATE INDEX collate_test1_idx6 ON collate_test1 ((a COLLATE "C...
regress	diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/collate.windows.win1252.out C:/cirrus/build/testrun/reg... --- C:/cirrus/src/test/regress/expected/collate.windows.win1252.out 2025-12-25 17:59:54.100819900 +0000 +++ C:/cirrus/build/testrun/regress/regress/results/collate.windows.win1252.out 2025-12-25 18:03:21.848038200 +0000 @@ -845,6 +845,8 @@ CREATE INDEX collate_test1_idx4 ON collate_test1 (((b\|\|'foo') COLLATE "POSIX")); CREATE INDEX collate_test1_idx5 ON collate_test1 (a COLLATE "C"); -- fail ERROR: collations are not supported by type integer +LINE 1: CREATE INDEX collate_test1_idx5 ON collate_test1 (a COLLATE ... + ^ CREATE INDEX collate_test1_idx6 ON collate_test1 ((a COLLATE "C")); -- fail ERROR: collations are not supported by type integer LINE 1: ...ATE INDEX collate_test1_idx6 ON collate_test1 ((a COLLATE "C...
	Linux - Debian Trixie - Autoconf
regress	diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/collate.linux.utf8.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/t... --- /tmp/cirrus-ci-build/src/test/regress/expected/collate.linux.utf8.out 2025-12-25 17:59:55.060256510 +0000 +++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/collate.linux.utf8.out 2025-12-25 18:07:32.595630654 +0000 @@ -1009,6 +1009,8 @@ CREATE INDEX collate_test1_idx4 ON collate_test1 (((b\|\|'foo') COLLATE "POSIX")); CREATE INDEX collate_test1_idx5 ON collate_test1 (a COLLATE "C"); -- fail ERROR: collations are not supported by type integer +LINE 1: CREATE INDEX collate_test1_idx5 ON collate_test1 (a COLLATE ... + ^ CREATE INDEX collate_test1_idx6 ON collate_test1 ((a COLLATE "C")); -- fail ERROR: collations are not supported by type integer LINE 1: ...ATE INDEX collate_test1_idx6 ON collate_test1 ((a COLLATE "C...
regress	diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/collate.linux.utf8.out /tmp/cirrus-ci-build/src/test/recovery/tm... --- /tmp/cirrus-ci-build/src/test/regress/expected/collate.linux.utf8.out 2025-12-25 17:59:55.060256510 +0000 +++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/collate.linux.utf8.out 2025-12-25 18:09:10.463517315 +0000 @@ -1009,6 +1009,8 @@ CREATE INDEX collate_test1_idx4 ON collate_test1 (((b\|\|'foo') COLLATE "POSIX")); CREATE INDEX collate_test1_idx5 ON collate_test1 (a COLLATE "C"); -- fail ERROR: collations are not supported by type integer +LINE 1: CREATE INDEX collate_test1_idx5 ON collate_test1 (a COLLATE ... + ^ CREATE INDEX collate_test1_idx6 ON collate_test1 ((a COLLATE "C")); -- fail ERROR: collations are not supported by type integer LINE 1: ...ATE INDEX collate_test1_idx6 ON collate_test1 ((a COLLATE "C...
regress	diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/collate.linux.utf8.out /tmp/cirrus-ci-build/src/test/regress/res... --- /tmp/cirrus-ci-build/src/test/regress/expected/collate.linux.utf8.out 2025-12-25 17:59:55.060256510 +0000 +++ /tmp/cirrus-ci-build/src/test/regress/results/collate.linux.utf8.out 2025-12-25 18:04:49.451716928 +0000 @@ -1009,6 +1009,8 @@ CREATE INDEX collate_test1_idx4 ON collate_test1 (((b\|\|'foo') COLLATE "POSIX")); CREATE INDEX collate_test1_idx5 ON collate_test1 (a COLLATE "C"); -- fail ERROR: collations are not supported by type integer +LINE 1: CREATE INDEX collate_test1_idx5 ON collate_test1 (a COLLATE ... + ^ CREATE INDEX collate_test1_idx6 ON collate_test1 ((a COLLATE "C")); -- fail ERROR: collations are not supported by type integer LINE 1: ...ATE INDEX collate_test1_idx6 ON collate_test1 ((a COLLATE "C...
57/6303	refactor handling optional argument in system functions
	Linux - Debian Trixie - Autoconf
regress	diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/r... --- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out 2025-12-25 13:16:53.463167932 +0000 +++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/triggers.out 2025-12-25 13:22:22.420391344 +0000 @@ -2680,952 +2680,10 @@ alter table parent attach partition child2 for values in ('BBB'); -- a child with a different column order create table child3 (b int, a text); -alter table parent attach partition child3 for values in ('CCC'); -create trigger parent_insert_trig - after insert on parent referencing new table as new_table - for each statement execute procedure dump_insert(); -create trigger parent_update_trig - after update on parent referencing old table as old_table new table as new_table - for each statement execute procedure dump_update(); -create trigger parent_delete_trig - after delete on parent referencing old table as old_table - for each statement execute procedure dump_delete(); -create trigger child1_insert_trig - after insert on child1 referencing new table as new_table - for each statement execute procedure dump_insert(); ...
regress	diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/src/test/regress/results/trigg... --- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out 2025-12-25 13:16:53.463167932 +0000 +++ /tmp/cirrus-ci-build/src/test/regress/results/triggers.out 2025-12-25 13:20:54.956452716 +0000 @@ -2541,1091 +2541,10 @@ create table parent (a int primary key, f int references parent) partition by list (a); create table child1 partition of parent for values in (1); -select tgrelid::regclass, rtrim(tgname, '0123456789') as tgname, - tgfoid::regproc, tgenabled - from pg_trigger where tgrelid in ('parent'::regclass, 'child1'::regclass) - order by tgrelid::regclass::text, tgfoid; - tgrelid \| tgname \| tgfoid \| tgenabled ----------+-------------------------+------------------------+----------- - child1 \| RI_ConstraintTrigger_c_ \| "RI_FKey_check_ins" \| O - child1 \| RI_ConstraintTrigger_c_ \| "RI_FKey_check_upd" \| O - child1 \| RI_ConstraintTrigger_a_ \| "RI_FKey_noaction_del" \| O - child1 \| RI_ConstraintTrigger_a_ \| "RI_FKey_noaction_upd" \| O - parent \| RI_ConstraintTrigger_c_ \| "RI_FKey_check_ins" \| O - parent \| RI_ConstraintTrigger_c_ \| "RI_FKey_check_upd" \| O - parent \| RI_ConstraintTrigger_a_ \| "RI_FKey_noaction_del" \| O ...