This robot generates gigabytes of CI logs every week. Here is an attempt to
search for "highlights", so it's easier to find actionable information
quickly. New ideas for what patterns to search for are very welcome.
"Current" shows only the most recent results from each submission. The
wider time ranges also show information about historical versions, which
may be useful for flapping tests, and also for hunting for bugs in master.
| 56/6029 |
NOT NULL NOT ENFORCED |
 |
OpenBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/constraints.out /home/postgres/postgres/build/testrun/pg_upgr...
--- /home/postgres/postgres/src/test/regress/expected/constraints.out Sun Nov 16 18:09:01 2025
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/constraints.out Sun Nov 16 18:11:21 202...
@@ -1031,10 +1031,11 @@
ERROR: conflicting NOT ENFORCED declaration for not-null constraint on column "x"
CREATE TABLE ne_nn_tbl (x int, CONSTRAINT nn NOT NULL x NOT ENFORCED);
SELECT pg_get_constraintdef(oid) FROM pg_constraint WHERE conname = 'nn';
- pg_get_constraintdef
--------------------------
+ pg_get_constraintdef
+-------------------------------------
NOT NULL x NOT ENFORCED
-(1 row)
+ NOT NULL f1 NO INHERIT NOT ENFORCED
+(2 rows)
INSERT INTO ne_nn_tbl VALUES (NULL); --ok
ALTER TABLE ne_nn_tbl ALTER CONSTRAINT nn ENFORCED; --error |
| 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-11-16 17:45:21.373447600 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/create_index.out 2025-11-16 17:48:08.840089200 +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-11-16 17:45:21.373447600 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/create_index.out 2025-11-16 17:50:47.491383400 +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-11-16 17:45:21.405611500 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/hash_index.out 2025-11-16 17:50:54.125165900 +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-11-16 17:45:21.373447600 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/create_index.out 2025-11-16 17:48:05.232675700 +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-11-16 17:45:29.520581500 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/create_index.out 2025-11-16 17:48:27.143083900 +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-11-16 17:45:29.520581500 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/create_index.out 2025-11-16 17:51:12.900329200 +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-11-16 17:45:29.559220900 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/hash_index.out 2025-11-16 17:51:25.830009700 +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-11-16 17:45:29.520581500 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/create_index.out 2025-11-16 17:48:18.430189500 +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 |
|
macOS - Sequoia - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/create_index.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_p...
--- /Users/admin/pgsql/src/test/regress/expected/create_index.out 2025-11-16 17:45:33
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/create_index.out 2025-11-16 17:48:40
@@ -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 /Users/admin/pgsql/src/test/regress/expected/create_index.out /Users/admin/pgsql/build/testrun/recovery/027_str...
--- /Users/admin/pgsql/src/test/regress/expected/create_index.out 2025-11-16 17:45:33
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/create_index.out 2025-11-16 17:49:42
@@ -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 /Users/admin/pgsql/src/test/regress/expected/hash_index.out /Users/admin/pgsql/build/testrun/recovery/027_strea...
--- /Users/admin/pgsql/src/test/regress/expected/hash_index.out 2025-11-16 17:45:33
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/hash_index.out 2025-11-16 17:49:49
@@ -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 /Users/admin/pgsql/src/test/regress/expected/create_index.out /Users/admin/pgsql/build/testrun/regress/regress/...
--- /Users/admin/pgsql/src/test/regress/expected/create_index.out 2025-11-16 17:45:33
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/create_index.out 2025-11-16 17:48:36
@@ -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 Trixie - 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-11-16 17:45:36.312536625 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/create_index.out 2025-11-16 17:47:17.42785...
@@ -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-11-16 17:45:36.312536625 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/create_index.out 2025-11-16 17:48:32.760...
@@ -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-11-16 17:45:36.328462906 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/hash_index.out 2025-11-16 17:48:41.14859...
@@ -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-11-16 17:45:36.312536625 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/create_index.out 2025-11-16 17:47:16.127850734 +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-11-16 17:45:33.869814612 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/create_index.out 2025-11-16 17:46:45.42...
@@ -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-11-16 17:45:33.869814612 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/create_index.out 2025-11-16 17:47: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 2025-11-16 17:45:33.926846244 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/hash_index.out 2025-11-16 17:47:21.05...
@@ -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-11-16 17:45:33.869814612 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/create_index.out 2025-11-16 17:46:41.012094065 +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 |
|
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-11-16 17:45:20.599364000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/create_index.out 2025-11-16 17:46:33.22331...
@@ -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-11-16 17:45:20.599364000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/create_index.out 2025-11-16 17:47:34.522...
@@ -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-11-16 17:45:20.614601000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/hash_index.out 2025-11-16 17:47:53.69505...
@@ -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-11-16 17:45:20.599364000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/create_index.out 2025-11-16 17:46:33.130148000 +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 Trixie - 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-11-16 17:45:18.840767306 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/create_index.out 2025-11-16 17:50:12.675884342 +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-11-16 17:45:18.840767306 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/create_index.out 2025-11-16 17:51:52.073636944 +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-11-16 17:45:18.860836006 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/hash_index.out 2025-11-16 17:52:06.721988643 +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-11-16 17:45:18.840767306 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/create_index.out 2025-11-16 17:47:08.206803767 +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 Sun Nov 16 17:45:56 2025
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/create_index.out Sun Nov 16 17:47:44 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 Sun Nov 16 17:45:56 2025
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/create_index.out Sun Nov 16 17:49:10 ...
@@ -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 Sun Nov 16 17:45:56 2025
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/hash_index.out Sun Nov 16 17:49: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 Sun Nov 16 17:45:56 2025
+++ /home/postgres/postgres/build/testrun/regress/regress/results/create_index.out Sun Nov 16 17:47:33 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 |
| 57/6222 |
enhance wraparound warnings |
|
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-16 14:37:50.568884000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/postgres_fdw-running/regress/results/postgres_fdw.out 2025-11-16 14:45:50.6266380...
@@ -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/6022 |
Use streaming read I/O in BRIN vacuuming |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/cluster.out /home/postgres/postgres/build/testrun/pg_upgrade/...
--- /home/postgres/postgres/src/test/regress/expected/cluster.out 2025-11-16 14:08:40.433821463 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/cluster.out 2025-11-16 14:10:34.6756033...
@@ -1,675 +1 @@
---
--- CLUSTER
---
-CREATE TABLE clstr_tst_s (rf_a SERIAL PRIMARY KEY,
- b INT);
-CREATE TABLE clstr_tst (a SERIAL PRIMARY KEY,
- b INT,
- c TEXT,
- d TEXT,
- CONSTRAINT clstr_tst_con FOREIGN KEY (b) REFERENCES clstr_tst_s);
-CREATE INDEX clstr_tst_b ON clstr_tst (b);
-CREATE INDEX clstr_tst_c ON clstr_tst (c);
-CREATE INDEX clstr_tst_c_b ON clstr_tst (c,b);
-CREATE INDEX clstr_tst_b_c ON clstr_tst (b,c);
-INSERT INTO clstr_tst_s (b) VALUES (0);
-INSERT INTO clstr_tst_s (b) SELECT b FROM clstr_tst_s;
... |
| 56/5319 |
Changing shared_buffers without restart |
|
Linux - Debian Trixie - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/buffermgr/expected/buffer_resize.out /tmp/cirrus-ci-build/build/testrun/buffermgr...
--- /tmp/cirrus-ci-build/src/test/buffermgr/expected/buffer_resize.out 2025-11-16 09:21:13.985495108 +0000
+++ /tmp/cirrus-ci-build/build/testrun/buffermgr/regress/results/buffer_resize.out 2025-11-16 09:28:23.284618305 +0000
@@ -111,219 +111,7 @@
(1 row)
SELECT pg_resize_shared_buffers();
- pg_resize_shared_buffers
---------------------------
- t
-(1 row)
-
-SHOW shared_buffers;
- shared_buffers
-----------------
- 64MB
-(1 row)
-
-SELECT * FROM buffer_allocations;
- name | segment | size | allocated_size
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/pg_buffercache/expected/pg_buffercache_numa.out /tmp/cirrus-ci-build/build/testrun...
--- /tmp/cirrus-ci-build/contrib/pg_buffercache/expected/pg_buffercache_numa.out 2025-11-16 09:21:12.433759896 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_buffercache/regress/results/pg_buffercache_numa.out 2025-11-16 09:28:04.484737...
@@ -7,11 +7,7 @@
from pg_settings
where name = 'shared_buffers')
from pg_buffercache_numa;
- ?column?
-----------
- t
-(1 row)
-
+ERROR: invalid input syntax for type bigint: "128MB"
-- Check that the functions / views can't be accessed by default. To avoid
-- having to create a dedicated user, use the pg_database_owner pseudo-role.
SET ROLE pg_database_owner; |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/numeric.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stre...
--- /tmp/cirrus-ci-build/src/test/regress/expected/numeric.out 2025-11-16 09:21:14.157466052 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/numeric.out 2025-11-16 09:26:50.44142016...
@@ -3757,11 +3757,8 @@
SET LOCAL parallel_setup_cost = 0;
SET LOCAL max_parallel_workers_per_gather = 4;
SELECT trim_scale(variance(a) * 1e1000) FROM num_variance;
- trim_scale
-------------
- 12
-(1 row)
-
+ERROR: failed to initialize shared_buffers to 16384
+CONTEXT: parallel worker
ROLLBACK;
-- case where sum of squares would overflow but variance does not
DELETE FROM num_variance;
@@ -3778,11 +3775,8 @@
SET LOCAL parallel_setup_cost = 0;
SET LOCAL max_parallel_workers_per_gather = 4;
... |
|
Linux - Debian Trixie - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/pg_buffercache/expected/pg_buffercache_numa.out /tmp/cirrus-ci-build/contrib/pg_bu...
--- /tmp/cirrus-ci-build/contrib/pg_buffercache/expected/pg_buffercache_numa.out 2025-11-16 09:21:03.284199318 +0000
+++ /tmp/cirrus-ci-build/contrib/pg_buffercache/results/pg_buffercache_numa.out 2025-11-16 09:27:25.722600818 +0000
@@ -7,11 +7,7 @@
from pg_settings
where name = 'shared_buffers')
from pg_buffercache_numa;
- ?column?
-----------
- t
-(1 row)
-
+ERROR: invalid input syntax for type bigint: "128MB"
-- Check that the functions / views can't be accessed by default. To avoid
-- having to create a dedicated user, use the pg_database_owner pseudo-role.
SET ROLE pg_database_owner; |
| 56/6054 |
let ALTER COLUMN SET DATA TYPE cope with POLICY dependency |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/rowsecurity.out /home/postgres/postgres/build/testrun/regress...
--- /home/postgres/postgres/src/test/regress/expected/rowsecurity.out 2025-11-15 18:18:13.434212945 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/rowsecurity.out 2025-11-15 18:20:57.768434834 +0000
@@ -376,15 +376,15 @@
--------------------+----------+-------+----------------------------------------------+-------------------+------------...
regress_rls_schema | category | table | regress_rls_alice=arwdDxtm/regress_rls_alice+| |
| | | =arwdDxtm/regress_rls_alice | |
- regress_rls_schema | document | table | regress_rls_alice=arwdDxtm/regress_rls_alice+| | p1: ...
- | | | =arwdDxtm/regress_rls_alice | | (u): (dle...
+ regress_rls_schema | document | table | regress_rls_alice=arwdDxtm/regress_rls_alice+| | p1r (RESTRI...
+ | | | =arwdDxtm/regress_rls_alice | | (u): (cid...
+ | | | | | to: regre...
+ | | | | | p1: ...
+ | | | | | (u): (dle...
| | | | | FROM uac...
| | | | | WHERE (ua...
| | | | | p2r (RESTRI...
| | | | | (u): ((ci...
- | | | | | to: regre...
- | | | | | p1r (RESTRI...
... |
| 56/6148 |
CI: Add task that runs pgindent |
|
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-15 02:11:14.623130000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/postgres_fdw-running/regress/results/postgres_fdw.out 2025-11-15 02:18:36.2339900...
@@ -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/5623 |
Make numeric type accessible to third-party code. |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/portals_p2.out /home/postgres/postgres/build/testrun/pg_upgra...
--- /home/postgres/postgres/src/test/regress/expected/portals_p2.out 2025-11-14 23:18:55.127518578 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/portals_p2.out 2025-11-14 23:21:10.6101...
@@ -1,122 +1 @@
---
--- PORTALS_P2
---
-BEGIN;
-DECLARE foo13 CURSOR FOR
- SELECT * FROM onek WHERE unique1 = 50;
-DECLARE foo14 CURSOR FOR
- SELECT * FROM onek WHERE unique1 = 51;
-DECLARE foo15 CURSOR FOR
- SELECT * FROM onek WHERE unique1 = 52;
-DECLARE foo16 CURSOR FOR
- SELECT * FROM onek WHERE unique1 = 53;
-DECLARE foo17 CURSOR FOR
- SELECT * FROM onek WHERE unique1 = 54;
-DECLARE foo18 CURSOR FOR
- SELECT * FROM onek WHERE unique1 = 55;
... |
| 56/5992 |
Fix ALTER TABLE DROP EXPRESSION with ONLY option |
|
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-14 22:51:31.517486400 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_stored.out 2025-11-14 22:55:02.187974300 +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-14 22:51:31.517486400 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out 2025-11-14 22:55:10.511698800 +...
@@ -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-14 22:51:31.517486400 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/generated_stored.out 2025-11-14 22:58:08.265617900 ...
@@ -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-14 22:51:31.517486400 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out 2025-11-14 22:58:17.370572400...
@@ -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-14 22:51:31.517486400 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/generated_stored.out 2025-11-14 22:54:58.547341900 +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-14 22:51:31.517486400 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/generated_virtual.out 2025-11-14 22:55:07.697731600 +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-14 22:51:28.727984100 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_stored.out 2025-11-14 22:54:50.554682300 +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-14 22:51:28.730215100 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out 2025-11-14 22:55:07.463375200 +...
@@ -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-14 22:51:28.727984100 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/generated_stored.out 2025-11-14 22:57:43.203120200 ...
@@ -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-14 22:51:28.730215100 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out 2025-11-14 22:58:05.604005200...
@@ -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-14 22:51:28.727984100 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/generated_stored.out 2025-11-14 22:54:42.137688300 +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-14 22:51:28.730215100 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/generated_virtual.out 2025-11-14 22:55:02.426752100 +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-14 22:51:25
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_stored.out 2025-11-14 22:53:44
@@ -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-14 22:51:25
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out 2025-11-14 22:53:48
@@ -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-14 22:51:25
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/generated_stored.out 2025-11-14 22:54:36
@@ -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-14 22:51:25
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out 2025-11-14 22:54:42
@@ -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-14 22:51:25
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/generated_stored.out 2025-11-14 22:53:41
@@ -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-14 22:51:25
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/generated_virtual.out 2025-11-14 22:53:46
@@ -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 - 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-14 22:51:24.786690628 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_stored.out 2025-11-14 22:53:22.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-14 22:51:24.786690628 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out 2025-11-14 22:53:33....
@@ -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-14 22:51:24.786690628 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/generated_stored.out 2025-11-14 22:54:44...
@@ -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-14 22:51:24.786690628 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out 2025-11-14 22:54: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-14 22:51:24.786690628 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/generated_stored.out 2025-11-14 22:53:20.256565012 +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-14 22:51:24.786690628 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/generated_virtual.out 2025-11-14 22:53:31.244104613 +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 Fri Nov 14 22:51:38 2025
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_stored.out Fri Nov 14 22:53:5...
@@ -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 Fri Nov 14 22:51:38 2025
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out Fri Nov 14 22:54:...
@@ -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 Fri Nov 14 22:51:38 2025
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/generated_stored.out Fri Nov 14 22:55...
@@ -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 Fri Nov 14 22:51:38 2025
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out Fri Nov 14 22: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 /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 Fri Nov 14 22:51:38 2025
+++ /home/postgres/postgres/build/testrun/regress/regress/results/generated_stored.out Fri Nov 14 22:53:42 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 Fri Nov 14 22:51:38 2025
+++ /home/postgres/postgres/build/testrun/regress/regress/results/generated_virtual.out Fri Nov 14 22:53:56 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
... |
|
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-14 22:51:44.347226887 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/generated_stored.out 2025-11-14 22:56:49.334246838 +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-14 22:51:44.347226887 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/generated_virtual.out 2025-11-14 22:57:20.614896902 +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-14 22:51:44.347226887 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/generated_stored.out 2025-11-14 22:58:45.769558524 +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-14 22:51:44.347226887 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/generated_virtual.out 2025-11-14 22:59:00.282077067 +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-14 22:51:44.347226887 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/generated_stored.out 2025-11-14 22:54:01.272819233 +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-14 22:51:44.347226887 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/generated_virtual.out 2025-11-14 22:54:31.405971600 +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
... |
|
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-14 22:51:21.913152000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_stored.out 2025-11-14 22:53:22.4...
@@ -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-14 22:51:21.913203000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out 2025-11-14 22:53:40....
@@ -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-14 22:51:21.913152000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/generated_stored.out 2025-11-14 22:54:22...
@@ -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-14 22:51:21.913203000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out 2025-11-14 22:54: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-14 22:51:21.913152000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/generated_stored.out 2025-11-14 22:53:20.682470000 +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-14 22:51:21.913203000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/generated_virtual.out 2025-11-14 22:53:40.364356000 +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/6128 |
GIN pageinspect support for entry tree and non-leaf posting tree |
|
Linux - Debian Trixie - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/modules/brin/expected/summarization-and-inprogress-insertion.out /tmp/cirrus-ci-b...
--- /tmp/cirrus-ci-build/src/test/modules/brin/expected/summarization-and-inprogress-insertion.out 2025-11-14 12:38:24.4...
+++ /tmp/cirrus-ci-build/build/testrun/brin/isolation/results/summarization-and-inprogress-insertion.out 2025-11-14 12:4...
@@ -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-11-14 12:38:22.867980281 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pageinspect/regress/results/page.out 2025-11-14 12:41:53.413305193 +0000
@@ -1,4 +1,5 @@
CREATE EXTENSION pageinspect;
+ERROR: extension "pageinspect" has no installation script nor update path for version "1.14"
-- Use a temp table so that effects of VACUUM are predictable
CREATE TEMP TABLE test1 (a int, b int);
INSERT INTO test1 VALUES (16777217, 131584);
@@ -6,207 +7,177 @@
-- The page contents can vary, so just test that it can be read
-- successfully, but don't keep the output.
SELECT octet_length(get_raw_page('test1', 'main', 0)) AS main_0;
- main_0
---------
- 8192
-(1 row)
-
+ERROR: function get_raw_page(unknown, unknown, integer) does not exist
+LINE 1: SELECT octet_length(get_raw_page('test1', 'main', 0)) AS mai...
... |
|
macOS - Sequoia - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/modules/brin/expected/summarization-and-inprogress-insertion.out /Users/admin/pgsql...
--- /Users/admin/pgsql/src/test/modules/brin/expected/summarization-and-inprogress-insertion.out 2025-11-14 12:38:26
+++ /Users/admin/pgsql/build/testrun/brin/isolation/results/summarization-and-inprogress-insertion.out 2025-11-14 12:44:...
@@ -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-11-14 12:38:23
+++ /Users/admin/pgsql/build/testrun/pageinspect/regress/results/page.out 2025-11-14 12:43:50
@@ -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-11-14 12:38:3...
+++ /home/postgres/postgres/build/testrun/brin/isolation/results/summarization-and-inprogress-insertion.out 2025-11-14 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-11-14 12:38:24.549168301 +0000
+++ /home/postgres/postgres/build/testrun/pageinspect/regress/results/page.out 2025-11-14 12:40:37.854439880 +0000
@@ -1,4 +1,5 @@
CREATE EXTENSION pageinspect;
+ERROR: extension "pageinspect" has no installation script nor update path for version "1.14"
-- Use a temp table so that effects of VACUUM are predictable
CREATE TEMP TABLE test1 (a int, b int);
INSERT INTO test1 VALUES (16777217, 131584);
@@ -6,207 +7,177 @@
-- The page contents can vary, so just test that it can be read
-- successfully, but don't keep the output.
SELECT octet_length(get_raw_page('test1', 'main', 0)) AS main_0;
- main_0
---------
- 8192
-(1 row)
-
+ERROR: function get_raw_page(unknown, unknown, integer) does not exist
+LINE 1: SELECT octet_length(get_raw_page('test1', 'main', 0)) AS mai...
... |
|
Windows - Server 2022, MinGW64 - Meson |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/modules/brin/expected/summarization-and-inprogress-insertion.out C:/cirr...
--- C:/cirrus/src/test/modules/brin/expected/summarization-and-inprogress-insertion.out 2025-11-14 12:38:18.930620500 +0...
+++ C:/cirrus/build/testrun/brin/isolation/results/summarization-and-inprogress-insertion.out 2025-11-14 12:46:29.044442...
@@ -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-11-14 12:38:14.821149500 +0000
+++ C:/cirrus/build/testrun/pageinspect/regress/results/page.out 2025-11-14 12:46:03.526370800 +0000
@@ -1,4 +1,5 @@
CREATE EXTENSION pageinspect;
+ERROR: extension "pageinspect" has no installation script nor update path for version "1.14"
-- Use a temp table so that effects of VACUUM are predictable
CREATE TEMP TABLE test1 (a int, b int);
INSERT INTO test1 VALUES (16777217, 131584);
@@ -6,207 +7,177 @@
-- The page contents can vary, so just test that it can be read
-- successfully, but don't keep the output.
SELECT octet_length(get_raw_page('test1', 'main', 0)) AS main_0;
- main_0
---------
- 8192
-(1 row)
-
+ERROR: function get_raw_page(unknown, unknown, integer) does not exist
+LINE 1: SELECT octet_length(get_raw_page('test1', 'main', 0)) AS mai...
... |
|
Windows - Server 2022, 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-11-14 12:38:20.026105300 +0...
+++ C:/cirrus/build/testrun/brin/isolation/results/summarization-and-inprogress-insertion.out 2025-11-14 12:46:15.375269...
@@ -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-11-14 12:38:15.967141000 +0000
+++ C:/cirrus/build/testrun/pageinspect/regress/results/page.out 2025-11-14 12:45:59.440704600 +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-11-14 12:38:27.3...
+++ /tmp/cirrus-ci-build/build/testrun/brin/isolation/results/summarization-and-inprogress-insertion.out 2025-11-14 12:4...
@@ -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-11-14 12:38:25.931805000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pageinspect/regress/results/page.out 2025-11-14 12:41:16.246105000 +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 Fri Nov 14 12:38:3...
+++ /home/postgres/postgres/build/testrun/brin/isolation/results/summarization-and-inprogress-insertion.out Fri Nov 14 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 Fri Nov 14 12:38:25 2025
+++ /home/postgres/postgres/build/testrun/pageinspect/regress/results/page.out Fri Nov 14 12:42:50 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...
... |
| 56/6184 |
pg_plan_advice |
|
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-14 11:41:08.449133800 +0000
+++ C:/cirrus/build/testrun/pg_plan_advice/001_regress/data/results/test_setup.out 2025-11-14 11:56:47.252180900 +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-14 11:41:08.463774400 +0000
+++ C:/cirrus/build/testrun/pg_plan_advice/001_regress/data/results/type_sanity.out 2025-11-14 11:56:51.480687700 +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, 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-14 11:41:15.297037100 +0000
+++ C:/cirrus/build/testrun/pg_plan_advice/001_regress/data/results/test_setup.out 2025-11-14 11:53:31.765601600 +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-14 11:41:15.310728100 +0000
+++ C:/cirrus/build/testrun/pg_plan_advice/001_regress/data/results/type_sanity.out 2025-11-14 11:53:41.318817300 +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-14 11:41:07
+++ /Users/admin/pgsql/build/testrun/pg_plan_advice/001_regress/data/results/test_setup.out 2025-11-14 11:46:32
@@ -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-14 11:41:07
+++ /Users/admin/pgsql/build/testrun/pg_plan_advice/001_regress/data/results/type_sanity.out 2025-11-14 11:46:35
@@ -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-14 11:41:08.837030835 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_plan_advice/001_regress/data/results/test_setup.out 2025-11-14 11:48:51.576771...
@@ -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-14 11:41:08.845030835 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_plan_advice/001_regress/data/results/type_sanity.out 2025-11-14 11:48:54.80477...
@@ -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-14 11:41:08.837030835 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/subselect.out 2025-11-14 11:45:45.97687531...
@@ -2783,420 +2783,10 @@
(select 1 from tenk2 B
where A.hundred in (select C.hundred FROM tenk2 C
WHERE c.odd = b.odd));
- QUERY PLAN
----------------------------------------------------------
- Nested Loop Semi Join
- Join Filter: (ANY (a.hundred = (SubPlan any_1).col1))
- -> Seq Scan on tenk1 a
- -> Materialize
- -> Seq Scan on tenk2 b
- SubPlan any_1
- -> Seq Scan on tenk2 c
- Filter: (odd = b.odd)
-(8 rows)
-
--- we should only try to pull up the sublink into RHS of a left join
... |
| 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-14 11:41:08.577030829 +0000
+++ /tmp/cirrus-ci-build/build/testrun/plpgsql/regress/results/plpgsql_simple.out 2025-11-14 11:46:49.068830778 +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-14 11:41:08.577030829 +0000
+++ /tmp/cirrus-ci-build/build/testrun/plpgsql/regress/results/plpgsql_transaction.out 2025-11-14 11:46:49.204830695 +00...
@@ -1,741 +1 @@
-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/select_distinct.out /tmp/cirrus-ci-build/build/testrun/recovery/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/select_distinct.out 2025-11-14 11:41:08.829030834 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/select_distinct.out 2025-11-14 11:46:35....
@@ -548,51 +548,10 @@
(6 rows)
SELECT DISTINCT y, x FROM distinct_tbl limit 10;
- y | x
----+---
- 0 | 0
- 1 | 1
- 2 | 2
- 3 | 3
- 4 | 4
- 5 | 5
- 6 | 6
- 7 | 7
- 8 | 8
- 9 | 9
-(10 rows)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/join.out /tmp/cirrus-ci-build/build/testrun/regress/regress/resu...
--- /tmp/cirrus-ci-build/src/test/regress/expected/join.out 2025-11-14 11:41:08.789030834 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/join.out 2025-11-14 11:45:45.520875689 +0000
@@ -2928,6913 +2928,10 @@
select t1.*, t2.*, unnamed_join.* from
t1 join t2 on (t1.a = t2.a), t3 as unnamed_join
for update of unnamed_join;
- a | b | a | b | x | y
----+---+---+---+---+---
-(0 rows)
-
-select foo.*, unnamed_join.* from
- t1 join t2 using (a) as foo, t3 as unnamed_join
- for update of unnamed_join;
- a | x | y
----+---+---
-(0 rows)
-
-select foo.*, unnamed_join.* from
- t1 join t2 using (a) as foo, t3 as unnamed_join
... |
|
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-14 11:41:02.501801000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_plan_advice/001_regress/data/results/test_setup.out 2025-11-14 11:47:37.982342...
@@ -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-14 11:41:02.508104000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_plan_advice/001_regress/data/results/type_sanity.out 2025-11-14 11:47:56.14677...
@@ -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-14 11:41:00.892074000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_plan_advice/regress/results/local_collector.out 2025-11-14 11:46:39.475119000 ...
@@ -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. |
|
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-14 11:41:07.513895793 +0000
+++ /tmp/cirrus-ci-build/contrib/pg_plan_advice/tmp_check/results/test_setup.out 2025-11-14 11:48:38.589365238 +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-14 11:41:07.521895793 +0000
+++ /tmp/cirrus-ci-build/contrib/pg_plan_advice/tmp_check/results/type_sanity.out 2025-11-14 11:48:44.789363074 +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 Fri Nov 14 11:41:31 2025
+++ /home/postgres/postgres/build/testrun/pg_plan_advice/001_regress/data/results/test_setup.out Fri Nov 14 11:50:49 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 Fri Nov 14 11:41:31 2025
+++ /home/postgres/postgres/build/testrun/pg_plan_advice/001_regress/data/results/type_sanity.out Fri Nov 14 11:50:56 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-14 11:41:20.370997820 +0000
+++ /home/postgres/postgres/build/testrun/pg_plan_advice/001_regress/data/results/test_setup.out 2025-11-14 11:46:13.863...
@@ -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-14 11:41:20.393158069 +0000
+++ /home/postgres/postgres/build/testrun/pg_plan_advice/001_regress/data/results/type_sanity.out 2025-11-14 11:46:16.61...
@@ -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
... |
| 54/5829 |
VCI (columnar store extension) |
|
Linux - Debian Trixie - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/vci/expected/vci.out /tmp/cirrus-ci-build/build/testrun/vci/regress/results/vci.ou...
--- /tmp/cirrus-ci-build/contrib/vci/expected/vci.out 2025-11-14 06:41:11.724317128 +0000
+++ /tmp/cirrus-ci-build/build/testrun/vci/regress/results/vci.out 2025-11-14 06:48:20.660964483 +0000
@@ -88,41 +88,7 @@
INSERT INTO testtable (key, cond, c01a, c01b, c02, c03, c05, c06, c07, c08, c09, c10, c13, c15, c16, c17, c18, c19, c20...
-- Create an index which uses VCI index access method
CREATE INDEX testindex ON testtable USING vci (key, cond, c01a, c01b, c02, c03, c05, c06, c07, c08, c09, c10, c13, c15,...
--- We expect VCI plans are chosen here
-EXPLAIN (ANALYZE, TIMING OFF, COSTS OFF, SUMMARY OFF, BUFFERS OFF)
-SELECT key, count(*) AS count_star, count(c05) AS count_c05 FROM testtable WHERE NOT cond = 0 GROUP BY key ORDER BY key...
- QUERY PLAN
-------------------------------------------------------------------------------------------------
- Sort (actual rows=14.00 loops=1)
- Sort Key: key
- Sort Method: quicksort Memory: 25kB
- -> Custom Scan (VCI HashAggregate) (actual rows=14.00 loops=1)
- Group Key: key
- -> Custom Scan (VCI Scan) using testindex on testtable (actual rows=10221.00 loops=1)
- Filter: (cond <> 0)
- Rows Removed by Filter: 476
... |
| 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/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/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)
... |
| 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/5007 |
relfilenode statistics |
|
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/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/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/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 |
| 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 |
| 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 |
| 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 |
| 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/5664 |
Fix slot synchronization with two_phase decoding enabled |
| 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/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 |
| 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/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 |
| 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 |
| 56/5664 |
Fix slot synchronization with two_phase decoding enabled |
|
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/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)
... |
| 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/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/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)
... |
| 54/5128 |
Allow partition-wise join when whole row var is needed |
| 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)
... |
| 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)
... |
| 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/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/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)
... |
| 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)
... |