This robot generates gigabytes of CI logs every week. Here is an attempt to
search for "highlights", so it's easier to find actionable information
quickly. New ideas for what patterns to search for are very welcome.
"Current" shows only the most recent results from each submission. The
wider time ranges also show information about historical versions, which
may be useful for flapping tests, and also for hunting for bugs in master.
| 57/6208 |
Add pg_get_subscription_ddl() function |
 |
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/subscription.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/0...
--- /tmp/cirrus-ci-build/src/test/regress/expected/subscription.out 2025-11-09 05:08:37.150860000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/subscription.out 2025-11-09 05:12:08.16705...
@@ -527,7 +527,9 @@
-- configurations and checking the DDL.
--
CREATE ROLE createsub_role LOGIN;
+WARNING: roles created by regression test cases should have names starting with "regress_"
CREATE ROLE readalldata_role LOGIN;
+WARNING: roles created by regression test cases should have names starting with "regress_"
-- see the pg_get_subscription_ddl output for a NULL and empty input
SELECT pg_get_subscription_ddl('');
ERROR: subscription "" does not exist
@@ -540,6 +542,7 @@
-- Create subscription with minimal options
CREATE SUBSCRIPTION testsub1 CONNECTION 'dbname=db_doesnotexist'
PUBLICATION testpub1 WITH (connect=false);
+WARNING: subscriptions created by regression test cases should have names starting with "regress_"
WARNING: subscription was created, but is not connected
HINT: To initiate replication, you must manually create the replication slot, enable the subscription, and alter the s...
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/subscription.out /tmp/cirrus-ci-build/build/testrun/recovery/027...
--- /tmp/cirrus-ci-build/src/test/regress/expected/subscription.out 2025-11-09 05:08:37.150860000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/subscription.out 2025-11-09 05:13:08.602...
@@ -527,7 +527,9 @@
-- configurations and checking the DDL.
--
CREATE ROLE createsub_role LOGIN;
+WARNING: roles created by regression test cases should have names starting with "regress_"
CREATE ROLE readalldata_role LOGIN;
+WARNING: roles created by regression test cases should have names starting with "regress_"
-- see the pg_get_subscription_ddl output for a NULL and empty input
SELECT pg_get_subscription_ddl('');
ERROR: subscription "" does not exist
@@ -540,6 +542,7 @@
-- Create subscription with minimal options
CREATE SUBSCRIPTION testsub1 CONNECTION 'dbname=db_doesnotexist'
PUBLICATION testpub1 WITH (connect=false);
+WARNING: subscriptions created by regression test cases should have names starting with "regress_"
WARNING: subscription was created, but is not connected
HINT: To initiate replication, you must manually create the replication slot, enable the subscription, and alter the s...
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/subscription.out /tmp/cirrus-ci-build/build/testrun/regress/regr...
--- /tmp/cirrus-ci-build/src/test/regress/expected/subscription.out 2025-11-09 05:08:37.150860000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/subscription.out 2025-11-09 05:12:03.347598000 +0000
@@ -527,7 +527,9 @@
-- configurations and checking the DDL.
--
CREATE ROLE createsub_role LOGIN;
+WARNING: roles created by regression test cases should have names starting with "regress_"
CREATE ROLE readalldata_role LOGIN;
+WARNING: roles created by regression test cases should have names starting with "regress_"
-- see the pg_get_subscription_ddl output for a NULL and empty input
SELECT pg_get_subscription_ddl('');
ERROR: subscription "" does not exist
@@ -540,6 +542,7 @@
-- Create subscription with minimal options
CREATE SUBSCRIPTION testsub1 CONNECTION 'dbname=db_doesnotexist'
PUBLICATION testpub1 WITH (connect=false);
+WARNING: subscriptions created by regression test cases should have names starting with "regress_"
WARNING: subscription was created, but is not connected
HINT: To initiate replication, you must manually create the replication slot, enable the subscription, and alter the s...
... |
| 56/6198 |
Change initdb default to the builtin collation provider |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/contrib/citext/expected/citext_utf8.out /home/postgres/postgres/build/testrun/citext/re...
--- /home/postgres/postgres/contrib/citext/expected/citext_utf8.out 2025-11-09 00:59:19.680370385 +0000
+++ /home/postgres/postgres/build/testrun/citext/regress/results/citext_utf8.out 2025-11-09 01:01:24.665082762 +0000
@@ -30,7 +30,7 @@
SELECT 'À'::citext = 'à'::citext AS t;
t
---
- t
+ f
(1 row)
SELECT 'À'::text = 'à'::text AS f; -- text wins.
@@ -64,7 +64,7 @@
SELECT 'i'::citext = 'İ'::citext AS t;
t
---
- t
+ f
(1 row)
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/modules/test_regex/expected/test_regex_utf8.out /home/postgres/postgres/build/...
--- /home/postgres/postgres/src/test/modules/test_regex/expected/test_regex_utf8.out 2025-11-09 00:59:27.418008183 +0000
+++ /home/postgres/postgres/build/testrun/test_regex/regress/results/test_regex_utf8.out 2025-11-09 01:01:47.677586869 +...
@@ -152,7 +152,7 @@
test_regex
-----------------
{0,REG_ULOCALE}
- {xᔀሷ}
+ {x}
(2 rows)
select * from test_regex('[[:lower:]]+', E'x\u1500\u1237', 'L');
@@ -166,7 +166,7 @@
test_regex
-----------------
{0,REG_ULOCALE}
- {xᔀሷ}
+ {x}
(2 rows)
... |
| 56/5992 |
Fix ALTER TABLE DROP EXPRESSION with ONLY option |
|
Linux - Debian Trixie - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_stored.out /tmp/cirrus-ci-build/build/testrun/pg_upgra...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_stored.out 2025-11-08 22:10:25.672240045 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_stored.out 2025-11-08 22:12:18.7...
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out /tmp/cirrus-ci-build/build/testrun/pg_upgr...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out 2025-11-08 22:10:25.672240045 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out 2025-11-08 22:12:29....
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_stored.out /tmp/cirrus-ci-build/build/testrun/recovery...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_stored.out 2025-11-08 22:10:25.672240045 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/generated_stored.out 2025-11-08 22:13:35...
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out /tmp/cirrus-ci-build/build/testrun/recover...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out 2025-11-08 22:10:25.672240045 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out 2025-11-08 22:13:4...
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_stored.out /tmp/cirrus-ci-build/build/testrun/regress/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_stored.out 2025-11-08 22:10:25.672240045 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/generated_stored.out 2025-11-08 22:12:15.602541768 +0000
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out /tmp/cirrus-ci-build/build/testrun/regress...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out 2025-11-08 22:10:25.672240045 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/generated_virtual.out 2025-11-08 22:12:26.799267214 +0000
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
|
Windows - Server 2022, MinGW64 - Meson |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/generated_stored.out C:/cirrus/build/testrun/pg_upgrade...
--- C:/cirrus/src/test/regress/expected/generated_stored.out 2025-11-08 22:10:27.072319000 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_stored.out 2025-11-08 22:13:32.433137800 +0...
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/generated_virtual.out C:/cirrus/build/testrun/pg_upgrad...
--- C:/cirrus/src/test/regress/expected/generated_virtual.out 2025-11-08 22:10:27.072319000 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out 2025-11-08 22:13:40.401892700 +...
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/generated_stored.out C:/cirrus/build/testrun/recovery/0...
--- C:/cirrus/src/test/regress/expected/generated_stored.out 2025-11-08 22:10:27.072319000 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/generated_stored.out 2025-11-08 22:16:27.311076500 ...
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/generated_virtual.out C:/cirrus/build/testrun/recovery/...
--- C:/cirrus/src/test/regress/expected/generated_virtual.out 2025-11-08 22:10:27.072319000 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out 2025-11-08 22:16:36.274460700...
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/generated_stored.out C:/cirrus/build/testrun/regress/re...
--- C:/cirrus/src/test/regress/expected/generated_stored.out 2025-11-08 22:10:27.072319000 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/generated_stored.out 2025-11-08 22:13:25.053261800 +0000
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/generated_virtual.out C:/cirrus/build/testrun/regress/r...
--- C:/cirrus/src/test/regress/expected/generated_virtual.out 2025-11-08 22:10:27.072319000 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/generated_virtual.out 2025-11-08 22:13:35.721228000 +0000
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/generated_stored.out C:/cirrus/build/testrun/pg_upgrade...
--- C:/cirrus/src/test/regress/expected/generated_stored.out 2025-11-08 22:10:32.902025300 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_stored.out 2025-11-08 22:14:04.221438000 +0...
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/generated_virtual.out C:/cirrus/build/testrun/pg_upgrad...
--- C:/cirrus/src/test/regress/expected/generated_virtual.out 2025-11-08 22:10:32.902025300 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out 2025-11-08 22:14:24.240969300 +...
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/generated_stored.out C:/cirrus/build/testrun/recovery/0...
--- C:/cirrus/src/test/regress/expected/generated_stored.out 2025-11-08 22:10:32.902025300 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/generated_stored.out 2025-11-08 22:17:04.688220100 ...
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/generated_virtual.out C:/cirrus/build/testrun/recovery/...
--- C:/cirrus/src/test/regress/expected/generated_virtual.out 2025-11-08 22:10:32.902025300 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out 2025-11-08 22:17:19.584705200...
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/generated_stored.out C:/cirrus/build/testrun/regress/re...
--- C:/cirrus/src/test/regress/expected/generated_stored.out 2025-11-08 22:10:32.902025300 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/generated_stored.out 2025-11-08 22:13:55.507571800 +0000
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/generated_virtual.out C:/cirrus/build/testrun/regress/r...
--- C:/cirrus/src/test/regress/expected/generated_virtual.out 2025-11-08 22:10:32.902025300 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/generated_virtual.out 2025-11-08 22:14:16.331303700 +0000
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
|
macOS - Sequoia - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/generated_stored.out /Users/admin/pgsql/build/testrun/pg_upgrade/0...
--- /Users/admin/pgsql/src/test/regress/expected/generated_stored.out 2025-11-08 22:10:23
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_stored.out 2025-11-08 22:12:32
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff -U3 /Users/admin/pgsql/src/test/regress/expected/generated_virtual.out /Users/admin/pgsql/build/testrun/pg_upgrade/...
--- /Users/admin/pgsql/src/test/regress/expected/generated_virtual.out 2025-11-08 22:10:23
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out 2025-11-08 22:12:36
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/generated_stored.out /Users/admin/pgsql/build/testrun/recovery/027...
--- /Users/admin/pgsql/src/test/regress/expected/generated_stored.out 2025-11-08 22:10:23
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/generated_stored.out 2025-11-08 22:13:37
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff -U3 /Users/admin/pgsql/src/test/regress/expected/generated_virtual.out /Users/admin/pgsql/build/testrun/recovery/02...
--- /Users/admin/pgsql/src/test/regress/expected/generated_virtual.out 2025-11-08 22:10:23
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out 2025-11-08 22:13:44
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/generated_stored.out /Users/admin/pgsql/build/testrun/regress/regr...
--- /Users/admin/pgsql/src/test/regress/expected/generated_stored.out 2025-11-08 22:10:23
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/generated_stored.out 2025-11-08 22:12:32
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff -U3 /Users/admin/pgsql/src/test/regress/expected/generated_virtual.out /Users/admin/pgsql/build/testrun/regress/reg...
--- /Users/admin/pgsql/src/test/regress/expected/generated_virtual.out 2025-11-08 22:10:23
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/generated_virtual.out 2025-11-08 22:12:36
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/generated_stored.out /home/postgres/postgres/build/testrun/pg...
--- /home/postgres/postgres/src/test/regress/expected/generated_stored.out 2025-11-08 22:10:39.667644038 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_stored.out 2025-11-08 22:12:0...
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff -U3 /home/postgres/postgres/src/test/regress/expected/generated_virtual.out /home/postgres/postgres/build/testrun/p...
--- /home/postgres/postgres/src/test/regress/expected/generated_virtual.out 2025-11-08 22:10:39.668443863 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out 2025-11-08 22:12:...
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/generated_stored.out /home/postgres/postgres/build/testrun/re...
--- /home/postgres/postgres/src/test/regress/expected/generated_stored.out 2025-11-08 22:10:39.667644038 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/generated_stored.out 2025-11-08 22:12...
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff -U3 /home/postgres/postgres/src/test/regress/expected/generated_virtual.out /home/postgres/postgres/build/testrun/r...
--- /home/postgres/postgres/src/test/regress/expected/generated_virtual.out 2025-11-08 22:10:39.668443863 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out 2025-11-08 22:1...
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/generated_stored.out /home/postgres/postgres/build/testrun/re...
--- /home/postgres/postgres/src/test/regress/expected/generated_stored.out 2025-11-08 22:10:39.667644038 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/generated_stored.out 2025-11-08 22:11:52.722287276 +00...
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff -U3 /home/postgres/postgres/src/test/regress/expected/generated_virtual.out /home/postgres/postgres/build/testrun/r...
--- /home/postgres/postgres/src/test/regress/expected/generated_virtual.out 2025-11-08 22:10:39.668443863 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/generated_virtual.out 2025-11-08 22:12:03.686399031 +0...
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
|
Linux - Debian Trixie - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_stored.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_stored.out 2025-11-08 22:10:26.105367772 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/generated_stored.out 2025-11-08 22:15:28.699641895 +0000
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tm...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out 2025-11-08 22:10:26.105367772 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/generated_virtual.out 2025-11-08 22:15:59.403252657 +0000
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_stored.out /tmp/cirrus-ci-build/src/test/recovery/tmp_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_stored.out 2025-11-08 22:10:26.105367772 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/generated_stored.out 2025-11-08 22:17:08.214656891 +0000
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out /tmp/cirrus-ci-build/src/test/recovery/tmp...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out 2025-11-08 22:10:26.105367772 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/generated_virtual.out 2025-11-08 22:17:22.026571484 +0000
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_stored.out /tmp/cirrus-ci-build/src/test/regress/resul...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_stored.out 2025-11-08 22:10:26.105367772 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/generated_stored.out 2025-11-08 22:12:34.884937689 +0000
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out /tmp/cirrus-ci-build/src/test/regress/resu...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out 2025-11-08 22:10:26.105367772 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/generated_virtual.out 2025-11-08 22:13:03.523505656 +0000
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
|
OpenBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/generated_stored.out /home/postgres/postgres/build/testrun/pg...
--- /home/postgres/postgres/src/test/regress/expected/generated_stored.out Sat Nov 8 22:10:49 2025
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_stored.out Sat Nov 8 22:13:1...
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff -U3 /home/postgres/postgres/src/test/regress/expected/generated_virtual.out /home/postgres/postgres/build/testrun/p...
--- /home/postgres/postgres/src/test/regress/expected/generated_virtual.out Sat Nov 8 22:10:49 2025
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out Sat Nov 8 22:13:...
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/generated_stored.out /home/postgres/postgres/build/testrun/re...
--- /home/postgres/postgres/src/test/regress/expected/generated_stored.out Sat Nov 8 22:10:49 2025
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/generated_stored.out Sat Nov 8 22:14...
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff -U3 /home/postgres/postgres/src/test/regress/expected/generated_virtual.out /home/postgres/postgres/build/testrun/r...
--- /home/postgres/postgres/src/test/regress/expected/generated_virtual.out Sat Nov 8 22:10:49 2025
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out Sat Nov 8 22:1...
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/generated_stored.out /home/postgres/postgres/build/testrun/re...
--- /home/postgres/postgres/src/test/regress/expected/generated_stored.out Sat Nov 8 22:10:49 2025
+++ /home/postgres/postgres/build/testrun/regress/regress/results/generated_stored.out Sat Nov 8 22:12:57 2025
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff -U3 /home/postgres/postgres/src/test/regress/expected/generated_virtual.out /home/postgres/postgres/build/testrun/r...
--- /home/postgres/postgres/src/test/regress/expected/generated_virtual.out Sat Nov 8 22:10:49 2025
+++ /home/postgres/postgres/build/testrun/regress/regress/results/generated_virtual.out Sat Nov 8 22:13:08 2025
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_stored.out /tmp/cirrus-ci-build/build/testrun/pg_upgra...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_stored.out 2025-11-08 22:10:33.356730000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_stored.out 2025-11-08 22:12:31.3...
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out /tmp/cirrus-ci-build/build/testrun/pg_upgr...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out 2025-11-08 22:10:33.356767000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out 2025-11-08 22:12:50....
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_stored.out /tmp/cirrus-ci-build/build/testrun/recovery...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_stored.out 2025-11-08 22:10:33.356730000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/generated_stored.out 2025-11-08 22:13:26...
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out /tmp/cirrus-ci-build/build/testrun/recover...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out 2025-11-08 22:10:33.356767000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out 2025-11-08 22:13:5...
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_stored.out /tmp/cirrus-ci-build/build/testrun/regress/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_stored.out 2025-11-08 22:10:33.356730000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/generated_stored.out 2025-11-08 22:12:31.949032000 +0000
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out /tmp/cirrus-ci-build/build/testrun/regress...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out 2025-11-08 22:10:33.356767000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/generated_virtual.out 2025-11-08 22:12:49.711723000 +0000
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
| 56/6192 |
Lock-free XLog Reservation from WAL |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/isolation/expected/tuplelock-upgrade-no-deadlock.out /home/postgres/postgres/b...
--- /home/postgres/postgres/src/test/isolation/expected/tuplelock-upgrade-no-deadlock.out 2025-11-08 15:24:40.473221097 ...
+++ /home/postgres/postgres/build/testrun/isolation/isolation/results/tuplelock-upgrade-no-deadlock.out 2025-11-08 15:26...
@@ -1,253 +1,2 @@
Parsed test spec with 4 sessions
-
-starting permutation: s1_share s2_for_update s3_share s3_for_update s1_rollback s3_rollback s2_rollback
-step s1_share: select id from tlu_job where id = 1 for share;
-id
---
- 1
-(1 row)
-
-step s2_for_update: select id from tlu_job where id = 1 for update; <waiting ...>
-step s3_share: select id from tlu_job where id = 1 for share;
-id
---
- 1
-(1 row)
-
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/bitmapops.out /home/postgres/postgres/build/testrun/regress/r...
--- /home/postgres/postgres/src/test/regress/expected/bitmapops.out 2025-11-08 15:24:41.481526132 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/bitmapops.out 2025-11-08 15:26:27.837837183 +0000
@@ -13,6 +13,8 @@
SELECT (r%53), (r%59), 'foooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooo...
FROM generate_series(1,70000) r;
CREATE INDEX i_bmtest_a ON bmscantest(a);
+ERROR: parallel worker failed to initialize
+HINT: More details may be available in the server log.
CREATE INDEX i_bmtest_b ON bmscantest(b);
-- We want to use bitmapscans. With default settings, the planner currently
-- chooses a bitmap scan for the queries below anyway, but let's make sure. |
| 56/6184 |
pg_plan_advice |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/test_setup.out C:/cirrus/build/testrun/pg_plan_advice/0...
--- C:/cirrus/src/test/regress/expected/test_setup.out 2025-11-08 11:17:09.425127700 +0000
+++ C:/cirrus/build/testrun/pg_plan_advice/001_regress/data/results/test_setup.out 2025-11-08 11:28:37.434317800 +0000
@@ -205,6 +205,7 @@
RETURNS bool
AS :'regresslib', 'binary_coercible'
LANGUAGE C STRICT STABLE PARALLEL SAFE;
+ERROR: could not access file "/usr/local/pgsql/lib/regress.dll": No such file or directory
-- Use hand-rolled hash functions and operator classes to get predictable
-- result on different machines. The hash function for int4 simply returns
-- the sum of the values passed to it and the one for text returns the length
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/type_sanity.out C:/cirrus/build/testrun/pg_plan_advice/...
--- C:/cirrus/src/test/regress/expected/type_sanity.out 2025-11-08 11:17:09.439818000 +0000
+++ C:/cirrus/build/testrun/pg_plan_advice/001_regress/data/results/type_sanity.out 2025-11-08 11:28:45.947505400 +0000
@@ -595,6 +595,7 @@
CREATE FUNCTION is_catalog_text_unique_index_oid(oid) RETURNS bool
AS :'regresslib', 'is_catalog_text_unique_index_oid'
LANGUAGE C STRICT;
+ERROR: could not access file "/usr/local/pgsql/lib/regress.dll": No such file or directory
SELECT indexrelid::regclass
... |
|
Windows - Server 2022, MinGW64 - Meson |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/test_setup.out C:/cirrus/build/testrun/pg_plan_advice/0...
--- C:/cirrus/src/test/regress/expected/test_setup.out 2025-11-08 11:16:06.213631400 +0000
+++ C:/cirrus/build/testrun/pg_plan_advice/001_regress/data/results/test_setup.out 2025-11-08 11:31:53.170917700 +0000
@@ -205,6 +205,7 @@
RETURNS bool
AS :'regresslib', 'binary_coercible'
LANGUAGE C STRICT STABLE PARALLEL SAFE;
+ERROR: could not access file "/usr/local/pgsql/lib/regress.dll": No such file or directory
-- Use hand-rolled hash functions and operator classes to get predictable
-- result on different machines. The hash function for int4 simply returns
-- the sum of the values passed to it and the one for text returns the length
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/type_sanity.out C:/cirrus/build/testrun/pg_plan_advice/...
--- C:/cirrus/src/test/regress/expected/type_sanity.out 2025-11-08 11:16:06.230116500 +0000
+++ C:/cirrus/build/testrun/pg_plan_advice/001_regress/data/results/type_sanity.out 2025-11-08 11:31:57.120003000 +0000
@@ -595,6 +595,7 @@
CREATE FUNCTION is_catalog_text_unique_index_oid(oid) RETURNS bool
AS :'regresslib', 'is_catalog_text_unique_index_oid'
LANGUAGE C STRICT;
+ERROR: could not access file "/usr/local/pgsql/lib/regress.dll": No such file or directory
SELECT indexrelid::regclass
... |
|
macOS - Sequoia - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/test_setup.out /Users/admin/pgsql/build/testrun/pg_plan_advice/001...
--- /Users/admin/pgsql/src/test/regress/expected/test_setup.out 2025-11-08 11:16:02
+++ /Users/admin/pgsql/build/testrun/pg_plan_advice/001_regress/data/results/test_setup.out 2025-11-08 11:21:38
@@ -205,6 +205,7 @@
RETURNS bool
AS :'regresslib', 'binary_coercible'
LANGUAGE C STRICT STABLE PARALLEL SAFE;
+ERROR: could not access file "/usr/local/pgsql/lib/regress.dylib": No such file or directory
-- Use hand-rolled hash functions and operator classes to get predictable
-- result on different machines. The hash function for int4 simply returns
-- the sum of the values passed to it and the one for text returns the length
diff -U3 /Users/admin/pgsql/src/test/regress/expected/type_sanity.out /Users/admin/pgsql/build/testrun/pg_plan_advice/00...
--- /Users/admin/pgsql/src/test/regress/expected/type_sanity.out 2025-11-08 11:16:02
+++ /Users/admin/pgsql/build/testrun/pg_plan_advice/001_regress/data/results/type_sanity.out 2025-11-08 11:21:41
@@ -595,6 +595,7 @@
CREATE FUNCTION is_catalog_text_unique_index_oid(oid) RETURNS bool
AS :'regresslib', 'is_catalog_text_unique_index_oid'
LANGUAGE C STRICT;
+ERROR: could not access file "/usr/local/pgsql/lib/regress.dylib": No such file or directory
SELECT indexrelid::regclass
... |
|
Linux - Debian Trixie - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/test_setup.out /tmp/cirrus-ci-build/build/testrun/pg_plan_advice...
--- /tmp/cirrus-ci-build/src/test/regress/expected/test_setup.out 2025-11-08 11:16:02.312393634 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_plan_advice/001_regress/data/results/test_setup.out 2025-11-08 11:23:32.824077...
@@ -205,6 +205,7 @@
RETURNS bool
AS :'regresslib', 'binary_coercible'
LANGUAGE C STRICT STABLE PARALLEL SAFE;
+ERROR: could not access file "/usr/local/pgsql/lib/x86_64-linux-gnu/regress.so": No such file or directory
-- Use hand-rolled hash functions and operator classes to get predictable
-- result on different machines. The hash function for int4 simply returns
-- the sum of the values passed to it and the one for text returns the length
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/type_sanity.out /tmp/cirrus-ci-build/build/testrun/pg_plan_advic...
--- /tmp/cirrus-ci-build/src/test/regress/expected/type_sanity.out 2025-11-08 11:16:02.320393634 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_plan_advice/001_regress/data/results/type_sanity.out 2025-11-08 11:23:36.13207...
@@ -595,6 +595,7 @@
CREATE FUNCTION is_catalog_text_unique_index_oid(oid) RETURNS bool
AS :'regresslib', 'is_catalog_text_unique_index_oid'
LANGUAGE C STRICT;
+ERROR: could not access file "/usr/local/pgsql/lib/x86_64-linux-gnu/regress.so": No such file or directory
SELECT indexrelid::regclass
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out 2025-11-08 11:16:02.312393634 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/subselect.out 2025-11-08 11:20:32.25606947...
@@ -3067,136 +3067,10 @@
SET plan_cache_mode = 'force_generic_plan';
EXPLAIN (COSTS OFF) EXECUTE test(NULL, 3.14, '-1.5');
- QUERY PLAN ...
------------------------------------------------------------------------------------------------------------------------...
- Hash Semi Join
- Hash Cond: (((sin((onek.two)::double precision) * (onek.four)::double precision) / ($3)::real) = "*VALUES*".column1)
- -> Seq Scan on onek
- -> Hash
- -> Values Scan on "*VALUES*"
-(5 rows)
-
-RESET plan_cache_mode;
--- VtA doesn't support LIMIT, OFFSET, and ORDER BY clauses
-EXPLAIN (COSTS OFF)
-SELECT ten FROM onek WHERE unique1 IN (VALUES (1), (2) OFFSET 1);
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/pl/plpgsql/src/expected/plpgsql_simple.out /tmp/cirrus-ci-build/build/testrun/plpgsql/...
--- /tmp/cirrus-ci-build/src/pl/plpgsql/src/expected/plpgsql_simple.out 2025-11-08 11:16:02.048393644 +0000
+++ /tmp/cirrus-ci-build/build/testrun/plpgsql/regress/results/plpgsql_simple.out 2025-11-08 11:21:32.960078568 +0000
@@ -128,4 +128,7 @@
fetch p_CurData into val;
raise notice 'val = %', val;
end; $$;
-NOTICE: val = 42
+server closed the connection unexpectedly
+ This probably means the server terminated abnormally
+ before or while processing the request.
+connection to server was lost
diff -U3 /tmp/cirrus-ci-build/src/pl/plpgsql/src/expected/plpgsql_transaction.out /tmp/cirrus-ci-build/build/testrun/plp...
--- /tmp/cirrus-ci-build/src/pl/plpgsql/src/expected/plpgsql_transaction.out 2025-11-08 11:16:02.048393644 +0000
+++ /tmp/cirrus-ci-build/build/testrun/plpgsql/regress/results/plpgsql_transaction.out 2025-11-08 11:21:33.056078574 +00...
@@ -1,741 +1,2 @@
-CREATE TABLE test1 (a int, b text);
-CREATE PROCEDURE transaction_test1(x int, y text)
-LANGUAGE plpgsql
-AS $$
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out /tmp/cirrus-ci-build/build/testrun/recovery/027_st...
--- /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out 2025-11-08 11:16:02.312393634 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/subselect.out 2025-11-08 11:21:21.320077...
@@ -1464,1739 +1464,10 @@
select * from onek i2 where i2.unique1 = o.unique2
) ss
where o.ten = 1;
- count
--------
- 100
-(1 row)
-
-rollback;
---
--- Test rescan of a sorted SetOp node
---
-begin;
-set local enable_hashagg = off;
-explain (costs off)
-select count(*) from
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out /tmp/cirrus-ci-build/build/testrun/regress/regress...
--- /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out 2025-11-08 11:16:02.312393634 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/subselect.out 2025-11-08 11:20:29.128068596 +0000
@@ -1464,1739 +1464,10 @@
select * from onek i2 where i2.unique1 = o.unique2
) ss
where o.ten = 1;
- count
--------
- 100
-(1 row)
-
-rollback;
---
--- Test rescan of a sorted SetOp node
---
-begin;
-set local enable_hashagg = off;
-explain (costs off)
-select count(*) from
... |
|
Linux - Debian Trixie - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/test_setup.out /tmp/cirrus-ci-build/contrib/pg_plan_advice/tmp_c...
--- /tmp/cirrus-ci-build/src/test/regress/expected/test_setup.out 2025-11-08 11:16:02.310239422 +0000
+++ /tmp/cirrus-ci-build/contrib/pg_plan_advice/tmp_check/results/test_setup.out 2025-11-08 11:22:30.976592937 +0000
@@ -205,6 +205,7 @@
RETURNS bool
AS :'regresslib', 'binary_coercible'
LANGUAGE C STRICT STABLE PARALLEL SAFE;
+ERROR: could not access file "/usr/local/pgsql/lib/regress.so": No such file or directory
-- Use hand-rolled hash functions and operator classes to get predictable
-- result on different machines. The hash function for int4 simply returns
-- the sum of the values passed to it and the one for text returns the length
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/type_sanity.out /tmp/cirrus-ci-build/contrib/pg_plan_advice/tmp_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/type_sanity.out 2025-11-08 11:16:02.314255804 +0000
+++ /tmp/cirrus-ci-build/contrib/pg_plan_advice/tmp_check/results/type_sanity.out 2025-11-08 11:22:37.016714985 +0000
@@ -595,6 +595,7 @@
CREATE FUNCTION is_catalog_text_unique_index_oid(oid) RETURNS bool
AS :'regresslib', 'is_catalog_text_unique_index_oid'
LANGUAGE C STRICT;
+ERROR: could not access file "/usr/local/pgsql/lib/regress.so": No such file or directory
SELECT indexrelid::regclass
... |
|
OpenBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/test_setup.out /home/postgres/postgres/build/testrun/pg_plan_...
--- /home/postgres/postgres/src/test/regress/expected/test_setup.out Sat Nov 8 11:16:41 2025
+++ /home/postgres/postgres/build/testrun/pg_plan_advice/001_regress/data/results/test_setup.out Sat Nov 8 11:25:36 202...
@@ -205,6 +205,7 @@
RETURNS bool
AS :'regresslib', 'binary_coercible'
LANGUAGE C STRICT STABLE PARALLEL SAFE;
+ERROR: could not access file "/usr/local/pgsql/lib/regress.so": No such file or directory
-- Use hand-rolled hash functions and operator classes to get predictable
-- result on different machines. The hash function for int4 simply returns
-- the sum of the values passed to it and the one for text returns the length
diff -U3 /home/postgres/postgres/src/test/regress/expected/type_sanity.out /home/postgres/postgres/build/testrun/pg_plan...
--- /home/postgres/postgres/src/test/regress/expected/type_sanity.out Sat Nov 8 11:16:41 2025
+++ /home/postgres/postgres/build/testrun/pg_plan_advice/001_regress/data/results/type_sanity.out Sat Nov 8 11:25:44 20...
@@ -595,6 +595,7 @@
CREATE FUNCTION is_catalog_text_unique_index_oid(oid) RETURNS bool
AS :'regresslib', 'is_catalog_text_unique_index_oid'
LANGUAGE C STRICT;
+ERROR: could not access file "/usr/local/pgsql/lib/regress.so": No such file or directory
SELECT indexrelid::regclass
... |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/test_setup.out /home/postgres/postgres/build/testrun/pg_plan_...
--- /home/postgres/postgres/src/test/regress/expected/test_setup.out 2025-11-08 11:16:22.576282089 +0000
+++ /home/postgres/postgres/build/testrun/pg_plan_advice/001_regress/data/results/test_setup.out 2025-11-08 11:21:23.264...
@@ -205,6 +205,7 @@
RETURNS bool
AS :'regresslib', 'binary_coercible'
LANGUAGE C STRICT STABLE PARALLEL SAFE;
+ERROR: could not access file "/usr/local/pgsql/lib/regress.so": No such file or directory
-- Use hand-rolled hash functions and operator classes to get predictable
-- result on different machines. The hash function for int4 simply returns
-- the sum of the values passed to it and the one for text returns the length
diff -U3 /home/postgres/postgres/src/test/regress/expected/type_sanity.out /home/postgres/postgres/build/testrun/pg_plan...
--- /home/postgres/postgres/src/test/regress/expected/type_sanity.out 2025-11-08 11:16:22.600581927 +0000
+++ /home/postgres/postgres/build/testrun/pg_plan_advice/001_regress/data/results/type_sanity.out 2025-11-08 11:21:25.98...
@@ -595,6 +595,7 @@
CREATE FUNCTION is_catalog_text_unique_index_oid(oid) RETURNS bool
AS :'regresslib', 'is_catalog_text_unique_index_oid'
LANGUAGE C STRICT;
+ERROR: could not access file "/usr/local/pgsql/lib/regress.so": No such file or directory
SELECT indexrelid::regclass
... |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/test_setup.out /tmp/cirrus-ci-build/build/testrun/pg_plan_advice...
--- /tmp/cirrus-ci-build/src/test/regress/expected/test_setup.out 2025-11-08 11:16:01.990451000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_plan_advice/001_regress/data/results/test_setup.out 2025-11-08 11:22:24.653281...
@@ -205,6 +205,7 @@
RETURNS bool
AS :'regresslib', 'binary_coercible'
LANGUAGE C STRICT STABLE PARALLEL SAFE;
+ERROR: could not access file "/usr/local/pgsql/lib/regress.so": No such file or directory
-- Use hand-rolled hash functions and operator classes to get predictable
-- result on different machines. The hash function for int4 simply returns
-- the sum of the values passed to it and the one for text returns the length
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/type_sanity.out /tmp/cirrus-ci-build/build/testrun/pg_plan_advic...
--- /tmp/cirrus-ci-build/src/test/regress/expected/type_sanity.out 2025-11-08 11:16:01.996420000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_plan_advice/001_regress/data/results/type_sanity.out 2025-11-08 11:22:41.93288...
@@ -595,6 +595,7 @@
CREATE FUNCTION is_catalog_text_unique_index_oid(oid) RETURNS bool
AS :'regresslib', 'is_catalog_text_unique_index_oid'
LANGUAGE C STRICT;
+ERROR: could not access file "/usr/local/pgsql/lib/regress.so": No such file or directory
SELECT indexrelid::regclass
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/pg_plan_advice/expected/local_collector.out /tmp/cirrus-ci-build/build/testrun/pg_...
--- /tmp/cirrus-ci-build/contrib/pg_plan_advice/expected/local_collector.out 2025-11-08 11:16:00.395519000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_plan_advice/regress/results/local_collector.out 2025-11-08 11:21:29.635518000 ...
@@ -24,10 +24,10 @@
-- Should return the advice from the second test query.
SELECT advice FROM pg_get_collected_local_advice() ORDER BY id LIMIT 1;
- advice
-------------------------
- SEQ_SCAN(dummy_table) +
- NO_GATHER(dummy_table)
+ advice
+-----------------------
+ SEQ_SCAN(dummy_table)+
+ GATHER(dummy_table)
(1 row)
-- Now try clearing advice again. |
| 56/6095 |
LISTEN/NOTIFY bug: VACUUM sets frozenxid past a xid in async queue |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out /tmp/cirrus-ci-build/build/testrun/postgres...
--- /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out 2025-11-08 05:58:41.366167000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/postgres_fdw-running/regress/results/postgres_fdw.out 2025-11-08 06:06:29.3642110...
@@ -12713,8 +12713,7 @@
FROM postgres_fdw_get_connections(true);
server_name | closed | remote_backend_pid
-------------+--------+--------------------
- loopback | t | t
-(1 row)
+(0 rows)
-- Clean up
\set VERBOSITY default |
| 56/5958 |
Per backend relation statistics tracking |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/stats.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_u...
--- /tmp/cirrus-ci-build/src/test/regress/expected/stats.out 2025-11-05 13:07:53.517859000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/stats.out 2025-11-05 13:12:36.460976000 +0...
@@ -243,7 +243,7 @@
SELECT :seq_scan_after > :seq_scan_before;
?column?
----------
- t
+ f
(1 row)
---- |
| 56/6087 |
CREATE TABLE LIKE INCLUDING TRIGGERS |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/triggers.out C:/cirrus/build/testrun/regress/regress/re...
--- C:/cirrus/src/test/regress/expected/triggers.out 2025-11-05 00:24:02.065787400 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/triggers.out 2025-11-05 00:26:45.121603600 +0000
@@ -407,6 +407,7 @@
--create table like tests
COMMENT ON TRIGGER before_ins_stmt_trig ON main_table IS 'trigger before_ins_stmt_trig';
CREATE TABLE main_table1(c INT, LIKE main_table INCLUDING TRIGGERS INCLUDING COMMENTS);
+ERROR: trigger "after_ins_stmt_trig" for relation "main_table1" already exists
\d main_table
Table "public.main_table"
Column | Type | Collation | Nullable | Default
@@ -424,22 +425,6 @@
before_upd_a_stmt_trig BEFORE UPDATE OF a ON main_table FOR EACH STATEMENT EXECUTE FUNCTION trigger_func('before_up...
\d main_table1
- Table "public.main_table1"
- Column | Type | Collation | Nullable | Default
---------+---------+-----------+----------+---------
- c | integer | | |
- a | integer | | |
... |
|
Linux - Debian Trixie - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/build/testrun/recovery/027_str...
--- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out 2025-11-05 00:23:58.919191853 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/triggers.out 2025-11-05 00:29:29.3986958...
@@ -431,14 +431,14 @@
a | integer | | |
b | integer | | |
Triggers:
+ "0 0 0 0 0 0 0 ]} :resulttype 26 :resulttypmod -1 :resultcollid " BEFORE INSERT ON main_table1 FOR EACH STATEMENT E...
after_ins_stmt_trig AFTER INSERT ON main_table1 FOR EACH STATEMENT EXECUTE FUNCTION trigger_func('after_ins_stmt')
after_upd_a_b_row_trig AFTER UPDATE OF a, b ON main_table1 FOR EACH ROW EXECUTE FUNCTION trigger_func('after_upd_a_...
after_upd_b_row_trig AFTER UPDATE OF b ON main_table1 FOR EACH ROW EXECUTE FUNCTION trigger_func('after_upd_b_row')
after_upd_b_stmt_trig AFTER UPDATE OF b ON main_table1 FOR EACH STATEMENT EXECUTE FUNCTION trigger_func('after_upd_...
- after_upd_stmt_trig AFTER UPDATE ON main_table1 FOR EACH STATEMENT EXECUTE FUNCTION trigger_func('after_upd_stmt')
- before_ins_stmt_trig BEFORE INSERT ON main_table1 FOR EACH STATEMENT EXECUTE FUNCTION trigger_func('before_ins_stmt...
before_upd_a_row_trig BEFORE UPDATE OF a ON main_table1 FOR EACH ROW EXECUTE FUNCTION trigger_func('before_upd_a_ro...
before_upd_a_stmt_trig BEFORE UPDATE OF a ON main_table1 FOR EACH STATEMENT EXECUTE FUNCTION trigger_func('before_u...
+ "false :opcollid 0 :inputcollid 0 :args ({VAR :varno 2 :varattno" AFTER UPDATE ON main_table1 FOR EACH STATEMENT EX...
\dd before_ins_stmt_trig
Object descriptions |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/build/testrun/recovery/027_str...
--- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out 2025-11-05 00:23:57.461266000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/triggers.out 2025-11-05 00:27:34.9832430...
@@ -431,6 +431,7 @@
a | integer | | |
b | integer | | |
Triggers:
+ "" BEFORE UPDATE OF a ON main_table1 FOR EACH STATEMENT EXECUTE FUNCTION trigger_func('before_upd_a_stmt')
after_ins_stmt_trig AFTER INSERT ON main_table1 FOR EACH STATEMENT EXECUTE FUNCTION trigger_func('after_ins_stmt')
after_upd_a_b_row_trig AFTER UPDATE OF a, b ON main_table1 FOR EACH ROW EXECUTE FUNCTION trigger_func('after_upd_a_...
after_upd_b_row_trig AFTER UPDATE OF b ON main_table1 FOR EACH ROW EXECUTE FUNCTION trigger_func('after_upd_b_row')
@@ -438,7 +439,6 @@
after_upd_stmt_trig AFTER UPDATE ON main_table1 FOR EACH STATEMENT EXECUTE FUNCTION trigger_func('after_upd_stmt')
before_ins_stmt_trig BEFORE INSERT ON main_table1 FOR EACH STATEMENT EXECUTE FUNCTION trigger_func('before_ins_stmt...
before_upd_a_row_trig BEFORE UPDATE OF a ON main_table1 FOR EACH ROW EXECUTE FUNCTION trigger_func('before_upd_a_ro...
- before_upd_a_stmt_trig BEFORE UPDATE OF a ON main_table1 FOR EACH STATEMENT EXECUTE FUNCTION trigger_func('before_u...
\dd before_ins_stmt_trig
Object descriptions |
|
OpenBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/triggers.out /home/postgres/postgres/build/testrun/recovery/0...
--- /home/postgres/postgres/src/test/regress/expected/triggers.out Wed Nov 5 00:24:19 2025
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/triggers.out Wed Nov 5 00:29:35 2025
@@ -407,6 +407,7 @@
--create table like tests
COMMENT ON TRIGGER before_ins_stmt_trig ON main_table IS 'trigger before_ins_stmt_trig';
CREATE TABLE main_table1(c INT, LIKE main_table INCLUDING TRIGGERS INCLUDING COMMENTS);
+ERROR: trigger "" for relation "main_table1" already exists
\d main_table
Table "public.main_table"
Column | Type | Collation | Nullable | Default
@@ -424,22 +425,6 @@
before_upd_a_stmt_trig BEFORE UPDATE OF a ON main_table FOR EACH STATEMENT EXECUTE FUNCTION trigger_func('before_up...
\d main_table1
- Table "public.main_table1"
- Column | Type | Collation | Nullable | Default
---------+---------+-----------+----------+---------
- c | integer | | |
- a | integer | | |
... |
| 56/5699 |
Adding error messages to a few slash commands |
|
Windows - Server 2022, MinGW64 - Meson |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/matview.out C:/cirrus/build/testrun/pg_upgrade/002_pg_u...
--- C:/cirrus/src/test/regress/expected/matview.out 2025-11-02 00:13:31.684350700 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/matview.out 2025-11-02 00:16:13.822746200 +0000
@@ -141,6 +141,11 @@
CREATE SCHEMA mvtest_mvschema;
ALTER MATERIALIZED VIEW mvtest_tvm SET SCHEMA mvtest_mvschema;
\d+ mvtest_tvm
+ List of relations
+ Schema | Name | Type | Owner | Persistence | Size | Description
+--------+------+------+-------+-------------+------+-------------
+(0 rows)
+
\d+ mvtest_tvmm
Materialized view "public.mvtest_tvmm"
Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/identity.out C:/cirrus/build/testrun/pg_upgrade/002_pg_...
--- C:/cirrus/src/test/regress/expected/identity.out 2025-11-02 00:13:31.653792500 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/identity.out 2025-11-02 00:16:13.319820400 +0000
@@ -607,6 +607,11 @@
Sequence for identity column: public.itest8.f4
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/matview.out C:/cirrus/build/testrun/recovery/027_stream...
--- C:/cirrus/src/test/regress/expected/matview.out 2025-11-02 00:13:31.684350700 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/matview.out 2025-11-02 00:19:03.140047900 +0000
@@ -141,6 +141,11 @@
CREATE SCHEMA mvtest_mvschema;
ALTER MATERIALIZED VIEW mvtest_tvm SET SCHEMA mvtest_mvschema;
\d+ mvtest_tvm
+ List of relations
+ Schema | Name | Type | Owner | Persistence | Size | Description
+--------+------+------+-------+-------------+------+-------------
+(0 rows)
+
\d+ mvtest_tvmm
Materialized view "public.mvtest_tvmm"
Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/identity.out C:/cirrus/build/testrun/recovery/027_strea...
--- C:/cirrus/src/test/regress/expected/identity.out 2025-11-02 00:13:31.653792500 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/identity.out 2025-11-02 00:19:04.000889100 +0000
@@ -607,6 +607,11 @@
Sequence for identity column: public.itest8.f4
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/matview.out C:/cirrus/build/testrun/regress/regress/res...
--- C:/cirrus/src/test/regress/expected/matview.out 2025-11-02 00:13:31.684350700 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/matview.out 2025-11-02 00:16:07.576663900 +0000
@@ -141,6 +141,11 @@
CREATE SCHEMA mvtest_mvschema;
ALTER MATERIALIZED VIEW mvtest_tvm SET SCHEMA mvtest_mvschema;
\d+ mvtest_tvm
+ List of relations
+ Schema | Name | Type | Owner | Persistence | Size | Description
+--------+------+------+-------+-------------+------+-------------
+(0 rows)
+
\d+ mvtest_tvmm
Materialized view "public.mvtest_tvmm"
Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/identity.out C:/cirrus/build/testrun/regress/regress/re...
--- C:/cirrus/src/test/regress/expected/identity.out 2025-11-02 00:13:31.653792500 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/identity.out 2025-11-02 00:16:07.108020400 +0000
@@ -607,6 +607,11 @@
Sequence for identity column: public.itest8.f4
... |
|
macOS - Sequoia - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/matview.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upg...
--- /Users/admin/pgsql/src/test/regress/expected/matview.out 2025-11-02 00:13:16
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/matview.out 2025-11-02 00:15:56
@@ -141,6 +141,11 @@
CREATE SCHEMA mvtest_mvschema;
ALTER MATERIALIZED VIEW mvtest_tvm SET SCHEMA mvtest_mvschema;
\d+ mvtest_tvm
+ List of relations
+ Schema | Name | Type | Owner | Persistence | Size | Description
+--------+------+------+-------+-------------+------+-------------
+(0 rows)
+
\d+ mvtest_tvmm
Materialized view "public.mvtest_tvmm"
Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
diff -U3 /Users/admin/pgsql/src/test/regress/expected/identity.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_up...
--- /Users/admin/pgsql/src/test/regress/expected/identity.out 2025-11-02 00:13:16
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/identity.out 2025-11-02 00:15:55
@@ -607,6 +607,11 @@
Sequence for identity column: public.itest8.f4
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/matview.out /Users/admin/pgsql/build/testrun/recovery/027_stream_r...
--- /Users/admin/pgsql/src/test/regress/expected/matview.out 2025-11-02 00:13:16
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/matview.out 2025-11-02 00:16:47
@@ -141,6 +141,11 @@
CREATE SCHEMA mvtest_mvschema;
ALTER MATERIALIZED VIEW mvtest_tvm SET SCHEMA mvtest_mvschema;
\d+ mvtest_tvm
+ List of relations
+ Schema | Name | Type | Owner | Persistence | Size | Description
+--------+------+------+-------+-------------+------+-------------
+(0 rows)
+
\d+ mvtest_tvmm
Materialized view "public.mvtest_tvmm"
Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
diff -U3 /Users/admin/pgsql/src/test/regress/expected/identity.out /Users/admin/pgsql/build/testrun/recovery/027_stream_...
--- /Users/admin/pgsql/src/test/regress/expected/identity.out 2025-11-02 00:13:16
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/identity.out 2025-11-02 00:16:48
@@ -607,6 +607,11 @@
Sequence for identity column: public.itest8.f4
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/matview.out /Users/admin/pgsql/build/testrun/regress/regress/resul...
--- /Users/admin/pgsql/src/test/regress/expected/matview.out 2025-11-02 00:13:16
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/matview.out 2025-11-02 00:15:56
@@ -141,6 +141,11 @@
CREATE SCHEMA mvtest_mvschema;
ALTER MATERIALIZED VIEW mvtest_tvm SET SCHEMA mvtest_mvschema;
\d+ mvtest_tvm
+ List of relations
+ Schema | Name | Type | Owner | Persistence | Size | Description
+--------+------+------+-------+-------------+------+-------------
+(0 rows)
+
\d+ mvtest_tvmm
Materialized view "public.mvtest_tvmm"
Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
diff -U3 /Users/admin/pgsql/src/test/regress/expected/identity.out /Users/admin/pgsql/build/testrun/regress/regress/resu...
--- /Users/admin/pgsql/src/test/regress/expected/identity.out 2025-11-02 00:13:16
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/identity.out 2025-11-02 00:15:56
@@ -607,6 +607,11 @@
Sequence for identity column: public.itest8.f4
... |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/matview.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg...
--- /tmp/cirrus-ci-build/src/test/regress/expected/matview.out 2025-11-02 00:13:15.992329656 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/matview.out 2025-11-02 00:15:14.236936584 ...
@@ -141,6 +141,11 @@
CREATE SCHEMA mvtest_mvschema;
ALTER MATERIALIZED VIEW mvtest_tvm SET SCHEMA mvtest_mvschema;
\d+ mvtest_tvm
+ List of relations
+ Schema | Name | Type | Owner | Persistence | Size | Description
+--------+------+------+-------+-------------+------+-------------
+(0 rows)
+
\d+ mvtest_tvmm
Materialized view "public.mvtest_tvmm"
Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/identity.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_p...
--- /tmp/cirrus-ci-build/src/test/regress/expected/identity.out 2025-11-02 00:13:15.976329322 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/identity.out 2025-11-02 00:15:14.376935580...
@@ -607,6 +607,11 @@
Sequence for identity column: public.itest8.f4
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/matview.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stre...
--- /tmp/cirrus-ci-build/src/test/regress/expected/matview.out 2025-11-02 00:13:15.992329656 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/matview.out 2025-11-02 00:16:35.51257813...
@@ -141,6 +141,11 @@
CREATE SCHEMA mvtest_mvschema;
ALTER MATERIALIZED VIEW mvtest_tvm SET SCHEMA mvtest_mvschema;
\d+ mvtest_tvm
+ List of relations
+ Schema | Name | Type | Owner | Persistence | Size | Description
+--------+------+------+-------+-------------+------+-------------
+(0 rows)
+
\d+ mvtest_tvmm
Materialized view "public.mvtest_tvmm"
Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/identity.out /tmp/cirrus-ci-build/build/testrun/recovery/027_str...
--- /tmp/cirrus-ci-build/src/test/regress/expected/identity.out 2025-11-02 00:13:15.976329322 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/identity.out 2025-11-02 00:16:35.5365780...
@@ -607,6 +607,11 @@
Sequence for identity column: public.itest8.f4
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/matview.out /tmp/cirrus-ci-build/build/testrun/regress/regress/r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/matview.out 2025-11-02 00:13:15.992329656 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/matview.out 2025-11-02 00:15:11.364957662 +0000
@@ -141,6 +141,11 @@
CREATE SCHEMA mvtest_mvschema;
ALTER MATERIALIZED VIEW mvtest_tvm SET SCHEMA mvtest_mvschema;
\d+ mvtest_tvm
+ List of relations
+ Schema | Name | Type | Owner | Persistence | Size | Description
+--------+------+------+-------+-------------+------+-------------
+(0 rows)
+
\d+ mvtest_tvmm
Materialized view "public.mvtest_tvmm"
Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/identity.out /tmp/cirrus-ci-build/build/testrun/regress/regress/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/identity.out 2025-11-02 00:13:15.976329322 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/identity.out 2025-11-02 00:15:11.208958827 +0000
@@ -607,6 +607,11 @@
Sequence for identity column: public.itest8.f4
... |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/matview.out C:/cirrus/build/testrun/pg_upgrade/002_pg_u...
--- C:/cirrus/src/test/regress/expected/matview.out 2025-11-02 00:13:18.784205100 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/matview.out 2025-11-02 00:16:22.563714600 +0000
@@ -141,6 +141,11 @@
CREATE SCHEMA mvtest_mvschema;
ALTER MATERIALIZED VIEW mvtest_tvm SET SCHEMA mvtest_mvschema;
\d+ mvtest_tvm
+ List of relations
+ Schema | Name | Type | Owner | Persistence | Size | Description
+--------+------+------+-------+-------------+------+-------------
+(0 rows)
+
\d+ mvtest_tvmm
Materialized view "public.mvtest_tvmm"
Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/identity.out C:/cirrus/build/testrun/pg_upgrade/002_pg_...
--- C:/cirrus/src/test/regress/expected/identity.out 2025-11-02 00:13:18.748864100 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/identity.out 2025-11-02 00:16:22.313712200 +0000
@@ -607,6 +607,11 @@
Sequence for identity column: public.itest8.f4
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/matview.out C:/cirrus/build/testrun/recovery/027_stream...
--- C:/cirrus/src/test/regress/expected/matview.out 2025-11-02 00:13:18.784205100 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/matview.out 2025-11-02 00:18:57.883954700 +0000
@@ -141,6 +141,11 @@
CREATE SCHEMA mvtest_mvschema;
ALTER MATERIALIZED VIEW mvtest_tvm SET SCHEMA mvtest_mvschema;
\d+ mvtest_tvm
+ List of relations
+ Schema | Name | Type | Owner | Persistence | Size | Description
+--------+------+------+-------+-------------+------+-------------
+(0 rows)
+
\d+ mvtest_tvmm
Materialized view "public.mvtest_tvmm"
Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/identity.out C:/cirrus/build/testrun/recovery/027_strea...
--- C:/cirrus/src/test/regress/expected/identity.out 2025-11-02 00:13:18.748864100 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/identity.out 2025-11-02 00:18:56.740889600 +0000
@@ -607,6 +607,11 @@
Sequence for identity column: public.itest8.f4
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/matview.out C:/cirrus/build/testrun/regress/regress/res...
--- C:/cirrus/src/test/regress/expected/matview.out 2025-11-02 00:13:18.784205100 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/matview.out 2025-11-02 00:16:16.448975300 +0000
@@ -141,6 +141,11 @@
CREATE SCHEMA mvtest_mvschema;
ALTER MATERIALIZED VIEW mvtest_tvm SET SCHEMA mvtest_mvschema;
\d+ mvtest_tvm
+ List of relations
+ Schema | Name | Type | Owner | Persistence | Size | Description
+--------+------+------+-------+-------------+------+-------------
+(0 rows)
+
\d+ mvtest_tvmm
Materialized view "public.mvtest_tvmm"
Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/identity.out C:/cirrus/build/testrun/regress/regress/re...
--- C:/cirrus/src/test/regress/expected/identity.out 2025-11-02 00:13:18.748864100 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/identity.out 2025-11-02 00:16:16.182367000 +0000
@@ -607,6 +607,11 @@
Sequence for identity column: public.itest8.f4
... |
|
OpenBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/matview.out /home/postgres/postgres/build/testrun/pg_upgrade/...
--- /home/postgres/postgres/src/test/regress/expected/matview.out Sun Nov 2 00:13:30 2025
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/matview.out Sun Nov 2 00:15:42 2025
@@ -141,6 +141,11 @@
CREATE SCHEMA mvtest_mvschema;
ALTER MATERIALIZED VIEW mvtest_tvm SET SCHEMA mvtest_mvschema;
\d+ mvtest_tvm
+ List of relations
+ Schema | Name | Type | Owner | Persistence | Size | Description
+--------+------+------+-------+-------------+------+-------------
+(0 rows)
+
\d+ mvtest_tvmm
Materialized view "public.mvtest_tvmm"
Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
diff -U3 /home/postgres/postgres/src/test/regress/expected/identity.out /home/postgres/postgres/build/testrun/pg_upgrade...
--- /home/postgres/postgres/src/test/regress/expected/identity.out Sun Nov 2 00:13:30 2025
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/identity.out Sun Nov 2 00:15:42 2025
@@ -607,6 +607,11 @@
Sequence for identity column: public.itest8.f4
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/matview.out /home/postgres/postgres/build/testrun/recovery/02...
--- /home/postgres/postgres/src/test/regress/expected/matview.out Sun Nov 2 00:13:30 2025
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/matview.out Sun Nov 2 00:17:23 2025
@@ -141,6 +141,11 @@
CREATE SCHEMA mvtest_mvschema;
ALTER MATERIALIZED VIEW mvtest_tvm SET SCHEMA mvtest_mvschema;
\d+ mvtest_tvm
+ List of relations
+ Schema | Name | Type | Owner | Persistence | Size | Description
+--------+------+------+-------+-------------+------+-------------
+(0 rows)
+
\d+ mvtest_tvmm
Materialized view "public.mvtest_tvmm"
Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
diff -U3 /home/postgres/postgres/src/test/regress/expected/identity.out /home/postgres/postgres/build/testrun/recovery/0...
--- /home/postgres/postgres/src/test/regress/expected/identity.out Sun Nov 2 00:13:30 2025
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/identity.out Sun Nov 2 00:17:24 2025
@@ -607,6 +607,11 @@
Sequence for identity column: public.itest8.f4
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/matview.out /home/postgres/postgres/build/testrun/regress/reg...
--- /home/postgres/postgres/src/test/regress/expected/matview.out Sun Nov 2 00:13:30 2025
+++ /home/postgres/postgres/build/testrun/regress/regress/results/matview.out Sun Nov 2 00:15:33 2025
@@ -141,6 +141,11 @@
CREATE SCHEMA mvtest_mvschema;
ALTER MATERIALIZED VIEW mvtest_tvm SET SCHEMA mvtest_mvschema;
\d+ mvtest_tvm
+ List of relations
+ Schema | Name | Type | Owner | Persistence | Size | Description
+--------+------+------+-------+-------------+------+-------------
+(0 rows)
+
\d+ mvtest_tvmm
Materialized view "public.mvtest_tvmm"
Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
diff -U3 /home/postgres/postgres/src/test/regress/expected/identity.out /home/postgres/postgres/build/testrun/regress/re...
--- /home/postgres/postgres/src/test/regress/expected/identity.out Sun Nov 2 00:13:30 2025
+++ /home/postgres/postgres/build/testrun/regress/regress/results/identity.out Sun Nov 2 00:15:33 2025
@@ -607,6 +607,11 @@
Sequence for identity column: public.itest8.f4
... |
|
Linux - Debian Bookworm - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/matview.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/re...
--- /tmp/cirrus-ci-build/src/test/regress/expected/matview.out 2025-11-02 00:13:20.704323133 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/matview.out 2025-11-02 00:18:21.731607052 +0000
@@ -141,6 +141,11 @@
CREATE SCHEMA mvtest_mvschema;
ALTER MATERIALIZED VIEW mvtest_tvm SET SCHEMA mvtest_mvschema;
\d+ mvtest_tvm
+ List of relations
+ Schema | Name | Type | Owner | Persistence | Size | Description
+--------+------+------+-------+-------------+------+-------------
+(0 rows)
+
\d+ mvtest_tvmm
Materialized view "public.mvtest_tvmm"
Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/identity.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/identity.out 2025-11-02 00:13:20.688314607 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/identity.out 2025-11-02 00:18:21.507594795 +0000
@@ -607,6 +607,11 @@
Sequence for identity column: public.itest8.f4
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/matview.out /tmp/cirrus-ci-build/src/test/regress/results/matvie...
--- /tmp/cirrus-ci-build/src/test/regress/expected/matview.out 2025-11-02 00:13:20.704323133 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/matview.out 2025-11-02 00:15:35.251084356 +0000
@@ -141,6 +141,11 @@
CREATE SCHEMA mvtest_mvschema;
ALTER MATERIALIZED VIEW mvtest_tvm SET SCHEMA mvtest_mvschema;
\d+ mvtest_tvm
+ List of relations
+ Schema | Name | Type | Owner | Persistence | Size | Description
+--------+------+------+-------+-------------+------+-------------
+(0 rows)
+
\d+ mvtest_tvmm
Materialized view "public.mvtest_tvmm"
Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/identity.out /tmp/cirrus-ci-build/src/test/regress/results/ident...
--- /tmp/cirrus-ci-build/src/test/regress/expected/identity.out 2025-11-02 00:13:20.688314607 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/identity.out 2025-11-02 00:15:34.959056506 +0000
@@ -607,6 +607,11 @@
Sequence for identity column: public.itest8.f4
... |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/matview.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg...
--- /tmp/cirrus-ci-build/src/test/regress/expected/matview.out 2025-11-02 00:13:13.882246000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/matview.out 2025-11-02 00:15:03.510158000 ...
@@ -141,6 +141,11 @@
CREATE SCHEMA mvtest_mvschema;
ALTER MATERIALIZED VIEW mvtest_tvm SET SCHEMA mvtest_mvschema;
\d+ mvtest_tvm
+ List of relations
+ Schema | Name | Type | Owner | Persistence | Size | Description
+--------+------+------+-------+-------------+------+-------------
+(0 rows)
+
\d+ mvtest_tvmm
Materialized view "public.mvtest_tvmm"
Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/identity.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_p...
--- /tmp/cirrus-ci-build/src/test/regress/expected/identity.out 2025-11-02 00:13:13.868921000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/identity.out 2025-11-02 00:15:02.348727000...
@@ -607,6 +607,11 @@
Sequence for identity column: public.itest8.f4
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/matview.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stre...
--- /tmp/cirrus-ci-build/src/test/regress/expected/matview.out 2025-11-02 00:13:13.882246000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/matview.out 2025-11-02 00:16:06.29691200...
@@ -141,6 +141,11 @@
CREATE SCHEMA mvtest_mvschema;
ALTER MATERIALIZED VIEW mvtest_tvm SET SCHEMA mvtest_mvschema;
\d+ mvtest_tvm
+ List of relations
+ Schema | Name | Type | Owner | Persistence | Size | Description
+--------+------+------+-------+-------------+------+-------------
+(0 rows)
+
\d+ mvtest_tvmm
Materialized view "public.mvtest_tvmm"
Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/identity.out /tmp/cirrus-ci-build/build/testrun/recovery/027_str...
--- /tmp/cirrus-ci-build/src/test/regress/expected/identity.out 2025-11-02 00:13:13.868921000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/identity.out 2025-11-02 00:16:03.2077040...
@@ -607,6 +607,11 @@
Sequence for identity column: public.itest8.f4
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/matview.out /tmp/cirrus-ci-build/build/testrun/regress/regress/r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/matview.out 2025-11-02 00:13:13.882246000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/matview.out 2025-11-02 00:15:02.551748000 +0000
@@ -141,6 +141,11 @@
CREATE SCHEMA mvtest_mvschema;
ALTER MATERIALIZED VIEW mvtest_tvm SET SCHEMA mvtest_mvschema;
\d+ mvtest_tvm
+ List of relations
+ Schema | Name | Type | Owner | Persistence | Size | Description
+--------+------+------+-------+-------------+------+-------------
+(0 rows)
+
\d+ mvtest_tvmm
Materialized view "public.mvtest_tvmm"
Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/identity.out /tmp/cirrus-ci-build/build/testrun/regress/regress/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/identity.out 2025-11-02 00:13:13.868921000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/identity.out 2025-11-02 00:14:56.530023000 +0000
@@ -607,6 +607,11 @@
Sequence for identity column: public.itest8.f4
... |
| 56/6158 |
Use log_newpage_range in HASH index build |
|
Windows - Server 2022, MinGW64 - Meson |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/create_index.out C:/cirrus/build/testrun/pg_upgrade/002...
--- C:/cirrus/src/test/regress/expected/create_index.out 2025-10-31 17:36:23.471843500 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/create_index.out 2025-10-31 17:39:43.159051500 +0000
@@ -1216,6 +1216,7 @@
-- maintenance_work_mem setting and fillfactor:
SET maintenance_work_mem = '1MB';
CREATE INDEX hash_tuplesort_idx ON tenk1 USING hash (stringu1 name_ops) WITH (fillfactor = 10);
+WARNING: spool init
EXPLAIN (COSTS OFF)
SELECT count(*) FROM tenk1 WHERE stringu1 = 'TVAAAA';
QUERY PLAN |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/create_index.out C:/cirrus/build/testrun/recovery/027_s...
--- C:/cirrus/src/test/regress/expected/create_index.out 2025-10-31 17:36:23.471843500 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/create_index.out 2025-10-31 17:42:30.711787700 +000...
@@ -1216,6 +1216,7 @@
-- maintenance_work_mem setting and fillfactor:
SET maintenance_work_mem = '1MB';
CREATE INDEX hash_tuplesort_idx ON tenk1 USING hash (stringu1 name_ops) WITH (fillfactor = 10);
+WARNING: spool init
EXPLAIN (COSTS OFF)
SELECT count(*) FROM tenk1 WHERE stringu1 = 'TVAAAA';
QUERY PLAN
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/hash_index.out C:/cirrus/build/testrun/recovery/027_str...
--- C:/cirrus/src/test/regress/expected/hash_index.out 2025-10-31 17:36:23.507586800 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/hash_index.out 2025-10-31 17:42:37.705437500 +0000
@@ -269,6 +269,7 @@
-- Rebuild the index using a different fillfactor
ALTER INDEX hash_split_index SET (fillfactor = 10);
REINDEX INDEX hash_split_index;
+WARNING: spool init
-- Clean up.
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/create_index.out C:/cirrus/build/testrun/regress/regres...
--- C:/cirrus/src/test/regress/expected/create_index.out 2025-10-31 17:36:23.471843500 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/create_index.out 2025-10-31 17:39:39.030147000 +0000
@@ -1216,6 +1216,7 @@
-- maintenance_work_mem setting and fillfactor:
SET maintenance_work_mem = '1MB';
CREATE INDEX hash_tuplesort_idx ON tenk1 USING hash (stringu1 name_ops) WITH (fillfactor = 10);
+WARNING: spool init
EXPLAIN (COSTS OFF)
SELECT count(*) FROM tenk1 WHERE stringu1 = 'TVAAAA';
QUERY PLAN |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/create_index.out C:/cirrus/build/testrun/pg_upgrade/002...
--- C:/cirrus/src/test/regress/expected/create_index.out 2025-10-31 17:36:29.998076400 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/create_index.out 2025-10-31 17:39:27.531620200 +0000
@@ -1216,6 +1216,7 @@
-- maintenance_work_mem setting and fillfactor:
SET maintenance_work_mem = '1MB';
CREATE INDEX hash_tuplesort_idx ON tenk1 USING hash (stringu1 name_ops) WITH (fillfactor = 10);
+WARNING: spool init
EXPLAIN (COSTS OFF)
SELECT count(*) FROM tenk1 WHERE stringu1 = 'TVAAAA';
QUERY PLAN |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/create_index.out C:/cirrus/build/testrun/recovery/027_s...
--- C:/cirrus/src/test/regress/expected/create_index.out 2025-10-31 17:36:29.998076400 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/create_index.out 2025-10-31 17:42:16.836796700 +000...
@@ -1216,6 +1216,7 @@
-- maintenance_work_mem setting and fillfactor:
SET maintenance_work_mem = '1MB';
CREATE INDEX hash_tuplesort_idx ON tenk1 USING hash (stringu1 name_ops) WITH (fillfactor = 10);
+WARNING: spool init
EXPLAIN (COSTS OFF)
SELECT count(*) FROM tenk1 WHERE stringu1 = 'TVAAAA';
QUERY PLAN
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/hash_index.out C:/cirrus/build/testrun/recovery/027_str...
--- C:/cirrus/src/test/regress/expected/hash_index.out 2025-10-31 17:36:30.032668000 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/hash_index.out 2025-10-31 17:42:30.566768200 +0000
@@ -269,6 +269,7 @@
-- Rebuild the index using a different fillfactor
ALTER INDEX hash_split_index SET (fillfactor = 10);
REINDEX INDEX hash_split_index;
+WARNING: spool init
-- Clean up.
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/create_index.out C:/cirrus/build/testrun/regress/regres...
--- C:/cirrus/src/test/regress/expected/create_index.out 2025-10-31 17:36:29.998076400 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/create_index.out 2025-10-31 17:39:18.016489200 +0000
@@ -1216,6 +1216,7 @@
-- maintenance_work_mem setting and fillfactor:
SET maintenance_work_mem = '1MB';
CREATE INDEX hash_tuplesort_idx ON tenk1 USING hash (stringu1 name_ops) WITH (fillfactor = 10);
+WARNING: spool init
EXPLAIN (COSTS OFF)
SELECT count(*) FROM tenk1 WHERE stringu1 = 'TVAAAA';
QUERY PLAN |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/0...
--- /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out 2025-10-31 17:36:22.399171294 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/create_index.out 2025-10-31 17:38:23.73339...
@@ -1216,6 +1216,7 @@
-- maintenance_work_mem setting and fillfactor:
SET maintenance_work_mem = '1MB';
CREATE INDEX hash_tuplesort_idx ON tenk1 USING hash (stringu1 name_ops) WITH (fillfactor = 10);
+WARNING: spool init
EXPLAIN (COSTS OFF)
SELECT count(*) FROM tenk1 WHERE stringu1 = 'TVAAAA';
QUERY PLAN |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out /tmp/cirrus-ci-build/build/testrun/recovery/027...
--- /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out 2025-10-31 17:36:22.399171294 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/create_index.out 2025-10-31 17:39:45.042...
@@ -1216,6 +1216,7 @@
-- maintenance_work_mem setting and fillfactor:
SET maintenance_work_mem = '1MB';
CREATE INDEX hash_tuplesort_idx ON tenk1 USING hash (stringu1 name_ops) WITH (fillfactor = 10);
+WARNING: spool init
EXPLAIN (COSTS OFF)
SELECT count(*) FROM tenk1 WHERE stringu1 = 'TVAAAA';
QUERY PLAN
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/hash_index.out /tmp/cirrus-ci-build/build/testrun/recovery/027_s...
--- /tmp/cirrus-ci-build/src/test/regress/expected/hash_index.out 2025-10-31 17:36:22.419169819 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/hash_index.out 2025-10-31 17:39:54.27830...
@@ -269,6 +269,7 @@
-- Rebuild the index using a different fillfactor
ALTER INDEX hash_split_index SET (fillfactor = 10);
REINDEX INDEX hash_split_index;
+WARNING: spool init
-- Clean up.
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out /tmp/cirrus-ci-build/build/testrun/regress/regr...
--- /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out 2025-10-31 17:36:22.399171294 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/create_index.out 2025-10-31 17:38:20.737409034 +0000
@@ -1216,6 +1216,7 @@
-- maintenance_work_mem setting and fillfactor:
SET maintenance_work_mem = '1MB';
CREATE INDEX hash_tuplesort_idx ON tenk1 USING hash (stringu1 name_ops) WITH (fillfactor = 10);
+WARNING: spool init
EXPLAIN (COSTS OFF)
SELECT count(*) FROM tenk1 WHERE stringu1 = 'TVAAAA';
QUERY PLAN |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/create_index.out /home/postgres/postgres/build/testrun/pg_upg...
--- /home/postgres/postgres/src/test/regress/expected/create_index.out 2025-10-31 17:36:36.769645173 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/create_index.out 2025-10-31 17:37:51.23...
@@ -1216,6 +1216,7 @@
-- maintenance_work_mem setting and fillfactor:
SET maintenance_work_mem = '1MB';
CREATE INDEX hash_tuplesort_idx ON tenk1 USING hash (stringu1 name_ops) WITH (fillfactor = 10);
+WARNING: spool init
EXPLAIN (COSTS OFF)
SELECT count(*) FROM tenk1 WHERE stringu1 = 'TVAAAA';
QUERY PLAN |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/create_index.out /home/postgres/postgres/build/testrun/recove...
--- /home/postgres/postgres/src/test/regress/expected/create_index.out 2025-10-31 17:36:36.769645173 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/create_index.out 2025-10-31 17:38:21....
@@ -1216,6 +1216,7 @@
-- maintenance_work_mem setting and fillfactor:
SET maintenance_work_mem = '1MB';
CREATE INDEX hash_tuplesort_idx ON tenk1 USING hash (stringu1 name_ops) WITH (fillfactor = 10);
+WARNING: spool init
EXPLAIN (COSTS OFF)
SELECT count(*) FROM tenk1 WHERE stringu1 = 'TVAAAA';
QUERY PLAN
diff -U3 /home/postgres/postgres/src/test/regress/expected/hash_index.out /home/postgres/postgres/build/testrun/recovery...
--- /home/postgres/postgres/src/test/regress/expected/hash_index.out 2025-10-31 17:36:36.822174424 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/hash_index.out 2025-10-31 17:38:34.64...
@@ -269,6 +269,7 @@
-- Rebuild the index using a different fillfactor
ALTER INDEX hash_split_index SET (fillfactor = 10);
REINDEX INDEX hash_split_index;
+WARNING: spool init
-- Clean up.
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/create_index.out /home/postgres/postgres/build/testrun/regres...
--- /home/postgres/postgres/src/test/regress/expected/create_index.out 2025-10-31 17:36:36.769645173 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/create_index.out 2025-10-31 17:37:46.785277404 +0000
@@ -1216,6 +1216,7 @@
-- maintenance_work_mem setting and fillfactor:
SET maintenance_work_mem = '1MB';
CREATE INDEX hash_tuplesort_idx ON tenk1 USING hash (stringu1 name_ops) WITH (fillfactor = 10);
+WARNING: spool init
EXPLAIN (COSTS OFF)
SELECT count(*) FROM tenk1 WHERE stringu1 = 'TVAAAA';
QUERY PLAN |
|
Linux - Debian Bookworm - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_che...
--- /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out 2025-10-31 17:36:22.132186942 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/create_index.out 2025-10-31 17:41:34.221174753 +0000
@@ -1216,6 +1216,7 @@
-- maintenance_work_mem setting and fillfactor:
SET maintenance_work_mem = '1MB';
CREATE INDEX hash_tuplesort_idx ON tenk1 USING hash (stringu1 name_ops) WITH (fillfactor = 10);
+WARNING: spool init
EXPLAIN (COSTS OFF)
SELECT count(*) FROM tenk1 WHERE stringu1 = 'TVAAAA';
QUERY PLAN |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out /tmp/cirrus-ci-build/src/test/recovery/tmp_chec...
--- /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out 2025-10-31 17:36:22.132186942 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/create_index.out 2025-10-31 17:43:20.369047591 +0000
@@ -1216,6 +1216,7 @@
-- maintenance_work_mem setting and fillfactor:
SET maintenance_work_mem = '1MB';
CREATE INDEX hash_tuplesort_idx ON tenk1 USING hash (stringu1 name_ops) WITH (fillfactor = 10);
+WARNING: spool init
EXPLAIN (COSTS OFF)
SELECT count(*) FROM tenk1 WHERE stringu1 = 'TVAAAA';
QUERY PLAN
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/hash_index.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/hash_index.out 2025-10-31 17:36:22.152187310 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/hash_index.out 2025-10-31 17:43:27.621022592 +0000
@@ -269,6 +269,7 @@
-- Rebuild the index using a different fillfactor
ALTER INDEX hash_split_index SET (fillfactor = 10);
REINDEX INDEX hash_split_index;
+WARNING: spool init
-- Clean up.
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out /tmp/cirrus-ci-build/src/test/regress/results/c...
--- /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out 2025-10-31 17:36:22.132186942 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/create_index.out 2025-10-31 17:38:26.736895478 +0000
@@ -1216,6 +1216,7 @@
-- maintenance_work_mem setting and fillfactor:
SET maintenance_work_mem = '1MB';
CREATE INDEX hash_tuplesort_idx ON tenk1 USING hash (stringu1 name_ops) WITH (fillfactor = 10);
+WARNING: spool init
EXPLAIN (COSTS OFF)
SELECT count(*) FROM tenk1 WHERE stringu1 = 'TVAAAA';
QUERY PLAN |
|
OpenBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/create_index.out /home/postgres/postgres/build/testrun/pg_upg...
--- /home/postgres/postgres/src/test/regress/expected/create_index.out Fri Oct 31 17:36:45 2025
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/create_index.out Fri Oct 31 17:38:39 20...
@@ -1216,6 +1216,7 @@
-- maintenance_work_mem setting and fillfactor:
SET maintenance_work_mem = '1MB';
CREATE INDEX hash_tuplesort_idx ON tenk1 USING hash (stringu1 name_ops) WITH (fillfactor = 10);
+WARNING: spool init
EXPLAIN (COSTS OFF)
SELECT count(*) FROM tenk1 WHERE stringu1 = 'TVAAAA';
QUERY PLAN |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/create_index.out /home/postgres/postgres/build/testrun/recove...
--- /home/postgres/postgres/src/test/regress/expected/create_index.out Fri Oct 31 17:36:45 2025
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/create_index.out Fri Oct 31 17:40:08 ...
@@ -1216,6 +1216,7 @@
-- maintenance_work_mem setting and fillfactor:
SET maintenance_work_mem = '1MB';
CREATE INDEX hash_tuplesort_idx ON tenk1 USING hash (stringu1 name_ops) WITH (fillfactor = 10);
+WARNING: spool init
EXPLAIN (COSTS OFF)
SELECT count(*) FROM tenk1 WHERE stringu1 = 'TVAAAA';
QUERY PLAN
diff -U3 /home/postgres/postgres/src/test/regress/expected/hash_index.out /home/postgres/postgres/build/testrun/recovery...
--- /home/postgres/postgres/src/test/regress/expected/hash_index.out Fri Oct 31 17:36:45 2025
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/hash_index.out Fri Oct 31 17:40:33 20...
@@ -269,6 +269,7 @@
-- Rebuild the index using a different fillfactor
ALTER INDEX hash_split_index SET (fillfactor = 10);
REINDEX INDEX hash_split_index;
+WARNING: spool init
-- Clean up.
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/create_index.out /home/postgres/postgres/build/testrun/regres...
--- /home/postgres/postgres/src/test/regress/expected/create_index.out Fri Oct 31 17:36:45 2025
+++ /home/postgres/postgres/build/testrun/regress/regress/results/create_index.out Fri Oct 31 17:38:28 2025
@@ -1216,6 +1216,7 @@
-- maintenance_work_mem setting and fillfactor:
SET maintenance_work_mem = '1MB';
CREATE INDEX hash_tuplesort_idx ON tenk1 USING hash (stringu1 name_ops) WITH (fillfactor = 10);
+WARNING: spool init
EXPLAIN (COSTS OFF)
SELECT count(*) FROM tenk1 WHERE stringu1 = 'TVAAAA';
QUERY PLAN |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/0...
--- /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out 2025-10-31 17:36:19.857054000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/create_index.out 2025-10-31 17:37:40.36672...
@@ -1216,6 +1216,7 @@
-- maintenance_work_mem setting and fillfactor:
SET maintenance_work_mem = '1MB';
CREATE INDEX hash_tuplesort_idx ON tenk1 USING hash (stringu1 name_ops) WITH (fillfactor = 10);
+WARNING: spool init
EXPLAIN (COSTS OFF)
SELECT count(*) FROM tenk1 WHERE stringu1 = 'TVAAAA';
QUERY PLAN |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out /tmp/cirrus-ci-build/build/testrun/recovery/027...
--- /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out 2025-10-31 17:36:19.857054000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/create_index.out 2025-10-31 17:38:46.948...
@@ -1216,6 +1216,7 @@
-- maintenance_work_mem setting and fillfactor:
SET maintenance_work_mem = '1MB';
CREATE INDEX hash_tuplesort_idx ON tenk1 USING hash (stringu1 name_ops) WITH (fillfactor = 10);
+WARNING: spool init
EXPLAIN (COSTS OFF)
SELECT count(*) FROM tenk1 WHERE stringu1 = 'TVAAAA';
QUERY PLAN
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/hash_index.out /tmp/cirrus-ci-build/build/testrun/recovery/027_s...
--- /tmp/cirrus-ci-build/src/test/regress/expected/hash_index.out 2025-10-31 17:36:19.871813000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/hash_index.out 2025-10-31 17:39:08.88014...
@@ -269,6 +269,7 @@
-- Rebuild the index using a different fillfactor
ALTER INDEX hash_split_index SET (fillfactor = 10);
REINDEX INDEX hash_split_index;
+WARNING: spool init
-- Clean up.
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out /tmp/cirrus-ci-build/build/testrun/regress/regr...
--- /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out 2025-10-31 17:36:19.857054000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/create_index.out 2025-10-31 17:37:39.307642000 +0000
@@ -1216,6 +1216,7 @@
-- maintenance_work_mem setting and fillfactor:
SET maintenance_work_mem = '1MB';
CREATE INDEX hash_tuplesort_idx ON tenk1 USING hash (stringu1 name_ops) WITH (fillfactor = 10);
+WARNING: spool init
EXPLAIN (COSTS OFF)
SELECT count(*) FROM tenk1 WHERE stringu1 = 'TVAAAA';
QUERY PLAN |
| 56/6004 |
Reset recovery target parameters in pg_createsubscriber |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out /tmp/cirrus-ci-build/build/testrun/postgres...
--- /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out 2025-10-31 12:28:12.132536000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/postgres_fdw-running/regress/results/postgres_fdw.out 2025-10-31 12:35:12.7892240...
@@ -12696,8 +12696,7 @@
FROM postgres_fdw_get_connections(true);
server_name | closed | remote_backend_pid
-------------+--------+--------------------
- loopback | f | t
-(1 row)
+(0 rows)
-- After terminating the remote backend, since the connection is closed,
-- "closed" should be TRUE, or NULL if the connection status check
@@ -12713,8 +12712,7 @@
FROM postgres_fdw_get_connections(true);
server_name | closed | remote_backend_pid
-------------+--------+--------------------
- loopback | t | t
-(1 row)
+(0 rows)
... |
| 56/6128 |
GIN pageinspect support for entry tree and non-leaf posting tree |
|
Windows - Server 2019, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/modules/brin/expected/summarization-and-inprogress-insertion.out C:/cirr...
--- C:/cirrus/src/test/modules/brin/expected/summarization-and-inprogress-insertion.out 2025-10-29 12:21:19.280608600 +0...
+++ C:/cirrus/build/testrun/brin/isolation/results/summarization-and-inprogress-insertion.out 2025-10-29 12:29:21.312651...
@@ -1,51 +1,4 @@
Parsed test spec with 2 sessions
starting permutation: s2check s1b s2b s1i s2summ s1c s2c s2check
-step s2check: SELECT * FROM brin_page_items(get_raw_page('brinidx', 2), 'brinidx'::regclass);
-itemoffset|blknum|attnum|allnulls|hasnulls|placeholder|empty|value
-----------+------+------+--------+--------+-----------+-----+--------
- 1| 0| 1|f |t |f |f |{1 .. 1}
-(1 row)
-
-step s1b: BEGIN ISOLATION LEVEL REPEATABLE READ;
-step s2b: BEGIN ISOLATION LEVEL REPEATABLE READ; SELECT 1;
-?column?
---------
- 1
-(1 row)
-
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/pageinspect/expected/page.out C:/cirrus/build/testrun/pageinspect/regress...
--- C:/cirrus/contrib/pageinspect/expected/page.out 2025-10-29 12:21:15.342135900 +0000
+++ C:/cirrus/build/testrun/pageinspect/regress/results/page.out 2025-10-29 12:28:58.519934000 +0000
@@ -1,4 +1,5 @@
CREATE EXTENSION pageinspect;
+ERROR: extension "pageinspect" has no installation script nor update path for version "1.14"
-- Use a temp table so that effects of VACUUM are predictable
CREATE TEMP TABLE test1 (a int, b int);
INSERT INTO test1 VALUES (16777217, 131584);
@@ -6,207 +7,177 @@
-- The page contents can vary, so just test that it can be read
-- successfully, but don't keep the output.
SELECT octet_length(get_raw_page('test1', 'main', 0)) AS main_0;
- main_0
---------
- 8192
-(1 row)
-
+ERROR: function get_raw_page(unknown, unknown, integer) does not exist
+LINE 1: SELECT octet_length(get_raw_page('test1', 'main', 0)) AS mai...
... |
|
Windows - Server 2019, MinGW64 - Meson |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/modules/brin/expected/summarization-and-inprogress-insertion.out C:/cirr...
--- C:/cirrus/src/test/modules/brin/expected/summarization-and-inprogress-insertion.out 2025-10-29 12:21:05.893912500 +0...
+++ C:/cirrus/build/testrun/brin/isolation/results/summarization-and-inprogress-insertion.out 2025-10-29 12:32:34.536571...
@@ -1,51 +1,4 @@
Parsed test spec with 2 sessions
starting permutation: s2check s1b s2b s1i s2summ s1c s2c s2check
-step s2check: SELECT * FROM brin_page_items(get_raw_page('brinidx', 2), 'brinidx'::regclass);
-itemoffset|blknum|attnum|allnulls|hasnulls|placeholder|empty|value
-----------+------+------+--------+--------+-----------+-----+--------
- 1| 0| 1|f |t |f |f |{1 .. 1}
-(1 row)
-
-step s1b: BEGIN ISOLATION LEVEL REPEATABLE READ;
-step s2b: BEGIN ISOLATION LEVEL REPEATABLE READ; SELECT 1;
-?column?
---------
- 1
-(1 row)
-
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/pageinspect/expected/page.out C:/cirrus/build/testrun/pageinspect/regress...
--- C:/cirrus/contrib/pageinspect/expected/page.out 2025-10-29 12:21:01.904168500 +0000
+++ C:/cirrus/build/testrun/pageinspect/regress/results/page.out 2025-10-29 12:32:11.045842700 +0000
@@ -1,4 +1,5 @@
CREATE EXTENSION pageinspect;
+ERROR: extension "pageinspect" has no installation script nor update path for version "1.14"
-- Use a temp table so that effects of VACUUM are predictable
CREATE TEMP TABLE test1 (a int, b int);
INSERT INTO test1 VALUES (16777217, 131584);
@@ -6,207 +7,177 @@
-- The page contents can vary, so just test that it can be read
-- successfully, but don't keep the output.
SELECT octet_length(get_raw_page('test1', 'main', 0)) AS main_0;
- main_0
---------
- 8192
-(1 row)
-
+ERROR: function get_raw_page(unknown, unknown, integer) does not exist
+LINE 1: SELECT octet_length(get_raw_page('test1', 'main', 0)) AS mai...
... |
|
macOS - Sonoma - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/modules/brin/expected/summarization-and-inprogress-insertion.out /Users/admin/pgsql...
--- /Users/admin/pgsql/src/test/modules/brin/expected/summarization-and-inprogress-insertion.out 2025-10-29 12:20:11
+++ /Users/admin/pgsql/build/testrun/brin/isolation/results/summarization-and-inprogress-insertion.out 2025-10-29 12:23:...
@@ -1,51 +1,4 @@
Parsed test spec with 2 sessions
starting permutation: s2check s1b s2b s1i s2summ s1c s2c s2check
-step s2check: SELECT * FROM brin_page_items(get_raw_page('brinidx', 2), 'brinidx'::regclass);
-itemoffset|blknum|attnum|allnulls|hasnulls|placeholder|empty|value
-----------+------+------+--------+--------+-----------+-----+--------
- 1| 0| 1|f |t |f |f |{1 .. 1}
-(1 row)
-
-step s1b: BEGIN ISOLATION LEVEL REPEATABLE READ;
-step s2b: BEGIN ISOLATION LEVEL REPEATABLE READ; SELECT 1;
-?column?
---------
- 1
-(1 row)
-
... |
| regress |
diff -U3 /Users/admin/pgsql/contrib/pageinspect/expected/page.out /Users/admin/pgsql/build/testrun/pageinspect/regress/r...
--- /Users/admin/pgsql/contrib/pageinspect/expected/page.out 2025-10-29 12:20:09
+++ /Users/admin/pgsql/build/testrun/pageinspect/regress/results/page.out 2025-10-29 12:23:20
@@ -1,4 +1,5 @@
CREATE EXTENSION pageinspect;
+ERROR: extension "pageinspect" has no installation script nor update path for version "1.14"
-- Use a temp table so that effects of VACUUM are predictable
CREATE TEMP TABLE test1 (a int, b int);
INSERT INTO test1 VALUES (16777217, 131584);
@@ -6,207 +7,177 @@
-- The page contents can vary, so just test that it can be read
-- successfully, but don't keep the output.
SELECT octet_length(get_raw_page('test1', 'main', 0)) AS main_0;
- main_0
---------
- 8192
-(1 row)
-
+ERROR: function get_raw_page(unknown, unknown, integer) does not exist
+LINE 1: SELECT octet_length(get_raw_page('test1', 'main', 0)) AS mai...
... |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/modules/brin/expected/summarization-and-inprogress-insertion.out /tmp/cirrus-ci-b...
--- /tmp/cirrus-ci-build/src/test/modules/brin/expected/summarization-and-inprogress-insertion.out 2025-10-29 12:21:12.3...
+++ /tmp/cirrus-ci-build/build/testrun/brin/isolation/results/summarization-and-inprogress-insertion.out 2025-10-29 12:2...
@@ -1,51 +1,4 @@
Parsed test spec with 2 sessions
starting permutation: s2check s1b s2b s1i s2summ s1c s2c s2check
-step s2check: SELECT * FROM brin_page_items(get_raw_page('brinidx', 2), 'brinidx'::regclass);
-itemoffset|blknum|attnum|allnulls|hasnulls|placeholder|empty|value
-----------+------+------+--------+--------+-----------+-----+--------
- 1| 0| 1|f |t |f |f |{1 .. 1}
-(1 row)
-
-step s1b: BEGIN ISOLATION LEVEL REPEATABLE READ;
-step s2b: BEGIN ISOLATION LEVEL REPEATABLE READ; SELECT 1;
-?column?
---------
- 1
-(1 row)
-
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/pageinspect/expected/page.out /tmp/cirrus-ci-build/build/testrun/pageinspect/regre...
--- /tmp/cirrus-ci-build/contrib/pageinspect/expected/page.out 2025-10-29 12:21:10.528456479 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pageinspect/regress/results/page.out 2025-10-29 12:28:10.424424722 +0000
@@ -1,4 +1,5 @@
CREATE EXTENSION pageinspect;
+ERROR: extension "pageinspect" has no installation script nor update path for version "1.14"
-- Use a temp table so that effects of VACUUM are predictable
CREATE TEMP TABLE test1 (a int, b int);
INSERT INTO test1 VALUES (16777217, 131584);
@@ -6,207 +7,177 @@
-- The page contents can vary, so just test that it can be read
-- successfully, but don't keep the output.
SELECT octet_length(get_raw_page('test1', 'main', 0)) AS main_0;
- main_0
---------
- 8192
-(1 row)
-
+ERROR: function get_raw_page(unknown, unknown, integer) does not exist
+LINE 1: SELECT octet_length(get_raw_page('test1', 'main', 0)) AS mai...
... |
|
OpenBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/modules/brin/expected/summarization-and-inprogress-insertion.out /home/postgre...
--- /home/postgres/postgres/src/test/modules/brin/expected/summarization-and-inprogress-insertion.out Wed Oct 29 12:21:3...
+++ /home/postgres/postgres/build/testrun/brin/isolation/results/summarization-and-inprogress-insertion.out Wed Oct 29 1...
@@ -1,51 +1,4 @@
Parsed test spec with 2 sessions
starting permutation: s2check s1b s2b s1i s2summ s1c s2c s2check
-step s2check: SELECT * FROM brin_page_items(get_raw_page('brinidx', 2), 'brinidx'::regclass);
-itemoffset|blknum|attnum|allnulls|hasnulls|placeholder|empty|value
-----------+------+------+--------+--------+-----------+-----+--------
- 1| 0| 1|f |t |f |f |{1 .. 1}
-(1 row)
-
-step s1b: BEGIN ISOLATION LEVEL REPEATABLE READ;
-step s2b: BEGIN ISOLATION LEVEL REPEATABLE READ; SELECT 1;
-?column?
---------
- 1
-(1 row)
-
... |
| regress |
diff -U3 /home/postgres/postgres/contrib/pageinspect/expected/page.out /home/postgres/postgres/build/testrun/pageinspect...
--- /home/postgres/postgres/contrib/pageinspect/expected/page.out Wed Oct 29 12:21:23 2025
+++ /home/postgres/postgres/build/testrun/pageinspect/regress/results/page.out Wed Oct 29 12:26:33 2025
@@ -1,4 +1,5 @@
CREATE EXTENSION pageinspect;
+ERROR: extension "pageinspect" has no installation script nor update path for version "1.14"
-- Use a temp table so that effects of VACUUM are predictable
CREATE TEMP TABLE test1 (a int, b int);
INSERT INTO test1 VALUES (16777217, 131584);
@@ -6,207 +7,177 @@
-- The page contents can vary, so just test that it can be read
-- successfully, but don't keep the output.
SELECT octet_length(get_raw_page('test1', 'main', 0)) AS main_0;
- main_0
---------
- 8192
-(1 row)
-
+ERROR: function get_raw_page(unknown, unknown, integer) does not exist
+LINE 1: SELECT octet_length(get_raw_page('test1', 'main', 0)) AS mai...
... |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/modules/brin/expected/summarization-and-inprogress-insertion.out /home/postgre...
--- /home/postgres/postgres/src/test/modules/brin/expected/summarization-and-inprogress-insertion.out 2025-10-29 12:21:1...
+++ /home/postgres/postgres/build/testrun/brin/isolation/results/summarization-and-inprogress-insertion.out 2025-10-29 1...
@@ -1,51 +1,4 @@
Parsed test spec with 2 sessions
starting permutation: s2check s1b s2b s1i s2summ s1c s2c s2check
-step s2check: SELECT * FROM brin_page_items(get_raw_page('brinidx', 2), 'brinidx'::regclass);
-itemoffset|blknum|attnum|allnulls|hasnulls|placeholder|empty|value
-----------+------+------+--------+--------+-----------+-----+--------
- 1| 0| 1|f |t |f |f |{1 .. 1}
-(1 row)
-
-step s1b: BEGIN ISOLATION LEVEL REPEATABLE READ;
-step s2b: BEGIN ISOLATION LEVEL REPEATABLE READ; SELECT 1;
-?column?
---------
- 1
-(1 row)
-
... |
| regress |
diff -U3 /home/postgres/postgres/contrib/pageinspect/expected/page.out /home/postgres/postgres/build/testrun/pageinspect...
--- /home/postgres/postgres/contrib/pageinspect/expected/page.out 2025-10-29 12:21:09.077935001 +0000
+++ /home/postgres/postgres/build/testrun/pageinspect/regress/results/page.out 2025-10-29 12:24:25.097233923 +0000
@@ -1,4 +1,5 @@
CREATE EXTENSION pageinspect;
+ERROR: extension "pageinspect" has no installation script nor update path for version "1.14"
-- Use a temp table so that effects of VACUUM are predictable
CREATE TEMP TABLE test1 (a int, b int);
INSERT INTO test1 VALUES (16777217, 131584);
@@ -6,207 +7,177 @@
-- The page contents can vary, so just test that it can be read
-- successfully, but don't keep the output.
SELECT octet_length(get_raw_page('test1', 'main', 0)) AS main_0;
- main_0
---------
- 8192
-(1 row)
-
+ERROR: function get_raw_page(unknown, unknown, integer) does not exist
+LINE 1: SELECT octet_length(get_raw_page('test1', 'main', 0)) AS mai...
... |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/modules/brin/expected/summarization-and-inprogress-insertion.out /tmp/cirrus-ci-b...
--- /tmp/cirrus-ci-build/src/test/modules/brin/expected/summarization-and-inprogress-insertion.out 2025-10-29 12:21:02.7...
+++ /tmp/cirrus-ci-build/build/testrun/brin/isolation/results/summarization-and-inprogress-insertion.out 2025-10-29 12:2...
@@ -1,51 +1,4 @@
Parsed test spec with 2 sessions
starting permutation: s2check s1b s2b s1i s2summ s1c s2c s2check
-step s2check: SELECT * FROM brin_page_items(get_raw_page('brinidx', 2), 'brinidx'::regclass);
-itemoffset|blknum|attnum|allnulls|hasnulls|placeholder|empty|value
-----------+------+------+--------+--------+-----------+-----+--------
- 1| 0| 1|f |t |f |f |{1 .. 1}
-(1 row)
-
-step s1b: BEGIN ISOLATION LEVEL REPEATABLE READ;
-step s2b: BEGIN ISOLATION LEVEL REPEATABLE READ; SELECT 1;
-?column?
---------
- 1
-(1 row)
-
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/pageinspect/expected/page.out /tmp/cirrus-ci-build/build/testrun/pageinspect/regre...
--- /tmp/cirrus-ci-build/contrib/pageinspect/expected/page.out 2025-10-29 12:21:01.330757000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pageinspect/regress/results/page.out 2025-10-29 12:24:28.565783000 +0000
@@ -1,4 +1,5 @@
CREATE EXTENSION pageinspect;
+ERROR: extension "pageinspect" has no installation script nor update path for version "1.14"
-- Use a temp table so that effects of VACUUM are predictable
CREATE TEMP TABLE test1 (a int, b int);
INSERT INTO test1 VALUES (16777217, 131584);
@@ -6,207 +7,177 @@
-- The page contents can vary, so just test that it can be read
-- successfully, but don't keep the output.
SELECT octet_length(get_raw_page('test1', 'main', 0)) AS main_0;
- main_0
---------
- 8192
-(1 row)
-
+ERROR: function get_raw_page(unknown, unknown, integer) does not exist
+LINE 1: SELECT octet_length(get_raw_page('test1', 'main', 0)) AS mai...
... |
| 55/5923 |
Let plan_cache_mode to be a little less strict |
|
Windows - Server 2019, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/plancache.out C:/cirrus/build/testrun/pg_upgrade/002_pg...
--- C:/cirrus/src/test/regress/expected/plancache.out 2025-09-21 14:42:11.892752900 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/plancache.out 2025-09-21 14:46:21.781833200 +0000
@@ -398,3 +398,36 @@
(1 row)
drop table test_mode;
+-- Check the interference between plan_cache_mode and cursor_options
+-- EXPLAIN (COSTS OFF, GENERIC_PLAN)
+SELECT prepare_spi_plan(NULL, NULL, NULL); -- ERROR
+ERROR: query text cannot be null
+SELECT prepare_spi_plan(
+ 'EXPLAIN (COSTS OFF) SELECT * FROM pcachetest WHERE q1 = $1',
+ NULL, 'integer') AS p1 \gset
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = $2',
+ NULL, 'integer', NULL); --ERROR
+ERROR: type name cannot be NULL
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = 3',
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/plancache.out C:/cirrus/build/testrun/recovery/027_stre...
--- C:/cirrus/src/test/regress/expected/plancache.out 2025-09-21 14:42:11.892752900 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/plancache.out 2025-09-21 14:49:04.523467100 +0000
@@ -398,3 +398,36 @@
(1 row)
drop table test_mode;
+-- Check the interference between plan_cache_mode and cursor_options
+-- EXPLAIN (COSTS OFF, GENERIC_PLAN)
+SELECT prepare_spi_plan(NULL, NULL, NULL); -- ERROR
+ERROR: query text cannot be null
+SELECT prepare_spi_plan(
+ 'EXPLAIN (COSTS OFF) SELECT * FROM pcachetest WHERE q1 = $1',
+ NULL, 'integer') AS p1 \gset
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = $2',
+ NULL, 'integer', NULL); --ERROR
+ERROR: type name cannot be NULL
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = 3',
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/plancache.out C:/cirrus/build/testrun/regress/regress/r...
--- C:/cirrus/src/test/regress/expected/plancache.out 2025-09-21 14:42:11.892752900 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/plancache.out 2025-09-21 14:46:16.015723100 +0000
@@ -398,3 +398,36 @@
(1 row)
drop table test_mode;
+-- Check the interference between plan_cache_mode and cursor_options
+-- EXPLAIN (COSTS OFF, GENERIC_PLAN)
+SELECT prepare_spi_plan(NULL, NULL, NULL); -- ERROR
+ERROR: query text cannot be null
+SELECT prepare_spi_plan(
+ 'EXPLAIN (COSTS OFF) SELECT * FROM pcachetest WHERE q1 = $1',
+ NULL, 'integer') AS p1 \gset
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = $2',
+ NULL, 'integer', NULL); --ERROR
+ERROR: type name cannot be NULL
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = 3',
... |
|
Windows - Server 2019, MinGW64 - Meson |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/plancache.out C:/cirrus/build/testrun/pg_upgrade/002_pg...
--- C:/cirrus/src/test/regress/expected/plancache.out 2025-09-21 14:42:19.095412100 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/plancache.out 2025-09-21 14:45:05.939052300 +0000
@@ -398,3 +398,36 @@
(1 row)
drop table test_mode;
+-- Check the interference between plan_cache_mode and cursor_options
+-- EXPLAIN (COSTS OFF, GENERIC_PLAN)
+SELECT prepare_spi_plan(NULL, NULL, NULL); -- ERROR
+ERROR: query text cannot be null
+SELECT prepare_spi_plan(
+ 'EXPLAIN (COSTS OFF) SELECT * FROM pcachetest WHERE q1 = $1',
+ NULL, 'integer') AS p1 \gset
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = $2',
+ NULL, 'integer', NULL); --ERROR
+ERROR: type name cannot be NULL
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = 3',
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/plancache.out C:/cirrus/build/testrun/recovery/027_stre...
--- C:/cirrus/src/test/regress/expected/plancache.out 2025-09-21 14:42:19.095412100 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/plancache.out 2025-09-21 14:47:52.596328300 +0000
@@ -398,3 +398,36 @@
(1 row)
drop table test_mode;
+-- Check the interference between plan_cache_mode and cursor_options
+-- EXPLAIN (COSTS OFF, GENERIC_PLAN)
+SELECT prepare_spi_plan(NULL, NULL, NULL); -- ERROR
+ERROR: query text cannot be null
+SELECT prepare_spi_plan(
+ 'EXPLAIN (COSTS OFF) SELECT * FROM pcachetest WHERE q1 = $1',
+ NULL, 'integer') AS p1 \gset
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = $2',
+ NULL, 'integer', NULL); --ERROR
+ERROR: type name cannot be NULL
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = 3',
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/plancache.out C:/cirrus/build/testrun/regress/regress/r...
--- C:/cirrus/src/test/regress/expected/plancache.out 2025-09-21 14:42:19.095412100 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/plancache.out 2025-09-21 14:45:02.618565300 +0000
@@ -398,3 +398,36 @@
(1 row)
drop table test_mode;
+-- Check the interference between plan_cache_mode and cursor_options
+-- EXPLAIN (COSTS OFF, GENERIC_PLAN)
+SELECT prepare_spi_plan(NULL, NULL, NULL); -- ERROR
+ERROR: query text cannot be null
+SELECT prepare_spi_plan(
+ 'EXPLAIN (COSTS OFF) SELECT * FROM pcachetest WHERE q1 = $1',
+ NULL, 'integer') AS p1 \gset
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = $2',
+ NULL, 'integer', NULL); --ERROR
+ERROR: type name cannot be NULL
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = 3',
... |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/plancache.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/plancache.out 2025-09-21 14:42:08.521558840 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/plancache.out 2025-09-21 14:44:40.13690589...
@@ -398,3 +398,36 @@
(1 row)
drop table test_mode;
+-- Check the interference between plan_cache_mode and cursor_options
+-- EXPLAIN (COSTS OFF, GENERIC_PLAN)
+SELECT prepare_spi_plan(NULL, NULL, NULL); -- ERROR
+ERROR: query text cannot be null
+SELECT prepare_spi_plan(
+ 'EXPLAIN (COSTS OFF) SELECT * FROM pcachetest WHERE q1 = $1',
+ NULL, 'integer') AS p1 \gset
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = $2',
+ NULL, 'integer', NULL); --ERROR
+ERROR: type name cannot be NULL
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = 3',
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/plancache.out /tmp/cirrus-ci-build/build/testrun/recovery/027_st...
--- /tmp/cirrus-ci-build/src/test/regress/expected/plancache.out 2025-09-21 14:42:08.521558840 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/plancache.out 2025-09-21 14:46:02.280856...
@@ -398,3 +398,36 @@
(1 row)
drop table test_mode;
+-- Check the interference between plan_cache_mode and cursor_options
+-- EXPLAIN (COSTS OFF, GENERIC_PLAN)
+SELECT prepare_spi_plan(NULL, NULL, NULL); -- ERROR
+ERROR: query text cannot be null
+SELECT prepare_spi_plan(
+ 'EXPLAIN (COSTS OFF) SELECT * FROM pcachetest WHERE q1 = $1',
+ NULL, 'integer') AS p1 \gset
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = $2',
+ NULL, 'integer', NULL); --ERROR
+ERROR: type name cannot be NULL
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = 3',
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/plancache.out /tmp/cirrus-ci-build/build/testrun/regress/regress...
--- /tmp/cirrus-ci-build/src/test/regress/expected/plancache.out 2025-09-21 14:42:08.521558840 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/plancache.out 2025-09-21 14:44:36.960907676 +0000
@@ -398,3 +398,36 @@
(1 row)
drop table test_mode;
+-- Check the interference between plan_cache_mode and cursor_options
+-- EXPLAIN (COSTS OFF, GENERIC_PLAN)
+SELECT prepare_spi_plan(NULL, NULL, NULL); -- ERROR
+ERROR: query text cannot be null
+SELECT prepare_spi_plan(
+ 'EXPLAIN (COSTS OFF) SELECT * FROM pcachetest WHERE q1 = $1',
+ NULL, 'integer') AS p1 \gset
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = $2',
+ NULL, 'integer', NULL); --ERROR
+ERROR: type name cannot be NULL
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = 3',
... |
|
macOS - Sonoma - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/plancache.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_u...
--- /Users/admin/pgsql/src/test/regress/expected/plancache.out 2025-09-21 14:41:11
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/plancache.out 2025-09-21 14:42:42
@@ -398,3 +398,36 @@
(1 row)
drop table test_mode;
+-- Check the interference between plan_cache_mode and cursor_options
+-- EXPLAIN (COSTS OFF, GENERIC_PLAN)
+SELECT prepare_spi_plan(NULL, NULL, NULL); -- ERROR
+ERROR: query text cannot be null
+SELECT prepare_spi_plan(
+ 'EXPLAIN (COSTS OFF) SELECT * FROM pcachetest WHERE q1 = $1',
+ NULL, 'integer') AS p1 \gset
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = $2',
+ NULL, 'integer', NULL); --ERROR
+ERROR: type name cannot be NULL
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = 3',
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/plancache.out /Users/admin/pgsql/build/testrun/recovery/027_stream...
--- /Users/admin/pgsql/src/test/regress/expected/plancache.out 2025-09-21 14:41:11
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/plancache.out 2025-09-21 14:43:32
@@ -398,3 +398,36 @@
(1 row)
drop table test_mode;
+-- Check the interference between plan_cache_mode and cursor_options
+-- EXPLAIN (COSTS OFF, GENERIC_PLAN)
+SELECT prepare_spi_plan(NULL, NULL, NULL); -- ERROR
+ERROR: query text cannot be null
+SELECT prepare_spi_plan(
+ 'EXPLAIN (COSTS OFF) SELECT * FROM pcachetest WHERE q1 = $1',
+ NULL, 'integer') AS p1 \gset
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = $2',
+ NULL, 'integer', NULL); --ERROR
+ERROR: type name cannot be NULL
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = 3',
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/plancache.out /Users/admin/pgsql/build/testrun/regress/regress/res...
--- /Users/admin/pgsql/src/test/regress/expected/plancache.out 2025-09-21 14:41:11
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/plancache.out 2025-09-21 14:42:45
@@ -398,3 +398,36 @@
(1 row)
drop table test_mode;
+-- Check the interference between plan_cache_mode and cursor_options
+-- EXPLAIN (COSTS OFF, GENERIC_PLAN)
+SELECT prepare_spi_plan(NULL, NULL, NULL); -- ERROR
+ERROR: query text cannot be null
+SELECT prepare_spi_plan(
+ 'EXPLAIN (COSTS OFF) SELECT * FROM pcachetest WHERE q1 = $1',
+ NULL, 'integer') AS p1 \gset
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = $2',
+ NULL, 'integer', NULL); --ERROR
+ERROR: type name cannot be NULL
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = 3',
... |
|
OpenBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/plancache.out /home/postgres/postgres/build/testrun/pg_upgrad...
--- /home/postgres/postgres/src/test/regress/expected/plancache.out Sun Sep 21 14:42:19 2025
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/plancache.out Sun Sep 21 14:45:13 2025
@@ -398,3 +398,36 @@
(1 row)
drop table test_mode;
+-- Check the interference between plan_cache_mode and cursor_options
+-- EXPLAIN (COSTS OFF, GENERIC_PLAN)
+SELECT prepare_spi_plan(NULL, NULL, NULL); -- ERROR
+ERROR: query text cannot be null
+SELECT prepare_spi_plan(
+ 'EXPLAIN (COSTS OFF) SELECT * FROM pcachetest WHERE q1 = $1',
+ NULL, 'integer') AS p1 \gset
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = $2',
+ NULL, 'integer', NULL); --ERROR
+ERROR: type name cannot be NULL
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = 3',
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/plancache.out /home/postgres/postgres/build/testrun/recovery/...
--- /home/postgres/postgres/src/test/regress/expected/plancache.out Sun Sep 21 14:42:19 2025
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/plancache.out Sun Sep 21 14:47:24 202...
@@ -398,3 +398,36 @@
(1 row)
drop table test_mode;
+-- Check the interference between plan_cache_mode and cursor_options
+-- EXPLAIN (COSTS OFF, GENERIC_PLAN)
+SELECT prepare_spi_plan(NULL, NULL, NULL); -- ERROR
+ERROR: query text cannot be null
+SELECT prepare_spi_plan(
+ 'EXPLAIN (COSTS OFF) SELECT * FROM pcachetest WHERE q1 = $1',
+ NULL, 'integer') AS p1 \gset
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = $2',
+ NULL, 'integer', NULL); --ERROR
+ERROR: type name cannot be NULL
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = 3',
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/plancache.out /home/postgres/postgres/build/testrun/regress/r...
--- /home/postgres/postgres/src/test/regress/expected/plancache.out Sun Sep 21 14:42:19 2025
+++ /home/postgres/postgres/build/testrun/regress/regress/results/plancache.out Sun Sep 21 14:45:05 2025
@@ -398,3 +398,36 @@
(1 row)
drop table test_mode;
+-- Check the interference between plan_cache_mode and cursor_options
+-- EXPLAIN (COSTS OFF, GENERIC_PLAN)
+SELECT prepare_spi_plan(NULL, NULL, NULL); -- ERROR
+ERROR: query text cannot be null
+SELECT prepare_spi_plan(
+ 'EXPLAIN (COSTS OFF) SELECT * FROM pcachetest WHERE q1 = $1',
+ NULL, 'integer') AS p1 \gset
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = $2',
+ NULL, 'integer', NULL); --ERROR
+ERROR: type name cannot be NULL
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = 3',
... |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/plancache.out /home/postgres/postgres/build/testrun/pg_upgrad...
--- /home/postgres/postgres/src/test/regress/expected/plancache.out 2025-09-21 14:42:32.514033719 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/plancache.out 2025-09-21 14:44:39.43163...
@@ -398,3 +398,36 @@
(1 row)
drop table test_mode;
+-- Check the interference between plan_cache_mode and cursor_options
+-- EXPLAIN (COSTS OFF, GENERIC_PLAN)
+SELECT prepare_spi_plan(NULL, NULL, NULL); -- ERROR
+ERROR: query text cannot be null
+SELECT prepare_spi_plan(
+ 'EXPLAIN (COSTS OFF) SELECT * FROM pcachetest WHERE q1 = $1',
+ NULL, 'integer') AS p1 \gset
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = $2',
+ NULL, 'integer', NULL); --ERROR
+ERROR: type name cannot be NULL
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = 3',
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/plancache.out /home/postgres/postgres/build/testrun/recovery/...
--- /home/postgres/postgres/src/test/regress/expected/plancache.out 2025-09-21 14:42:32.514033719 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/plancache.out 2025-09-21 14:45:21.700...
@@ -398,3 +398,36 @@
(1 row)
drop table test_mode;
+-- Check the interference between plan_cache_mode and cursor_options
+-- EXPLAIN (COSTS OFF, GENERIC_PLAN)
+SELECT prepare_spi_plan(NULL, NULL, NULL); -- ERROR
+ERROR: query text cannot be null
+SELECT prepare_spi_plan(
+ 'EXPLAIN (COSTS OFF) SELECT * FROM pcachetest WHERE q1 = $1',
+ NULL, 'integer') AS p1 \gset
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = $2',
+ NULL, 'integer', NULL); --ERROR
+ERROR: type name cannot be NULL
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = 3',
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/plancache.out /home/postgres/postgres/build/testrun/regress/r...
--- /home/postgres/postgres/src/test/regress/expected/plancache.out 2025-09-21 14:42:32.514033719 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/plancache.out 2025-09-21 14:44:45.016096313 +0000
@@ -398,3 +398,36 @@
(1 row)
drop table test_mode;
+-- Check the interference between plan_cache_mode and cursor_options
+-- EXPLAIN (COSTS OFF, GENERIC_PLAN)
+SELECT prepare_spi_plan(NULL, NULL, NULL); -- ERROR
+ERROR: query text cannot be null
+SELECT prepare_spi_plan(
+ 'EXPLAIN (COSTS OFF) SELECT * FROM pcachetest WHERE q1 = $1',
+ NULL, 'integer') AS p1 \gset
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = $2',
+ NULL, 'integer', NULL); --ERROR
+ERROR: type name cannot be NULL
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = 3',
... |
|
Linux - Debian Bookworm - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/plancache.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/plancache.out 2025-09-21 14:42:10.438086034 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/plancache.out 2025-09-21 14:48:25.668376845 +0000
@@ -398,3 +398,36 @@
(1 row)
drop table test_mode;
+-- Check the interference between plan_cache_mode and cursor_options
+-- EXPLAIN (COSTS OFF, GENERIC_PLAN)
+SELECT prepare_spi_plan(NULL, NULL, NULL); -- ERROR
+ERROR: query text cannot be null
+SELECT prepare_spi_plan(
+ 'EXPLAIN (COSTS OFF) SELECT * FROM pcachetest WHERE q1 = $1',
+ NULL, 'integer') AS p1 \gset
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = $2',
+ NULL, 'integer', NULL); --ERROR
+ERROR: type name cannot be NULL
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = 3',
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/plancache.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check/r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/plancache.out 2025-09-21 14:42:10.438086034 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/plancache.out 2025-09-21 14:50:10.039842337 +0000
@@ -398,3 +398,36 @@
(1 row)
drop table test_mode;
+-- Check the interference between plan_cache_mode and cursor_options
+-- EXPLAIN (COSTS OFF, GENERIC_PLAN)
+SELECT prepare_spi_plan(NULL, NULL, NULL); -- ERROR
+ERROR: query text cannot be null
+SELECT prepare_spi_plan(
+ 'EXPLAIN (COSTS OFF) SELECT * FROM pcachetest WHERE q1 = $1',
+ NULL, 'integer') AS p1 \gset
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = $2',
+ NULL, 'integer', NULL); --ERROR
+ERROR: type name cannot be NULL
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = 3',
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/plancache.out /tmp/cirrus-ci-build/src/test/regress/results/plan...
--- /tmp/cirrus-ci-build/src/test/regress/expected/plancache.out 2025-09-21 14:42:10.438086034 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/plancache.out 2025-09-21 14:45:34.028107312 +0000
@@ -398,3 +398,36 @@
(1 row)
drop table test_mode;
+-- Check the interference between plan_cache_mode and cursor_options
+-- EXPLAIN (COSTS OFF, GENERIC_PLAN)
+SELECT prepare_spi_plan(NULL, NULL, NULL); -- ERROR
+ERROR: query text cannot be null
+SELECT prepare_spi_plan(
+ 'EXPLAIN (COSTS OFF) SELECT * FROM pcachetest WHERE q1 = $1',
+ NULL, 'integer') AS p1 \gset
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = $2',
+ NULL, 'integer', NULL); --ERROR
+ERROR: type name cannot be NULL
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = 3',
... |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/plancache.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/plancache.out 2025-09-21 14:42:07.689551000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/plancache.out 2025-09-21 14:45:30.76085500...
@@ -398,3 +398,36 @@
(1 row)
drop table test_mode;
+-- Check the interference between plan_cache_mode and cursor_options
+-- EXPLAIN (COSTS OFF, GENERIC_PLAN)
+SELECT prepare_spi_plan(NULL, NULL, NULL); -- ERROR
+ERROR: query text cannot be null
+SELECT prepare_spi_plan(
+ 'EXPLAIN (COSTS OFF) SELECT * FROM pcachetest WHERE q1 = $1',
+ NULL, 'integer') AS p1 \gset
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = $2',
+ NULL, 'integer', NULL); --ERROR
+ERROR: type name cannot be NULL
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = 3',
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/plancache.out /tmp/cirrus-ci-build/build/testrun/recovery/027_st...
--- /tmp/cirrus-ci-build/src/test/regress/expected/plancache.out 2025-09-21 14:42:07.689551000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/plancache.out 2025-09-21 14:46:47.984727...
@@ -398,3 +398,36 @@
(1 row)
drop table test_mode;
+-- Check the interference between plan_cache_mode and cursor_options
+-- EXPLAIN (COSTS OFF, GENERIC_PLAN)
+SELECT prepare_spi_plan(NULL, NULL, NULL); -- ERROR
+ERROR: query text cannot be null
+SELECT prepare_spi_plan(
+ 'EXPLAIN (COSTS OFF) SELECT * FROM pcachetest WHERE q1 = $1',
+ NULL, 'integer') AS p1 \gset
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = $2',
+ NULL, 'integer', NULL); --ERROR
+ERROR: type name cannot be NULL
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = 3',
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/plancache.out /tmp/cirrus-ci-build/build/testrun/regress/regress...
--- /tmp/cirrus-ci-build/src/test/regress/expected/plancache.out 2025-09-21 14:42:07.689551000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/plancache.out 2025-09-21 14:45:42.081847000 +0000
@@ -398,3 +398,36 @@
(1 row)
drop table test_mode;
+-- Check the interference between plan_cache_mode and cursor_options
+-- EXPLAIN (COSTS OFF, GENERIC_PLAN)
+SELECT prepare_spi_plan(NULL, NULL, NULL); -- ERROR
+ERROR: query text cannot be null
+SELECT prepare_spi_plan(
+ 'EXPLAIN (COSTS OFF) SELECT * FROM pcachetest WHERE q1 = $1',
+ NULL, 'integer') AS p1 \gset
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = $2',
+ NULL, 'integer', NULL); --ERROR
+ERROR: type name cannot be NULL
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = 3',
... |
| 55/5892 |
parallel safety of correlated subquery (was: parallel_safe) |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/btree_gist/expected/without_overlaps.out /tmp/cirrus-ci-build/build/testrun/btree_...
--- /tmp/cirrus-ci-build/contrib/btree_gist/expected/without_overlaps.out 2025-09-20 08:51:54.407536498 +0000
+++ /tmp/cirrus-ci-build/build/testrun/btree_gist/regress/results/without_overlaps.out 2025-09-20 08:57:55.595629068 +00...
@@ -9,84 +9,7 @@
CONSTRAINT temporal_rng_pk PRIMARY KEY (id, valid_at WITHOUT OVERLAPS)
);
\d temporal_rng
- Table "public.temporal_rng"
- Column | Type | Collation | Nullable | Default
-----------+-----------+-----------+----------+---------
- id | integer | | not null |
- valid_at | daterange | | not null |
-Indexes:
- "temporal_rng_pk" PRIMARY KEY (id, valid_at WITHOUT OVERLAPS)
-
-SELECT pg_get_constraintdef(oid) FROM pg_constraint WHERE conname = 'temporal_rng_pk';
- pg_get_constraintdef
----------------------------------------------
- PRIMARY KEY (id, valid_at WITHOUT OVERLAPS)
-(1 row)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/earthdistance/expected/earthdistance.out /tmp/cirrus-ci-build/build/testrun/earthd...
--- /tmp/cirrus-ci-build/contrib/earthdistance/expected/earthdistance.out 2025-09-20 08:51:54.427498058 +0000
+++ /tmp/cirrus-ci-build/build/testrun/earthdistance/regress/results/earthdistance.out 2025-09-20 08:57:56.755624067 +00...
@@ -1053,46 +1053,7 @@
drop extension cube cascade;
NOTICE: drop cascades to column f1 of table foo
\d foo
- Table "public.foo"
- Column | Type | Collation | Nullable | Default
---------+---------+-----------+----------+---------
- f2 | integer | | |
-
--- list what's installed
-\dT public.*
- List of data types
- Schema | Name | Description
---------+------+-------------
-(0 rows)
-
-\df public.*
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/bit.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upg...
--- /tmp/cirrus-ci-build/src/test/regress/expected/bit.out 2025-09-20 08:51:56.296273095 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/bit.out 2025-09-20 08:56:36.975911987 +000...
@@ -772,79 +772,7 @@
b4 bit varying(5) DEFAULT B'0101'
);
\d bit_defaults
- Table "public.bit_defaults"
- Column | Type | Collation | Nullable | Default
---------+----------------+-----------+----------+---------------------
- b1 | bit(4) | | | '1001'::"bit"
- b2 | bit(4) | | | '0101'::"bit"
- b3 | bit varying(5) | | | '1001'::bit varying
- b4 | bit varying(5) | | | '0101'::"bit"
-
-INSERT INTO bit_defaults DEFAULT VALUES;
-TABLE bit_defaults;
- b1 | b2 | b3 | b4
-------+------+------+------
- 1001 | 0101 | 1001 | 0101
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out /tmp/cirrus-ci-build/build/testrun/postgres...
--- /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out 2025-09-20 08:51:54.523313549 +0000
+++ /tmp/cirrus-ci-build/build/testrun/postgres_fdw/regress/results/postgres_fdw.out 2025-09-20 08:58:10.599563301 +0000
@@ -397,12314 +397,7 @@
-- subquery
SELECT * FROM ft1 t1 WHERE t1.c3 IN (SELECT c3 FROM ft2 t2 WHERE c1 <= 10) ORDER BY c1;
- c1 | c2 | c3 | c4 | c5 | c6 | c7 | c8
-----+----+-------+------------------------------+--------------------------+----+------------+-----
- 1 | 1 | 00001 | Fri Jan 02 00:00:00 1970 PST | Fri Jan 02 00:00:00 1970 | 1 | 1 | foo
- 2 | 2 | 00002 | Sat Jan 03 00:00:00 1970 PST | Sat Jan 03 00:00:00 1970 | 2 | 2 | foo
- 3 | 3 | 00003 | Sun Jan 04 00:00:00 1970 PST | Sun Jan 04 00:00:00 1970 | 3 | 3 | foo
- 4 | 4 | 00004 | Mon Jan 05 00:00:00 1970 PST | Mon Jan 05 00:00:00 1970 | 4 | 4 | foo
- 5 | 5 | 00005 | Tue Jan 06 00:00:00 1970 PST | Tue Jan 06 00:00:00 1970 | 5 | 5 | foo
- 6 | 6 | 00006 | Wed Jan 07 00:00:00 1970 PST | Wed Jan 07 00:00:00 1970 | 6 | 6 | foo
- 7 | 7 | 00007 | Thu Jan 08 00:00:00 1970 PST | Thu Jan 08 00:00:00 1970 | 7 | 7 | foo
- 8 | 8 | 00008 | Fri Jan 09 00:00:00 1970 PST | Fri Jan 09 00:00:00 1970 | 8 | 8 | foo
- 9 | 9 | 00009 | Sat Jan 10 00:00:00 1970 PST | Sat Jan 10 00:00:00 1970 | 9 | 9 | foo
- 10 | 0 | 00010 | Sun Jan 11 00:00:00 1970 PST | Sun Jan 11 00:00:00 1970 | 0 | 0 | foo
-(10 rows)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/bit.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/bit.out 2025-09-20 08:51:56.296273095 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/bit.out 2025-09-20 08:57:19.655774821 +0...
@@ -772,79 +772,7 @@
b4 bit varying(5) DEFAULT B'0101'
);
\d bit_defaults
- Table "public.bit_defaults"
- Column | Type | Collation | Nullable | Default
---------+----------------+-----------+----------+---------------------
- b1 | bit(4) | | | '1001'::"bit"
- b2 | bit(4) | | | '0101'::"bit"
- b3 | bit varying(5) | | | '1001'::bit varying
- b4 | bit varying(5) | | | '0101'::"bit"
-
-INSERT INTO bit_defaults DEFAULT VALUES;
-TABLE bit_defaults;
- b1 | b2 | b3 | b4
-------+------+------+------
- 1001 | 0101 | 1001 | 0101
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/bit.out /tmp/cirrus-ci-build/build/testrun/regress/regress/resul...
--- /tmp/cirrus-ci-build/src/test/regress/expected/bit.out 2025-09-20 08:51:56.296273095 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/bit.out 2025-09-20 08:56:35.499915684 +0000
@@ -772,79 +772,7 @@
b4 bit varying(5) DEFAULT B'0101'
);
\d bit_defaults
- Table "public.bit_defaults"
- Column | Type | Collation | Nullable | Default
---------+----------------+-----------+----------+---------------------
- b1 | bit(4) | | | '1001'::"bit"
- b2 | bit(4) | | | '0101'::"bit"
- b3 | bit varying(5) | | | '1001'::bit varying
- b4 | bit varying(5) | | | '0101'::"bit"
-
-INSERT INTO bit_defaults DEFAULT VALUES;
-TABLE bit_defaults;
- b1 | b2 | b3 | b4
-------+------+------+------
- 1001 | 0101 | 1001 | 0101
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/seg/expected/partition.out /tmp/cirrus-ci-build/build/testrun/seg/regress/results/...
--- /tmp/cirrus-ci-build/contrib/seg/expected/partition.out 2025-09-20 08:51:54.535290485 +0000
+++ /tmp/cirrus-ci-build/build/testrun/seg/regress/results/partition.out 2025-09-20 08:58:10.459563926 +0000
@@ -24,31 +24,7 @@
create table pt34 partition of pt for values in (3,4);
insert into pt values(4, '-1 .. 1'::seg, 'foo');
\d+ pt
- Partitioned table "public.pt"
- Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
-----------+---------+-----------+----------+---------+----------+--------------+-------------
- category | integer | | | | plain | |
- sdata | seg | | | | plain | |
- tdata | text | | | | extended | |
-Partition key: LIST (category)
-Indexes:
- "pti1" btree ((mydouble(category) + 1))
- "pti2" btree (sdata)
- "pti3" btree (tdata COLLATE mycollation)
-Partitions: pt12 FOR VALUES IN (1, 2),
- pt34 FOR VALUES IN (3, 4)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/test_decoding/expected/ddl.out /tmp/cirrus-ci-build/build/testrun/test_decoding/re...
--- /tmp/cirrus-ci-build/contrib/test_decoding/expected/ddl.out 2025-09-20 08:51:54.551259733 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_decoding/regress/results/ddl.out 2025-09-20 08:58:15.755540209 +0000
@@ -484,374 +484,7 @@
WITH (user_catalog_table = true)
;
\d+ replication_metadata
- Table "public.replication_metadata"
- Column | Type | Collation | Nullable | Default | Storage | Stats target...
-----------+---------+-----------+----------+--------------------------------------------------+----------+-------------...
- id | integer | | not null | nextval('replication_metadata_id_seq'::regclass) | plain | ...
- relation | name | | not null | | plain | ...
- options | text[] | | | | extended | ...
-Indexes:
- "replication_metadata_pkey" PRIMARY KEY, btree (id)
-Not-null constraints:
- "replication_metadata_id_not_null" NOT NULL "id"
- "replication_metadata_relation_not_null" NOT NULL "relation"
-Options: user_catalog_table=true
-
... |
| 55/5357 |
New predefined role pg_manage_extensions |
|
Windows - Server 2019, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/pl/plperl/expected/plperl_setup.out C:/cirrus/build/testrun/plperl/regress/re...
--- C:/cirrus/src/pl/plperl/expected/plperl_setup.out 2025-09-20 06:03:19.784041700 +0000
+++ C:/cirrus/build/testrun/plperl/regress/results/plperl_setup.out 2025-09-20 06:09:43.175939000 +0000
@@ -12,7 +12,7 @@
HINT: Must have CREATE privilege on current database to create this extension.
CREATE EXTENSION plperlu; -- fail
ERROR: permission denied to create extension "plperlu"
-HINT: Must be superuser to create this extension.
+HINT: Must be superuser or member of pg_manage_extensions to create this extension.
RESET ROLE;
DO $$
begin
@@ -24,7 +24,7 @@
CREATE EXTENSION plperl;
CREATE EXTENSION plperlu; -- fail
ERROR: permission denied to create extension "plperlu"
-HINT: Must be superuser to create this extension.
+HINT: Must be superuser or member of pg_manage_extensions to create this extension.
CREATE SCHEMA plperl_setup_scratch;
SET search_path = plperl_setup_scratch;
... |
|
Windows - Server 2019, MinGW64 - Meson |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/pl/plperl/expected/plperl_setup.out C:/cirrus/build/testrun/plperl/regress/re...
--- C:/cirrus/src/pl/plperl/expected/plperl_setup.out 2025-09-20 06:03:22.407587900 +0000
+++ C:/cirrus/build/testrun/plperl/regress/results/plperl_setup.out 2025-09-20 06:10:57.445574200 +0000
@@ -12,7 +12,7 @@
HINT: Must have CREATE privilege on current database to create this extension.
CREATE EXTENSION plperlu; -- fail
ERROR: permission denied to create extension "plperlu"
-HINT: Must be superuser to create this extension.
+HINT: Must be superuser or member of pg_manage_extensions to create this extension.
RESET ROLE;
DO $$
begin
@@ -24,7 +24,7 @@
CREATE EXTENSION plperl;
CREATE EXTENSION plperlu; -- fail
ERROR: permission denied to create extension "plperlu"
-HINT: Must be superuser to create this extension.
+HINT: Must be superuser or member of pg_manage_extensions to create this extension.
CREATE SCHEMA plperl_setup_scratch;
SET search_path = plperl_setup_scratch;
... |
|
macOS - Sonoma - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/pl/plperl/expected/plperl_setup.out /Users/admin/pgsql/build/testrun/plperl/regress/resu...
--- /Users/admin/pgsql/src/pl/plperl/expected/plperl_setup.out 2025-09-20 06:02:11
+++ /Users/admin/pgsql/build/testrun/plperl/regress/results/plperl_setup.out 2025-09-20 06:04:27
@@ -12,7 +12,7 @@
HINT: Must have CREATE privilege on current database to create this extension.
CREATE EXTENSION plperlu; -- fail
ERROR: permission denied to create extension "plperlu"
-HINT: Must be superuser to create this extension.
+HINT: Must be superuser or member of pg_manage_extensions to create this extension.
RESET ROLE;
DO $$
begin
@@ -24,7 +24,7 @@
CREATE EXTENSION plperl;
CREATE EXTENSION plperlu; -- fail
ERROR: permission denied to create extension "plperlu"
-HINT: Must be superuser to create this extension.
+HINT: Must be superuser or member of pg_manage_extensions to create this extension.
CREATE SCHEMA plperl_setup_scratch;
SET search_path = plperl_setup_scratch;
... |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/pl/plperl/expected/plperl_setup.out /tmp/cirrus-ci-build/build/testrun/plperl/regress/...
--- /tmp/cirrus-ci-build/src/pl/plperl/expected/plperl_setup.out 2025-09-20 06:03:11.768527650 +0000
+++ /tmp/cirrus-ci-build/build/testrun/plperl/regress/results/plperl_setup.out 2025-09-20 06:07:15.883225241 +0000
@@ -12,7 +12,7 @@
HINT: Must have CREATE privilege on current database to create this extension.
CREATE EXTENSION plperlu; -- fail
ERROR: permission denied to create extension "plperlu"
-HINT: Must be superuser to create this extension.
+HINT: Must be superuser or member of pg_manage_extensions to create this extension.
RESET ROLE;
DO $$
begin
@@ -24,7 +24,7 @@
CREATE EXTENSION plperl;
CREATE EXTENSION plperlu; -- fail
ERROR: permission denied to create extension "plperlu"
-HINT: Must be superuser to create this extension.
+HINT: Must be superuser or member of pg_manage_extensions to create this extension.
CREATE SCHEMA plperl_setup_scratch;
SET search_path = plperl_setup_scratch;
... |
|
Linux - Debian Bookworm - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/pl/plperl/expected/plperl_setup.out /tmp/cirrus-ci-build/src/pl/plperl/results/plperl_...
--- /tmp/cirrus-ci-build/src/pl/plperl/expected/plperl_setup.out 2025-09-20 06:03:17.154618242 +0000
+++ /tmp/cirrus-ci-build/src/pl/plperl/results/plperl_setup.out 2025-09-20 06:05:09.090593026 +0000
@@ -12,7 +12,7 @@
HINT: Must have CREATE privilege on current database to create this extension.
CREATE EXTENSION plperlu; -- fail
ERROR: permission denied to create extension "plperlu"
-HINT: Must be superuser to create this extension.
+HINT: Must be superuser or member of pg_manage_extensions to create this extension.
RESET ROLE;
DO $$
begin
@@ -24,7 +24,7 @@
CREATE EXTENSION plperl;
CREATE EXTENSION plperlu; -- fail
ERROR: permission denied to create extension "plperlu"
-HINT: Must be superuser to create this extension.
+HINT: Must be superuser or member of pg_manage_extensions to create this extension.
CREATE SCHEMA plperl_setup_scratch;
SET search_path = plperl_setup_scratch;
... |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/pl/plperl/expected/plperl_setup.out /home/postgres/postgres/build/testrun/plperl/re...
--- /home/postgres/postgres/src/pl/plperl/expected/plperl_setup.out 2025-09-20 06:03:35.282482774 +0000
+++ /home/postgres/postgres/build/testrun/plperl/regress/results/plperl_setup.out 2025-09-20 06:05:33.755792815 +0000
@@ -12,7 +12,7 @@
HINT: Must have CREATE privilege on current database to create this extension.
CREATE EXTENSION plperlu; -- fail
ERROR: permission denied to create extension "plperlu"
-HINT: Must be superuser to create this extension.
+HINT: Must be superuser or member of pg_manage_extensions to create this extension.
RESET ROLE;
DO $$
begin
@@ -24,7 +24,7 @@
CREATE EXTENSION plperl;
CREATE EXTENSION plperlu; -- fail
ERROR: permission denied to create extension "plperlu"
-HINT: Must be superuser to create this extension.
+HINT: Must be superuser or member of pg_manage_extensions to create this extension.
CREATE SCHEMA plperl_setup_scratch;
SET search_path = plperl_setup_scratch;
... |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/pl/plperl/expected/plperl_setup.out /tmp/cirrus-ci-build/build/testrun/plperl/regress/...
--- /tmp/cirrus-ci-build/src/pl/plperl/expected/plperl_setup.out 2025-09-20 06:03:13.323919000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/plperl/regress/results/plperl_setup.out 2025-09-20 06:05:26.163662000 +0000
@@ -12,7 +12,7 @@
HINT: Must have CREATE privilege on current database to create this extension.
CREATE EXTENSION plperlu; -- fail
ERROR: permission denied to create extension "plperlu"
-HINT: Must be superuser to create this extension.
+HINT: Must be superuser or member of pg_manage_extensions to create this extension.
RESET ROLE;
DO $$
begin
@@ -24,7 +24,7 @@
CREATE EXTENSION plperl;
CREATE EXTENSION plperlu; -- fail
ERROR: permission denied to create extension "plperlu"
-HINT: Must be superuser to create this extension.
+HINT: Must be superuser or member of pg_manage_extensions to create this extension.
CREATE SCHEMA plperl_setup_scratch;
SET search_path = plperl_setup_scratch;
... |
| 55/5588 |
Improvement of var_eq_non_const() |
|
macOS - Sonoma - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/subselect.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_u...
--- /Users/admin/pgsql/src/test/regress/expected/subselect.out 2025-09-20 02:56:12
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/subselect.out 2025-09-20 02:57:30
@@ -2913,13 +2913,15 @@
EXPLAIN (COSTS OFF)
SELECT * FROM onek, (VALUES('RFAAAA'), ('VJAAAA')) AS v (i)
WHERE onek.stringu1 = v.i;
- QUERY PLAN
--------------------------------------------------------------
+ QUERY PLAN
+-------------------------------------------------------------------
Nested Loop
-> Values Scan on "*VALUES*"
- -> Index Scan using onek_stringu1 on onek
- Index Cond: (stringu1 = ("*VALUES*".column1)::text)
-(4 rows)
+ -> Bitmap Heap Scan on onek
+ Recheck Cond: (stringu1 = ("*VALUES*".column1)::text)
+ -> Bitmap Index Scan on onek_stringu1
+ Index Cond: (stringu1 = ("*VALUES*".column1)::text)
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/subselect.out /Users/admin/pgsql/build/testrun/recovery/027_stream...
--- /Users/admin/pgsql/src/test/regress/expected/subselect.out 2025-09-20 02:56:12
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/subselect.out 2025-09-20 02:58:09
@@ -2913,13 +2913,15 @@
EXPLAIN (COSTS OFF)
SELECT * FROM onek, (VALUES('RFAAAA'), ('VJAAAA')) AS v (i)
WHERE onek.stringu1 = v.i;
- QUERY PLAN
--------------------------------------------------------------
+ QUERY PLAN
+-------------------------------------------------------------------
Nested Loop
-> Values Scan on "*VALUES*"
- -> Index Scan using onek_stringu1 on onek
- Index Cond: (stringu1 = ("*VALUES*".column1)::text)
-(4 rows)
+ -> Bitmap Heap Scan on onek
+ Recheck Cond: (stringu1 = ("*VALUES*".column1)::text)
+ -> Bitmap Index Scan on onek_stringu1
+ Index Cond: (stringu1 = ("*VALUES*".column1)::text)
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/subselect.out /Users/admin/pgsql/build/testrun/regress/regress/res...
--- /Users/admin/pgsql/src/test/regress/expected/subselect.out 2025-09-20 02:56:12
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/subselect.out 2025-09-20 02:57:29
@@ -2913,13 +2913,15 @@
EXPLAIN (COSTS OFF)
SELECT * FROM onek, (VALUES('RFAAAA'), ('VJAAAA')) AS v (i)
WHERE onek.stringu1 = v.i;
- QUERY PLAN
--------------------------------------------------------------
+ QUERY PLAN
+-------------------------------------------------------------------
Nested Loop
-> Values Scan on "*VALUES*"
- -> Index Scan using onek_stringu1 on onek
- Index Cond: (stringu1 = ("*VALUES*".column1)::text)
-(4 rows)
+ -> Bitmap Heap Scan on onek
+ Recheck Cond: (stringu1 = ("*VALUES*".column1)::text)
+ -> Bitmap Index Scan on onek_stringu1
+ Index Cond: (stringu1 = ("*VALUES*".column1)::text)
... |
|
Windows - Server 2019, MinGW64 - Meson |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/subselect.out C:/cirrus/build/testrun/pg_upgrade/002_pg...
--- C:/cirrus/src/test/regress/expected/subselect.out 2025-09-20 02:57:15.518797000 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/subselect.out 2025-09-20 02:59:33.953355500 +0000
@@ -2913,13 +2913,15 @@
EXPLAIN (COSTS OFF)
SELECT * FROM onek, (VALUES('RFAAAA'), ('VJAAAA')) AS v (i)
WHERE onek.stringu1 = v.i;
- QUERY PLAN
--------------------------------------------------------------
+ QUERY PLAN
+-------------------------------------------------------------------
Nested Loop
-> Values Scan on "*VALUES*"
- -> Index Scan using onek_stringu1 on onek
- Index Cond: (stringu1 = ("*VALUES*".column1)::text)
-(4 rows)
+ -> Bitmap Heap Scan on onek
+ Recheck Cond: (stringu1 = ("*VALUES*".column1)::text)
+ -> Bitmap Index Scan on onek_stringu1
+ Index Cond: (stringu1 = ("*VALUES*".column1)::text)
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/subselect.out C:/cirrus/build/testrun/recovery/027_stre...
--- C:/cirrus/src/test/regress/expected/subselect.out 2025-09-20 02:57:15.518797000 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/subselect.out 2025-09-20 03:02:35.616405900 +0000
@@ -2913,13 +2913,15 @@
EXPLAIN (COSTS OFF)
SELECT * FROM onek, (VALUES('RFAAAA'), ('VJAAAA')) AS v (i)
WHERE onek.stringu1 = v.i;
- QUERY PLAN
--------------------------------------------------------------
+ QUERY PLAN
+-------------------------------------------------------------------
Nested Loop
-> Values Scan on "*VALUES*"
- -> Index Scan using onek_stringu1 on onek
- Index Cond: (stringu1 = ("*VALUES*".column1)::text)
-(4 rows)
+ -> Bitmap Heap Scan on onek
+ Recheck Cond: (stringu1 = ("*VALUES*".column1)::text)
+ -> Bitmap Index Scan on onek_stringu1
+ Index Cond: (stringu1 = ("*VALUES*".column1)::text)
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/subselect.out C:/cirrus/build/testrun/regress/regress/r...
--- C:/cirrus/src/test/regress/expected/subselect.out 2025-09-20 02:57:15.518797000 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/subselect.out 2025-09-20 02:59:26.761485800 +0000
@@ -2913,13 +2913,15 @@
EXPLAIN (COSTS OFF)
SELECT * FROM onek, (VALUES('RFAAAA'), ('VJAAAA')) AS v (i)
WHERE onek.stringu1 = v.i;
- QUERY PLAN
--------------------------------------------------------------
+ QUERY PLAN
+-------------------------------------------------------------------
Nested Loop
-> Values Scan on "*VALUES*"
- -> Index Scan using onek_stringu1 on onek
- Index Cond: (stringu1 = ("*VALUES*".column1)::text)
-(4 rows)
+ -> Bitmap Heap Scan on onek
+ Recheck Cond: (stringu1 = ("*VALUES*".column1)::text)
+ -> Bitmap Index Scan on onek_stringu1
+ Index Cond: (stringu1 = ("*VALUES*".column1)::text)
... |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out 2025-09-20 02:57:16.641347994 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/subselect.out 2025-09-20 02:59:03.28685357...
@@ -2913,13 +2913,15 @@
EXPLAIN (COSTS OFF)
SELECT * FROM onek, (VALUES('RFAAAA'), ('VJAAAA')) AS v (i)
WHERE onek.stringu1 = v.i;
- QUERY PLAN
--------------------------------------------------------------
+ QUERY PLAN
+-------------------------------------------------------------------
Nested Loop
-> Values Scan on "*VALUES*"
- -> Index Scan using onek_stringu1 on onek
- Index Cond: (stringu1 = ("*VALUES*".column1)::text)
-(4 rows)
+ -> Bitmap Heap Scan on onek
+ Recheck Cond: (stringu1 = ("*VALUES*".column1)::text)
+ -> Bitmap Index Scan on onek_stringu1
+ Index Cond: (stringu1 = ("*VALUES*".column1)::text)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out /tmp/cirrus-ci-build/build/testrun/recovery/027_st...
--- /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out 2025-09-20 02:57:16.641347994 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/subselect.out 2025-09-20 03:00:22.894639...
@@ -2913,13 +2913,15 @@
EXPLAIN (COSTS OFF)
SELECT * FROM onek, (VALUES('RFAAAA'), ('VJAAAA')) AS v (i)
WHERE onek.stringu1 = v.i;
- QUERY PLAN
--------------------------------------------------------------
+ QUERY PLAN
+-------------------------------------------------------------------
Nested Loop
-> Values Scan on "*VALUES*"
- -> Index Scan using onek_stringu1 on onek
- Index Cond: (stringu1 = ("*VALUES*".column1)::text)
-(4 rows)
+ -> Bitmap Heap Scan on onek
+ Recheck Cond: (stringu1 = ("*VALUES*".column1)::text)
+ -> Bitmap Index Scan on onek_stringu1
+ Index Cond: (stringu1 = ("*VALUES*".column1)::text)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out /tmp/cirrus-ci-build/build/testrun/regress/regress...
--- /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out 2025-09-20 02:57:16.641347994 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/subselect.out 2025-09-20 02:59:00.126844724 +0000
@@ -2913,13 +2913,15 @@
EXPLAIN (COSTS OFF)
SELECT * FROM onek, (VALUES('RFAAAA'), ('VJAAAA')) AS v (i)
WHERE onek.stringu1 = v.i;
- QUERY PLAN
--------------------------------------------------------------
+ QUERY PLAN
+-------------------------------------------------------------------
Nested Loop
-> Values Scan on "*VALUES*"
- -> Index Scan using onek_stringu1 on onek
- Index Cond: (stringu1 = ("*VALUES*".column1)::text)
-(4 rows)
+ -> Bitmap Heap Scan on onek
+ Recheck Cond: (stringu1 = ("*VALUES*".column1)::text)
+ -> Bitmap Index Scan on onek_stringu1
+ Index Cond: (stringu1 = ("*VALUES*".column1)::text)
... |
|
Windows - Server 2019, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/subselect.out C:/cirrus/build/testrun/pg_upgrade/002_pg...
--- C:/cirrus/src/test/regress/expected/subselect.out 2025-09-20 02:57:15.017158800 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/subselect.out 2025-09-20 03:00:11.461488900 +0000
@@ -2913,13 +2913,15 @@
EXPLAIN (COSTS OFF)
SELECT * FROM onek, (VALUES('RFAAAA'), ('VJAAAA')) AS v (i)
WHERE onek.stringu1 = v.i;
- QUERY PLAN
--------------------------------------------------------------
+ QUERY PLAN
+-------------------------------------------------------------------
Nested Loop
-> Values Scan on "*VALUES*"
- -> Index Scan using onek_stringu1 on onek
- Index Cond: (stringu1 = ("*VALUES*".column1)::text)
-(4 rows)
+ -> Bitmap Heap Scan on onek
+ Recheck Cond: (stringu1 = ("*VALUES*".column1)::text)
+ -> Bitmap Index Scan on onek_stringu1
+ Index Cond: (stringu1 = ("*VALUES*".column1)::text)
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/subselect.out C:/cirrus/build/testrun/recovery/027_stre...
--- C:/cirrus/src/test/regress/expected/subselect.out 2025-09-20 02:57:15.017158800 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/subselect.out 2025-09-20 03:03:02.678693500 +0000
@@ -2913,13 +2913,15 @@
EXPLAIN (COSTS OFF)
SELECT * FROM onek, (VALUES('RFAAAA'), ('VJAAAA')) AS v (i)
WHERE onek.stringu1 = v.i;
- QUERY PLAN
--------------------------------------------------------------
+ QUERY PLAN
+-------------------------------------------------------------------
Nested Loop
-> Values Scan on "*VALUES*"
- -> Index Scan using onek_stringu1 on onek
- Index Cond: (stringu1 = ("*VALUES*".column1)::text)
-(4 rows)
+ -> Bitmap Heap Scan on onek
+ Recheck Cond: (stringu1 = ("*VALUES*".column1)::text)
+ -> Bitmap Index Scan on onek_stringu1
+ Index Cond: (stringu1 = ("*VALUES*".column1)::text)
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/subselect.out C:/cirrus/build/testrun/regress/regress/r...
--- C:/cirrus/src/test/regress/expected/subselect.out 2025-09-20 02:57:15.017158800 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/subselect.out 2025-09-20 03:00:05.952216700 +0000
@@ -2913,13 +2913,15 @@
EXPLAIN (COSTS OFF)
SELECT * FROM onek, (VALUES('RFAAAA'), ('VJAAAA')) AS v (i)
WHERE onek.stringu1 = v.i;
- QUERY PLAN
--------------------------------------------------------------
+ QUERY PLAN
+-------------------------------------------------------------------
Nested Loop
-> Values Scan on "*VALUES*"
- -> Index Scan using onek_stringu1 on onek
- Index Cond: (stringu1 = ("*VALUES*".column1)::text)
-(4 rows)
+ -> Bitmap Heap Scan on onek
+ Recheck Cond: (stringu1 = ("*VALUES*".column1)::text)
+ -> Bitmap Index Scan on onek_stringu1
+ Index Cond: (stringu1 = ("*VALUES*".column1)::text)
... |
|
OpenBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/subselect.out /home/postgres/postgres/build/testrun/pg_upgrad...
--- /home/postgres/postgres/src/test/regress/expected/subselect.out Sat Sep 20 02:57:22 2025
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/subselect.out Sat Sep 20 02:59:23 2025
@@ -2913,13 +2913,15 @@
EXPLAIN (COSTS OFF)
SELECT * FROM onek, (VALUES('RFAAAA'), ('VJAAAA')) AS v (i)
WHERE onek.stringu1 = v.i;
- QUERY PLAN
--------------------------------------------------------------
+ QUERY PLAN
+-------------------------------------------------------------------
Nested Loop
-> Values Scan on "*VALUES*"
- -> Index Scan using onek_stringu1 on onek
- Index Cond: (stringu1 = ("*VALUES*".column1)::text)
-(4 rows)
+ -> Bitmap Heap Scan on onek
+ Recheck Cond: (stringu1 = ("*VALUES*".column1)::text)
+ -> Bitmap Index Scan on onek_stringu1
+ Index Cond: (stringu1 = ("*VALUES*".column1)::text)
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/subselect.out /home/postgres/postgres/build/testrun/recovery/...
--- /home/postgres/postgres/src/test/regress/expected/subselect.out Sat Sep 20 02:57:22 2025
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/subselect.out Sat Sep 20 03:01:06 202...
@@ -2913,13 +2913,15 @@
EXPLAIN (COSTS OFF)
SELECT * FROM onek, (VALUES('RFAAAA'), ('VJAAAA')) AS v (i)
WHERE onek.stringu1 = v.i;
- QUERY PLAN
--------------------------------------------------------------
+ QUERY PLAN
+-------------------------------------------------------------------
Nested Loop
-> Values Scan on "*VALUES*"
- -> Index Scan using onek_stringu1 on onek
- Index Cond: (stringu1 = ("*VALUES*".column1)::text)
-(4 rows)
+ -> Bitmap Heap Scan on onek
+ Recheck Cond: (stringu1 = ("*VALUES*".column1)::text)
+ -> Bitmap Index Scan on onek_stringu1
+ Index Cond: (stringu1 = ("*VALUES*".column1)::text)
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/subselect.out /home/postgres/postgres/build/testrun/regress/r...
--- /home/postgres/postgres/src/test/regress/expected/subselect.out Sat Sep 20 02:57:22 2025
+++ /home/postgres/postgres/build/testrun/regress/regress/results/subselect.out Sat Sep 20 02:59:13 2025
@@ -2913,13 +2913,15 @@
EXPLAIN (COSTS OFF)
SELECT * FROM onek, (VALUES('RFAAAA'), ('VJAAAA')) AS v (i)
WHERE onek.stringu1 = v.i;
- QUERY PLAN
--------------------------------------------------------------
+ QUERY PLAN
+-------------------------------------------------------------------
Nested Loop
-> Values Scan on "*VALUES*"
- -> Index Scan using onek_stringu1 on onek
- Index Cond: (stringu1 = ("*VALUES*".column1)::text)
-(4 rows)
+ -> Bitmap Heap Scan on onek
+ Recheck Cond: (stringu1 = ("*VALUES*".column1)::text)
+ -> Bitmap Index Scan on onek_stringu1
+ Index Cond: (stringu1 = ("*VALUES*".column1)::text)
... |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out 2025-09-20 02:57:12.548550000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/subselect.out 2025-09-20 02:58:49.25952500...
@@ -2913,13 +2913,15 @@
EXPLAIN (COSTS OFF)
SELECT * FROM onek, (VALUES('RFAAAA'), ('VJAAAA')) AS v (i)
WHERE onek.stringu1 = v.i;
- QUERY PLAN
--------------------------------------------------------------
+ QUERY PLAN
+-------------------------------------------------------------------
Nested Loop
-> Values Scan on "*VALUES*"
- -> Index Scan using onek_stringu1 on onek
- Index Cond: (stringu1 = ("*VALUES*".column1)::text)
-(4 rows)
+ -> Bitmap Heap Scan on onek
+ Recheck Cond: (stringu1 = ("*VALUES*".column1)::text)
+ -> Bitmap Index Scan on onek_stringu1
+ Index Cond: (stringu1 = ("*VALUES*".column1)::text)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out /tmp/cirrus-ci-build/build/testrun/recovery/027_st...
--- /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out 2025-09-20 02:57:12.548550000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/subselect.out 2025-09-20 02:59:53.073612...
@@ -2913,13 +2913,15 @@
EXPLAIN (COSTS OFF)
SELECT * FROM onek, (VALUES('RFAAAA'), ('VJAAAA')) AS v (i)
WHERE onek.stringu1 = v.i;
- QUERY PLAN
--------------------------------------------------------------
+ QUERY PLAN
+-------------------------------------------------------------------
Nested Loop
-> Values Scan on "*VALUES*"
- -> Index Scan using onek_stringu1 on onek
- Index Cond: (stringu1 = ("*VALUES*".column1)::text)
-(4 rows)
+ -> Bitmap Heap Scan on onek
+ Recheck Cond: (stringu1 = ("*VALUES*".column1)::text)
+ -> Bitmap Index Scan on onek_stringu1
+ Index Cond: (stringu1 = ("*VALUES*".column1)::text)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out /tmp/cirrus-ci-build/build/testrun/regress/regress...
--- /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out 2025-09-20 02:57:12.548550000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/subselect.out 2025-09-20 02:58:46.257080000 +0000
@@ -2913,13 +2913,15 @@
EXPLAIN (COSTS OFF)
SELECT * FROM onek, (VALUES('RFAAAA'), ('VJAAAA')) AS v (i)
WHERE onek.stringu1 = v.i;
- QUERY PLAN
--------------------------------------------------------------
+ QUERY PLAN
+-------------------------------------------------------------------
Nested Loop
-> Values Scan on "*VALUES*"
- -> Index Scan using onek_stringu1 on onek
- Index Cond: (stringu1 = ("*VALUES*".column1)::text)
-(4 rows)
+ -> Bitmap Heap Scan on onek
+ Recheck Cond: (stringu1 = ("*VALUES*".column1)::text)
+ -> Bitmap Index Scan on onek_stringu1
+ Index Cond: (stringu1 = ("*VALUES*".column1)::text)
... |
|
Linux - Debian Bookworm - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out 2025-09-20 02:57:07.331075383 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/subselect.out 2025-09-20 03:01:36.385819009 +0000
@@ -2913,13 +2913,15 @@
EXPLAIN (COSTS OFF)
SELECT * FROM onek, (VALUES('RFAAAA'), ('VJAAAA')) AS v (i)
WHERE onek.stringu1 = v.i;
- QUERY PLAN
--------------------------------------------------------------
+ QUERY PLAN
+-------------------------------------------------------------------
Nested Loop
-> Values Scan on "*VALUES*"
- -> Index Scan using onek_stringu1 on onek
- Index Cond: (stringu1 = ("*VALUES*".column1)::text)
-(4 rows)
+ -> Bitmap Heap Scan on onek
+ Recheck Cond: (stringu1 = ("*VALUES*".column1)::text)
+ -> Bitmap Index Scan on onek_stringu1
+ Index Cond: (stringu1 = ("*VALUES*".column1)::text)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check/r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out 2025-09-20 02:57:07.331075383 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/subselect.out 2025-09-20 03:04:18.499155171 +0000
@@ -2913,13 +2913,15 @@
EXPLAIN (COSTS OFF)
SELECT * FROM onek, (VALUES('RFAAAA'), ('VJAAAA')) AS v (i)
WHERE onek.stringu1 = v.i;
- QUERY PLAN
--------------------------------------------------------------
+ QUERY PLAN
+-------------------------------------------------------------------
Nested Loop
-> Values Scan on "*VALUES*"
- -> Index Scan using onek_stringu1 on onek
- Index Cond: (stringu1 = ("*VALUES*".column1)::text)
-(4 rows)
+ -> Bitmap Heap Scan on onek
+ Recheck Cond: (stringu1 = ("*VALUES*".column1)::text)
+ -> Bitmap Index Scan on onek_stringu1
+ Index Cond: (stringu1 = ("*VALUES*".column1)::text)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out /tmp/cirrus-ci-build/src/test/regress/results/subs...
--- /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out 2025-09-20 02:57:07.331075383 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/subselect.out 2025-09-20 02:59:01.333374161 +0000
@@ -2913,13 +2913,15 @@
EXPLAIN (COSTS OFF)
SELECT * FROM onek, (VALUES('RFAAAA'), ('VJAAAA')) AS v (i)
WHERE onek.stringu1 = v.i;
- QUERY PLAN
--------------------------------------------------------------
+ QUERY PLAN
+-------------------------------------------------------------------
Nested Loop
-> Values Scan on "*VALUES*"
- -> Index Scan using onek_stringu1 on onek
- Index Cond: (stringu1 = ("*VALUES*".column1)::text)
-(4 rows)
+ -> Bitmap Heap Scan on onek
+ Recheck Cond: (stringu1 = ("*VALUES*".column1)::text)
+ -> Bitmap Index Scan on onek_stringu1
+ Index Cond: (stringu1 = ("*VALUES*".column1)::text)
... |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/subselect.out /home/postgres/postgres/build/testrun/pg_upgrad...
--- /home/postgres/postgres/src/test/regress/expected/subselect.out 2025-09-20 02:57:27.411096205 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/subselect.out 2025-09-20 02:58:40.28591...
@@ -2913,13 +2913,15 @@
EXPLAIN (COSTS OFF)
SELECT * FROM onek, (VALUES('RFAAAA'), ('VJAAAA')) AS v (i)
WHERE onek.stringu1 = v.i;
- QUERY PLAN
--------------------------------------------------------------
+ QUERY PLAN
+-------------------------------------------------------------------
Nested Loop
-> Values Scan on "*VALUES*"
- -> Index Scan using onek_stringu1 on onek
- Index Cond: (stringu1 = ("*VALUES*".column1)::text)
-(4 rows)
+ -> Bitmap Heap Scan on onek
+ Recheck Cond: (stringu1 = ("*VALUES*".column1)::text)
+ -> Bitmap Index Scan on onek_stringu1
+ Index Cond: (stringu1 = ("*VALUES*".column1)::text)
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/subselect.out /home/postgres/postgres/build/testrun/recovery/...
--- /home/postgres/postgres/src/test/regress/expected/subselect.out 2025-09-20 02:57:27.411096205 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/subselect.out 2025-09-20 02:59:11.091...
@@ -2913,13 +2913,15 @@
EXPLAIN (COSTS OFF)
SELECT * FROM onek, (VALUES('RFAAAA'), ('VJAAAA')) AS v (i)
WHERE onek.stringu1 = v.i;
- QUERY PLAN
--------------------------------------------------------------
+ QUERY PLAN
+-------------------------------------------------------------------
Nested Loop
-> Values Scan on "*VALUES*"
- -> Index Scan using onek_stringu1 on onek
- Index Cond: (stringu1 = ("*VALUES*".column1)::text)
-(4 rows)
+ -> Bitmap Heap Scan on onek
+ Recheck Cond: (stringu1 = ("*VALUES*".column1)::text)
+ -> Bitmap Index Scan on onek_stringu1
+ Index Cond: (stringu1 = ("*VALUES*".column1)::text)
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/subselect.out /home/postgres/postgres/build/testrun/regress/r...
--- /home/postgres/postgres/src/test/regress/expected/subselect.out 2025-09-20 02:57:27.411096205 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/subselect.out 2025-09-20 02:58:38.010728569 +0000
@@ -2913,13 +2913,15 @@
EXPLAIN (COSTS OFF)
SELECT * FROM onek, (VALUES('RFAAAA'), ('VJAAAA')) AS v (i)
WHERE onek.stringu1 = v.i;
- QUERY PLAN
--------------------------------------------------------------
+ QUERY PLAN
+-------------------------------------------------------------------
Nested Loop
-> Values Scan on "*VALUES*"
- -> Index Scan using onek_stringu1 on onek
- Index Cond: (stringu1 = ("*VALUES*".column1)::text)
-(4 rows)
+ -> Bitmap Heap Scan on onek
+ Recheck Cond: (stringu1 = ("*VALUES*".column1)::text)
+ -> Bitmap Index Scan on onek_stringu1
+ Index Cond: (stringu1 = ("*VALUES*".column1)::text)
... |
| 56/5667 |
support create index on virtual generated column. |
|
macOS - Sonoma - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/generated_virtual.out /Users/admin/pgsql/build/testrun/pg_upgrade/...
--- /Users/admin/pgsql/src/test/regress/expected/generated_virtual.out 2025-09-12 12:57:11
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out 2025-09-12 12:59:39
@@ -768,7 +768,7 @@
ALTER INDEX gtestparted_a_idx ATTACH PARTITION gtestpart2_a_idx; --ok
ALTER INDEX gtestparted_a_idx ATTACH PARTITION gtestpart2_a_idx_copy; --error
ERROR: cannot attach index "gtestpart2_a_idx_copy" as a partition of index "gtestparted_a_idx"
-DETAIL: Another index is already attached for partition "gtestpart2".
+DETAIL: Another index "gtestpart2_a_idx" is already attached for partition "gtestpart2".
CREATE INDEX gtestparted_a_idx_1 on gtestparted(a);
--now index gtestpart2_a_idx_copy should attach to the partition tree.
SELECT * FROM pg_partition_tree('gtestparted_a_idx_1'::regclass); |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/generated_virtual.out /Users/admin/pgsql/build/testrun/recovery/02...
--- /Users/admin/pgsql/src/test/regress/expected/generated_virtual.out 2025-09-12 12:57:11
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out 2025-09-12 13:00:29
@@ -768,7 +768,7 @@
ALTER INDEX gtestparted_a_idx ATTACH PARTITION gtestpart2_a_idx; --ok
ALTER INDEX gtestparted_a_idx ATTACH PARTITION gtestpart2_a_idx_copy; --error
ERROR: cannot attach index "gtestpart2_a_idx_copy" as a partition of index "gtestparted_a_idx"
-DETAIL: Another index is already attached for partition "gtestpart2".
+DETAIL: Another index "gtestpart2_a_idx" is already attached for partition "gtestpart2".
CREATE INDEX gtestparted_a_idx_1 on gtestparted(a);
--now index gtestpart2_a_idx_copy should attach to the partition tree.
SELECT * FROM pg_partition_tree('gtestparted_a_idx_1'::regclass); |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/generated_virtual.out /Users/admin/pgsql/build/testrun/regress/reg...
--- /Users/admin/pgsql/src/test/regress/expected/generated_virtual.out 2025-09-12 12:57:11
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/generated_virtual.out 2025-09-12 12:59:39
@@ -768,7 +768,7 @@
ALTER INDEX gtestparted_a_idx ATTACH PARTITION gtestpart2_a_idx; --ok
ALTER INDEX gtestparted_a_idx ATTACH PARTITION gtestpart2_a_idx_copy; --error
ERROR: cannot attach index "gtestpart2_a_idx_copy" as a partition of index "gtestparted_a_idx"
-DETAIL: Another index is already attached for partition "gtestpart2".
+DETAIL: Another index "gtestpart2_a_idx" is already attached for partition "gtestpart2".
CREATE INDEX gtestparted_a_idx_1 on gtestparted(a);
--now index gtestpart2_a_idx_copy should attach to the partition tree.
SELECT * FROM pg_partition_tree('gtestparted_a_idx_1'::regclass); |
|
Windows - Server 2019, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/generated_virtual.out C:/cirrus/build/testrun/pg_upgrad...
--- C:/cirrus/src/test/regress/expected/generated_virtual.out 2025-09-12 12:58:01.970185800 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out 2025-09-12 13:01:17.872536400 +...
@@ -768,7 +768,7 @@
ALTER INDEX gtestparted_a_idx ATTACH PARTITION gtestpart2_a_idx; --ok
ALTER INDEX gtestparted_a_idx ATTACH PARTITION gtestpart2_a_idx_copy; --error
ERROR: cannot attach index "gtestpart2_a_idx_copy" as a partition of index "gtestparted_a_idx"
-DETAIL: Another index is already attached for partition "gtestpart2".
+DETAIL: Another index "gtestpart2_a_idx" is already attached for partition "gtestpart2".
CREATE INDEX gtestparted_a_idx_1 on gtestparted(a);
--now index gtestpart2_a_idx_copy should attach to the partition tree.
SELECT * FROM pg_partition_tree('gtestparted_a_idx_1'::regclass); |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/generated_virtual.out C:/cirrus/build/testrun/recovery/...
--- C:/cirrus/src/test/regress/expected/generated_virtual.out 2025-09-12 12:58:01.970185800 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out 2025-09-12 13:04:08.253614400...
@@ -768,7 +768,7 @@
ALTER INDEX gtestparted_a_idx ATTACH PARTITION gtestpart2_a_idx; --ok
ALTER INDEX gtestparted_a_idx ATTACH PARTITION gtestpart2_a_idx_copy; --error
ERROR: cannot attach index "gtestpart2_a_idx_copy" as a partition of index "gtestparted_a_idx"
-DETAIL: Another index is already attached for partition "gtestpart2".
+DETAIL: Another index "gtestpart2_a_idx" is already attached for partition "gtestpart2".
CREATE INDEX gtestparted_a_idx_1 on gtestparted(a);
--now index gtestpart2_a_idx_copy should attach to the partition tree.
SELECT * FROM pg_partition_tree('gtestparted_a_idx_1'::regclass); |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/generated_virtual.out C:/cirrus/build/testrun/regress/r...
--- C:/cirrus/src/test/regress/expected/generated_virtual.out 2025-09-12 12:58:01.970185800 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/generated_virtual.out 2025-09-12 13:01:16.165036300 +0000
@@ -768,7 +768,7 @@
ALTER INDEX gtestparted_a_idx ATTACH PARTITION gtestpart2_a_idx; --ok
ALTER INDEX gtestparted_a_idx ATTACH PARTITION gtestpart2_a_idx_copy; --error
ERROR: cannot attach index "gtestpart2_a_idx_copy" as a partition of index "gtestparted_a_idx"
-DETAIL: Another index is already attached for partition "gtestpart2".
+DETAIL: Another index "gtestpart2_a_idx" is already attached for partition "gtestpart2".
CREATE INDEX gtestparted_a_idx_1 on gtestparted(a);
--now index gtestpart2_a_idx_copy should attach to the partition tree.
SELECT * FROM pg_partition_tree('gtestparted_a_idx_1'::regclass); |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out /tmp/cirrus-ci-build/build/testrun/pg_upgr...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out 2025-09-12 12:58:01.003634752 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out 2025-09-12 13:03:48....
@@ -768,7 +768,7 @@
ALTER INDEX gtestparted_a_idx ATTACH PARTITION gtestpart2_a_idx; --ok
ALTER INDEX gtestparted_a_idx ATTACH PARTITION gtestpart2_a_idx_copy; --error
ERROR: cannot attach index "gtestpart2_a_idx_copy" as a partition of index "gtestparted_a_idx"
-DETAIL: Another index is already attached for partition "gtestpart2".
+DETAIL: Another index "gtestpart2_a_idx" is already attached for partition "gtestpart2".
CREATE INDEX gtestparted_a_idx_1 on gtestparted(a);
--now index gtestpart2_a_idx_copy should attach to the partition tree.
SELECT * FROM pg_partition_tree('gtestparted_a_idx_1'::regclass); |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out /tmp/cirrus-ci-build/build/testrun/recover...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out 2025-09-12 12:58:01.003634752 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out 2025-09-12 13:05:1...
@@ -768,7 +768,7 @@
ALTER INDEX gtestparted_a_idx ATTACH PARTITION gtestpart2_a_idx; --ok
ALTER INDEX gtestparted_a_idx ATTACH PARTITION gtestpart2_a_idx_copy; --error
ERROR: cannot attach index "gtestpart2_a_idx_copy" as a partition of index "gtestparted_a_idx"
-DETAIL: Another index is already attached for partition "gtestpart2".
+DETAIL: Another index "gtestpart2_a_idx" is already attached for partition "gtestpart2".
CREATE INDEX gtestparted_a_idx_1 on gtestparted(a);
--now index gtestpart2_a_idx_copy should attach to the partition tree.
SELECT * FROM pg_partition_tree('gtestparted_a_idx_1'::regclass); |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out /tmp/cirrus-ci-build/build/testrun/regress...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out 2025-09-12 12:58:01.003634752 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/generated_virtual.out 2025-09-12 13:03:44.986261035 +0000
@@ -768,7 +768,7 @@
ALTER INDEX gtestparted_a_idx ATTACH PARTITION gtestpart2_a_idx; --ok
ALTER INDEX gtestparted_a_idx ATTACH PARTITION gtestpart2_a_idx_copy; --error
ERROR: cannot attach index "gtestpart2_a_idx_copy" as a partition of index "gtestparted_a_idx"
-DETAIL: Another index is already attached for partition "gtestpart2".
+DETAIL: Another index "gtestpart2_a_idx" is already attached for partition "gtestpart2".
CREATE INDEX gtestparted_a_idx_1 on gtestparted(a);
--now index gtestpart2_a_idx_copy should attach to the partition tree.
SELECT * FROM pg_partition_tree('gtestparted_a_idx_1'::regclass); |
|
Linux - Debian Bookworm - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tm...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out 2025-09-12 12:57:59.028118336 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/generated_virtual.out 2025-09-12 13:05:48.993022110 +0000
@@ -768,7 +768,7 @@
ALTER INDEX gtestparted_a_idx ATTACH PARTITION gtestpart2_a_idx; --ok
ALTER INDEX gtestparted_a_idx ATTACH PARTITION gtestpart2_a_idx_copy; --error
ERROR: cannot attach index "gtestpart2_a_idx_copy" as a partition of index "gtestparted_a_idx"
-DETAIL: Another index is already attached for partition "gtestpart2".
+DETAIL: Another index "gtestpart2_a_idx" is already attached for partition "gtestpart2".
CREATE INDEX gtestparted_a_idx_1 on gtestparted(a);
--now index gtestpart2_a_idx_copy should attach to the partition tree.
SELECT * FROM pg_partition_tree('gtestparted_a_idx_1'::regclass); |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out /tmp/cirrus-ci-build/src/test/regress/resu...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out 2025-09-12 12:57:59.028118336 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/generated_virtual.out 2025-09-12 13:03:24.310484568 +0000
@@ -768,7 +768,7 @@
ALTER INDEX gtestparted_a_idx ATTACH PARTITION gtestpart2_a_idx; --ok
ALTER INDEX gtestparted_a_idx ATTACH PARTITION gtestpart2_a_idx_copy; --error
ERROR: cannot attach index "gtestpart2_a_idx_copy" as a partition of index "gtestparted_a_idx"
-DETAIL: Another index is already attached for partition "gtestpart2".
+DETAIL: Another index "gtestpart2_a_idx" is already attached for partition "gtestpart2".
CREATE INDEX gtestparted_a_idx_1 on gtestparted(a);
--now index gtestpart2_a_idx_copy should attach to the partition tree.
SELECT * FROM pg_partition_tree('gtestparted_a_idx_1'::regclass); |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out /tmp/cirrus-ci-build/build/testrun/pg_upgr...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out 2025-09-12 12:58:00.250333000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out 2025-09-12 13:01:02....
@@ -768,7 +768,7 @@
ALTER INDEX gtestparted_a_idx ATTACH PARTITION gtestpart2_a_idx; --ok
ALTER INDEX gtestparted_a_idx ATTACH PARTITION gtestpart2_a_idx_copy; --error
ERROR: cannot attach index "gtestpart2_a_idx_copy" as a partition of index "gtestparted_a_idx"
-DETAIL: Another index is already attached for partition "gtestpart2".
+DETAIL: Another index "gtestpart2_a_idx" is already attached for partition "gtestpart2".
CREATE INDEX gtestparted_a_idx_1 on gtestparted(a);
--now index gtestpart2_a_idx_copy should attach to the partition tree.
SELECT * FROM pg_partition_tree('gtestparted_a_idx_1'::regclass); |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out /tmp/cirrus-ci-build/build/testrun/recover...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out 2025-09-12 12:58:00.250333000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out 2025-09-12 13:02:2...
@@ -768,7 +768,7 @@
ALTER INDEX gtestparted_a_idx ATTACH PARTITION gtestpart2_a_idx; --ok
ALTER INDEX gtestparted_a_idx ATTACH PARTITION gtestpart2_a_idx_copy; --error
ERROR: cannot attach index "gtestpart2_a_idx_copy" as a partition of index "gtestparted_a_idx"
-DETAIL: Another index is already attached for partition "gtestpart2".
+DETAIL: Another index "gtestpart2_a_idx" is already attached for partition "gtestpart2".
CREATE INDEX gtestparted_a_idx_1 on gtestparted(a);
--now index gtestpart2_a_idx_copy should attach to the partition tree.
SELECT * FROM pg_partition_tree('gtestparted_a_idx_1'::regclass); |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out /tmp/cirrus-ci-build/build/testrun/regress...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out 2025-09-12 12:58:00.250333000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/generated_virtual.out 2025-09-12 13:01:05.017580000 +0000
@@ -768,7 +768,7 @@
ALTER INDEX gtestparted_a_idx ATTACH PARTITION gtestpart2_a_idx; --ok
ALTER INDEX gtestparted_a_idx ATTACH PARTITION gtestpart2_a_idx_copy; --error
ERROR: cannot attach index "gtestpart2_a_idx_copy" as a partition of index "gtestparted_a_idx"
-DETAIL: Another index is already attached for partition "gtestpart2".
+DETAIL: Another index "gtestpart2_a_idx" is already attached for partition "gtestpart2".
CREATE INDEX gtestparted_a_idx_1 on gtestparted(a);
--now index gtestpart2_a_idx_copy should attach to the partition tree.
SELECT * FROM pg_partition_tree('gtestparted_a_idx_1'::regclass); |
| 56/5664 |
Fix slot synchronization with two_phase decoding enabled |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out /tmp/cirrus-ci-build/build/testrun/postgres...
--- /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out 2025-09-01 16:29:06.961562000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/postgres_fdw-running/regress/results/postgres_fdw.out 2025-09-01 16:36:30.6695530...
@@ -12700,8 +12700,7 @@
FROM postgres_fdw_get_connections(true);
server_name | closed | remote_backend_pid
-------------+--------+--------------------
- loopback | t | t
-(1 row)
+(0 rows)
-- Clean up
\set VERBOSITY default |
| 56/5614 |
Leaf and internal block access stats for indexes |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out /tmp/cirrus-ci-build/build/testrun/postgres...
--- /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out 2025-09-01 16:29:06.961562000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/postgres_fdw-running/regress/results/postgres_fdw.out 2025-09-01 16:36:30.6695530...
@@ -12700,8 +12700,7 @@
FROM postgres_fdw_get_connections(true);
server_name | closed | remote_backend_pid
-------------+--------+--------------------
- loopback | t | t
-(1 row)
+(0 rows)
-- Clean up
\set VERBOSITY default |
| 54/5846 |
Introduce New Command Processing Chapter |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out /tmp/cirrus-ci-build/build/testrun/postgres...
--- /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out 2025-09-01 16:29:06.961562000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/postgres_fdw-running/regress/results/postgres_fdw.out 2025-09-01 16:36:30.6695530...
@@ -12700,8 +12700,7 @@
FROM postgres_fdw_get_connections(true);
server_name | closed | remote_backend_pid
-------------+--------+--------------------
- loopback | t | t
-(1 row)
+(0 rows)
-- Clean up
\set VERBOSITY default |
| 56/5725 |
domain over virtual generated column |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out /tmp/cirrus-ci-build/build/testrun/postgres...
--- /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out 2025-09-01 16:29:06.961562000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/postgres_fdw-running/regress/results/postgres_fdw.out 2025-09-01 16:36:30.6695530...
@@ -12700,8 +12700,7 @@
FROM postgres_fdw_get_connections(true);
server_name | closed | remote_backend_pid
-------------+--------+--------------------
- loopback | t | t
-(1 row)
+(0 rows)
-- Clean up
\set VERBOSITY default |
| 55/5893 |
Adding pg_dump flag for parallel export to pipes |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out /tmp/cirrus-ci-build/build/testrun/postgres...
--- /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out 2025-09-01 16:29:06.961562000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/postgres_fdw-running/regress/results/postgres_fdw.out 2025-09-01 16:36:30.6695530...
@@ -12700,8 +12700,7 @@
FROM postgres_fdw_get_connections(true);
server_name | closed | remote_backend_pid
-------------+--------+--------------------
- loopback | t | t
-(1 row)
+(0 rows)
-- Clean up
\set VERBOSITY default |
| 55/5961 |
Proposal: GUC to control starting/stopping logical subscription workers |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out /tmp/cirrus-ci-build/build/testrun/postgres...
--- /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out 2025-09-01 16:29:06.961562000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/postgres_fdw-running/regress/results/postgres_fdw.out 2025-09-01 16:36:30.6695530...
@@ -12700,8 +12700,7 @@
FROM postgres_fdw_get_connections(true);
server_name | closed | remote_backend_pid
-------------+--------+--------------------
- loopback | t | t
-(1 row)
+(0 rows)
-- Clean up
\set VERBOSITY default |
| 55/5965 |
Expose custom planning data in EXPLAIN |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out /tmp/cirrus-ci-build/build/testrun/postgres...
--- /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out 2025-09-01 16:29:06.961562000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/postgres_fdw-running/regress/results/postgres_fdw.out 2025-09-01 16:36:30.6695530...
@@ -12700,8 +12700,7 @@
FROM postgres_fdw_get_connections(true);
server_name | closed | remote_backend_pid
-------------+--------+--------------------
- loopback | t | t
-(1 row)
+(0 rows)
-- Clean up
\set VERBOSITY default |
| 54/5128 |
Allow partition-wise join when whole row var is needed |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out /tmp/cirrus-ci-build/build/testrun/postgres...
--- /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out 2025-09-01 16:29:06.961562000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/postgres_fdw-running/regress/results/postgres_fdw.out 2025-09-01 16:36:30.6695530...
@@ -12700,8 +12700,7 @@
FROM postgres_fdw_get_connections(true);
server_name | closed | remote_backend_pid
-------------+--------+--------------------
- loopback | t | t
-(1 row)
+(0 rows)
-- Clean up
\set VERBOSITY default |
| 56/3405 |
Add pg_stat_session |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out /tmp/cirrus-ci-build/build/testrun/postgres...
--- /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out 2025-09-01 16:29:06.961562000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/postgres_fdw-running/regress/results/postgres_fdw.out 2025-09-01 16:36:30.6695530...
@@ -12700,8 +12700,7 @@
FROM postgres_fdw_get_connections(true);
server_name | closed | remote_backend_pid
-------------+--------+--------------------
- loopback | t | t
-(1 row)
+(0 rows)
-- Clean up
\set VERBOSITY default |
| 56/4904 |
SQL Property Graph Queries (SQL/PGQ) |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out /tmp/cirrus-ci-build/build/testrun/postgres...
--- /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out 2025-09-01 16:29:06.961562000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/postgres_fdw-running/regress/results/postgres_fdw.out 2025-09-01 16:36:30.6695530...
@@ -12700,8 +12700,7 @@
FROM postgres_fdw_get_connections(true);
server_name | closed | remote_backend_pid
-------------+--------+--------------------
- loopback | t | t
-(1 row)
+(0 rows)
-- Clean up
\set VERBOSITY default |
| 56/4884 |
Fix rare recovery shutdown hang |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out /tmp/cirrus-ci-build/build/testrun/postgres...
--- /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out 2025-09-01 16:29:06.961562000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/postgres_fdw-running/regress/results/postgres_fdw.out 2025-09-01 16:36:30.6695530...
@@ -12700,8 +12700,7 @@
FROM postgres_fdw_get_connections(true);
server_name | closed | remote_backend_pid
-------------+--------+--------------------
- loopback | t | t
-(1 row)
+(0 rows)
-- Clean up
\set VERBOSITY default |
| 56/5007 |
relfilenode statistics |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out /tmp/cirrus-ci-build/build/testrun/postgres...
--- /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out 2025-09-01 16:29:06.961562000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/postgres_fdw-running/regress/results/postgres_fdw.out 2025-09-01 16:36:30.6695530...
@@ -12700,8 +12700,7 @@
FROM postgres_fdw_get_connections(true);
server_name | closed | remote_backend_pid
-------------+--------+--------------------
- loopback | t | t
-(1 row)
+(0 rows)
-- Clean up
\set VERBOSITY default |
| 56/4942 |
Avoid orphaned objects dependencies, take 3 |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out /tmp/cirrus-ci-build/build/testrun/postgres...
--- /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out 2025-09-01 16:29:06.961562000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/postgres_fdw-running/regress/results/postgres_fdw.out 2025-09-01 16:36:30.6695530...
@@ -12700,8 +12700,7 @@
FROM postgres_fdw_get_connections(true);
server_name | closed | remote_backend_pid
-------------+--------+--------------------
- loopback | t | t
-(1 row)
+(0 rows)
-- Clean up
\set VERBOSITY default |
| 55/5086 |
Document NULL Concepts and Behaviors |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out /tmp/cirrus-ci-build/build/testrun/postgres...
--- /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out 2025-09-01 16:29:06.961562000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/postgres_fdw-running/regress/results/postgres_fdw.out 2025-09-01 16:36:30.6695530...
@@ -12700,8 +12700,7 @@
FROM postgres_fdw_get_connections(true);
server_name | closed | remote_backend_pid
-------------+--------+--------------------
- loopback | t | t
-(1 row)
+(0 rows)
-- Clean up
\set VERBOSITY default |
| 54/5548 |
Document custom settings more consistently |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out /tmp/cirrus-ci-build/build/testrun/postgres...
--- /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out 2025-09-01 16:29:06.961562000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/postgres_fdw-running/regress/results/postgres_fdw.out 2025-09-01 16:36:30.6695530...
@@ -12700,8 +12700,7 @@
FROM postgres_fdw_get_connections(true);
server_name | closed | remote_backend_pid
-------------+--------+--------------------
- loopback | t | t
-(1 row)
+(0 rows)
-- Clean up
\set VERBOSITY default |
| 56/5303 |
Fix for consume_xids advancing XIDs incorrectly |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out /tmp/cirrus-ci-build/build/testrun/postgres...
--- /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out 2025-09-01 16:29:06.961562000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/postgres_fdw-running/regress/results/postgres_fdw.out 2025-09-01 16:36:30.6695530...
@@ -12700,8 +12700,7 @@
FROM postgres_fdw_get_connections(true);
server_name | closed | remote_backend_pid
-------------+--------+--------------------
- loopback | t | t
-(1 row)
+(0 rows)
-- Clean up
\set VERBOSITY default |
| 55/5595 |
Track and display estimated "work_mem" as well as limit, via EXPLAIN (work_mem on); add hook to override work_mem limits; add extension to override using "workmem.query_work_mem" GUC |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out /tmp/cirrus-ci-build/build/testrun/postgres...
--- /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out 2025-09-01 16:29:06.961562000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/postgres_fdw-running/regress/results/postgres_fdw.out 2025-09-01 16:36:30.6695530...
@@ -12700,8 +12700,7 @@
FROM postgres_fdw_get_connections(true);
server_name | closed | remote_backend_pid
-------------+--------+--------------------
- loopback | t | t
-(1 row)
+(0 rows)
-- Clean up
\set VERBOSITY default |
| 54/5128 |
Allow partition-wise join when whole row var is needed |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/tuplesort.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/tuplesort.out 2025-09-01 12:29:05.463331014 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/tuplesort.out 2025-09-01 12:31:30.30714566...
@@ -223,32 +223,17 @@
BEGIN;
SET LOCAL enable_indexscan = false;
CLUSTER abbrev_abort_uuids USING abbrev_abort_uuids__abort_increasing_idx;
+ERROR: could not read blocks 143..158 in file "base/16387/t66_44575": Operation canceled
-- head
SELECT id, abort_increasing, abort_decreasing, noabort_increasing, noabort_decreasing
FROM abbrev_abort_uuids
ORDER BY ctid LIMIT 5;
- id | abort_increasing | abort_decreasing | noabort_increasing ...
--------+--------------------------------------+--------------------------------------+---------------------------------...
- 1 | 00000000-0000-0000-0000-000000000000 | 00000000-0000-0000-0000-000000020000 | 00000000-0000-0000-0000-00000000...
- 2 | 00000000-0000-0000-0000-000000000001 | 00000000-0000-0000-0000-000000019999 | 00000001-0000-0000-0000-00000000...
- 3 | 00000000-0000-0000-0000-000000000002 | 00000000-0000-0000-0000-000000019998 | 00000002-0000-0000-0000-00000000...
- 20004 | 00000000-0000-0000-0000-000000000002 | 00000000-0000-0000-0000-000000019998 | 00000002-0000-0000-0000-00000000...
- 4 | 00000000-0000-0000-0000-000000000003 | 00000000-0000-0000-0000-000000019997 | 00000003-0000-0000-0000-00000000...
-(5 rows)
... |
| 56/4942 |
Avoid orphaned objects dependencies, take 3 |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/tuplesort.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/tuplesort.out 2025-09-01 12:29:05.463331014 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/tuplesort.out 2025-09-01 12:31:30.30714566...
@@ -223,32 +223,17 @@
BEGIN;
SET LOCAL enable_indexscan = false;
CLUSTER abbrev_abort_uuids USING abbrev_abort_uuids__abort_increasing_idx;
+ERROR: could not read blocks 143..158 in file "base/16387/t66_44575": Operation canceled
-- head
SELECT id, abort_increasing, abort_decreasing, noabort_increasing, noabort_decreasing
FROM abbrev_abort_uuids
ORDER BY ctid LIMIT 5;
- id | abort_increasing | abort_decreasing | noabort_increasing ...
--------+--------------------------------------+--------------------------------------+---------------------------------...
- 1 | 00000000-0000-0000-0000-000000000000 | 00000000-0000-0000-0000-000000020000 | 00000000-0000-0000-0000-00000000...
- 2 | 00000000-0000-0000-0000-000000000001 | 00000000-0000-0000-0000-000000019999 | 00000001-0000-0000-0000-00000000...
- 3 | 00000000-0000-0000-0000-000000000002 | 00000000-0000-0000-0000-000000019998 | 00000002-0000-0000-0000-00000000...
- 20004 | 00000000-0000-0000-0000-000000000002 | 00000000-0000-0000-0000-000000019998 | 00000002-0000-0000-0000-00000000...
- 4 | 00000000-0000-0000-0000-000000000003 | 00000000-0000-0000-0000-000000019997 | 00000003-0000-0000-0000-00000000...
-(5 rows)
... |
| 56/5007 |
relfilenode statistics |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/tuplesort.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/tuplesort.out 2025-09-01 12:29:05.463331014 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/tuplesort.out 2025-09-01 12:31:30.30714566...
@@ -223,32 +223,17 @@
BEGIN;
SET LOCAL enable_indexscan = false;
CLUSTER abbrev_abort_uuids USING abbrev_abort_uuids__abort_increasing_idx;
+ERROR: could not read blocks 143..158 in file "base/16387/t66_44575": Operation canceled
-- head
SELECT id, abort_increasing, abort_decreasing, noabort_increasing, noabort_decreasing
FROM abbrev_abort_uuids
ORDER BY ctid LIMIT 5;
- id | abort_increasing | abort_decreasing | noabort_increasing ...
--------+--------------------------------------+--------------------------------------+---------------------------------...
- 1 | 00000000-0000-0000-0000-000000000000 | 00000000-0000-0000-0000-000000020000 | 00000000-0000-0000-0000-00000000...
- 2 | 00000000-0000-0000-0000-000000000001 | 00000000-0000-0000-0000-000000019999 | 00000001-0000-0000-0000-00000000...
- 3 | 00000000-0000-0000-0000-000000000002 | 00000000-0000-0000-0000-000000019998 | 00000002-0000-0000-0000-00000000...
- 20004 | 00000000-0000-0000-0000-000000000002 | 00000000-0000-0000-0000-000000019998 | 00000002-0000-0000-0000-00000000...
- 4 | 00000000-0000-0000-0000-000000000003 | 00000000-0000-0000-0000-000000019997 | 00000003-0000-0000-0000-00000000...
-(5 rows)
... |
| 55/5086 |
Document NULL Concepts and Behaviors |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/tuplesort.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/tuplesort.out 2025-09-01 12:29:05.463331014 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/tuplesort.out 2025-09-01 12:31:30.30714566...
@@ -223,32 +223,17 @@
BEGIN;
SET LOCAL enable_indexscan = false;
CLUSTER abbrev_abort_uuids USING abbrev_abort_uuids__abort_increasing_idx;
+ERROR: could not read blocks 143..158 in file "base/16387/t66_44575": Operation canceled
-- head
SELECT id, abort_increasing, abort_decreasing, noabort_increasing, noabort_decreasing
FROM abbrev_abort_uuids
ORDER BY ctid LIMIT 5;
- id | abort_increasing | abort_decreasing | noabort_increasing ...
--------+--------------------------------------+--------------------------------------+---------------------------------...
- 1 | 00000000-0000-0000-0000-000000000000 | 00000000-0000-0000-0000-000000020000 | 00000000-0000-0000-0000-00000000...
- 2 | 00000000-0000-0000-0000-000000000001 | 00000000-0000-0000-0000-000000019999 | 00000001-0000-0000-0000-00000000...
- 3 | 00000000-0000-0000-0000-000000000002 | 00000000-0000-0000-0000-000000019998 | 00000002-0000-0000-0000-00000000...
- 20004 | 00000000-0000-0000-0000-000000000002 | 00000000-0000-0000-0000-000000019998 | 00000002-0000-0000-0000-00000000...
- 4 | 00000000-0000-0000-0000-000000000003 | 00000000-0000-0000-0000-000000019997 | 00000003-0000-0000-0000-00000000...
-(5 rows)
... |
| 56/4884 |
Fix rare recovery shutdown hang |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/tuplesort.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/tuplesort.out 2025-09-01 12:29:05.463331014 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/tuplesort.out 2025-09-01 12:31:30.30714566...
@@ -223,32 +223,17 @@
BEGIN;
SET LOCAL enable_indexscan = false;
CLUSTER abbrev_abort_uuids USING abbrev_abort_uuids__abort_increasing_idx;
+ERROR: could not read blocks 143..158 in file "base/16387/t66_44575": Operation canceled
-- head
SELECT id, abort_increasing, abort_decreasing, noabort_increasing, noabort_decreasing
FROM abbrev_abort_uuids
ORDER BY ctid LIMIT 5;
- id | abort_increasing | abort_decreasing | noabort_increasing ...
--------+--------------------------------------+--------------------------------------+---------------------------------...
- 1 | 00000000-0000-0000-0000-000000000000 | 00000000-0000-0000-0000-000000020000 | 00000000-0000-0000-0000-00000000...
- 2 | 00000000-0000-0000-0000-000000000001 | 00000000-0000-0000-0000-000000019999 | 00000001-0000-0000-0000-00000000...
- 3 | 00000000-0000-0000-0000-000000000002 | 00000000-0000-0000-0000-000000019998 | 00000002-0000-0000-0000-00000000...
- 20004 | 00000000-0000-0000-0000-000000000002 | 00000000-0000-0000-0000-000000019998 | 00000002-0000-0000-0000-00000000...
- 4 | 00000000-0000-0000-0000-000000000003 | 00000000-0000-0000-0000-000000019997 | 00000003-0000-0000-0000-00000000...
-(5 rows)
... |
| 56/4904 |
SQL Property Graph Queries (SQL/PGQ) |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/tuplesort.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/tuplesort.out 2025-09-01 12:29:05.463331014 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/tuplesort.out 2025-09-01 12:31:30.30714566...
@@ -223,32 +223,17 @@
BEGIN;
SET LOCAL enable_indexscan = false;
CLUSTER abbrev_abort_uuids USING abbrev_abort_uuids__abort_increasing_idx;
+ERROR: could not read blocks 143..158 in file "base/16387/t66_44575": Operation canceled
-- head
SELECT id, abort_increasing, abort_decreasing, noabort_increasing, noabort_decreasing
FROM abbrev_abort_uuids
ORDER BY ctid LIMIT 5;
- id | abort_increasing | abort_decreasing | noabort_increasing ...
--------+--------------------------------------+--------------------------------------+---------------------------------...
- 1 | 00000000-0000-0000-0000-000000000000 | 00000000-0000-0000-0000-000000020000 | 00000000-0000-0000-0000-00000000...
- 2 | 00000000-0000-0000-0000-000000000001 | 00000000-0000-0000-0000-000000019999 | 00000001-0000-0000-0000-00000000...
- 3 | 00000000-0000-0000-0000-000000000002 | 00000000-0000-0000-0000-000000019998 | 00000002-0000-0000-0000-00000000...
- 20004 | 00000000-0000-0000-0000-000000000002 | 00000000-0000-0000-0000-000000019998 | 00000002-0000-0000-0000-00000000...
- 4 | 00000000-0000-0000-0000-000000000003 | 00000000-0000-0000-0000-000000019997 | 00000003-0000-0000-0000-00000000...
-(5 rows)
... |
| 56/3405 |
Add pg_stat_session |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/tuplesort.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/tuplesort.out 2025-09-01 12:29:05.463331014 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/tuplesort.out 2025-09-01 12:31:30.30714566...
@@ -223,32 +223,17 @@
BEGIN;
SET LOCAL enable_indexscan = false;
CLUSTER abbrev_abort_uuids USING abbrev_abort_uuids__abort_increasing_idx;
+ERROR: could not read blocks 143..158 in file "base/16387/t66_44575": Operation canceled
-- head
SELECT id, abort_increasing, abort_decreasing, noabort_increasing, noabort_decreasing
FROM abbrev_abort_uuids
ORDER BY ctid LIMIT 5;
- id | abort_increasing | abort_decreasing | noabort_increasing ...
--------+--------------------------------------+--------------------------------------+---------------------------------...
- 1 | 00000000-0000-0000-0000-000000000000 | 00000000-0000-0000-0000-000000020000 | 00000000-0000-0000-0000-00000000...
- 2 | 00000000-0000-0000-0000-000000000001 | 00000000-0000-0000-0000-000000019999 | 00000001-0000-0000-0000-00000000...
- 3 | 00000000-0000-0000-0000-000000000002 | 00000000-0000-0000-0000-000000019998 | 00000002-0000-0000-0000-00000000...
- 20004 | 00000000-0000-0000-0000-000000000002 | 00000000-0000-0000-0000-000000019998 | 00000002-0000-0000-0000-00000000...
- 4 | 00000000-0000-0000-0000-000000000003 | 00000000-0000-0000-0000-000000019997 | 00000003-0000-0000-0000-00000000...
-(5 rows)
... |
| 54/5548 |
Document custom settings more consistently |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/tuplesort.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/tuplesort.out 2025-09-01 12:29:05.463331014 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/tuplesort.out 2025-09-01 12:31:30.30714566...
@@ -223,32 +223,17 @@
BEGIN;
SET LOCAL enable_indexscan = false;
CLUSTER abbrev_abort_uuids USING abbrev_abort_uuids__abort_increasing_idx;
+ERROR: could not read blocks 143..158 in file "base/16387/t66_44575": Operation canceled
-- head
SELECT id, abort_increasing, abort_decreasing, noabort_increasing, noabort_decreasing
FROM abbrev_abort_uuids
ORDER BY ctid LIMIT 5;
- id | abort_increasing | abort_decreasing | noabort_increasing ...
--------+--------------------------------------+--------------------------------------+---------------------------------...
- 1 | 00000000-0000-0000-0000-000000000000 | 00000000-0000-0000-0000-000000020000 | 00000000-0000-0000-0000-00000000...
- 2 | 00000000-0000-0000-0000-000000000001 | 00000000-0000-0000-0000-000000019999 | 00000001-0000-0000-0000-00000000...
- 3 | 00000000-0000-0000-0000-000000000002 | 00000000-0000-0000-0000-000000019998 | 00000002-0000-0000-0000-00000000...
- 20004 | 00000000-0000-0000-0000-000000000002 | 00000000-0000-0000-0000-000000019998 | 00000002-0000-0000-0000-00000000...
- 4 | 00000000-0000-0000-0000-000000000003 | 00000000-0000-0000-0000-000000019997 | 00000003-0000-0000-0000-00000000...
-(5 rows)
... |
| 56/5303 |
Fix for consume_xids advancing XIDs incorrectly |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/tuplesort.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/tuplesort.out 2025-09-01 12:29:05.463331014 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/tuplesort.out 2025-09-01 12:31:30.30714566...
@@ -223,32 +223,17 @@
BEGIN;
SET LOCAL enable_indexscan = false;
CLUSTER abbrev_abort_uuids USING abbrev_abort_uuids__abort_increasing_idx;
+ERROR: could not read blocks 143..158 in file "base/16387/t66_44575": Operation canceled
-- head
SELECT id, abort_increasing, abort_decreasing, noabort_increasing, noabort_decreasing
FROM abbrev_abort_uuids
ORDER BY ctid LIMIT 5;
- id | abort_increasing | abort_decreasing | noabort_increasing ...
--------+--------------------------------------+--------------------------------------+---------------------------------...
- 1 | 00000000-0000-0000-0000-000000000000 | 00000000-0000-0000-0000-000000020000 | 00000000-0000-0000-0000-00000000...
- 2 | 00000000-0000-0000-0000-000000000001 | 00000000-0000-0000-0000-000000019999 | 00000001-0000-0000-0000-00000000...
- 3 | 00000000-0000-0000-0000-000000000002 | 00000000-0000-0000-0000-000000019998 | 00000002-0000-0000-0000-00000000...
- 20004 | 00000000-0000-0000-0000-000000000002 | 00000000-0000-0000-0000-000000019998 | 00000002-0000-0000-0000-00000000...
- 4 | 00000000-0000-0000-0000-000000000003 | 00000000-0000-0000-0000-000000019997 | 00000003-0000-0000-0000-00000000...
-(5 rows)
... |
| 55/5595 |
Track and display estimated "work_mem" as well as limit, via EXPLAIN (work_mem on); add hook to override work_mem limits; add extension to override using "workmem.query_work_mem" GUC |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/tuplesort.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/tuplesort.out 2025-09-01 12:29:05.463331014 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/tuplesort.out 2025-09-01 12:31:30.30714566...
@@ -223,32 +223,17 @@
BEGIN;
SET LOCAL enable_indexscan = false;
CLUSTER abbrev_abort_uuids USING abbrev_abort_uuids__abort_increasing_idx;
+ERROR: could not read blocks 143..158 in file "base/16387/t66_44575": Operation canceled
-- head
SELECT id, abort_increasing, abort_decreasing, noabort_increasing, noabort_decreasing
FROM abbrev_abort_uuids
ORDER BY ctid LIMIT 5;
- id | abort_increasing | abort_decreasing | noabort_increasing ...
--------+--------------------------------------+--------------------------------------+---------------------------------...
- 1 | 00000000-0000-0000-0000-000000000000 | 00000000-0000-0000-0000-000000020000 | 00000000-0000-0000-0000-00000000...
- 2 | 00000000-0000-0000-0000-000000000001 | 00000000-0000-0000-0000-000000019999 | 00000001-0000-0000-0000-00000000...
- 3 | 00000000-0000-0000-0000-000000000002 | 00000000-0000-0000-0000-000000019998 | 00000002-0000-0000-0000-00000000...
- 20004 | 00000000-0000-0000-0000-000000000002 | 00000000-0000-0000-0000-000000019998 | 00000002-0000-0000-0000-00000000...
- 4 | 00000000-0000-0000-0000-000000000003 | 00000000-0000-0000-0000-000000019997 | 00000003-0000-0000-0000-00000000...
-(5 rows)
... |
| 56/5664 |
Fix slot synchronization with two_phase decoding enabled |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/tuplesort.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/tuplesort.out 2025-09-01 12:29:05.463331014 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/tuplesort.out 2025-09-01 12:31:30.30714566...
@@ -223,32 +223,17 @@
BEGIN;
SET LOCAL enable_indexscan = false;
CLUSTER abbrev_abort_uuids USING abbrev_abort_uuids__abort_increasing_idx;
+ERROR: could not read blocks 143..158 in file "base/16387/t66_44575": Operation canceled
-- head
SELECT id, abort_increasing, abort_decreasing, noabort_increasing, noabort_decreasing
FROM abbrev_abort_uuids
ORDER BY ctid LIMIT 5;
- id | abort_increasing | abort_decreasing | noabort_increasing ...
--------+--------------------------------------+--------------------------------------+---------------------------------...
- 1 | 00000000-0000-0000-0000-000000000000 | 00000000-0000-0000-0000-000000020000 | 00000000-0000-0000-0000-00000000...
- 2 | 00000000-0000-0000-0000-000000000001 | 00000000-0000-0000-0000-000000019999 | 00000001-0000-0000-0000-00000000...
- 3 | 00000000-0000-0000-0000-000000000002 | 00000000-0000-0000-0000-000000019998 | 00000002-0000-0000-0000-00000000...
- 20004 | 00000000-0000-0000-0000-000000000002 | 00000000-0000-0000-0000-000000019998 | 00000002-0000-0000-0000-00000000...
- 4 | 00000000-0000-0000-0000-000000000003 | 00000000-0000-0000-0000-000000019997 | 00000003-0000-0000-0000-00000000...
-(5 rows)
... |
| 56/5614 |
Leaf and internal block access stats for indexes |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/tuplesort.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/tuplesort.out 2025-09-01 12:29:05.463331014 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/tuplesort.out 2025-09-01 12:31:30.30714566...
@@ -223,32 +223,17 @@
BEGIN;
SET LOCAL enable_indexscan = false;
CLUSTER abbrev_abort_uuids USING abbrev_abort_uuids__abort_increasing_idx;
+ERROR: could not read blocks 143..158 in file "base/16387/t66_44575": Operation canceled
-- head
SELECT id, abort_increasing, abort_decreasing, noabort_increasing, noabort_decreasing
FROM abbrev_abort_uuids
ORDER BY ctid LIMIT 5;
- id | abort_increasing | abort_decreasing | noabort_increasing ...
--------+--------------------------------------+--------------------------------------+---------------------------------...
- 1 | 00000000-0000-0000-0000-000000000000 | 00000000-0000-0000-0000-000000020000 | 00000000-0000-0000-0000-00000000...
- 2 | 00000000-0000-0000-0000-000000000001 | 00000000-0000-0000-0000-000000019999 | 00000001-0000-0000-0000-00000000...
- 3 | 00000000-0000-0000-0000-000000000002 | 00000000-0000-0000-0000-000000019998 | 00000002-0000-0000-0000-00000000...
- 20004 | 00000000-0000-0000-0000-000000000002 | 00000000-0000-0000-0000-000000019998 | 00000002-0000-0000-0000-00000000...
- 4 | 00000000-0000-0000-0000-000000000003 | 00000000-0000-0000-0000-000000019997 | 00000003-0000-0000-0000-00000000...
-(5 rows)
... |
| 54/5846 |
Introduce New Command Processing Chapter |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/tuplesort.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/tuplesort.out 2025-09-01 12:29:05.463331014 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/tuplesort.out 2025-09-01 12:31:30.30714566...
@@ -223,32 +223,17 @@
BEGIN;
SET LOCAL enable_indexscan = false;
CLUSTER abbrev_abort_uuids USING abbrev_abort_uuids__abort_increasing_idx;
+ERROR: could not read blocks 143..158 in file "base/16387/t66_44575": Operation canceled
-- head
SELECT id, abort_increasing, abort_decreasing, noabort_increasing, noabort_decreasing
FROM abbrev_abort_uuids
ORDER BY ctid LIMIT 5;
- id | abort_increasing | abort_decreasing | noabort_increasing ...
--------+--------------------------------------+--------------------------------------+---------------------------------...
- 1 | 00000000-0000-0000-0000-000000000000 | 00000000-0000-0000-0000-000000020000 | 00000000-0000-0000-0000-00000000...
- 2 | 00000000-0000-0000-0000-000000000001 | 00000000-0000-0000-0000-000000019999 | 00000001-0000-0000-0000-00000000...
- 3 | 00000000-0000-0000-0000-000000000002 | 00000000-0000-0000-0000-000000019998 | 00000002-0000-0000-0000-00000000...
- 20004 | 00000000-0000-0000-0000-000000000002 | 00000000-0000-0000-0000-000000019998 | 00000002-0000-0000-0000-00000000...
- 4 | 00000000-0000-0000-0000-000000000003 | 00000000-0000-0000-0000-000000019997 | 00000003-0000-0000-0000-00000000...
-(5 rows)
... |
| 55/5965 |
Expose custom planning data in EXPLAIN |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/tuplesort.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/tuplesort.out 2025-09-01 12:29:05.463331014 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/tuplesort.out 2025-09-01 12:31:30.30714566...
@@ -223,32 +223,17 @@
BEGIN;
SET LOCAL enable_indexscan = false;
CLUSTER abbrev_abort_uuids USING abbrev_abort_uuids__abort_increasing_idx;
+ERROR: could not read blocks 143..158 in file "base/16387/t66_44575": Operation canceled
-- head
SELECT id, abort_increasing, abort_decreasing, noabort_increasing, noabort_decreasing
FROM abbrev_abort_uuids
ORDER BY ctid LIMIT 5;
- id | abort_increasing | abort_decreasing | noabort_increasing ...
--------+--------------------------------------+--------------------------------------+---------------------------------...
- 1 | 00000000-0000-0000-0000-000000000000 | 00000000-0000-0000-0000-000000020000 | 00000000-0000-0000-0000-00000000...
- 2 | 00000000-0000-0000-0000-000000000001 | 00000000-0000-0000-0000-000000019999 | 00000001-0000-0000-0000-00000000...
- 3 | 00000000-0000-0000-0000-000000000002 | 00000000-0000-0000-0000-000000019998 | 00000002-0000-0000-0000-00000000...
- 20004 | 00000000-0000-0000-0000-000000000002 | 00000000-0000-0000-0000-000000019998 | 00000002-0000-0000-0000-00000000...
- 4 | 00000000-0000-0000-0000-000000000003 | 00000000-0000-0000-0000-000000019997 | 00000003-0000-0000-0000-00000000...
-(5 rows)
... |
| 55/5961 |
Proposal: GUC to control starting/stopping logical subscription workers |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/tuplesort.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/tuplesort.out 2025-09-01 12:29:05.463331014 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/tuplesort.out 2025-09-01 12:31:30.30714566...
@@ -223,32 +223,17 @@
BEGIN;
SET LOCAL enable_indexscan = false;
CLUSTER abbrev_abort_uuids USING abbrev_abort_uuids__abort_increasing_idx;
+ERROR: could not read blocks 143..158 in file "base/16387/t66_44575": Operation canceled
-- head
SELECT id, abort_increasing, abort_decreasing, noabort_increasing, noabort_decreasing
FROM abbrev_abort_uuids
ORDER BY ctid LIMIT 5;
- id | abort_increasing | abort_decreasing | noabort_increasing ...
--------+--------------------------------------+--------------------------------------+---------------------------------...
- 1 | 00000000-0000-0000-0000-000000000000 | 00000000-0000-0000-0000-000000020000 | 00000000-0000-0000-0000-00000000...
- 2 | 00000000-0000-0000-0000-000000000001 | 00000000-0000-0000-0000-000000019999 | 00000001-0000-0000-0000-00000000...
- 3 | 00000000-0000-0000-0000-000000000002 | 00000000-0000-0000-0000-000000019998 | 00000002-0000-0000-0000-00000000...
- 20004 | 00000000-0000-0000-0000-000000000002 | 00000000-0000-0000-0000-000000019998 | 00000002-0000-0000-0000-00000000...
- 4 | 00000000-0000-0000-0000-000000000003 | 00000000-0000-0000-0000-000000019997 | 00000003-0000-0000-0000-00000000...
-(5 rows)
... |
| 55/5893 |
Adding pg_dump flag for parallel export to pipes |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/tuplesort.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/tuplesort.out 2025-09-01 12:29:05.463331014 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/tuplesort.out 2025-09-01 12:31:30.30714566...
@@ -223,32 +223,17 @@
BEGIN;
SET LOCAL enable_indexscan = false;
CLUSTER abbrev_abort_uuids USING abbrev_abort_uuids__abort_increasing_idx;
+ERROR: could not read blocks 143..158 in file "base/16387/t66_44575": Operation canceled
-- head
SELECT id, abort_increasing, abort_decreasing, noabort_increasing, noabort_decreasing
FROM abbrev_abort_uuids
ORDER BY ctid LIMIT 5;
- id | abort_increasing | abort_decreasing | noabort_increasing ...
--------+--------------------------------------+--------------------------------------+---------------------------------...
- 1 | 00000000-0000-0000-0000-000000000000 | 00000000-0000-0000-0000-000000020000 | 00000000-0000-0000-0000-00000000...
- 2 | 00000000-0000-0000-0000-000000000001 | 00000000-0000-0000-0000-000000019999 | 00000001-0000-0000-0000-00000000...
- 3 | 00000000-0000-0000-0000-000000000002 | 00000000-0000-0000-0000-000000019998 | 00000002-0000-0000-0000-00000000...
- 20004 | 00000000-0000-0000-0000-000000000002 | 00000000-0000-0000-0000-000000019998 | 00000002-0000-0000-0000-00000000...
- 4 | 00000000-0000-0000-0000-000000000003 | 00000000-0000-0000-0000-000000019997 | 00000003-0000-0000-0000-00000000...
-(5 rows)
... |
| 56/5725 |
domain over virtual generated column |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/tuplesort.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/tuplesort.out 2025-09-01 12:29:05.463331014 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/tuplesort.out 2025-09-01 12:31:30.30714566...
@@ -223,32 +223,17 @@
BEGIN;
SET LOCAL enable_indexscan = false;
CLUSTER abbrev_abort_uuids USING abbrev_abort_uuids__abort_increasing_idx;
+ERROR: could not read blocks 143..158 in file "base/16387/t66_44575": Operation canceled
-- head
SELECT id, abort_increasing, abort_decreasing, noabort_increasing, noabort_decreasing
FROM abbrev_abort_uuids
ORDER BY ctid LIMIT 5;
- id | abort_increasing | abort_decreasing | noabort_increasing ...
--------+--------------------------------------+--------------------------------------+---------------------------------...
- 1 | 00000000-0000-0000-0000-000000000000 | 00000000-0000-0000-0000-000000020000 | 00000000-0000-0000-0000-00000000...
- 2 | 00000000-0000-0000-0000-000000000001 | 00000000-0000-0000-0000-000000019999 | 00000001-0000-0000-0000-00000000...
- 3 | 00000000-0000-0000-0000-000000000002 | 00000000-0000-0000-0000-000000019998 | 00000002-0000-0000-0000-00000000...
- 20004 | 00000000-0000-0000-0000-000000000002 | 00000000-0000-0000-0000-000000019998 | 00000002-0000-0000-0000-00000000...
- 4 | 00000000-0000-0000-0000-000000000003 | 00000000-0000-0000-0000-000000019997 | 00000003-0000-0000-0000-00000000...
-(5 rows)
... |