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.
| 59/5839 |
problems with toast.* reloptions |
 |
Windows - Server 2022, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/modules/injection_points/expected/vacuum.out C:/cirrus/build/testrun/inj...
--- C:/cirrus/src/test/modules/injection_points/expected/vacuum.out 2026-05-01 21:58:22.838444100 +0000
+++ C:/cirrus/build/testrun/injection_points/regress/results/vacuum.out 2026-05-01 22:09:19.098914700 +0000
@@ -47,41 +47,34 @@
(autovacuum_enabled=false,
vacuum_index_cleanup=true, toast.vacuum_index_cleanup=false,
vacuum_truncate=true, toast.vacuum_truncate=false);
+ERROR: unrecognized parameter namespace "toast"
CREATE TABLE vac_tab_off_toast_on(i int, j text) WITH
(autovacuum_enabled=false,
vacuum_index_cleanup=false, toast.vacuum_index_cleanup=true,
vacuum_truncate=false, toast.vacuum_truncate=true);
+ERROR: unrecognized parameter namespace "toast"
-- Multiple relations should use their options in isolation.
VACUUM vac_tab_on_toast_off, vac_tab_off_toast_on;
-NOTICE: notice triggered for injection point vacuum-index-cleanup-enabled
-NOTICE: notice triggered for injection point vacuum-truncate-enabled
-NOTICE: notice triggered for injection point vacuum-index-cleanup-disabled
-NOTICE: notice triggered for injection point vacuum-truncate-disabled
-NOTICE: notice triggered for injection point vacuum-index-cleanup-disabled
... |
|
macOS - Sequoia - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/modules/injection_points/expected/vacuum.out /Users/admin/pgsql/build/testrun/injec...
--- /Users/admin/pgsql/src/test/modules/injection_points/expected/vacuum.out 2026-05-01 21:57:35
+++ /Users/admin/pgsql/build/testrun/injection_points/regress/results/vacuum.out 2026-05-01 22:04:51
@@ -47,41 +47,34 @@
(autovacuum_enabled=false,
vacuum_index_cleanup=true, toast.vacuum_index_cleanup=false,
vacuum_truncate=true, toast.vacuum_truncate=false);
+ERROR: unrecognized parameter namespace "toast"
CREATE TABLE vac_tab_off_toast_on(i int, j text) WITH
(autovacuum_enabled=false,
vacuum_index_cleanup=false, toast.vacuum_index_cleanup=true,
vacuum_truncate=false, toast.vacuum_truncate=true);
+ERROR: unrecognized parameter namespace "toast"
-- Multiple relations should use their options in isolation.
VACUUM vac_tab_on_toast_off, vac_tab_off_toast_on;
-NOTICE: notice triggered for injection point vacuum-index-cleanup-enabled
-NOTICE: notice triggered for injection point vacuum-truncate-enabled
-NOTICE: notice triggered for injection point vacuum-index-cleanup-disabled
-NOTICE: notice triggered for injection point vacuum-truncate-disabled
-NOTICE: notice triggered for injection point vacuum-index-cleanup-disabled
... |
|
Linux - Debian Trixie - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/vacuum.out /tmp/cirrus-ci-build/build/testrun/i...
--- /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/vacuum.out 2026-05-01 21:58:19.011223534 +0000
+++ /tmp/cirrus-ci-build/build/testrun/injection_points/regress/results/vacuum.out 2026-05-01 22:03:39.131631265 +0000
@@ -47,41 +47,34 @@
(autovacuum_enabled=false,
vacuum_index_cleanup=true, toast.vacuum_index_cleanup=false,
vacuum_truncate=true, toast.vacuum_truncate=false);
+ERROR: unrecognized parameter namespace "toast"
CREATE TABLE vac_tab_off_toast_on(i int, j text) WITH
(autovacuum_enabled=false,
vacuum_index_cleanup=false, toast.vacuum_index_cleanup=true,
vacuum_truncate=false, toast.vacuum_truncate=true);
+ERROR: unrecognized parameter namespace "toast"
-- Multiple relations should use their options in isolation.
VACUUM vac_tab_on_toast_off, vac_tab_off_toast_on;
-NOTICE: notice triggered for injection point vacuum-index-cleanup-enabled
-NOTICE: notice triggered for injection point vacuum-truncate-enabled
-NOTICE: notice triggered for injection point vacuum-index-cleanup-disabled
-NOTICE: notice triggered for injection point vacuum-truncate-disabled
-NOTICE: notice triggered for injection point vacuum-index-cleanup-disabled
... |
|
Linux - Debian Trixie - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/vacuum.out /tmp/cirrus-ci-build/src/test/module...
--- /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/vacuum.out 2026-05-01 21:59:10.314157951 +0000
+++ /tmp/cirrus-ci-build/src/test/modules/injection_points/results/vacuum.out 2026-05-01 22:08:32.232305451 +0000
@@ -47,41 +47,34 @@
(autovacuum_enabled=false,
vacuum_index_cleanup=true, toast.vacuum_index_cleanup=false,
vacuum_truncate=true, toast.vacuum_truncate=false);
+ERROR: unrecognized parameter namespace "toast"
CREATE TABLE vac_tab_off_toast_on(i int, j text) WITH
(autovacuum_enabled=false,
vacuum_index_cleanup=false, toast.vacuum_index_cleanup=true,
vacuum_truncate=false, toast.vacuum_truncate=true);
+ERROR: unrecognized parameter namespace "toast"
-- Multiple relations should use their options in isolation.
VACUUM vac_tab_on_toast_off, vac_tab_off_toast_on;
-NOTICE: notice triggered for injection point vacuum-index-cleanup-enabled
-NOTICE: notice triggered for injection point vacuum-truncate-enabled
-NOTICE: notice triggered for injection point vacuum-index-cleanup-disabled
-NOTICE: notice triggered for injection point vacuum-truncate-disabled
-NOTICE: notice triggered for injection point vacuum-index-cleanup-disabled
... |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/modules/injection_points/expected/vacuum.out /home/postgres/postgres/build/tes...
--- /home/postgres/postgres/src/test/modules/injection_points/expected/vacuum.out 2026-05-01 21:59:34.138446306 +0000
+++ /home/postgres/postgres/build/testrun/injection_points/regress/results/vacuum.out 2026-05-01 22:02:49.128976040 +000...
@@ -47,41 +47,34 @@
(autovacuum_enabled=false,
vacuum_index_cleanup=true, toast.vacuum_index_cleanup=false,
vacuum_truncate=true, toast.vacuum_truncate=false);
+ERROR: unrecognized parameter namespace "toast"
CREATE TABLE vac_tab_off_toast_on(i int, j text) WITH
(autovacuum_enabled=false,
vacuum_index_cleanup=false, toast.vacuum_index_cleanup=true,
vacuum_truncate=false, toast.vacuum_truncate=true);
+ERROR: unrecognized parameter namespace "toast"
-- Multiple relations should use their options in isolation.
VACUUM vac_tab_on_toast_off, vac_tab_off_toast_on;
-NOTICE: notice triggered for injection point vacuum-index-cleanup-enabled
-NOTICE: notice triggered for injection point vacuum-truncate-enabled
-NOTICE: notice triggered for injection point vacuum-index-cleanup-disabled
-NOTICE: notice triggered for injection point vacuum-truncate-disabled
-NOTICE: notice triggered for injection point vacuum-index-cleanup-disabled
... |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/vacuum.out /tmp/cirrus-ci-build/build/testrun/i...
--- /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/vacuum.out 2026-05-01 21:58:42.158595000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/injection_points/regress/results/vacuum.out 2026-05-01 22:03:20.727000000 +0000
@@ -47,41 +47,34 @@
(autovacuum_enabled=false,
vacuum_index_cleanup=true, toast.vacuum_index_cleanup=false,
vacuum_truncate=true, toast.vacuum_truncate=false);
+ERROR: unrecognized parameter namespace "toast"
CREATE TABLE vac_tab_off_toast_on(i int, j text) WITH
(autovacuum_enabled=false,
vacuum_index_cleanup=false, toast.vacuum_index_cleanup=true,
vacuum_truncate=false, toast.vacuum_truncate=true);
+ERROR: unrecognized parameter namespace "toast"
-- Multiple relations should use their options in isolation.
VACUUM vac_tab_on_toast_off, vac_tab_off_toast_on;
-NOTICE: notice triggered for injection point vacuum-index-cleanup-enabled
-NOTICE: notice triggered for injection point vacuum-truncate-enabled
-NOTICE: notice triggered for injection point vacuum-index-cleanup-disabled
-NOTICE: notice triggered for injection point vacuum-truncate-disabled
-NOTICE: notice triggered for injection point vacuum-index-cleanup-disabled
... |
|
OpenBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/modules/injection_points/expected/vacuum.out /home/postgres/postgres/build/tes...
--- /home/postgres/postgres/src/test/modules/injection_points/expected/vacuum.out Fri May 1 21:58:45 2026
+++ /home/postgres/postgres/build/testrun/injection_points/regress/results/vacuum.out Fri May 1 22:04:55 2026
@@ -47,41 +47,34 @@
(autovacuum_enabled=false,
vacuum_index_cleanup=true, toast.vacuum_index_cleanup=false,
vacuum_truncate=true, toast.vacuum_truncate=false);
+ERROR: unrecognized parameter namespace "toast"
CREATE TABLE vac_tab_off_toast_on(i int, j text) WITH
(autovacuum_enabled=false,
vacuum_index_cleanup=false, toast.vacuum_index_cleanup=true,
vacuum_truncate=false, toast.vacuum_truncate=true);
+ERROR: unrecognized parameter namespace "toast"
-- Multiple relations should use their options in isolation.
VACUUM vac_tab_on_toast_off, vac_tab_off_toast_on;
-NOTICE: notice triggered for injection point vacuum-index-cleanup-enabled
-NOTICE: notice triggered for injection point vacuum-truncate-enabled
-NOTICE: notice triggered for injection point vacuum-index-cleanup-disabled
-NOTICE: notice triggered for injection point vacuum-truncate-disabled
-NOTICE: notice triggered for injection point vacuum-index-cleanup-disabled
... |
| 59/6664 |
Support EXCEPT for ALL SEQUENCES publications |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/publication.out C:/cirrus/build/testrun/pg_upgrade/002_...
--- C:/cirrus/src/test/regress/expected/publication.out 2026-05-01 13:22:30.392979600 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/publication.out 2026-05-01 13:27:38.954189600 +0000
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/publication.out C:/cirrus/build/testrun/recovery/027_st...
--- C:/cirrus/src/test/regress/expected/publication.out 2026-05-01 13:22:30.392979600 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/publication.out 2026-05-01 13:31:48.865222200 +0000
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/publication.out C:/cirrus/build/testrun/regress/regress...
--- C:/cirrus/src/test/regress/expected/publication.out 2026-05-01 13:22:30.392979600 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/publication.out 2026-05-01 13:27:34.690032100 +0000
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/publication.out C:/cirrus/build/testrun/test_plan_advic...
--- C:/cirrus/src/test/regress/expected/publication.out 2026-05-01 13:22:30.392979600 +0000
+++ C:/cirrus/build/testrun/test_plan_advice/001_replan_regress/data/results/publication.out 2026-05-01 13:27:33.3453154...
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
|
macOS - Sequoia - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/publication.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg...
--- /Users/admin/pgsql/src/test/regress/expected/publication.out 2026-05-01 13:22:07
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/publication.out 2026-05-01 13:27:30
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/publication.out /Users/admin/pgsql/build/testrun/recovery/027_stre...
--- /Users/admin/pgsql/src/test/regress/expected/publication.out 2026-05-01 13:22:07
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/publication.out 2026-05-01 13:29:50
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/publication.out /Users/admin/pgsql/build/testrun/regress/regress/r...
--- /Users/admin/pgsql/src/test/regress/expected/publication.out 2026-05-01 13:22:07
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/publication.out 2026-05-01 13:27:27
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/publication.out /Users/admin/pgsql/build/testrun/test_plan_advice/...
--- /Users/admin/pgsql/src/test/regress/expected/publication.out 2026-05-01 13:22:07
+++ /Users/admin/pgsql/build/testrun/test_plan_advice/001_replan_regress/data/results/publication.out 2026-05-01 13:27:2...
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
|
Linux - Debian Trixie - Meson |
| regress |
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 2026-05-01 13:22:19.241844086 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/publication.out 2026-05-01 13:27:44.992115...
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/publication.out /tmp/cirrus-ci-build/build/testrun/recovery/027_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/publication.out 2026-05-01 13:22:19.241844086 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/publication.out 2026-05-01 13:29:17.0715...
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/publication.out /tmp/cirrus-ci-build/build/testrun/regress/regre...
--- /tmp/cirrus-ci-build/src/test/regress/expected/publication.out 2026-05-01 13:22:19.241844086 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/publication.out 2026-05-01 13:27:43.320130874 +0000
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/publication.out /tmp/cirrus-ci-build/build/testrun/test_plan_adv...
--- /tmp/cirrus-ci-build/src/test/regress/expected/publication.out 2026-05-01 13:22:19.241844086 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/publication.out 2026-05-01 13:27...
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/publication.out /home/postgres/postgres/build/testrun/pg_upgr...
--- /home/postgres/postgres/src/test/regress/expected/publication.out 2026-05-01 13:23:40.193678509 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/publication.out 2026-05-01 13:27:30.054...
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/publication.out /home/postgres/postgres/build/testrun/recover...
--- /home/postgres/postgres/src/test/regress/expected/publication.out 2026-05-01 13:23:40.193678509 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/publication.out 2026-05-01 13:28:25.7...
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/publication.out /home/postgres/postgres/build/testrun/regress...
--- /home/postgres/postgres/src/test/regress/expected/publication.out 2026-05-01 13:23:40.193678509 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/publication.out 2026-05-01 13:27:27.023380407 +0000
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/publication.out /home/postgres/postgres/build/testrun/test_pl...
--- /home/postgres/postgres/src/test/regress/expected/publication.out 2026-05-01 13:23:40.193678509 +0000
+++ /home/postgres/postgres/build/testrun/test_plan_advice/001_replan_regress/data/results/publication.out 2026-05-01 13...
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
|
Linux - Debian Trixie - Autoconf |
| regress |
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 2026-05-01 13:22:29.226654286 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/publication.out 2026-05-01 13:31:28.185770049 +0000
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/publication.out /tmp/cirrus-ci-build/src/test/modules/test_plan_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/publication.out 2026-05-01 13:22:29.226654286 +0000
+++ /tmp/cirrus-ci-build/src/test/modules/test_plan_advice/tmp_check/results/publication.out 2026-05-01 13:33:26.0576623...
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/publication.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check...
--- /tmp/cirrus-ci-build/src/test/regress/expected/publication.out 2026-05-01 13:22:29.226654286 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/publication.out 2026-05-01 13:33:10.357674627 +0000
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
| regress |
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 2026-05-01 13:22:29.226654286 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/publication.out 2026-05-01 13:28:42.805911734 +0000
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
|
OpenBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/publication.out /home/postgres/postgres/build/testrun/pg_upgr...
--- /home/postgres/postgres/src/test/regress/expected/publication.out Fri May 1 13:22:35 2026
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/publication.out Fri May 1 13:27:24 202...
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/publication.out /home/postgres/postgres/build/testrun/recover...
--- /home/postgres/postgres/src/test/regress/expected/publication.out Fri May 1 13:22:35 2026
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/publication.out Fri May 1 13:29:45 2...
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/publication.out /home/postgres/postgres/build/testrun/regress...
--- /home/postgres/postgres/src/test/regress/expected/publication.out Fri May 1 13:22:35 2026
+++ /home/postgres/postgres/build/testrun/regress/regress/results/publication.out Fri May 1 13:27:17 2026
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/publication.out /home/postgres/postgres/build/testrun/test_pl...
--- /home/postgres/postgres/src/test/regress/expected/publication.out Fri May 1 13:22:35 2026
+++ /home/postgres/postgres/build/testrun/test_plan_advice/001_replan_regress/data/results/publication.out Fri May 1 13...
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
|
FreeBSD - Meson |
| regress |
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 2026-05-01 13:23:09.466536000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/publication.out 2026-05-01 13:28:08.233906...
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/publication.out /tmp/cirrus-ci-build/build/testrun/recovery/027_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/publication.out 2026-05-01 13:23:09.466536000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/publication.out 2026-05-01 13:30:04.2005...
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/publication.out /tmp/cirrus-ci-build/build/testrun/regress/regre...
--- /tmp/cirrus-ci-build/src/test/regress/expected/publication.out 2026-05-01 13:23:09.466536000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/publication.out 2026-05-01 13:28:14.192916000 +0000
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/publication.out /tmp/cirrus-ci-build/build/testrun/test_plan_adv...
--- /tmp/cirrus-ci-build/src/test/regress/expected/publication.out 2026-05-01 13:23:09.466536000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/publication.out 2026-05-01 13:28...
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
| 59/6543 |
synchronized_standby_slots behavior inconsistent with quorum-based synchronous replication |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/modules/unsafe_tests/expected/guc_privs.out C:/cirrus/build/testrun/unsa...
--- C:/cirrus/src/test/modules/unsafe_tests/expected/guc_privs.out 2026-05-01 11:16:02.939276600 +0000
+++ C:/cirrus/build/testrun/unsafe_tests/regress/results/guc_privs.out 2026-05-01 11:26:44.902714600 +0000
@@ -590,8 +590,7 @@
-- Cannot set synchronized_standby_slots to an invalid slot name
ALTER SYSTEM SET synchronized_standby_slots='invalid*';
ERROR: invalid value for parameter "synchronized_standby_slots": "invalid*"
-DETAIL: replication slot name "invalid*" contains invalid character
-HINT: Replication slot names may only contain lower case letters, numbers, and the underscore character.
+DETAIL: syntax error at or near "*"
-- Can set synchronized_standby_slots to a non-existent slot name
ALTER SYSTEM SET synchronized_standby_slots='missing';
-- Reset the GUC |
|
Linux - Debian Trixie - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/modules/unsafe_tests/expected/guc_privs.out /tmp/cirrus-ci-build/build/testrun/un...
--- /tmp/cirrus-ci-build/src/test/modules/unsafe_tests/expected/guc_privs.out 2026-05-01 11:15:55.308138508 +0000
+++ /tmp/cirrus-ci-build/build/testrun/unsafe_tests/regress/results/guc_privs.out 2026-05-01 11:20:56.208830338 +0000
@@ -590,8 +590,7 @@
-- Cannot set synchronized_standby_slots to an invalid slot name
ALTER SYSTEM SET synchronized_standby_slots='invalid*';
ERROR: invalid value for parameter "synchronized_standby_slots": "invalid*"
-DETAIL: replication slot name "invalid*" contains invalid character
-HINT: Replication slot names may only contain lower case letters, numbers, and the underscore character.
+DETAIL: syntax error at or near "*"
-- Can set synchronized_standby_slots to a non-existent slot name
ALTER SYSTEM SET synchronized_standby_slots='missing';
-- Reset the GUC |
|
macOS - Sequoia - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/modules/unsafe_tests/expected/guc_privs.out /Users/admin/pgsql/build/testrun/unsafe...
--- /Users/admin/pgsql/src/test/modules/unsafe_tests/expected/guc_privs.out 2026-05-01 11:15:42
+++ /Users/admin/pgsql/build/testrun/unsafe_tests/regress/results/guc_privs.out 2026-05-01 11:23:02
@@ -590,8 +590,7 @@
-- Cannot set synchronized_standby_slots to an invalid slot name
ALTER SYSTEM SET synchronized_standby_slots='invalid*';
ERROR: invalid value for parameter "synchronized_standby_slots": "invalid*"
-DETAIL: replication slot name "invalid*" contains invalid character
-HINT: Replication slot names may only contain lower case letters, numbers, and the underscore character.
+DETAIL: syntax error at or near "*"
-- Can set synchronized_standby_slots to a non-existent slot name
ALTER SYSTEM SET synchronized_standby_slots='missing';
-- Reset the GUC |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/modules/unsafe_tests/expected/guc_privs.out /tmp/cirrus-ci-build/build/testrun/un...
--- /tmp/cirrus-ci-build/src/test/modules/unsafe_tests/expected/guc_privs.out 2026-05-01 11:16:03.912551000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/unsafe_tests/regress/results/guc_privs.out 2026-05-01 11:20:51.141732000 +0000
@@ -590,8 +590,7 @@
-- Cannot set synchronized_standby_slots to an invalid slot name
ALTER SYSTEM SET synchronized_standby_slots='invalid*';
ERROR: invalid value for parameter "synchronized_standby_slots": "invalid*"
-DETAIL: replication slot name "invalid*" contains invalid character
-HINT: Replication slot names may only contain lower case letters, numbers, and the underscore character.
+DETAIL: syntax error at or near "*"
-- Can set synchronized_standby_slots to a non-existent slot name
ALTER SYSTEM SET synchronized_standby_slots='missing';
-- Reset the GUC |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/modules/unsafe_tests/expected/guc_privs.out /home/postgres/postgres/build/test...
--- /home/postgres/postgres/src/test/modules/unsafe_tests/expected/guc_privs.out 2026-05-01 11:17:28.690621220 +0000
+++ /home/postgres/postgres/build/testrun/unsafe_tests/regress/results/guc_privs.out 2026-05-01 11:20:44.525022287 +0000
@@ -590,8 +590,7 @@
-- Cannot set synchronized_standby_slots to an invalid slot name
ALTER SYSTEM SET synchronized_standby_slots='invalid*';
ERROR: invalid value for parameter "synchronized_standby_slots": "invalid*"
-DETAIL: replication slot name "invalid*" contains invalid character
-HINT: Replication slot names may only contain lower case letters, numbers, and the underscore character.
+DETAIL: syntax error at or near "*"
-- Can set synchronized_standby_slots to a non-existent slot name
ALTER SYSTEM SET synchronized_standby_slots='missing';
-- Reset the GUC |
|
Linux - Debian Trixie - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/modules/unsafe_tests/expected/guc_privs.out /tmp/cirrus-ci-build/src/test/modules...
--- /tmp/cirrus-ci-build/src/test/modules/unsafe_tests/expected/guc_privs.out 2026-05-01 11:16:21.822917968 +0000
+++ /tmp/cirrus-ci-build/src/test/modules/unsafe_tests/results/guc_privs.out 2026-05-01 11:23:54.790067700 +0000
@@ -590,8 +590,7 @@
-- Cannot set synchronized_standby_slots to an invalid slot name
ALTER SYSTEM SET synchronized_standby_slots='invalid*';
ERROR: invalid value for parameter "synchronized_standby_slots": "invalid*"
-DETAIL: replication slot name "invalid*" contains invalid character
-HINT: Replication slot names may only contain lower case letters, numbers, and the underscore character.
+DETAIL: syntax error at or near "*"
-- Can set synchronized_standby_slots to a non-existent slot name
ALTER SYSTEM SET synchronized_standby_slots='missing';
-- Reset the GUC |
|
OpenBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/modules/unsafe_tests/expected/guc_privs.out /home/postgres/postgres/build/test...
--- /home/postgres/postgres/src/test/modules/unsafe_tests/expected/guc_privs.out Fri May 1 11:16:16 2026
+++ /home/postgres/postgres/build/testrun/unsafe_tests/regress/results/guc_privs.out Fri May 1 11:22:47 2026
@@ -590,8 +590,7 @@
-- Cannot set synchronized_standby_slots to an invalid slot name
ALTER SYSTEM SET synchronized_standby_slots='invalid*';
ERROR: invalid value for parameter "synchronized_standby_slots": "invalid*"
-DETAIL: replication slot name "invalid*" contains invalid character
-HINT: Replication slot names may only contain lower case letters, numbers, and the underscore character.
+DETAIL: syntax error at or near "*"
-- Can set synchronized_standby_slots to a non-existent slot name
ALTER SYSTEM SET synchronized_standby_slots='missing';
-- Reset the GUC |
| 59/6699 |
Allow SJE to recognize GiST-backed temporal primary keys |
|
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 2026-04-30 21:35:20.530886269 +0000
+++ /home/postgres/postgres/build/testrun/isolation/isolation/results/timeouts.out 2026-04-30 21:38:25.194772913 +0000
@@ -11,7 +11,7 @@
step sto: SET statement_timeout = '10ms';
step locktbl: LOCK TABLE accounts; <waiting ...>
step locktbl: <... completed>
-ERROR: canceling statement due to statement timeout
+ERROR: canceling statement due to user request
starting permutation: rdtbl lto locktbl
step rdtbl: SELECT * FROM accounts; |
| 59/5831 |
pgindent: improve formatting of multiline comments |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out /tmp/cirrus-ci-build/build/testrun/regress-runn...
--- /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out 2026-04-30 20:34:44.682871000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress-running/regress/results/create_index.out 2026-04-30 20:45:40.409099000 +0...
@@ -2056,7 +2056,7 @@
QUERY PLAN
----------------------------------------------------------------------------
Aggregate
- -> Index Only Scan using tenk1_thous_tenthous on tenk1 t1
+ -> Seq Scan on tenk1 t1
Filter: ((thousand = 42) OR (thousand = (SubPlan expr_1)))
SubPlan expr_1
-> Limit
@@ -2255,7 +2255,7 @@
Aggregate
-> Nested Loop Left Join
Join Filter: (tenk1.hundred = 42)
- -> Index Only Scan using tenk1_hundred on tenk1
+ -> Seq Scan on tenk1
-> Memoize
Cache Key: tenk1.hundred
... |
| 59/6251 |
Use ROLERECURSE_PRIVS in is_admin_of_role() |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out /tmp/cirrus-ci-build/build/testrun/regress-runn...
--- /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out 2026-04-30 18:56:29.331436000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress-running/regress/results/create_index.out 2026-04-30 19:06:22.531751000 +0...
@@ -2056,7 +2056,7 @@
QUERY PLAN
----------------------------------------------------------------------------
Aggregate
- -> Index Only Scan using tenk1_thous_tenthous on tenk1 t1
+ -> Seq Scan on tenk1 t1
Filter: ((thousand = 42) OR (thousand = (SubPlan expr_1)))
SubPlan expr_1
-> Limit
@@ -2225,9 +2225,11 @@
Filter: ((thousand = 42) OR (thousand = 41) OR (tenthous = 2))
-> Bitmap Index Scan on tenk2_hundred
Index Cond: (hundred = 42)
- -> Index Only Scan using tenk1_hundred on tenk1
- Index Cond: (hundred = 42)
-(9 rows)
+ -> Bitmap Heap Scan on tenk1
... |
| 59/5988 |
disallow alter individual column if partition key contains wholerow reference |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/name.out /home/postgres/postgres/build/testrun/regress/regres...
--- /home/postgres/postgres/src/test/regress/expected/name.out 2026-04-30 18:37:27.485146812 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/name.out 2026-04-30 18:38:25.828773696 +0000
@@ -1,197 +1,2 @@
---
--- NAME
--- all inputs are silently truncated at NAMEDATALEN-1 (63) characters
---
--- fixed-length by reference
-SELECT name 'name string' = name 'name string' AS "True";
- True
-------
- t
-(1 row)
-
-SELECT name 'name string' = name 'name string ' AS "False";
- False
--------
- f
-(1 row)
... |
| 59/6121 |
avoid call ATPostAlterTypeCleanup twice |
|
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 2026-04-30 18:37:06.633147282 +0000
+++ /home/postgres/postgres/build/testrun/isolation/isolation/results/timeouts.out 2026-04-30 18:39:56.684673323 +0000
@@ -11,7 +11,7 @@
step sto: SET statement_timeout = '10ms';
step locktbl: LOCK TABLE accounts; <waiting ...>
step locktbl: <... completed>
-ERROR: canceling statement due to statement timeout
+ERROR: canceling statement due to user request
starting permutation: rdtbl lto locktbl
step rdtbl: SELECT * FROM accounts; |
| 59/4971 |
[CREATE|RE] INDEX CONCURRENTLY with single heap scan |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/indexing.out C:/cirrus/build/testrun/pg_upgrade/002_pg_...
--- C:/cirrus/src/test/regress/expected/indexing.out 2026-04-30 10:30:22.238171100 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/indexing.out 2026-04-30 10:36:04.845414900 +0000
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/indexing.out C:/cirrus/build/testrun/recovery/027_strea...
--- C:/cirrus/src/test/regress/expected/indexing.out 2026-04-30 10:30:22.238171100 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/indexing.out 2026-04-30 10:39:51.965957800 +0000
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/indexing.out C:/cirrus/build/testrun/regress/regress/re...
--- C:/cirrus/src/test/regress/expected/indexing.out 2026-04-30 10:30:22.238171100 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/indexing.out 2026-04-30 10:35:53.029025300 +0000
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/indexing.out C:/cirrus/build/testrun/test_plan_advice/0...
--- C:/cirrus/src/test/regress/expected/indexing.out 2026-04-30 10:30:22.238171100 +0000
+++ C:/cirrus/build/testrun/test_plan_advice/001_replan_regress/data/results/indexing.out 2026-04-30 10:36:07.276083900 ...
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
|
Linux - Debian Trixie - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_p...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2026-04-30 10:30:53.227906548 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/indexing.out 2026-04-30 10:36:34.659260762...
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/build/testrun/recovery/027_str...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2026-04-30 10:30:53.227906548 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/indexing.out 2026-04-30 10:38:11.7831791...
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/build/testrun/regress/regress/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2026-04-30 10:30:53.227906548 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/indexing.out 2026-04-30 10:36:34.939260555 +0000
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/build/testrun/test_plan_advice...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2026-04-30 10:30:53.227906548 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/indexing.out 2026-04-30 10:36:40...
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
|
macOS - Sequoia - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/indexing.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_up...
--- /Users/admin/pgsql/src/test/regress/expected/indexing.out 2026-04-30 10:30:30
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/indexing.out 2026-04-30 10:36:03
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/indexing.out /Users/admin/pgsql/build/testrun/recovery/027_stream_...
--- /Users/admin/pgsql/src/test/regress/expected/indexing.out 2026-04-30 10:30:30
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/indexing.out 2026-04-30 10:37:33
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/indexing.out /Users/admin/pgsql/build/testrun/regress/regress/resu...
--- /Users/admin/pgsql/src/test/regress/expected/indexing.out 2026-04-30 10:30:30
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/indexing.out 2026-04-30 10:36:04
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/indexing.out /Users/admin/pgsql/build/testrun/test_plan_advice/001...
--- /Users/admin/pgsql/src/test/regress/expected/indexing.out 2026-04-30 10:30:30
+++ /Users/admin/pgsql/build/testrun/test_plan_advice/001_replan_regress/data/results/indexing.out 2026-04-30 10:36:05
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
|
Linux - Debian Trixie - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2026-04-30 10:30:59.243567121 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/indexing.out 2026-04-30 10:40:49.622692827 +0000
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/src/test/modules/test_plan_adv...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2026-04-30 10:30:59.243567121 +0000
+++ /tmp/cirrus-ci-build/src/test/modules/test_plan_advice/tmp_check/results/indexing.out 2026-04-30 10:42:53.806203479 ...
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check/re...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2026-04-30 10:30:59.243567121 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/indexing.out 2026-04-30 10:42:50.138216741 +0000
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/src/test/regress/results/index...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2026-04-30 10:30:59.243567121 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/indexing.out 2026-04-30 10:38:19.171528373 +0000
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_p...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2026-04-30 10:30:49.256236000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/indexing.out 2026-04-30 10:37:06.563084000...
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/build/testrun/recovery/027_str...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2026-04-30 10:30:49.256236000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/indexing.out 2026-04-30 10:39:00.4051100...
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/build/testrun/regress/regress/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2026-04-30 10:30:49.256236000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/indexing.out 2026-04-30 10:36:56.536967000 +0000
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/build/testrun/test_plan_advice...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2026-04-30 10:30:49.256236000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/indexing.out 2026-04-30 10:37:19...
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/indexing.out /home/postgres/postgres/build/testrun/pg_upgrade...
--- /home/postgres/postgres/src/test/regress/expected/indexing.out 2026-04-30 10:31:32.228214958 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/indexing.out 2026-04-30 10:35:20.738169...
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/indexing.out /home/postgres/postgres/build/testrun/recovery/0...
--- /home/postgres/postgres/src/test/regress/expected/indexing.out 2026-04-30 10:31:32.228214958 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/indexing.out 2026-04-30 10:36:10.6049...
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/indexing.out /home/postgres/postgres/build/testrun/regress/re...
--- /home/postgres/postgres/src/test/regress/expected/indexing.out 2026-04-30 10:31:32.228214958 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/indexing.out 2026-04-30 10:35:20.531093696 +0000
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/indexing.out /home/postgres/postgres/build/testrun/test_plan_...
--- /home/postgres/postgres/src/test/regress/expected/indexing.out 2026-04-30 10:31:32.228214958 +0000
+++ /home/postgres/postgres/build/testrun/test_plan_advice/001_replan_regress/data/results/indexing.out 2026-04-30 10:35...
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
|
OpenBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/indexing.out /home/postgres/postgres/build/testrun/pg_upgrade...
--- /home/postgres/postgres/src/test/regress/expected/indexing.out Thu Apr 30 10:30:36 2026
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/indexing.out Thu Apr 30 10:36:04 2026
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/indexing.out /home/postgres/postgres/build/testrun/recovery/0...
--- /home/postgres/postgres/src/test/regress/expected/indexing.out Thu Apr 30 10:30:36 2026
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/indexing.out Thu Apr 30 10:39:04 2026
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/indexing.out /home/postgres/postgres/build/testrun/regress/re...
--- /home/postgres/postgres/src/test/regress/expected/indexing.out Thu Apr 30 10:30:36 2026
+++ /home/postgres/postgres/build/testrun/regress/regress/results/indexing.out Thu Apr 30 10:36:01 2026
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/indexing.out /home/postgres/postgres/build/testrun/test_plan_...
--- /home/postgres/postgres/src/test/regress/expected/indexing.out Thu Apr 30 10:30:36 2026
+++ /home/postgres/postgres/build/testrun/test_plan_advice/001_replan_regress/data/results/indexing.out Thu Apr 30 10:36...
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
| 59/6059 |
Improving the names generated for indexes on expressions |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/indexing.out C:/cirrus/build/testrun/pg_upgrade/002_pg_...
--- C:/cirrus/src/test/regress/expected/indexing.out 2026-04-30 08:19:37.641993600 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/indexing.out 2026-04-30 08:25:15.298325300 +0000
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/indexing.out C:/cirrus/build/testrun/recovery/027_strea...
--- C:/cirrus/src/test/regress/expected/indexing.out 2026-04-30 08:19:37.641993600 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/indexing.out 2026-04-30 08:29:11.478441700 +0000
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/indexing.out C:/cirrus/build/testrun/regress/regress/re...
--- C:/cirrus/src/test/regress/expected/indexing.out 2026-04-30 08:19:37.641993600 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/indexing.out 2026-04-30 08:25:08.594701100 +0000
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/indexing.out C:/cirrus/build/testrun/test_plan_advice/0...
--- C:/cirrus/src/test/regress/expected/indexing.out 2026-04-30 08:19:37.641993600 +0000
+++ C:/cirrus/build/testrun/test_plan_advice/001_replan_regress/data/results/indexing.out 2026-04-30 08:25:22.303689200 ...
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
|
Linux - Debian Trixie - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_p...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2026-04-30 08:18:59.665736913 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/indexing.out 2026-04-30 08:24:49.095168775...
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/build/testrun/recovery/027_str...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2026-04-30 08:18:59.665736913 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/indexing.out 2026-04-30 08:26:32.5877690...
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/build/testrun/regress/regress/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2026-04-30 08:18:59.665736913 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/indexing.out 2026-04-30 08:24:50.679176842 +0000
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/build/testrun/test_plan_advice...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2026-04-30 08:18:59.665736913 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/indexing.out 2026-04-30 08:24:55...
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
|
macOS - Sequoia - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/indexing.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_up...
--- /Users/admin/pgsql/src/test/regress/expected/indexing.out 2026-04-30 08:24:37
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/indexing.out 2026-04-30 08:29:50
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/indexing.out /Users/admin/pgsql/build/testrun/recovery/027_stream_...
--- /Users/admin/pgsql/src/test/regress/expected/indexing.out 2026-04-30 08:24:37
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/indexing.out 2026-04-30 08:31:21
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/indexing.out /Users/admin/pgsql/build/testrun/regress/regress/resu...
--- /Users/admin/pgsql/src/test/regress/expected/indexing.out 2026-04-30 08:24:37
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/indexing.out 2026-04-30 08:29:52
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/indexing.out /Users/admin/pgsql/build/testrun/test_plan_advice/001...
--- /Users/admin/pgsql/src/test/regress/expected/indexing.out 2026-04-30 08:24:37
+++ /Users/admin/pgsql/build/testrun/test_plan_advice/001_replan_regress/data/results/indexing.out 2026-04-30 08:29:55
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
|
Linux - Debian Trixie - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2026-04-30 08:19:24.334145141 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/indexing.out 2026-04-30 08:29:14.563446068 +0000
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/src/test/modules/test_plan_adv...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2026-04-30 08:19:24.334145141 +0000
+++ /tmp/cirrus-ci-build/src/test/modules/test_plan_advice/tmp_check/results/indexing.out 2026-04-30 08:30:34.011684089 ...
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check/re...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2026-04-30 08:19:24.334145141 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/indexing.out 2026-04-30 08:30:45.287722615 +0000
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/src/test/regress/results/index...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2026-04-30 08:19:24.334145141 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/indexing.out 2026-04-30 08:26:13.943385267 +0000
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/indexing.out /home/postgres/postgres/build/testrun/pg_upgrade...
--- /home/postgres/postgres/src/test/regress/expected/indexing.out 2026-04-30 08:19:06.343274343 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/indexing.out 2026-04-30 08:23:07.823190...
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/indexing.out /home/postgres/postgres/build/testrun/recovery/0...
--- /home/postgres/postgres/src/test/regress/expected/indexing.out 2026-04-30 08:19:06.343274343 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/indexing.out 2026-04-30 08:24:09.4554...
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/indexing.out /home/postgres/postgres/build/testrun/regress/re...
--- /home/postgres/postgres/src/test/regress/expected/indexing.out 2026-04-30 08:19:06.343274343 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/indexing.out 2026-04-30 08:22:55.102680580 +0000
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/indexing.out /home/postgres/postgres/build/testrun/test_plan_...
--- /home/postgres/postgres/src/test/regress/expected/indexing.out 2026-04-30 08:19:06.343274343 +0000
+++ /home/postgres/postgres/build/testrun/test_plan_advice/001_replan_regress/data/results/indexing.out 2026-04-30 08:23...
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_p...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2026-04-30 08:18:48.844152000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/indexing.out 2026-04-30 08:24:40.915807000...
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/build/testrun/recovery/027_str...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2026-04-30 08:18:48.844152000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/indexing.out 2026-04-30 08:26:05.8772840...
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/build/testrun/regress/regress/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2026-04-30 08:18:48.844152000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/indexing.out 2026-04-30 08:24:44.260945000 +0000
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/build/testrun/test_plan_advice...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2026-04-30 08:18:48.844152000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/indexing.out 2026-04-30 08:24:45...
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
|
OpenBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/indexing.out /home/postgres/postgres/build/testrun/pg_upgrade...
--- /home/postgres/postgres/src/test/regress/expected/indexing.out Thu Apr 30 08:20:04 2026
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/indexing.out Thu Apr 30 08:25:40 2026
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/indexing.out /home/postgres/postgres/build/testrun/recovery/0...
--- /home/postgres/postgres/src/test/regress/expected/indexing.out Thu Apr 30 08:20:04 2026
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/indexing.out Thu Apr 30 08:28:46 2026
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/indexing.out /home/postgres/postgres/build/testrun/regress/re...
--- /home/postgres/postgres/src/test/regress/expected/indexing.out Thu Apr 30 08:20:04 2026
+++ /home/postgres/postgres/build/testrun/regress/regress/results/indexing.out Thu Apr 30 08:25:39 2026
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/indexing.out /home/postgres/postgres/build/testrun/test_plan_...
--- /home/postgres/postgres/src/test/regress/expected/indexing.out Thu Apr 30 08:20:04 2026
+++ /home/postgres/postgres/build/testrun/test_plan_advice/001_replan_regress/data/results/indexing.out Thu Apr 30 08:25...
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
| 59/6397 |
extended statistic (examine_variable) ignored CollateExpr |
|
OpenBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/collate.icu.utf8.out /home/postgres/postgres/build/testrun/pg...
--- /home/postgres/postgres/src/test/regress/expected/collate.icu.utf8.out Wed Apr 29 21:57:38 2026
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/collate.icu.utf8.out Wed Apr 29 22:00:0...
@@ -2753,15 +2753,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/collate.icu.utf8.out /home/postgres/postgres/build/testrun/re...
--- /home/postgres/postgres/src/test/regress/expected/collate.icu.utf8.out Wed Apr 29 21:57:38 2026
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/collate.icu.utf8.out Wed Apr 29 22:02...
@@ -2753,15 +2753,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/collate.icu.utf8.out /home/postgres/postgres/build/testrun/re...
--- /home/postgres/postgres/src/test/regress/expected/collate.icu.utf8.out Wed Apr 29 21:57:38 2026
+++ /home/postgres/postgres/build/testrun/regress/regress/results/collate.icu.utf8.out Wed Apr 29 22:00:00 2026
@@ -2753,15 +2753,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/collate.icu.utf8.out /home/postgres/postgres/build/testrun/te...
--- /home/postgres/postgres/src/test/regress/expected/collate.icu.utf8.out Wed Apr 29 21:57:38 2026
+++ /home/postgres/postgres/build/testrun/test_plan_advice/001_replan_regress/data/results/collate.icu.utf8.out Wed Apr ...
@@ -2753,15 +2753,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
|
Linux - Debian Trixie - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp...
--- /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out 2026-04-29 21:57:33.224402716 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/collate.icu.utf8.out 2026-04-29 22:03:55.716330830 +0000
@@ -2753,15 +2753,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out /tmp/cirrus-ci-build/src/test/modules/test_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out 2026-04-29 21:57:33.224402716 +0000
+++ /tmp/cirrus-ci-build/src/test/modules/test_plan_advice/tmp_check/results/collate.icu.utf8.out 2026-04-29 22:05:56.52...
@@ -2753,15 +2753,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out /tmp/cirrus-ci-build/src/test/recovery/tmp_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out 2026-04-29 21:57:33.224402716 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/collate.icu.utf8.out 2026-04-29 22:06:03.836311970 +0000
@@ -2753,15 +2753,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out /tmp/cirrus-ci-build/src/test/regress/resul...
--- /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out 2026-04-29 21:57:33.224402716 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/collate.icu.utf8.out 2026-04-29 22:02:01.080346134 +0000
@@ -2753,15 +2753,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
|
Linux - Debian Trixie - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out /tmp/cirrus-ci-build/build/testrun/pg_upgra...
--- /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out 2026-04-29 21:57:27.784355423 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/collate.icu.utf8.out 2026-04-29 21:59:41.7...
@@ -2753,15 +2753,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out /tmp/cirrus-ci-build/build/testrun/recovery...
--- /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out 2026-04-29 21:57:27.784355423 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/collate.icu.utf8.out 2026-04-29 22:01:18...
@@ -2753,15 +2753,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out /tmp/cirrus-ci-build/build/testrun/regress/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out 2026-04-29 21:57:27.784355423 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/collate.icu.utf8.out 2026-04-29 21:59:38.547340341 +0000
@@ -2753,15 +2753,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out /tmp/cirrus-ci-build/build/testrun/test_pla...
--- /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out 2026-04-29 21:57:27.784355423 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/collate.icu.utf8.out 2026-04-29 ...
@@ -2753,15 +2753,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/collate.icu.utf8.out /home/postgres/postgres/build/testrun/pg...
--- /home/postgres/postgres/src/test/regress/expected/collate.icu.utf8.out 2026-04-29 21:57:57.238890473 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/collate.icu.utf8.out 2026-04-29 21:59:4...
@@ -2753,15 +2753,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out /tmp/cirrus-ci-build/build/testrun/pg_upgra...
--- /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out 2026-04-29 21:57:27.840069000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/collate.icu.utf8.out 2026-04-29 21:59:59.6...
@@ -2753,15 +2753,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out /tmp/cirrus-ci-build/build/testrun/recovery...
--- /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out 2026-04-29 21:57:27.840069000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/collate.icu.utf8.out 2026-04-29 22:01:39...
@@ -2753,15 +2753,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out /tmp/cirrus-ci-build/build/testrun/regress/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out 2026-04-29 21:57:27.840069000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/collate.icu.utf8.out 2026-04-29 22:00:00.491659000 +0000
@@ -2753,15 +2753,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out /tmp/cirrus-ci-build/build/testrun/test_pla...
--- /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out 2026-04-29 21:57:27.840069000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/collate.icu.utf8.out 2026-04-29 ...
@@ -2753,15 +2753,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
|
macOS - Sequoia - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/collate.icu.utf8.out /Users/admin/pgsql/build/testrun/pg_upgrade/0...
--- /Users/admin/pgsql/src/test/regress/expected/collate.icu.utf8.out 2026-04-29 21:57:35
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/collate.icu.utf8.out 2026-04-29 22:00:31
@@ -2753,15 +2753,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/collate.icu.utf8.out /Users/admin/pgsql/build/testrun/recovery/027...
--- /Users/admin/pgsql/src/test/regress/expected/collate.icu.utf8.out 2026-04-29 21:57:35
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/collate.icu.utf8.out 2026-04-29 22:02:02
@@ -2753,15 +2753,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/collate.icu.utf8.out /Users/admin/pgsql/build/testrun/regress/regr...
--- /Users/admin/pgsql/src/test/regress/expected/collate.icu.utf8.out 2026-04-29 21:57:35
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/collate.icu.utf8.out 2026-04-29 22:00:24
@@ -2753,15 +2753,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/collate.icu.utf8.out /Users/admin/pgsql/build/testrun/test_plan_ad...
--- /Users/admin/pgsql/src/test/regress/expected/collate.icu.utf8.out 2026-04-29 21:57:35
+++ /Users/admin/pgsql/build/testrun/test_plan_advice/001_replan_regress/data/results/collate.icu.utf8.out 2026-04-29 22...
@@ -2753,15 +2753,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
| 59/4817 |
COPY (on_error table) saving error info to a table |
|
Linux - Debian Trixie - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_u...
--- /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out 2026-04-29 13:25:38.702625094 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/copy2.out 2026-04-29 13:28:44.326045516 +0...
@@ -969,13 +969,13 @@
ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2);
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: new row for relation "err_tbl" violates check constraint "cc2"
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43090, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc2;
ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail;
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43090, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc3;
BEGIN; |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stream...
--- /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out 2026-04-29 13:25:38.702625094 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/copy2.out 2026-04-29 13:30:50.388223039 ...
@@ -969,13 +969,13 @@
ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2);
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: new row for relation "err_tbl" violates check constraint "cc2"
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43101, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc2;
ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail;
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43101, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc3;
BEGIN; |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out /tmp/cirrus-ci-build/build/testrun/regress/regress/res...
--- /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out 2026-04-29 13:25:38.702625094 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/copy2.out 2026-04-29 13:28:42.938007545 +0000
@@ -969,13 +969,13 @@
ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2);
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: new row for relation "err_tbl" violates check constraint "cc2"
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43140, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc2;
ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail;
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43140, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc3;
BEGIN; |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out /tmp/cirrus-ci-build/build/testrun/test_plan_advice/00...
--- /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out 2026-04-29 13:25:38.702625094 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/copy2.out 2026-04-29 13:28:59.39...
@@ -969,13 +969,13 @@
ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2);
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: new row for relation "err_tbl" violates check constraint "cc2"
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43182, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc2;
ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail;
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43182, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc3;
BEGIN; |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/copy2.out C:/cirrus/build/testrun/pg_upgrade/002_pg_upg...
--- C:/cirrus/src/test/regress/expected/copy2.out 2026-04-29 13:12:17.151896900 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/copy2.out 2026-04-29 13:17:24.383896700 +0000
@@ -969,13 +969,13 @@
ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2);
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: new row for relation "err_tbl" violates check constraint "cc2"
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 42180, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc2;
ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail;
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 42180, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc3;
BEGIN; |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/copy2.out C:/cirrus/build/testrun/recovery/027_stream_r...
--- C:/cirrus/src/test/regress/expected/copy2.out 2026-04-29 13:12:17.151896900 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/copy2.out 2026-04-29 13:21:21.453217400 +0000
@@ -969,13 +969,13 @@
ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2);
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: new row for relation "err_tbl" violates check constraint "cc2"
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 41567, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc2;
ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail;
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 41567, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc3;
BEGIN; |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/copy2.out C:/cirrus/build/testrun/regress/regress/resul...
--- C:/cirrus/src/test/regress/expected/copy2.out 2026-04-29 13:12:17.151896900 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/copy2.out 2026-04-29 13:17:16.260854200 +0000
@@ -969,13 +969,13 @@
ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2);
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: new row for relation "err_tbl" violates check constraint "cc2"
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 41930, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc2;
ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail;
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 41930, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc3;
BEGIN; |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/copy2.out C:/cirrus/build/testrun/test_plan_advice/001_...
--- C:/cirrus/src/test/regress/expected/copy2.out 2026-04-29 13:12:17.151896900 +0000
+++ C:/cirrus/build/testrun/test_plan_advice/001_replan_regress/data/results/copy2.out 2026-04-29 13:17:22.349724700 +00...
@@ -969,13 +969,13 @@
ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2);
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: new row for relation "err_tbl" violates check constraint "cc2"
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43175, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc2;
ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail;
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43175, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc3;
BEGIN; |
|
macOS - Sequoia - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/copy2.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgra...
--- /Users/admin/pgsql/src/test/regress/expected/copy2.out 2026-04-29 13:12:06
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/copy2.out 2026-04-29 13:16:49
@@ -969,13 +969,13 @@
ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2);
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: new row for relation "err_tbl" violates check constraint "cc2"
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43707, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc2;
ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail;
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43707, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc3;
BEGIN; |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/copy2.out /Users/admin/pgsql/build/testrun/recovery/027_stream_reg...
--- /Users/admin/pgsql/src/test/regress/expected/copy2.out 2026-04-29 13:12:06
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/copy2.out 2026-04-29 13:19:32
@@ -969,13 +969,13 @@
ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2);
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: new row for relation "err_tbl" violates check constraint "cc2"
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 42972, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc2;
ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail;
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 42972, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc3;
BEGIN; |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/copy2.out /Users/admin/pgsql/build/testrun/regress/regress/results...
--- /Users/admin/pgsql/src/test/regress/expected/copy2.out 2026-04-29 13:12:06
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/copy2.out 2026-04-29 13:16:44
@@ -969,13 +969,13 @@
ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2);
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: new row for relation "err_tbl" violates check constraint "cc2"
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 42793, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc2;
ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail;
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 42793, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc3;
BEGIN; |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/copy2.out /Users/admin/pgsql/build/testrun/test_plan_advice/001_re...
--- /Users/admin/pgsql/src/test/regress/expected/copy2.out 2026-04-29 13:12:06
+++ /Users/admin/pgsql/build/testrun/test_plan_advice/001_replan_regress/data/results/copy2.out 2026-04-29 13:16:55
@@ -969,13 +969,13 @@
ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2);
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: new row for relation "err_tbl" violates check constraint "cc2"
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 42967, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc2;
ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail;
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 42967, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc3;
BEGIN; |
|
OpenBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/copy2.out /home/postgres/postgres/build/testrun/pg_upgrade/00...
--- /home/postgres/postgres/src/test/regress/expected/copy2.out Wed Apr 29 13:12:30 2026
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/copy2.out Wed Apr 29 13:16:01 2026
@@ -969,13 +969,13 @@
ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2);
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: new row for relation "err_tbl" violates check constraint "cc2"
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43651, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc2;
ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail;
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43651, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc3;
BEGIN; |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/copy2.out /home/postgres/postgres/build/testrun/recovery/027_...
--- /home/postgres/postgres/src/test/regress/expected/copy2.out Wed Apr 29 13:12:30 2026
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/copy2.out Wed Apr 29 13:18:36 2026
@@ -969,13 +969,13 @@
ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2);
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: new row for relation "err_tbl" violates check constraint "cc2"
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43319, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc2;
ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail;
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43319, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc3;
BEGIN; |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/copy2.out /home/postgres/postgres/build/testrun/regress/regre...
--- /home/postgres/postgres/src/test/regress/expected/copy2.out Wed Apr 29 13:12:30 2026
+++ /home/postgres/postgres/build/testrun/regress/regress/results/copy2.out Wed Apr 29 13:15:50 2026
@@ -969,13 +969,13 @@
ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2);
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: new row for relation "err_tbl" violates check constraint "cc2"
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43515, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc2;
ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail;
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43515, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc3;
BEGIN; |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/copy2.out /home/postgres/postgres/build/testrun/test_plan_adv...
--- /home/postgres/postgres/src/test/regress/expected/copy2.out Wed Apr 29 13:12:30 2026
+++ /home/postgres/postgres/build/testrun/test_plan_advice/001_replan_regress/data/results/copy2.out Wed Apr 29 13:15:57...
@@ -969,13 +969,13 @@
ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2);
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: new row for relation "err_tbl" violates check constraint "cc2"
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 42980, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc2;
ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail;
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 42980, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc3;
BEGIN; |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/copy2.out /home/postgres/postgres/build/testrun/pg_upgrade/00...
--- /home/postgres/postgres/src/test/regress/expected/copy2.out 2026-04-29 13:13:06.582003992 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/copy2.out 2026-04-29 13:15:32.111315464...
@@ -969,13 +969,13 @@
ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2);
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: new row for relation "err_tbl" violates check constraint "cc2"
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43557, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc2;
ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail;
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43557, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc3;
BEGIN; |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/copy2.out /home/postgres/postgres/build/testrun/recovery/027_...
--- /home/postgres/postgres/src/test/regress/expected/copy2.out 2026-04-29 13:13:06.582003992 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/copy2.out 2026-04-29 13:16:18.6614048...
@@ -969,13 +969,13 @@
ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2);
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: new row for relation "err_tbl" violates check constraint "cc2"
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 42189, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc2;
ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail;
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 42189, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc3;
BEGIN; |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/copy2.out /home/postgres/postgres/build/testrun/regress/regre...
--- /home/postgres/postgres/src/test/regress/expected/copy2.out 2026-04-29 13:13:06.582003992 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/copy2.out 2026-04-29 13:15:25.954583948 +0000
@@ -969,13 +969,13 @@
ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2);
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: new row for relation "err_tbl" violates check constraint "cc2"
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 41902, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc2;
ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail;
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 41902, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc3;
BEGIN; |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/copy2.out /home/postgres/postgres/build/testrun/test_plan_adv...
--- /home/postgres/postgres/src/test/regress/expected/copy2.out 2026-04-29 13:13:06.582003992 +0000
+++ /home/postgres/postgres/build/testrun/test_plan_advice/001_replan_regress/data/results/copy2.out 2026-04-29 13:15:24...
@@ -969,13 +969,13 @@
ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2);
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: new row for relation "err_tbl" violates check constraint "cc2"
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 42097, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc2;
ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail;
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 42097, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc3;
BEGIN; |
|
Linux - Debian Trixie - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/resu...
--- /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out 2026-04-29 13:12:17.198240437 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/copy2.out 2026-04-29 13:20:13.633446973 +0000
@@ -969,13 +969,13 @@
ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2);
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: new row for relation "err_tbl" violates check constraint "cc2"
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43308, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc2;
ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail;
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43308, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc3;
BEGIN; |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out /tmp/cirrus-ci-build/src/test/modules/test_plan_advice...
--- /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out 2026-04-29 13:12:17.198240437 +0000
+++ /tmp/cirrus-ci-build/src/test/modules/test_plan_advice/tmp_check/results/copy2.out 2026-04-29 13:22:32.020490332 +00...
@@ -969,13 +969,13 @@
ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2);
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: new row for relation "err_tbl" violates check constraint "cc2"
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43304, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc2;
ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail;
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43304, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc3;
BEGIN; |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check/resul...
--- /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out 2026-04-29 13:12:17.198240437 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/copy2.out 2026-04-29 13:22:07.028494608 +0000
@@ -969,13 +969,13 @@
ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2);
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: new row for relation "err_tbl" violates check constraint "cc2"
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43163, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc2;
ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail;
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43163, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc3;
BEGIN; |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out /tmp/cirrus-ci-build/src/test/regress/results/copy2.ou...
--- /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out 2026-04-29 13:12:17.198240437 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/copy2.out 2026-04-29 13:17:07.359940510 +0000
@@ -969,13 +969,13 @@
ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2);
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: new row for relation "err_tbl" violates check constraint "cc2"
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43315, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc2;
ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail;
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43315, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc3;
BEGIN; |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_u...
--- /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out 2026-04-29 13:12:20.269710000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/copy2.out 2026-04-29 13:16:32.050196000 +0...
@@ -969,13 +969,13 @@
ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2);
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: new row for relation "err_tbl" violates check constraint "cc2"
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43122, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc2;
ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail;
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43122, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc3;
BEGIN; |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stream...
--- /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out 2026-04-29 13:12:20.269710000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/copy2.out 2026-04-29 13:18:02.746755000 ...
@@ -969,13 +969,13 @@
ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2);
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: new row for relation "err_tbl" violates check constraint "cc2"
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 42916, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc2;
ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail;
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 42916, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc3;
BEGIN; |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out /tmp/cirrus-ci-build/build/testrun/regress/regress/res...
--- /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out 2026-04-29 13:12:20.269710000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/copy2.out 2026-04-29 13:16:23.154104000 +0000
@@ -969,13 +969,13 @@
ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2);
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: new row for relation "err_tbl" violates check constraint "cc2"
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43047, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc2;
ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail;
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43047, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc3;
BEGIN; |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out /tmp/cirrus-ci-build/build/testrun/test_plan_advice/00...
--- /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out 2026-04-29 13:12:20.269710000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/copy2.out 2026-04-29 13:16:42.00...
@@ -969,13 +969,13 @@
ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2);
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: new row for relation "err_tbl" violates check constraint "cc2"
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43102, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc2;
ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail;
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43102, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc3;
BEGIN; |
| 59/6643 |
New Table Access Methods for Multi and Single Inserts |
|
macOS - Sequoia - Meson |
| regress |
diff -U3 /Users/admin/pgsql/contrib/pg_stat_statements/expected/wal.out /Users/admin/pgsql/build/testrun/pg_stat_stateme...
--- /Users/admin/pgsql/contrib/pg_stat_statements/expected/wal.out 2026-04-28 17:20:14
+++ /Users/admin/pgsql/build/testrun/pg_stat_statements/regress/results/wal.out 2026-04-28 17:26:55
@@ -16,7 +16,7 @@
query | calls | rows | wal_bytes_generated | wal_records_genera...
--------------------------------------------------------------+-------+------+---------------------+-------------------...
DELETE FROM pgss_wal_tab WHERE a > $1 | 1 | 1 | t | t ...
- INSERT INTO pgss_wal_tab VALUES(generate_series($1, $2), $3) | 1 | 10 | t | t ...
+ INSERT INTO pgss_wal_tab VALUES(generate_series($1, $2), $3) | 1 | 10 | t | t ...
SELECT pg_stat_statements_reset() IS NOT NULL AS t | 1 | 1 | f | f ...
SET pg_stat_statements.track_utility = $1 | 1 | 0 | f | f ...
UPDATE pgss_wal_tab SET b = $1 WHERE a > $2 | 1 | 3 | t | t ... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/vacuum.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgr...
--- /Users/admin/pgsql/src/test/regress/expected/vacuum.out 2026-04-28 17:20:17
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/vacuum.out 2026-04-28 17:24:42
@@ -231,7 +231,7 @@
SELECT pg_relation_size('vac_truncate_test') > 0;
?column?
----------
- t
+ f
(1 row)
SET vacuum_truncate = false;
@@ -251,7 +251,7 @@
SELECT pg_relation_size('vac_truncate_test') > 0;
?column?
----------
- t
+ f
(1 row)
... |
| regress |
diff -U3 /Users/admin/pgsql/contrib/pg_walinspect/expected/pg_walinspect.out /Users/admin/pgsql/build/testrun/pg_walinsp...
--- /Users/admin/pgsql/contrib/pg_walinspect/expected/pg_walinspect.out 2026-04-28 17:20:14
+++ /Users/admin/pgsql/build/testrun/pg_walinspect/regress/results/pg_walinspect.out 2026-04-28 17:26:56
@@ -98,7 +98,7 @@
WHERE block_ref LIKE concat('%', :'sample_tbl_oid', '%') AND resource_manager = 'Heap';
ok
----
- t
+ f
(1 row)
-- ===================================================================
@@ -109,7 +109,7 @@
WHERE resource_manager = 'Heap' AND record_type = 'INSERT';
ok
----
- t
+ f
(1 row)
... |
| regress |
diff -U3 /Users/admin/pgsql/contrib/postgres_fdw/expected/postgres_fdw.out /Users/admin/pgsql/build/testrun/postgres_fdw...
--- /Users/admin/pgsql/contrib/postgres_fdw/expected/postgres_fdw.out 2026-04-28 17:20:14
+++ /Users/admin/pgsql/build/testrun/postgres_fdw/regress/results/postgres_fdw.out 2026-04-28 17:27:01
@@ -3016,13 +3016,16 @@
-- GROUP BY clause having expressions
explain (verbose, costs off)
select c2/2, sum(c2) * (c2/2) from ft1 group by c2/2 order by c2/2;
- QUERY PLAN
-------------------------------------------------------------------------------------------------------------------
- Foreign Scan
+ QUERY PLAN
+---------------------------------------------------------------------------------------
+ Sort
Output: ((c2 / 2)), ((sum(c2) * (c2 / 2)))
- Relations: Aggregate on (public.ft1)
- Remote SQL: SELECT (c2 / 2), (sum(c2) * (c2 / 2)) FROM "S 1"."T 1" GROUP BY 1 ORDER BY (c2 / 2) ASC NULLS LAST
-(4 rows)
+ Sort Key: ((ft1.c2 / 2))
+ -> Foreign Scan
+ Output: ((c2 / 2)), ((sum(c2) * (c2 / 2)))
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/vacuum.out /Users/admin/pgsql/build/testrun/recovery/027_stream_re...
--- /Users/admin/pgsql/src/test/regress/expected/vacuum.out 2026-04-28 17:20:17
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/vacuum.out 2026-04-28 17:26:03
@@ -231,7 +231,7 @@
SELECT pg_relation_size('vac_truncate_test') > 0;
?column?
----------
- t
+ f
(1 row)
SET vacuum_truncate = false;
@@ -251,7 +251,7 @@
SELECT pg_relation_size('vac_truncate_test') > 0;
?column?
----------
- t
+ f
(1 row)
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/vacuum.out /Users/admin/pgsql/build/testrun/regress/regress/result...
--- /Users/admin/pgsql/src/test/regress/expected/vacuum.out 2026-04-28 17:20:17
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/vacuum.out 2026-04-28 17:24:39
@@ -231,7 +231,7 @@
SELECT pg_relation_size('vac_truncate_test') > 0;
?column?
----------
- t
+ f
(1 row)
SET vacuum_truncate = false;
@@ -251,7 +251,7 @@
SELECT pg_relation_size('vac_truncate_test') > 0;
?column?
----------
- t
+ f
(1 row)
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/vacuum.out /Users/admin/pgsql/build/testrun/test_plan_advice/001_r...
--- /Users/admin/pgsql/src/test/regress/expected/vacuum.out 2026-04-28 17:20:17
+++ /Users/admin/pgsql/build/testrun/test_plan_advice/001_replan_regress/data/results/vacuum.out 2026-04-28 17:24:41
@@ -231,7 +231,7 @@
SELECT pg_relation_size('vac_truncate_test') > 0;
?column?
----------
- t
+ f
(1 row)
SET vacuum_truncate = false;
@@ -251,7 +251,7 @@
SELECT pg_relation_size('vac_truncate_test') > 0;
?column?
----------
- t
+ f
(1 row)
... |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/pg_stat_statements/expected/wal.out C:/cirrus/build/testrun/pg_stat_state...
--- C:/cirrus/contrib/pg_stat_statements/expected/wal.out 2026-04-28 17:20:15.442740200 +0000
+++ C:/cirrus/build/testrun/pg_stat_statements/regress/results/wal.out 2026-04-28 17:29:56.133181200 +0000
@@ -16,7 +16,7 @@
query | calls | rows | wal_bytes_generated | wal_records_genera...
--------------------------------------------------------------+-------+------+---------------------+-------------------...
DELETE FROM pgss_wal_tab WHERE a > $1 | 1 | 1 | t | t ...
- INSERT INTO pgss_wal_tab VALUES(generate_series($1, $2), $3) | 1 | 10 | t | t ...
+ INSERT INTO pgss_wal_tab VALUES(generate_series($1, $2), $3) | 1 | 10 | t | t ...
SELECT pg_stat_statements_reset() IS NOT NULL AS t | 1 | 1 | f | f ...
SET pg_stat_statements.track_utility = $1 | 1 | 0 | f | f ...
UPDATE pgss_wal_tab SET b = $1 WHERE a > $2 | 1 | 3 | t | t ... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/copy.out C:/cirrus/build/testrun/pg_upgrade/002_pg_upgr...
--- C:/cirrus/src/test/regress/expected/copy.out 2026-04-28 17:20:20.144378900 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/copy.out 2026-04-28 17:23:11.635005800 +0000
@@ -624,24 +624,28 @@
INSERT INTO copy_bulk_src SELECT g, 'row-' || g FROM generate_series(1, 2500) g;
CREATE TABLE copy_bulk_dst (a int, b text);
COPY copy_bulk_src TO '/tmp/copy_buffered_bulk_test.csv' CSV;
+ERROR: could not open file "/tmp/copy_buffered_bulk_test.csv" for writing: No such file or directory
+HINT: COPY TO instructs the PostgreSQL server process to write a file. You may want a client-side facility such as psq...
COPY copy_bulk_dst FROM '/tmp/copy_buffered_bulk_test.csv' CSV;
+ERROR: could not open file "/tmp/copy_buffered_bulk_test.csv" for reading: No such file or directory
+HINT: COPY FROM instructs the PostgreSQL server process to read a file. You may want a client-side facility such as ps...
SELECT count(*) FROM copy_bulk_dst;
count
-------
- 2500
+ 0
(1 row)
SELECT min(a), max(a) FROM copy_bulk_dst;
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/pg_walinspect/expected/pg_walinspect.out C:/cirrus/build/testrun/pg_walin...
--- C:/cirrus/contrib/pg_walinspect/expected/pg_walinspect.out 2026-04-28 17:20:15.520080600 +0000
+++ C:/cirrus/build/testrun/pg_walinspect/regress/results/pg_walinspect.out 2026-04-28 17:29:57.337775400 +0000
@@ -98,7 +98,7 @@
WHERE block_ref LIKE concat('%', :'sample_tbl_oid', '%') AND resource_manager = 'Heap';
ok
----
- t
+ f
(1 row)
-- ===================================================================
@@ -109,7 +109,7 @@
WHERE resource_manager = 'Heap' AND record_type = 'INSERT';
ok
----
- t
+ f
(1 row)
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/postgres_fdw/expected/postgres_fdw.out C:/cirrus/build/testrun/postgres_f...
--- C:/cirrus/contrib/postgres_fdw/expected/postgres_fdw.out 2026-04-28 17:20:15.630553400 +0000
+++ C:/cirrus/build/testrun/postgres_fdw/regress/results/postgres_fdw.out 2026-04-28 17:30:10.046740500 +0000
@@ -3016,13 +3016,16 @@
-- GROUP BY clause having expressions
explain (verbose, costs off)
select c2/2, sum(c2) * (c2/2) from ft1 group by c2/2 order by c2/2;
- QUERY PLAN
-------------------------------------------------------------------------------------------------------------------
- Foreign Scan
+ QUERY PLAN
+---------------------------------------------------------------------------------------
+ Sort
Output: ((c2 / 2)), ((sum(c2) * (c2 / 2)))
- Relations: Aggregate on (public.ft1)
- Remote SQL: SELECT (c2 / 2), (sum(c2) * (c2 / 2)) FROM "S 1"."T 1" GROUP BY 1 ORDER BY (c2 / 2) ASC NULLS LAST
-(4 rows)
+ Sort Key: ((ft1.c2 / 2))
+ -> Foreign Scan
+ Output: ((c2 / 2)), ((sum(c2) * (c2 / 2)))
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/copy.out C:/cirrus/build/testrun/recovery/027_stream_re...
--- C:/cirrus/src/test/regress/expected/copy.out 2026-04-28 17:20:20.144378900 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/copy.out 2026-04-28 17:27:09.560575000 +0000
@@ -624,24 +624,28 @@
INSERT INTO copy_bulk_src SELECT g, 'row-' || g FROM generate_series(1, 2500) g;
CREATE TABLE copy_bulk_dst (a int, b text);
COPY copy_bulk_src TO '/tmp/copy_buffered_bulk_test.csv' CSV;
+ERROR: could not open file "/tmp/copy_buffered_bulk_test.csv" for writing: No such file or directory
+HINT: COPY TO instructs the PostgreSQL server process to write a file. You may want a client-side facility such as psq...
COPY copy_bulk_dst FROM '/tmp/copy_buffered_bulk_test.csv' CSV;
+ERROR: could not open file "/tmp/copy_buffered_bulk_test.csv" for reading: No such file or directory
+HINT: COPY FROM instructs the PostgreSQL server process to read a file. You may want a client-side facility such as ps...
SELECT count(*) FROM copy_bulk_dst;
count
-------
- 2500
+ 0
(1 row)
SELECT min(a), max(a) FROM copy_bulk_dst;
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/copy.out C:/cirrus/build/testrun/regress/regress/result...
--- C:/cirrus/src/test/regress/expected/copy.out 2026-04-28 17:20:20.144378900 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/copy.out 2026-04-28 17:23:07.538810800 +0000
@@ -624,24 +624,28 @@
INSERT INTO copy_bulk_src SELECT g, 'row-' || g FROM generate_series(1, 2500) g;
CREATE TABLE copy_bulk_dst (a int, b text);
COPY copy_bulk_src TO '/tmp/copy_buffered_bulk_test.csv' CSV;
+ERROR: could not open file "/tmp/copy_buffered_bulk_test.csv" for writing: No such file or directory
+HINT: COPY TO instructs the PostgreSQL server process to write a file. You may want a client-side facility such as psq...
COPY copy_bulk_dst FROM '/tmp/copy_buffered_bulk_test.csv' CSV;
+ERROR: could not open file "/tmp/copy_buffered_bulk_test.csv" for reading: No such file or directory
+HINT: COPY FROM instructs the PostgreSQL server process to read a file. You may want a client-side facility such as ps...
SELECT count(*) FROM copy_bulk_dst;
count
-------
- 2500
+ 0
(1 row)
SELECT min(a), max(a) FROM copy_bulk_dst;
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/copy.out C:/cirrus/build/testrun/test_plan_advice/001_r...
--- C:/cirrus/src/test/regress/expected/copy.out 2026-04-28 17:20:20.144378900 +0000
+++ C:/cirrus/build/testrun/test_plan_advice/001_replan_regress/data/results/copy.out 2026-04-28 17:23:10.525629600 +000...
@@ -624,24 +624,28 @@
INSERT INTO copy_bulk_src SELECT g, 'row-' || g FROM generate_series(1, 2500) g;
CREATE TABLE copy_bulk_dst (a int, b text);
COPY copy_bulk_src TO '/tmp/copy_buffered_bulk_test.csv' CSV;
+ERROR: could not open file "/tmp/copy_buffered_bulk_test.csv" for writing: No such file or directory
+HINT: COPY TO instructs the PostgreSQL server process to write a file. You may want a client-side facility such as psq...
COPY copy_bulk_dst FROM '/tmp/copy_buffered_bulk_test.csv' CSV;
+ERROR: could not open file "/tmp/copy_buffered_bulk_test.csv" for reading: No such file or directory
+HINT: COPY FROM instructs the PostgreSQL server process to read a file. You may want a client-side facility such as ps...
SELECT count(*) FROM copy_bulk_dst;
count
-------
- 2500
+ 0
(1 row)
SELECT min(a), max(a) FROM copy_bulk_dst;
... |
|
Linux - Debian Trixie - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/pg_stat_statements/expected/wal.out /tmp/cirrus-ci-build/build/testrun/pg_stat_sta...
--- /tmp/cirrus-ci-build/contrib/pg_stat_statements/expected/wal.out 2026-04-28 17:20:08.558306780 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_stat_statements/regress/results/wal.out 2026-04-28 17:28:14.005169841 +0000
@@ -16,7 +16,7 @@
query | calls | rows | wal_bytes_generated | wal_records_genera...
--------------------------------------------------------------+-------+------+---------------------+-------------------...
DELETE FROM pgss_wal_tab WHERE a > $1 | 1 | 1 | t | t ...
- INSERT INTO pgss_wal_tab VALUES(generate_series($1, $2), $3) | 1 | 10 | t | t ...
+ INSERT INTO pgss_wal_tab VALUES(generate_series($1, $2), $3) | 1 | 10 | t | t ...
SELECT pg_stat_statements_reset() IS NOT NULL AS t | 1 | 1 | f | f ...
SET pg_stat_statements.track_utility = $1 | 1 | 0 | f | f ...
UPDATE pgss_wal_tab SET b = $1 WHERE a > $2 | 1 | 3 | t | t ... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/vacuum.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/vacuum.out 2026-04-28 17:20:10.562306822 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/vacuum.out 2026-04-28 17:24:39.557324834 +...
@@ -231,7 +231,7 @@
SELECT pg_relation_size('vac_truncate_test') > 0;
?column?
----------
- t
+ f
(1 row)
SET vacuum_truncate = false;
@@ -251,7 +251,7 @@
SELECT pg_relation_size('vac_truncate_test') > 0;
?column?
----------
- t
+ f
(1 row)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/pg_walinspect/expected/pg_walinspect.out /tmp/cirrus-ci-build/build/testrun/pg_wal...
--- /tmp/cirrus-ci-build/contrib/pg_walinspect/expected/pg_walinspect.out 2026-04-28 17:20:08.570306780 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_walinspect/regress/results/pg_walinspect.out 2026-04-28 17:28:17.589165242 +00...
@@ -98,7 +98,7 @@
WHERE block_ref LIKE concat('%', :'sample_tbl_oid', '%') AND resource_manager = 'Heap';
ok
----
- t
+ f
(1 row)
-- ===================================================================
@@ -109,7 +109,7 @@
WHERE resource_manager = 'Heap' AND record_type = 'INSERT';
ok
----
- t
+ f
(1 row)
... |
| 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 2026-04-28 17:20:08.598306780 +0000
+++ /tmp/cirrus-ci-build/build/testrun/postgres_fdw/regress/results/postgres_fdw.out 2026-04-28 17:28:38.373140297 +0000
@@ -3016,13 +3016,16 @@
-- GROUP BY clause having expressions
explain (verbose, costs off)
select c2/2, sum(c2) * (c2/2) from ft1 group by c2/2 order by c2/2;
- QUERY PLAN
-------------------------------------------------------------------------------------------------------------------
- Foreign Scan
+ QUERY PLAN
+---------------------------------------------------------------------------------------
+ Sort
Output: ((c2 / 2)), ((sum(c2) * (c2 / 2)))
- Relations: Aggregate on (public.ft1)
- Remote SQL: SELECT (c2 / 2), (sum(c2) * (c2 / 2)) FROM "S 1"."T 1" GROUP BY 1 ORDER BY (c2 / 2) ASC NULLS LAST
-(4 rows)
+ Sort Key: ((ft1.c2 / 2))
+ -> Foreign Scan
+ Output: ((c2 / 2)), ((sum(c2) * (c2 / 2)))
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/vacuum.out /tmp/cirrus-ci-build/build/testrun/recovery/027_strea...
--- /tmp/cirrus-ci-build/src/test/regress/expected/vacuum.out 2026-04-28 17:20:10.562306822 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/vacuum.out 2026-04-28 17:26:59.645216146...
@@ -231,7 +231,7 @@
SELECT pg_relation_size('vac_truncate_test') > 0;
?column?
----------
- t
+ f
(1 row)
SET vacuum_truncate = false;
@@ -251,7 +251,7 @@
SELECT pg_relation_size('vac_truncate_test') > 0;
?column?
----------
- t
+ f
(1 row)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/vacuum.out /tmp/cirrus-ci-build/build/testrun/regress/regress/re...
--- /tmp/cirrus-ci-build/src/test/regress/expected/vacuum.out 2026-04-28 17:20:10.562306822 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/vacuum.out 2026-04-28 17:24:41.253322163 +0000
@@ -231,7 +231,7 @@
SELECT pg_relation_size('vac_truncate_test') > 0;
?column?
----------
- t
+ f
(1 row)
SET vacuum_truncate = false;
@@ -251,7 +251,7 @@
SELECT pg_relation_size('vac_truncate_test') > 0;
?column?
----------
- t
+ f
(1 row)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/vacuum.out /tmp/cirrus-ci-build/build/testrun/test_plan_advice/0...
--- /tmp/cirrus-ci-build/src/test/regress/expected/vacuum.out 2026-04-28 17:20:10.562306822 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/vacuum.out 2026-04-28 17:24:43.4...
@@ -231,7 +231,7 @@
SELECT pg_relation_size('vac_truncate_test') > 0;
?column?
----------
- t
+ f
(1 row)
SET vacuum_truncate = false;
@@ -251,7 +251,7 @@
SELECT pg_relation_size('vac_truncate_test') > 0;
?column?
----------
- t
+ f
(1 row)
... |
|
Linux - Debian Trixie - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/pg_stat_statements/expected/wal.out /tmp/cirrus-ci-build/contrib/pg_stat_statement...
--- /tmp/cirrus-ci-build/contrib/pg_stat_statements/expected/wal.out 2026-04-28 17:20:36.687516834 +0000
+++ /tmp/cirrus-ci-build/contrib/pg_stat_statements/results/wal.out 2026-04-28 17:27:07.747114783 +0000
@@ -16,7 +16,7 @@
query | calls | rows | wal_bytes_generated | wal_records_genera...
--------------------------------------------------------------+-------+------+---------------------+-------------------...
DELETE FROM pgss_wal_tab WHERE a > $1 | 1 | 1 | t | t ...
- INSERT INTO pgss_wal_tab VALUES(generate_series($1, $2), $3) | 1 | 10 | t | t ...
+ INSERT INTO pgss_wal_tab VALUES(generate_series($1, $2), $3) | 1 | 10 | t | t ...
SELECT pg_stat_statements_reset() IS NOT NULL AS t | 1 | 1 | f | f ...
SET pg_stat_statements.track_utility = $1 | 1 | 0 | f | f ...
UPDATE pgss_wal_tab SET b = $1 WHERE a > $2 | 1 | 3 | t | t ... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/vacuum.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/res...
--- /tmp/cirrus-ci-build/src/test/regress/expected/vacuum.out 2026-04-28 17:20:38.527514763 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/vacuum.out 2026-04-28 17:27:30.907096792 +0000
@@ -231,7 +231,7 @@
SELECT pg_relation_size('vac_truncate_test') > 0;
?column?
----------
- t
+ f
(1 row)
SET vacuum_truncate = false;
@@ -251,7 +251,7 @@
SELECT pg_relation_size('vac_truncate_test') > 0;
?column?
----------
- t
+ f
(1 row)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/vacuum.out /tmp/cirrus-ci-build/src/test/modules/test_plan_advic...
--- /tmp/cirrus-ci-build/src/test/regress/expected/vacuum.out 2026-04-28 17:20:38.527514763 +0000
+++ /tmp/cirrus-ci-build/src/test/modules/test_plan_advice/tmp_check/results/vacuum.out 2026-04-28 17:29:34.459015702 +0...
@@ -231,7 +231,7 @@
SELECT pg_relation_size('vac_truncate_test') > 0;
?column?
----------
- t
+ f
(1 row)
SET vacuum_truncate = false;
@@ -251,7 +251,7 @@
SELECT pg_relation_size('vac_truncate_test') > 0;
?column?
----------
- t
+ f
(1 row)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/vacuum.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check/resu...
--- /tmp/cirrus-ci-build/src/test/regress/expected/vacuum.out 2026-04-28 17:20:38.527514763 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/vacuum.out 2026-04-28 17:29:37.199014095 +0000
@@ -231,7 +231,7 @@
SELECT pg_relation_size('vac_truncate_test') > 0;
?column?
----------
- t
+ f
(1 row)
SET vacuum_truncate = false;
@@ -251,7 +251,7 @@
SELECT pg_relation_size('vac_truncate_test') > 0;
?column?
----------
- t
+ f
(1 row)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/vacuum.out /tmp/cirrus-ci-build/src/test/regress/results/vacuum....
--- /tmp/cirrus-ci-build/src/test/regress/expected/vacuum.out 2026-04-28 17:20:38.527514763 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/vacuum.out 2026-04-28 17:25:23.835216253 +0000
@@ -231,7 +231,7 @@
SELECT pg_relation_size('vac_truncate_test') > 0;
?column?
----------
- t
+ f
(1 row)
SET vacuum_truncate = false;
@@ -251,7 +251,7 @@
SELECT pg_relation_size('vac_truncate_test') > 0;
?column?
----------
- t
+ f
(1 row)
... |
|
OpenBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/contrib/pg_stat_statements/expected/wal.out /home/postgres/postgres/build/testrun/pg_st...
--- /home/postgres/postgres/contrib/pg_stat_statements/expected/wal.out Tue Apr 28 17:21:01 2026
+++ /home/postgres/postgres/build/testrun/pg_stat_statements/regress/results/wal.out Tue Apr 28 17:27:05 2026
@@ -16,7 +16,7 @@
query | calls | rows | wal_bytes_generated | wal_records_genera...
--------------------------------------------------------------+-------+------+---------------------+-------------------...
DELETE FROM pgss_wal_tab WHERE a > $1 | 1 | 1 | t | t ...
- INSERT INTO pgss_wal_tab VALUES(generate_series($1, $2), $3) | 1 | 10 | t | t ...
+ INSERT INTO pgss_wal_tab VALUES(generate_series($1, $2), $3) | 1 | 10 | t | t ...
SELECT pg_stat_statements_reset() IS NOT NULL AS t | 1 | 1 | f | f ...
SET pg_stat_statements.track_utility = $1 | 1 | 0 | f | f ...
UPDATE pgss_wal_tab SET b = $1 WHERE a > $2 | 1 | 3 | t | t ... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/vacuum.out /home/postgres/postgres/build/testrun/pg_upgrade/0...
--- /home/postgres/postgres/src/test/regress/expected/vacuum.out Tue Apr 28 17:21:11 2026
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/vacuum.out Tue Apr 28 17:24:10 2026
@@ -231,7 +231,7 @@
SELECT pg_relation_size('vac_truncate_test') > 0;
?column?
----------
- t
+ f
(1 row)
SET vacuum_truncate = false;
@@ -251,7 +251,7 @@
SELECT pg_relation_size('vac_truncate_test') > 0;
?column?
----------
- t
+ f
(1 row)
... |
| regress |
diff -U3 /home/postgres/postgres/contrib/pg_walinspect/expected/pg_walinspect.out /home/postgres/postgres/build/testrun/...
--- /home/postgres/postgres/contrib/pg_walinspect/expected/pg_walinspect.out Tue Apr 28 17:21:02 2026
+++ /home/postgres/postgres/build/testrun/pg_walinspect/regress/results/pg_walinspect.out Tue Apr 28 17:27:06 2026
@@ -98,7 +98,7 @@
WHERE block_ref LIKE concat('%', :'sample_tbl_oid', '%') AND resource_manager = 'Heap';
ok
----
- t
+ f
(1 row)
-- ===================================================================
@@ -109,7 +109,7 @@
WHERE resource_manager = 'Heap' AND record_type = 'INSERT';
ok
----
- t
+ f
(1 row)
... |
| regress |
diff -U3 /home/postgres/postgres/contrib/postgres_fdw/expected/postgres_fdw.out /home/postgres/postgres/build/testrun/po...
--- /home/postgres/postgres/contrib/postgres_fdw/expected/postgres_fdw.out Tue Apr 28 17:21:02 2026
+++ /home/postgres/postgres/build/testrun/postgres_fdw/regress/results/postgres_fdw.out Tue Apr 28 17:27:25 2026
@@ -3016,13 +3016,16 @@
-- GROUP BY clause having expressions
explain (verbose, costs off)
select c2/2, sum(c2) * (c2/2) from ft1 group by c2/2 order by c2/2;
- QUERY PLAN
-------------------------------------------------------------------------------------------------------------------
- Foreign Scan
+ QUERY PLAN
+---------------------------------------------------------------------------------------
+ Sort
Output: ((c2 / 2)), ((sum(c2) * (c2 / 2)))
- Relations: Aggregate on (public.ft1)
- Remote SQL: SELECT (c2 / 2), (sum(c2) * (c2 / 2)) FROM "S 1"."T 1" GROUP BY 1 ORDER BY (c2 / 2) ASC NULLS LAST
-(4 rows)
+ Sort Key: ((ft1.c2 / 2))
+ -> Foreign Scan
+ Output: ((c2 / 2)), ((sum(c2) * (c2 / 2)))
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/vacuum.out /home/postgres/postgres/build/testrun/recovery/027...
--- /home/postgres/postgres/src/test/regress/expected/vacuum.out Tue Apr 28 17:21:11 2026
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/vacuum.out Tue Apr 28 17:26:09 2026
@@ -231,7 +231,7 @@
SELECT pg_relation_size('vac_truncate_test') > 0;
?column?
----------
- t
+ f
(1 row)
SET vacuum_truncate = false;
@@ -251,7 +251,7 @@
SELECT pg_relation_size('vac_truncate_test') > 0;
?column?
----------
- t
+ f
(1 row)
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/vacuum.out /home/postgres/postgres/build/testrun/regress/regr...
--- /home/postgres/postgres/src/test/regress/expected/vacuum.out Tue Apr 28 17:21:11 2026
+++ /home/postgres/postgres/build/testrun/regress/regress/results/vacuum.out Tue Apr 28 17:24:05 2026
@@ -231,7 +231,7 @@
SELECT pg_relation_size('vac_truncate_test') > 0;
?column?
----------
- t
+ f
(1 row)
SET vacuum_truncate = false;
@@ -251,7 +251,7 @@
SELECT pg_relation_size('vac_truncate_test') > 0;
?column?
----------
- t
+ f
(1 row)
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/vacuum.out /home/postgres/postgres/build/testrun/test_plan_ad...
--- /home/postgres/postgres/src/test/regress/expected/vacuum.out Tue Apr 28 17:21:11 2026
+++ /home/postgres/postgres/build/testrun/test_plan_advice/001_replan_regress/data/results/vacuum.out Tue Apr 28 17:24:1...
@@ -231,7 +231,7 @@
SELECT pg_relation_size('vac_truncate_test') > 0;
?column?
----------
- t
+ f
(1 row)
SET vacuum_truncate = false;
@@ -251,7 +251,7 @@
SELECT pg_relation_size('vac_truncate_test') > 0;
?column?
----------
- t
+ f
(1 row)
... |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/contrib/pg_stat_statements/expected/wal.out /home/postgres/postgres/build/testrun/pg_st...
--- /home/postgres/postgres/contrib/pg_stat_statements/expected/wal.out 2026-04-28 17:20:57.785658987 +0000
+++ /home/postgres/postgres/build/testrun/pg_stat_statements/regress/results/wal.out 2026-04-28 17:24:46.940200163 +0000
@@ -16,7 +16,7 @@
query | calls | rows | wal_bytes_generated | wal_records_genera...
--------------------------------------------------------------+-------+------+---------------------+-------------------...
DELETE FROM pgss_wal_tab WHERE a > $1 | 1 | 1 | t | t ...
- INSERT INTO pgss_wal_tab VALUES(generate_series($1, $2), $3) | 1 | 10 | t | t ...
+ INSERT INTO pgss_wal_tab VALUES(generate_series($1, $2), $3) | 1 | 10 | t | t ...
SELECT pg_stat_statements_reset() IS NOT NULL AS t | 1 | 1 | f | f ...
SET pg_stat_statements.track_utility = $1 | 1 | 0 | f | f ...
UPDATE pgss_wal_tab SET b = $1 WHERE a > $2 | 1 | 3 | t | t ... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/vacuum.out /home/postgres/postgres/build/testrun/pg_upgrade/0...
--- /home/postgres/postgres/src/test/regress/expected/vacuum.out 2026-04-28 17:21:06.892003247 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/vacuum.out 2026-04-28 17:23:24.14153601...
@@ -231,7 +231,7 @@
SELECT pg_relation_size('vac_truncate_test') > 0;
?column?
----------
- t
+ f
(1 row)
SET vacuum_truncate = false;
@@ -251,7 +251,7 @@
SELECT pg_relation_size('vac_truncate_test') > 0;
?column?
----------
- t
+ f
(1 row)
... |
| regress |
diff -U3 /home/postgres/postgres/contrib/pg_walinspect/expected/pg_walinspect.out /home/postgres/postgres/build/testrun/...
--- /home/postgres/postgres/contrib/pg_walinspect/expected/pg_walinspect.out 2026-04-28 17:20:57.912968021 +0000
+++ /home/postgres/postgres/build/testrun/pg_walinspect/regress/results/pg_walinspect.out 2026-04-28 17:24:47.874833874 ...
@@ -98,7 +98,7 @@
WHERE block_ref LIKE concat('%', :'sample_tbl_oid', '%') AND resource_manager = 'Heap';
ok
----
- t
+ f
(1 row)
-- ===================================================================
@@ -109,7 +109,7 @@
WHERE resource_manager = 'Heap' AND record_type = 'INSERT';
ok
----
- t
+ f
(1 row)
... |
| regress |
diff -U3 /home/postgres/postgres/contrib/postgres_fdw/expected/postgres_fdw.out /home/postgres/postgres/build/testrun/po...
--- /home/postgres/postgres/contrib/postgres_fdw/expected/postgres_fdw.out 2026-04-28 17:20:58.107453422 +0000
+++ /home/postgres/postgres/build/testrun/postgres_fdw/regress/results/postgres_fdw.out 2026-04-28 17:24:55.037253251 +0...
@@ -3016,13 +3016,16 @@
-- GROUP BY clause having expressions
explain (verbose, costs off)
select c2/2, sum(c2) * (c2/2) from ft1 group by c2/2 order by c2/2;
- QUERY PLAN
-------------------------------------------------------------------------------------------------------------------
- Foreign Scan
+ QUERY PLAN
+---------------------------------------------------------------------------------------
+ Sort
Output: ((c2 / 2)), ((sum(c2) * (c2 / 2)))
- Relations: Aggregate on (public.ft1)
- Remote SQL: SELECT (c2 / 2), (sum(c2) * (c2 / 2)) FROM "S 1"."T 1" GROUP BY 1 ORDER BY (c2 / 2) ASC NULLS LAST
-(4 rows)
+ Sort Key: ((ft1.c2 / 2))
+ -> Foreign Scan
+ Output: ((c2 / 2)), ((sum(c2) * (c2 / 2)))
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/vacuum.out /home/postgres/postgres/build/testrun/recovery/027...
--- /home/postgres/postgres/src/test/regress/expected/vacuum.out 2026-04-28 17:21:06.892003247 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/vacuum.out 2026-04-28 17:24:01.489371...
@@ -231,7 +231,7 @@
SELECT pg_relation_size('vac_truncate_test') > 0;
?column?
----------
- t
+ f
(1 row)
SET vacuum_truncate = false;
@@ -251,7 +251,7 @@
SELECT pg_relation_size('vac_truncate_test') > 0;
?column?
----------
- t
+ f
(1 row)
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/vacuum.out /home/postgres/postgres/build/testrun/regress/regr...
--- /home/postgres/postgres/src/test/regress/expected/vacuum.out 2026-04-28 17:21:06.892003247 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/vacuum.out 2026-04-28 17:23:20.053496839 +0000
@@ -231,7 +231,7 @@
SELECT pg_relation_size('vac_truncate_test') > 0;
?column?
----------
- t
+ f
(1 row)
SET vacuum_truncate = false;
@@ -251,7 +251,7 @@
SELECT pg_relation_size('vac_truncate_test') > 0;
?column?
----------
- t
+ f
(1 row)
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/vacuum.out /home/postgres/postgres/build/testrun/test_plan_ad...
--- /home/postgres/postgres/src/test/regress/expected/vacuum.out 2026-04-28 17:21:06.892003247 +0000
+++ /home/postgres/postgres/build/testrun/test_plan_advice/001_replan_regress/data/results/vacuum.out 2026-04-28 17:23:2...
@@ -231,7 +231,7 @@
SELECT pg_relation_size('vac_truncate_test') > 0;
?column?
----------
- t
+ f
(1 row)
SET vacuum_truncate = false;
@@ -251,7 +251,7 @@
SELECT pg_relation_size('vac_truncate_test') > 0;
?column?
----------
- t
+ f
(1 row)
... |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/pg_stat_statements/expected/wal.out /tmp/cirrus-ci-build/build/testrun/pg_stat_sta...
--- /tmp/cirrus-ci-build/contrib/pg_stat_statements/expected/wal.out 2026-04-28 17:21:09.856737000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_stat_statements/regress/results/wal.out 2026-04-28 17:25:44.618194000 +0000
@@ -16,7 +16,7 @@
query | calls | rows | wal_bytes_generated | wal_records_genera...
--------------------------------------------------------------+-------+------+---------------------+-------------------...
DELETE FROM pgss_wal_tab WHERE a > $1 | 1 | 1 | t | t ...
- INSERT INTO pgss_wal_tab VALUES(generate_series($1, $2), $3) | 1 | 10 | t | t ...
+ INSERT INTO pgss_wal_tab VALUES(generate_series($1, $2), $3) | 1 | 10 | t | t ...
SELECT pg_stat_statements_reset() IS NOT NULL AS t | 1 | 1 | f | f ...
SET pg_stat_statements.track_utility = $1 | 1 | 0 | f | f ...
UPDATE pgss_wal_tab SET b = $1 WHERE a > $2 | 1 | 3 | t | t ... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/vacuum.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/vacuum.out 2026-04-28 17:21:11.534108000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/vacuum.out 2026-04-28 17:23:26.099721000 +...
@@ -231,7 +231,7 @@
SELECT pg_relation_size('vac_truncate_test') > 0;
?column?
----------
- t
+ f
(1 row)
SET vacuum_truncate = false;
@@ -251,7 +251,7 @@
SELECT pg_relation_size('vac_truncate_test') > 0;
?column?
----------
- t
+ f
(1 row)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/pg_walinspect/expected/pg_walinspect.out /tmp/cirrus-ci-build/build/testrun/pg_wal...
--- /tmp/cirrus-ci-build/contrib/pg_walinspect/expected/pg_walinspect.out 2026-04-28 17:21:09.868222000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_walinspect/regress/results/pg_walinspect.out 2026-04-28 17:25:44.524403000 +00...
@@ -98,7 +98,7 @@
WHERE block_ref LIKE concat('%', :'sample_tbl_oid', '%') AND resource_manager = 'Heap';
ok
----
- t
+ f
(1 row)
-- ===================================================================
@@ -109,7 +109,7 @@
WHERE resource_manager = 'Heap' AND record_type = 'INSERT';
ok
----
- t
+ f
(1 row)
... |
| 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 2026-04-28 17:21:09.892402000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/postgres_fdw/regress/results/postgres_fdw.out 2026-04-28 17:26:35.261726000 +0000
@@ -3016,13 +3016,16 @@
-- GROUP BY clause having expressions
explain (verbose, costs off)
select c2/2, sum(c2) * (c2/2) from ft1 group by c2/2 order by c2/2;
- QUERY PLAN
-------------------------------------------------------------------------------------------------------------------
- Foreign Scan
+ QUERY PLAN
+---------------------------------------------------------------------------------------
+ Sort
Output: ((c2 / 2)), ((sum(c2) * (c2 / 2)))
- Relations: Aggregate on (public.ft1)
- Remote SQL: SELECT (c2 / 2), (sum(c2) * (c2 / 2)) FROM "S 1"."T 1" GROUP BY 1 ORDER BY (c2 / 2) ASC NULLS LAST
-(4 rows)
+ Sort Key: ((ft1.c2 / 2))
+ -> Foreign Scan
+ Output: ((c2 / 2)), ((sum(c2) * (c2 / 2)))
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/vacuum.out /tmp/cirrus-ci-build/build/testrun/recovery/027_strea...
--- /tmp/cirrus-ci-build/src/test/regress/expected/vacuum.out 2026-04-28 17:21:11.534108000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/vacuum.out 2026-04-28 17:24:52.663917000...
@@ -231,7 +231,7 @@
SELECT pg_relation_size('vac_truncate_test') > 0;
?column?
----------
- t
+ f
(1 row)
SET vacuum_truncate = false;
@@ -251,7 +251,7 @@
SELECT pg_relation_size('vac_truncate_test') > 0;
?column?
----------
- t
+ f
(1 row)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/vacuum.out /tmp/cirrus-ci-build/build/testrun/regress/regress/re...
--- /tmp/cirrus-ci-build/src/test/regress/expected/vacuum.out 2026-04-28 17:21:11.534108000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/vacuum.out 2026-04-28 17:23:21.767095000 +0000
@@ -231,7 +231,7 @@
SELECT pg_relation_size('vac_truncate_test') > 0;
?column?
----------
- t
+ f
(1 row)
SET vacuum_truncate = false;
@@ -251,7 +251,7 @@
SELECT pg_relation_size('vac_truncate_test') > 0;
?column?
----------
- t
+ f
(1 row)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/vacuum.out /tmp/cirrus-ci-build/build/testrun/test_plan_advice/0...
--- /tmp/cirrus-ci-build/src/test/regress/expected/vacuum.out 2026-04-28 17:21:11.534108000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/vacuum.out 2026-04-28 17:23:29.2...
@@ -231,7 +231,7 @@
SELECT pg_relation_size('vac_truncate_test') > 0;
?column?
----------
- t
+ f
(1 row)
SET vacuum_truncate = false;
@@ -251,7 +251,7 @@
SELECT pg_relation_size('vac_truncate_test') > 0;
?column?
----------
- t
+ f
(1 row)
... |
| 59/6274 |
Add a greedy join search algorithm to handle large join problems |
|
macOS - Sequoia - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/goo.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade...
--- /Users/admin/pgsql/src/test/regress/expected/goo.out 2026-04-27 13:02:03
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/goo.out 2026-04-27 13:06:14
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/goo.out /Users/admin/pgsql/build/testrun/recovery/027_stream_regre...
--- /Users/admin/pgsql/src/test/regress/expected/goo.out 2026-04-27 13:02:03
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/goo.out 2026-04-27 13:07:58
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/goo.out /Users/admin/pgsql/build/testrun/regress/regress/results/g...
--- /Users/admin/pgsql/src/test/regress/expected/goo.out 2026-04-27 13:02:03
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/goo.out 2026-04-27 13:06:19
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/goo.out /Users/admin/pgsql/build/testrun/test_plan_advice/001_repl...
--- /Users/admin/pgsql/src/test/regress/expected/goo.out 2026-04-27 13:02:03
+++ /Users/admin/pgsql/build/testrun/test_plan_advice/001_replan_regress/data/results/goo.out 2026-04-27 13:06:23
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/goo.out C:/cirrus/build/testrun/pg_upgrade/002_pg_upgra...
--- C:/cirrus/src/test/regress/expected/goo.out 2026-04-27 13:01:57.381978500 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/goo.out 2026-04-27 13:05:48.900717400 +0000
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/goo.out C:/cirrus/build/testrun/recovery/027_stream_reg...
--- C:/cirrus/src/test/regress/expected/goo.out 2026-04-27 13:01:57.381978500 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/goo.out 2026-04-27 13:09:30.815745400 +0000
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/goo.out C:/cirrus/build/testrun/regress/regress/results...
--- C:/cirrus/src/test/regress/expected/goo.out 2026-04-27 13:01:57.381978500 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/goo.out 2026-04-27 13:05:49.666346800 +0000
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/goo.out C:/cirrus/build/testrun/test_plan_advice/001_re...
--- C:/cirrus/src/test/regress/expected/goo.out 2026-04-27 13:01:57.381978500 +0000
+++ C:/cirrus/build/testrun/test_plan_advice/001_replan_regress/data/results/goo.out 2026-04-27 13:05:51.218096300 +0000
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
|
Linux - Debian Trixie - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/goo.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upg...
--- /tmp/cirrus-ci-build/src/test/regress/expected/goo.out 2026-04-27 13:01:56.062509622 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/goo.out 2026-04-27 13:06:02.105593533 +000...
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/goo.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/goo.out 2026-04-27 13:01:56.062509622 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/goo.out 2026-04-27 13:07:53.670878383 +0...
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/goo.out /tmp/cirrus-ci-build/build/testrun/regress/regress/resul...
--- /tmp/cirrus-ci-build/src/test/regress/expected/goo.out 2026-04-27 13:01:56.062509622 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/goo.out 2026-04-27 13:06:04.537584667 +0000
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/goo.out /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/goo.out 2026-04-27 13:01:56.062509622 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/goo.out 2026-04-27 13:06:09.2575...
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
|
OpenBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/goo.out /home/postgres/postgres/build/testrun/pg_upgrade/002_...
--- /home/postgres/postgres/src/test/regress/expected/goo.out Mon Apr 27 13:02:14 2026
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/goo.out Mon Apr 27 13:06:10 2026
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/goo.out /home/postgres/postgres/build/testrun/recovery/027_st...
--- /home/postgres/postgres/src/test/regress/expected/goo.out Mon Apr 27 13:02:14 2026
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/goo.out Mon Apr 27 13:08:59 2026
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/goo.out /home/postgres/postgres/build/testrun/regress/regress...
--- /home/postgres/postgres/src/test/regress/expected/goo.out Mon Apr 27 13:02:14 2026
+++ /home/postgres/postgres/build/testrun/regress/regress/results/goo.out Mon Apr 27 13:06:03 2026
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/goo.out /home/postgres/postgres/build/testrun/test_plan_advic...
--- /home/postgres/postgres/src/test/regress/expected/goo.out Mon Apr 27 13:02:14 2026
+++ /home/postgres/postgres/build/testrun/test_plan_advice/001_replan_regress/data/results/goo.out Mon Apr 27 13:06:07 2...
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/goo.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upg...
--- /tmp/cirrus-ci-build/src/test/regress/expected/goo.out 2026-04-27 13:01:56.174226000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/goo.out 2026-04-27 13:05:52.215178000 +000...
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/goo.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/goo.out 2026-04-27 13:01:56.174226000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/goo.out 2026-04-27 13:07:59.618350000 +0...
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/goo.out /tmp/cirrus-ci-build/build/testrun/regress/regress/resul...
--- /tmp/cirrus-ci-build/src/test/regress/expected/goo.out 2026-04-27 13:01:56.174226000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/goo.out 2026-04-27 13:05:57.083582000 +0000
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/goo.out /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/goo.out 2026-04-27 13:01:56.174226000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/goo.out 2026-04-27 13:05:59.0636...
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
|
Linux - Debian Trixie - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/goo.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/result...
--- /tmp/cirrus-ci-build/src/test/regress/expected/goo.out 2026-04-27 13:02:06.533625455 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/goo.out 2026-04-27 13:08:56.418850040 +0000
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/goo.out /tmp/cirrus-ci-build/src/test/modules/test_plan_advice/t...
--- /tmp/cirrus-ci-build/src/test/regress/expected/goo.out 2026-04-27 13:02:06.533625455 +0000
+++ /tmp/cirrus-ci-build/src/test/modules/test_plan_advice/tmp_check/results/goo.out 2026-04-27 13:11:36.114536292 +0000
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/goo.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results...
--- /tmp/cirrus-ci-build/src/test/regress/expected/goo.out 2026-04-27 13:02:06.533625455 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/goo.out 2026-04-27 13:11:15.414013600 +0000
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/goo.out /tmp/cirrus-ci-build/src/test/regress/results/goo.out
--- /tmp/cirrus-ci-build/src/test/regress/expected/goo.out 2026-04-27 13:02:06.533625455 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/goo.out 2026-04-27 13:06:54.549159355 +0000
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| 59/6610 |
ORDER BY ALL |
|
Linux - Debian Trixie - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/pl/plpgsql/src/expected/plpgsql_misc.out /tmp/cirrus-ci-build/build/testrun/plpgsql/re...
--- /tmp/cirrus-ci-build/src/pl/plpgsql/src/expected/plpgsql_misc.out 2026-04-27 04:01:04.108080988 +0000
+++ /tmp/cirrus-ci-build/build/testrun/plpgsql/regress/results/plpgsql_misc.out 2026-04-27 04:07:40.918240415 +0000
@@ -194,7 +194,7 @@
end;
$$ language plpgsql;
select * from test_order_by_all_return();
- a | b | c
+ a | b | c
---+-----+-----
1 | bar | 2.5
1 | qux | 1.5
@@ -210,7 +210,7 @@
end;
$$ language plpgsql;
select * from test_order_by_all_desc_return();
- a | b | c
+ a | b | c
---+-----+-----
3 | foo | 1.5
... |
|
macOS - Sequoia - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/pl/plpgsql/src/expected/plpgsql_misc.out /Users/admin/pgsql/build/testrun/plpgsql/regres...
--- /Users/admin/pgsql/src/pl/plpgsql/src/expected/plpgsql_misc.out 2026-04-27 04:01:13
+++ /Users/admin/pgsql/build/testrun/plpgsql/regress/results/plpgsql_misc.out 2026-04-27 04:08:18
@@ -194,7 +194,7 @@
end;
$$ language plpgsql;
select * from test_order_by_all_return();
- a | b | c
+ a | b | c
---+-----+-----
1 | bar | 2.5
1 | qux | 1.5
@@ -210,7 +210,7 @@
end;
$$ language plpgsql;
select * from test_order_by_all_desc_return();
- a | b | c
+ a | b | c
---+-----+-----
3 | foo | 1.5
... |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/pl/plpgsql/src/expected/plpgsql_misc.out C:/cirrus/build/testrun/plpgsql/regr...
--- C:/cirrus/src/pl/plpgsql/src/expected/plpgsql_misc.out 2026-04-27 04:01:06.564122100 +0000
+++ C:/cirrus/build/testrun/plpgsql/regress/results/plpgsql_misc.out 2026-04-27 04:10:14.938484200 +0000
@@ -194,7 +194,7 @@
end;
$$ language plpgsql;
select * from test_order_by_all_return();
- a | b | c
+ a | b | c
---+-----+-----
1 | bar | 2.5
1 | qux | 1.5
@@ -210,7 +210,7 @@
end;
$$ language plpgsql;
select * from test_order_by_all_desc_return();
- a | b | c
+ a | b | c
---+-----+-----
3 | foo | 1.5
... |
|
OpenBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/pl/plpgsql/src/expected/plpgsql_misc.out /home/postgres/postgres/build/testrun/plpg...
--- /home/postgres/postgres/src/pl/plpgsql/src/expected/plpgsql_misc.out Mon Apr 27 04:01:14 2026
+++ /home/postgres/postgres/build/testrun/plpgsql/regress/results/plpgsql_misc.out Mon Apr 27 04:07:42 2026
@@ -194,7 +194,7 @@
end;
$$ language plpgsql;
select * from test_order_by_all_return();
- a | b | c
+ a | b | c
---+-----+-----
1 | bar | 2.5
1 | qux | 1.5
@@ -210,7 +210,7 @@
end;
$$ language plpgsql;
select * from test_order_by_all_desc_return();
- a | b | c
+ a | b | c
---+-----+-----
3 | foo | 1.5
... |
|
Linux - Debian Trixie - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/pl/plpgsql/src/expected/plpgsql_misc.out /tmp/cirrus-ci-build/src/pl/plpgsql/src/resul...
--- /tmp/cirrus-ci-build/src/pl/plpgsql/src/expected/plpgsql_misc.out 2026-04-27 04:01:08.242381028 +0000
+++ /tmp/cirrus-ci-build/src/pl/plpgsql/src/results/plpgsql_misc.out 2026-04-27 04:05:19.481299977 +0000
@@ -194,7 +194,7 @@
end;
$$ language plpgsql;
select * from test_order_by_all_return();
- a | b | c
+ a | b | c
---+-----+-----
1 | bar | 2.5
1 | qux | 1.5
@@ -210,7 +210,7 @@
end;
$$ language plpgsql;
select * from test_order_by_all_desc_return();
- a | b | c
+ a | b | c
---+-----+-----
3 | foo | 1.5
... |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/pl/plpgsql/src/expected/plpgsql_misc.out /home/postgres/postgres/build/testrun/plpg...
--- /home/postgres/postgres/src/pl/plpgsql/src/expected/plpgsql_misc.out 2026-04-27 04:01:31.357454487 +0000
+++ /home/postgres/postgres/build/testrun/plpgsql/regress/results/plpgsql_misc.out 2026-04-27 04:05:37.655346565 +0000
@@ -194,7 +194,7 @@
end;
$$ language plpgsql;
select * from test_order_by_all_return();
- a | b | c
+ a | b | c
---+-----+-----
1 | bar | 2.5
1 | qux | 1.5
@@ -210,7 +210,7 @@
end;
$$ language plpgsql;
select * from test_order_by_all_desc_return();
- a | b | c
+ a | b | c
---+-----+-----
3 | foo | 1.5
... |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/pl/plpgsql/src/expected/plpgsql_misc.out /tmp/cirrus-ci-build/build/testrun/plpgsql/re...
--- /tmp/cirrus-ci-build/src/pl/plpgsql/src/expected/plpgsql_misc.out 2026-04-27 04:01:03.765882000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/plpgsql/regress/results/plpgsql_misc.out 2026-04-27 04:04:58.431789000 +0000
@@ -194,7 +194,7 @@
end;
$$ language plpgsql;
select * from test_order_by_all_return();
- a | b | c
+ a | b | c
---+-----+-----
1 | bar | 2.5
1 | qux | 1.5
@@ -210,7 +210,7 @@
end;
$$ language plpgsql;
select * from test_order_by_all_desc_return();
- a | b | c
+ a | b | c
---+-----+-----
3 | foo | 1.5
... |