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.
| 56/6049 |
Adding basic NUMA awareness |
 |
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-09-18 21:44:49.525636000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/postgres_fdw-running/regress/results/postgres_fdw.out 2025-09-18 21:52:16.3310650...
@@ -12685,8 +12685,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
@@ -12702,8 +12701,7 @@
FROM postgres_fdw_get_connections(true);
server_name | closed | remote_backend_pid
-------------+--------+--------------------
- loopback | t | t
-(1 row)
+(0 rows)
... |
| 55/5902 |
Making pg_rewind faster |
|
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-09-18 21:33:17.623803877 +0000
+++ /home/postgres/postgres/build/testrun/isolation/isolation/results/timeouts.out 2025-09-18 21:36:16.382506781 +0000
@@ -78,4 +78,4 @@
step slto: SET lock_timeout = '10s'; 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 |
| 55/5978 |
Add tests for Bitmapset |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/modules/test_bitmapset/expected/test_bitmapset.out /tmp/cirrus-ci-build/build/tes...
--- /tmp/cirrus-ci-build/src/test/modules/test_bitmapset/expected/test_bitmapset.out 2025-09-18 19:14:08.941074692 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_bitmapset/regress/results/test_bitmapset.out 2025-09-18 19:18:27.738130114 +...
@@ -713,11 +713,7 @@
SELECT 'overlap list complex' as test,
test_bms_overlap_list(test_bms_from_array(ARRAY[2,10]), bms_list) as result
FROM test_lists;
- test | result
-----------------------+--------
- overlap list complex | f
-(1 row)
-
+ERROR: negative bitmapset member not allowed
SELECT 'overlap empty list' as test,
test_bms_overlap_list(test_bms_make_singleton(1), ARRAY[]::text[]) as result;
test | result |
|
OpenBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/modules/test_bitmapset/expected/test_bitmapset.out /home/postgres/postgres/bui...
--- /home/postgres/postgres/src/test/modules/test_bitmapset/expected/test_bitmapset.out Thu Sep 18 19:14:21 2025
+++ /home/postgres/postgres/build/testrun/test_bitmapset/regress/results/test_bitmapset.out Thu Sep 18 19:18:23 2025
@@ -713,11 +713,7 @@
SELECT 'overlap list complex' as test,
test_bms_overlap_list(test_bms_from_array(ARRAY[2,10]), bms_list) as result
FROM test_lists;
- test | result
-----------------------+--------
- overlap list complex | f
-(1 row)
-
+ERROR: negative bitmapset member not allowed
SELECT 'overlap empty list' as test,
test_bms_overlap_list(test_bms_make_singleton(1), ARRAY[]::text[]) as result;
test | result |
| 55/5319 |
Changing shared_buffers without restart |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/isolation/expected/multiple-row-versions.out /tmp/cirrus-ci-build/build/testrun/i...
--- /tmp/cirrus-ci-build/src/test/isolation/expected/multiple-row-versions.out 2025-09-18 05:16:11.324093752 +0000
+++ /tmp/cirrus-ci-build/build/testrun/isolation/isolation/results/multiple-row-versions.out 2025-09-18 05:21:08.0281509...
@@ -1,30 +1,7 @@
Parsed test spec with 4 sessions
starting permutation: rx1 wx2 c2 wx3 ry3 wy4 rz4 c4 c3 wz1 c1
-step rx1: SELECT * FROM t WHERE id = 1000000;
- id|txt
--------+---
-1000000|
-(1 row)
-
-step wx2: UPDATE t SET txt = 'b' WHERE id = 1000000;
-step c2: COMMIT;
-step wx3: UPDATE t SET txt = 'c' WHERE id = 1000000;
-step ry3: SELECT * FROM t WHERE id = 500000;
- id|txt
-------+---
-500000|
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/numeric.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg...
--- /tmp/cirrus-ci-build/src/test/regress/expected/numeric.out 2025-09-18 05:16:11.518643177 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/numeric.out 2025-09-18 05:21:00.060067843 ...
@@ -3757,141 +3757,8 @@
SET LOCAL parallel_setup_cost = 0;
SET LOCAL max_parallel_workers_per_gather = 4;
SELECT trim_scale(variance(a) * 1e1000) FROM num_variance;
- trim_scale
-------------
- 12
-(1 row)
-
-ROLLBACK;
--- case where sum of squares would overflow but variance does not
-DELETE FROM num_variance;
-INSERT INTO num_variance SELECT 9e131071 + x FROM generate_series(1, 5) x;
-SELECT variance(a) FROM num_variance;
- variance
---------------------
- 2.5000000000000000
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/numeric.out /tmp/cirrus-ci-build/build/testrun/regress/regress/r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/numeric.out 2025-09-18 05:16:11.518643177 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/numeric.out 2025-09-18 05:20:59.944066975 +0000
@@ -3757,141 +3757,8 @@
SET LOCAL parallel_setup_cost = 0;
SET LOCAL max_parallel_workers_per_gather = 4;
SELECT trim_scale(variance(a) * 1e1000) FROM num_variance;
- trim_scale
-------------
- 12
-(1 row)
-
-ROLLBACK;
--- case where sum of squares would overflow but variance does not
-DELETE FROM num_variance;
-INSERT INTO num_variance SELECT 9e131071 + x FROM generate_series(1, 5) x;
-SELECT variance(a) FROM num_variance;
- variance
---------------------
- 2.5000000000000000
... |
| 56/6065 |
fix re-initialization of LWLock-related shared memory |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/contrib/postgres_fdw/expected/query_cancel.out /home/postgres/postgres/build/testrun/po...
--- /home/postgres/postgres/contrib/postgres_fdw/expected/query_cancel.out 2025-09-17 15:43:30.051640048 +0000
+++ /home/postgres/postgres/build/testrun/postgres_fdw/regress/results/query_cancel.out 2025-09-17 15:49:20.234542632 +0...
@@ -30,5 +30,5 @@
SET LOCAL statement_timeout = '10ms';
-- This would take very long if not canceled:
SELECT count(*) FROM ft1 a CROSS JOIN ft1 b CROSS JOIN ft1 c CROSS JOIN ft1 d;
-ERROR: canceling statement due to statement timeout
+ERROR: canceling statement due to user request
COMMIT; |
| 55/5836 |
SQL:2011 Application Time Update & Delete |
|
Windows - Server 2019, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/for_portion_of.out C:/cirrus/build/testrun/pg_upgrade/0...
--- C:/cirrus/src/test/regress/expected/for_portion_of.out 2025-09-16 23:31:33.478981600 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/for_portion_of.out 2025-09-16 23:34:15.742886400 +000...
@@ -176,7 +176,8 @@
ERROR: function pg_catalog.daterange(integer, integer) does not exist
LINE 2: FOR PORTION OF valid_at FROM 1 TO 4
^
-HINT: No function matches the given name and argument types. You might need to add explicit type casts.
+DETAIL: No function of that name accepts the given argument types.
+HINT: You might need to add explicit type casts.
-- Updating with timestamps reversed fails
UPDATE for_portion_of_test
FOR PORTION OF valid_at FROM '2018-06-01' TO '2018-01-01'
@@ -467,7 +468,8 @@
ERROR: function pg_catalog.daterange(integer, integer) does not exist
LINE 2: FOR PORTION OF valid_at FROM 1 TO 4
^
-HINT: No function matches the given name and argument types. You might need to add explicit type casts.
+DETAIL: No function of that name accepts the given argument types.
+HINT: You might need to add explicit type casts.
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/for_portion_of.out C:/cirrus/build/testrun/recovery/027...
--- C:/cirrus/src/test/regress/expected/for_portion_of.out 2025-09-16 23:31:33.478981600 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/for_portion_of.out 2025-09-16 23:36:52.480247100 +0...
@@ -176,7 +176,8 @@
ERROR: function pg_catalog.daterange(integer, integer) does not exist
LINE 2: FOR PORTION OF valid_at FROM 1 TO 4
^
-HINT: No function matches the given name and argument types. You might need to add explicit type casts.
+DETAIL: No function of that name accepts the given argument types.
+HINT: You might need to add explicit type casts.
-- Updating with timestamps reversed fails
UPDATE for_portion_of_test
FOR PORTION OF valid_at FROM '2018-06-01' TO '2018-01-01'
@@ -467,7 +468,8 @@
ERROR: function pg_catalog.daterange(integer, integer) does not exist
LINE 2: FOR PORTION OF valid_at FROM 1 TO 4
^
-HINT: No function matches the given name and argument types. You might need to add explicit type casts.
+DETAIL: No function of that name accepts the given argument types.
+HINT: You might need to add explicit type casts.
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/for_portion_of.out C:/cirrus/build/testrun/regress/regr...
--- C:/cirrus/src/test/regress/expected/for_portion_of.out 2025-09-16 23:31:33.478981600 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/for_portion_of.out 2025-09-16 23:34:04.952337600 +0000
@@ -176,7 +176,8 @@
ERROR: function pg_catalog.daterange(integer, integer) does not exist
LINE 2: FOR PORTION OF valid_at FROM 1 TO 4
^
-HINT: No function matches the given name and argument types. You might need to add explicit type casts.
+DETAIL: No function of that name accepts the given argument types.
+HINT: You might need to add explicit type casts.
-- Updating with timestamps reversed fails
UPDATE for_portion_of_test
FOR PORTION OF valid_at FROM '2018-06-01' TO '2018-01-01'
@@ -467,7 +468,8 @@
ERROR: function pg_catalog.daterange(integer, integer) does not exist
LINE 2: FOR PORTION OF valid_at FROM 1 TO 4
^
-HINT: No function matches the given name and argument types. You might need to add explicit type casts.
+DETAIL: No function of that name accepts the given argument types.
+HINT: You might need to add explicit type casts.
... |
|
Windows - Server 2019, MinGW64 - Meson |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/for_portion_of.out C:/cirrus/build/testrun/pg_upgrade/0...
--- C:/cirrus/src/test/regress/expected/for_portion_of.out 2025-09-16 23:31:37.843137100 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/for_portion_of.out 2025-09-16 23:37:55.675142900 +000...
@@ -176,7 +176,8 @@
ERROR: function pg_catalog.daterange(integer, integer) does not exist
LINE 2: FOR PORTION OF valid_at FROM 1 TO 4
^
-HINT: No function matches the given name and argument types. You might need to add explicit type casts.
+DETAIL: No function of that name accepts the given argument types.
+HINT: You might need to add explicit type casts.
-- Updating with timestamps reversed fails
UPDATE for_portion_of_test
FOR PORTION OF valid_at FROM '2018-06-01' TO '2018-01-01'
@@ -467,7 +468,8 @@
ERROR: function pg_catalog.daterange(integer, integer) does not exist
LINE 2: FOR PORTION OF valid_at FROM 1 TO 4
^
-HINT: No function matches the given name and argument types. You might need to add explicit type casts.
+DETAIL: No function of that name accepts the given argument types.
+HINT: You might need to add explicit type casts.
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/for_portion_of.out C:/cirrus/build/testrun/recovery/027...
--- C:/cirrus/src/test/regress/expected/for_portion_of.out 2025-09-16 23:31:37.843137100 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/for_portion_of.out 2025-09-16 23:40:39.597496500 +0...
@@ -176,7 +176,8 @@
ERROR: function pg_catalog.daterange(integer, integer) does not exist
LINE 2: FOR PORTION OF valid_at FROM 1 TO 4
^
-HINT: No function matches the given name and argument types. You might need to add explicit type casts.
+DETAIL: No function of that name accepts the given argument types.
+HINT: You might need to add explicit type casts.
-- Updating with timestamps reversed fails
UPDATE for_portion_of_test
FOR PORTION OF valid_at FROM '2018-06-01' TO '2018-01-01'
@@ -467,7 +468,8 @@
ERROR: function pg_catalog.daterange(integer, integer) does not exist
LINE 2: FOR PORTION OF valid_at FROM 1 TO 4
^
-HINT: No function matches the given name and argument types. You might need to add explicit type casts.
+DETAIL: No function of that name accepts the given argument types.
+HINT: You might need to add explicit type casts.
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/for_portion_of.out C:/cirrus/build/testrun/regress/regr...
--- C:/cirrus/src/test/regress/expected/for_portion_of.out 2025-09-16 23:31:37.843137100 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/for_portion_of.out 2025-09-16 23:37:51.972993700 +0000
@@ -176,7 +176,8 @@
ERROR: function pg_catalog.daterange(integer, integer) does not exist
LINE 2: FOR PORTION OF valid_at FROM 1 TO 4
^
-HINT: No function matches the given name and argument types. You might need to add explicit type casts.
+DETAIL: No function of that name accepts the given argument types.
+HINT: You might need to add explicit type casts.
-- Updating with timestamps reversed fails
UPDATE for_portion_of_test
FOR PORTION OF valid_at FROM '2018-06-01' TO '2018-01-01'
@@ -467,7 +468,8 @@
ERROR: function pg_catalog.daterange(integer, integer) does not exist
LINE 2: FOR PORTION OF valid_at FROM 1 TO 4
^
-HINT: No function matches the given name and argument types. You might need to add explicit type casts.
+DETAIL: No function of that name accepts the given argument types.
+HINT: You might need to add explicit type casts.
... |
|
macOS - Sonoma - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/for_portion_of.out /Users/admin/pgsql/build/testrun/pg_upgrade/002...
--- /Users/admin/pgsql/src/test/regress/expected/for_portion_of.out 2025-09-16 23:31:15
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/for_portion_of.out 2025-09-16 23:33:09
@@ -176,7 +176,8 @@
ERROR: function pg_catalog.daterange(integer, integer) does not exist
LINE 2: FOR PORTION OF valid_at FROM 1 TO 4
^
-HINT: No function matches the given name and argument types. You might need to add explicit type casts.
+DETAIL: No function of that name accepts the given argument types.
+HINT: You might need to add explicit type casts.
-- Updating with timestamps reversed fails
UPDATE for_portion_of_test
FOR PORTION OF valid_at FROM '2018-06-01' TO '2018-01-01'
@@ -467,7 +468,8 @@
ERROR: function pg_catalog.daterange(integer, integer) does not exist
LINE 2: FOR PORTION OF valid_at FROM 1 TO 4
^
-HINT: No function matches the given name and argument types. You might need to add explicit type casts.
+DETAIL: No function of that name accepts the given argument types.
+HINT: You might need to add explicit type casts.
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/for_portion_of.out /Users/admin/pgsql/build/testrun/recovery/027_s...
--- /Users/admin/pgsql/src/test/regress/expected/for_portion_of.out 2025-09-16 23:31:15
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/for_portion_of.out 2025-09-16 23:33:52
@@ -176,7 +176,8 @@
ERROR: function pg_catalog.daterange(integer, integer) does not exist
LINE 2: FOR PORTION OF valid_at FROM 1 TO 4
^
-HINT: No function matches the given name and argument types. You might need to add explicit type casts.
+DETAIL: No function of that name accepts the given argument types.
+HINT: You might need to add explicit type casts.
-- Updating with timestamps reversed fails
UPDATE for_portion_of_test
FOR PORTION OF valid_at FROM '2018-06-01' TO '2018-01-01'
@@ -467,7 +468,8 @@
ERROR: function pg_catalog.daterange(integer, integer) does not exist
LINE 2: FOR PORTION OF valid_at FROM 1 TO 4
^
-HINT: No function matches the given name and argument types. You might need to add explicit type casts.
+DETAIL: No function of that name accepts the given argument types.
+HINT: You might need to add explicit type casts.
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/for_portion_of.out /Users/admin/pgsql/build/testrun/regress/regres...
--- /Users/admin/pgsql/src/test/regress/expected/for_portion_of.out 2025-09-16 23:31:15
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/for_portion_of.out 2025-09-16 23:33:09
@@ -176,7 +176,8 @@
ERROR: function pg_catalog.daterange(integer, integer) does not exist
LINE 2: FOR PORTION OF valid_at FROM 1 TO 4
^
-HINT: No function matches the given name and argument types. You might need to add explicit type casts.
+DETAIL: No function of that name accepts the given argument types.
+HINT: You might need to add explicit type casts.
-- Updating with timestamps reversed fails
UPDATE for_portion_of_test
FOR PORTION OF valid_at FROM '2018-06-01' TO '2018-01-01'
@@ -467,7 +468,8 @@
ERROR: function pg_catalog.daterange(integer, integer) does not exist
LINE 2: FOR PORTION OF valid_at FROM 1 TO 4
^
-HINT: No function matches the given name and argument types. You might need to add explicit type casts.
+DETAIL: No function of that name accepts the given argument types.
+HINT: You might need to add explicit type casts.
... |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade...
--- /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out 2025-09-16 23:31:28.272381149 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/for_portion_of.out 2025-09-16 23:36:46.631...
@@ -176,7 +176,8 @@
ERROR: function pg_catalog.daterange(integer, integer) does not exist
LINE 2: FOR PORTION OF valid_at FROM 1 TO 4
^
-HINT: No function matches the given name and argument types. You might need to add explicit type casts.
+DETAIL: No function of that name accepts the given argument types.
+HINT: You might need to add explicit type casts.
-- Updating with timestamps reversed fails
UPDATE for_portion_of_test
FOR PORTION OF valid_at FROM '2018-06-01' TO '2018-01-01'
@@ -467,7 +468,8 @@
ERROR: function pg_catalog.daterange(integer, integer) does not exist
LINE 2: FOR PORTION OF valid_at FROM 1 TO 4
^
-HINT: No function matches the given name and argument types. You might need to add explicit type casts.
+DETAIL: No function of that name accepts the given argument types.
+HINT: You might need to add explicit type casts.
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out /tmp/cirrus-ci-build/build/testrun/recovery/0...
--- /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out 2025-09-16 23:31:28.272381149 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/for_portion_of.out 2025-09-16 23:38:07.2...
@@ -176,7 +176,8 @@
ERROR: function pg_catalog.daterange(integer, integer) does not exist
LINE 2: FOR PORTION OF valid_at FROM 1 TO 4
^
-HINT: No function matches the given name and argument types. You might need to add explicit type casts.
+DETAIL: No function of that name accepts the given argument types.
+HINT: You might need to add explicit type casts.
-- Updating with timestamps reversed fails
UPDATE for_portion_of_test
FOR PORTION OF valid_at FROM '2018-06-01' TO '2018-01-01'
@@ -467,7 +468,8 @@
ERROR: function pg_catalog.daterange(integer, integer) does not exist
LINE 2: FOR PORTION OF valid_at FROM 1 TO 4
^
-HINT: No function matches the given name and argument types. You might need to add explicit type casts.
+DETAIL: No function of that name accepts the given argument types.
+HINT: You might need to add explicit type casts.
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out /tmp/cirrus-ci-build/build/testrun/regress/re...
--- /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out 2025-09-16 23:31:28.272381149 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/for_portion_of.out 2025-09-16 23:36:45.323963556 +0000
@@ -176,7 +176,8 @@
ERROR: function pg_catalog.daterange(integer, integer) does not exist
LINE 2: FOR PORTION OF valid_at FROM 1 TO 4
^
-HINT: No function matches the given name and argument types. You might need to add explicit type casts.
+DETAIL: No function of that name accepts the given argument types.
+HINT: You might need to add explicit type casts.
-- Updating with timestamps reversed fails
UPDATE for_portion_of_test
FOR PORTION OF valid_at FROM '2018-06-01' TO '2018-01-01'
@@ -467,7 +468,8 @@
ERROR: function pg_catalog.daterange(integer, integer) does not exist
LINE 2: FOR PORTION OF valid_at FROM 1 TO 4
^
-HINT: No function matches the given name and argument types. You might need to add explicit type casts.
+DETAIL: No function of that name accepts the given argument types.
+HINT: You might need to add explicit type casts.
... |
|
Linux - Debian Bookworm - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_c...
--- /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out 2025-09-16 23:31:32.306857459 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/for_portion_of.out 2025-09-16 23:40:00.577398766 +0000
@@ -176,7 +176,8 @@
ERROR: function pg_catalog.daterange(integer, integer) does not exist
LINE 2: FOR PORTION OF valid_at FROM 1 TO 4
^
-HINT: No function matches the given name and argument types. You might need to add explicit type casts.
+DETAIL: No function of that name accepts the given argument types.
+HINT: You might need to add explicit type casts.
-- Updating with timestamps reversed fails
UPDATE for_portion_of_test
FOR PORTION OF valid_at FROM '2018-06-01' TO '2018-01-01'
@@ -467,7 +468,8 @@
ERROR: function pg_catalog.daterange(integer, integer) does not exist
LINE 2: FOR PORTION OF valid_at FROM 1 TO 4
^
-HINT: No function matches the given name and argument types. You might need to add explicit type casts.
+DETAIL: No function of that name accepts the given argument types.
+HINT: You might need to add explicit type casts.
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out /tmp/cirrus-ci-build/src/test/recovery/tmp_ch...
--- /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out 2025-09-16 23:31:32.306857459 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/for_portion_of.out 2025-09-16 23:41:42.209019604 +0000
@@ -176,7 +176,8 @@
ERROR: function pg_catalog.daterange(integer, integer) does not exist
LINE 2: FOR PORTION OF valid_at FROM 1 TO 4
^
-HINT: No function matches the given name and argument types. You might need to add explicit type casts.
+DETAIL: No function of that name accepts the given argument types.
+HINT: You might need to add explicit type casts.
-- Updating with timestamps reversed fails
UPDATE for_portion_of_test
FOR PORTION OF valid_at FROM '2018-06-01' TO '2018-01-01'
@@ -467,7 +468,8 @@
ERROR: function pg_catalog.daterange(integer, integer) does not exist
LINE 2: FOR PORTION OF valid_at FROM 1 TO 4
^
-HINT: No function matches the given name and argument types. You might need to add explicit type casts.
+DETAIL: No function of that name accepts the given argument types.
+HINT: You might need to add explicit type casts.
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out /tmp/cirrus-ci-build/src/test/regress/results...
--- /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out 2025-09-16 23:31:32.306857459 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/for_portion_of.out 2025-09-16 23:36:18.616720093 +0000
@@ -176,7 +176,8 @@
ERROR: function pg_catalog.daterange(integer, integer) does not exist
LINE 2: FOR PORTION OF valid_at FROM 1 TO 4
^
-HINT: No function matches the given name and argument types. You might need to add explicit type casts.
+DETAIL: No function of that name accepts the given argument types.
+HINT: You might need to add explicit type casts.
-- Updating with timestamps reversed fails
UPDATE for_portion_of_test
FOR PORTION OF valid_at FROM '2018-06-01' TO '2018-01-01'
@@ -467,7 +468,8 @@
ERROR: function pg_catalog.daterange(integer, integer) does not exist
LINE 2: FOR PORTION OF valid_at FROM 1 TO 4
^
-HINT: No function matches the given name and argument types. You might need to add explicit type casts.
+DETAIL: No function of that name accepts the given argument types.
+HINT: You might need to add explicit type casts.
... |
|
OpenBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/for_portion_of.out /home/postgres/postgres/build/testrun/pg_u...
--- /home/postgres/postgres/src/test/regress/expected/for_portion_of.out Tue Sep 16 23:31:48 2025
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/for_portion_of.out Tue Sep 16 23:35:34 ...
@@ -176,7 +176,8 @@
ERROR: function pg_catalog.daterange(integer, integer) does not exist
LINE 2: FOR PORTION OF valid_at FROM 1 TO 4
^
-HINT: No function matches the given name and argument types. You might need to add explicit type casts.
+DETAIL: No function of that name accepts the given argument types.
+HINT: You might need to add explicit type casts.
-- Updating with timestamps reversed fails
UPDATE for_portion_of_test
FOR PORTION OF valid_at FROM '2018-06-01' TO '2018-01-01'
@@ -467,7 +468,8 @@
ERROR: function pg_catalog.daterange(integer, integer) does not exist
LINE 2: FOR PORTION OF valid_at FROM 1 TO 4
^
-HINT: No function matches the given name and argument types. You might need to add explicit type casts.
+DETAIL: No function of that name accepts the given argument types.
+HINT: You might need to add explicit type casts.
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/for_portion_of.out /home/postgres/postgres/build/testrun/reco...
--- /home/postgres/postgres/src/test/regress/expected/for_portion_of.out Tue Sep 16 23:31:48 2025
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/for_portion_of.out Tue Sep 16 23:37:0...
@@ -176,7 +176,8 @@
ERROR: function pg_catalog.daterange(integer, integer) does not exist
LINE 2: FOR PORTION OF valid_at FROM 1 TO 4
^
-HINT: No function matches the given name and argument types. You might need to add explicit type casts.
+DETAIL: No function of that name accepts the given argument types.
+HINT: You might need to add explicit type casts.
-- Updating with timestamps reversed fails
UPDATE for_portion_of_test
FOR PORTION OF valid_at FROM '2018-06-01' TO '2018-01-01'
@@ -467,7 +468,8 @@
ERROR: function pg_catalog.daterange(integer, integer) does not exist
LINE 2: FOR PORTION OF valid_at FROM 1 TO 4
^
-HINT: No function matches the given name and argument types. You might need to add explicit type casts.
+DETAIL: No function of that name accepts the given argument types.
+HINT: You might need to add explicit type casts.
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/for_portion_of.out /home/postgres/postgres/build/testrun/regr...
--- /home/postgres/postgres/src/test/regress/expected/for_portion_of.out Tue Sep 16 23:31:48 2025
+++ /home/postgres/postgres/build/testrun/regress/regress/results/for_portion_of.out Tue Sep 16 23:35:30 2025
@@ -176,7 +176,8 @@
ERROR: function pg_catalog.daterange(integer, integer) does not exist
LINE 2: FOR PORTION OF valid_at FROM 1 TO 4
^
-HINT: No function matches the given name and argument types. You might need to add explicit type casts.
+DETAIL: No function of that name accepts the given argument types.
+HINT: You might need to add explicit type casts.
-- Updating with timestamps reversed fails
UPDATE for_portion_of_test
FOR PORTION OF valid_at FROM '2018-06-01' TO '2018-01-01'
@@ -467,7 +468,8 @@
ERROR: function pg_catalog.daterange(integer, integer) does not exist
LINE 2: FOR PORTION OF valid_at FROM 1 TO 4
^
-HINT: No function matches the given name and argument types. You might need to add explicit type casts.
+DETAIL: No function of that name accepts the given argument types.
+HINT: You might need to add explicit type casts.
... |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/for_portion_of.out /home/postgres/postgres/build/testrun/pg_u...
--- /home/postgres/postgres/src/test/regress/expected/for_portion_of.out 2025-09-16 23:31:51.509395365 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/for_portion_of.out 2025-09-16 23:34:29....
@@ -176,7 +176,8 @@
ERROR: function pg_catalog.daterange(integer, integer) does not exist
LINE 2: FOR PORTION OF valid_at FROM 1 TO 4
^
-HINT: No function matches the given name and argument types. You might need to add explicit type casts.
+DETAIL: No function of that name accepts the given argument types.
+HINT: You might need to add explicit type casts.
-- Updating with timestamps reversed fails
UPDATE for_portion_of_test
FOR PORTION OF valid_at FROM '2018-06-01' TO '2018-01-01'
@@ -467,7 +468,8 @@
ERROR: function pg_catalog.daterange(integer, integer) does not exist
LINE 2: FOR PORTION OF valid_at FROM 1 TO 4
^
-HINT: No function matches the given name and argument types. You might need to add explicit type casts.
+DETAIL: No function of that name accepts the given argument types.
+HINT: You might need to add explicit type casts.
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/for_portion_of.out /home/postgres/postgres/build/testrun/reco...
--- /home/postgres/postgres/src/test/regress/expected/for_portion_of.out 2025-09-16 23:31:51.509395365 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/for_portion_of.out 2025-09-16 23:35:0...
@@ -176,7 +176,8 @@
ERROR: function pg_catalog.daterange(integer, integer) does not exist
LINE 2: FOR PORTION OF valid_at FROM 1 TO 4
^
-HINT: No function matches the given name and argument types. You might need to add explicit type casts.
+DETAIL: No function of that name accepts the given argument types.
+HINT: You might need to add explicit type casts.
-- Updating with timestamps reversed fails
UPDATE for_portion_of_test
FOR PORTION OF valid_at FROM '2018-06-01' TO '2018-01-01'
@@ -467,7 +468,8 @@
ERROR: function pg_catalog.daterange(integer, integer) does not exist
LINE 2: FOR PORTION OF valid_at FROM 1 TO 4
^
-HINT: No function matches the given name and argument types. You might need to add explicit type casts.
+DETAIL: No function of that name accepts the given argument types.
+HINT: You might need to add explicit type casts.
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/for_portion_of.out /home/postgres/postgres/build/testrun/regr...
--- /home/postgres/postgres/src/test/regress/expected/for_portion_of.out 2025-09-16 23:31:51.509395365 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/for_portion_of.out 2025-09-16 23:34:30.193963124 +0000
@@ -176,7 +176,8 @@
ERROR: function pg_catalog.daterange(integer, integer) does not exist
LINE 2: FOR PORTION OF valid_at FROM 1 TO 4
^
-HINT: No function matches the given name and argument types. You might need to add explicit type casts.
+DETAIL: No function of that name accepts the given argument types.
+HINT: You might need to add explicit type casts.
-- Updating with timestamps reversed fails
UPDATE for_portion_of_test
FOR PORTION OF valid_at FROM '2018-06-01' TO '2018-01-01'
@@ -467,7 +468,8 @@
ERROR: function pg_catalog.daterange(integer, integer) does not exist
LINE 2: FOR PORTION OF valid_at FROM 1 TO 4
^
-HINT: No function matches the given name and argument types. You might need to add explicit type casts.
+DETAIL: No function of that name accepts the given argument types.
+HINT: You might need to add explicit type casts.
... |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade...
--- /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out 2025-09-16 23:31:27.709716000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/for_portion_of.out 2025-09-16 23:33:59.951...
@@ -176,7 +176,8 @@
ERROR: function pg_catalog.daterange(integer, integer) does not exist
LINE 2: FOR PORTION OF valid_at FROM 1 TO 4
^
-HINT: No function matches the given name and argument types. You might need to add explicit type casts.
+DETAIL: No function of that name accepts the given argument types.
+HINT: You might need to add explicit type casts.
-- Updating with timestamps reversed fails
UPDATE for_portion_of_test
FOR PORTION OF valid_at FROM '2018-06-01' TO '2018-01-01'
@@ -467,7 +468,8 @@
ERROR: function pg_catalog.daterange(integer, integer) does not exist
LINE 2: FOR PORTION OF valid_at FROM 1 TO 4
^
-HINT: No function matches the given name and argument types. You might need to add explicit type casts.
+DETAIL: No function of that name accepts the given argument types.
+HINT: You might need to add explicit type casts.
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out /tmp/cirrus-ci-build/build/testrun/recovery/0...
--- /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out 2025-09-16 23:31:27.709716000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/for_portion_of.out 2025-09-16 23:35:04.1...
@@ -176,7 +176,8 @@
ERROR: function pg_catalog.daterange(integer, integer) does not exist
LINE 2: FOR PORTION OF valid_at FROM 1 TO 4
^
-HINT: No function matches the given name and argument types. You might need to add explicit type casts.
+DETAIL: No function of that name accepts the given argument types.
+HINT: You might need to add explicit type casts.
-- Updating with timestamps reversed fails
UPDATE for_portion_of_test
FOR PORTION OF valid_at FROM '2018-06-01' TO '2018-01-01'
@@ -467,7 +468,8 @@
ERROR: function pg_catalog.daterange(integer, integer) does not exist
LINE 2: FOR PORTION OF valid_at FROM 1 TO 4
^
-HINT: No function matches the given name and argument types. You might need to add explicit type casts.
+DETAIL: No function of that name accepts the given argument types.
+HINT: You might need to add explicit type casts.
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out /tmp/cirrus-ci-build/build/testrun/regress/re...
--- /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out 2025-09-16 23:31:27.709716000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/for_portion_of.out 2025-09-16 23:34:02.772051000 +0000
@@ -176,7 +176,8 @@
ERROR: function pg_catalog.daterange(integer, integer) does not exist
LINE 2: FOR PORTION OF valid_at FROM 1 TO 4
^
-HINT: No function matches the given name and argument types. You might need to add explicit type casts.
+DETAIL: No function of that name accepts the given argument types.
+HINT: You might need to add explicit type casts.
-- Updating with timestamps reversed fails
UPDATE for_portion_of_test
FOR PORTION OF valid_at FROM '2018-06-01' TO '2018-01-01'
@@ -467,7 +468,8 @@
ERROR: function pg_catalog.daterange(integer, integer) does not exist
LINE 2: FOR PORTION OF valid_at FROM 1 TO 4
^
-HINT: No function matches the given name and argument types. You might need to add explicit type casts.
+DETAIL: No function of that name accepts the given argument types.
+HINT: You might need to add explicit type casts.
... |
| 55/5755 |
Parallel processing of indexes in autovacuum |
|
Windows - Server 2019, MinGW64 - Meson |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/isolation/expected/lock-update-traversal.out C:/cirrus/build/testrun/iso...
--- C:/cirrus/src/test/isolation/expected/lock-update-traversal.out 2025-09-15 22:23:15.786094300 +0000
+++ C:/cirrus/build/testrun/isolation/isolation/results/lock-update-traversal.out 2025-09-15 22:30:23.471166700 +0000
@@ -1,63 +1,6 @@
Parsed test spec with 2 sessions
starting permutation: s1b s2b s1s s2u s1l s2c s2d1 s1c
-step s1b: BEGIN ISOLATION LEVEL REPEATABLE READ;
-step s2b: BEGIN;
-step s1s: SELECT * FROM foo;
-key|value
----+-----
- 1| 1
-(1 row)
-
-step s2u: UPDATE foo SET value = 2 WHERE key = 1;
-step s1l: SELECT * FROM foo FOR KEY SHARE;
-key|value
----+-----
- 1| 1
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/vacuum_parallel.out C:/cirrus/build/testrun/pg_upgrade/...
--- C:/cirrus/src/test/regress/expected/vacuum_parallel.out 2025-09-15 22:23:16.734780000 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/vacuum_parallel.out 2025-09-15 22:29:51.752880000 +00...
@@ -43,7 +43,7 @@
-- Since vacuum_in_leader_small_index uses deduplication, we expect an
-- assertion failure with bug #17245 (in the absence of bugfix):
INSERT INTO parallel_vacuum_table SELECT i FROM generate_series(1, 10000) i;
-RESET max_parallel_maintenance_workers;
-RESET min_parallel_index_scan_size;
--- Deliberately don't drop table, to get further coverage from tools like
--- pg_amcheck in some testing scenarios
+server closed the connection unexpectedly
+ This probably means the server terminated abnormally
+ before or while processing the request.
+connection to server was lost
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/maintain_every.out C:/cirrus/build/testrun/pg_upgrade/0...
--- C:/cirrus/src/test/regress/expected/maintain_every.out 2025-09-15 22:23:16.601449500 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/maintain_every.out 2025-09-15 22:29:51.862271400 +000...
@@ -1,33 +1,2 @@
--- Test maintenance commands that visit every eligible relation. Run as a
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/vacuum_parallel.out C:/cirrus/build/testrun/recovery/02...
--- C:/cirrus/src/test/regress/expected/vacuum_parallel.out 2025-09-15 22:23:16.734780000 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/vacuum_parallel.out 2025-09-15 22:32:29.244642300 +...
@@ -43,7 +43,7 @@
-- Since vacuum_in_leader_small_index uses deduplication, we expect an
-- assertion failure with bug #17245 (in the absence of bugfix):
INSERT INTO parallel_vacuum_table SELECT i FROM generate_series(1, 10000) i;
-RESET max_parallel_maintenance_workers;
-RESET min_parallel_index_scan_size;
--- Deliberately don't drop table, to get further coverage from tools like
--- pg_amcheck in some testing scenarios
+server closed the connection unexpectedly
+ This probably means the server terminated abnormally
+ before or while processing the request.
+connection to server was lost
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/maintain_every.out C:/cirrus/build/testrun/recovery/027...
--- C:/cirrus/src/test/regress/expected/maintain_every.out 2025-09-15 22:23:16.601449500 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/maintain_every.out 2025-09-15 22:32:29.459765600 +0...
@@ -1,33 +1,2 @@
--- Test maintenance commands that visit every eligible relation. Run as a
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/vacuum_parallel.out C:/cirrus/build/testrun/regress/reg...
--- C:/cirrus/src/test/regress/expected/vacuum_parallel.out 2025-09-15 22:23:16.734780000 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/vacuum_parallel.out 2025-09-15 22:29:51.631308200 +0000
@@ -43,7 +43,7 @@
-- Since vacuum_in_leader_small_index uses deduplication, we expect an
-- assertion failure with bug #17245 (in the absence of bugfix):
INSERT INTO parallel_vacuum_table SELECT i FROM generate_series(1, 10000) i;
-RESET max_parallel_maintenance_workers;
-RESET min_parallel_index_scan_size;
--- Deliberately don't drop table, to get further coverage from tools like
--- pg_amcheck in some testing scenarios
+server closed the connection unexpectedly
+ This probably means the server terminated abnormally
+ before or while processing the request.
+connection to server was lost
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/maintain_every.out C:/cirrus/build/testrun/regress/regr...
--- C:/cirrus/src/test/regress/expected/maintain_every.out 2025-09-15 22:23:16.601449500 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/maintain_every.out 2025-09-15 22:29:51.814895800 +0000
@@ -1,33 +1,2 @@
--- Test maintenance commands that visit every eligible relation. Run as a
... |
|
macOS - Sonoma - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/isolation/expected/lock-update-traversal.out /Users/admin/pgsql/build/testrun/isola...
--- /Users/admin/pgsql/src/test/isolation/expected/lock-update-traversal.out 2025-09-15 22:22:07
+++ /Users/admin/pgsql/build/testrun/isolation/isolation/results/lock-update-traversal.out 2025-09-15 22:24:40
@@ -1,63 +1,6 @@
Parsed test spec with 2 sessions
starting permutation: s1b s2b s1s s2u s1l s2c s2d1 s1c
-step s1b: BEGIN ISOLATION LEVEL REPEATABLE READ;
-step s2b: BEGIN;
-step s1s: SELECT * FROM foo;
-key|value
----+-----
- 1| 1
-(1 row)
-
-step s2u: UPDATE foo SET value = 2 WHERE key = 1;
-step s1l: SELECT * FROM foo FOR KEY SHARE;
-key|value
----+-----
- 1| 1
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/vacuum_parallel.out /Users/admin/pgsql/build/testrun/pg_upgrade/00...
--- /Users/admin/pgsql/src/test/regress/expected/vacuum_parallel.out 2025-09-15 22:22:07
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/vacuum_parallel.out 2025-09-15 22:24:40
@@ -43,7 +43,7 @@
-- Since vacuum_in_leader_small_index uses deduplication, we expect an
-- assertion failure with bug #17245 (in the absence of bugfix):
INSERT INTO parallel_vacuum_table SELECT i FROM generate_series(1, 10000) i;
-RESET max_parallel_maintenance_workers;
-RESET min_parallel_index_scan_size;
--- Deliberately don't drop table, to get further coverage from tools like
--- pg_amcheck in some testing scenarios
+server closed the connection unexpectedly
+ This probably means the server terminated abnormally
+ before or while processing the request.
+connection to server was lost
diff -U3 /Users/admin/pgsql/src/test/regress/expected/maintain_every.out /Users/admin/pgsql/build/testrun/pg_upgrade/002...
--- /Users/admin/pgsql/src/test/regress/expected/maintain_every.out 2025-09-15 22:22:07
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/maintain_every.out 2025-09-15 22:24:41
@@ -1,33 +1,2 @@
--- Test maintenance commands that visit every eligible relation. Run as a
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/vacuum_parallel.out /Users/admin/pgsql/build/testrun/recovery/027_...
--- /Users/admin/pgsql/src/test/regress/expected/vacuum_parallel.out 2025-09-15 22:22:07
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/vacuum_parallel.out 2025-09-15 22:25:26
@@ -43,7 +43,7 @@
-- Since vacuum_in_leader_small_index uses deduplication, we expect an
-- assertion failure with bug #17245 (in the absence of bugfix):
INSERT INTO parallel_vacuum_table SELECT i FROM generate_series(1, 10000) i;
-RESET max_parallel_maintenance_workers;
-RESET min_parallel_index_scan_size;
--- Deliberately don't drop table, to get further coverage from tools like
--- pg_amcheck in some testing scenarios
+server closed the connection unexpectedly
+ This probably means the server terminated abnormally
+ before or while processing the request.
+connection to server was lost
diff -U3 /Users/admin/pgsql/src/test/regress/expected/maintain_every.out /Users/admin/pgsql/build/testrun/recovery/027_s...
--- /Users/admin/pgsql/src/test/regress/expected/maintain_every.out 2025-09-15 22:22:07
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/maintain_every.out 2025-09-15 22:25:26
@@ -1,33 +1,2 @@
--- Test maintenance commands that visit every eligible relation. Run as a
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/vacuum_parallel.out /Users/admin/pgsql/build/testrun/regress/regre...
--- /Users/admin/pgsql/src/test/regress/expected/vacuum_parallel.out 2025-09-15 22:22:07
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/vacuum_parallel.out 2025-09-15 22:24:40
@@ -43,7 +43,7 @@
-- Since vacuum_in_leader_small_index uses deduplication, we expect an
-- assertion failure with bug #17245 (in the absence of bugfix):
INSERT INTO parallel_vacuum_table SELECT i FROM generate_series(1, 10000) i;
-RESET max_parallel_maintenance_workers;
-RESET min_parallel_index_scan_size;
--- Deliberately don't drop table, to get further coverage from tools like
--- pg_amcheck in some testing scenarios
+server closed the connection unexpectedly
+ This probably means the server terminated abnormally
+ before or while processing the request.
+connection to server was lost
diff -U3 /Users/admin/pgsql/src/test/regress/expected/maintain_every.out /Users/admin/pgsql/build/testrun/regress/regres...
--- /Users/admin/pgsql/src/test/regress/expected/maintain_every.out 2025-09-15 22:22:07
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/maintain_every.out 2025-09-15 22:24:41
@@ -1,33 +1,2 @@
--- Test maintenance commands that visit every eligible relation. Run as a
... |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/isolation/expected/lock-update-traversal.out /tmp/cirrus-ci-build/build/testrun/i...
--- /tmp/cirrus-ci-build/src/test/isolation/expected/lock-update-traversal.out 2025-09-15 22:23:00.156555852 +0000
+++ /tmp/cirrus-ci-build/build/testrun/isolation/isolation/results/lock-update-traversal.out 2025-09-15 22:28:32.2016242...
@@ -1,63 +1,6 @@
Parsed test spec with 2 sessions
starting permutation: s1b s2b s1s s2u s1l s2c s2d1 s1c
-step s1b: BEGIN ISOLATION LEVEL REPEATABLE READ;
-step s2b: BEGIN;
-step s1s: SELECT * FROM foo;
-key|value
----+-----
- 1| 1
-(1 row)
-
-step s2u: UPDATE foo SET value = 2 WHERE key = 1;
-step s1l: SELECT * FROM foo FOR KEY SHARE;
-key|value
----+-----
- 1| 1
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/vacuum_parallel.out /tmp/cirrus-ci-build/build/testrun/pg_upgrad...
--- /tmp/cirrus-ci-build/src/test/regress/expected/vacuum_parallel.out 2025-09-15 22:23:00.400821501 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/vacuum_parallel.out 2025-09-15 22:28:48.80...
@@ -43,7 +43,7 @@
-- Since vacuum_in_leader_small_index uses deduplication, we expect an
-- assertion failure with bug #17245 (in the absence of bugfix):
INSERT INTO parallel_vacuum_table SELECT i FROM generate_series(1, 10000) i;
-RESET max_parallel_maintenance_workers;
-RESET min_parallel_index_scan_size;
--- Deliberately don't drop table, to get further coverage from tools like
--- pg_amcheck in some testing scenarios
+server closed the connection unexpectedly
+ This probably means the server terminated abnormally
+ before or while processing the request.
+connection to server was lost
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/publication.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/00...
--- /tmp/cirrus-ci-build/src/test/regress/expected/publication.out 2025-09-15 22:23:00.368786661 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/publication.out 2025-09-15 22:28:49.385635...
@@ -359,1643 +359,10 @@
"public.testpub_rf_tbl3" WHERE ((e > 300) AND (e < 500))
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/vacuum_parallel.out /tmp/cirrus-ci-build/build/testrun/recovery/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/vacuum_parallel.out 2025-09-15 22:23:00.400821501 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/vacuum_parallel.out 2025-09-15 22:29:45....
@@ -43,7 +43,7 @@
-- Since vacuum_in_leader_small_index uses deduplication, we expect an
-- assertion failure with bug #17245 (in the absence of bugfix):
INSERT INTO parallel_vacuum_table SELECT i FROM generate_series(1, 10000) i;
-RESET max_parallel_maintenance_workers;
-RESET min_parallel_index_scan_size;
--- Deliberately don't drop table, to get further coverage from tools like
--- pg_amcheck in some testing scenarios
+server closed the connection unexpectedly
+ This probably means the server terminated abnormally
+ before or while processing the request.
+connection to server was lost
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/maintain_every.out /tmp/cirrus-ci-build/build/testrun/recovery/0...
--- /tmp/cirrus-ci-build/src/test/regress/expected/maintain_every.out 2025-09-15 22:23:00.344760533 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/maintain_every.out 2025-09-15 22:29:45.0...
@@ -10,24 +10,10 @@
CREATE TEMP TABLE past_inh_db_child () INHERITS (past_inh_db_parent);
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/vacuum_parallel.out /tmp/cirrus-ci-build/build/testrun/regress/r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/vacuum_parallel.out 2025-09-15 22:23:00.400821501 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/vacuum_parallel.out 2025-09-15 22:28:47.697634118 +0000
@@ -43,7 +43,7 @@
-- Since vacuum_in_leader_small_index uses deduplication, we expect an
-- assertion failure with bug #17245 (in the absence of bugfix):
INSERT INTO parallel_vacuum_table SELECT i FROM generate_series(1, 10000) i;
-RESET max_parallel_maintenance_workers;
-RESET min_parallel_index_scan_size;
--- Deliberately don't drop table, to get further coverage from tools like
--- pg_amcheck in some testing scenarios
+server closed the connection unexpectedly
+ This probably means the server terminated abnormally
+ before or while processing the request.
+connection to server was lost
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/maintain_every.out /tmp/cirrus-ci-build/build/testrun/regress/re...
--- /tmp/cirrus-ci-build/src/test/regress/expected/maintain_every.out 2025-09-15 22:23:00.344760533 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/maintain_every.out 2025-09-15 22:28:48.289634529 +0000
@@ -29,5 +29,10 @@
(1 row)
... |
|
Windows - Server 2019, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/isolation/expected/lock-update-traversal.out C:/cirrus/build/testrun/iso...
--- C:/cirrus/src/test/isolation/expected/lock-update-traversal.out 2025-09-15 22:23:04.086182400 +0000
+++ C:/cirrus/build/testrun/isolation/isolation/results/lock-update-traversal.out 2025-09-15 22:26:43.625336300 +0000
@@ -1,63 +1,6 @@
Parsed test spec with 2 sessions
starting permutation: s1b s2b s1s s2u s1l s2c s2d1 s1c
-step s1b: BEGIN ISOLATION LEVEL REPEATABLE READ;
-step s2b: BEGIN;
-step s1s: SELECT * FROM foo;
-key|value
----+-----
- 1| 1
-(1 row)
-
-step s2u: UPDATE foo SET value = 2 WHERE key = 1;
-step s1l: SELECT * FROM foo FOR KEY SHARE;
-key|value
----+-----
- 1| 1
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/vacuum_parallel.out C:/cirrus/build/testrun/pg_upgrade/...
--- C:/cirrus/src/test/regress/expected/vacuum_parallel.out 2025-09-15 22:23:05.052149700 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/vacuum_parallel.out 2025-09-15 22:27:00.068707700 +00...
@@ -43,7 +43,7 @@
-- Since vacuum_in_leader_small_index uses deduplication, we expect an
-- assertion failure with bug #17245 (in the absence of bugfix):
INSERT INTO parallel_vacuum_table SELECT i FROM generate_series(1, 10000) i;
-RESET max_parallel_maintenance_workers;
-RESET min_parallel_index_scan_size;
--- Deliberately don't drop table, to get further coverage from tools like
--- pg_amcheck in some testing scenarios
+server closed the connection unexpectedly
+ This probably means the server terminated abnormally
+ before or while processing the request.
+connection to server was lost
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/maintain_every.out C:/cirrus/build/testrun/pg_upgrade/0...
--- C:/cirrus/src/test/regress/expected/maintain_every.out 2025-09-15 22:23:04.924232900 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/maintain_every.out 2025-09-15 22:27:00.252248300 +000...
@@ -1,33 +1,2 @@
--- Test maintenance commands that visit every eligible relation. Run as a
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/vacuum_parallel.out C:/cirrus/build/testrun/recovery/02...
--- C:/cirrus/src/test/regress/expected/vacuum_parallel.out 2025-09-15 22:23:05.052149700 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/vacuum_parallel.out 2025-09-15 22:29:34.407087300 +...
@@ -43,7 +43,7 @@
-- Since vacuum_in_leader_small_index uses deduplication, we expect an
-- assertion failure with bug #17245 (in the absence of bugfix):
INSERT INTO parallel_vacuum_table SELECT i FROM generate_series(1, 10000) i;
-RESET max_parallel_maintenance_workers;
-RESET min_parallel_index_scan_size;
--- Deliberately don't drop table, to get further coverage from tools like
--- pg_amcheck in some testing scenarios
+server closed the connection unexpectedly
+ This probably means the server terminated abnormally
+ before or while processing the request.
+connection to server was lost
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/maintain_every.out C:/cirrus/build/testrun/recovery/027...
--- C:/cirrus/src/test/regress/expected/maintain_every.out 2025-09-15 22:23:04.924232900 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/maintain_every.out 2025-09-15 22:29:34.803576300 +0...
@@ -1,33 +1,2 @@
--- Test maintenance commands that visit every eligible relation. Run as a
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/vacuum_parallel.out C:/cirrus/build/testrun/regress/reg...
--- C:/cirrus/src/test/regress/expected/vacuum_parallel.out 2025-09-15 22:23:05.052149700 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/vacuum_parallel.out 2025-09-15 22:26:51.056975100 +0000
@@ -43,7 +43,7 @@
-- Since vacuum_in_leader_small_index uses deduplication, we expect an
-- assertion failure with bug #17245 (in the absence of bugfix):
INSERT INTO parallel_vacuum_table SELECT i FROM generate_series(1, 10000) i;
-RESET max_parallel_maintenance_workers;
-RESET min_parallel_index_scan_size;
--- Deliberately don't drop table, to get further coverage from tools like
--- pg_amcheck in some testing scenarios
+server closed the connection unexpectedly
+ This probably means the server terminated abnormally
+ before or while processing the request.
+connection to server was lost
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/maintain_every.out C:/cirrus/build/testrun/regress/regr...
--- C:/cirrus/src/test/regress/expected/maintain_every.out 2025-09-15 22:23:04.924232900 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/maintain_every.out 2025-09-15 22:26:52.342890700 +0000
@@ -1,33 +1,2 @@
--- Test maintenance commands that visit every eligible relation. Run as a
... |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/isolation/expected/insert-conflict-do-nothing-2.out /tmp/cirrus-ci-build/build/te...
--- /tmp/cirrus-ci-build/src/test/isolation/expected/insert-conflict-do-nothing-2.out 2025-09-15 22:23:00.588928000 +000...
+++ /tmp/cirrus-ci-build/build/testrun/isolation/isolation/results/insert-conflict-do-nothing-2.out 2025-09-15 22:25:59....
@@ -61,61 +61,6 @@
starting permutation: begins1 begins2 donothing1 c1 donothing2 c2 show
-step begins1: BEGIN ISOLATION LEVEL SERIALIZABLE;
-step begins2: BEGIN ISOLATION LEVEL SERIALIZABLE;
-step donothing1: INSERT INTO ints(key, val) VALUES(1, 'donothing1') ON CONFLICT DO NOTHING;
-step c1: COMMIT;
-step donothing2: INSERT INTO ints(key, val) VALUES(1, 'donothing2'), (1, 'donothing3') ON CONFLICT DO NOTHING;
-step c2: COMMIT;
-step show: SELECT * FROM ints;
-key|val
----+----------
- 1|donothing1
-(1 row)
-
-
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/vacuum_parallel.out /tmp/cirrus-ci-build/build/testrun/pg_upgrad...
--- /tmp/cirrus-ci-build/src/test/regress/expected/vacuum_parallel.out 2025-09-15 22:23:00.782241000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/vacuum_parallel.out 2025-09-15 22:26:48.90...
@@ -43,7 +43,7 @@
-- Since vacuum_in_leader_small_index uses deduplication, we expect an
-- assertion failure with bug #17245 (in the absence of bugfix):
INSERT INTO parallel_vacuum_table SELECT i FROM generate_series(1, 10000) i;
-RESET max_parallel_maintenance_workers;
-RESET min_parallel_index_scan_size;
--- Deliberately don't drop table, to get further coverage from tools like
--- pg_amcheck in some testing scenarios
+server closed the connection unexpectedly
+ This probably means the server terminated abnormally
+ before or while processing the request.
+connection to server was lost
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/maintain_every.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade...
--- /tmp/cirrus-ci-build/src/test/regress/expected/maintain_every.out 2025-09-15 22:23:00.733664000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/maintain_every.out 2025-09-15 22:26:48.929...
@@ -1,33 +1,2 @@
--- Test maintenance commands that visit every eligible relation. Run as a
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/vacuum_parallel.out /tmp/cirrus-ci-build/build/testrun/recovery/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/vacuum_parallel.out 2025-09-15 22:23:00.782241000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/vacuum_parallel.out 2025-09-15 22:27:52....
@@ -43,7 +43,7 @@
-- Since vacuum_in_leader_small_index uses deduplication, we expect an
-- assertion failure with bug #17245 (in the absence of bugfix):
INSERT INTO parallel_vacuum_table SELECT i FROM generate_series(1, 10000) i;
-RESET max_parallel_maintenance_workers;
-RESET min_parallel_index_scan_size;
--- Deliberately don't drop table, to get further coverage from tools like
--- pg_amcheck in some testing scenarios
+server closed the connection unexpectedly
+ This probably means the server terminated abnormally
+ before or while processing the request.
+connection to server was lost
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/maintain_every.out /tmp/cirrus-ci-build/build/testrun/recovery/0...
--- /tmp/cirrus-ci-build/src/test/regress/expected/maintain_every.out 2025-09-15 22:23:00.733664000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/maintain_every.out 2025-09-15 22:27:52.9...
@@ -1,33 +1,3 @@
--- Test maintenance commands that visit every eligible relation. Run as a
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/vacuum_parallel.out /tmp/cirrus-ci-build/build/testrun/regress/r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/vacuum_parallel.out 2025-09-15 22:23:00.782241000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/vacuum_parallel.out 2025-09-15 22:26:50.707521000 +0000
@@ -43,7 +43,7 @@
-- Since vacuum_in_leader_small_index uses deduplication, we expect an
-- assertion failure with bug #17245 (in the absence of bugfix):
INSERT INTO parallel_vacuum_table SELECT i FROM generate_series(1, 10000) i;
-RESET max_parallel_maintenance_workers;
-RESET min_parallel_index_scan_size;
--- Deliberately don't drop table, to get further coverage from tools like
--- pg_amcheck in some testing scenarios
+server closed the connection unexpectedly
+ This probably means the server terminated abnormally
+ before or while processing the request.
+connection to server was lost
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/maintain_every.out /tmp/cirrus-ci-build/build/testrun/regress/re...
--- /tmp/cirrus-ci-build/src/test/regress/expected/maintain_every.out 2025-09-15 22:23:00.733664000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/maintain_every.out 2025-09-15 22:26:50.804829000 +0000
@@ -1,33 +1 @@
--- Test maintenance commands that visit every eligible relation. Run as a
... |
|
Linux - Debian Bookworm - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/vacuum_parallel.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/vacuum_parallel.out 2025-09-15 22:23:06.484096248 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/vacuum_parallel.out 2025-09-15 22:30:53.683514792 +0000
@@ -43,7 +43,7 @@
-- Since vacuum_in_leader_small_index uses deduplication, we expect an
-- assertion failure with bug #17245 (in the absence of bugfix):
INSERT INTO parallel_vacuum_table SELECT i FROM generate_series(1, 10000) i;
-RESET max_parallel_maintenance_workers;
-RESET min_parallel_index_scan_size;
--- Deliberately don't drop table, to get further coverage from tools like
--- pg_amcheck in some testing scenarios
+server closed the connection unexpectedly
+ This probably means the server terminated abnormally
+ before or while processing the request.
+connection to server was lost
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/publication.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_chec...
--- /tmp/cirrus-ci-build/src/test/regress/expected/publication.out 2025-09-15 22:23:06.456096247 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/publication.out 2025-09-15 22:30:54.359514534 +0000
@@ -96,1906 +96,10 @@
RESET client_min_messages;
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/isolation/expected/lock-update-traversal.out /tmp/cirrus-ci-build/src/test/isolat...
--- /tmp/cirrus-ci-build/src/test/isolation/expected/lock-update-traversal.out 2025-09-15 22:23:06.240096243 +0000
+++ /tmp/cirrus-ci-build/src/test/isolation/output_iso/results/lock-update-traversal.out 2025-09-15 22:28:29.111580817 +...
@@ -1,63 +1,6 @@
Parsed test spec with 2 sessions
starting permutation: s1b s2b s1s s2u s1l s2c s2d1 s1c
-step s1b: BEGIN ISOLATION LEVEL REPEATABLE READ;
-step s2b: BEGIN;
-step s1s: SELECT * FROM foo;
-key|value
----+-----
- 1| 1
-(1 row)
-
-step s2u: UPDATE foo SET value = 2 WHERE key = 1;
-step s1l: SELECT * FROM foo FOR KEY SHARE;
-key|value
----+-----
- 1| 1
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/vacuum_parallel.out /tmp/cirrus-ci-build/src/test/recovery/tmp_c...
--- /tmp/cirrus-ci-build/src/test/regress/expected/vacuum_parallel.out 2025-09-15 22:23:06.484096248 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/vacuum_parallel.out 2025-09-15 22:32:38.367394020 +0000
@@ -43,7 +43,7 @@
-- Since vacuum_in_leader_small_index uses deduplication, we expect an
-- assertion failure with bug #17245 (in the absence of bugfix):
INSERT INTO parallel_vacuum_table SELECT i FROM generate_series(1, 10000) i;
-RESET max_parallel_maintenance_workers;
-RESET min_parallel_index_scan_size;
--- Deliberately don't drop table, to get further coverage from tools like
--- pg_amcheck in some testing scenarios
+server closed the connection unexpectedly
+ This probably means the server terminated abnormally
+ before or while processing the request.
+connection to server was lost
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/maintain_every.out /tmp/cirrus-ci-build/src/test/recovery/tmp_ch...
--- /tmp/cirrus-ci-build/src/test/regress/expected/maintain_every.out 2025-09-15 22:23:06.428096247 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/maintain_every.out 2025-09-15 22:32:38.539393857 +0000
@@ -20,14 +20,7 @@
DROP TABLE past_inh_db_child;
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/vacuum_parallel.out /tmp/cirrus-ci-build/src/test/regress/result...
--- /tmp/cirrus-ci-build/src/test/regress/expected/vacuum_parallel.out 2025-09-15 22:23:06.484096248 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/vacuum_parallel.out 2025-09-15 22:28:55.919565676 +0000
@@ -43,7 +43,7 @@
-- Since vacuum_in_leader_small_index uses deduplication, we expect an
-- assertion failure with bug #17245 (in the absence of bugfix):
INSERT INTO parallel_vacuum_table SELECT i FROM generate_series(1, 10000) i;
-RESET max_parallel_maintenance_workers;
-RESET min_parallel_index_scan_size;
--- Deliberately don't drop table, to get further coverage from tools like
--- pg_amcheck in some testing scenarios
+server closed the connection unexpectedly
+ This probably means the server terminated abnormally
+ before or while processing the request.
+connection to server was lost
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/publication.out /tmp/cirrus-ci-build/src/test/regress/results/pu...
--- /tmp/cirrus-ci-build/src/test/regress/expected/publication.out 2025-09-15 22:23:06.456096247 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/publication.out 2025-09-15 22:28:56.679565278 +0000
@@ -59,1943 +59,10 @@
--- adding tables
... |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/isolation/expected/lock-update-traversal.out /home/postgres/postgres/build/tes...
--- /home/postgres/postgres/src/test/isolation/expected/lock-update-traversal.out 2025-09-15 22:23:27.151332966 +0000
+++ /home/postgres/postgres/build/testrun/isolation/isolation/results/lock-update-traversal.out 2025-09-15 22:26:29.8718...
@@ -1,63 +1,6 @@
Parsed test spec with 2 sessions
starting permutation: s1b s2b s1s s2u s1l s2c s2d1 s1c
-step s1b: BEGIN ISOLATION LEVEL REPEATABLE READ;
-step s2b: BEGIN;
-step s1s: SELECT * FROM foo;
-key|value
----+-----
- 1| 1
-(1 row)
-
-step s2u: UPDATE foo SET value = 2 WHERE key = 1;
-step s1l: SELECT * FROM foo FOR KEY SHARE;
-key|value
----+-----
- 1| 1
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/vacuum_parallel.out /home/postgres/postgres/build/testrun/pg_...
--- /home/postgres/postgres/src/test/regress/expected/vacuum_parallel.out 2025-09-15 22:23:28.424991047 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/vacuum_parallel.out 2025-09-15 22:26:41...
@@ -43,7 +43,7 @@
-- Since vacuum_in_leader_small_index uses deduplication, we expect an
-- assertion failure with bug #17245 (in the absence of bugfix):
INSERT INTO parallel_vacuum_table SELECT i FROM generate_series(1, 10000) i;
-RESET max_parallel_maintenance_workers;
-RESET min_parallel_index_scan_size;
--- Deliberately don't drop table, to get further coverage from tools like
--- pg_amcheck in some testing scenarios
+server closed the connection unexpectedly
+ This probably means the server terminated abnormally
+ before or while processing the request.
+connection to server was lost
diff -U3 /home/postgres/postgres/src/test/regress/expected/maintain_every.out /home/postgres/postgres/build/testrun/pg_u...
--- /home/postgres/postgres/src/test/regress/expected/maintain_every.out 2025-09-15 22:23:28.276109321 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/maintain_every.out 2025-09-15 22:26:41....
@@ -1,33 +1,3 @@
--- Test maintenance commands that visit every eligible relation. Run as a
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/vacuum_parallel.out /home/postgres/postgres/build/testrun/rec...
--- /home/postgres/postgres/src/test/regress/expected/vacuum_parallel.out 2025-09-15 22:23:28.424991047 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/vacuum_parallel.out 2025-09-15 22:27:...
@@ -43,7 +43,7 @@
-- Since vacuum_in_leader_small_index uses deduplication, we expect an
-- assertion failure with bug #17245 (in the absence of bugfix):
INSERT INTO parallel_vacuum_table SELECT i FROM generate_series(1, 10000) i;
-RESET max_parallel_maintenance_workers;
-RESET min_parallel_index_scan_size;
--- Deliberately don't drop table, to get further coverage from tools like
--- pg_amcheck in some testing scenarios
+server closed the connection unexpectedly
+ This probably means the server terminated abnormally
+ before or while processing the request.
+connection to server was lost
diff -U3 /home/postgres/postgres/src/test/regress/expected/maintain_every.out /home/postgres/postgres/build/testrun/reco...
--- /home/postgres/postgres/src/test/regress/expected/maintain_every.out 2025-09-15 22:23:28.276109321 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/maintain_every.out 2025-09-15 22:27:2...
@@ -1,33 +1,3 @@
--- Test maintenance commands that visit every eligible relation. Run as a
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/vacuum_parallel.out /home/postgres/postgres/build/testrun/reg...
--- /home/postgres/postgres/src/test/regress/expected/vacuum_parallel.out 2025-09-15 22:23:28.424991047 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/vacuum_parallel.out 2025-09-15 22:26:38.161917338 +000...
@@ -43,7 +43,7 @@
-- Since vacuum_in_leader_small_index uses deduplication, we expect an
-- assertion failure with bug #17245 (in the absence of bugfix):
INSERT INTO parallel_vacuum_table SELECT i FROM generate_series(1, 10000) i;
-RESET max_parallel_maintenance_workers;
-RESET min_parallel_index_scan_size;
--- Deliberately don't drop table, to get further coverage from tools like
--- pg_amcheck in some testing scenarios
+server closed the connection unexpectedly
+ This probably means the server terminated abnormally
+ before or while processing the request.
+connection to server was lost
diff -U3 /home/postgres/postgres/src/test/regress/expected/maintain_every.out /home/postgres/postgres/build/testrun/regr...
--- /home/postgres/postgres/src/test/regress/expected/maintain_every.out 2025-09-15 22:23:28.276109321 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/maintain_every.out 2025-09-15 22:26:38.307228038 +0000
@@ -1,33 +1 @@
--- Test maintenance commands that visit every eligible relation. Run as a
... |
| 55/5958 |
Per backend relation statistics tracking |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/stats.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_u...
--- /tmp/cirrus-ci-build/src/test/regress/expected/stats.out 2025-09-13 14:29:46.721120000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/stats.out 2025-09-13 14:34:42.886730000 +0...
@@ -243,7 +243,7 @@
SELECT :seq_scan_after > :seq_scan_before;
?column?
----------
- t
+ f
(1 row)
---- |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/stats.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stream...
--- /tmp/cirrus-ci-build/src/test/regress/expected/stats.out 2025-09-13 14:29:46.721120000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/stats.out 2025-09-13 14:35:50.848669000 ...
@@ -243,7 +243,7 @@
SELECT :seq_scan_after > :seq_scan_before;
?column?
----------
- t
+ f
(1 row)
---- |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/stats.out /tmp/cirrus-ci-build/build/testrun/regress/regress/res...
--- /tmp/cirrus-ci-build/src/test/regress/expected/stats.out 2025-09-13 14:29:46.721120000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/stats.out 2025-09-13 14:34:27.167837000 +0000
@@ -243,7 +243,7 @@
SELECT :seq_scan_after > :seq_scan_before;
?column?
----------
- t
+ f
(1 row)
---- |
| 55/5923 |
Let plan_cache_mode to be a little less strict |
|
Windows - Server 2019, MinGW64 - Meson |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/plancache.out C:/cirrus/build/testrun/pg_upgrade/002_pg...
--- C:/cirrus/src/test/regress/expected/plancache.out 2025-09-13 14:19:18.295381500 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/plancache.out 2025-09-13 14:22:11.703114900 +0000
@@ -398,3 +398,36 @@
(1 row)
drop table test_mode;
+-- Check the interference between plan_cache_mode and cursor_options
+-- EXPLAIN (COSTS OFF, GENERIC_PLAN)
+SELECT prepare_spi_plan(NULL, NULL, NULL); -- ERROR
+ERROR: query text cannot be null
+SELECT prepare_spi_plan(
+ 'EXPLAIN (COSTS OFF) SELECT * FROM pcachetest WHERE q1 = $1',
+ NULL, 'integer') AS p1 \gset
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = $2',
+ NULL, 'integer', NULL); --ERROR
+ERROR: type name cannot be NULL
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = 3',
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/plancache.out C:/cirrus/build/testrun/recovery/027_stre...
--- C:/cirrus/src/test/regress/expected/plancache.out 2025-09-13 14:19:18.295381500 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/plancache.out 2025-09-13 14:25:08.994530900 +0000
@@ -398,3 +398,36 @@
(1 row)
drop table test_mode;
+-- Check the interference between plan_cache_mode and cursor_options
+-- EXPLAIN (COSTS OFF, GENERIC_PLAN)
+SELECT prepare_spi_plan(NULL, NULL, NULL); -- ERROR
+ERROR: query text cannot be null
+SELECT prepare_spi_plan(
+ 'EXPLAIN (COSTS OFF) SELECT * FROM pcachetest WHERE q1 = $1',
+ NULL, 'integer') AS p1 \gset
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = $2',
+ NULL, 'integer', NULL); --ERROR
+ERROR: type name cannot be NULL
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = 3',
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/plancache.out C:/cirrus/build/testrun/regress/regress/r...
--- C:/cirrus/src/test/regress/expected/plancache.out 2025-09-13 14:19:18.295381500 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/plancache.out 2025-09-13 14:22:07.814013200 +0000
@@ -398,3 +398,36 @@
(1 row)
drop table test_mode;
+-- Check the interference between plan_cache_mode and cursor_options
+-- EXPLAIN (COSTS OFF, GENERIC_PLAN)
+SELECT prepare_spi_plan(NULL, NULL, NULL); -- ERROR
+ERROR: query text cannot be null
+SELECT prepare_spi_plan(
+ 'EXPLAIN (COSTS OFF) SELECT * FROM pcachetest WHERE q1 = $1',
+ NULL, 'integer') AS p1 \gset
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = $2',
+ NULL, 'integer', NULL); --ERROR
+ERROR: type name cannot be NULL
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = 3',
... |
|
Windows - Server 2019, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/plancache.out C:/cirrus/build/testrun/pg_upgrade/002_pg...
--- C:/cirrus/src/test/regress/expected/plancache.out 2025-09-13 14:19:12.490663700 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/plancache.out 2025-09-13 14:23:41.088210100 +0000
@@ -398,3 +398,36 @@
(1 row)
drop table test_mode;
+-- Check the interference between plan_cache_mode and cursor_options
+-- EXPLAIN (COSTS OFF, GENERIC_PLAN)
+SELECT prepare_spi_plan(NULL, NULL, NULL); -- ERROR
+ERROR: query text cannot be null
+SELECT prepare_spi_plan(
+ 'EXPLAIN (COSTS OFF) SELECT * FROM pcachetest WHERE q1 = $1',
+ NULL, 'integer') AS p1 \gset
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = $2',
+ NULL, 'integer', NULL); --ERROR
+ERROR: type name cannot be NULL
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = 3',
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/plancache.out C:/cirrus/build/testrun/recovery/027_stre...
--- C:/cirrus/src/test/regress/expected/plancache.out 2025-09-13 14:19:12.490663700 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/plancache.out 2025-09-13 14:26:38.130974400 +0000
@@ -398,3 +398,36 @@
(1 row)
drop table test_mode;
+-- Check the interference between plan_cache_mode and cursor_options
+-- EXPLAIN (COSTS OFF, GENERIC_PLAN)
+SELECT prepare_spi_plan(NULL, NULL, NULL); -- ERROR
+ERROR: query text cannot be null
+SELECT prepare_spi_plan(
+ 'EXPLAIN (COSTS OFF) SELECT * FROM pcachetest WHERE q1 = $1',
+ NULL, 'integer') AS p1 \gset
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = $2',
+ NULL, 'integer', NULL); --ERROR
+ERROR: type name cannot be NULL
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = 3',
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/plancache.out C:/cirrus/build/testrun/regress/regress/r...
--- C:/cirrus/src/test/regress/expected/plancache.out 2025-09-13 14:19:12.490663700 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/plancache.out 2025-09-13 14:23:36.406068800 +0000
@@ -398,3 +398,36 @@
(1 row)
drop table test_mode;
+-- Check the interference between plan_cache_mode and cursor_options
+-- EXPLAIN (COSTS OFF, GENERIC_PLAN)
+SELECT prepare_spi_plan(NULL, NULL, NULL); -- ERROR
+ERROR: query text cannot be null
+SELECT prepare_spi_plan(
+ 'EXPLAIN (COSTS OFF) SELECT * FROM pcachetest WHERE q1 = $1',
+ NULL, 'integer') AS p1 \gset
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = $2',
+ NULL, 'integer', NULL); --ERROR
+ERROR: type name cannot be NULL
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = 3',
... |
|
macOS - Sonoma - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/plancache.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_u...
--- /Users/admin/pgsql/src/test/regress/expected/plancache.out 2025-09-13 14:18:11
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/plancache.out 2025-09-13 14:20:04
@@ -398,3 +398,36 @@
(1 row)
drop table test_mode;
+-- Check the interference between plan_cache_mode and cursor_options
+-- EXPLAIN (COSTS OFF, GENERIC_PLAN)
+SELECT prepare_spi_plan(NULL, NULL, NULL); -- ERROR
+ERROR: query text cannot be null
+SELECT prepare_spi_plan(
+ 'EXPLAIN (COSTS OFF) SELECT * FROM pcachetest WHERE q1 = $1',
+ NULL, 'integer') AS p1 \gset
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = $2',
+ NULL, 'integer', NULL); --ERROR
+ERROR: type name cannot be NULL
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = 3',
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/plancache.out /Users/admin/pgsql/build/testrun/recovery/027_stream...
--- /Users/admin/pgsql/src/test/regress/expected/plancache.out 2025-09-13 14:18:11
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/plancache.out 2025-09-13 14:21:00
@@ -398,3 +398,36 @@
(1 row)
drop table test_mode;
+-- Check the interference between plan_cache_mode and cursor_options
+-- EXPLAIN (COSTS OFF, GENERIC_PLAN)
+SELECT prepare_spi_plan(NULL, NULL, NULL); -- ERROR
+ERROR: query text cannot be null
+SELECT prepare_spi_plan(
+ 'EXPLAIN (COSTS OFF) SELECT * FROM pcachetest WHERE q1 = $1',
+ NULL, 'integer') AS p1 \gset
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = $2',
+ NULL, 'integer', NULL); --ERROR
+ERROR: type name cannot be NULL
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = 3',
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/plancache.out /Users/admin/pgsql/build/testrun/regress/regress/res...
--- /Users/admin/pgsql/src/test/regress/expected/plancache.out 2025-09-13 14:18:11
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/plancache.out 2025-09-13 14:20:05
@@ -398,3 +398,36 @@
(1 row)
drop table test_mode;
+-- Check the interference between plan_cache_mode and cursor_options
+-- EXPLAIN (COSTS OFF, GENERIC_PLAN)
+SELECT prepare_spi_plan(NULL, NULL, NULL); -- ERROR
+ERROR: query text cannot be null
+SELECT prepare_spi_plan(
+ 'EXPLAIN (COSTS OFF) SELECT * FROM pcachetest WHERE q1 = $1',
+ NULL, 'integer') AS p1 \gset
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = $2',
+ NULL, 'integer', NULL); --ERROR
+ERROR: type name cannot be NULL
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = 3',
... |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/plancache.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/plancache.out 2025-09-13 14:19:07.047635078 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/plancache.out 2025-09-13 14:21:28.59652904...
@@ -398,3 +398,36 @@
(1 row)
drop table test_mode;
+-- Check the interference between plan_cache_mode and cursor_options
+-- EXPLAIN (COSTS OFF, GENERIC_PLAN)
+SELECT prepare_spi_plan(NULL, NULL, NULL); -- ERROR
+ERROR: query text cannot be null
+SELECT prepare_spi_plan(
+ 'EXPLAIN (COSTS OFF) SELECT * FROM pcachetest WHERE q1 = $1',
+ NULL, 'integer') AS p1 \gset
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = $2',
+ NULL, 'integer', NULL); --ERROR
+ERROR: type name cannot be NULL
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = 3',
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/plancache.out /tmp/cirrus-ci-build/build/testrun/recovery/027_st...
--- /tmp/cirrus-ci-build/src/test/regress/expected/plancache.out 2025-09-13 14:19:07.047635078 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/plancache.out 2025-09-13 14:22:45.091145...
@@ -398,3 +398,36 @@
(1 row)
drop table test_mode;
+-- Check the interference between plan_cache_mode and cursor_options
+-- EXPLAIN (COSTS OFF, GENERIC_PLAN)
+SELECT prepare_spi_plan(NULL, NULL, NULL); -- ERROR
+ERROR: query text cannot be null
+SELECT prepare_spi_plan(
+ 'EXPLAIN (COSTS OFF) SELECT * FROM pcachetest WHERE q1 = $1',
+ NULL, 'integer') AS p1 \gset
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = $2',
+ NULL, 'integer', NULL); --ERROR
+ERROR: type name cannot be NULL
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = 3',
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/plancache.out /tmp/cirrus-ci-build/build/testrun/regress/regress...
--- /tmp/cirrus-ci-build/src/test/regress/expected/plancache.out 2025-09-13 14:19:07.047635078 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/plancache.out 2025-09-13 14:21:30.268579092 +0000
@@ -398,3 +398,36 @@
(1 row)
drop table test_mode;
+-- Check the interference between plan_cache_mode and cursor_options
+-- EXPLAIN (COSTS OFF, GENERIC_PLAN)
+SELECT prepare_spi_plan(NULL, NULL, NULL); -- ERROR
+ERROR: query text cannot be null
+SELECT prepare_spi_plan(
+ 'EXPLAIN (COSTS OFF) SELECT * FROM pcachetest WHERE q1 = $1',
+ NULL, 'integer') AS p1 \gset
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = $2',
+ NULL, 'integer', NULL); --ERROR
+ERROR: type name cannot be NULL
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = 3',
... |
|
OpenBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/plancache.out /home/postgres/postgres/build/testrun/pg_upgrad...
--- /home/postgres/postgres/src/test/regress/expected/plancache.out Sat Sep 13 14:19:20 2025
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/plancache.out Sat Sep 13 14:21:53 2025
@@ -398,3 +398,36 @@
(1 row)
drop table test_mode;
+-- Check the interference between plan_cache_mode and cursor_options
+-- EXPLAIN (COSTS OFF, GENERIC_PLAN)
+SELECT prepare_spi_plan(NULL, NULL, NULL); -- ERROR
+ERROR: query text cannot be null
+SELECT prepare_spi_plan(
+ 'EXPLAIN (COSTS OFF) SELECT * FROM pcachetest WHERE q1 = $1',
+ NULL, 'integer') AS p1 \gset
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = $2',
+ NULL, 'integer', NULL); --ERROR
+ERROR: type name cannot be NULL
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = 3',
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/plancache.out /home/postgres/postgres/build/testrun/recovery/...
--- /home/postgres/postgres/src/test/regress/expected/plancache.out Sat Sep 13 14:19:20 2025
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/plancache.out Sat Sep 13 14:23:45 202...
@@ -398,3 +398,36 @@
(1 row)
drop table test_mode;
+-- Check the interference between plan_cache_mode and cursor_options
+-- EXPLAIN (COSTS OFF, GENERIC_PLAN)
+SELECT prepare_spi_plan(NULL, NULL, NULL); -- ERROR
+ERROR: query text cannot be null
+SELECT prepare_spi_plan(
+ 'EXPLAIN (COSTS OFF) SELECT * FROM pcachetest WHERE q1 = $1',
+ NULL, 'integer') AS p1 \gset
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = $2',
+ NULL, 'integer', NULL); --ERROR
+ERROR: type name cannot be NULL
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = 3',
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/plancache.out /home/postgres/postgres/build/testrun/regress/r...
--- /home/postgres/postgres/src/test/regress/expected/plancache.out Sat Sep 13 14:19:20 2025
+++ /home/postgres/postgres/build/testrun/regress/regress/results/plancache.out Sat Sep 13 14:21:46 2025
@@ -398,3 +398,36 @@
(1 row)
drop table test_mode;
+-- Check the interference between plan_cache_mode and cursor_options
+-- EXPLAIN (COSTS OFF, GENERIC_PLAN)
+SELECT prepare_spi_plan(NULL, NULL, NULL); -- ERROR
+ERROR: query text cannot be null
+SELECT prepare_spi_plan(
+ 'EXPLAIN (COSTS OFF) SELECT * FROM pcachetest WHERE q1 = $1',
+ NULL, 'integer') AS p1 \gset
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = $2',
+ NULL, 'integer', NULL); --ERROR
+ERROR: type name cannot be NULL
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = 3',
... |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/plancache.out /home/postgres/postgres/build/testrun/pg_upgrad...
--- /home/postgres/postgres/src/test/regress/expected/plancache.out 2025-09-13 14:19:34.924300721 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/plancache.out 2025-09-13 14:21:46.17111...
@@ -398,3 +398,36 @@
(1 row)
drop table test_mode;
+-- Check the interference between plan_cache_mode and cursor_options
+-- EXPLAIN (COSTS OFF, GENERIC_PLAN)
+SELECT prepare_spi_plan(NULL, NULL, NULL); -- ERROR
+ERROR: query text cannot be null
+SELECT prepare_spi_plan(
+ 'EXPLAIN (COSTS OFF) SELECT * FROM pcachetest WHERE q1 = $1',
+ NULL, 'integer') AS p1 \gset
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = $2',
+ NULL, 'integer', NULL); --ERROR
+ERROR: type name cannot be NULL
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = 3',
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/plancache.out /home/postgres/postgres/build/testrun/recovery/...
--- /home/postgres/postgres/src/test/regress/expected/plancache.out 2025-09-13 14:19:34.924300721 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/plancache.out 2025-09-13 14:22:25.325...
@@ -398,3 +398,36 @@
(1 row)
drop table test_mode;
+-- Check the interference between plan_cache_mode and cursor_options
+-- EXPLAIN (COSTS OFF, GENERIC_PLAN)
+SELECT prepare_spi_plan(NULL, NULL, NULL); -- ERROR
+ERROR: query text cannot be null
+SELECT prepare_spi_plan(
+ 'EXPLAIN (COSTS OFF) SELECT * FROM pcachetest WHERE q1 = $1',
+ NULL, 'integer') AS p1 \gset
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = $2',
+ NULL, 'integer', NULL); --ERROR
+ERROR: type name cannot be NULL
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = 3',
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/plancache.out /home/postgres/postgres/build/testrun/regress/r...
--- /home/postgres/postgres/src/test/regress/expected/plancache.out 2025-09-13 14:19:34.924300721 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/plancache.out 2025-09-13 14:21:32.211938306 +0000
@@ -398,3 +398,36 @@
(1 row)
drop table test_mode;
+-- Check the interference between plan_cache_mode and cursor_options
+-- EXPLAIN (COSTS OFF, GENERIC_PLAN)
+SELECT prepare_spi_plan(NULL, NULL, NULL); -- ERROR
+ERROR: query text cannot be null
+SELECT prepare_spi_plan(
+ 'EXPLAIN (COSTS OFF) SELECT * FROM pcachetest WHERE q1 = $1',
+ NULL, 'integer') AS p1 \gset
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = $2',
+ NULL, 'integer', NULL); --ERROR
+ERROR: type name cannot be NULL
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = 3',
... |
|
Linux - Debian Bookworm - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/plancache.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/plancache.out 2025-09-13 14:19:14.474485178 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/plancache.out 2025-09-13 14:25:04.553969177 +0000
@@ -398,3 +398,36 @@
(1 row)
drop table test_mode;
+-- Check the interference between plan_cache_mode and cursor_options
+-- EXPLAIN (COSTS OFF, GENERIC_PLAN)
+SELECT prepare_spi_plan(NULL, NULL, NULL); -- ERROR
+ERROR: query text cannot be null
+SELECT prepare_spi_plan(
+ 'EXPLAIN (COSTS OFF) SELECT * FROM pcachetest WHERE q1 = $1',
+ NULL, 'integer') AS p1 \gset
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = $2',
+ NULL, 'integer', NULL); --ERROR
+ERROR: type name cannot be NULL
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = 3',
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/plancache.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check/r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/plancache.out 2025-09-13 14:19:14.474485178 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/plancache.out 2025-09-13 14:27:11.293896895 +0000
@@ -398,3 +398,36 @@
(1 row)
drop table test_mode;
+-- Check the interference between plan_cache_mode and cursor_options
+-- EXPLAIN (COSTS OFF, GENERIC_PLAN)
+SELECT prepare_spi_plan(NULL, NULL, NULL); -- ERROR
+ERROR: query text cannot be null
+SELECT prepare_spi_plan(
+ 'EXPLAIN (COSTS OFF) SELECT * FROM pcachetest WHERE q1 = $1',
+ NULL, 'integer') AS p1 \gset
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = $2',
+ NULL, 'integer', NULL); --ERROR
+ERROR: type name cannot be NULL
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = 3',
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/plancache.out /tmp/cirrus-ci-build/src/test/regress/results/plan...
--- /tmp/cirrus-ci-build/src/test/regress/expected/plancache.out 2025-09-13 14:19:14.474485178 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/plancache.out 2025-09-13 14:22:28.698104528 +0000
@@ -398,3 +398,36 @@
(1 row)
drop table test_mode;
+-- Check the interference between plan_cache_mode and cursor_options
+-- EXPLAIN (COSTS OFF, GENERIC_PLAN)
+SELECT prepare_spi_plan(NULL, NULL, NULL); -- ERROR
+ERROR: query text cannot be null
+SELECT prepare_spi_plan(
+ 'EXPLAIN (COSTS OFF) SELECT * FROM pcachetest WHERE q1 = $1',
+ NULL, 'integer') AS p1 \gset
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = $2',
+ NULL, 'integer', NULL); --ERROR
+ERROR: type name cannot be NULL
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = 3',
... |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/plancache.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/plancache.out 2025-09-13 14:19:06.210786000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/plancache.out 2025-09-13 14:22:40.88721400...
@@ -398,3 +398,36 @@
(1 row)
drop table test_mode;
+-- Check the interference between plan_cache_mode and cursor_options
+-- EXPLAIN (COSTS OFF, GENERIC_PLAN)
+SELECT prepare_spi_plan(NULL, NULL, NULL); -- ERROR
+ERROR: query text cannot be null
+SELECT prepare_spi_plan(
+ 'EXPLAIN (COSTS OFF) SELECT * FROM pcachetest WHERE q1 = $1',
+ NULL, 'integer') AS p1 \gset
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = $2',
+ NULL, 'integer', NULL); --ERROR
+ERROR: type name cannot be NULL
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = 3',
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/plancache.out /tmp/cirrus-ci-build/build/testrun/recovery/027_st...
--- /tmp/cirrus-ci-build/src/test/regress/expected/plancache.out 2025-09-13 14:19:06.210786000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/plancache.out 2025-09-13 14:24:10.015188...
@@ -398,3 +398,36 @@
(1 row)
drop table test_mode;
+-- Check the interference between plan_cache_mode and cursor_options
+-- EXPLAIN (COSTS OFF, GENERIC_PLAN)
+SELECT prepare_spi_plan(NULL, NULL, NULL); -- ERROR
+ERROR: query text cannot be null
+SELECT prepare_spi_plan(
+ 'EXPLAIN (COSTS OFF) SELECT * FROM pcachetest WHERE q1 = $1',
+ NULL, 'integer') AS p1 \gset
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = $2',
+ NULL, 'integer', NULL); --ERROR
+ERROR: type name cannot be NULL
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = 3',
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/plancache.out /tmp/cirrus-ci-build/build/testrun/regress/regress...
--- /tmp/cirrus-ci-build/src/test/regress/expected/plancache.out 2025-09-13 14:19:06.210786000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/plancache.out 2025-09-13 14:22:47.244101000 +0000
@@ -398,3 +398,35 @@
(1 row)
drop table test_mode;
+-- Check the interference between plan_cache_mode and cursor_options
+-- EXPLAIN (COSTS OFF, GENERIC_PLAN)
+SELECT prepare_spi_plan(NULL, NULL, NULL); -- ERROR
+ERROR: query text cannot be null
+SELECT prepare_spi_plan(
+ 'EXPLAIN (COSTS OFF) SELECT * FROM pcachetest WHERE q1 = $1',
+ NULL, 'integer') AS p1 \gset
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = $2',
+ NULL, 'integer', NULL); --ERROR
+ERROR: type name cannot be NULL
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = 3',
... |
| 55/5667 |
support create index on virtual generated column. |
|
macOS - Sonoma - 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-09-12 12:57:11
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out 2025-09-12 12:59:39
@@ -768,7 +768,7 @@
ALTER INDEX gtestparted_a_idx ATTACH PARTITION gtestpart2_a_idx; --ok
ALTER INDEX gtestparted_a_idx ATTACH PARTITION gtestpart2_a_idx_copy; --error
ERROR: cannot attach index "gtestpart2_a_idx_copy" as a partition of index "gtestparted_a_idx"
-DETAIL: Another index is already attached for partition "gtestpart2".
+DETAIL: Another index "gtestpart2_a_idx" is already attached for partition "gtestpart2".
CREATE INDEX gtestparted_a_idx_1 on gtestparted(a);
--now index gtestpart2_a_idx_copy should attach to the partition tree.
SELECT * FROM pg_partition_tree('gtestparted_a_idx_1'::regclass); |
| 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-09-12 12:57:11
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out 2025-09-12 13:00:29
@@ -768,7 +768,7 @@
ALTER INDEX gtestparted_a_idx ATTACH PARTITION gtestpart2_a_idx; --ok
ALTER INDEX gtestparted_a_idx ATTACH PARTITION gtestpart2_a_idx_copy; --error
ERROR: cannot attach index "gtestpart2_a_idx_copy" as a partition of index "gtestparted_a_idx"
-DETAIL: Another index is already attached for partition "gtestpart2".
+DETAIL: Another index "gtestpart2_a_idx" is already attached for partition "gtestpart2".
CREATE INDEX gtestparted_a_idx_1 on gtestparted(a);
--now index gtestpart2_a_idx_copy should attach to the partition tree.
SELECT * FROM pg_partition_tree('gtestparted_a_idx_1'::regclass); |
| 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-09-12 12:57:11
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/generated_virtual.out 2025-09-12 12:59:39
@@ -768,7 +768,7 @@
ALTER INDEX gtestparted_a_idx ATTACH PARTITION gtestpart2_a_idx; --ok
ALTER INDEX gtestparted_a_idx ATTACH PARTITION gtestpart2_a_idx_copy; --error
ERROR: cannot attach index "gtestpart2_a_idx_copy" as a partition of index "gtestparted_a_idx"
-DETAIL: Another index is already attached for partition "gtestpart2".
+DETAIL: Another index "gtestpart2_a_idx" is already attached for partition "gtestpart2".
CREATE INDEX gtestparted_a_idx_1 on gtestparted(a);
--now index gtestpart2_a_idx_copy should attach to the partition tree.
SELECT * FROM pg_partition_tree('gtestparted_a_idx_1'::regclass); |
|
Windows - Server 2019, 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-09-12 12:58:01.970185800 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out 2025-09-12 13:01:17.872536400 +...
@@ -768,7 +768,7 @@
ALTER INDEX gtestparted_a_idx ATTACH PARTITION gtestpart2_a_idx; --ok
ALTER INDEX gtestparted_a_idx ATTACH PARTITION gtestpart2_a_idx_copy; --error
ERROR: cannot attach index "gtestpart2_a_idx_copy" as a partition of index "gtestparted_a_idx"
-DETAIL: Another index is already attached for partition "gtestpart2".
+DETAIL: Another index "gtestpart2_a_idx" is already attached for partition "gtestpart2".
CREATE INDEX gtestparted_a_idx_1 on gtestparted(a);
--now index gtestpart2_a_idx_copy should attach to the partition tree.
SELECT * FROM pg_partition_tree('gtestparted_a_idx_1'::regclass); |
| 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-09-12 12:58:01.970185800 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out 2025-09-12 13:04:08.253614400...
@@ -768,7 +768,7 @@
ALTER INDEX gtestparted_a_idx ATTACH PARTITION gtestpart2_a_idx; --ok
ALTER INDEX gtestparted_a_idx ATTACH PARTITION gtestpart2_a_idx_copy; --error
ERROR: cannot attach index "gtestpart2_a_idx_copy" as a partition of index "gtestparted_a_idx"
-DETAIL: Another index is already attached for partition "gtestpart2".
+DETAIL: Another index "gtestpart2_a_idx" is already attached for partition "gtestpart2".
CREATE INDEX gtestparted_a_idx_1 on gtestparted(a);
--now index gtestpart2_a_idx_copy should attach to the partition tree.
SELECT * FROM pg_partition_tree('gtestparted_a_idx_1'::regclass); |
| 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-09-12 12:58:01.970185800 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/generated_virtual.out 2025-09-12 13:01:16.165036300 +0000
@@ -768,7 +768,7 @@
ALTER INDEX gtestparted_a_idx ATTACH PARTITION gtestpart2_a_idx; --ok
ALTER INDEX gtestparted_a_idx ATTACH PARTITION gtestpart2_a_idx_copy; --error
ERROR: cannot attach index "gtestpart2_a_idx_copy" as a partition of index "gtestparted_a_idx"
-DETAIL: Another index is already attached for partition "gtestpart2".
+DETAIL: Another index "gtestpart2_a_idx" is already attached for partition "gtestpart2".
CREATE INDEX gtestparted_a_idx_1 on gtestparted(a);
--now index gtestpart2_a_idx_copy should attach to the partition tree.
SELECT * FROM pg_partition_tree('gtestparted_a_idx_1'::regclass); |
|
Linux - Debian Bookworm - 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-09-12 12:58:01.003634752 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out 2025-09-12 13:03:48....
@@ -768,7 +768,7 @@
ALTER INDEX gtestparted_a_idx ATTACH PARTITION gtestpart2_a_idx; --ok
ALTER INDEX gtestparted_a_idx ATTACH PARTITION gtestpart2_a_idx_copy; --error
ERROR: cannot attach index "gtestpart2_a_idx_copy" as a partition of index "gtestparted_a_idx"
-DETAIL: Another index is already attached for partition "gtestpart2".
+DETAIL: Another index "gtestpart2_a_idx" is already attached for partition "gtestpart2".
CREATE INDEX gtestparted_a_idx_1 on gtestparted(a);
--now index gtestpart2_a_idx_copy should attach to the partition tree.
SELECT * FROM pg_partition_tree('gtestparted_a_idx_1'::regclass); |
| 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-09-12 12:58:01.003634752 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out 2025-09-12 13:05:1...
@@ -768,7 +768,7 @@
ALTER INDEX gtestparted_a_idx ATTACH PARTITION gtestpart2_a_idx; --ok
ALTER INDEX gtestparted_a_idx ATTACH PARTITION gtestpart2_a_idx_copy; --error
ERROR: cannot attach index "gtestpart2_a_idx_copy" as a partition of index "gtestparted_a_idx"
-DETAIL: Another index is already attached for partition "gtestpart2".
+DETAIL: Another index "gtestpart2_a_idx" is already attached for partition "gtestpart2".
CREATE INDEX gtestparted_a_idx_1 on gtestparted(a);
--now index gtestpart2_a_idx_copy should attach to the partition tree.
SELECT * FROM pg_partition_tree('gtestparted_a_idx_1'::regclass); |
| 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-09-12 12:58:01.003634752 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/generated_virtual.out 2025-09-12 13:03:44.986261035 +0000
@@ -768,7 +768,7 @@
ALTER INDEX gtestparted_a_idx ATTACH PARTITION gtestpart2_a_idx; --ok
ALTER INDEX gtestparted_a_idx ATTACH PARTITION gtestpart2_a_idx_copy; --error
ERROR: cannot attach index "gtestpart2_a_idx_copy" as a partition of index "gtestparted_a_idx"
-DETAIL: Another index is already attached for partition "gtestpart2".
+DETAIL: Another index "gtestpart2_a_idx" is already attached for partition "gtestpart2".
CREATE INDEX gtestparted_a_idx_1 on gtestparted(a);
--now index gtestpart2_a_idx_copy should attach to the partition tree.
SELECT * FROM pg_partition_tree('gtestparted_a_idx_1'::regclass); |
|
Linux - Debian Bookworm - 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-09-12 12:57:59.028118336 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/generated_virtual.out 2025-09-12 13:05:48.993022110 +0000
@@ -768,7 +768,7 @@
ALTER INDEX gtestparted_a_idx ATTACH PARTITION gtestpart2_a_idx; --ok
ALTER INDEX gtestparted_a_idx ATTACH PARTITION gtestpart2_a_idx_copy; --error
ERROR: cannot attach index "gtestpart2_a_idx_copy" as a partition of index "gtestparted_a_idx"
-DETAIL: Another index is already attached for partition "gtestpart2".
+DETAIL: Another index "gtestpart2_a_idx" is already attached for partition "gtestpart2".
CREATE INDEX gtestparted_a_idx_1 on gtestparted(a);
--now index gtestpart2_a_idx_copy should attach to the partition tree.
SELECT * FROM pg_partition_tree('gtestparted_a_idx_1'::regclass); |
| 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-09-12 12:57:59.028118336 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/generated_virtual.out 2025-09-12 13:03:24.310484568 +0000
@@ -768,7 +768,7 @@
ALTER INDEX gtestparted_a_idx ATTACH PARTITION gtestpart2_a_idx; --ok
ALTER INDEX gtestparted_a_idx ATTACH PARTITION gtestpart2_a_idx_copy; --error
ERROR: cannot attach index "gtestpart2_a_idx_copy" as a partition of index "gtestparted_a_idx"
-DETAIL: Another index is already attached for partition "gtestpart2".
+DETAIL: Another index "gtestpart2_a_idx" is already attached for partition "gtestpart2".
CREATE INDEX gtestparted_a_idx_1 on gtestparted(a);
--now index gtestpart2_a_idx_copy should attach to the partition tree.
SELECT * FROM pg_partition_tree('gtestparted_a_idx_1'::regclass); |
|
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-09-12 12:58:00.250333000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out 2025-09-12 13:01:02....
@@ -768,7 +768,7 @@
ALTER INDEX gtestparted_a_idx ATTACH PARTITION gtestpart2_a_idx; --ok
ALTER INDEX gtestparted_a_idx ATTACH PARTITION gtestpart2_a_idx_copy; --error
ERROR: cannot attach index "gtestpart2_a_idx_copy" as a partition of index "gtestparted_a_idx"
-DETAIL: Another index is already attached for partition "gtestpart2".
+DETAIL: Another index "gtestpart2_a_idx" is already attached for partition "gtestpart2".
CREATE INDEX gtestparted_a_idx_1 on gtestparted(a);
--now index gtestpart2_a_idx_copy should attach to the partition tree.
SELECT * FROM pg_partition_tree('gtestparted_a_idx_1'::regclass); |
| 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-09-12 12:58:00.250333000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out 2025-09-12 13:02:2...
@@ -768,7 +768,7 @@
ALTER INDEX gtestparted_a_idx ATTACH PARTITION gtestpart2_a_idx; --ok
ALTER INDEX gtestparted_a_idx ATTACH PARTITION gtestpart2_a_idx_copy; --error
ERROR: cannot attach index "gtestpart2_a_idx_copy" as a partition of index "gtestparted_a_idx"
-DETAIL: Another index is already attached for partition "gtestpart2".
+DETAIL: Another index "gtestpart2_a_idx" is already attached for partition "gtestpart2".
CREATE INDEX gtestparted_a_idx_1 on gtestparted(a);
--now index gtestpart2_a_idx_copy should attach to the partition tree.
SELECT * FROM pg_partition_tree('gtestparted_a_idx_1'::regclass); |
| 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-09-12 12:58:00.250333000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/generated_virtual.out 2025-09-12 13:01:05.017580000 +0000
@@ -768,7 +768,7 @@
ALTER INDEX gtestparted_a_idx ATTACH PARTITION gtestpart2_a_idx; --ok
ALTER INDEX gtestparted_a_idx ATTACH PARTITION gtestpart2_a_idx_copy; --error
ERROR: cannot attach index "gtestpart2_a_idx_copy" as a partition of index "gtestparted_a_idx"
-DETAIL: Another index is already attached for partition "gtestpart2".
+DETAIL: Another index "gtestpart2_a_idx" is already attached for partition "gtestpart2".
CREATE INDEX gtestparted_a_idx_1 on gtestparted(a);
--now index gtestpart2_a_idx_copy should attach to the partition tree.
SELECT * FROM pg_partition_tree('gtestparted_a_idx_1'::regclass); |
| 55/5892 |
parallel safety of correlated subquery (was: parallel_safe) |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/btree_gist/expected/without_overlaps.out /tmp/cirrus-ci-build/build/testrun/btree_...
--- /tmp/cirrus-ci-build/contrib/btree_gist/expected/without_overlaps.out 2025-09-12 08:34:03.045896525 +0000
+++ /tmp/cirrus-ci-build/build/testrun/btree_gist/regress/results/without_overlaps.out 2025-09-12 08:40:34.208729902 +00...
@@ -9,84 +9,7 @@
CONSTRAINT temporal_rng_pk PRIMARY KEY (id, valid_at WITHOUT OVERLAPS)
);
\d temporal_rng
- Table "public.temporal_rng"
- Column | Type | Collation | Nullable | Default
-----------+-----------+-----------+----------+---------
- id | integer | | not null |
- valid_at | daterange | | not null |
-Indexes:
- "temporal_rng_pk" PRIMARY KEY (id, valid_at WITHOUT OVERLAPS)
-
-SELECT pg_get_constraintdef(oid) FROM pg_constraint WHERE conname = 'temporal_rng_pk';
- pg_get_constraintdef
----------------------------------------------
- PRIMARY KEY (id, valid_at WITHOUT OVERLAPS)
-(1 row)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/earthdistance/expected/earthdistance.out /tmp/cirrus-ci-build/build/testrun/earthd...
--- /tmp/cirrus-ci-build/contrib/earthdistance/expected/earthdistance.out 2025-09-12 08:34:03.065896525 +0000
+++ /tmp/cirrus-ci-build/build/testrun/earthdistance/regress/results/earthdistance.out 2025-09-12 08:40:35.632728015 +00...
@@ -1053,46 +1053,7 @@
drop extension cube cascade;
NOTICE: drop cascades to column f1 of table foo
\d foo
- Table "public.foo"
- Column | Type | Collation | Nullable | Default
---------+---------+-----------+----------+---------
- f2 | integer | | |
-
--- list what's installed
-\dT public.*
- List of data types
- Schema | Name | Description
---------+------+-------------
-(0 rows)
-
-\df public.*
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/bit.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upg...
--- /tmp/cirrus-ci-build/src/test/regress/expected/bit.out 2025-09-12 08:34:05.017896515 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/bit.out 2025-09-12 08:39:17.580847608 +000...
@@ -772,79 +772,7 @@
b4 bit varying(5) DEFAULT B'0101'
);
\d bit_defaults
- Table "public.bit_defaults"
- Column | Type | Collation | Nullable | Default
---------+----------------+-----------+----------+---------------------
- b1 | bit(4) | | | '1001'::"bit"
- b2 | bit(4) | | | '0101'::"bit"
- b3 | bit varying(5) | | | '1001'::bit varying
- b4 | bit varying(5) | | | '0101'::"bit"
-
-INSERT INTO bit_defaults DEFAULT VALUES;
-TABLE bit_defaults;
- b1 | b2 | b3 | b4
-------+------+------+------
- 1001 | 0101 | 1001 | 0101
... |
| 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-09-12 08:34:03.161896525 +0000
+++ /tmp/cirrus-ci-build/build/testrun/postgres_fdw/regress/results/postgres_fdw.out 2025-09-12 08:40:48.928710712 +0000
@@ -397,12312 +397,7 @@
-- subquery
SELECT * FROM ft1 t1 WHERE t1.c3 IN (SELECT c3 FROM ft2 t2 WHERE c1 <= 10) ORDER BY c1;
- c1 | c2 | c3 | c4 | c5 | c6 | c7 | c8
-----+----+-------+------------------------------+--------------------------+----+------------+-----
- 1 | 1 | 00001 | Fri Jan 02 00:00:00 1970 PST | Fri Jan 02 00:00:00 1970 | 1 | 1 | foo
- 2 | 2 | 00002 | Sat Jan 03 00:00:00 1970 PST | Sat Jan 03 00:00:00 1970 | 2 | 2 | foo
- 3 | 3 | 00003 | Sun Jan 04 00:00:00 1970 PST | Sun Jan 04 00:00:00 1970 | 3 | 3 | foo
- 4 | 4 | 00004 | Mon Jan 05 00:00:00 1970 PST | Mon Jan 05 00:00:00 1970 | 4 | 4 | foo
- 5 | 5 | 00005 | Tue Jan 06 00:00:00 1970 PST | Tue Jan 06 00:00:00 1970 | 5 | 5 | foo
- 6 | 6 | 00006 | Wed Jan 07 00:00:00 1970 PST | Wed Jan 07 00:00:00 1970 | 6 | 6 | foo
- 7 | 7 | 00007 | Thu Jan 08 00:00:00 1970 PST | Thu Jan 08 00:00:00 1970 | 7 | 7 | foo
- 8 | 8 | 00008 | Fri Jan 09 00:00:00 1970 PST | Fri Jan 09 00:00:00 1970 | 8 | 8 | foo
- 9 | 9 | 00009 | Sat Jan 10 00:00:00 1970 PST | Sat Jan 10 00:00:00 1970 | 9 | 9 | foo
- 10 | 0 | 00010 | Sun Jan 11 00:00:00 1970 PST | Sun Jan 11 00:00:00 1970 | 0 | 0 | foo
-(10 rows)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/bit.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/bit.out 2025-09-12 08:34:05.017896515 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/bit.out 2025-09-12 08:39:57.204781956 +0...
@@ -772,79 +772,7 @@
b4 bit varying(5) DEFAULT B'0101'
);
\d bit_defaults
- Table "public.bit_defaults"
- Column | Type | Collation | Nullable | Default
---------+----------------+-----------+----------+---------------------
- b1 | bit(4) | | | '1001'::"bit"
- b2 | bit(4) | | | '0101'::"bit"
- b3 | bit varying(5) | | | '1001'::bit varying
- b4 | bit varying(5) | | | '0101'::"bit"
-
-INSERT INTO bit_defaults DEFAULT VALUES;
-TABLE bit_defaults;
- b1 | b2 | b3 | b4
-------+------+------+------
- 1001 | 0101 | 1001 | 0101
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/bit.out /tmp/cirrus-ci-build/build/testrun/regress/regress/resul...
--- /tmp/cirrus-ci-build/src/test/regress/expected/bit.out 2025-09-12 08:34:05.017896515 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/bit.out 2025-09-12 08:39:14.804852779 +0000
@@ -772,79 +772,7 @@
b4 bit varying(5) DEFAULT B'0101'
);
\d bit_defaults
- Table "public.bit_defaults"
- Column | Type | Collation | Nullable | Default
---------+----------------+-----------+----------+---------------------
- b1 | bit(4) | | | '1001'::"bit"
- b2 | bit(4) | | | '0101'::"bit"
- b3 | bit varying(5) | | | '1001'::bit varying
- b4 | bit varying(5) | | | '0101'::"bit"
-
-INSERT INTO bit_defaults DEFAULT VALUES;
-TABLE bit_defaults;
- b1 | b2 | b3 | b4
-------+------+------+------
- 1001 | 0101 | 1001 | 0101
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/seg/expected/partition.out /tmp/cirrus-ci-build/build/testrun/seg/regress/results/...
--- /tmp/cirrus-ci-build/contrib/seg/expected/partition.out 2025-09-12 08:34:03.169896525 +0000
+++ /tmp/cirrus-ci-build/build/testrun/seg/regress/results/partition.out 2025-09-12 08:40:50.584708593 +0000
@@ -24,31 +24,7 @@
create table pt34 partition of pt for values in (3,4);
insert into pt values(4, '-1 .. 1'::seg, 'foo');
\d+ pt
- Partitioned table "public.pt"
- Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
-----------+---------+-----------+----------+---------+----------+--------------+-------------
- category | integer | | | | plain | |
- sdata | seg | | | | plain | |
- tdata | text | | | | extended | |
-Partition key: LIST (category)
-Indexes:
- "pti1" btree ((mydouble(category) + 1))
- "pti2" btree (sdata)
- "pti3" btree (tdata COLLATE mycollation)
-Partitions: pt12 FOR VALUES IN (1, 2),
- pt34 FOR VALUES IN (3, 4)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/test_decoding/expected/ddl.out /tmp/cirrus-ci-build/build/testrun/test_decoding/re...
--- /tmp/cirrus-ci-build/contrib/test_decoding/expected/ddl.out 2025-09-12 08:34:03.189896525 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_decoding/regress/results/ddl.out 2025-09-12 08:40:53.692704636 +0000
@@ -484,374 +484,7 @@
WITH (user_catalog_table = true)
;
\d+ replication_metadata
- Table "public.replication_metadata"
- Column | Type | Collation | Nullable | Default | Storage | Stats target...
-----------+---------+-----------+----------+--------------------------------------------------+----------+-------------...
- id | integer | | not null | nextval('replication_metadata_id_seq'::regclass) | plain | ...
- relation | name | | not null | | plain | ...
- options | text[] | | | | extended | ...
-Indexes:
- "replication_metadata_pkey" PRIMARY KEY, btree (id)
-Not-null constraints:
- "replication_metadata_id_not_null" NOT NULL "id"
- "replication_metadata_relation_not_null" NOT NULL "relation"
-Options: user_catalog_table=true
-
... |
| 55/5357 |
New predefined role pg_manage_extensions |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/pl/plperl/expected/plperl_setup.out /tmp/cirrus-ci-build/build/testrun/plperl/regress/...
--- /tmp/cirrus-ci-build/src/pl/plperl/expected/plperl_setup.out 2025-09-12 05:51:26.825065634 +0000
+++ /tmp/cirrus-ci-build/build/testrun/plperl/regress/results/plperl_setup.out 2025-09-12 05:56:36.572480899 +0000
@@ -12,7 +12,7 @@
HINT: Must have CREATE privilege on current database to create this extension.
CREATE EXTENSION plperlu; -- fail
ERROR: permission denied to create extension "plperlu"
-HINT: Must be superuser to create this extension.
+HINT: Must be superuser or member of pg_manage_extensions to create this extension.
RESET ROLE;
DO $$
begin
@@ -24,7 +24,7 @@
CREATE EXTENSION plperl;
CREATE EXTENSION plperlu; -- fail
ERROR: permission denied to create extension "plperlu"
-HINT: Must be superuser to create this extension.
+HINT: Must be superuser or member of pg_manage_extensions to create this extension.
CREATE SCHEMA plperl_setup_scratch;
SET search_path = plperl_setup_scratch;
... |
|
Windows - Server 2019, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/pl/plperl/expected/plperl_setup.out C:/cirrus/build/testrun/plperl/regress/re...
--- C:/cirrus/src/pl/plperl/expected/plperl_setup.out 2025-09-12 05:51:33.568140300 +0000
+++ C:/cirrus/build/testrun/plperl/regress/results/plperl_setup.out 2025-09-12 05:58:33.349510500 +0000
@@ -12,7 +12,7 @@
HINT: Must have CREATE privilege on current database to create this extension.
CREATE EXTENSION plperlu; -- fail
ERROR: permission denied to create extension "plperlu"
-HINT: Must be superuser to create this extension.
+HINT: Must be superuser or member of pg_manage_extensions to create this extension.
RESET ROLE;
DO $$
begin
@@ -24,7 +24,7 @@
CREATE EXTENSION plperl;
CREATE EXTENSION plperlu; -- fail
ERROR: permission denied to create extension "plperlu"
-HINT: Must be superuser to create this extension.
+HINT: Must be superuser or member of pg_manage_extensions to create this extension.
CREATE SCHEMA plperl_setup_scratch;
SET search_path = plperl_setup_scratch;
... |
|
macOS - Sonoma - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/pl/plperl/expected/plperl_setup.out /Users/admin/pgsql/build/testrun/plperl/regress/resu...
--- /Users/admin/pgsql/src/pl/plperl/expected/plperl_setup.out 2025-09-12 05:51:12
+++ /Users/admin/pgsql/build/testrun/plperl/regress/results/plperl_setup.out 2025-09-12 05:53:49
@@ -12,7 +12,7 @@
HINT: Must have CREATE privilege on current database to create this extension.
CREATE EXTENSION plperlu; -- fail
ERROR: permission denied to create extension "plperlu"
-HINT: Must be superuser to create this extension.
+HINT: Must be superuser or member of pg_manage_extensions to create this extension.
RESET ROLE;
DO $$
begin
@@ -24,7 +24,7 @@
CREATE EXTENSION plperl;
CREATE EXTENSION plperlu; -- fail
ERROR: permission denied to create extension "plperlu"
-HINT: Must be superuser to create this extension.
+HINT: Must be superuser or member of pg_manage_extensions to create this extension.
CREATE SCHEMA plperl_setup_scratch;
SET search_path = plperl_setup_scratch;
... |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/pl/plperl/expected/plperl_setup.out /tmp/cirrus-ci-build/build/testrun/plperl/regress/...
--- /tmp/cirrus-ci-build/src/pl/plperl/expected/plperl_setup.out 2025-09-12 05:51:26.484063000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/plperl/regress/results/plperl_setup.out 2025-09-12 05:53:51.103558000 +0000
@@ -12,7 +12,7 @@
HINT: Must have CREATE privilege on current database to create this extension.
CREATE EXTENSION plperlu; -- fail
ERROR: permission denied to create extension "plperlu"
-HINT: Must be superuser to create this extension.
+HINT: Must be superuser or member of pg_manage_extensions to create this extension.
RESET ROLE;
DO $$
begin
@@ -24,7 +24,7 @@
CREATE EXTENSION plperl;
CREATE EXTENSION plperlu; -- fail
ERROR: permission denied to create extension "plperlu"
-HINT: Must be superuser to create this extension.
+HINT: Must be superuser or member of pg_manage_extensions to create this extension.
CREATE SCHEMA plperl_setup_scratch;
SET search_path = plperl_setup_scratch;
... |
|
Linux - Debian Bookworm - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/pl/plperl/expected/plperl_setup.out /tmp/cirrus-ci-build/src/pl/plperl/results/plperl_...
--- /tmp/cirrus-ci-build/src/pl/plperl/expected/plperl_setup.out 2025-09-12 05:51:29.123696402 +0000
+++ /tmp/cirrus-ci-build/src/pl/plperl/results/plperl_setup.out 2025-09-12 05:54:07.875838991 +0000
@@ -12,7 +12,7 @@
HINT: Must have CREATE privilege on current database to create this extension.
CREATE EXTENSION plperlu; -- fail
ERROR: permission denied to create extension "plperlu"
-HINT: Must be superuser to create this extension.
+HINT: Must be superuser or member of pg_manage_extensions to create this extension.
RESET ROLE;
DO $$
begin
@@ -24,7 +24,7 @@
CREATE EXTENSION plperl;
CREATE EXTENSION plperlu; -- fail
ERROR: permission denied to create extension "plperlu"
-HINT: Must be superuser to create this extension.
+HINT: Must be superuser or member of pg_manage_extensions to create this extension.
CREATE SCHEMA plperl_setup_scratch;
SET search_path = plperl_setup_scratch;
... |
| 55/5588 |
Improvement of var_eq_non_const() |
|
Windows - Server 2019, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/subselect.out C:/cirrus/build/testrun/pg_upgrade/002_pg...
--- C:/cirrus/src/test/regress/expected/subselect.out 2025-09-12 02:43:13.397307200 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/subselect.out 2025-09-12 02:46:05.056890200 +0000
@@ -2884,13 +2884,15 @@
EXPLAIN (COSTS OFF)
SELECT * FROM onek, (VALUES('RFAAAA'), ('VJAAAA')) AS v (i)
WHERE onek.stringu1 = v.i;
- QUERY PLAN
--------------------------------------------------------------
+ QUERY PLAN
+-------------------------------------------------------------------
Nested Loop
-> Values Scan on "*VALUES*"
- -> Index Scan using onek_stringu1 on onek
- Index Cond: (stringu1 = ("*VALUES*".column1)::text)
-(4 rows)
+ -> Bitmap Heap Scan on onek
+ Recheck Cond: (stringu1 = ("*VALUES*".column1)::text)
+ -> Bitmap Index Scan on onek_stringu1
+ Index Cond: (stringu1 = ("*VALUES*".column1)::text)
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/subselect.out C:/cirrus/build/testrun/recovery/027_stre...
--- C:/cirrus/src/test/regress/expected/subselect.out 2025-09-12 02:43:13.397307200 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/subselect.out 2025-09-12 02:48:46.111522800 +0000
@@ -2884,13 +2884,15 @@
EXPLAIN (COSTS OFF)
SELECT * FROM onek, (VALUES('RFAAAA'), ('VJAAAA')) AS v (i)
WHERE onek.stringu1 = v.i;
- QUERY PLAN
--------------------------------------------------------------
+ QUERY PLAN
+-------------------------------------------------------------------
Nested Loop
-> Values Scan on "*VALUES*"
- -> Index Scan using onek_stringu1 on onek
- Index Cond: (stringu1 = ("*VALUES*".column1)::text)
-(4 rows)
+ -> Bitmap Heap Scan on onek
+ Recheck Cond: (stringu1 = ("*VALUES*".column1)::text)
+ -> Bitmap Index Scan on onek_stringu1
+ Index Cond: (stringu1 = ("*VALUES*".column1)::text)
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/subselect.out C:/cirrus/build/testrun/regress/regress/r...
--- C:/cirrus/src/test/regress/expected/subselect.out 2025-09-12 02:43:13.397307200 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/subselect.out 2025-09-12 02:45:56.188727000 +0000
@@ -2884,13 +2884,15 @@
EXPLAIN (COSTS OFF)
SELECT * FROM onek, (VALUES('RFAAAA'), ('VJAAAA')) AS v (i)
WHERE onek.stringu1 = v.i;
- QUERY PLAN
--------------------------------------------------------------
+ QUERY PLAN
+-------------------------------------------------------------------
Nested Loop
-> Values Scan on "*VALUES*"
- -> Index Scan using onek_stringu1 on onek
- Index Cond: (stringu1 = ("*VALUES*".column1)::text)
-(4 rows)
+ -> Bitmap Heap Scan on onek
+ Recheck Cond: (stringu1 = ("*VALUES*".column1)::text)
+ -> Bitmap Index Scan on onek_stringu1
+ Index Cond: (stringu1 = ("*VALUES*".column1)::text)
... |
|
macOS - Sonoma - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/subselect.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_u...
--- /Users/admin/pgsql/src/test/regress/expected/subselect.out 2025-09-12 02:43:12
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/subselect.out 2025-09-12 02:44:59
@@ -2884,13 +2884,15 @@
EXPLAIN (COSTS OFF)
SELECT * FROM onek, (VALUES('RFAAAA'), ('VJAAAA')) AS v (i)
WHERE onek.stringu1 = v.i;
- QUERY PLAN
--------------------------------------------------------------
+ QUERY PLAN
+-------------------------------------------------------------------
Nested Loop
-> Values Scan on "*VALUES*"
- -> Index Scan using onek_stringu1 on onek
- Index Cond: (stringu1 = ("*VALUES*".column1)::text)
-(4 rows)
+ -> Bitmap Heap Scan on onek
+ Recheck Cond: (stringu1 = ("*VALUES*".column1)::text)
+ -> Bitmap Index Scan on onek_stringu1
+ Index Cond: (stringu1 = ("*VALUES*".column1)::text)
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/subselect.out /Users/admin/pgsql/build/testrun/recovery/027_stream...
--- /Users/admin/pgsql/src/test/regress/expected/subselect.out 2025-09-12 02:43:12
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/subselect.out 2025-09-12 02:45:41
@@ -2884,13 +2884,15 @@
EXPLAIN (COSTS OFF)
SELECT * FROM onek, (VALUES('RFAAAA'), ('VJAAAA')) AS v (i)
WHERE onek.stringu1 = v.i;
- QUERY PLAN
--------------------------------------------------------------
+ QUERY PLAN
+-------------------------------------------------------------------
Nested Loop
-> Values Scan on "*VALUES*"
- -> Index Scan using onek_stringu1 on onek
- Index Cond: (stringu1 = ("*VALUES*".column1)::text)
-(4 rows)
+ -> Bitmap Heap Scan on onek
+ Recheck Cond: (stringu1 = ("*VALUES*".column1)::text)
+ -> Bitmap Index Scan on onek_stringu1
+ Index Cond: (stringu1 = ("*VALUES*".column1)::text)
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/subselect.out /Users/admin/pgsql/build/testrun/regress/regress/res...
--- /Users/admin/pgsql/src/test/regress/expected/subselect.out 2025-09-12 02:43:12
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/subselect.out 2025-09-12 02:44:58
@@ -2884,13 +2884,15 @@
EXPLAIN (COSTS OFF)
SELECT * FROM onek, (VALUES('RFAAAA'), ('VJAAAA')) AS v (i)
WHERE onek.stringu1 = v.i;
- QUERY PLAN
--------------------------------------------------------------
+ QUERY PLAN
+-------------------------------------------------------------------
Nested Loop
-> Values Scan on "*VALUES*"
- -> Index Scan using onek_stringu1 on onek
- Index Cond: (stringu1 = ("*VALUES*".column1)::text)
-(4 rows)
+ -> Bitmap Heap Scan on onek
+ Recheck Cond: (stringu1 = ("*VALUES*".column1)::text)
+ -> Bitmap Index Scan on onek_stringu1
+ Index Cond: (stringu1 = ("*VALUES*".column1)::text)
... |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out 2025-09-12 02:43:10.225570905 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/subselect.out 2025-09-12 02:44:52.69778820...
@@ -2884,13 +2884,15 @@
EXPLAIN (COSTS OFF)
SELECT * FROM onek, (VALUES('RFAAAA'), ('VJAAAA')) AS v (i)
WHERE onek.stringu1 = v.i;
- QUERY PLAN
--------------------------------------------------------------
+ QUERY PLAN
+-------------------------------------------------------------------
Nested Loop
-> Values Scan on "*VALUES*"
- -> Index Scan using onek_stringu1 on onek
- Index Cond: (stringu1 = ("*VALUES*".column1)::text)
-(4 rows)
+ -> Bitmap Heap Scan on onek
+ Recheck Cond: (stringu1 = ("*VALUES*".column1)::text)
+ -> Bitmap Index Scan on onek_stringu1
+ Index Cond: (stringu1 = ("*VALUES*".column1)::text)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out /tmp/cirrus-ci-build/build/testrun/recovery/027_st...
--- /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out 2025-09-12 02:43:10.225570905 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/subselect.out 2025-09-12 02:46:09.673714...
@@ -2884,13 +2884,15 @@
EXPLAIN (COSTS OFF)
SELECT * FROM onek, (VALUES('RFAAAA'), ('VJAAAA')) AS v (i)
WHERE onek.stringu1 = v.i;
- QUERY PLAN
--------------------------------------------------------------
+ QUERY PLAN
+-------------------------------------------------------------------
Nested Loop
-> Values Scan on "*VALUES*"
- -> Index Scan using onek_stringu1 on onek
- Index Cond: (stringu1 = ("*VALUES*".column1)::text)
-(4 rows)
+ -> Bitmap Heap Scan on onek
+ Recheck Cond: (stringu1 = ("*VALUES*".column1)::text)
+ -> Bitmap Index Scan on onek_stringu1
+ Index Cond: (stringu1 = ("*VALUES*".column1)::text)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out /tmp/cirrus-ci-build/build/testrun/regress/regress...
--- /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out 2025-09-12 02:43:10.225570905 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/subselect.out 2025-09-12 02:44:49.989767871 +0000
@@ -2884,13 +2884,15 @@
EXPLAIN (COSTS OFF)
SELECT * FROM onek, (VALUES('RFAAAA'), ('VJAAAA')) AS v (i)
WHERE onek.stringu1 = v.i;
- QUERY PLAN
--------------------------------------------------------------
+ QUERY PLAN
+-------------------------------------------------------------------
Nested Loop
-> Values Scan on "*VALUES*"
- -> Index Scan using onek_stringu1 on onek
- Index Cond: (stringu1 = ("*VALUES*".column1)::text)
-(4 rows)
+ -> Bitmap Heap Scan on onek
+ Recheck Cond: (stringu1 = ("*VALUES*".column1)::text)
+ -> Bitmap Index Scan on onek_stringu1
+ Index Cond: (stringu1 = ("*VALUES*".column1)::text)
... |
|
Linux - Debian Bookworm - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out 2025-09-12 02:43:09.305913869 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/subselect.out 2025-09-12 02:48:51.869183686 +0000
@@ -2884,13 +2884,15 @@
EXPLAIN (COSTS OFF)
SELECT * FROM onek, (VALUES('RFAAAA'), ('VJAAAA')) AS v (i)
WHERE onek.stringu1 = v.i;
- QUERY PLAN
--------------------------------------------------------------
+ QUERY PLAN
+-------------------------------------------------------------------
Nested Loop
-> Values Scan on "*VALUES*"
- -> Index Scan using onek_stringu1 on onek
- Index Cond: (stringu1 = ("*VALUES*".column1)::text)
-(4 rows)
+ -> Bitmap Heap Scan on onek
+ Recheck Cond: (stringu1 = ("*VALUES*".column1)::text)
+ -> Bitmap Index Scan on onek_stringu1
+ Index Cond: (stringu1 = ("*VALUES*".column1)::text)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check/r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out 2025-09-12 02:43:09.305913869 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/subselect.out 2025-09-12 02:50:34.169100699 +0000
@@ -2884,13 +2884,15 @@
EXPLAIN (COSTS OFF)
SELECT * FROM onek, (VALUES('RFAAAA'), ('VJAAAA')) AS v (i)
WHERE onek.stringu1 = v.i;
- QUERY PLAN
--------------------------------------------------------------
+ QUERY PLAN
+-------------------------------------------------------------------
Nested Loop
-> Values Scan on "*VALUES*"
- -> Index Scan using onek_stringu1 on onek
- Index Cond: (stringu1 = ("*VALUES*".column1)::text)
-(4 rows)
+ -> Bitmap Heap Scan on onek
+ Recheck Cond: (stringu1 = ("*VALUES*".column1)::text)
+ -> Bitmap Index Scan on onek_stringu1
+ Index Cond: (stringu1 = ("*VALUES*".column1)::text)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out /tmp/cirrus-ci-build/src/test/regress/results/subs...
--- /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out 2025-09-12 02:43:09.305913869 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/subselect.out 2025-09-12 02:45:13.129467040 +0000
@@ -2884,13 +2884,15 @@
EXPLAIN (COSTS OFF)
SELECT * FROM onek, (VALUES('RFAAAA'), ('VJAAAA')) AS v (i)
WHERE onek.stringu1 = v.i;
- QUERY PLAN
--------------------------------------------------------------
+ QUERY PLAN
+-------------------------------------------------------------------
Nested Loop
-> Values Scan on "*VALUES*"
- -> Index Scan using onek_stringu1 on onek
- Index Cond: (stringu1 = ("*VALUES*".column1)::text)
-(4 rows)
+ -> Bitmap Heap Scan on onek
+ Recheck Cond: (stringu1 = ("*VALUES*".column1)::text)
+ -> Bitmap Index Scan on onek_stringu1
+ Index Cond: (stringu1 = ("*VALUES*".column1)::text)
... |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out 2025-09-12 02:43:09.832079000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/subselect.out 2025-09-12 02:44:42.81041500...
@@ -2884,13 +2884,15 @@
EXPLAIN (COSTS OFF)
SELECT * FROM onek, (VALUES('RFAAAA'), ('VJAAAA')) AS v (i)
WHERE onek.stringu1 = v.i;
- QUERY PLAN
--------------------------------------------------------------
+ QUERY PLAN
+-------------------------------------------------------------------
Nested Loop
-> Values Scan on "*VALUES*"
- -> Index Scan using onek_stringu1 on onek
- Index Cond: (stringu1 = ("*VALUES*".column1)::text)
-(4 rows)
+ -> Bitmap Heap Scan on onek
+ Recheck Cond: (stringu1 = ("*VALUES*".column1)::text)
+ -> Bitmap Index Scan on onek_stringu1
+ Index Cond: (stringu1 = ("*VALUES*".column1)::text)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out /tmp/cirrus-ci-build/build/testrun/recovery/027_st...
--- /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out 2025-09-12 02:43:09.832079000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/subselect.out 2025-09-12 02:45:47.348081...
@@ -2884,13 +2884,15 @@
EXPLAIN (COSTS OFF)
SELECT * FROM onek, (VALUES('RFAAAA'), ('VJAAAA')) AS v (i)
WHERE onek.stringu1 = v.i;
- QUERY PLAN
--------------------------------------------------------------
+ QUERY PLAN
+-------------------------------------------------------------------
Nested Loop
-> Values Scan on "*VALUES*"
- -> Index Scan using onek_stringu1 on onek
- Index Cond: (stringu1 = ("*VALUES*".column1)::text)
-(4 rows)
+ -> Bitmap Heap Scan on onek
+ Recheck Cond: (stringu1 = ("*VALUES*".column1)::text)
+ -> Bitmap Index Scan on onek_stringu1
+ Index Cond: (stringu1 = ("*VALUES*".column1)::text)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out /tmp/cirrus-ci-build/build/testrun/regress/regress...
--- /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out 2025-09-12 02:43:09.832079000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/subselect.out 2025-09-12 02:44:43.027276000 +0000
@@ -2884,13 +2884,15 @@
EXPLAIN (COSTS OFF)
SELECT * FROM onek, (VALUES('RFAAAA'), ('VJAAAA')) AS v (i)
WHERE onek.stringu1 = v.i;
- QUERY PLAN
--------------------------------------------------------------
+ QUERY PLAN
+-------------------------------------------------------------------
Nested Loop
-> Values Scan on "*VALUES*"
- -> Index Scan using onek_stringu1 on onek
- Index Cond: (stringu1 = ("*VALUES*".column1)::text)
-(4 rows)
+ -> Bitmap Heap Scan on onek
+ Recheck Cond: (stringu1 = ("*VALUES*".column1)::text)
+ -> Bitmap Index Scan on onek_stringu1
+ Index Cond: (stringu1 = ("*VALUES*".column1)::text)
... |
| 55/6007 |
Inconsistent update in the MERGE command |
|
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-09-01 16:29:06.961562000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/postgres_fdw-running/regress/results/postgres_fdw.out 2025-09-01 16:36:30.6695530...
@@ -12700,8 +12700,7 @@
FROM postgres_fdw_get_connections(true);
server_name | closed | remote_backend_pid
-------------+--------+--------------------
- loopback | t | t
-(1 row)
+(0 rows)
-- Clean up
\set VERBOSITY default |
| 55/5693 |
Fix replica identity checks for MERGE command on published table. |
| 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-09-01 16:29:06.961562000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/postgres_fdw-running/regress/results/postgres_fdw.out 2025-09-01 16:36:30.6695530...
@@ -12700,8 +12700,7 @@
FROM postgres_fdw_get_connections(true);
server_name | closed | remote_backend_pid
-------------+--------+--------------------
- loopback | t | t
-(1 row)
+(0 rows)
-- Clean up
\set VERBOSITY default |
| 55/5899 |
Explicitly enable meson features in CI |
| 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-09-01 16:29:06.961562000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/postgres_fdw-running/regress/results/postgres_fdw.out 2025-09-01 16:36:30.6695530...
@@ -12700,8 +12700,7 @@
FROM postgres_fdw_get_connections(true);
server_name | closed | remote_backend_pid
-------------+--------+--------------------
- loopback | t | t
-(1 row)
+(0 rows)
-- Clean up
\set VERBOSITY default |
| 55/5996 |
Fixes a trivial bug in dumped parse/query/plan trees |
| 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-09-01 16:29:06.961562000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/postgres_fdw-running/regress/results/postgres_fdw.out 2025-09-01 16:36:30.6695530...
@@ -12700,8 +12700,7 @@
FROM postgres_fdw_get_connections(true);
server_name | closed | remote_backend_pid
-------------+--------+--------------------
- loopback | t | t
-(1 row)
+(0 rows)
-- Clean up
\set VERBOSITY default |
| 55/5899 |
Explicitly enable meson features in CI |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/tuplesort.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/tuplesort.out 2025-09-01 12:29:05.463331014 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/tuplesort.out 2025-09-01 12:31:30.30714566...
@@ -223,32 +223,17 @@
BEGIN;
SET LOCAL enable_indexscan = false;
CLUSTER abbrev_abort_uuids USING abbrev_abort_uuids__abort_increasing_idx;
+ERROR: could not read blocks 143..158 in file "base/16387/t66_44575": Operation canceled
-- head
SELECT id, abort_increasing, abort_decreasing, noabort_increasing, noabort_decreasing
FROM abbrev_abort_uuids
ORDER BY ctid LIMIT 5;
- id | abort_increasing | abort_decreasing | noabort_increasing ...
--------+--------------------------------------+--------------------------------------+---------------------------------...
- 1 | 00000000-0000-0000-0000-000000000000 | 00000000-0000-0000-0000-000000020000 | 00000000-0000-0000-0000-00000000...
- 2 | 00000000-0000-0000-0000-000000000001 | 00000000-0000-0000-0000-000000019999 | 00000001-0000-0000-0000-00000000...
- 3 | 00000000-0000-0000-0000-000000000002 | 00000000-0000-0000-0000-000000019998 | 00000002-0000-0000-0000-00000000...
- 20004 | 00000000-0000-0000-0000-000000000002 | 00000000-0000-0000-0000-000000019998 | 00000002-0000-0000-0000-00000000...
- 4 | 00000000-0000-0000-0000-000000000003 | 00000000-0000-0000-0000-000000019997 | 00000003-0000-0000-0000-00000000...
-(5 rows)
... |
| 55/5996 |
Fixes a trivial bug in dumped parse/query/plan trees |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/tuplesort.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/tuplesort.out 2025-09-01 12:29:05.463331014 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/tuplesort.out 2025-09-01 12:31:30.30714566...
@@ -223,32 +223,17 @@
BEGIN;
SET LOCAL enable_indexscan = false;
CLUSTER abbrev_abort_uuids USING abbrev_abort_uuids__abort_increasing_idx;
+ERROR: could not read blocks 143..158 in file "base/16387/t66_44575": Operation canceled
-- head
SELECT id, abort_increasing, abort_decreasing, noabort_increasing, noabort_decreasing
FROM abbrev_abort_uuids
ORDER BY ctid LIMIT 5;
- id | abort_increasing | abort_decreasing | noabort_increasing ...
--------+--------------------------------------+--------------------------------------+---------------------------------...
- 1 | 00000000-0000-0000-0000-000000000000 | 00000000-0000-0000-0000-000000020000 | 00000000-0000-0000-0000-00000000...
- 2 | 00000000-0000-0000-0000-000000000001 | 00000000-0000-0000-0000-000000019999 | 00000001-0000-0000-0000-00000000...
- 3 | 00000000-0000-0000-0000-000000000002 | 00000000-0000-0000-0000-000000019998 | 00000002-0000-0000-0000-00000000...
- 20004 | 00000000-0000-0000-0000-000000000002 | 00000000-0000-0000-0000-000000019998 | 00000002-0000-0000-0000-00000000...
- 4 | 00000000-0000-0000-0000-000000000003 | 00000000-0000-0000-0000-000000019997 | 00000003-0000-0000-0000-00000000...
-(5 rows)
... |
| 55/6007 |
Inconsistent update in the MERGE command |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/tuplesort.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/tuplesort.out 2025-09-01 12:29:05.463331014 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/tuplesort.out 2025-09-01 12:31:30.30714566...
@@ -223,32 +223,17 @@
BEGIN;
SET LOCAL enable_indexscan = false;
CLUSTER abbrev_abort_uuids USING abbrev_abort_uuids__abort_increasing_idx;
+ERROR: could not read blocks 143..158 in file "base/16387/t66_44575": Operation canceled
-- head
SELECT id, abort_increasing, abort_decreasing, noabort_increasing, noabort_decreasing
FROM abbrev_abort_uuids
ORDER BY ctid LIMIT 5;
- id | abort_increasing | abort_decreasing | noabort_increasing ...
--------+--------------------------------------+--------------------------------------+---------------------------------...
- 1 | 00000000-0000-0000-0000-000000000000 | 00000000-0000-0000-0000-000000020000 | 00000000-0000-0000-0000-00000000...
- 2 | 00000000-0000-0000-0000-000000000001 | 00000000-0000-0000-0000-000000019999 | 00000001-0000-0000-0000-00000000...
- 3 | 00000000-0000-0000-0000-000000000002 | 00000000-0000-0000-0000-000000019998 | 00000002-0000-0000-0000-00000000...
- 20004 | 00000000-0000-0000-0000-000000000002 | 00000000-0000-0000-0000-000000019998 | 00000002-0000-0000-0000-00000000...
- 4 | 00000000-0000-0000-0000-000000000003 | 00000000-0000-0000-0000-000000019997 | 00000003-0000-0000-0000-00000000...
-(5 rows)
... |
| 55/5693 |
Fix replica identity checks for MERGE command on published table. |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/tuplesort.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/tuplesort.out 2025-09-01 12:29:05.463331014 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/tuplesort.out 2025-09-01 12:31:30.30714566...
@@ -223,32 +223,17 @@
BEGIN;
SET LOCAL enable_indexscan = false;
CLUSTER abbrev_abort_uuids USING abbrev_abort_uuids__abort_increasing_idx;
+ERROR: could not read blocks 143..158 in file "base/16387/t66_44575": Operation canceled
-- head
SELECT id, abort_increasing, abort_decreasing, noabort_increasing, noabort_decreasing
FROM abbrev_abort_uuids
ORDER BY ctid LIMIT 5;
- id | abort_increasing | abort_decreasing | noabort_increasing ...
--------+--------------------------------------+--------------------------------------+---------------------------------...
- 1 | 00000000-0000-0000-0000-000000000000 | 00000000-0000-0000-0000-000000020000 | 00000000-0000-0000-0000-00000000...
- 2 | 00000000-0000-0000-0000-000000000001 | 00000000-0000-0000-0000-000000019999 | 00000001-0000-0000-0000-00000000...
- 3 | 00000000-0000-0000-0000-000000000002 | 00000000-0000-0000-0000-000000019998 | 00000002-0000-0000-0000-00000000...
- 20004 | 00000000-0000-0000-0000-000000000002 | 00000000-0000-0000-0000-000000019998 | 00000002-0000-0000-0000-00000000...
- 4 | 00000000-0000-0000-0000-000000000003 | 00000000-0000-0000-0000-000000019997 | 00000003-0000-0000-0000-00000000...
-(5 rows)
... |