This robot generates gigabytes of CI logs every week. Here is an attempt to
search for "highlights", so it's easier to find actionable information
quickly. New ideas for what patterns to search for are very welcome.
"Current" shows only the most recent results from each submission. The
wider time ranges also show information about historical versions, which
may be useful for flapping tests, and also for hunting for bugs in master.
| 57/6054 |
let ALTER COLUMN SET DATA TYPE cope with POLICY dependency |
 |
Windows - Server 2022, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/rowsecurity.out C:/cirrus/build/testrun/recovery/027_st...
--- C:/cirrus/src/test/regress/expected/rowsecurity.out 2025-12-13 18:55:58.496820600 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/rowsecurity.out 2025-12-13 19:02:02.942646800 +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...
... |
|
macOS - Sequoia - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/rowsecurity.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg...
--- /Users/admin/pgsql/src/test/regress/expected/rowsecurity.out 2025-12-13 18:55:51
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/rowsecurity.out 2025-12-13 18:58:29
@@ -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...
... |
| 57/5836 |
SQL:2011 Application Time Update & Delete |
|
Windows - Server 2022, MinGW64 - Meson |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/partition_info.out C:/cirrus/build/testrun/pg_upgrade/0...
--- C:/cirrus/src/test/regress/expected/partition_info.out 2025-12-13 16:11:16.482369500 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/partition_info.out 2025-12-13 16:18:36.510679700 +000...
@@ -352,7 +352,14 @@
-- Test about selection of arbiter indexes for partitioned tables with
-- non-valid index on the parent table
CREATE TABLE pt (a int PRIMARY KEY) PARTITION BY RANGE (a);
+ERROR: relation "pt" already exists
CREATE TABLE p1 PARTITION OF pt FOR VALUES FROM (1) to (2) PARTITION BY RANGE (a);
+ERROR: Inheriting from a table with a PERIOD is not supported
CREATE TABLE p1_1 PARTITION OF p1 FOR VALUES FROM (1) TO (2);
+ERROR: relation "p1" does not exist
CREATE UNIQUE INDEX ON ONLY p1 (a);
+ERROR: relation "p1" does not exist
INSERT INTO p1 VALUES (1) ON CONFLICT (a) DO NOTHING;
+ERROR: relation "p1" does not exist
+LINE 1: INSERT INTO p1 VALUES (1) ON CONFLICT (a) DO NOTHING;
+ ^ |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/partition_info.out C:/cirrus/build/testrun/recovery/027...
--- C:/cirrus/src/test/regress/expected/partition_info.out 2025-12-13 16:11:16.482369500 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/partition_info.out 2025-12-13 16:21:34.147375700 +0...
@@ -352,7 +352,14 @@
-- Test about selection of arbiter indexes for partitioned tables with
-- non-valid index on the parent table
CREATE TABLE pt (a int PRIMARY KEY) PARTITION BY RANGE (a);
+ERROR: relation "pt" already exists
CREATE TABLE p1 PARTITION OF pt FOR VALUES FROM (1) to (2) PARTITION BY RANGE (a);
+ERROR: Inheriting from a table with a PERIOD is not supported
CREATE TABLE p1_1 PARTITION OF p1 FOR VALUES FROM (1) TO (2);
+ERROR: relation "p1" does not exist
CREATE UNIQUE INDEX ON ONLY p1 (a);
+ERROR: relation "p1" does not exist
INSERT INTO p1 VALUES (1) ON CONFLICT (a) DO NOTHING;
+ERROR: relation "p1" does not exist
+LINE 1: INSERT INTO p1 VALUES (1) ON CONFLICT (a) DO NOTHING;
+ ^ |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/partition_info.out C:/cirrus/build/testrun/regress/regr...
--- C:/cirrus/src/test/regress/expected/partition_info.out 2025-12-13 16:11:16.482369500 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/partition_info.out 2025-12-13 16:18:33.133231000 +0000
@@ -352,7 +352,14 @@
-- Test about selection of arbiter indexes for partitioned tables with
-- non-valid index on the parent table
CREATE TABLE pt (a int PRIMARY KEY) PARTITION BY RANGE (a);
+ERROR: relation "pt" already exists
CREATE TABLE p1 PARTITION OF pt FOR VALUES FROM (1) to (2) PARTITION BY RANGE (a);
+ERROR: Inheriting from a table with a PERIOD is not supported
CREATE TABLE p1_1 PARTITION OF p1 FOR VALUES FROM (1) TO (2);
+ERROR: relation "p1" does not exist
CREATE UNIQUE INDEX ON ONLY p1 (a);
+ERROR: relation "p1" does not exist
INSERT INTO p1 VALUES (1) ON CONFLICT (a) DO NOTHING;
+ERROR: relation "p1" does not exist
+LINE 1: INSERT INTO p1 VALUES (1) ON CONFLICT (a) DO NOTHING;
+ ^ |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/partition_info.out C:/cirrus/build/testrun/pg_upgrade/0...
--- C:/cirrus/src/test/regress/expected/partition_info.out 2025-12-13 16:11:17.216193600 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/partition_info.out 2025-12-13 16:15:41.433048400 +000...
@@ -352,7 +352,14 @@
-- Test about selection of arbiter indexes for partitioned tables with
-- non-valid index on the parent table
CREATE TABLE pt (a int PRIMARY KEY) PARTITION BY RANGE (a);
+ERROR: relation "pt" already exists
CREATE TABLE p1 PARTITION OF pt FOR VALUES FROM (1) to (2) PARTITION BY RANGE (a);
+ERROR: Inheriting from a table with a PERIOD is not supported
CREATE TABLE p1_1 PARTITION OF p1 FOR VALUES FROM (1) TO (2);
+ERROR: relation "p1" does not exist
CREATE UNIQUE INDEX ON ONLY p1 (a);
+ERROR: relation "p1" does not exist
INSERT INTO p1 VALUES (1) ON CONFLICT (a) DO NOTHING;
+ERROR: relation "p1" does not exist
+LINE 1: INSERT INTO p1 VALUES (1) ON CONFLICT (a) DO NOTHING;
+ ^ |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/partition_info.out C:/cirrus/build/testrun/recovery/027...
--- C:/cirrus/src/test/regress/expected/partition_info.out 2025-12-13 16:11:17.216193600 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/partition_info.out 2025-12-13 16:18:23.486344000 +0...
@@ -352,7 +352,14 @@
-- Test about selection of arbiter indexes for partitioned tables with
-- non-valid index on the parent table
CREATE TABLE pt (a int PRIMARY KEY) PARTITION BY RANGE (a);
+ERROR: relation "pt" already exists
CREATE TABLE p1 PARTITION OF pt FOR VALUES FROM (1) to (2) PARTITION BY RANGE (a);
+ERROR: Inheriting from a table with a PERIOD is not supported
CREATE TABLE p1_1 PARTITION OF p1 FOR VALUES FROM (1) TO (2);
+ERROR: relation "p1" does not exist
CREATE UNIQUE INDEX ON ONLY p1 (a);
+ERROR: relation "p1" does not exist
INSERT INTO p1 VALUES (1) ON CONFLICT (a) DO NOTHING;
+ERROR: relation "p1" does not exist
+LINE 1: INSERT INTO p1 VALUES (1) ON CONFLICT (a) DO NOTHING;
+ ^ |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/partition_info.out C:/cirrus/build/testrun/regress/regr...
--- C:/cirrus/src/test/regress/expected/partition_info.out 2025-12-13 16:11:17.216193600 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/partition_info.out 2025-12-13 16:15:34.591733800 +0000
@@ -352,7 +352,14 @@
-- Test about selection of arbiter indexes for partitioned tables with
-- non-valid index on the parent table
CREATE TABLE pt (a int PRIMARY KEY) PARTITION BY RANGE (a);
+ERROR: relation "pt" already exists
CREATE TABLE p1 PARTITION OF pt FOR VALUES FROM (1) to (2) PARTITION BY RANGE (a);
+ERROR: Inheriting from a table with a PERIOD is not supported
CREATE TABLE p1_1 PARTITION OF p1 FOR VALUES FROM (1) TO (2);
+ERROR: relation "p1" does not exist
CREATE UNIQUE INDEX ON ONLY p1 (a);
+ERROR: relation "p1" does not exist
INSERT INTO p1 VALUES (1) ON CONFLICT (a) DO NOTHING;
+ERROR: relation "p1" does not exist
+LINE 1: INSERT INTO p1 VALUES (1) ON CONFLICT (a) DO NOTHING;
+ ^ |
|
macOS - Sequoia - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/partition_info.out /Users/admin/pgsql/build/testrun/pg_upgrade/002...
--- /Users/admin/pgsql/src/test/regress/expected/partition_info.out 2025-12-13 16:11:08
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/partition_info.out 2025-12-13 16:14:23
@@ -352,7 +352,14 @@
-- Test about selection of arbiter indexes for partitioned tables with
-- non-valid index on the parent table
CREATE TABLE pt (a int PRIMARY KEY) PARTITION BY RANGE (a);
+ERROR: relation "pt" already exists
CREATE TABLE p1 PARTITION OF pt FOR VALUES FROM (1) to (2) PARTITION BY RANGE (a);
+ERROR: Inheriting from a table with a PERIOD is not supported
CREATE TABLE p1_1 PARTITION OF p1 FOR VALUES FROM (1) TO (2);
+ERROR: relation "p1" does not exist
CREATE UNIQUE INDEX ON ONLY p1 (a);
+ERROR: relation "p1" does not exist
INSERT INTO p1 VALUES (1) ON CONFLICT (a) DO NOTHING;
+ERROR: relation "p1" does not exist
+LINE 1: INSERT INTO p1 VALUES (1) ON CONFLICT (a) DO NOTHING;
+ ^ |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/partition_info.out /Users/admin/pgsql/build/testrun/recovery/027_s...
--- /Users/admin/pgsql/src/test/regress/expected/partition_info.out 2025-12-13 16:11:08
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/partition_info.out 2025-12-13 16:15:29
@@ -352,7 +352,14 @@
-- Test about selection of arbiter indexes for partitioned tables with
-- non-valid index on the parent table
CREATE TABLE pt (a int PRIMARY KEY) PARTITION BY RANGE (a);
+ERROR: relation "pt" already exists
CREATE TABLE p1 PARTITION OF pt FOR VALUES FROM (1) to (2) PARTITION BY RANGE (a);
+ERROR: Inheriting from a table with a PERIOD is not supported
CREATE TABLE p1_1 PARTITION OF p1 FOR VALUES FROM (1) TO (2);
+ERROR: relation "p1" does not exist
CREATE UNIQUE INDEX ON ONLY p1 (a);
+ERROR: relation "p1" does not exist
INSERT INTO p1 VALUES (1) ON CONFLICT (a) DO NOTHING;
+ERROR: relation "p1" does not exist
+LINE 1: INSERT INTO p1 VALUES (1) ON CONFLICT (a) DO NOTHING;
+ ^ |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/partition_info.out /Users/admin/pgsql/build/testrun/regress/regres...
--- /Users/admin/pgsql/src/test/regress/expected/partition_info.out 2025-12-13 16:11:08
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/partition_info.out 2025-12-13 16:14:26
@@ -352,7 +352,14 @@
-- Test about selection of arbiter indexes for partitioned tables with
-- non-valid index on the parent table
CREATE TABLE pt (a int PRIMARY KEY) PARTITION BY RANGE (a);
+ERROR: relation "pt" already exists
CREATE TABLE p1 PARTITION OF pt FOR VALUES FROM (1) to (2) PARTITION BY RANGE (a);
+ERROR: Inheriting from a table with a PERIOD is not supported
CREATE TABLE p1_1 PARTITION OF p1 FOR VALUES FROM (1) TO (2);
+ERROR: relation "p1" does not exist
CREATE UNIQUE INDEX ON ONLY p1 (a);
+ERROR: relation "p1" does not exist
INSERT INTO p1 VALUES (1) ON CONFLICT (a) DO NOTHING;
+ERROR: relation "p1" does not exist
+LINE 1: INSERT INTO p1 VALUES (1) ON CONFLICT (a) DO NOTHING;
+ ^ |
|
Linux - Debian Trixie - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/partition_info.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade...
--- /tmp/cirrus-ci-build/src/test/regress/expected/partition_info.out 2025-12-13 16:11:16.660023457 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/partition_info.out 2025-12-13 16:16:47.247...
@@ -352,7 +352,14 @@
-- Test about selection of arbiter indexes for partitioned tables with
-- non-valid index on the parent table
CREATE TABLE pt (a int PRIMARY KEY) PARTITION BY RANGE (a);
+ERROR: relation "pt" already exists
CREATE TABLE p1 PARTITION OF pt FOR VALUES FROM (1) to (2) PARTITION BY RANGE (a);
+ERROR: Inheriting from a table with a PERIOD is not supported
CREATE TABLE p1_1 PARTITION OF p1 FOR VALUES FROM (1) TO (2);
+ERROR: relation "p1" does not exist
CREATE UNIQUE INDEX ON ONLY p1 (a);
+ERROR: relation "p1" does not exist
INSERT INTO p1 VALUES (1) ON CONFLICT (a) DO NOTHING;
+ERROR: relation "p1" does not exist
+LINE 1: INSERT INTO p1 VALUES (1) ON CONFLICT (a) DO NOTHING;
+ ^ |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/partition_info.out /tmp/cirrus-ci-build/build/testrun/recovery/0...
--- /tmp/cirrus-ci-build/src/test/regress/expected/partition_info.out 2025-12-13 16:11:16.660023457 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/partition_info.out 2025-12-13 16:18:11.7...
@@ -352,7 +352,14 @@
-- Test about selection of arbiter indexes for partitioned tables with
-- non-valid index on the parent table
CREATE TABLE pt (a int PRIMARY KEY) PARTITION BY RANGE (a);
+ERROR: relation "pt" already exists
CREATE TABLE p1 PARTITION OF pt FOR VALUES FROM (1) to (2) PARTITION BY RANGE (a);
+ERROR: Inheriting from a table with a PERIOD is not supported
CREATE TABLE p1_1 PARTITION OF p1 FOR VALUES FROM (1) TO (2);
+ERROR: relation "p1" does not exist
CREATE UNIQUE INDEX ON ONLY p1 (a);
+ERROR: relation "p1" does not exist
INSERT INTO p1 VALUES (1) ON CONFLICT (a) DO NOTHING;
+ERROR: relation "p1" does not exist
+LINE 1: INSERT INTO p1 VALUES (1) ON CONFLICT (a) DO NOTHING;
+ ^ |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/partition_info.out /tmp/cirrus-ci-build/build/testrun/regress/re...
--- /tmp/cirrus-ci-build/src/test/regress/expected/partition_info.out 2025-12-13 16:11:16.660023457 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/partition_info.out 2025-12-13 16:16:43.491242418 +0000
@@ -352,7 +352,14 @@
-- Test about selection of arbiter indexes for partitioned tables with
-- non-valid index on the parent table
CREATE TABLE pt (a int PRIMARY KEY) PARTITION BY RANGE (a);
+ERROR: relation "pt" already exists
CREATE TABLE p1 PARTITION OF pt FOR VALUES FROM (1) to (2) PARTITION BY RANGE (a);
+ERROR: Inheriting from a table with a PERIOD is not supported
CREATE TABLE p1_1 PARTITION OF p1 FOR VALUES FROM (1) TO (2);
+ERROR: relation "p1" does not exist
CREATE UNIQUE INDEX ON ONLY p1 (a);
+ERROR: relation "p1" does not exist
INSERT INTO p1 VALUES (1) ON CONFLICT (a) DO NOTHING;
+ERROR: relation "p1" does not exist
+LINE 1: INSERT INTO p1 VALUES (1) ON CONFLICT (a) DO NOTHING;
+ ^ |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/partition_info.out /home/postgres/postgres/build/testrun/pg_u...
--- /home/postgres/postgres/src/test/regress/expected/partition_info.out 2025-12-13 16:11:24.402493253 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/partition_info.out 2025-12-13 16:15:15....
@@ -352,7 +352,14 @@
-- Test about selection of arbiter indexes for partitioned tables with
-- non-valid index on the parent table
CREATE TABLE pt (a int PRIMARY KEY) PARTITION BY RANGE (a);
+ERROR: relation "pt" already exists
CREATE TABLE p1 PARTITION OF pt FOR VALUES FROM (1) to (2) PARTITION BY RANGE (a);
+ERROR: Inheriting from a table with a PERIOD is not supported
CREATE TABLE p1_1 PARTITION OF p1 FOR VALUES FROM (1) TO (2);
+ERROR: relation "p1" does not exist
CREATE UNIQUE INDEX ON ONLY p1 (a);
+ERROR: relation "p1" does not exist
INSERT INTO p1 VALUES (1) ON CONFLICT (a) DO NOTHING;
+ERROR: relation "p1" does not exist
+LINE 1: INSERT INTO p1 VALUES (1) ON CONFLICT (a) DO NOTHING;
+ ^ |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/partition_info.out /home/postgres/postgres/build/testrun/reco...
--- /home/postgres/postgres/src/test/regress/expected/partition_info.out 2025-12-13 16:11:24.402493253 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/partition_info.out 2025-12-13 16:15:5...
@@ -352,7 +352,14 @@
-- Test about selection of arbiter indexes for partitioned tables with
-- non-valid index on the parent table
CREATE TABLE pt (a int PRIMARY KEY) PARTITION BY RANGE (a);
+ERROR: relation "pt" already exists
CREATE TABLE p1 PARTITION OF pt FOR VALUES FROM (1) to (2) PARTITION BY RANGE (a);
+ERROR: Inheriting from a table with a PERIOD is not supported
CREATE TABLE p1_1 PARTITION OF p1 FOR VALUES FROM (1) TO (2);
+ERROR: relation "p1" does not exist
CREATE UNIQUE INDEX ON ONLY p1 (a);
+ERROR: relation "p1" does not exist
INSERT INTO p1 VALUES (1) ON CONFLICT (a) DO NOTHING;
+ERROR: relation "p1" does not exist
+LINE 1: INSERT INTO p1 VALUES (1) ON CONFLICT (a) DO NOTHING;
+ ^ |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/partition_info.out /home/postgres/postgres/build/testrun/regr...
--- /home/postgres/postgres/src/test/regress/expected/partition_info.out 2025-12-13 16:11:24.402493253 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/partition_info.out 2025-12-13 16:15:18.446637860 +0000
@@ -352,7 +352,14 @@
-- Test about selection of arbiter indexes for partitioned tables with
-- non-valid index on the parent table
CREATE TABLE pt (a int PRIMARY KEY) PARTITION BY RANGE (a);
+ERROR: relation "pt" already exists
CREATE TABLE p1 PARTITION OF pt FOR VALUES FROM (1) to (2) PARTITION BY RANGE (a);
+ERROR: Inheriting from a table with a PERIOD is not supported
CREATE TABLE p1_1 PARTITION OF p1 FOR VALUES FROM (1) TO (2);
+ERROR: relation "p1" does not exist
CREATE UNIQUE INDEX ON ONLY p1 (a);
+ERROR: relation "p1" does not exist
INSERT INTO p1 VALUES (1) ON CONFLICT (a) DO NOTHING;
+ERROR: relation "p1" does not exist
+LINE 1: INSERT INTO p1 VALUES (1) ON CONFLICT (a) DO NOTHING;
+ ^ |
|
Linux - Debian Trixie - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/partition_info.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_c...
--- /tmp/cirrus-ci-build/src/test/regress/expected/partition_info.out 2025-12-13 16:11:09.908504191 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/partition_info.out 2025-12-13 16:20:10.044288971 +0000
@@ -352,7 +352,14 @@
-- Test about selection of arbiter indexes for partitioned tables with
-- non-valid index on the parent table
CREATE TABLE pt (a int PRIMARY KEY) PARTITION BY RANGE (a);
+ERROR: relation "pt" already exists
CREATE TABLE p1 PARTITION OF pt FOR VALUES FROM (1) to (2) PARTITION BY RANGE (a);
+ERROR: Inheriting from a table with a PERIOD is not supported
CREATE TABLE p1_1 PARTITION OF p1 FOR VALUES FROM (1) TO (2);
+ERROR: relation "p1" does not exist
CREATE UNIQUE INDEX ON ONLY p1 (a);
+ERROR: relation "p1" does not exist
INSERT INTO p1 VALUES (1) ON CONFLICT (a) DO NOTHING;
+ERROR: relation "p1" does not exist
+LINE 1: INSERT INTO p1 VALUES (1) ON CONFLICT (a) DO NOTHING;
+ ^ |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/partition_info.out /tmp/cirrus-ci-build/src/test/recovery/tmp_ch...
--- /tmp/cirrus-ci-build/src/test/regress/expected/partition_info.out 2025-12-13 16:11:09.908504191 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/partition_info.out 2025-12-13 16:21:26.706160926 +0000
@@ -352,7 +352,14 @@
-- Test about selection of arbiter indexes for partitioned tables with
-- non-valid index on the parent table
CREATE TABLE pt (a int PRIMARY KEY) PARTITION BY RANGE (a);
+ERROR: relation "pt" already exists
CREATE TABLE p1 PARTITION OF pt FOR VALUES FROM (1) to (2) PARTITION BY RANGE (a);
+ERROR: Inheriting from a table with a PERIOD is not supported
CREATE TABLE p1_1 PARTITION OF p1 FOR VALUES FROM (1) TO (2);
+ERROR: relation "p1" does not exist
CREATE UNIQUE INDEX ON ONLY p1 (a);
+ERROR: relation "p1" does not exist
INSERT INTO p1 VALUES (1) ON CONFLICT (a) DO NOTHING;
+ERROR: relation "p1" does not exist
+LINE 1: INSERT INTO p1 VALUES (1) ON CONFLICT (a) DO NOTHING;
+ ^ |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/partition_info.out /tmp/cirrus-ci-build/src/test/regress/results...
--- /tmp/cirrus-ci-build/src/test/regress/expected/partition_info.out 2025-12-13 16:11:09.908504191 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/partition_info.out 2025-12-13 16:17:29.314420056 +0000
@@ -352,7 +352,14 @@
-- Test about selection of arbiter indexes for partitioned tables with
-- non-valid index on the parent table
CREATE TABLE pt (a int PRIMARY KEY) PARTITION BY RANGE (a);
+ERROR: relation "pt" already exists
CREATE TABLE p1 PARTITION OF pt FOR VALUES FROM (1) to (2) PARTITION BY RANGE (a);
+ERROR: Inheriting from a table with a PERIOD is not supported
CREATE TABLE p1_1 PARTITION OF p1 FOR VALUES FROM (1) TO (2);
+ERROR: relation "p1" does not exist
CREATE UNIQUE INDEX ON ONLY p1 (a);
+ERROR: relation "p1" does not exist
INSERT INTO p1 VALUES (1) ON CONFLICT (a) DO NOTHING;
+ERROR: relation "p1" does not exist
+LINE 1: INSERT INTO p1 VALUES (1) ON CONFLICT (a) DO NOTHING;
+ ^ |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/partition_info.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade...
--- /tmp/cirrus-ci-build/src/test/regress/expected/partition_info.out 2025-12-13 16:11:14.686639000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/partition_info.out 2025-12-13 16:16:22.464...
@@ -352,7 +352,14 @@
-- Test about selection of arbiter indexes for partitioned tables with
-- non-valid index on the parent table
CREATE TABLE pt (a int PRIMARY KEY) PARTITION BY RANGE (a);
+ERROR: relation "pt" already exists
CREATE TABLE p1 PARTITION OF pt FOR VALUES FROM (1) to (2) PARTITION BY RANGE (a);
+ERROR: Inheriting from a table with a PERIOD is not supported
CREATE TABLE p1_1 PARTITION OF p1 FOR VALUES FROM (1) TO (2);
+ERROR: relation "p1" does not exist
CREATE UNIQUE INDEX ON ONLY p1 (a);
+ERROR: relation "p1" does not exist
INSERT INTO p1 VALUES (1) ON CONFLICT (a) DO NOTHING;
+ERROR: relation "p1" does not exist
+LINE 1: INSERT INTO p1 VALUES (1) ON CONFLICT (a) DO NOTHING;
+ ^ |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/partition_info.out /tmp/cirrus-ci-build/build/testrun/recovery/0...
--- /tmp/cirrus-ci-build/src/test/regress/expected/partition_info.out 2025-12-13 16:11:14.686639000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/partition_info.out 2025-12-13 16:17:43.9...
@@ -352,7 +352,14 @@
-- Test about selection of arbiter indexes for partitioned tables with
-- non-valid index on the parent table
CREATE TABLE pt (a int PRIMARY KEY) PARTITION BY RANGE (a);
+ERROR: relation "pt" already exists
CREATE TABLE p1 PARTITION OF pt FOR VALUES FROM (1) to (2) PARTITION BY RANGE (a);
+ERROR: Inheriting from a table with a PERIOD is not supported
CREATE TABLE p1_1 PARTITION OF p1 FOR VALUES FROM (1) TO (2);
+ERROR: relation "p1" does not exist
CREATE UNIQUE INDEX ON ONLY p1 (a);
+ERROR: relation "p1" does not exist
INSERT INTO p1 VALUES (1) ON CONFLICT (a) DO NOTHING;
+ERROR: relation "p1" does not exist
+LINE 1: INSERT INTO p1 VALUES (1) ON CONFLICT (a) DO NOTHING;
+ ^ |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/partition_info.out /tmp/cirrus-ci-build/build/testrun/regress/re...
--- /tmp/cirrus-ci-build/src/test/regress/expected/partition_info.out 2025-12-13 16:11:14.686639000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/partition_info.out 2025-12-13 16:16:17.997601000 +0000
@@ -352,7 +352,14 @@
-- Test about selection of arbiter indexes for partitioned tables with
-- non-valid index on the parent table
CREATE TABLE pt (a int PRIMARY KEY) PARTITION BY RANGE (a);
+ERROR: relation "pt" already exists
CREATE TABLE p1 PARTITION OF pt FOR VALUES FROM (1) to (2) PARTITION BY RANGE (a);
+ERROR: Inheriting from a table with a PERIOD is not supported
CREATE TABLE p1_1 PARTITION OF p1 FOR VALUES FROM (1) TO (2);
+ERROR: relation "p1" does not exist
CREATE UNIQUE INDEX ON ONLY p1 (a);
+ERROR: relation "p1" does not exist
INSERT INTO p1 VALUES (1) ON CONFLICT (a) DO NOTHING;
+ERROR: relation "p1" does not exist
+LINE 1: INSERT INTO p1 VALUES (1) ON CONFLICT (a) DO NOTHING;
+ ^ |
|
OpenBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/partition_info.out /home/postgres/postgres/build/testrun/pg_u...
--- /home/postgres/postgres/src/test/regress/expected/partition_info.out Sat Dec 13 16:11:25 2025
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/partition_info.out Sat Dec 13 16:16:28 ...
@@ -352,7 +352,14 @@
-- Test about selection of arbiter indexes for partitioned tables with
-- non-valid index on the parent table
CREATE TABLE pt (a int PRIMARY KEY) PARTITION BY RANGE (a);
+ERROR: relation "pt" already exists
CREATE TABLE p1 PARTITION OF pt FOR VALUES FROM (1) to (2) PARTITION BY RANGE (a);
+ERROR: Inheriting from a table with a PERIOD is not supported
CREATE TABLE p1_1 PARTITION OF p1 FOR VALUES FROM (1) TO (2);
+ERROR: relation "p1" does not exist
CREATE UNIQUE INDEX ON ONLY p1 (a);
+ERROR: relation "p1" does not exist
INSERT INTO p1 VALUES (1) ON CONFLICT (a) DO NOTHING;
+ERROR: relation "p1" does not exist
+LINE 1: INSERT INTO p1 VALUES (1) ON CONFLICT (a) DO NOTHING;
+ ^ |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/partition_info.out /home/postgres/postgres/build/testrun/reco...
--- /home/postgres/postgres/src/test/regress/expected/partition_info.out Sat Dec 13 16:11:25 2025
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/partition_info.out Sat Dec 13 16:18:4...
@@ -352,7 +352,14 @@
-- Test about selection of arbiter indexes for partitioned tables with
-- non-valid index on the parent table
CREATE TABLE pt (a int PRIMARY KEY) PARTITION BY RANGE (a);
+ERROR: relation "pt" already exists
CREATE TABLE p1 PARTITION OF pt FOR VALUES FROM (1) to (2) PARTITION BY RANGE (a);
+ERROR: Inheriting from a table with a PERIOD is not supported
CREATE TABLE p1_1 PARTITION OF p1 FOR VALUES FROM (1) TO (2);
+ERROR: relation "p1" does not exist
CREATE UNIQUE INDEX ON ONLY p1 (a);
+ERROR: relation "p1" does not exist
INSERT INTO p1 VALUES (1) ON CONFLICT (a) DO NOTHING;
+ERROR: relation "p1" does not exist
+LINE 1: INSERT INTO p1 VALUES (1) ON CONFLICT (a) DO NOTHING;
+ ^ |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/partition_info.out /home/postgres/postgres/build/testrun/regr...
--- /home/postgres/postgres/src/test/regress/expected/partition_info.out Sat Dec 13 16:11:25 2025
+++ /home/postgres/postgres/build/testrun/regress/regress/results/partition_info.out Sat Dec 13 16:16:23 2025
@@ -352,7 +352,14 @@
-- Test about selection of arbiter indexes for partitioned tables with
-- non-valid index on the parent table
CREATE TABLE pt (a int PRIMARY KEY) PARTITION BY RANGE (a);
+ERROR: relation "pt" already exists
CREATE TABLE p1 PARTITION OF pt FOR VALUES FROM (1) to (2) PARTITION BY RANGE (a);
+ERROR: Inheriting from a table with a PERIOD is not supported
CREATE TABLE p1_1 PARTITION OF p1 FOR VALUES FROM (1) TO (2);
+ERROR: relation "p1" does not exist
CREATE UNIQUE INDEX ON ONLY p1 (a);
+ERROR: relation "p1" does not exist
INSERT INTO p1 VALUES (1) ON CONFLICT (a) DO NOTHING;
+ERROR: relation "p1" does not exist
+LINE 1: INSERT INTO p1 VALUES (1) ON CONFLICT (a) DO NOTHING;
+ ^ |
| 57/6258 |
Adds two new modifiers for \dt[Oo] and \di[Oo]. This helps inspect large deployments where relation size is important. |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/rangefuncs.out /home/postgres/postgres/build/testrun/regress/...
--- /home/postgres/postgres/src/test/regress/expected/rangefuncs.out 2025-12-13 14:42:42.345519247 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/rangefuncs.out 2025-12-13 14:44:28.673655813 +0000
@@ -1,2507 +1 @@
-CREATE TABLE rngfunc2(rngfuncid int, f2 int);
-INSERT INTO rngfunc2 VALUES(1, 11);
-INSERT INTO rngfunc2 VALUES(2, 22);
-INSERT INTO rngfunc2 VALUES(1, 111);
-CREATE FUNCTION rngfunct(int) returns setof rngfunc2 as 'SELECT * FROM rngfunc2 WHERE rngfuncid = $1 ORDER BY f2;' LANG...
--- function with ORDINALITY
-select * from rngfunct(1) with ordinality as z(a,b,ord);
- a | b | ord
----+-----+-----
- 1 | 11 | 1
- 1 | 111 | 2
-(2 rows)
-
-select * from rngfunct(1) with ordinality as z(a,b,ord) where b > 100; -- ordinal 2, not 1
- a | b | ord
----+-----+-----
... |
| 57/6303 |
refactor handling optional argument in system functions |
|
Linux - Debian Trixie - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out 2025-12-13 12:30:54.149801922 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/triggers.out 2025-12-13 12:35:53.041547117 +0000
@@ -2441,1191 +2441,10 @@
where tgrelid::regclass in ('trg_clone', 'trg_clone1', 'trg_clone2',
'trg_clone3', 'trg_clone_3_3')
group by tgrelid::regclass order by tgrelid::regclass;
- tgrelid | count
----------------+-------
- trg_clone | 1
- trg_clone1 | 1
- trg_clone2 | 1
- trg_clone3 | 1
- trg_clone_3_3 | 1
-(5 rows)
-
-drop table trg_clone;
--- Test the interaction between ALTER TABLE .. DISABLE TRIGGER and
--- both kinds of inheritance. Historically, legacy inheritance has
--- not recursed to children, so that behavior is preserved.
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/src/test/regress/results/trigg...
--- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out 2025-12-13 12:30:54.149801922 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/triggers.out 2025-12-13 12:34:36.510719854 +0000
@@ -2714,918 +2714,7 @@
create trigger child3_update_trig
after update on child3 referencing old table as old_table new table as new_table
for each statement execute procedure dump_update();
-create trigger child3_delete_trig
- after delete on child3 referencing old table as old_table
- for each statement execute procedure dump_delete();
-SELECT trigger_name, event_manipulation, event_object_schema, event_object_table,
- action_order, action_condition, action_orientation, action_timing,
- action_reference_old_table, action_reference_new_table
- FROM information_schema.triggers
- WHERE event_object_table IN ('parent', 'child1', 'child2', 'child3')
- ORDER BY trigger_name COLLATE "C", 2;
- trigger_name | event_manipulation | event_object_schema | event_object_table | action_order | action_condition |...
---------------------+--------------------+---------------------+--------------------+--------------+------------------+...
- child1_delete_trig | DELETE | public | child1 | 1 | |...
- child1_insert_trig | INSERT | public | child1 | 1 | |...
... |
| 57/6246 |
Remove ctid from self-join examples in UPDATE and DELETE docs |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/modules/injection_points/expected/index-concurrently-upsert-predicate.out /hom...
--- /home/postgres/postgres/src/test/modules/injection_points/expected/index-concurrently-upsert-predicate.out 2025-12-1...
+++ /home/postgres/postgres/build/testrun/injection_points/isolation/results/index-concurrently-upsert-predicate.out 202...
@@ -80,16 +80,7 @@
SELECT injection_points_detach('invalidate-catalog-snapshot-end');
SELECT injection_points_wakeup('invalidate-catalog-snapshot-end');
-injection_points_detach
------------------------
-
-(1 row)
-
-injection_points_wakeup
------------------------
-
-(1 row)
-
+ERROR: could not detach injection point "invalidate-catalog-snapshot-end"
step s4_wakeup_s2:
SELECT injection_points_detach('exec-insert-before-insert-speculative');
... |
| 57/5769 |
make ALTER DOMAIN VALIDATE CONSTRAINT no-op when constraint is validated |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/isolation/expected/timeouts.out /home/postgres/postgres/build/testrun/isolatio...
--- /home/postgres/postgres/src/test/isolation/expected/timeouts.out 2025-12-13 06:38:54.873980396 +0000
+++ /home/postgres/postgres/build/testrun/isolation/isolation/results/timeouts.out 2025-12-13 06:42:04.152442472 +0000
@@ -11,7 +11,7 @@
step sto: SET statement_timeout = '10ms';
step locktbl: LOCK TABLE accounts; <waiting ...>
step locktbl: <... completed>
-ERROR: canceling statement due to statement timeout
+ERROR: canceling statement due to user request
starting permutation: rdtbl lto locktbl
step rdtbl: SELECT * FROM accounts; |
| 57/3659 |
Add SPLIT PARTITION/MERGE PARTITIONS commands |
|
Windows - Server 2022, MinGW64 - Meson |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/modules/test_ddl_deparse/expected/alter_table.out C:/cirrus/build/testru...
--- C:/cirrus/src/test/modules/test_ddl_deparse/expected/alter_table.out 2025-12-13 06:27:07.643550400 +0000
+++ C:/cirrus/build/testrun/test_ddl_deparse/regress/results/alter_table.out 2025-12-13 06:39:19.026409500 +0000
@@ -41,41 +41,41 @@
NOTICE: merging constraint "a_pos" with inherited definition
NOTICE: DDL test: type alter table, tag ALTER TABLE
NOTICE: subcommand: type ADD CONSTRAINT (and recurse) desc constraint a_pos on table parent
+<<<<<<< HEAD
+=======
CREATE TABLE part (
a int
) PARTITION BY RANGE (a);
-NOTICE: DDL test: type simple, tag CREATE TABLE
+ERROR: syntax error at or near "<<<<<<<"
+LINE 1: <<<<<<< HEAD
+ ^
CREATE TABLE part1 PARTITION OF part FOR VALUES FROM (1) to (100);
-NOTICE: DDL test: type simple, tag CREATE TABLE
+ERROR: relation "part" does not exist
CREATE TABLE part2 (a int);
... |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/modules/test_ddl_deparse/expected/alter_table.out C:/cirrus/build/testru...
--- C:/cirrus/src/test/modules/test_ddl_deparse/expected/alter_table.out 2025-12-13 06:27:17.801004600 +0000
+++ C:/cirrus/build/testrun/test_ddl_deparse/regress/results/alter_table.out 2025-12-13 06:36:08.844978900 +0000
@@ -41,41 +41,41 @@
NOTICE: merging constraint "a_pos" with inherited definition
NOTICE: DDL test: type alter table, tag ALTER TABLE
NOTICE: subcommand: type ADD CONSTRAINT (and recurse) desc constraint a_pos on table parent
+<<<<<<< HEAD
+=======
CREATE TABLE part (
a int
) PARTITION BY RANGE (a);
-NOTICE: DDL test: type simple, tag CREATE TABLE
+ERROR: syntax error at or near "<<<<<<<"
+LINE 1: <<<<<<< HEAD
+ ^
CREATE TABLE part1 PARTITION OF part FOR VALUES FROM (1) to (100);
-NOTICE: DDL test: type simple, tag CREATE TABLE
+ERROR: relation "part" does not exist
CREATE TABLE part2 (a int);
... |
|
macOS - Sequoia - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/modules/test_ddl_deparse/expected/alter_table.out /Users/admin/pgsql/build/testrun/...
--- /Users/admin/pgsql/src/test/modules/test_ddl_deparse/expected/alter_table.out 2025-12-13 06:27:11
+++ /Users/admin/pgsql/build/testrun/test_ddl_deparse/regress/results/alter_table.out 2025-12-13 06:32:48
@@ -41,41 +41,41 @@
NOTICE: merging constraint "a_pos" with inherited definition
NOTICE: DDL test: type alter table, tag ALTER TABLE
NOTICE: subcommand: type ADD CONSTRAINT (and recurse) desc constraint a_pos on table parent
+<<<<<<< HEAD
+=======
CREATE TABLE part (
a int
) PARTITION BY RANGE (a);
-NOTICE: DDL test: type simple, tag CREATE TABLE
+ERROR: syntax error at or near "<<<<<<<"
+LINE 1: <<<<<<< HEAD
+ ^
CREATE TABLE part1 PARTITION OF part FOR VALUES FROM (1) to (100);
-NOTICE: DDL test: type simple, tag CREATE TABLE
+ERROR: relation "part" does not exist
CREATE TABLE part2 (a int);
... |
|
Linux - Debian Trixie - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/modules/test_ddl_deparse/expected/alter_table.out /tmp/cirrus-ci-build/build/test...
--- /tmp/cirrus-ci-build/src/test/modules/test_ddl_deparse/expected/alter_table.out 2025-12-13 06:27:04.870622738 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_ddl_deparse/regress/results/alter_table.out 2025-12-13 06:33:54.758731419 +0...
@@ -41,41 +41,41 @@
NOTICE: merging constraint "a_pos" with inherited definition
NOTICE: DDL test: type alter table, tag ALTER TABLE
NOTICE: subcommand: type ADD CONSTRAINT (and recurse) desc constraint a_pos on table parent
+<<<<<<< HEAD
+=======
CREATE TABLE part (
a int
) PARTITION BY RANGE (a);
-NOTICE: DDL test: type simple, tag CREATE TABLE
+ERROR: syntax error at or near "<<<<<<<"
+LINE 1: <<<<<<< HEAD
+ ^
CREATE TABLE part1 PARTITION OF part FOR VALUES FROM (1) to (100);
-NOTICE: DDL test: type simple, tag CREATE TABLE
+ERROR: relation "part" does not exist
CREATE TABLE part2 (a int);
... |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/modules/test_ddl_deparse/expected/alter_table.out /tmp/cirrus-ci-build/build/test...
--- /tmp/cirrus-ci-build/src/test/modules/test_ddl_deparse/expected/alter_table.out 2025-12-13 06:27:05.029718000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_ddl_deparse/regress/results/alter_table.out 2025-12-13 06:31:41.452220000 +0...
@@ -41,41 +41,41 @@
NOTICE: merging constraint "a_pos" with inherited definition
NOTICE: DDL test: type alter table, tag ALTER TABLE
NOTICE: subcommand: type ADD CONSTRAINT (and recurse) desc constraint a_pos on table parent
+<<<<<<< HEAD
+=======
CREATE TABLE part (
a int
) PARTITION BY RANGE (a);
-NOTICE: DDL test: type simple, tag CREATE TABLE
+ERROR: syntax error at or near "<<<<<<<"
+LINE 1: <<<<<<< HEAD
+ ^
CREATE TABLE part1 PARTITION OF part FOR VALUES FROM (1) to (100);
-NOTICE: DDL test: type simple, tag CREATE TABLE
+ERROR: relation "part" does not exist
CREATE TABLE part2 (a int);
... |
|
OpenBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/modules/test_ddl_deparse/expected/alter_table.out /home/postgres/postgres/buil...
--- /home/postgres/postgres/src/test/modules/test_ddl_deparse/expected/alter_table.out Sat Dec 13 06:27:25 2025
+++ /home/postgres/postgres/build/testrun/test_ddl_deparse/regress/results/alter_table.out Sat Dec 13 06:33:34 2025
@@ -41,41 +41,41 @@
NOTICE: merging constraint "a_pos" with inherited definition
NOTICE: DDL test: type alter table, tag ALTER TABLE
NOTICE: subcommand: type ADD CONSTRAINT (and recurse) desc constraint a_pos on table parent
+<<<<<<< HEAD
+=======
CREATE TABLE part (
a int
) PARTITION BY RANGE (a);
-NOTICE: DDL test: type simple, tag CREATE TABLE
+ERROR: syntax error at or near "<<<<<<<"
+LINE 1: <<<<<<< HEAD
+ ^
CREATE TABLE part1 PARTITION OF part FOR VALUES FROM (1) to (100);
-NOTICE: DDL test: type simple, tag CREATE TABLE
+ERROR: relation "part" does not exist
CREATE TABLE part2 (a int);
... |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/modules/test_ddl_deparse/expected/alter_table.out /home/postgres/postgres/buil...
--- /home/postgres/postgres/src/test/modules/test_ddl_deparse/expected/alter_table.out 2025-12-13 06:27:14.873472078 +00...
+++ /home/postgres/postgres/build/testrun/test_ddl_deparse/regress/results/alter_table.out 2025-12-13 06:31:05.503391835...
@@ -41,41 +41,41 @@
NOTICE: merging constraint "a_pos" with inherited definition
NOTICE: DDL test: type alter table, tag ALTER TABLE
NOTICE: subcommand: type ADD CONSTRAINT (and recurse) desc constraint a_pos on table parent
+<<<<<<< HEAD
+=======
CREATE TABLE part (
a int
) PARTITION BY RANGE (a);
-NOTICE: DDL test: type simple, tag CREATE TABLE
+ERROR: syntax error at or near "<<<<<<<"
+LINE 1: <<<<<<< HEAD
+ ^
CREATE TABLE part1 PARTITION OF part FOR VALUES FROM (1) to (100);
-NOTICE: DDL test: type simple, tag CREATE TABLE
+ERROR: relation "part" does not exist
CREATE TABLE part2 (a int);
... |
|
Linux - Debian Trixie - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/modules/test_ddl_deparse/expected/alter_table.out /tmp/cirrus-ci-build/src/test/m...
--- /tmp/cirrus-ci-build/src/test/modules/test_ddl_deparse/expected/alter_table.out 2025-12-13 06:27:02.697891827 +0000
+++ /tmp/cirrus-ci-build/src/test/modules/test_ddl_deparse/results/alter_table.out 2025-12-13 06:33:01.146145229 +0000
@@ -41,41 +41,41 @@
NOTICE: merging constraint "a_pos" with inherited definition
NOTICE: DDL test: type alter table, tag ALTER TABLE
NOTICE: subcommand: type ADD CONSTRAINT (and recurse) desc constraint a_pos on table parent
+<<<<<<< HEAD
+=======
CREATE TABLE part (
a int
) PARTITION BY RANGE (a);
-NOTICE: DDL test: type simple, tag CREATE TABLE
+ERROR: syntax error at or near "<<<<<<<"
+LINE 1: <<<<<<< HEAD
+ ^
CREATE TABLE part1 PARTITION OF part FOR VALUES FROM (1) to (100);
-NOTICE: DDL test: type simple, tag CREATE TABLE
+ERROR: relation "part" does not exist
CREATE TABLE part2 (a int);
... |
| 57/6252 |
Proposal: Conflict log history table for Logical Replication |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/subscription.out C:/cirrus/build/testrun/pg_upgrade/002...
--- C:/cirrus/src/test/regress/expected/subscription.out 2025-12-13 02:05:46.752532500 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/subscription.out 2025-12-13 02:09:40.645491400 +0000
@@ -550,14 +550,13 @@
SELECT format_type(atttypid, atttypmod) FROM pg_attribute WHERE attrelid = 'public.regress_conflict_log1'::regclass AND...
format_type
-------------
- json
-(1 row)
+(0 rows)
\dRs+
- ...
- Name | Owner | Enabled | Publication | Binary | Streaming | Two-phase commit | D...
-------------------------+---------------------------+---------+-------------+--------+-----------+------------------+--...
- regress_conflict_test1 | regress_subscription_user | f | {testpub} | f | parallel | d | f...
+ ...
+ Name | Owner | Enabled | Publication | Binary | Streaming | Two-phase commit | D...
+------------------------+---------------------------+---------+-------------+--------+-----------+------------------+--...
+ regress_conflict_test1 | regress_subscription_user | f | {testpub} | f | parallel | d | f...
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/subscription.out C:/cirrus/build/testrun/recovery/027_s...
--- C:/cirrus/src/test/regress/expected/subscription.out 2025-12-13 02:05:46.752532500 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/subscription.out 2025-12-13 02:12:35.599093000 +000...
@@ -550,14 +550,13 @@
SELECT format_type(atttypid, atttypmod) FROM pg_attribute WHERE attrelid = 'public.regress_conflict_log1'::regclass AND...
format_type
-------------
- json
-(1 row)
+(0 rows)
\dRs+
- ...
- Name | Owner | Enabled | Publication | Binary | Streaming | Two-phase commit | D...
-------------------------+---------------------------+---------+-------------+--------+-----------+------------------+--...
- regress_conflict_test1 | regress_subscription_user | f | {testpub} | f | parallel | d | f...
+ ...
+ Name | Owner | Enabled | Publication | Binary | Streaming | Two-phase commit | D...
+------------------------+---------------------------+---------+-------------+--------+-----------+------------------+--...
+ regress_conflict_test1 | regress_subscription_user | f | {testpub} | f | parallel | d | f...
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/subscription.out C:/cirrus/build/testrun/regress/regres...
--- C:/cirrus/src/test/regress/expected/subscription.out 2025-12-13 02:05:46.752532500 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/subscription.out 2025-12-13 02:09:33.180155400 +0000
@@ -550,14 +550,13 @@
SELECT format_type(atttypid, atttypmod) FROM pg_attribute WHERE attrelid = 'public.regress_conflict_log1'::regclass AND...
format_type
-------------
- json
-(1 row)
+(0 rows)
\dRs+
- ...
- Name | Owner | Enabled | Publication | Binary | Streaming | Two-phase commit | D...
-------------------------+---------------------------+---------+-------------+--------+-----------+------------------+--...
- regress_conflict_test1 | regress_subscription_user | f | {testpub} | f | parallel | d | f...
+ ...
+ Name | Owner | Enabled | Publication | Binary | Streaming | Two-phase commit | D...
+------------------------+---------------------------+---------+-------------+--------+-----------+------------------+--...
+ regress_conflict_test1 | regress_subscription_user | f | {testpub} | f | parallel | d | f...
... |
|
Windows - Server 2022, MinGW64 - Meson |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/subscription.out C:/cirrus/build/testrun/pg_upgrade/002...
--- C:/cirrus/src/test/regress/expected/subscription.out 2025-12-13 02:05:53.546425900 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/subscription.out 2025-12-13 02:11:11.625446100 +0000
@@ -550,14 +550,13 @@
SELECT format_type(atttypid, atttypmod) FROM pg_attribute WHERE attrelid = 'public.regress_conflict_log1'::regclass AND...
format_type
-------------
- json
-(1 row)
+(0 rows)
\dRs+
- ...
- Name | Owner | Enabled | Publication | Binary | Streaming | Two-phase commit | D...
-------------------------+---------------------------+---------+-------------+--------+-----------+------------------+--...
- regress_conflict_test1 | regress_subscription_user | f | {testpub} | f | parallel | d | f...
+ ...
+ Name | Owner | Enabled | Publication | Binary | Streaming | Two-phase commit | D...
+------------------------+---------------------------+---------+-------------+--------+-----------+------------------+--...
+ regress_conflict_test1 | regress_subscription_user | f | {testpub} | f | parallel | d | f...
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/subscription.out C:/cirrus/build/testrun/recovery/027_s...
--- C:/cirrus/src/test/regress/expected/subscription.out 2025-12-13 02:05:53.546425900 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/subscription.out 2025-12-13 02:13:54.428108800 +000...
@@ -550,14 +550,13 @@
SELECT format_type(atttypid, atttypmod) FROM pg_attribute WHERE attrelid = 'public.regress_conflict_log1'::regclass AND...
format_type
-------------
- json
-(1 row)
+(0 rows)
\dRs+
- ...
- Name | Owner | Enabled | Publication | Binary | Streaming | Two-phase commit | D...
-------------------------+---------------------------+---------+-------------+--------+-----------+------------------+--...
- regress_conflict_test1 | regress_subscription_user | f | {testpub} | f | parallel | d | f...
+ ...
+ Name | Owner | Enabled | Publication | Binary | Streaming | Two-phase commit | D...
+------------------------+---------------------------+---------+-------------+--------+-----------+------------------+--...
+ regress_conflict_test1 | regress_subscription_user | f | {testpub} | f | parallel | d | f...
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/subscription.out C:/cirrus/build/testrun/regress/regres...
--- C:/cirrus/src/test/regress/expected/subscription.out 2025-12-13 02:05:53.546425900 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/subscription.out 2025-12-13 02:11:07.851030600 +0000
@@ -550,14 +550,13 @@
SELECT format_type(atttypid, atttypmod) FROM pg_attribute WHERE attrelid = 'public.regress_conflict_log1'::regclass AND...
format_type
-------------
- json
-(1 row)
+(0 rows)
\dRs+
- ...
- Name | Owner | Enabled | Publication | Binary | Streaming | Two-phase commit | D...
-------------------------+---------------------------+---------+-------------+--------+-----------+------------------+--...
- regress_conflict_test1 | regress_subscription_user | f | {testpub} | f | parallel | d | f...
+ ...
+ Name | Owner | Enabled | Publication | Binary | Streaming | Two-phase commit | D...
+------------------------+---------------------------+---------+-------------+--------+-----------+------------------+--...
+ regress_conflict_test1 | regress_subscription_user | f | {testpub} | f | parallel | d | f...
... |
|
macOS - Sequoia - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/subscription.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_p...
--- /Users/admin/pgsql/src/test/regress/expected/subscription.out 2025-12-13 02:05:34
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/subscription.out 2025-12-13 02:08:02
@@ -550,14 +550,13 @@
SELECT format_type(atttypid, atttypmod) FROM pg_attribute WHERE attrelid = 'public.regress_conflict_log1'::regclass AND...
format_type
-------------
- json
-(1 row)
+(0 rows)
\dRs+
- ...
- Name | Owner | Enabled | Publication | Binary | Streaming | Two-phase commit | D...
-------------------------+---------------------------+---------+-------------+--------+-----------+------------------+--...
- regress_conflict_test1 | regress_subscription_user | f | {testpub} | f | parallel | d | f...
+ ...
+ Name | Owner | Enabled | Publication | Binary | Streaming | Two-phase commit | D...
+------------------------+---------------------------+---------+-------------+--------+-----------+------------------+--...
+ regress_conflict_test1 | regress_subscription_user | f | {testpub} | f | parallel | d | f...
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/subscription.out /Users/admin/pgsql/build/testrun/recovery/027_str...
--- /Users/admin/pgsql/src/test/regress/expected/subscription.out 2025-12-13 02:05:34
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/subscription.out 2025-12-13 02:09:04
@@ -550,14 +550,13 @@
SELECT format_type(atttypid, atttypmod) FROM pg_attribute WHERE attrelid = 'public.regress_conflict_log1'::regclass AND...
format_type
-------------
- json
-(1 row)
+(0 rows)
\dRs+
- ...
- Name | Owner | Enabled | Publication | Binary | Streaming | Two-phase commit | D...
-------------------------+---------------------------+---------+-------------+--------+-----------+------------------+--...
- regress_conflict_test1 | regress_subscription_user | f | {testpub} | f | parallel | d | f...
+ ...
+ Name | Owner | Enabled | Publication | Binary | Streaming | Two-phase commit | D...
+------------------------+---------------------------+---------+-------------+--------+-----------+------------------+--...
+ regress_conflict_test1 | regress_subscription_user | f | {testpub} | f | parallel | d | f...
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/subscription.out /Users/admin/pgsql/build/testrun/regress/regress/...
--- /Users/admin/pgsql/src/test/regress/expected/subscription.out 2025-12-13 02:05:34
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/subscription.out 2025-12-13 02:08:03
@@ -550,14 +550,13 @@
SELECT format_type(atttypid, atttypmod) FROM pg_attribute WHERE attrelid = 'public.regress_conflict_log1'::regclass AND...
format_type
-------------
- json
-(1 row)
+(0 rows)
\dRs+
- ...
- Name | Owner | Enabled | Publication | Binary | Streaming | Two-phase commit | D...
-------------------------+---------------------------+---------+-------------+--------+-----------+------------------+--...
- regress_conflict_test1 | regress_subscription_user | f | {testpub} | f | parallel | d | f...
+ ...
+ Name | Owner | Enabled | Publication | Binary | Streaming | Two-phase commit | D...
+------------------------+---------------------------+---------+-------------+--------+-----------+------------------+--...
+ regress_conflict_test1 | regress_subscription_user | f | {testpub} | f | parallel | d | f...
... |
|
Linux - Debian Trixie - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/subscription.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/0...
--- /tmp/cirrus-ci-build/src/test/regress/expected/subscription.out 2025-12-13 02:05:41.756421352 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/subscription.out 2025-12-13 02:09:35.95748...
@@ -550,14 +550,13 @@
SELECT format_type(atttypid, atttypmod) FROM pg_attribute WHERE attrelid = 'public.regress_conflict_log1'::regclass AND...
format_type
-------------
- json
-(1 row)
+(0 rows)
\dRs+
- ...
- Name | Owner | Enabled | Publication | Binary | Streaming | Two-phase commit | D...
-------------------------+---------------------------+---------+-------------+--------+-----------+------------------+--...
- regress_conflict_test1 | regress_subscription_user | f | {testpub} | f | parallel | d | f...
+ ...
+ Name | Owner | Enabled | Publication | Binary | Streaming | Two-phase commit | D...
+------------------------+---------------------------+---------+-------------+--------+-----------+------------------+--...
+ regress_conflict_test1 | regress_subscription_user | f | {testpub} | f | parallel | d | f...
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/subscription.out /tmp/cirrus-ci-build/build/testrun/recovery/027...
--- /tmp/cirrus-ci-build/src/test/regress/expected/subscription.out 2025-12-13 02:05:41.756421352 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/subscription.out 2025-12-13 02:10:59.553...
@@ -550,14 +550,13 @@
SELECT format_type(atttypid, atttypmod) FROM pg_attribute WHERE attrelid = 'public.regress_conflict_log1'::regclass AND...
format_type
-------------
- json
-(1 row)
+(0 rows)
\dRs+
- ...
- Name | Owner | Enabled | Publication | Binary | Streaming | Two-phase commit | D...
-------------------------+---------------------------+---------+-------------+--------+-----------+------------------+--...
- regress_conflict_test1 | regress_subscription_user | f | {testpub} | f | parallel | d | f...
+ ...
+ Name | Owner | Enabled | Publication | Binary | Streaming | Two-phase commit | D...
+------------------------+---------------------------+---------+-------------+--------+-----------+------------------+--...
+ regress_conflict_test1 | regress_subscription_user | f | {testpub} | f | parallel | d | f...
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/subscription.out /tmp/cirrus-ci-build/build/testrun/regress/regr...
--- /tmp/cirrus-ci-build/src/test/regress/expected/subscription.out 2025-12-13 02:05:41.756421352 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/subscription.out 2025-12-13 02:09:35.993488205 +0000
@@ -550,14 +550,13 @@
SELECT format_type(atttypid, atttypmod) FROM pg_attribute WHERE attrelid = 'public.regress_conflict_log1'::regclass AND...
format_type
-------------
- json
-(1 row)
+(0 rows)
\dRs+
- ...
- Name | Owner | Enabled | Publication | Binary | Streaming | Two-phase commit | D...
-------------------------+---------------------------+---------+-------------+--------+-----------+------------------+--...
- regress_conflict_test1 | regress_subscription_user | f | {testpub} | f | parallel | d | f...
+ ...
+ Name | Owner | Enabled | Publication | Binary | Streaming | Two-phase commit | D...
+------------------------+---------------------------+---------+-------------+--------+-----------+------------------+--...
+ regress_conflict_test1 | regress_subscription_user | f | {testpub} | f | parallel | d | f...
... |
|
Linux - Debian Trixie - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/subscription.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_che...
--- /tmp/cirrus-ci-build/src/test/regress/expected/subscription.out 2025-12-13 02:05:54.152447733 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/subscription.out 2025-12-13 02:13:39.812279073 +0000
@@ -550,14 +550,13 @@
SELECT format_type(atttypid, atttypmod) FROM pg_attribute WHERE attrelid = 'public.regress_conflict_log1'::regclass AND...
format_type
-------------
- json
-(1 row)
+(0 rows)
\dRs+
- ...
- Name | Owner | Enabled | Publication | Binary | Streaming | Two-phase commit | D...
-------------------------+---------------------------+---------+-------------+--------+-----------+------------------+--...
- regress_conflict_test1 | regress_subscription_user | f | {testpub} | f | parallel | d | f...
+ ...
+ Name | Owner | Enabled | Publication | Binary | Streaming | Two-phase commit | D...
+------------------------+---------------------------+---------+-------------+--------+-----------+------------------+--...
+ regress_conflict_test1 | regress_subscription_user | f | {testpub} | f | parallel | d | f...
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/subscription.out /tmp/cirrus-ci-build/src/test/recovery/tmp_chec...
--- /tmp/cirrus-ci-build/src/test/regress/expected/subscription.out 2025-12-13 02:05:54.152447733 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/subscription.out 2025-12-13 02:14:51.120358350 +0000
@@ -550,14 +550,13 @@
SELECT format_type(atttypid, atttypmod) FROM pg_attribute WHERE attrelid = 'public.regress_conflict_log1'::regclass AND...
format_type
-------------
- json
-(1 row)
+(0 rows)
\dRs+
- ...
- Name | Owner | Enabled | Publication | Binary | Streaming | Two-phase commit | D...
-------------------------+---------------------------+---------+-------------+--------+-----------+------------------+--...
- regress_conflict_test1 | regress_subscription_user | f | {testpub} | f | parallel | d | f...
+ ...
+ Name | Owner | Enabled | Publication | Binary | Streaming | Two-phase commit | D...
+------------------------+---------------------------+---------+-------------+--------+-----------+------------------+--...
+ regress_conflict_test1 | regress_subscription_user | f | {testpub} | f | parallel | d | f...
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/subscription.out /tmp/cirrus-ci-build/src/test/regress/results/s...
--- /tmp/cirrus-ci-build/src/test/regress/expected/subscription.out 2025-12-13 02:05:54.152447733 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/subscription.out 2025-12-13 02:10:38.859878182 +0000
@@ -550,14 +550,13 @@
SELECT format_type(atttypid, atttypmod) FROM pg_attribute WHERE attrelid = 'public.regress_conflict_log1'::regclass AND...
format_type
-------------
- json
-(1 row)
+(0 rows)
\dRs+
- ...
- Name | Owner | Enabled | Publication | Binary | Streaming | Two-phase commit | D...
-------------------------+---------------------------+---------+-------------+--------+-----------+------------------+--...
- regress_conflict_test1 | regress_subscription_user | f | {testpub} | f | parallel | d | f...
+ ...
+ Name | Owner | Enabled | Publication | Binary | Streaming | Two-phase commit | D...
+------------------------+---------------------------+---------+-------------+--------+-----------+------------------+--...
+ regress_conflict_test1 | regress_subscription_user | f | {testpub} | f | parallel | d | f...
... |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/subscription.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/0...
--- /tmp/cirrus-ci-build/src/test/regress/expected/subscription.out 2025-12-13 02:05:39.253193000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/subscription.out 2025-12-13 02:09:09.81232...
@@ -550,14 +550,13 @@
SELECT format_type(atttypid, atttypmod) FROM pg_attribute WHERE attrelid = 'public.regress_conflict_log1'::regclass AND...
format_type
-------------
- json
-(1 row)
+(0 rows)
\dRs+
- ...
- Name | Owner | Enabled | Publication | Binary | Streaming | Two-phase commit | D...
-------------------------+---------------------------+---------+-------------+--------+-----------+------------------+--...
- regress_conflict_test1 | regress_subscription_user | f | {testpub} | f | parallel | d | f...
+ ...
+ Name | Owner | Enabled | Publication | Binary | Streaming | Two-phase commit | D...
+------------------------+---------------------------+---------+-------------+--------+-----------+------------------+--...
+ regress_conflict_test1 | regress_subscription_user | f | {testpub} | f | parallel | d | f...
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/subscription.out /tmp/cirrus-ci-build/build/testrun/recovery/027...
--- /tmp/cirrus-ci-build/src/test/regress/expected/subscription.out 2025-12-13 02:05:39.253193000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/subscription.out 2025-12-13 02:10:24.842...
@@ -550,14 +550,13 @@
SELECT format_type(atttypid, atttypmod) FROM pg_attribute WHERE attrelid = 'public.regress_conflict_log1'::regclass AND...
format_type
-------------
- json
-(1 row)
+(0 rows)
\dRs+
- ...
- Name | Owner | Enabled | Publication | Binary | Streaming | Two-phase commit | D...
-------------------------+---------------------------+---------+-------------+--------+-----------+------------------+--...
- regress_conflict_test1 | regress_subscription_user | f | {testpub} | f | parallel | d | f...
+ ...
+ Name | Owner | Enabled | Publication | Binary | Streaming | Two-phase commit | D...
+------------------------+---------------------------+---------+-------------+--------+-----------+------------------+--...
+ regress_conflict_test1 | regress_subscription_user | f | {testpub} | f | parallel | d | f...
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/subscription.out /tmp/cirrus-ci-build/build/testrun/regress/regr...
--- /tmp/cirrus-ci-build/src/test/regress/expected/subscription.out 2025-12-13 02:05:39.253193000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/subscription.out 2025-12-13 02:09:03.692571000 +0000
@@ -550,14 +550,13 @@
SELECT format_type(atttypid, atttypmod) FROM pg_attribute WHERE attrelid = 'public.regress_conflict_log1'::regclass AND...
format_type
-------------
- json
-(1 row)
+(0 rows)
\dRs+
- ...
- Name | Owner | Enabled | Publication | Binary | Streaming | Two-phase commit | D...
-------------------------+---------------------------+---------+-------------+--------+-----------+------------------+--...
- regress_conflict_test1 | regress_subscription_user | f | {testpub} | f | parallel | d | f...
+ ...
+ Name | Owner | Enabled | Publication | Binary | Streaming | Two-phase commit | D...
+------------------------+---------------------------+---------+-------------+--------+-----------+------------------+--...
+ regress_conflict_test1 | regress_subscription_user | f | {testpub} | f | parallel | d | f...
... |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/subscription.out /home/postgres/postgres/build/testrun/pg_upg...
--- /home/postgres/postgres/src/test/regress/expected/subscription.out 2025-12-13 02:06:05.200030951 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/subscription.out 2025-12-13 02:08:53.35...
@@ -550,14 +550,13 @@
SELECT format_type(atttypid, atttypmod) FROM pg_attribute WHERE attrelid = 'public.regress_conflict_log1'::regclass AND...
format_type
-------------
- json
-(1 row)
+(0 rows)
\dRs+
- ...
- Name | Owner | Enabled | Publication | Binary | Streaming | Two-phase commit | D...
-------------------------+---------------------------+---------+-------------+--------+-----------+------------------+--...
- regress_conflict_test1 | regress_subscription_user | f | {testpub} | f | parallel | d | f...
+ ...
+ Name | Owner | Enabled | Publication | Binary | Streaming | Two-phase commit | D...
+------------------------+---------------------------+---------+-------------+--------+-----------+------------------+--...
+ regress_conflict_test1 | regress_subscription_user | f | {testpub} | f | parallel | d | f...
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/subscription.out /home/postgres/postgres/build/testrun/recove...
--- /home/postgres/postgres/src/test/regress/expected/subscription.out 2025-12-13 02:06:05.200030951 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/subscription.out 2025-12-13 02:09:37....
@@ -550,14 +550,13 @@
SELECT format_type(atttypid, atttypmod) FROM pg_attribute WHERE attrelid = 'public.regress_conflict_log1'::regclass AND...
format_type
-------------
- json
-(1 row)
+(0 rows)
\dRs+
- ...
- Name | Owner | Enabled | Publication | Binary | Streaming | Two-phase commit | D...
-------------------------+---------------------------+---------+-------------+--------+-----------+------------------+--...
- regress_conflict_test1 | regress_subscription_user | f | {testpub} | f | parallel | d | f...
+ ...
+ Name | Owner | Enabled | Publication | Binary | Streaming | Two-phase commit | D...
+------------------------+---------------------------+---------+-------------+--------+-----------+------------------+--...
+ regress_conflict_test1 | regress_subscription_user | f | {testpub} | f | parallel | d | f...
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/subscription.out /home/postgres/postgres/build/testrun/regres...
--- /home/postgres/postgres/src/test/regress/expected/subscription.out 2025-12-13 02:06:05.200030951 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/subscription.out 2025-12-13 02:08:53.843670190 +0000
@@ -550,14 +550,13 @@
SELECT format_type(atttypid, atttypmod) FROM pg_attribute WHERE attrelid = 'public.regress_conflict_log1'::regclass AND...
format_type
-------------
- json
-(1 row)
+(0 rows)
\dRs+
- ...
- Name | Owner | Enabled | Publication | Binary | Streaming | Two-phase commit | D...
-------------------------+---------------------------+---------+-------------+--------+-----------+------------------+--...
- regress_conflict_test1 | regress_subscription_user | f | {testpub} | f | parallel | d | f...
+ ...
+ Name | Owner | Enabled | Publication | Binary | Streaming | Two-phase commit | D...
+------------------------+---------------------------+---------+-------------+--------+-----------+------------------+--...
+ regress_conflict_test1 | regress_subscription_user | f | {testpub} | f | parallel | d | f...
... |
|
OpenBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/subscription.out /home/postgres/postgres/build/testrun/pg_upg...
--- /home/postgres/postgres/src/test/regress/expected/subscription.out Sat Dec 13 02:05:50 2025
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/subscription.out Sat Dec 13 02:09:15 20...
@@ -550,14 +550,13 @@
SELECT format_type(atttypid, atttypmod) FROM pg_attribute WHERE attrelid = 'public.regress_conflict_log1'::regclass AND...
format_type
-------------
- json
-(1 row)
+(0 rows)
\dRs+
- ...
- Name | Owner | Enabled | Publication | Binary | Streaming | Two-phase commit | D...
-------------------------+---------------------------+---------+-------------+--------+-----------+------------------+--...
- regress_conflict_test1 | regress_subscription_user | f | {testpub} | f | parallel | d | f...
+ ...
+ Name | Owner | Enabled | Publication | Binary | Streaming | Two-phase commit | D...
+------------------------+---------------------------+---------+-------------+--------+-----------+------------------+--...
+ regress_conflict_test1 | regress_subscription_user | f | {testpub} | f | parallel | d | f...
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/subscription.out /home/postgres/postgres/build/testrun/recove...
--- /home/postgres/postgres/src/test/regress/expected/subscription.out Sat Dec 13 02:05:50 2025
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/subscription.out Sat Dec 13 02:11:07 ...
@@ -550,14 +550,13 @@
SELECT format_type(atttypid, atttypmod) FROM pg_attribute WHERE attrelid = 'public.regress_conflict_log1'::regclass AND...
format_type
-------------
- json
-(1 row)
+(0 rows)
\dRs+
- ...
- Name | Owner | Enabled | Publication | Binary | Streaming | Two-phase commit | D...
-------------------------+---------------------------+---------+-------------+--------+-----------+------------------+--...
- regress_conflict_test1 | regress_subscription_user | f | {testpub} | f | parallel | d | f...
+ ...
+ Name | Owner | Enabled | Publication | Binary | Streaming | Two-phase commit | D...
+------------------------+---------------------------+---------+-------------+--------+-----------+------------------+--...
+ regress_conflict_test1 | regress_subscription_user | f | {testpub} | f | parallel | d | f...
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/subscription.out /home/postgres/postgres/build/testrun/regres...
--- /home/postgres/postgres/src/test/regress/expected/subscription.out Sat Dec 13 02:05:50 2025
+++ /home/postgres/postgres/build/testrun/regress/regress/results/subscription.out Sat Dec 13 02:09:09 2025
@@ -550,14 +550,13 @@
SELECT format_type(atttypid, atttypmod) FROM pg_attribute WHERE attrelid = 'public.regress_conflict_log1'::regclass AND...
format_type
-------------
- json
-(1 row)
+(0 rows)
\dRs+
- ...
- Name | Owner | Enabled | Publication | Binary | Streaming | Two-phase commit | D...
-------------------------+---------------------------+---------+-------------+--------+-----------+------------------+--...
- regress_conflict_test1 | regress_subscription_user | f | {testpub} | f | parallel | d | f...
+ ...
+ Name | Owner | Enabled | Publication | Binary | Streaming | Two-phase commit | D...
+------------------------+---------------------------+---------+-------------+--------+-----------+------------------+--...
+ regress_conflict_test1 | regress_subscription_user | f | {testpub} | f | parallel | d | f...
... |
| 54/5785 |
Reduce DEBUG level of catcache refreshing messages |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/index-concurrently-upsert-predicate.out /tmp/ci...
--- /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/index-concurrently-upsert-predicate.out 2025-12-13 0...
+++ /tmp/cirrus-ci-build/build/testrun/injection_points/isolation/results/index-concurrently-upsert-predicate.out 2025-1...
@@ -104,6 +104,9 @@
(1 row)
+step s1_start_upsert: <... completed>
+step s2_start_upsert: <... completed>
+step s3_start_create_index: <... completed>
step s4_wakeup_s1:
SELECT injection_points_detach('check-exclusion-or-unique-constraint-no-conflict');
SELECT injection_points_wakeup('check-exclusion-or-unique-constraint-no-conflict');
@@ -113,11 +116,4 @@
(1 row)
-injection_points_wakeup
------------------------
-
... |
| 57/5214 |
SQL:2023 JSON simplified accessor support |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/isolation/expected/timeouts.out /home/postgres/postgres/build/testrun/isolatio...
--- /home/postgres/postgres/src/test/isolation/expected/timeouts.out 2025-12-12 22:10:29.318592113 +0000
+++ /home/postgres/postgres/build/testrun/isolation/isolation/results/timeouts.out 2025-12-12 22:13:53.861147739 +0000
@@ -11,7 +11,7 @@
step sto: SET statement_timeout = '10ms';
step locktbl: LOCK TABLE accounts; <waiting ...>
step locktbl: <... completed>
-ERROR: canceling statement due to statement timeout
+ERROR: canceling statement due to user request
starting permutation: rdtbl lto locktbl
step rdtbl: SELECT * FROM accounts; |
| 57/6300 |
Let's add a test for NLS translation of PRI* macros |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/rangetypes.out /home/postgres/postgres/build/testrun/regress/...
--- /home/postgres/postgres/src/test/regress/expected/rangetypes.out 2025-12-12 20:01:26.053666913 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/rangetypes.out 2025-12-12 20:03:36.365159620 +0000
@@ -1,2035 +1,2 @@
--- Tests for range data types.
---
--- test input parser
--- (type textrange was already made in test_setup.sql)
---
--- negative tests; should fail
-select ''::textrange;
-ERROR: malformed range literal: ""
-LINE 1: select ''::textrange;
- ^
-DETAIL: Missing left parenthesis or bracket.
-select '-[a,z)'::textrange;
-ERROR: malformed range literal: "-[a,z)"
-LINE 1: select '-[a,z)'::textrange;
- ^
-DETAIL: Missing left parenthesis or bracket.
... |
| 57/6299 |
New grouping strategy - Index Aggregate |
|
Linux - Debian Trixie - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/partition_aggregate.out /tmp/cirrus-ci-build/build-32/testrun/pg...
--- /tmp/cirrus-ci-build/src/test/regress/expected/partition_aggregate.out 2025-12-12 16:39:11.696909537 +0000
+++ /tmp/cirrus-ci-build/build-32/testrun/pg_upgrade/002_pg_upgrade/data/results/partition_aggregate.out 2025-12-12 16:5...
@@ -1010,7 +1010,7 @@
--------------------------------------------------------------------
Sort
Sort Key: pagg_tab_m.a, (sum(pagg_tab_m.b)), (avg(pagg_tab_m.c))
- -> Finalize IndexAggregate
+ -> Finalize HashAggregate
Group Key: pagg_tab_m.a
Filter: (avg(pagg_tab_m.c) < '22'::numeric)
-> Append |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/partition_aggregate.out /tmp/cirrus-ci-build/build-32/testrun/re...
--- /tmp/cirrus-ci-build/src/test/regress/expected/partition_aggregate.out 2025-12-12 16:39:11.696909537 +0000
+++ /tmp/cirrus-ci-build/build-32/testrun/recovery/027_stream_regress/data/results/partition_aggregate.out 2025-12-12 16...
@@ -1010,7 +1010,7 @@
--------------------------------------------------------------------
Sort
Sort Key: pagg_tab_m.a, (sum(pagg_tab_m.b)), (avg(pagg_tab_m.c))
- -> Finalize IndexAggregate
+ -> Finalize HashAggregate
Group Key: pagg_tab_m.a
Filter: (avg(pagg_tab_m.c) < '22'::numeric)
-> Append |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/partition_aggregate.out /tmp/cirrus-ci-build/build-32/testrun/re...
--- /tmp/cirrus-ci-build/src/test/regress/expected/partition_aggregate.out 2025-12-12 16:39:11.696909537 +0000
+++ /tmp/cirrus-ci-build/build-32/testrun/regress/regress/results/partition_aggregate.out 2025-12-12 16:50:52.912283525 ...
@@ -1010,7 +1010,7 @@
--------------------------------------------------------------------
Sort
Sort Key: pagg_tab_m.a, (sum(pagg_tab_m.b)), (avg(pagg_tab_m.c))
- -> Finalize IndexAggregate
+ -> Finalize HashAggregate
Group Key: pagg_tab_m.a
Filter: (avg(pagg_tab_m.c) < '22'::numeric)
-> Append |
|
OpenBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/brin.out /home/postgres/postgres/build/testrun/pg_upgrade/002...
--- /home/postgres/postgres/src/test/regress/expected/brin.out Fri Dec 12 16:39:26 2025
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/brin.out Fri Dec 12 16:43:36 2025
@@ -539,53 +539,10 @@
-- vacuum actually removes the TOAST rows. Creating an index concurrently
-- is a one way to achieve that, because it does exactly such wait.
CREATE INDEX CONCURRENTLY brin_test_temp_idx ON brintest_3(a);
-DROP INDEX brin_test_temp_idx;
--- vacuum the table, to discard TOAST data
-VACUUM brintest_3;
--- retry insert with a different random-looking (but deterministic) value
--- the value is different, and so should replace either min or max in the
--- brin summary
-WITH rand_value AS (SELECT string_agg(fipshash((-i)::text),'') AS val FROM generate_series(1,60) s(i))
-INSERT INTO brintest_3
-SELECT val, val, val, val FROM rand_value;
--- now try some queries, accessing the brin index
-SET enable_seqscan = off;
-EXPLAIN (COSTS OFF)
-SELECT * FROM brintest_3 WHERE b < '0';
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/brin.out /home/postgres/postgres/build/testrun/recovery/027_s...
--- /home/postgres/postgres/src/test/regress/expected/brin.out Fri Dec 12 16:39:26 2025
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/brin.out Fri Dec 12 16:45:17 2025
@@ -363,229 +363,10 @@
END LOOP;
END;
$x$;
-RESET enable_seqscan;
-RESET enable_bitmapscan;
-INSERT INTO brintest SELECT
- repeat(stringu1, 42)::bytea,
- substr(stringu1, 1, 1)::"char",
- stringu1::name, 142857 * tenthous,
- thousand,
- twothousand,
- repeat(stringu1, 42),
- unique1::oid,
- format('(%s,%s)', tenthous, twenty)::tid,
- (four + 1.0)/(hundred+1),
- odd::float8 / (tenthous + 1),
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/brin.out /home/postgres/postgres/build/testrun/regress/regres...
--- /home/postgres/postgres/src/test/regress/expected/brin.out Fri Dec 12 16:39:26 2025
+++ /home/postgres/postgres/build/testrun/regress/regress/results/brin.out Fri Dec 12 16:43:25 2025
@@ -588,4 +588,10 @@
CREATE INDEX brin_insert_optimization_idx ON brin_insert_optimization USING brin (a);
UPDATE brin_insert_optimization SET a = a;
REINDEX INDEX CONCURRENTLY brin_insert_optimization_idx;
-DROP TABLE brin_insert_optimization;
+WARNING: terminating connection because of crash of another server process
+DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because anothe...
+HINT: In a moment you should be able to reconnect to the database and repeat your command.
+server closed the connection unexpectedly
+ This probably means the server terminated abnormally
+ before or while processing the request.
+connection to server was lost
diff -U3 /home/postgres/postgres/src/test/regress/expected/gist.out /home/postgres/postgres/build/testrun/regress/regres...
--- /home/postgres/postgres/src/test/regress/expected/gist.out Fri Dec 12 16:39:26 2025
+++ /home/postgres/postgres/build/testrun/regress/regress/results/gist.out Fri Dec 12 16:43:25 2025
@@ -390,14 +390,10 @@
-- Force an index build using buffering.
... |
| 57/5692 |
Create DATA dump objects for partitioned tables too |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/index-concurrently-upsert-predicate.out /tmp/ci...
--- /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/index-concurrently-upsert-predicate.out 2025-12-12 1...
+++ /tmp/cirrus-ci-build/build/testrun/injection_points/isolation/results/index-concurrently-upsert-predicate.out 2025-1...
@@ -90,20 +90,14 @@
(1 row)
+step s1_start_upsert: <... completed>
+step s2_start_upsert: <... completed>
+step s3_start_create_index: <... completed>
step s4_wakeup_s2:
SELECT injection_points_detach('exec-insert-before-insert-speculative');
SELECT injection_points_wakeup('exec-insert-before-insert-speculative');
-injection_points_detach
------------------------
-
-(1 row)
-
-injection_points_wakeup
... |
| 57/6253 |
Visibility bug in tuple lock |
|
Linux - Debian Trixie - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/heap_lock_update.out /tmp/cirrus-ci-build/build...
--- /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/heap_lock_update.out 2025-12-12 13:43:54.922722781 +...
+++ /tmp/cirrus-ci-build/build-32/testrun/injection_points/isolation/results/heap_lock_update.out 2025-12-12 13:56:00.50...
@@ -10,14 +10,14 @@
insert into t values (453) returning ctid; -- Should be (2,1)
update t set id = 454 where id = 453 returning ctid;
-ctid
------
-(2,1)
+ctid
+-------
+(1,199)
(1 row)
-ctid
------
-(2,2)
+ctid
+-------
... |
| 57/5623 |
Make numeric type accessible to third-party code. |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/foreign_key.out /home/postgres/postgres/build/testrun/pg_upgr...
--- /home/postgres/postgres/src/test/regress/expected/foreign_key.out 2025-12-12 12:47:36.050041571 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/foreign_key.out 2025-12-12 12:49:39.363...
@@ -1,3459 +1 @@
---
--- FOREIGN KEY
---
--- NOT ENFORCED
---
--- First test, check and cascade
---
-CREATE TABLE PKTABLE ( ptest1 int PRIMARY KEY, ptest2 text );
-CREATE TABLE FKTABLE ( ftest1 int CONSTRAINT fktable_ftest1_fkey REFERENCES PKTABLE MATCH FULL ON DELETE CASCADE ON UPD...
- ftest2 int );
--- Inserting into the foreign key table will not result in an error, even if
--- there is no matching key in the referenced table.
-INSERT INTO FKTABLE VALUES (1, 2);
-INSERT INTO FKTABLE VALUES (2, 3);
--- Check FKTABLE
-SELECT * FROM FKTABLE;
... |
| 57/6210 |
Move instrumentation structs |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/modules/injection_points/expected/reindex-concurrently-upsert-on-constraint.ou...
--- /home/postgres/postgres/src/test/modules/injection_points/expected/reindex-concurrently-upsert-on-constraint.out 202...
+++ /home/postgres/postgres/build/testrun/injection_points/isolation/results/reindex-concurrently-upsert-on-constraint.o...
@@ -29,7 +29,7 @@
<waiting ...>
step s1_start_upsert:
INSERT INTO test.tbl VALUES (13, now()) ON CONFLICT ON CONSTRAINT tbl_pkey DO UPDATE SET updated_at = now();
- <waiting ...>
+
step s4_wakeup_to_set_dead:
SELECT injection_points_detach('reindex-relation-concurrently-before-set-dead');
SELECT injection_points_wakeup('reindex-relation-concurrently-before-set-dead');
@@ -44,24 +44,15 @@
(1 row)
+step s3_start_reindex: <... completed>
step s2_start_upsert:
INSERT INTO test.tbl VALUES (13, now()) ON CONFLICT ON CONSTRAINT tbl_pkey DO UPDATE SET updated_at = now();
- <waiting ...>
... |
| 57/6280 |
refactor ExecInitPartitionInfo |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/modules/injection_points/expected/reindex-concurrently-upsert-on-constraint.ou...
--- /home/postgres/postgres/src/test/modules/injection_points/expected/reindex-concurrently-upsert-on-constraint.out 202...
+++ /home/postgres/postgres/build/testrun/injection_points/isolation/results/reindex-concurrently-upsert-on-constraint.o...
@@ -26,7 +26,7 @@
step s3_start_reindex:
REINDEX INDEX CONCURRENTLY test.tbl_pkey;
- <waiting ...>
+
step s1_start_upsert:
INSERT INTO test.tbl VALUES (13, now()) ON CONFLICT ON CONSTRAINT tbl_pkey DO UPDATE SET updated_at = now();
<waiting ...>
@@ -34,16 +34,7 @@
SELECT injection_points_detach('reindex-relation-concurrently-before-set-dead');
SELECT injection_points_wakeup('reindex-relation-concurrently-before-set-dead');
-injection_points_detach
------------------------
-
-(1 row)
... |
| 57/5759 |
finish TODOs in to_json_is_immutable, to_jsonb_is_immutable also add tests on it |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/index-concurrently-upsert-predicate.out /tmp/ci...
--- /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/index-concurrently-upsert-predicate.out 2025-12-11 1...
+++ /tmp/cirrus-ci-build/build/testrun/injection_points/isolation/results/index-concurrently-upsert-predicate.out 2025-1...
@@ -90,20 +90,14 @@
(1 row)
+step s1_start_upsert: <... completed>
+step s2_start_upsert: <... completed>
+step s3_start_create_index: <... completed>
step s4_wakeup_s2:
SELECT injection_points_detach('exec-insert-before-insert-speculative');
SELECT injection_points_wakeup('exec-insert-before-insert-speculative');
-injection_points_detach
------------------------
-
-(1 row)
-
-injection_points_wakeup
... |
| 57/5720 |
virtual generated column as partition key |
|
Windows - Server 2022, MinGW64 - Meson |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/amcheck/expected/check_btree.out C:/cirrus/build/testrun/amcheck/regress/...
--- C:/cirrus/contrib/amcheck/expected/check_btree.out 2025-12-11 15:06:05.635129300 +0000
+++ C:/cirrus/build/testrun/amcheck/regress/results/check_btree.out 2025-12-11 15:15:44.279289400 +0000
@@ -63,221 +63,7 @@
-- verify partitioned indexes are rejected (error)
BEGIN;
CREATE TABLE bttest_partitioned (a int, b int) PARTITION BY list (a);
-CREATE INDEX bttest_btree_partitioned_idx ON bttest_partitioned USING btree (b);
-SELECT bt_index_parent_check('bttest_btree_partitioned_idx');
-ERROR: expected index as targets for verification
-DETAIL: This operation is not supported for partitioned indexes.
-ROLLBACK;
--- normal check outside of xact
-SELECT bt_index_check('bttest_a_idx');
- bt_index_check
-----------------
-
-(1 row)
-
--- more expansive tests
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/btree_gist/expected/partitions.out C:/cirrus/build/testrun/btree_gist/reg...
--- C:/cirrus/contrib/btree_gist/expected/partitions.out 2025-12-11 15:06:05.777682400 +0000
+++ C:/cirrus/build/testrun/btree_gist/regress/results/partitions.out 2025-12-11 15:15:51.497551600 +0000
@@ -7,76 +7,7 @@
valid_at daterange,
exclude using gist (id with =, valid_at with &&)
) partition by range (id);
-create table parttmp_1_to_10 partition of parttmp for values from (1) to (10);
-create table parttmp_11_to_20 partition of parttmp for values from (11) to (20);
-insert into parttmp (id, valid_at) values
- (1, '[2000-01-01, 2000-02-01)'),
- (1, '[2000-02-01, 2000-03-01)'),
- (2, '[2000-01-01, 2000-02-01)'),
- (11, '[2000-01-01, 2000-02-01)'),
- (11, '[2000-02-01, 2000-03-01)'),
- (12, '[2000-01-01, 2000-02-01)');
-select * from parttmp order by id, valid_at;
- id | valid_at
-----+-------------------------
- 1 | [01-01-2000,02-01-2000)
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/modules/delay_execution/expected/partition-addition.out C:/cirrus/build/...
--- C:/cirrus/src/test/modules/delay_execution/expected/partition-addition.out 2025-12-11 15:06:09.971140500 +0000
+++ C:/cirrus/build/testrun/delay_execution/isolation/results/partition-addition.out 2025-12-11 15:16:24.412100700 +0000
@@ -1,27 +1,6 @@
Parsed test spec with 2 sessions
starting permutation: s2lock s1exec s2addp s2unlock
-step s2lock: SELECT pg_advisory_lock(12345);
-pg_advisory_lock
-----------------
-
-(1 row)
-
-step s1exec: LOAD 'delay_execution';
- SET delay_execution.post_planning_lock_id = 12345;
- SELECT * FROM foo WHERE a <> 1 AND a <> (SELECT 3); <waiting ...>
-step s2addp: CREATE TABLE foo2 (LIKE foo);
- ALTER TABLE foo ATTACH PARTITION foo2 FOR VALUES IN (2);
- INSERT INTO foo VALUES (2, 'ADD2');
-step s2unlock: SELECT pg_advisory_unlock(12345);
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/file_fdw/expected/file_fdw.out C:/cirrus/build/testrun/file_fdw/regress/r...
--- C:/cirrus/contrib/file_fdw/expected/file_fdw.out 2025-12-11 15:06:05.867492200 +0000
+++ C:/cirrus/build/testrun/file_fdw/regress/results/file_fdw.out 2025-12-11 15:15:56.166005300 +0000
@@ -375,182 +375,7 @@
-- declarative partitioning tests
SET ROLE regress_file_fdw_superuser;
CREATE TABLE pt (a int, b text) partition by list (a);
-\set filename :abs_srcdir '/data/list1.csv'
-CREATE FOREIGN TABLE p1 partition of pt for values in (1) SERVER file_server
-OPTIONS (format 'csv', filename :'filename', delimiter ',');
-CREATE TABLE p2 partition of pt for values in (2);
-SELECT tableoid::regclass, * FROM pt;
- tableoid | a | b
-----------+---+-----
- p1 | 1 | foo
- p1 | 1 | bar
-(2 rows)
-
-SELECT tableoid::regclass, * FROM p1;
- tableoid | a | b
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/modules/injection_points/expected/reindex-concurrently-upsert-partitione...
--- C:/cirrus/src/test/modules/injection_points/expected/reindex-concurrently-upsert-partitioned.out 2025-12-11 15:06:09...
+++ C:/cirrus/build/testrun/injection_points/isolation/results/reindex-concurrently-upsert-partitioned.out 2025-12-11 15...
@@ -1,238 +1,6 @@
Parsed test spec with 4 sessions
starting permutation: s3_setup_wait_before_set_dead s3_start_reindex s1_start_upsert s4_wakeup_to_set_dead s2_start_ups...
-injection_points_attach
------------------------
-
-(1 row)
-
-injection_points_attach
------------------------
-
-(1 row)
-
-injection_points_set_local
---------------------------
-
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/isolation/expected/detach-partition-concurrently-1.out C:/cirrus/build/t...
--- C:/cirrus/src/test/isolation/expected/detach-partition-concurrently-1.out 2025-12-11 15:06:09.804742000 +0000
+++ C:/cirrus/build/testrun/isolation/isolation/results/detach-partition-concurrently-1.out 2025-12-11 15:13:09.84716610...
@@ -1,288 +1,6 @@
Parsed test spec with 3 sessions
starting permutation: s1b s1s s2detach s1s s1c s1s
-step s1b: BEGIN;
-step s1s: SELECT * FROM d_listp;
-a
--
-1
-2
-(2 rows)
-
-step s2detach: ALTER TABLE d_listp DETACH PARTITION d_listp2 CONCURRENTLY; <waiting ...>
-step s1s: SELECT * FROM d_listp;
-a
--
-1
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/pageinspect/expected/page.out C:/cirrus/build/testrun/pageinspect/regress...
--- C:/cirrus/contrib/pageinspect/expected/page.out 2025-12-11 15:06:06.009056700 +0000
+++ C:/cirrus/build/testrun/pageinspect/regress/results/page.out 2025-12-11 15:16:03.028309300 +0000
@@ -179,110 +179,7 @@
-- check that using any of these functions with a partitioned table or index
-- would fail
create table test_partitioned (a int) partition by range (a);
-create index test_partitioned_index on test_partitioned (a);
-select get_raw_page('test_partitioned', 0); -- error about partitioned table
-ERROR: cannot get raw page from relation "test_partitioned"
-DETAIL: This operation is not supported for partitioned tables.
-select get_raw_page('test_partitioned_index', 0); -- error about partitioned index
-ERROR: cannot get raw page from relation "test_partitioned_index"
-DETAIL: This operation is not supported for partitioned indexes.
--- a regular table which is a member of a partition set should work though
-create table test_part1 partition of test_partitioned for values from ( 1 ) to (100);
-select get_raw_page('test_part1', 0); -- get farther and error about empty table
-ERROR: block number 0 is out of range for relation "test_part1"
-drop table test_partitioned;
--- check null bitmap alignment for table whose number of attributes is multiple of 8
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/pg_overexplain/expected/pg_overexplain.out C:/cirrus/build/testrun/pg_ove...
--- C:/cirrus/contrib/pg_overexplain/expected/pg_overexplain.out 2025-12-11 15:06:06.067130900 +0000
+++ C:/cirrus/build/testrun/pg_overexplain/regress/results/pg_overexplain.out 2025-12-11 15:16:07.791009400 +0000
@@ -52,440 +52,7 @@
-- Create a partitioned table.
CREATE TABLE vegetables (id serial, name text, genus text)
PARTITION BY LIST (genus);
-CREATE TABLE daucus PARTITION OF vegetables FOR VALUES IN ('daucus');
-CREATE TABLE brassica PARTITION OF vegetables FOR VALUES IN ('brassica');
-INSERT INTO vegetables (name, genus)
- VALUES ('carrot', 'daucus'), ('bok choy', 'brassica'),
- ('brocooli', 'brassica'), ('cauliflower', 'brassica'),
- ('cabbage', 'brassica'), ('kohlrabi', 'brassica'),
- ('rutabaga', 'brassica'), ('turnip', 'brassica');
-VACUUM ANALYZE vegetables;
--- We filter relation OIDs out of the test output in order to avoid
--- test instability. This is currently only needed for EXPLAIN (DEBUG), not
--- EXPLAIN (RANGE_TABLE). Also suppress actual row counts, which are not
--- stable (e.g. 1/8 is 0.12 on some buildfarm machines and 0.13 on others).
-CREATE FUNCTION explain_filter(text) RETURNS SETOF text
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/pg_prewarm/expected/pg_prewarm.out C:/cirrus/build/testrun/pg_prewarm/reg...
--- C:/cirrus/contrib/pg_prewarm/expected/pg_prewarm.out 2025-12-11 15:06:06.073961000 +0000
+++ C:/cirrus/build/testrun/pg_prewarm/regress/results/pg_prewarm.out 2025-12-11 15:16:08.167965500 +0000
@@ -2,9 +2,7 @@
CREATE EXTENSION pg_prewarm;
-- pg_prewarm() should fail if the target relation has no storage.
CREATE TABLE test (c1 int) PARTITION BY RANGE (c1);
-SELECT pg_prewarm('test', 'buffer');
-ERROR: relation "test" does not have storage
-DETAIL: This operation is not supported for partitioned tables.
--- Cleanup
-DROP TABLE test;
-DROP EXTENSION pg_prewarm;
+server closed the connection unexpectedly
+ This probably means the server terminated abnormally
+ before or while processing the request.
+connection to server was lost |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/pg_stat_statements/expected/utility.out C:/cirrus/build/testrun/pg_stat_s...
--- C:/cirrus/contrib/pg_stat_statements/expected/utility.out 2025-12-11 15:06:06.090564000 +0000
+++ C:/cirrus/build/testrun/pg_stat_statements/regress/results/utility.out 2025-12-11 15:16:10.487304100 +0000
@@ -44,696 +44,7 @@
-- Partitions
CREATE TABLE pt_stats (a int, b int) PARTITION BY range (a);
-CREATE TABLE pt_stats1 (a int, b int);
-ALTER TABLE pt_stats ATTACH PARTITION pt_stats1 FOR VALUES FROM (0) TO (100);
-CREATE TABLE pt_stats2 PARTITION OF pt_stats FOR VALUES FROM (100) TO (200);
-CREATE INDEX pt_stats_index ON ONLY pt_stats (a);
-CREATE INDEX pt_stats2_index ON ONLY pt_stats2 (a);
-ALTER INDEX pt_stats_index ATTACH PARTITION pt_stats2_index;
-DROP TABLE pt_stats;
--- Views
-CREATE VIEW view_stats AS SELECT 1::int AS a, 2::int AS b;
-ALTER VIEW view_stats ALTER COLUMN a SET DEFAULT 2;
-DROP VIEW view_stats;
--- Foreign tables
-CREATE FOREIGN DATA WRAPPER wrapper_stats;
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/database.out C:/cirrus/build/testrun/pg_upgrade/002_pg_...
--- C:/cirrus/src/test/regress/expected/database.out 2025-12-11 15:06:10.347073900 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/database.out 2025-12-11 15:12:15.460451400 +0000
@@ -2,20 +2,10 @@
ENCODING utf8 LC_COLLATE "C" LC_CTYPE "C" TEMPLATE template0;
ALTER DATABASE regression_tbd RENAME TO regression_utf8;
ALTER DATABASE regression_utf8 SET TABLESPACE regress_tblspace;
-ALTER DATABASE regression_utf8 SET TABLESPACE pg_default;
-ALTER DATABASE regression_utf8 CONNECTION_LIMIT 123;
--- Test PgDatabaseToastTable. Doing this with GRANT would be slow.
-BEGIN;
-UPDATE pg_database
-SET datacl = array_fill(makeaclitem(10, 10, 'USAGE', false), ARRAY[5e5::int])
-WHERE datname = 'regression_utf8';
--- load catcache entry, if nothing else does
-ALTER DATABASE regression_utf8 RENAME TO regression_rename_rolled_back;
-ROLLBACK;
-CREATE ROLE regress_datdba_before;
-CREATE ROLE regress_datdba_after;
-ALTER DATABASE regression_utf8 OWNER TO regress_datdba_before;
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/pg_visibility/expected/pg_visibility.out C:/cirrus/build/testrun/pg_visib...
--- C:/cirrus/contrib/pg_visibility/expected/pg_visibility.out 2025-12-11 15:06:06.158893900 +0000
+++ C:/cirrus/build/testrun/pg_visibility/regress/results/pg_visibility.out 2025-12-11 15:16:12.116202600 +0000
@@ -39,240 +39,7 @@
--
-- partitioned tables (the parent ones) don't have visibility maps
create table test_partitioned (a int) partition by list (a);
--- these should all fail
-select pg_visibility('test_partitioned', 0);
-ERROR: relation "test_partitioned" is of wrong relation kind
-DETAIL: This operation is not supported for partitioned tables.
-select pg_visibility_map('test_partitioned');
-ERROR: relation "test_partitioned" is of wrong relation kind
-DETAIL: This operation is not supported for partitioned tables.
-select pg_visibility_map_summary('test_partitioned');
-ERROR: relation "test_partitioned" is of wrong relation kind
-DETAIL: This operation is not supported for partitioned tables.
-select pg_check_frozen('test_partitioned');
-ERROR: relation "test_partitioned" is of wrong relation kind
-DETAIL: This operation is not supported for partitioned tables.
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/pgstattuple/expected/pgstattuple.out C:/cirrus/build/testrun/pgstattuple/...
--- C:/cirrus/contrib/pgstattuple/expected/pgstattuple.out 2025-12-11 15:06:06.248729300 +0000
+++ C:/cirrus/build/testrun/pgstattuple/regress/results/pgstattuple.out 2025-12-11 15:16:10.409166500 +0000
@@ -152,154 +152,7 @@
ERROR: relation "test_hashidx" is not a GIN index
-- check that using any of these functions with unsupported relations will fail
create table test_partitioned (a int) partition by range (a);
-create index test_partitioned_index on test_partitioned(a);
-create index test_partitioned_hash_index on test_partitioned using hash(a);
--- these should all fail
-select pgstattuple('test_partitioned');
-ERROR: cannot get tuple-level statistics for relation "test_partitioned"
-DETAIL: This operation is not supported for partitioned tables.
-select pgstattuple('test_partitioned_index');
-ERROR: cannot get tuple-level statistics for relation "test_partitioned_index"
-DETAIL: This operation is not supported for partitioned indexes.
-select pgstattuple_approx('test_partitioned');
-ERROR: relation "test_partitioned" is of wrong relation kind
-DETAIL: This operation is not supported for partitioned tables.
-select pg_relpages('test_partitioned');
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/postgres_fdw/expected/postgres_fdw.out C:/cirrus/build/testrun/postgres_f...
--- C:/cirrus/contrib/postgres_fdw/expected/postgres_fdw.out 2025-12-11 15:06:06.269693300 +0000
+++ C:/cirrus/build/testrun/postgres_fdw/regress/results/postgres_fdw.out 2025-12-11 15:16:15.989242900 +0000
@@ -4542,8180 +4542,7 @@
DROP FOREIGN TABLE reindex_foreign;
-- partitions and foreign tables
CREATE TABLE reind_fdw_parent (c1 int) PARTITION BY RANGE (c1);
-CREATE TABLE reind_fdw_0_10 PARTITION OF reind_fdw_parent
- FOR VALUES FROM (0) TO (10);
-CREATE FOREIGN TABLE reind_fdw_10_20 PARTITION OF reind_fdw_parent
- FOR VALUES FROM (10) TO (20)
- SERVER loopback OPTIONS (table_name 'reind_local_10_20');
-REINDEX TABLE reind_fdw_parent; -- ok
-REINDEX TABLE CONCURRENTLY reind_fdw_parent; -- ok
-DROP TABLE reind_fdw_parent;
--- ===================================================================
--- conversion error
--- ===================================================================
-ALTER FOREIGN TABLE ft1 ALTER COLUMN c8 TYPE int;
-SELECT * FROM ft1 ftx(x1,x2,x3,x4,x5,x6,x7,x8) WHERE x1 = 1; -- ERROR
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/database.out C:/cirrus/build/testrun/recovery/027_strea...
--- C:/cirrus/src/test/regress/expected/database.out 2025-12-11 15:06:10.347073900 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/database.out 2025-12-11 15:14:30.518545500 +0000
@@ -2,20 +2,10 @@
ENCODING utf8 LC_COLLATE "C" LC_CTYPE "C" TEMPLATE template0;
ALTER DATABASE regression_tbd RENAME TO regression_utf8;
ALTER DATABASE regression_utf8 SET TABLESPACE regress_tblspace;
-ALTER DATABASE regression_utf8 SET TABLESPACE pg_default;
-ALTER DATABASE regression_utf8 CONNECTION_LIMIT 123;
--- Test PgDatabaseToastTable. Doing this with GRANT would be slow.
-BEGIN;
-UPDATE pg_database
-SET datacl = array_fill(makeaclitem(10, 10, 'USAGE', false), ARRAY[5e5::int])
-WHERE datname = 'regression_utf8';
--- load catcache entry, if nothing else does
-ALTER DATABASE regression_utf8 RENAME TO regression_rename_rolled_back;
-ROLLBACK;
-CREATE ROLE regress_datdba_before;
-CREATE ROLE regress_datdba_after;
-ALTER DATABASE regression_utf8 OWNER TO regress_datdba_before;
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/database.out C:/cirrus/build/testrun/regress/regress/re...
--- C:/cirrus/src/test/regress/expected/database.out 2025-12-11 15:06:10.347073900 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/database.out 2025-12-11 15:12:15.319828800 +0000
@@ -2,20 +2,10 @@
ENCODING utf8 LC_COLLATE "C" LC_CTYPE "C" TEMPLATE template0;
ALTER DATABASE regression_tbd RENAME TO regression_utf8;
ALTER DATABASE regression_utf8 SET TABLESPACE regress_tblspace;
-ALTER DATABASE regression_utf8 SET TABLESPACE pg_default;
-ALTER DATABASE regression_utf8 CONNECTION_LIMIT 123;
--- Test PgDatabaseToastTable. Doing this with GRANT would be slow.
-BEGIN;
-UPDATE pg_database
-SET datacl = array_fill(makeaclitem(10, 10, 'USAGE', false), ARRAY[5e5::int])
-WHERE datname = 'regression_utf8';
--- load catcache entry, if nothing else does
-ALTER DATABASE regression_utf8 RENAME TO regression_rename_rolled_back;
-ROLLBACK;
-CREATE ROLE regress_datdba_before;
-CREATE ROLE regress_datdba_after;
-ALTER DATABASE regression_utf8 OWNER TO regress_datdba_before;
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/seg/expected/security.out C:/cirrus/build/testrun/seg/regress/results/sec...
--- C:/cirrus/contrib/seg/expected/security.out 2025-12-11 15:06:06.289638400 +0000
+++ C:/cirrus/build/testrun/seg/regress/results/security.out 2025-12-11 15:16:14.751454100 +0000
@@ -22,11 +22,7 @@
CREATE SCHEMA test_schema
CREATE TABLE t(i int) PARTITION BY RANGE (i)
CREATE TABLE p1 PARTITION OF t FOR VALUES FROM (1) TO (regress_seg_schema.exfun(2));
-DROP SCHEMA test_schema CASCADE;
-NOTICE: drop cascades to 3 other objects
-DETAIL: drop cascades to table test_schema.t
-drop cascades to extension seg
-drop cascades to operator test_schema.=(oid,regclass)
-RESET ROLE;
-DROP OWNED BY regress_seg_role;
-DROP ROLE regress_seg_role;
+server closed the connection unexpectedly
+ This probably means the server terminated abnormally
+ before or while processing the request.
+connection to server was lost
diff --strip-trailing-cr -U3 C:/cirrus/contrib/seg/expected/seg.out C:/cirrus/build/testrun/seg/regress/results/seg.out
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/modules/test_ddl_deparse/expected/alter_table.out C:/cirrus/build/testru...
--- C:/cirrus/src/test/modules/test_ddl_deparse/expected/alter_table.out 2025-12-11 15:06:10.066434900 +0000
+++ C:/cirrus/build/testrun/test_ddl_deparse/regress/results/alter_table.out 2025-12-11 15:16:35.659660200 +0000
@@ -101,43 +101,7 @@
CREATE TABLE part (
a int
) PARTITION BY RANGE (a);
-NOTICE: DDL test: type simple, tag CREATE TABLE
-CREATE TABLE part1 PARTITION OF part FOR VALUES FROM (1) to (100);
-NOTICE: DDL test: type simple, tag CREATE TABLE
-CREATE TABLE part2 (a int);
-NOTICE: DDL test: type simple, tag CREATE TABLE
-ALTER TABLE part ATTACH PARTITION part2 FOR VALUES FROM (101) to (200);
-NOTICE: DDL test: type alter table, tag ALTER TABLE
-NOTICE: subcommand: type ATTACH PARTITION desc table part2
-ALTER TABLE part DETACH PARTITION part2;
-NOTICE: DDL test: type alter table, tag ALTER TABLE
-NOTICE: subcommand: type DETACH PARTITION desc table part2
-DROP TABLE part2;
-ALTER TABLE part ADD PRIMARY KEY (a);
... |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/amcheck/expected/check_btree.out C:/cirrus/build/testrun/amcheck/regress/...
--- C:/cirrus/contrib/amcheck/expected/check_btree.out 2025-12-11 15:05:04.184173900 +0000
+++ C:/cirrus/build/testrun/amcheck/regress/results/check_btree.out 2025-12-11 15:11:28.494525900 +0000
@@ -63,221 +63,7 @@
-- verify partitioned indexes are rejected (error)
BEGIN;
CREATE TABLE bttest_partitioned (a int, b int) PARTITION BY list (a);
-CREATE INDEX bttest_btree_partitioned_idx ON bttest_partitioned USING btree (b);
-SELECT bt_index_parent_check('bttest_btree_partitioned_idx');
-ERROR: expected index as targets for verification
-DETAIL: This operation is not supported for partitioned indexes.
-ROLLBACK;
--- normal check outside of xact
-SELECT bt_index_check('bttest_a_idx');
- bt_index_check
-----------------
-
-(1 row)
-
--- more expansive tests
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/btree_gist/expected/partitions.out C:/cirrus/build/testrun/btree_gist/reg...
--- C:/cirrus/contrib/btree_gist/expected/partitions.out 2025-12-11 15:05:04.349226400 +0000
+++ C:/cirrus/build/testrun/btree_gist/regress/results/partitions.out 2025-12-11 15:11:44.058500200 +0000
@@ -7,76 +7,7 @@
valid_at daterange,
exclude using gist (id with =, valid_at with &&)
) partition by range (id);
-create table parttmp_1_to_10 partition of parttmp for values from (1) to (10);
-create table parttmp_11_to_20 partition of parttmp for values from (11) to (20);
-insert into parttmp (id, valid_at) values
- (1, '[2000-01-01, 2000-02-01)'),
- (1, '[2000-02-01, 2000-03-01)'),
- (2, '[2000-01-01, 2000-02-01)'),
- (11, '[2000-01-01, 2000-02-01)'),
- (11, '[2000-02-01, 2000-03-01)'),
- (12, '[2000-01-01, 2000-02-01)');
-select * from parttmp order by id, valid_at;
- id | valid_at
-----+-------------------------
- 1 | [01-01-2000,02-01-2000)
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/modules/delay_execution/expected/partition-addition.out C:/cirrus/build/...
--- C:/cirrus/src/test/modules/delay_execution/expected/partition-addition.out 2025-12-11 15:05:08.752485900 +0000
+++ C:/cirrus/build/testrun/delay_execution/isolation/results/partition-addition.out 2025-12-11 15:12:16.917391600 +0000
@@ -1,27 +1,6 @@
Parsed test spec with 2 sessions
starting permutation: s2lock s1exec s2addp s2unlock
-step s2lock: SELECT pg_advisory_lock(12345);
-pg_advisory_lock
-----------------
-
-(1 row)
-
-step s1exec: LOAD 'delay_execution';
- SET delay_execution.post_planning_lock_id = 12345;
- SELECT * FROM foo WHERE a <> 1 AND a <> (SELECT 3); <waiting ...>
-step s2addp: CREATE TABLE foo2 (LIKE foo);
- ALTER TABLE foo ATTACH PARTITION foo2 FOR VALUES IN (2);
- INSERT INTO foo VALUES (2, 'ADD2');
-step s2unlock: SELECT pg_advisory_unlock(12345);
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/file_fdw/expected/file_fdw.out C:/cirrus/build/testrun/file_fdw/regress/r...
--- C:/cirrus/contrib/file_fdw/expected/file_fdw.out 2025-12-11 15:05:04.430777000 +0000
+++ C:/cirrus/build/testrun/file_fdw/regress/results/file_fdw.out 2025-12-11 15:11:43.589749800 +0000
@@ -375,182 +375,7 @@
-- declarative partitioning tests
SET ROLE regress_file_fdw_superuser;
CREATE TABLE pt (a int, b text) partition by list (a);
-\set filename :abs_srcdir '/data/list1.csv'
-CREATE FOREIGN TABLE p1 partition of pt for values in (1) SERVER file_server
-OPTIONS (format 'csv', filename :'filename', delimiter ',');
-CREATE TABLE p2 partition of pt for values in (2);
-SELECT tableoid::regclass, * FROM pt;
- tableoid | a | b
-----------+---+-----
- p1 | 1 | foo
- p1 | 1 | bar
-(2 rows)
-
-SELECT tableoid::regclass, * FROM p1;
- tableoid | a | b
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/modules/injection_points/expected/reindex-concurrently-upsert-partitione...
--- C:/cirrus/src/test/modules/injection_points/expected/reindex-concurrently-upsert-partitioned.out 2025-12-11 15:05:08...
+++ C:/cirrus/build/testrun/injection_points/isolation/results/reindex-concurrently-upsert-partitioned.out 2025-12-11 15...
@@ -1,238 +1,6 @@
Parsed test spec with 4 sessions
starting permutation: s3_setup_wait_before_set_dead s3_start_reindex s1_start_upsert s4_wakeup_to_set_dead s2_start_ups...
-injection_points_attach
------------------------
-
-(1 row)
-
-injection_points_attach
------------------------
-
-(1 row)
-
-injection_points_set_local
---------------------------
-
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/isolation/expected/detach-partition-concurrently-1.out C:/cirrus/build/t...
--- C:/cirrus/src/test/isolation/expected/detach-partition-concurrently-1.out 2025-12-11 15:05:08.564034500 +0000
+++ C:/cirrus/build/testrun/isolation/isolation/results/detach-partition-concurrently-1.out 2025-12-11 15:08:08.55743270...
@@ -1,288 +1,6 @@
Parsed test spec with 3 sessions
starting permutation: s1b s1s s2detach s1s s1c s1s
-step s1b: BEGIN;
-step s1s: SELECT * FROM d_listp;
-a
--
-1
-2
-(2 rows)
-
-step s2detach: ALTER TABLE d_listp DETACH PARTITION d_listp2 CONCURRENTLY; <waiting ...>
-step s1s: SELECT * FROM d_listp;
-a
--
-1
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/pageinspect/expected/page.out C:/cirrus/build/testrun/pageinspect/regress...
--- C:/cirrus/contrib/pageinspect/expected/page.out 2025-12-11 15:05:04.597742500 +0000
+++ C:/cirrus/build/testrun/pageinspect/regress/results/page.out 2025-12-11 15:11:54.917880200 +0000
@@ -179,110 +179,7 @@
-- check that using any of these functions with a partitioned table or index
-- would fail
create table test_partitioned (a int) partition by range (a);
-create index test_partitioned_index on test_partitioned (a);
-select get_raw_page('test_partitioned', 0); -- error about partitioned table
-ERROR: cannot get raw page from relation "test_partitioned"
-DETAIL: This operation is not supported for partitioned tables.
-select get_raw_page('test_partitioned_index', 0); -- error about partitioned index
-ERROR: cannot get raw page from relation "test_partitioned_index"
-DETAIL: This operation is not supported for partitioned indexes.
--- a regular table which is a member of a partition set should work though
-create table test_part1 partition of test_partitioned for values from ( 1 ) to (100);
-select get_raw_page('test_part1', 0); -- get farther and error about empty table
-ERROR: block number 0 is out of range for relation "test_part1"
-drop table test_partitioned;
--- check null bitmap alignment for table whose number of attributes is multiple of 8
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/pg_overexplain/expected/pg_overexplain.out C:/cirrus/build/testrun/pg_ove...
--- C:/cirrus/contrib/pg_overexplain/expected/pg_overexplain.out 2025-12-11 15:05:04.666064500 +0000
+++ C:/cirrus/build/testrun/pg_overexplain/regress/results/pg_overexplain.out 2025-12-11 15:11:58.134670900 +0000
@@ -52,440 +52,7 @@
-- Create a partitioned table.
CREATE TABLE vegetables (id serial, name text, genus text)
PARTITION BY LIST (genus);
-CREATE TABLE daucus PARTITION OF vegetables FOR VALUES IN ('daucus');
-CREATE TABLE brassica PARTITION OF vegetables FOR VALUES IN ('brassica');
-INSERT INTO vegetables (name, genus)
- VALUES ('carrot', 'daucus'), ('bok choy', 'brassica'),
- ('brocooli', 'brassica'), ('cauliflower', 'brassica'),
- ('cabbage', 'brassica'), ('kohlrabi', 'brassica'),
- ('rutabaga', 'brassica'), ('turnip', 'brassica');
-VACUUM ANALYZE vegetables;
--- We filter relation OIDs out of the test output in order to avoid
--- test instability. This is currently only needed for EXPLAIN (DEBUG), not
--- EXPLAIN (RANGE_TABLE). Also suppress actual row counts, which are not
--- stable (e.g. 1/8 is 0.12 on some buildfarm machines and 0.13 on others).
-CREATE FUNCTION explain_filter(text) RETURNS SETOF text
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/pg_prewarm/expected/pg_prewarm.out C:/cirrus/build/testrun/pg_prewarm/reg...
--- C:/cirrus/contrib/pg_prewarm/expected/pg_prewarm.out 2025-12-11 15:05:04.673493700 +0000
+++ C:/cirrus/build/testrun/pg_prewarm/regress/results/pg_prewarm.out 2025-12-11 15:11:58.682525400 +0000
@@ -2,9 +2,7 @@
CREATE EXTENSION pg_prewarm;
-- pg_prewarm() should fail if the target relation has no storage.
CREATE TABLE test (c1 int) PARTITION BY RANGE (c1);
-SELECT pg_prewarm('test', 'buffer');
-ERROR: relation "test" does not have storage
-DETAIL: This operation is not supported for partitioned tables.
--- Cleanup
-DROP TABLE test;
-DROP EXTENSION pg_prewarm;
+server closed the connection unexpectedly
+ This probably means the server terminated abnormally
+ before or while processing the request.
+connection to server was lost |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/pg_stat_statements/expected/utility.out C:/cirrus/build/testrun/pg_stat_s...
--- C:/cirrus/contrib/pg_stat_statements/expected/utility.out 2025-12-11 15:05:04.697317500 +0000
+++ C:/cirrus/build/testrun/pg_stat_statements/regress/results/utility.out 2025-12-11 15:12:01.033604300 +0000
@@ -44,696 +44,7 @@
-- Partitions
CREATE TABLE pt_stats (a int, b int) PARTITION BY range (a);
-CREATE TABLE pt_stats1 (a int, b int);
-ALTER TABLE pt_stats ATTACH PARTITION pt_stats1 FOR VALUES FROM (0) TO (100);
-CREATE TABLE pt_stats2 PARTITION OF pt_stats FOR VALUES FROM (100) TO (200);
-CREATE INDEX pt_stats_index ON ONLY pt_stats (a);
-CREATE INDEX pt_stats2_index ON ONLY pt_stats2 (a);
-ALTER INDEX pt_stats_index ATTACH PARTITION pt_stats2_index;
-DROP TABLE pt_stats;
--- Views
-CREATE VIEW view_stats AS SELECT 1::int AS a, 2::int AS b;
-ALTER VIEW view_stats ALTER COLUMN a SET DEFAULT 2;
-DROP VIEW view_stats;
--- Foreign tables
-CREATE FOREIGN DATA WRAPPER wrapper_stats;
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/database.out C:/cirrus/build/testrun/pg_upgrade/002_pg_...
--- C:/cirrus/src/test/regress/expected/database.out 2025-12-11 15:05:09.173202400 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/database.out 2025-12-11 15:07:56.291817000 +0000
@@ -2,20 +2,10 @@
ENCODING utf8 LC_COLLATE "C" LC_CTYPE "C" TEMPLATE template0;
ALTER DATABASE regression_tbd RENAME TO regression_utf8;
ALTER DATABASE regression_utf8 SET TABLESPACE regress_tblspace;
-ALTER DATABASE regression_utf8 SET TABLESPACE pg_default;
-ALTER DATABASE regression_utf8 CONNECTION_LIMIT 123;
--- Test PgDatabaseToastTable. Doing this with GRANT would be slow.
-BEGIN;
-UPDATE pg_database
-SET datacl = array_fill(makeaclitem(10, 10, 'USAGE', false), ARRAY[5e5::int])
-WHERE datname = 'regression_utf8';
--- load catcache entry, if nothing else does
-ALTER DATABASE regression_utf8 RENAME TO regression_rename_rolled_back;
-ROLLBACK;
-CREATE ROLE regress_datdba_before;
-CREATE ROLE regress_datdba_after;
-ALTER DATABASE regression_utf8 OWNER TO regress_datdba_before;
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/pg_visibility/expected/pg_visibility.out C:/cirrus/build/testrun/pg_visib...
--- C:/cirrus/contrib/pg_visibility/expected/pg_visibility.out 2025-12-11 15:05:04.766216700 +0000
+++ C:/cirrus/build/testrun/pg_visibility/regress/results/pg_visibility.out 2025-12-11 15:12:04.040440100 +0000
@@ -39,240 +39,7 @@
--
-- partitioned tables (the parent ones) don't have visibility maps
create table test_partitioned (a int) partition by list (a);
--- these should all fail
-select pg_visibility('test_partitioned', 0);
-ERROR: relation "test_partitioned" is of wrong relation kind
-DETAIL: This operation is not supported for partitioned tables.
-select pg_visibility_map('test_partitioned');
-ERROR: relation "test_partitioned" is of wrong relation kind
-DETAIL: This operation is not supported for partitioned tables.
-select pg_visibility_map_summary('test_partitioned');
-ERROR: relation "test_partitioned" is of wrong relation kind
-DETAIL: This operation is not supported for partitioned tables.
-select pg_check_frozen('test_partitioned');
-ERROR: relation "test_partitioned" is of wrong relation kind
-DETAIL: This operation is not supported for partitioned tables.
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/pgstattuple/expected/pgstattuple.out C:/cirrus/build/testrun/pgstattuple/...
--- C:/cirrus/contrib/pgstattuple/expected/pgstattuple.out 2025-12-11 15:05:04.860442600 +0000
+++ C:/cirrus/build/testrun/pgstattuple/regress/results/pgstattuple.out 2025-12-11 15:12:02.584859900 +0000
@@ -152,154 +152,7 @@
ERROR: relation "test_hashidx" is not a GIN index
-- check that using any of these functions with unsupported relations will fail
create table test_partitioned (a int) partition by range (a);
-create index test_partitioned_index on test_partitioned(a);
-create index test_partitioned_hash_index on test_partitioned using hash(a);
--- these should all fail
-select pgstattuple('test_partitioned');
-ERROR: cannot get tuple-level statistics for relation "test_partitioned"
-DETAIL: This operation is not supported for partitioned tables.
-select pgstattuple('test_partitioned_index');
-ERROR: cannot get tuple-level statistics for relation "test_partitioned_index"
-DETAIL: This operation is not supported for partitioned indexes.
-select pgstattuple_approx('test_partitioned');
-ERROR: relation "test_partitioned" is of wrong relation kind
-DETAIL: This operation is not supported for partitioned tables.
-select pg_relpages('test_partitioned');
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/postgres_fdw/expected/postgres_fdw.out C:/cirrus/build/testrun/postgres_f...
--- C:/cirrus/contrib/postgres_fdw/expected/postgres_fdw.out 2025-12-11 15:05:04.884380300 +0000
+++ C:/cirrus/build/testrun/postgres_fdw/regress/results/postgres_fdw.out 2025-12-11 15:12:09.789947400 +0000
@@ -4542,8180 +4542,7 @@
DROP FOREIGN TABLE reindex_foreign;
-- partitions and foreign tables
CREATE TABLE reind_fdw_parent (c1 int) PARTITION BY RANGE (c1);
-CREATE TABLE reind_fdw_0_10 PARTITION OF reind_fdw_parent
- FOR VALUES FROM (0) TO (10);
-CREATE FOREIGN TABLE reind_fdw_10_20 PARTITION OF reind_fdw_parent
- FOR VALUES FROM (10) TO (20)
- SERVER loopback OPTIONS (table_name 'reind_local_10_20');
-REINDEX TABLE reind_fdw_parent; -- ok
-REINDEX TABLE CONCURRENTLY reind_fdw_parent; -- ok
-DROP TABLE reind_fdw_parent;
--- ===================================================================
--- conversion error
--- ===================================================================
-ALTER FOREIGN TABLE ft1 ALTER COLUMN c8 TYPE int;
-SELECT * FROM ft1 ftx(x1,x2,x3,x4,x5,x6,x7,x8) WHERE x1 = 1; -- ERROR
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/database.out C:/cirrus/build/testrun/recovery/027_strea...
--- C:/cirrus/src/test/regress/expected/database.out 2025-12-11 15:05:09.173202400 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/database.out 2025-12-11 15:10:13.385610700 +0000
@@ -2,20 +2,10 @@
ENCODING utf8 LC_COLLATE "C" LC_CTYPE "C" TEMPLATE template0;
ALTER DATABASE regression_tbd RENAME TO regression_utf8;
ALTER DATABASE regression_utf8 SET TABLESPACE regress_tblspace;
-ALTER DATABASE regression_utf8 SET TABLESPACE pg_default;
-ALTER DATABASE regression_utf8 CONNECTION_LIMIT 123;
--- Test PgDatabaseToastTable. Doing this with GRANT would be slow.
-BEGIN;
-UPDATE pg_database
-SET datacl = array_fill(makeaclitem(10, 10, 'USAGE', false), ARRAY[5e5::int])
-WHERE datname = 'regression_utf8';
--- load catcache entry, if nothing else does
-ALTER DATABASE regression_utf8 RENAME TO regression_rename_rolled_back;
-ROLLBACK;
-CREATE ROLE regress_datdba_before;
-CREATE ROLE regress_datdba_after;
-ALTER DATABASE regression_utf8 OWNER TO regress_datdba_before;
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/database.out C:/cirrus/build/testrun/regress/regress/re...
--- C:/cirrus/src/test/regress/expected/database.out 2025-12-11 15:05:09.173202400 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/database.out 2025-12-11 15:07:55.305973700 +0000
@@ -2,20 +2,10 @@
ENCODING utf8 LC_COLLATE "C" LC_CTYPE "C" TEMPLATE template0;
ALTER DATABASE regression_tbd RENAME TO regression_utf8;
ALTER DATABASE regression_utf8 SET TABLESPACE regress_tblspace;
-ALTER DATABASE regression_utf8 SET TABLESPACE pg_default;
-ALTER DATABASE regression_utf8 CONNECTION_LIMIT 123;
--- Test PgDatabaseToastTable. Doing this with GRANT would be slow.
-BEGIN;
-UPDATE pg_database
-SET datacl = array_fill(makeaclitem(10, 10, 'USAGE', false), ARRAY[5e5::int])
-WHERE datname = 'regression_utf8';
--- load catcache entry, if nothing else does
-ALTER DATABASE regression_utf8 RENAME TO regression_rename_rolled_back;
-ROLLBACK;
-CREATE ROLE regress_datdba_before;
-CREATE ROLE regress_datdba_after;
-ALTER DATABASE regression_utf8 OWNER TO regress_datdba_before;
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/seg/expected/security.out C:/cirrus/build/testrun/seg/regress/results/sec...
--- C:/cirrus/contrib/seg/expected/security.out 2025-12-11 15:05:04.903911800 +0000
+++ C:/cirrus/build/testrun/seg/regress/results/security.out 2025-12-11 15:12:07.815830500 +0000
@@ -22,11 +22,7 @@
CREATE SCHEMA test_schema
CREATE TABLE t(i int) PARTITION BY RANGE (i)
CREATE TABLE p1 PARTITION OF t FOR VALUES FROM (1) TO (regress_seg_schema.exfun(2));
-DROP SCHEMA test_schema CASCADE;
-NOTICE: drop cascades to 3 other objects
-DETAIL: drop cascades to table test_schema.t
-drop cascades to extension seg
-drop cascades to operator test_schema.=(oid,regclass)
-RESET ROLE;
-DROP OWNED BY regress_seg_role;
-DROP ROLE regress_seg_role;
+server closed the connection unexpectedly
+ This probably means the server terminated abnormally
+ before or while processing the request.
+connection to server was lost
diff --strip-trailing-cr -U3 C:/cirrus/contrib/seg/expected/partition.out C:/cirrus/build/testrun/seg/regress/results/pa...
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/modules/test_ddl_deparse/expected/alter_table.out C:/cirrus/build/testru...
--- C:/cirrus/src/test/modules/test_ddl_deparse/expected/alter_table.out 2025-12-11 15:05:08.867504500 +0000
+++ C:/cirrus/build/testrun/test_ddl_deparse/regress/results/alter_table.out 2025-12-11 15:12:30.198168300 +0000
@@ -101,43 +101,7 @@
CREATE TABLE part (
a int
) PARTITION BY RANGE (a);
-NOTICE: DDL test: type simple, tag CREATE TABLE
-CREATE TABLE part1 PARTITION OF part FOR VALUES FROM (1) to (100);
-NOTICE: DDL test: type simple, tag CREATE TABLE
-CREATE TABLE part2 (a int);
-NOTICE: DDL test: type simple, tag CREATE TABLE
-ALTER TABLE part ATTACH PARTITION part2 FOR VALUES FROM (101) to (200);
-NOTICE: DDL test: type alter table, tag ALTER TABLE
-NOTICE: subcommand: type ATTACH PARTITION desc table part2
-ALTER TABLE part DETACH PARTITION part2;
-NOTICE: DDL test: type alter table, tag ALTER TABLE
-NOTICE: subcommand: type DETACH PARTITION desc table part2
-DROP TABLE part2;
-ALTER TABLE part ADD PRIMARY KEY (a);
... |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/contrib/amcheck/expected/check_btree.out /home/postgres/postgres/build/testrun/amcheck/...
--- /home/postgres/postgres/contrib/amcheck/expected/check_btree.out 2025-12-11 15:05:17.975516800 +0000
+++ /home/postgres/postgres/build/testrun/amcheck/regress/results/check_btree.out 2025-12-11 15:08:29.767701770 +0000
@@ -63,221 +63,7 @@
-- verify partitioned indexes are rejected (error)
BEGIN;
CREATE TABLE bttest_partitioned (a int, b int) PARTITION BY list (a);
-CREATE INDEX bttest_btree_partitioned_idx ON bttest_partitioned USING btree (b);
-SELECT bt_index_parent_check('bttest_btree_partitioned_idx');
-ERROR: expected index as targets for verification
-DETAIL: This operation is not supported for partitioned indexes.
-ROLLBACK;
--- normal check outside of xact
-SELECT bt_index_check('bttest_a_idx');
- bt_index_check
-----------------
-
-(1 row)
-
--- more expansive tests
... |
| regress |
diff -U3 /home/postgres/postgres/contrib/btree_gist/expected/partitions.out /home/postgres/postgres/build/testrun/btree_...
--- /home/postgres/postgres/contrib/btree_gist/expected/partitions.out 2025-12-11 15:05:18.226720763 +0000
+++ /home/postgres/postgres/build/testrun/btree_gist/regress/results/partitions.out 2025-12-11 15:08:32.187080643 +0000
@@ -7,76 +7,7 @@
valid_at daterange,
exclude using gist (id with =, valid_at with &&)
) partition by range (id);
-create table parttmp_1_to_10 partition of parttmp for values from (1) to (10);
-create table parttmp_11_to_20 partition of parttmp for values from (11) to (20);
-insert into parttmp (id, valid_at) values
- (1, '[2000-01-01, 2000-02-01)'),
- (1, '[2000-02-01, 2000-03-01)'),
- (2, '[2000-01-01, 2000-02-01)'),
- (11, '[2000-01-01, 2000-02-01)'),
- (11, '[2000-02-01, 2000-03-01)'),
- (12, '[2000-01-01, 2000-02-01)');
-select * from parttmp order by id, valid_at;
- id | valid_at
-----+-------------------------
- 1 | [01-01-2000,02-01-2000)
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/modules/delay_execution/expected/partition-addition.out /home/postgres/postgre...
--- /home/postgres/postgres/src/test/modules/delay_execution/expected/partition-addition.out 2025-12-11 15:05:25.5514787...
+++ /home/postgres/postgres/build/testrun/delay_execution/isolation/results/partition-addition.out 2025-12-11 15:08:43.6...
@@ -1,27 +1,6 @@
Parsed test spec with 2 sessions
starting permutation: s2lock s1exec s2addp s2unlock
-step s2lock: SELECT pg_advisory_lock(12345);
-pg_advisory_lock
-----------------
-
-(1 row)
-
-step s1exec: LOAD 'delay_execution';
- SET delay_execution.post_planning_lock_id = 12345;
- SELECT * FROM foo WHERE a <> 1 AND a <> (SELECT 3); <waiting ...>
-step s2addp: CREATE TABLE foo2 (LIKE foo);
- ALTER TABLE foo ATTACH PARTITION foo2 FOR VALUES IN (2);
- INSERT INTO foo VALUES (2, 'ADD2');
-step s2unlock: SELECT pg_advisory_unlock(12345);
... |
| regress |
diff -U3 /home/postgres/postgres/contrib/file_fdw/expected/file_fdw.out /home/postgres/postgres/build/testrun/file_fdw/r...
--- /home/postgres/postgres/contrib/file_fdw/expected/file_fdw.out 2025-12-11 15:05:18.400684699 +0000
+++ /home/postgres/postgres/build/testrun/file_fdw/regress/results/file_fdw.out 2025-12-11 15:08:33.941592636 +0000
@@ -375,182 +375,7 @@
-- declarative partitioning tests
SET ROLE regress_file_fdw_superuser;
CREATE TABLE pt (a int, b text) partition by list (a);
-\set filename :abs_srcdir '/data/list1.csv'
-CREATE FOREIGN TABLE p1 partition of pt for values in (1) SERVER file_server
-OPTIONS (format 'csv', filename :'filename', delimiter ',');
-CREATE TABLE p2 partition of pt for values in (2);
-SELECT tableoid::regclass, * FROM pt;
- tableoid | a | b
-----------+---+-----
- p1 | 1 | foo
- p1 | 1 | bar
-(2 rows)
-
-SELECT tableoid::regclass, * FROM p1;
- tableoid | a | b
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/modules/injection_points/expected/reindex-concurrently-upsert-partitioned.out ...
--- /home/postgres/postgres/src/test/modules/injection_points/expected/reindex-concurrently-upsert-partitioned.out 2025-...
+++ /home/postgres/postgres/build/testrun/injection_points/isolation/results/reindex-concurrently-upsert-partitioned.out...
@@ -1,238 +1,6 @@
Parsed test spec with 4 sessions
starting permutation: s3_setup_wait_before_set_dead s3_start_reindex s1_start_upsert s4_wakeup_to_set_dead s2_start_ups...
-injection_points_attach
------------------------
-
-(1 row)
-
-injection_points_attach
------------------------
-
-(1 row)
-
-injection_points_set_local
---------------------------
-
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/isolation/expected/detach-partition-concurrently-1.out /home/postgres/postgres...
--- /home/postgres/postgres/src/test/isolation/expected/detach-partition-concurrently-1.out 2025-12-11 15:05:25.18791478...
+++ /home/postgres/postgres/build/testrun/isolation/isolation/results/detach-partition-concurrently-1.out 2025-12-11 15:...
@@ -1,288 +1,6 @@
Parsed test spec with 3 sessions
starting permutation: s1b s1s s2detach s1s s1c s1s
-step s1b: BEGIN;
-step s1s: SELECT * FROM d_listp;
-a
--
-1
-2
-(2 rows)
-
-step s2detach: ALTER TABLE d_listp DETACH PARTITION d_listp2 CONCURRENTLY; <waiting ...>
-step s1s: SELECT * FROM d_listp;
-a
--
-1
... |
| regress |
diff -U3 /home/postgres/postgres/contrib/pageinspect/expected/page.out /home/postgres/postgres/build/testrun/pageinspect...
--- /home/postgres/postgres/contrib/pageinspect/expected/page.out 2025-12-11 15:05:18.664543808 +0000
+++ /home/postgres/postgres/build/testrun/pageinspect/regress/results/page.out 2025-12-11 15:08:35.817459899 +0000
@@ -179,110 +179,7 @@
-- check that using any of these functions with a partitioned table or index
-- would fail
create table test_partitioned (a int) partition by range (a);
-create index test_partitioned_index on test_partitioned (a);
-select get_raw_page('test_partitioned', 0); -- error about partitioned table
-ERROR: cannot get raw page from relation "test_partitioned"
-DETAIL: This operation is not supported for partitioned tables.
-select get_raw_page('test_partitioned_index', 0); -- error about partitioned index
-ERROR: cannot get raw page from relation "test_partitioned_index"
-DETAIL: This operation is not supported for partitioned indexes.
--- a regular table which is a member of a partition set should work though
-create table test_part1 partition of test_partitioned for values from ( 1 ) to (100);
-select get_raw_page('test_part1', 0); -- get farther and error about empty table
-ERROR: block number 0 is out of range for relation "test_part1"
-drop table test_partitioned;
--- check null bitmap alignment for table whose number of attributes is multiple of 8
... |
| regress |
diff -U3 /home/postgres/postgres/contrib/pg_overexplain/expected/pg_overexplain.out /home/postgres/postgres/build/testru...
--- /home/postgres/postgres/contrib/pg_overexplain/expected/pg_overexplain.out 2025-12-11 15:05:18.765507646 +0000
+++ /home/postgres/postgres/build/testrun/pg_overexplain/regress/results/pg_overexplain.out 2025-12-11 15:08:37.03044781...
@@ -52,440 +52,7 @@
-- Create a partitioned table.
CREATE TABLE vegetables (id serial, name text, genus text)
PARTITION BY LIST (genus);
-CREATE TABLE daucus PARTITION OF vegetables FOR VALUES IN ('daucus');
-CREATE TABLE brassica PARTITION OF vegetables FOR VALUES IN ('brassica');
-INSERT INTO vegetables (name, genus)
- VALUES ('carrot', 'daucus'), ('bok choy', 'brassica'),
- ('brocooli', 'brassica'), ('cauliflower', 'brassica'),
- ('cabbage', 'brassica'), ('kohlrabi', 'brassica'),
- ('rutabaga', 'brassica'), ('turnip', 'brassica');
-VACUUM ANALYZE vegetables;
--- We filter relation OIDs out of the test output in order to avoid
--- test instability. This is currently only needed for EXPLAIN (DEBUG), not
--- EXPLAIN (RANGE_TABLE). Also suppress actual row counts, which are not
--- stable (e.g. 1/8 is 0.12 on some buildfarm machines and 0.13 on others).
-CREATE FUNCTION explain_filter(text) RETURNS SETOF text
... |
| regress |
diff -U3 /home/postgres/postgres/contrib/pg_prewarm/expected/pg_prewarm.out /home/postgres/postgres/build/testrun/pg_pre...
--- /home/postgres/postgres/contrib/pg_prewarm/expected/pg_prewarm.out 2025-12-11 15:05:18.777461042 +0000
+++ /home/postgres/postgres/build/testrun/pg_prewarm/regress/results/pg_prewarm.out 2025-12-11 15:08:37.109918809 +0000
@@ -2,9 +2,7 @@
CREATE EXTENSION pg_prewarm;
-- pg_prewarm() should fail if the target relation has no storage.
CREATE TABLE test (c1 int) PARTITION BY RANGE (c1);
-SELECT pg_prewarm('test', 'buffer');
-ERROR: relation "test" does not have storage
-DETAIL: This operation is not supported for partitioned tables.
--- Cleanup
-DROP TABLE test;
-DROP EXTENSION pg_prewarm;
+server closed the connection unexpectedly
+ This probably means the server terminated abnormally
+ before or while processing the request.
+connection to server was lost |
| regress |
diff -U3 /home/postgres/postgres/contrib/pg_stat_statements/expected/utility.out /home/postgres/postgres/build/testrun/p...
--- /home/postgres/postgres/contrib/pg_stat_statements/expected/utility.out 2025-12-11 15:05:18.806859883 +0000
+++ /home/postgres/postgres/build/testrun/pg_stat_statements/regress/results/utility.out 2025-12-11 15:08:37.585008885 +...
@@ -44,696 +44,7 @@
-- Partitions
CREATE TABLE pt_stats (a int, b int) PARTITION BY range (a);
-CREATE TABLE pt_stats1 (a int, b int);
-ALTER TABLE pt_stats ATTACH PARTITION pt_stats1 FOR VALUES FROM (0) TO (100);
-CREATE TABLE pt_stats2 PARTITION OF pt_stats FOR VALUES FROM (100) TO (200);
-CREATE INDEX pt_stats_index ON ONLY pt_stats (a);
-CREATE INDEX pt_stats2_index ON ONLY pt_stats2 (a);
-ALTER INDEX pt_stats_index ATTACH PARTITION pt_stats2_index;
-DROP TABLE pt_stats;
--- Views
-CREATE VIEW view_stats AS SELECT 1::int AS a, 2::int AS b;
-ALTER VIEW view_stats ALTER COLUMN a SET DEFAULT 2;
-DROP VIEW view_stats;
--- Foreign tables
-CREATE FOREIGN DATA WRAPPER wrapper_stats;
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/geometry.out /home/postgres/postgres/build/testrun/pg_upgrade...
--- /home/postgres/postgres/src/test/regress/expected/geometry.out 2025-12-11 15:05:26.447243392 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/geometry.out 2025-12-11 15:07:48.868000...
@@ -4176,1148 +4176,10 @@
-- Distance to polygon
SELECT p1.f1, p2.f1, p1.f1 <-> p2.f1 FROM POLYGON_TBL p1, POLYGON_TBL p2;
- f1 | f1 | ?column?
-----------------------------+----------------------------+----------------
- ((2,0),(2,4),(0,0)) | ((2,0),(2,4),(0,0)) | 0
- ((2,0),(2,4),(0,0)) | ((3,1),(3,3),(1,0)) | 0
- ((2,0),(2,4),(0,0)) | ((1,2),(3,4),(5,6),(7,8)) | 0
- ((2,0),(2,4),(0,0)) | ((7,8),(5,6),(3,4),(1,2)) | 0
- ((2,0),(2,4),(0,0)) | ((1,2),(7,8),(5,6),(3,-4)) | 0
- ((2,0),(2,4),(0,0)) | ((0,0)) | 0
- ((2,0),(2,4),(0,0)) | ((0,1),(0,1)) | 0.4472135955
- ((3,1),(3,3),(1,0)) | ((2,0),(2,4),(0,0)) | 0
- ((3,1),(3,3),(1,0)) | ((3,1),(3,3),(1,0)) | 0
- ((3,1),(3,3),(1,0)) | ((1,2),(3,4),(5,6),(7,8)) | 0.707106781187
- ((3,1),(3,3),(1,0)) | ((7,8),(5,6),(3,4),(1,2)) | 0.707106781187
... |
| regress |
diff -U3 /home/postgres/postgres/contrib/pg_visibility/expected/pg_visibility.out /home/postgres/postgres/build/testrun/...
--- /home/postgres/postgres/contrib/pg_visibility/expected/pg_visibility.out 2025-12-11 15:05:18.895689954 +0000
+++ /home/postgres/postgres/build/testrun/pg_visibility/regress/results/pg_visibility.out 2025-12-11 15:08:38.742759646 ...
@@ -39,240 +39,7 @@
--
-- partitioned tables (the parent ones) don't have visibility maps
create table test_partitioned (a int) partition by list (a);
--- these should all fail
-select pg_visibility('test_partitioned', 0);
-ERROR: relation "test_partitioned" is of wrong relation kind
-DETAIL: This operation is not supported for partitioned tables.
-select pg_visibility_map('test_partitioned');
-ERROR: relation "test_partitioned" is of wrong relation kind
-DETAIL: This operation is not supported for partitioned tables.
-select pg_visibility_map_summary('test_partitioned');
-ERROR: relation "test_partitioned" is of wrong relation kind
-DETAIL: This operation is not supported for partitioned tables.
-select pg_check_frozen('test_partitioned');
-ERROR: relation "test_partitioned" is of wrong relation kind
-DETAIL: This operation is not supported for partitioned tables.
... |
| regress |
diff -U3 /home/postgres/postgres/contrib/pgstattuple/expected/pgstattuple.out /home/postgres/postgres/build/testrun/pgst...
--- /home/postgres/postgres/contrib/pgstattuple/expected/pgstattuple.out 2025-12-11 15:05:19.037442720 +0000
+++ /home/postgres/postgres/build/testrun/pgstattuple/regress/results/pgstattuple.out 2025-12-11 15:08:37.559316905 +000...
@@ -152,154 +152,7 @@
ERROR: relation "test_hashidx" is not a GIN index
-- check that using any of these functions with unsupported relations will fail
create table test_partitioned (a int) partition by range (a);
-create index test_partitioned_index on test_partitioned(a);
-create index test_partitioned_hash_index on test_partitioned using hash(a);
--- these should all fail
-select pgstattuple('test_partitioned');
-ERROR: cannot get tuple-level statistics for relation "test_partitioned"
-DETAIL: This operation is not supported for partitioned tables.
-select pgstattuple('test_partitioned_index');
-ERROR: cannot get tuple-level statistics for relation "test_partitioned_index"
-DETAIL: This operation is not supported for partitioned indexes.
-select pgstattuple_approx('test_partitioned');
-ERROR: relation "test_partitioned" is of wrong relation kind
-DETAIL: This operation is not supported for partitioned tables.
-select pg_relpages('test_partitioned');
... |
| regress |
diff -U3 /home/postgres/postgres/contrib/postgres_fdw/expected/postgres_fdw.out /home/postgres/postgres/build/testrun/po...
--- /home/postgres/postgres/contrib/postgres_fdw/expected/postgres_fdw.out 2025-12-11 15:05:19.067540593 +0000
+++ /home/postgres/postgres/build/testrun/postgres_fdw/regress/results/postgres_fdw.out 2025-12-11 15:08:40.457241234 +0...
@@ -4542,8180 +4542,7 @@
DROP FOREIGN TABLE reindex_foreign;
-- partitions and foreign tables
CREATE TABLE reind_fdw_parent (c1 int) PARTITION BY RANGE (c1);
-CREATE TABLE reind_fdw_0_10 PARTITION OF reind_fdw_parent
- FOR VALUES FROM (0) TO (10);
-CREATE FOREIGN TABLE reind_fdw_10_20 PARTITION OF reind_fdw_parent
- FOR VALUES FROM (10) TO (20)
- SERVER loopback OPTIONS (table_name 'reind_local_10_20');
-REINDEX TABLE reind_fdw_parent; -- ok
-REINDEX TABLE CONCURRENTLY reind_fdw_parent; -- ok
-DROP TABLE reind_fdw_parent;
--- ===================================================================
--- conversion error
--- ===================================================================
-ALTER FOREIGN TABLE ft1 ALTER COLUMN c8 TYPE int;
-SELECT * FROM ft1 ftx(x1,x2,x3,x4,x5,x6,x7,x8) WHERE x1 = 1; -- ERROR
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/geometry.out /home/postgres/postgres/build/testrun/recovery/0...
--- /home/postgres/postgres/src/test/regress/expected/geometry.out 2025-12-11 15:05:26.447243392 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/geometry.out 2025-12-11 15:08:15.3633...
@@ -458,4866 +458,10 @@
ERROR: value out of range: underflow
-- Divide by point
SELECT p1.f1, p2.f1, p1.f1 / p2.f1 FROM POINT_TBL p1, POINT_TBL p2 WHERE p2.f1[0] BETWEEN 1 AND 1000;
- f1 | f1 | ?column?
--------------------+------------+-------------------------------------------
- (0,0) | (5.1,34.5) | (0,0)
- (0,0) | (10,10) | (0,0)
- (-10,0) | (5.1,34.5) | (-0.0419318237877,0.283656455034)
- (-10,0) | (10,10) | (-0.5,0.5)
- (-3,4) | (5.1,34.5) | (0.100883034877,0.101869666025)
- (-3,4) | (10,10) | (0.05,0.35)
- (5.1,34.5) | (5.1,34.5) | (1,0)
- (5.1,34.5) | (10,10) | (1.98,1.47)
- (-5,-12) | (5.1,34.5) | (-0.361353657935,0.0915100389719)
- (-5,-12) | (10,10) | (-0.85,-0.35)
- (1e-300,-1e-300) | (5.1,34.5) | (-2.41724631247e-302,-3.25588278822e-302)
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/horology.out /home/postgres/postgres/build/testrun/regress/re...
--- /home/postgres/postgres/src/test/regress/expected/horology.out 2025-12-11 15:05:26.455027126 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/horology.out 2025-12-11 15:07:43.447064196 +0000
@@ -3487,404 +3487,10 @@
(1 row)
SELECT to_date('3 4 21 01', 'W MM CC YY');
- to_date
-------------
- 04-15-2001
-(1 row)
-
-SELECT to_date('2458872', 'J');
- to_date
-------------
- 01-23-2020
-(1 row)
-
---
--- Check handling of BC dates
... |
| regress |
diff -U3 /home/postgres/postgres/contrib/seg/expected/security.out /home/postgres/postgres/build/testrun/seg/regress/res...
--- /home/postgres/postgres/contrib/seg/expected/security.out 2025-12-11 15:05:19.102631343 +0000
+++ /home/postgres/postgres/build/testrun/seg/regress/results/security.out 2025-12-11 15:08:39.735447427 +0000
@@ -22,11 +22,7 @@
CREATE SCHEMA test_schema
CREATE TABLE t(i int) PARTITION BY RANGE (i)
CREATE TABLE p1 PARTITION OF t FOR VALUES FROM (1) TO (regress_seg_schema.exfun(2));
-DROP SCHEMA test_schema CASCADE;
-NOTICE: drop cascades to 3 other objects
-DETAIL: drop cascades to table test_schema.t
-drop cascades to extension seg
-drop cascades to operator test_schema.=(oid,regclass)
-RESET ROLE;
-DROP OWNED BY regress_seg_role;
-DROP ROLE regress_seg_role;
+server closed the connection unexpectedly
+ This probably means the server terminated abnormally
+ before or while processing the request.
+connection to server was lost
diff -U3 /home/postgres/postgres/contrib/seg/expected/seg.out /home/postgres/postgres/build/testrun/seg/regress/results/...
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/modules/test_ddl_deparse/expected/alter_table.out /home/postgres/postgres/buil...
--- /home/postgres/postgres/src/test/modules/test_ddl_deparse/expected/alter_table.out 2025-12-11 15:05:25.819178581 +00...
+++ /home/postgres/postgres/build/testrun/test_ddl_deparse/regress/results/alter_table.out 2025-12-11 15:08:47.915722658...
@@ -101,43 +101,7 @@
CREATE TABLE part (
a int
) PARTITION BY RANGE (a);
-NOTICE: DDL test: type simple, tag CREATE TABLE
-CREATE TABLE part1 PARTITION OF part FOR VALUES FROM (1) to (100);
-NOTICE: DDL test: type simple, tag CREATE TABLE
-CREATE TABLE part2 (a int);
-NOTICE: DDL test: type simple, tag CREATE TABLE
-ALTER TABLE part ATTACH PARTITION part2 FOR VALUES FROM (101) to (200);
-NOTICE: DDL test: type alter table, tag ALTER TABLE
-NOTICE: subcommand: type ATTACH PARTITION desc table part2
-ALTER TABLE part DETACH PARTITION part2;
-NOTICE: DDL test: type alter table, tag ALTER TABLE
-NOTICE: subcommand: type DETACH PARTITION desc table part2
-DROP TABLE part2;
-ALTER TABLE part ADD PRIMARY KEY (a);
... |
|
Linux - Debian Trixie - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/insert.out /tmp/cirrus-ci-build/src/test/regress/results/insert....
--- /tmp/cirrus-ci-build/src/test/regress/expected/insert.out 2025-12-11 15:05:17.963374287 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/insert.out 2025-12-11 15:09:04.109984229 +0000
@@ -300,797 +300,7 @@
a text,
b int
) partition by range (a, (b+0));
--- no partitions, so fail
-insert into range_parted values ('a', 11);
-ERROR: no partition of relation "range_parted" found for row
-DETAIL: Partition key of the failing row contains (a, (b + 0)) = (a, 11).
-create table part1 partition of range_parted for values from ('a', 1) to ('a', 10);
-create table part2 partition of range_parted for values from ('a', 10) to ('a', 20);
-create table part3 partition of range_parted for values from ('b', 1) to ('b', 10);
-create table part4 partition of range_parted for values from ('b', 10) to ('b', 20);
--- fail
-insert into part1 values ('a', 11);
-ERROR: new row for relation "part1" violates partition constraint
-DETAIL: Failing row contains (a, 11).
-insert into part1 values ('b', 1);
... |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/amcheck/expected/check_btree.out /tmp/cirrus-ci-build/build/testrun/amcheck/regres...
--- /tmp/cirrus-ci-build/contrib/amcheck/expected/check_btree.out 2025-12-11 15:05:00.854561000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/amcheck/regress/results/check_btree.out 2025-12-11 15:08:17.874632000 +0000
@@ -63,221 +63,7 @@
-- verify partitioned indexes are rejected (error)
BEGIN;
CREATE TABLE bttest_partitioned (a int, b int) PARTITION BY list (a);
-CREATE INDEX bttest_btree_partitioned_idx ON bttest_partitioned USING btree (b);
-SELECT bt_index_parent_check('bttest_btree_partitioned_idx');
-ERROR: expected index as targets for verification
-DETAIL: This operation is not supported for partitioned indexes.
-ROLLBACK;
--- normal check outside of xact
-SELECT bt_index_check('bttest_a_idx');
- bt_index_check
-----------------
-
-(1 row)
-
--- more expansive tests
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/btree_gist/expected/partitions.out /tmp/cirrus-ci-build/build/testrun/btree_gist/r...
--- /tmp/cirrus-ci-build/contrib/btree_gist/expected/partitions.out 2025-12-11 15:05:00.899554000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/btree_gist/regress/results/partitions.out 2025-12-11 15:08:22.922183000 +0000
@@ -7,76 +7,7 @@
valid_at daterange,
exclude using gist (id with =, valid_at with &&)
) partition by range (id);
-create table parttmp_1_to_10 partition of parttmp for values from (1) to (10);
-create table parttmp_11_to_20 partition of parttmp for values from (11) to (20);
-insert into parttmp (id, valid_at) values
- (1, '[2000-01-01, 2000-02-01)'),
- (1, '[2000-02-01, 2000-03-01)'),
- (2, '[2000-01-01, 2000-02-01)'),
- (11, '[2000-01-01, 2000-02-01)'),
- (11, '[2000-02-01, 2000-03-01)'),
- (12, '[2000-01-01, 2000-02-01)');
-select * from parttmp order by id, valid_at;
- id | valid_at
-----+-------------------------
- 1 | [01-01-2000,02-01-2000)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/modules/delay_execution/expected/partition-addition.out /tmp/cirrus-ci-build/buil...
--- /tmp/cirrus-ci-build/src/test/modules/delay_execution/expected/partition-addition.out 2025-12-11 15:05:02.475775000 ...
+++ /tmp/cirrus-ci-build/build/testrun/delay_execution/isolation/results/partition-addition.out 2025-12-11 15:08:41.2453...
@@ -1,27 +1,6 @@
Parsed test spec with 2 sessions
starting permutation: s2lock s1exec s2addp s2unlock
-step s2lock: SELECT pg_advisory_lock(12345);
-pg_advisory_lock
-----------------
-
-(1 row)
-
-step s1exec: LOAD 'delay_execution';
- SET delay_execution.post_planning_lock_id = 12345;
- SELECT * FROM foo WHERE a <> 1 AND a <> (SELECT 3); <waiting ...>
-step s2addp: CREATE TABLE foo2 (LIKE foo);
- ALTER TABLE foo ATTACH PARTITION foo2 FOR VALUES IN (2);
- INSERT INTO foo VALUES (2, 'ADD2');
-step s2unlock: SELECT pg_advisory_unlock(12345);
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/file_fdw/expected/file_fdw.out /tmp/cirrus-ci-build/build/testrun/file_fdw/regress...
--- /tmp/cirrus-ci-build/contrib/file_fdw/expected/file_fdw.out 2025-12-11 15:05:00.914901000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/file_fdw/regress/results/file_fdw.out 2025-12-11 15:08:21.695757000 +0000
@@ -375,182 +375,7 @@
-- declarative partitioning tests
SET ROLE regress_file_fdw_superuser;
CREATE TABLE pt (a int, b text) partition by list (a);
-\set filename :abs_srcdir '/data/list1.csv'
-CREATE FOREIGN TABLE p1 partition of pt for values in (1) SERVER file_server
-OPTIONS (format 'csv', filename :'filename', delimiter ',');
-CREATE TABLE p2 partition of pt for values in (2);
-SELECT tableoid::regclass, * FROM pt;
- tableoid | a | b
-----------+---+-----
- p1 | 1 | foo
- p1 | 1 | bar
-(2 rows)
-
-SELECT tableoid::regclass, * FROM p1;
- tableoid | a | b
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/reindex-concurrently-upsert-partitioned.out /tm...
--- /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/reindex-concurrently-upsert-partitioned.out 2025-12-...
+++ /tmp/cirrus-ci-build/build/testrun/injection_points/isolation/results/reindex-concurrently-upsert-partitioned.out 20...
@@ -1,238 +1,6 @@
Parsed test spec with 4 sessions
starting permutation: s3_setup_wait_before_set_dead s3_start_reindex s1_start_upsert s4_wakeup_to_set_dead s2_start_ups...
-injection_points_attach
------------------------
-
-(1 row)
-
-injection_points_attach
------------------------
-
-(1 row)
-
-injection_points_set_local
---------------------------
-
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/isolation/expected/detach-partition-concurrently-1.out /tmp/cirrus-ci-build/build...
--- /tmp/cirrus-ci-build/src/test/isolation/expected/detach-partition-concurrently-1.out 2025-12-11 15:05:02.443502000 +...
+++ /tmp/cirrus-ci-build/build/testrun/isolation/isolation/results/detach-partition-concurrently-1.out 2025-12-11 15:07:...
@@ -1,288 +1,6 @@
Parsed test spec with 3 sessions
starting permutation: s1b s1s s2detach s1s s1c s1s
-step s1b: BEGIN;
-step s1s: SELECT * FROM d_listp;
-a
--
-1
-2
-(2 rows)
-
-step s2detach: ALTER TABLE d_listp DETACH PARTITION d_listp2 CONCURRENTLY; <waiting ...>
-step s1s: SELECT * FROM d_listp;
-a
--
-1
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/pageinspect/expected/page.out /tmp/cirrus-ci-build/build/testrun/pageinspect/regre...
--- /tmp/cirrus-ci-build/contrib/pageinspect/expected/page.out 2025-12-11 15:05:00.939269000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pageinspect/regress/results/page.out 2025-12-11 15:08:27.426987000 +0000
@@ -179,110 +179,7 @@
-- check that using any of these functions with a partitioned table or index
-- would fail
create table test_partitioned (a int) partition by range (a);
-create index test_partitioned_index on test_partitioned (a);
-select get_raw_page('test_partitioned', 0); -- error about partitioned table
-ERROR: cannot get raw page from relation "test_partitioned"
-DETAIL: This operation is not supported for partitioned tables.
-select get_raw_page('test_partitioned_index', 0); -- error about partitioned index
-ERROR: cannot get raw page from relation "test_partitioned_index"
-DETAIL: This operation is not supported for partitioned indexes.
--- a regular table which is a member of a partition set should work though
-create table test_part1 partition of test_partitioned for values from ( 1 ) to (100);
-select get_raw_page('test_part1', 0); -- get farther and error about empty table
-ERROR: block number 0 is out of range for relation "test_part1"
-drop table test_partitioned;
--- check null bitmap alignment for table whose number of attributes is multiple of 8
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/pg_overexplain/expected/pg_overexplain.out /tmp/cirrus-ci-build/build/testrun/pg_o...
--- /tmp/cirrus-ci-build/contrib/pg_overexplain/expected/pg_overexplain.out 2025-12-11 15:05:00.948114000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_overexplain/regress/results/pg_overexplain.out 2025-12-11 15:08:28.542265000 +...
@@ -52,440 +52,7 @@
-- Create a partitioned table.
CREATE TABLE vegetables (id serial, name text, genus text)
PARTITION BY LIST (genus);
-CREATE TABLE daucus PARTITION OF vegetables FOR VALUES IN ('daucus');
-CREATE TABLE brassica PARTITION OF vegetables FOR VALUES IN ('brassica');
-INSERT INTO vegetables (name, genus)
- VALUES ('carrot', 'daucus'), ('bok choy', 'brassica'),
- ('brocooli', 'brassica'), ('cauliflower', 'brassica'),
- ('cabbage', 'brassica'), ('kohlrabi', 'brassica'),
- ('rutabaga', 'brassica'), ('turnip', 'brassica');
-VACUUM ANALYZE vegetables;
--- We filter relation OIDs out of the test output in order to avoid
--- test instability. This is currently only needed for EXPLAIN (DEBUG), not
--- EXPLAIN (RANGE_TABLE). Also suppress actual row counts, which are not
--- stable (e.g. 1/8 is 0.12 on some buildfarm machines and 0.13 on others).
-CREATE FUNCTION explain_filter(text) RETURNS SETOF text
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/pg_prewarm/expected/pg_prewarm.out /tmp/cirrus-ci-build/build/testrun/pg_prewarm/r...
--- /tmp/cirrus-ci-build/contrib/pg_prewarm/expected/pg_prewarm.out 2025-12-11 15:05:00.949423000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_prewarm/regress/results/pg_prewarm.out 2025-12-11 15:08:28.927840000 +0000
@@ -2,9 +2,7 @@
CREATE EXTENSION pg_prewarm;
-- pg_prewarm() should fail if the target relation has no storage.
CREATE TABLE test (c1 int) PARTITION BY RANGE (c1);
-SELECT pg_prewarm('test', 'buffer');
-ERROR: relation "test" does not have storage
-DETAIL: This operation is not supported for partitioned tables.
--- Cleanup
-DROP TABLE test;
-DROP EXTENSION pg_prewarm;
+server closed the connection unexpectedly
+ This probably means the server terminated abnormally
+ before or while processing the request.
+connection to server was lost |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/pg_stat_statements/expected/utility.out /tmp/cirrus-ci-build/build/testrun/pg_stat...
--- /tmp/cirrus-ci-build/contrib/pg_stat_statements/expected/utility.out 2025-12-11 15:05:00.952563000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_stat_statements/regress/results/utility.out 2025-12-11 15:08:31.108111000 +000...
@@ -44,696 +44,7 @@
-- Partitions
CREATE TABLE pt_stats (a int, b int) PARTITION BY range (a);
-CREATE TABLE pt_stats1 (a int, b int);
-ALTER TABLE pt_stats ATTACH PARTITION pt_stats1 FOR VALUES FROM (0) TO (100);
-CREATE TABLE pt_stats2 PARTITION OF pt_stats FOR VALUES FROM (100) TO (200);
-CREATE INDEX pt_stats_index ON ONLY pt_stats (a);
-CREATE INDEX pt_stats2_index ON ONLY pt_stats2 (a);
-ALTER INDEX pt_stats_index ATTACH PARTITION pt_stats2_index;
-DROP TABLE pt_stats;
--- Views
-CREATE VIEW view_stats AS SELECT 1::int AS a, 2::int AS b;
-ALTER VIEW view_stats ALTER COLUMN a SET DEFAULT 2;
-DROP VIEW view_stats;
--- Foreign tables
-CREATE FOREIGN DATA WRAPPER wrapper_stats;
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/geometry.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_p...
--- /tmp/cirrus-ci-build/src/test/regress/expected/geometry.out 2025-12-11 15:05:02.571569000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/geometry.out 2025-12-11 15:07:08.616318000...
@@ -4469,855 +4469,10 @@
-- Right of circle
SELECT c1.f1, c2.f1 FROM CIRCLE_TBL c1, CIRCLE_TBL c2 WHERE c1.f1 >> c2.f1;
- f1 | f1
-----------------+-----------
- <(100,200),10> | <(5,1),3>
- <(100,200),10> | <(1,3),5>
- <(100,200),10> | <(1,2),3>
- <(100,200),10> | <(3,5),0>
-(4 rows)
-
--- Overlap or right of circle
-SELECT c1.f1, c2.f1 FROM CIRCLE_TBL c1, CIRCLE_TBL c2 WHERE c1.f1 &> c2.f1;
- f1 | f1
-----------------+----------------
- <(5,1),3> | <(5,1),3>
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/pg_visibility/expected/pg_visibility.out /tmp/cirrus-ci-build/build/testrun/pg_vis...
--- /tmp/cirrus-ci-build/contrib/pg_visibility/expected/pg_visibility.out 2025-12-11 15:05:00.962007000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_visibility/regress/results/pg_visibility.out 2025-12-11 15:08:32.679761000 +00...
@@ -39,240 +39,7 @@
--
-- partitioned tables (the parent ones) don't have visibility maps
create table test_partitioned (a int) partition by list (a);
--- these should all fail
-select pg_visibility('test_partitioned', 0);
-ERROR: relation "test_partitioned" is of wrong relation kind
-DETAIL: This operation is not supported for partitioned tables.
-select pg_visibility_map('test_partitioned');
-ERROR: relation "test_partitioned" is of wrong relation kind
-DETAIL: This operation is not supported for partitioned tables.
-select pg_visibility_map_summary('test_partitioned');
-ERROR: relation "test_partitioned" is of wrong relation kind
-DETAIL: This operation is not supported for partitioned tables.
-select pg_check_frozen('test_partitioned');
-ERROR: relation "test_partitioned" is of wrong relation kind
-DETAIL: This operation is not supported for partitioned tables.
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/pgstattuple/expected/pgstattuple.out /tmp/cirrus-ci-build/build/testrun/pgstattupl...
--- /tmp/cirrus-ci-build/contrib/pgstattuple/expected/pgstattuple.out 2025-12-11 15:05:00.977554000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pgstattuple/regress/results/pgstattuple.out 2025-12-11 15:08:31.315776000 +0000
@@ -152,154 +152,7 @@
ERROR: relation "test_hashidx" is not a GIN index
-- check that using any of these functions with unsupported relations will fail
create table test_partitioned (a int) partition by range (a);
-create index test_partitioned_index on test_partitioned(a);
-create index test_partitioned_hash_index on test_partitioned using hash(a);
--- these should all fail
-select pgstattuple('test_partitioned');
-ERROR: cannot get tuple-level statistics for relation "test_partitioned"
-DETAIL: This operation is not supported for partitioned tables.
-select pgstattuple('test_partitioned_index');
-ERROR: cannot get tuple-level statistics for relation "test_partitioned_index"
-DETAIL: This operation is not supported for partitioned indexes.
-select pgstattuple_approx('test_partitioned');
-ERROR: relation "test_partitioned" is of wrong relation kind
-DETAIL: This operation is not supported for partitioned tables.
-select pg_relpages('test_partitioned');
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out /tmp/cirrus-ci-build/build/testrun/postgres...
--- /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out 2025-12-11 15:05:00.989185000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/postgres_fdw/regress/results/postgres_fdw.out 2025-12-11 15:08:35.271219000 +0000
@@ -4542,8180 +4542,7 @@
DROP FOREIGN TABLE reindex_foreign;
-- partitions and foreign tables
CREATE TABLE reind_fdw_parent (c1 int) PARTITION BY RANGE (c1);
-CREATE TABLE reind_fdw_0_10 PARTITION OF reind_fdw_parent
- FOR VALUES FROM (0) TO (10);
-CREATE FOREIGN TABLE reind_fdw_10_20 PARTITION OF reind_fdw_parent
- FOR VALUES FROM (10) TO (20)
- SERVER loopback OPTIONS (table_name 'reind_local_10_20');
-REINDEX TABLE reind_fdw_parent; -- ok
-REINDEX TABLE CONCURRENTLY reind_fdw_parent; -- ok
-DROP TABLE reind_fdw_parent;
--- ===================================================================
--- conversion error
--- ===================================================================
-ALTER FOREIGN TABLE ft1 ALTER COLUMN c8 TYPE int;
-SELECT * FROM ft1 ftx(x1,x2,x3,x4,x5,x6,x7,x8) WHERE x1 = 1; -- ERROR
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/geometry.out /tmp/cirrus-ci-build/build/testrun/recovery/027_str...
--- /tmp/cirrus-ci-build/src/test/regress/expected/geometry.out 2025-12-11 15:05:02.571569000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/geometry.out 2025-12-11 15:07:55.8355750...
@@ -5176,148 +5176,10 @@
ERROR: division by zero
-- Distance to polygon
SELECT c.f1, p.f1, c.f1 <-> p.f1 FROM CIRCLE_TBL c, POLYGON_TBL p;
- f1 | f1 | ?column?
-----------------+----------------------------+----------------
- <(5,1),3> | ((2,0),(2,4),(0,0)) | 0
- <(5,1),3> | ((3,1),(3,3),(1,0)) | 0
- <(5,1),3> | ((1,2),(3,4),(5,6),(7,8)) | 0.535533905933
- <(5,1),3> | ((7,8),(5,6),(3,4),(1,2)) | 0.535533905933
- <(5,1),3> | ((1,2),(7,8),(5,6),(3,-4)) | 0
- <(5,1),3> | ((0,0)) | 2.09901951359
- <(5,1),3> | ((0,1),(0,1)) | 2
- <(1,2),100> | ((2,0),(2,4),(0,0)) | 0
- <(1,2),100> | ((3,1),(3,3),(1,0)) | 0
- <(1,2),100> | ((1,2),(3,4),(5,6),(7,8)) | 0
- <(1,2),100> | ((7,8),(5,6),(3,4),(1,2)) | 0
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/horology.out /tmp/cirrus-ci-build/build/testrun/regress/regress/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/horology.out 2025-12-11 15:05:02.574260000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/horology.out 2025-12-11 15:07:10.083147000 +0000
@@ -3086,805 +3086,10 @@
(1 row)
SELECT to_timestamp('1985 \ 12', 'YYYY \\ DD');
- to_timestamp
-------------------------------
- Sat Jan 12 00:00:00 1985 PST
-(1 row)
-
-SELECT to_timestamp('My birthday-> Year: 1976, Month: May, Day: 16',
- '"My birthday-> Year:" YYYY, "Month:" FMMonth, "Day:" DD');
- to_timestamp
-------------------------------
- Sun May 16 00:00:00 1976 PDT
-(1 row)
-
-SELECT to_timestamp('1,582nd VIII 21', 'Y,YYYth FMRM DD');
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/seg/expected/security.out /tmp/cirrus-ci-build/build/testrun/seg/regress/results/s...
--- /tmp/cirrus-ci-build/contrib/seg/expected/security.out 2025-12-11 15:05:00.997178000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/seg/regress/results/security.out 2025-12-11 15:08:34.219605000 +0000
@@ -22,11 +22,7 @@
CREATE SCHEMA test_schema
CREATE TABLE t(i int) PARTITION BY RANGE (i)
CREATE TABLE p1 PARTITION OF t FOR VALUES FROM (1) TO (regress_seg_schema.exfun(2));
-DROP SCHEMA test_schema CASCADE;
-NOTICE: drop cascades to 3 other objects
-DETAIL: drop cascades to table test_schema.t
-drop cascades to extension seg
-drop cascades to operator test_schema.=(oid,regclass)
-RESET ROLE;
-DROP OWNED BY regress_seg_role;
-DROP ROLE regress_seg_role;
+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/contrib/seg/expected/seg.out /tmp/cirrus-ci-build/build/testrun/seg/regress/results/seg.ou...
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/modules/test_ddl_deparse/expected/alter_table.out /tmp/cirrus-ci-build/build/test...
--- /tmp/cirrus-ci-build/src/test/modules/test_ddl_deparse/expected/alter_table.out 2025-12-11 15:05:02.490566000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_ddl_deparse/regress/results/alter_table.out 2025-12-11 15:08:48.341553000 +0...
@@ -101,43 +101,7 @@
CREATE TABLE part (
a int
) PARTITION BY RANGE (a);
-NOTICE: DDL test: type simple, tag CREATE TABLE
-CREATE TABLE part1 PARTITION OF part FOR VALUES FROM (1) to (100);
-NOTICE: DDL test: type simple, tag CREATE TABLE
-CREATE TABLE part2 (a int);
-NOTICE: DDL test: type simple, tag CREATE TABLE
-ALTER TABLE part ATTACH PARTITION part2 FOR VALUES FROM (101) to (200);
-NOTICE: DDL test: type alter table, tag ALTER TABLE
-NOTICE: subcommand: type ATTACH PARTITION desc table part2
-ALTER TABLE part DETACH PARTITION part2;
-NOTICE: DDL test: type alter table, tag ALTER TABLE
-NOTICE: subcommand: type DETACH PARTITION desc table part2
-DROP TABLE part2;
-ALTER TABLE part ADD PRIMARY KEY (a);
... |
| 57/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-12-11 14:28:44.251399200 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_stored.out 2025-12-11 14:32:44.322402500 +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-12-11 14:28:44.251399200 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out 2025-12-11 14:32:54.322401100 +...
@@ -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-12-11 14:28:44.251399200 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/generated_stored.out 2025-12-11 14:36:05.019081400 ...
@@ -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-12-11 14:28:44.251399200 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out 2025-12-11 14:36:16.170448600...
@@ -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-12-11 14:28:44.251399200 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/generated_stored.out 2025-12-11 14:32:37.017723900 +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-12-11 14:28:44.251399200 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/generated_virtual.out 2025-12-11 14:32:48.221816600 +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-12-11 14:28:32.300992300 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_stored.out 2025-12-11 14:31:42.179506000 +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-12-11 14:28:32.300992300 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out 2025-12-11 14:31:56.497377900 +...
@@ -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-12-11 14:28:32.300992300 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/generated_stored.out 2025-12-11 14:34:31.206845500 ...
@@ -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-12-11 14:28:32.300992300 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out 2025-12-11 14:34:48.412907500...
@@ -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-12-11 14:28:32.300992300 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/generated_stored.out 2025-12-11 14:31:36.202451000 +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-12-11 14:28:32.300992300 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/generated_virtual.out 2025-12-11 14:31:52.413395100 +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
... |
|
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-12-11 14:28:27.450096780 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_stored.out 2025-12-11 14:30:14.6...
@@ -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-12-11 14:28:27.450096780 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out 2025-12-11 14:30:24....
@@ -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-12-11 14:28:27.450096780 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/generated_stored.out 2025-12-11 14:31:33...
@@ -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-12-11 14:28:27.450096780 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out 2025-12-11 14:31:4...
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_stored.out /tmp/cirrus-ci-build/build/testrun/regress/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_stored.out 2025-12-11 14:28:27.450096780 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/generated_stored.out 2025-12-11 14:30:16.005406298 +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-12-11 14:28:27.450096780 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/generated_virtual.out 2025-12-11 14:30:26.918149388 +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-12-11 14:28:26
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_stored.out 2025-12-11 14:30:15
@@ -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-12-11 14:28:26
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out 2025-12-11 14:30:21
@@ -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-12-11 14:28:26
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/generated_stored.out 2025-12-11 14:32:12
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff -U3 /Users/admin/pgsql/src/test/regress/expected/generated_virtual.out /Users/admin/pgsql/build/testrun/recovery/02...
--- /Users/admin/pgsql/src/test/regress/expected/generated_virtual.out 2025-12-11 14:28:26
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out 2025-12-11 14:32:22
@@ -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-12-11 14:28:26
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/generated_stored.out 2025-12-11 14:30:15
@@ -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-12-11 14:28:26
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/generated_virtual.out 2025-12-11 14:30:21
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/generated_stored.out /home/postgres/postgres/build/testrun/pg...
--- /home/postgres/postgres/src/test/regress/expected/generated_stored.out 2025-12-11 14:28:53.235881623 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_stored.out 2025-12-11 14:30:1...
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff -U3 /home/postgres/postgres/src/test/regress/expected/generated_virtual.out /home/postgres/postgres/build/testrun/p...
--- /home/postgres/postgres/src/test/regress/expected/generated_virtual.out 2025-12-11 14:28:53.236495165 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out 2025-12-11 14:30:...
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/generated_stored.out /home/postgres/postgres/build/testrun/re...
--- /home/postgres/postgres/src/test/regress/expected/generated_stored.out 2025-12-11 14:28:53.235881623 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/generated_stored.out 2025-12-11 14:30...
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff -U3 /home/postgres/postgres/src/test/regress/expected/generated_virtual.out /home/postgres/postgres/build/testrun/r...
--- /home/postgres/postgres/src/test/regress/expected/generated_virtual.out 2025-12-11 14:28:53.236495165 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out 2025-12-11 14:3...
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/generated_stored.out /home/postgres/postgres/build/testrun/re...
--- /home/postgres/postgres/src/test/regress/expected/generated_stored.out 2025-12-11 14:28:53.235881623 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/generated_stored.out 2025-12-11 14:30:16.810871126 +00...
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff -U3 /home/postgres/postgres/src/test/regress/expected/generated_virtual.out /home/postgres/postgres/build/testrun/r...
--- /home/postgres/postgres/src/test/regress/expected/generated_virtual.out 2025-12-11 14:28:53.236495165 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/generated_virtual.out 2025-12-11 14:30:28.855414476 +0...
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
|
Linux - Debian Trixie - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_stored.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_stored.out 2025-12-11 14:28:35.900645722 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/generated_stored.out 2025-12-11 14:33:59.428044186 +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-12-11 14:28:35.900645722 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/generated_virtual.out 2025-12-11 14:34:34.524041177 +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-12-11 14:28:35.900645722 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/generated_stored.out 2025-12-11 14:36:10.712033396 +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-12-11 14:28:35.900645722 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/generated_virtual.out 2025-12-11 14:36:26.756032741 +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-12-11 14:28:35.900645722 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/generated_stored.out 2025-12-11 14:30:58.088062062 +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-12-11 14:28:35.900645722 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/generated_virtual.out 2025-12-11 14:31:31.400058907 +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-12-11 14:28:25.890723000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_stored.out 2025-12-11 14:30:22.0...
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out /tmp/cirrus-ci-build/build/testrun/pg_upgr...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out 2025-12-11 14:28:25.890789000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out 2025-12-11 14:30: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 /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-12-11 14:28:25.890723000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/generated_stored.out 2025-12-11 14:31:34...
@@ -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-12-11 14:28:25.890789000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out 2025-12-11 14:32:0...
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
| 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-12-11 14:28:25.890723000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/generated_stored.out 2025-12-11 14:30:21.368825000 +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-12-11 14:28:25.890789000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/generated_virtual.out 2025-12-11 14:30:46.083653000 +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 Thu Dec 11 14:28:44 2025
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_stored.out Thu Dec 11 14:30: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 Thu Dec 11 14:28:44 2025
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out Thu Dec 11 14:31:...
@@ -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 Thu Dec 11 14:28:44 2025
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/generated_stored.out Thu Dec 11 14:32...
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff -U3 /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 Thu Dec 11 14:28:44 2025
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out Thu Dec 11 14:3...
@@ -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 Thu Dec 11 14:28:44 2025
+++ /home/postgres/postgres/build/testrun/regress/regress/results/generated_stored.out Thu Dec 11 14:30:46 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 Thu Dec 11 14:28:44 2025
+++ /home/postgres/postgres/build/testrun/regress/regress/results/generated_virtual.out Thu Dec 11 14:30:57 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
... |
| 57/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/recovery/027_strea...
--- C:/cirrus/src/test/regress/expected/triggers.out 2025-12-11 11:25:41.322519200 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/triggers.out 2025-12-11 11:32:19.901048800 +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 " " 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-12-11 11:25:35.703424015 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/triggers.out 2025-12-11 11:31:00.7210771...
@@ -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...
+ "{VAR :varno 2 :varattno -6 :vartype 26 :vartypmod -1 :varcollid" AFTER UPDATE ON main_table1 FOR EACH STATEMENT EX...
\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 Thu Dec 11 11:25:52 2025
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/triggers.out Thu Dec 11 11:32:07 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 | | |
... |
| 57/6251 |
Use ROLERECURSE_PRIVS in is_admin_of_role() |
|
Windows - Server 2022, MinGW64 - Meson |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/create_role.out C:/cirrus/build/testrun/pg_upgrade/002_...
--- C:/cirrus/src/test/regress/expected/create_role.out 2025-12-11 04:51:44.367747500 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/create_role.out 2025-12-11 04:56:16.276040500 +0000
@@ -219,6 +219,8 @@
DROP ROLE regress_nosuch_admin_recursive;
ERROR: role "regress_nosuch_admin_recursive" does not exist
DROP ROLE regress_plainrole;
+ERROR: permission denied to drop role
+DETAIL: Only roles with the CREATEROLE attribute and the ADMIN option on role "regress_plainrole" may drop this role.
-- must revoke privileges before dropping role
REVOKE CREATE ON DATABASE regression FROM regress_createrole CASCADE;
-- ok, should be able to drop non-superuser roles we created |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/create_role.out C:/cirrus/build/testrun/recovery/027_st...
--- C:/cirrus/src/test/regress/expected/create_role.out 2025-12-11 04:51:44.367747500 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/create_role.out 2025-12-11 04:59:08.555818500 +0000
@@ -219,6 +219,8 @@
DROP ROLE regress_nosuch_admin_recursive;
ERROR: role "regress_nosuch_admin_recursive" does not exist
DROP ROLE regress_plainrole;
+ERROR: permission denied to drop role
+DETAIL: Only roles with the CREATEROLE attribute and the ADMIN option on role "regress_plainrole" may drop this role.
-- must revoke privileges before dropping role
REVOKE CREATE ON DATABASE regression FROM regress_createrole CASCADE;
-- ok, should be able to drop non-superuser roles we created |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/create_role.out C:/cirrus/build/testrun/regress/regress...
--- C:/cirrus/src/test/regress/expected/create_role.out 2025-12-11 04:51:44.367747500 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/create_role.out 2025-12-11 04:56:11.015786100 +0000
@@ -219,6 +219,8 @@
DROP ROLE regress_nosuch_admin_recursive;
ERROR: role "regress_nosuch_admin_recursive" does not exist
DROP ROLE regress_plainrole;
+ERROR: permission denied to drop role
+DETAIL: Only roles with the CREATEROLE attribute and the ADMIN option on role "regress_plainrole" may drop this role.
-- must revoke privileges before dropping role
REVOKE CREATE ON DATABASE regression FROM regress_createrole CASCADE;
-- ok, should be able to drop non-superuser roles we created |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/create_role.out C:/cirrus/build/testrun/pg_upgrade/002_...
--- C:/cirrus/src/test/regress/expected/create_role.out 2025-12-11 04:51:43.638483500 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/create_role.out 2025-12-11 04:55:19.157338900 +0000
@@ -219,6 +219,8 @@
DROP ROLE regress_nosuch_admin_recursive;
ERROR: role "regress_nosuch_admin_recursive" does not exist
DROP ROLE regress_plainrole;
+ERROR: permission denied to drop role
+DETAIL: Only roles with the CREATEROLE attribute and the ADMIN option on role "regress_plainrole" may drop this role.
-- must revoke privileges before dropping role
REVOKE CREATE ON DATABASE regression FROM regress_createrole CASCADE;
-- ok, should be able to drop non-superuser roles we created |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/create_role.out C:/cirrus/build/testrun/recovery/027_st...
--- C:/cirrus/src/test/regress/expected/create_role.out 2025-12-11 04:51:43.638483500 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/create_role.out 2025-12-11 04:58:08.605577800 +0000
@@ -219,6 +219,8 @@
DROP ROLE regress_nosuch_admin_recursive;
ERROR: role "regress_nosuch_admin_recursive" does not exist
DROP ROLE regress_plainrole;
+ERROR: permission denied to drop role
+DETAIL: Only roles with the CREATEROLE attribute and the ADMIN option on role "regress_plainrole" may drop this role.
-- must revoke privileges before dropping role
REVOKE CREATE ON DATABASE regression FROM regress_createrole CASCADE;
-- ok, should be able to drop non-superuser roles we created |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/create_role.out C:/cirrus/build/testrun/regress/regress...
--- C:/cirrus/src/test/regress/expected/create_role.out 2025-12-11 04:51:43.638483500 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/create_role.out 2025-12-11 04:55:13.433706600 +0000
@@ -219,6 +219,8 @@
DROP ROLE regress_nosuch_admin_recursive;
ERROR: role "regress_nosuch_admin_recursive" does not exist
DROP ROLE regress_plainrole;
+ERROR: permission denied to drop role
+DETAIL: Only roles with the CREATEROLE attribute and the ADMIN option on role "regress_plainrole" may drop this role.
-- must revoke privileges before dropping role
REVOKE CREATE ON DATABASE regression FROM regress_createrole CASCADE;
-- ok, should be able to drop non-superuser roles we created |
|
macOS - Sequoia - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/create_role.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg...
--- /Users/admin/pgsql/src/test/regress/expected/create_role.out 2025-12-11 04:51:38
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/create_role.out 2025-12-11 04:53:35
@@ -219,6 +219,8 @@
DROP ROLE regress_nosuch_admin_recursive;
ERROR: role "regress_nosuch_admin_recursive" does not exist
DROP ROLE regress_plainrole;
+ERROR: permission denied to drop role
+DETAIL: Only roles with the CREATEROLE attribute and the ADMIN option on role "regress_plainrole" may drop this role.
-- must revoke privileges before dropping role
REVOKE CREATE ON DATABASE regression FROM regress_createrole CASCADE;
-- ok, should be able to drop non-superuser roles we created |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/create_role.out /Users/admin/pgsql/build/testrun/recovery/027_stre...
--- /Users/admin/pgsql/src/test/regress/expected/create_role.out 2025-12-11 04:51:38
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/create_role.out 2025-12-11 04:54:30
@@ -219,6 +219,8 @@
DROP ROLE regress_nosuch_admin_recursive;
ERROR: role "regress_nosuch_admin_recursive" does not exist
DROP ROLE regress_plainrole;
+ERROR: permission denied to drop role
+DETAIL: Only roles with the CREATEROLE attribute and the ADMIN option on role "regress_plainrole" may drop this role.
-- must revoke privileges before dropping role
REVOKE CREATE ON DATABASE regression FROM regress_createrole CASCADE;
-- ok, should be able to drop non-superuser roles we created |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/create_role.out /Users/admin/pgsql/build/testrun/regress/regress/r...
--- /Users/admin/pgsql/src/test/regress/expected/create_role.out 2025-12-11 04:51:38
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/create_role.out 2025-12-11 04:53:36
@@ -219,6 +219,8 @@
DROP ROLE regress_nosuch_admin_recursive;
ERROR: role "regress_nosuch_admin_recursive" does not exist
DROP ROLE regress_plainrole;
+ERROR: permission denied to drop role
+DETAIL: Only roles with the CREATEROLE attribute and the ADMIN option on role "regress_plainrole" may drop this role.
-- must revoke privileges before dropping role
REVOKE CREATE ON DATABASE regression FROM regress_createrole CASCADE;
-- ok, should be able to drop non-superuser roles we created |
|
Linux - Debian Trixie - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/create_role.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_chec...
--- /tmp/cirrus-ci-build/src/test/regress/expected/create_role.out 2025-12-11 04:51:42.052374295 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/create_role.out 2025-12-11 04:57:19.983635875 +0000
@@ -219,6 +219,8 @@
DROP ROLE regress_nosuch_admin_recursive;
ERROR: role "regress_nosuch_admin_recursive" does not exist
DROP ROLE regress_plainrole;
+ERROR: permission denied to drop role
+DETAIL: Only roles with the CREATEROLE attribute and the ADMIN option on role "regress_plainrole" may drop this role.
-- must revoke privileges before dropping role
REVOKE CREATE ON DATABASE regression FROM regress_createrole CASCADE;
-- ok, should be able to drop non-superuser roles we created |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/create_role.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check...
--- /tmp/cirrus-ci-build/src/test/regress/expected/create_role.out 2025-12-11 04:51:42.052374295 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/create_role.out 2025-12-11 04:59:14.271548412 +0000
@@ -219,6 +219,8 @@
DROP ROLE regress_nosuch_admin_recursive;
ERROR: role "regress_nosuch_admin_recursive" does not exist
DROP ROLE regress_plainrole;
+ERROR: permission denied to drop role
+DETAIL: Only roles with the CREATEROLE attribute and the ADMIN option on role "regress_plainrole" may drop this role.
-- must revoke privileges before dropping role
REVOKE CREATE ON DATABASE regression FROM regress_createrole CASCADE;
-- ok, should be able to drop non-superuser roles we created |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/create_role.out /tmp/cirrus-ci-build/src/test/regress/results/cr...
--- /tmp/cirrus-ci-build/src/test/regress/expected/create_role.out 2025-12-11 04:51:42.052374295 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/create_role.out 2025-12-11 04:54:34.331857177 +0000
@@ -219,6 +219,8 @@
DROP ROLE regress_nosuch_admin_recursive;
ERROR: role "regress_nosuch_admin_recursive" does not exist
DROP ROLE regress_plainrole;
+ERROR: permission denied to drop role
+DETAIL: Only roles with the CREATEROLE attribute and the ADMIN option on role "regress_plainrole" may drop this role.
-- must revoke privileges before dropping role
REVOKE CREATE ON DATABASE regression FROM regress_createrole CASCADE;
-- ok, should be able to drop non-superuser roles we created |
|
Linux - Debian Trixie - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/create_role.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/00...
--- /tmp/cirrus-ci-build/src/test/regress/expected/create_role.out 2025-12-11 04:51:47.936712077 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/create_role.out 2025-12-11 04:53:53.944355...
@@ -219,6 +219,8 @@
DROP ROLE regress_nosuch_admin_recursive;
ERROR: role "regress_nosuch_admin_recursive" does not exist
DROP ROLE regress_plainrole;
+ERROR: permission denied to drop role
+DETAIL: Only roles with the CREATEROLE attribute and the ADMIN option on role "regress_plainrole" may drop this role.
-- must revoke privileges before dropping role
REVOKE CREATE ON DATABASE regression FROM regress_createrole CASCADE;
-- ok, should be able to drop non-superuser roles we created |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/create_role.out /tmp/cirrus-ci-build/build/testrun/recovery/027_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/create_role.out 2025-12-11 04:51:47.936712077 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/create_role.out 2025-12-11 04:55:06.9962...
@@ -219,6 +219,8 @@
DROP ROLE regress_nosuch_admin_recursive;
ERROR: role "regress_nosuch_admin_recursive" does not exist
DROP ROLE regress_plainrole;
+ERROR: permission denied to drop role
+DETAIL: Only roles with the CREATEROLE attribute and the ADMIN option on role "regress_plainrole" may drop this role.
-- must revoke privileges before dropping role
REVOKE CREATE ON DATABASE regression FROM regress_createrole CASCADE;
-- ok, should be able to drop non-superuser roles we created |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/create_role.out /tmp/cirrus-ci-build/build/testrun/regress/regre...
--- /tmp/cirrus-ci-build/src/test/regress/expected/create_role.out 2025-12-11 04:51:47.936712077 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/create_role.out 2025-12-11 04:53:51.848360945 +0000
@@ -219,6 +219,8 @@
DROP ROLE regress_nosuch_admin_recursive;
ERROR: role "regress_nosuch_admin_recursive" does not exist
DROP ROLE regress_plainrole;
+ERROR: permission denied to drop role
+DETAIL: Only roles with the CREATEROLE attribute and the ADMIN option on role "regress_plainrole" may drop this role.
-- must revoke privileges before dropping role
REVOKE CREATE ON DATABASE regression FROM regress_createrole CASCADE;
-- ok, should be able to drop non-superuser roles we created |
|
OpenBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/create_role.out /home/postgres/postgres/build/testrun/pg_upgr...
--- /home/postgres/postgres/src/test/regress/expected/create_role.out Thu Dec 11 04:52:01 2025
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/create_role.out Thu Dec 11 04:54:41 202...
@@ -219,6 +219,8 @@
DROP ROLE regress_nosuch_admin_recursive;
ERROR: role "regress_nosuch_admin_recursive" does not exist
DROP ROLE regress_plainrole;
+ERROR: permission denied to drop role
+DETAIL: Only roles with the CREATEROLE attribute and the ADMIN option on role "regress_plainrole" may drop this role.
-- must revoke privileges before dropping role
REVOKE CREATE ON DATABASE regression FROM regress_createrole CASCADE;
-- ok, should be able to drop non-superuser roles we created |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/create_role.out /home/postgres/postgres/build/testrun/recover...
--- /home/postgres/postgres/src/test/regress/expected/create_role.out Thu Dec 11 04:52:01 2025
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/create_role.out Thu Dec 11 04:56:18 2...
@@ -219,6 +219,8 @@
DROP ROLE regress_nosuch_admin_recursive;
ERROR: role "regress_nosuch_admin_recursive" does not exist
DROP ROLE regress_plainrole;
+ERROR: permission denied to drop role
+DETAIL: Only roles with the CREATEROLE attribute and the ADMIN option on role "regress_plainrole" may drop this role.
-- must revoke privileges before dropping role
REVOKE CREATE ON DATABASE regression FROM regress_createrole CASCADE;
-- ok, should be able to drop non-superuser roles we created |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/create_role.out /home/postgres/postgres/build/testrun/regress...
--- /home/postgres/postgres/src/test/regress/expected/create_role.out Thu Dec 11 04:52:01 2025
+++ /home/postgres/postgres/build/testrun/regress/regress/results/create_role.out Thu Dec 11 04:54:32 2025
@@ -219,6 +219,8 @@
DROP ROLE regress_nosuch_admin_recursive;
ERROR: role "regress_nosuch_admin_recursive" does not exist
DROP ROLE regress_plainrole;
+ERROR: permission denied to drop role
+DETAIL: Only roles with the CREATEROLE attribute and the ADMIN option on role "regress_plainrole" may drop this role.
-- must revoke privileges before dropping role
REVOKE CREATE ON DATABASE regression FROM regress_createrole CASCADE;
-- ok, should be able to drop non-superuser roles we created |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/create_role.out /home/postgres/postgres/build/testrun/pg_upgr...
--- /home/postgres/postgres/src/test/regress/expected/create_role.out 2025-12-11 04:51:57.688151447 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/create_role.out 2025-12-11 04:53:47.855...
@@ -219,6 +219,8 @@
DROP ROLE regress_nosuch_admin_recursive;
ERROR: role "regress_nosuch_admin_recursive" does not exist
DROP ROLE regress_plainrole;
+ERROR: permission denied to drop role
+DETAIL: Only roles with the CREATEROLE attribute and the ADMIN option on role "regress_plainrole" may drop this role.
-- must revoke privileges before dropping role
REVOKE CREATE ON DATABASE regression FROM regress_createrole CASCADE;
-- ok, should be able to drop non-superuser roles we created |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/create_role.out /home/postgres/postgres/build/testrun/recover...
--- /home/postgres/postgres/src/test/regress/expected/create_role.out 2025-12-11 04:51:57.688151447 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/create_role.out 2025-12-11 04:54:30.3...
@@ -219,6 +219,8 @@
DROP ROLE regress_nosuch_admin_recursive;
ERROR: role "regress_nosuch_admin_recursive" does not exist
DROP ROLE regress_plainrole;
+ERROR: permission denied to drop role
+DETAIL: Only roles with the CREATEROLE attribute and the ADMIN option on role "regress_plainrole" may drop this role.
-- must revoke privileges before dropping role
REVOKE CREATE ON DATABASE regression FROM regress_createrole CASCADE;
-- ok, should be able to drop non-superuser roles we created |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/create_role.out /home/postgres/postgres/build/testrun/regress...
--- /home/postgres/postgres/src/test/regress/expected/create_role.out 2025-12-11 04:51:57.688151447 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/create_role.out 2025-12-11 04:53:46.087064661 +0000
@@ -219,6 +219,8 @@
DROP ROLE regress_nosuch_admin_recursive;
ERROR: role "regress_nosuch_admin_recursive" does not exist
DROP ROLE regress_plainrole;
+ERROR: permission denied to drop role
+DETAIL: Only roles with the CREATEROLE attribute and the ADMIN option on role "regress_plainrole" may drop this role.
-- must revoke privileges before dropping role
REVOKE CREATE ON DATABASE regression FROM regress_createrole CASCADE;
-- ok, should be able to drop non-superuser roles we created |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/create_role.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/00...
--- /tmp/cirrus-ci-build/src/test/regress/expected/create_role.out 2025-12-11 04:51:47.927735000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/create_role.out 2025-12-11 04:54:02.334672...
@@ -219,6 +219,8 @@
DROP ROLE regress_nosuch_admin_recursive;
ERROR: role "regress_nosuch_admin_recursive" does not exist
DROP ROLE regress_plainrole;
+ERROR: permission denied to drop role
+DETAIL: Only roles with the CREATEROLE attribute and the ADMIN option on role "regress_plainrole" may drop this role.
-- must revoke privileges before dropping role
REVOKE CREATE ON DATABASE regression FROM regress_createrole CASCADE;
-- ok, should be able to drop non-superuser roles we created |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/create_role.out /tmp/cirrus-ci-build/build/testrun/recovery/027_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/create_role.out 2025-12-11 04:51:47.927735000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/create_role.out 2025-12-11 04:55:21.0939...
@@ -219,6 +219,8 @@
DROP ROLE regress_nosuch_admin_recursive;
ERROR: role "regress_nosuch_admin_recursive" does not exist
DROP ROLE regress_plainrole;
+ERROR: permission denied to drop role
+DETAIL: Only roles with the CREATEROLE attribute and the ADMIN option on role "regress_plainrole" may drop this role.
-- must revoke privileges before dropping role
REVOKE CREATE ON DATABASE regression FROM regress_createrole CASCADE;
-- ok, should be able to drop non-superuser roles we created |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/create_role.out /tmp/cirrus-ci-build/build/testrun/regress/regre...
--- /tmp/cirrus-ci-build/src/test/regress/expected/create_role.out 2025-12-11 04:51:47.927735000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/create_role.out 2025-12-11 04:54:01.428549000 +0000
@@ -219,6 +219,8 @@
DROP ROLE regress_nosuch_admin_recursive;
ERROR: role "regress_nosuch_admin_recursive" does not exist
DROP ROLE regress_plainrole;
+ERROR: permission denied to drop role
+DETAIL: Only roles with the CREATEROLE attribute and the ADMIN option on role "regress_plainrole" may drop this role.
-- must revoke privileges before dropping role
REVOKE CREATE ON DATABASE regression FROM regress_createrole CASCADE;
-- ok, should be able to drop non-superuser roles we created |
| 57/5885 |
Decouple C++ support in Meson's PGXS from LLVM enablement |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/modules/injection_points/expected/reindex-concurrently-upsert-on-constraint.ou...
--- /home/postgres/postgres/src/test/modules/injection_points/expected/reindex-concurrently-upsert-on-constraint.out 202...
+++ /home/postgres/postgres/build/testrun/injection_points/isolation/results/reindex-concurrently-upsert-on-constraint.o...
@@ -29,39 +29,20 @@
<waiting ...>
step s1_start_upsert:
INSERT INTO test.tbl VALUES (13, now()) ON CONFLICT ON CONSTRAINT tbl_pkey DO UPDATE SET updated_at = now();
- <waiting ...>
+
step s4_wakeup_to_set_dead:
SELECT injection_points_detach('reindex-relation-concurrently-before-set-dead');
SELECT injection_points_wakeup('reindex-relation-concurrently-before-set-dead');
-injection_points_detach
------------------------
-
-(1 row)
-
-injection_points_wakeup
------------------------
... |
| 54/5829 |
VCI (columnar store extension) |
|
Linux - Debian Trixie - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/vci/expected/vci.out /tmp/cirrus-ci-build/build/testrun/vci/regress/results/vci.ou...
--- /tmp/cirrus-ci-build/contrib/vci/expected/vci.out 2025-12-10 02:12:11.845261905 +0000
+++ /tmp/cirrus-ci-build/build/testrun/vci/regress/results/vci.out 2025-12-10 02:18:48.976263036 +0000
@@ -88,41 +88,7 @@
INSERT INTO testtable (key, cond, c01a, c01b, c02, c03, c05, c06, c07, c08, c09, c10, c13, c15, c16, c17, c18, c19, c20...
-- Create an index which uses VCI index access method
CREATE INDEX testindex ON testtable USING vci (key, cond, c01a, c01b, c02, c03, c05, c06, c07, c08, c09, c10, c13, c15,...
--- We expect VCI plans are chosen here
-EXPLAIN (ANALYZE, TIMING OFF, COSTS OFF, SUMMARY OFF, BUFFERS OFF)
-SELECT key, count(*) AS count_star, count(c05) AS count_c05 FROM testtable WHERE NOT cond = 0 GROUP BY key ORDER BY key...
- QUERY PLAN
-------------------------------------------------------------------------------------------------
- Sort (actual rows=14.00 loops=1)
- Sort Key: key
- Sort Method: quicksort Memory: 25kB
- -> Custom Scan (VCI HashAggregate) (actual rows=14.00 loops=1)
- Group Key: key
- -> Custom Scan (VCI Scan) using testindex on testtable (actual rows=10221.00 loops=1)
- Filter: (cond <> 0)
- Rows Removed by Filter: 476
... |
| 57/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-12-10 01:10:02.719648000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/stats.out 2025-12-10 01:14:40.861415000 +0...
@@ -243,7 +243,7 @@
SELECT :seq_scan_after > :seq_scan_before;
?column?
----------
- t
+ f
(1 row)
---- |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/stats.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stream...
--- /tmp/cirrus-ci-build/src/test/regress/expected/stats.out 2025-12-10 01:10:02.719648000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/stats.out 2025-12-10 01:16:04.434921000 ...
@@ -243,7 +243,7 @@
SELECT :seq_scan_after > :seq_scan_before;
?column?
----------
- t
+ f
(1 row)
---- |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/stats.out /tmp/cirrus-ci-build/build/testrun/regress/regress/res...
--- /tmp/cirrus-ci-build/src/test/regress/expected/stats.out 2025-12-10 01:10:02.719648000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/stats.out 2025-12-10 01:14:38.929619000 +0000
@@ -243,7 +243,7 @@
SELECT :seq_scan_after > :seq_scan_before;
?column?
----------
- t
+ f
(1 row)
---- |
| 56/5044 |
new plpgsql.extra_errors check - strict_expr_check |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/isolation/expected/timeouts.out /home/postgres/postgres/build/testrun/isolatio...
--- /home/postgres/postgres/src/test/isolation/expected/timeouts.out 2025-12-06 23:27:00.410012527 +0000
+++ /home/postgres/postgres/build/testrun/isolation/isolation/results/timeouts.out 2025-12-06 23:30:15.126807619 +0000
@@ -57,7 +57,7 @@
step sto: SET statement_timeout = '10ms';
step update: DELETE FROM accounts WHERE accountid = 'checking'; <waiting ...>
step update: <... completed>
-ERROR: canceling statement due to statement timeout
+ERROR: canceling statement due to user request
starting permutation: wrtbl lto update
step wrtbl: UPDATE accounts SET balance = balance + 100; |