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/6212 |
pg_get_domain_ddl: DDL reconstruction function for CREATE DOMAIN statement |
 |
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/object_ddl.out /tmp/cirrus-ci-build/build/testrun/recovery/027_s...
--- /tmp/cirrus-ci-build/src/test/regress/expected/object_ddl.out 2025-11-11 13:39:58.464803000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/object_ddl.out 2025-11-11 13:42:42.16527...
@@ -222,7 +222,7 @@
SELECT pg_get_domain_ddl('regress_comprehensive_domain');
...
-----------------------------------------------------------------------------------------------------------------------...
- CREATE DOMAIN public.regress_comprehensive_domain AS pg_catalog."varchar" DEFAULT 'default_value'::character varying C...
+ CREATE DOMAIN public.regress_comprehensive_domain AS pg_catalog."varchar" DEFAULT 'default_value'::character varying C...
(1 row)
SELECT pg_get_domain_ddl('regress_comprehensive_domain', pretty => true);
@@ -232,10 +232,10 @@
DEFAULT 'default_value'::character varying +
CONSTRAINT regress_comprehensive_domain_not_null +
NOT NULL +
- CONSTRAINT regress_comprehensive_domain_check +
- CHECK (length(VALUE::text) >= 5) +
CONSTRAINT regress_comprehensive_domain_check1 +
- CHECK (VALUE::text !~ '^\s*$'::text);
... |
| 56/5715 |
amcheck support for BRIN indexes |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out /tmp/cirrus-ci-build/build/testrun/postgres...
--- /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out 2025-11-11 07:46:11.638313000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/postgres_fdw-running/regress/results/postgres_fdw.out 2025-11-11 07:54:11.7858360...
@@ -12696,8 +12696,7 @@
FROM postgres_fdw_get_connections(true);
server_name | closed | remote_backend_pid
-------------+--------+--------------------
- loopback | f | t
-(1 row)
+(0 rows)
-- After terminating the remote backend, since the connection is closed,
-- "closed" should be TRUE, or NULL if the connection status check
@@ -12713,8 +12712,7 @@
FROM postgres_fdw_get_connections(true);
server_name | closed | remote_backend_pid
-------------+--------+--------------------
- loopback | t | t
-(1 row)
+(0 rows)
... |
| 56/5615 |
Corrupted FSM page is not saved after zeroing. |
|
Windows - Server 2022, MinGW64 - Meson |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/partition_aggregate.out C:/cirrus/build/testrun/regress...
--- C:/cirrus/src/test/regress/expected/partition_aggregate.out 2025-11-11 00:12:16.225306700 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/partition_aggregate.out 2025-11-11 00:19:13.558321300 +0000
@@ -1303,15 +1303,8 @@
(24 rows)
SELECT b, sum(a), count(*) FROM pagg_tab_ml GROUP BY b HAVING avg(a) < 15 ORDER BY 1, 2, 3;
- b | sum | count
----+-------+-------
- 0 | 30000 | 3000
- 1 | 33000 | 3000
- 2 | 36000 | 3000
- 3 | 39000 | 3000
- 4 | 42000 | 3000
-(5 rows)
-
+ERROR: parallel worker failed to initialize
+HINT: More details may be available in the server log.
-- Full aggregation at all levels as GROUP BY clause matches with PARTITION KEY
EXPLAIN (COSTS OFF)
... |
| 54/5829 |
VCI (columnar store extension) |
|
Windows - Server 2022, MinGW64 - Meson |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/vci/expected/vci.out C:/cirrus/build/testrun/vci/regress/results/vci.out
--- C:/cirrus/contrib/vci/expected/vci.out 2025-11-10 23:02:57.339782900 +0000
+++ C:/cirrus/build/testrun/vci/regress/results/vci.out 2025-11-10 23:15:50.456348900 +0000
@@ -91,38 +91,7 @@
-- 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
-(8 rows)
-
--- Confirms the aggregation can work. The first column indicates whether the
... |
|
macOS - Sequoia - Meson |
| regress |
diff -U3 /Users/admin/pgsql/contrib/vci/expected/vci.out /Users/admin/pgsql/build/testrun/vci/regress/results/vci.out
--- /Users/admin/pgsql/contrib/vci/expected/vci.out 2025-11-10 23:02:56
+++ /Users/admin/pgsql/build/testrun/vci/regress/results/vci.out 2025-11-10 23:09:30
@@ -91,38 +91,7 @@
-- 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
-(8 rows)
-
--- Confirms the aggregation can work. The first column indicates whether the
... |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/vci/expected/vci.out C:/cirrus/build/testrun/vci/regress/results/vci.out
--- C:/cirrus/contrib/vci/expected/vci.out 2025-11-10 23:04:05.842563800 +0000
+++ C:/cirrus/build/testrun/vci/regress/results/vci.out 2025-11-10 23:12:14.596014000 +0000
@@ -91,38 +91,7 @@
-- 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
-(8 rows)
-
--- Confirms the aggregation can work. The first column indicates whether the
... |
|
Linux - Debian Trixie - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/vci/expected/vci.out /tmp/cirrus-ci-build/build/testrun/vci/regress/results/vci.ou...
--- /tmp/cirrus-ci-build/contrib/vci/expected/vci.out 2025-11-10 23:02:56.729423095 +0000
+++ /tmp/cirrus-ci-build/build/testrun/vci/regress/results/vci.out 2025-11-10 23:10:12.450434867 +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
... |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/contrib/vci/expected/vci.out /home/postgres/postgres/build/testrun/vci/regress/results/...
--- /home/postgres/postgres/contrib/vci/expected/vci.out 2025-11-10 23:03:05.532553949 +0000
+++ /home/postgres/postgres/build/testrun/vci/regress/results/vci.out 2025-11-10 23:06:56.881055014 +0000
@@ -91,38 +91,7 @@
-- 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
-(8 rows)
-
--- Confirms the aggregation can work. The first column indicates whether the
... |
|
OpenBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/contrib/vci/expected/vci.out /home/postgres/postgres/build/testrun/vci/regress/results/...
--- /home/postgres/postgres/contrib/vci/expected/vci.out Mon Nov 10 23:03:51 2025
+++ /home/postgres/postgres/build/testrun/vci/regress/results/vci.out Mon Nov 10 23:10:49 2025
@@ -91,38 +91,7 @@
-- 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
-(8 rows)
-
--- Confirms the aggregation can work. The first column indicates whether the
... |
|
Linux - Debian Trixie - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/vci/expected/vci.out /tmp/cirrus-ci-build/contrib/vci/results/vci.out
--- /tmp/cirrus-ci-build/contrib/vci/expected/vci.out 2025-11-10 23:02:56.736331413 +0000
+++ /tmp/cirrus-ci-build/contrib/vci/results/vci.out 2025-11-10 23:12:18.570671738 +0000
@@ -91,38 +91,7 @@
-- 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
-(8 rows)
-
--- Confirms the aggregation can work. The first column indicates whether the
... |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/vci/expected/vci.out /tmp/cirrus-ci-build/build/testrun/vci/regress/results/vci.ou...
--- /tmp/cirrus-ci-build/contrib/vci/expected/vci.out 2025-11-10 23:03:07.755108000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/vci/regress/results/vci.out 2025-11-10 23:08:11.916747000 +0000
@@ -91,38 +91,7 @@
-- 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
-(8 rows)
-
--- Confirms the aggregation can work. The first column indicates whether the
... |
| 56/5992 |
Fix ALTER TABLE DROP EXPRESSION with ONLY option |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/generated_stored.out C:/cirrus/build/testrun/pg_upgrade...
--- C:/cirrus/src/test/regress/expected/generated_stored.out 2025-11-10 22:24:10.484841100 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_stored.out 2025-11-10 22:27:40.210089700 +0...
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/generated_virtual.out C:/cirrus/build/testrun/pg_upgrad...
--- C:/cirrus/src/test/regress/expected/generated_virtual.out 2025-11-10 22:24:10.484841100 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out 2025-11-10 22:27:59.784845800 +...
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/generated_stored.out C:/cirrus/build/testrun/recovery/0...
--- C:/cirrus/src/test/regress/expected/generated_stored.out 2025-11-10 22:24:10.484841100 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/generated_stored.out 2025-11-10 22:30:33.273326500 ...
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/generated_virtual.out C:/cirrus/build/testrun/recovery/...
--- C:/cirrus/src/test/regress/expected/generated_virtual.out 2025-11-10 22:24:10.484841100 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out 2025-11-10 22:30:49.448184000...
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/generated_stored.out C:/cirrus/build/testrun/regress/re...
--- C:/cirrus/src/test/regress/expected/generated_stored.out 2025-11-10 22:24:10.484841100 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/generated_stored.out 2025-11-10 22:27:33.108510700 +0000
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/generated_virtual.out C:/cirrus/build/testrun/regress/r...
--- C:/cirrus/src/test/regress/expected/generated_virtual.out 2025-11-10 22:24:10.484841100 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/generated_virtual.out 2025-11-10 22:27:52.458649400 +0000
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
|
Windows - Server 2022, MinGW64 - Meson |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/generated_stored.out C:/cirrus/build/testrun/pg_upgrade...
--- C:/cirrus/src/test/regress/expected/generated_stored.out 2025-11-10 22:24:19.646187600 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_stored.out 2025-11-10 22:27:00.506825400 +0...
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/generated_virtual.out C:/cirrus/build/testrun/pg_upgrad...
--- C:/cirrus/src/test/regress/expected/generated_virtual.out 2025-11-10 22:24:19.647579100 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out 2025-11-10 22:27:09.022926500 +...
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/generated_stored.out C:/cirrus/build/testrun/recovery/0...
--- C:/cirrus/src/test/regress/expected/generated_stored.out 2025-11-10 22:24:19.646187600 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/generated_stored.out 2025-11-10 22:29:52.283201900 ...
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/generated_virtual.out C:/cirrus/build/testrun/recovery/...
--- C:/cirrus/src/test/regress/expected/generated_virtual.out 2025-11-10 22:24:19.647579100 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out 2025-11-10 22:30:01.238285700...
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/generated_stored.out C:/cirrus/build/testrun/regress/re...
--- C:/cirrus/src/test/regress/expected/generated_stored.out 2025-11-10 22:24:19.646187600 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/generated_stored.out 2025-11-10 22:26:53.112265200 +0000
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/generated_virtual.out C:/cirrus/build/testrun/regress/r...
--- C:/cirrus/src/test/regress/expected/generated_virtual.out 2025-11-10 22:24:19.647579100 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/generated_virtual.out 2025-11-10 22:27:04.565900500 +0000
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
|
macOS - Sequoia - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/generated_stored.out /Users/admin/pgsql/build/testrun/pg_upgrade/0...
--- /Users/admin/pgsql/src/test/regress/expected/generated_stored.out 2025-11-10 22:23:06
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_stored.out 2025-11-10 22:25:29
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff -U3 /Users/admin/pgsql/src/test/regress/expected/generated_virtual.out /Users/admin/pgsql/build/testrun/pg_upgrade/...
--- /Users/admin/pgsql/src/test/regress/expected/generated_virtual.out 2025-11-10 22:23:06
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out 2025-11-10 22:25:32
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/generated_stored.out /Users/admin/pgsql/build/testrun/recovery/027...
--- /Users/admin/pgsql/src/test/regress/expected/generated_stored.out 2025-11-10 22:23:06
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/generated_stored.out 2025-11-10 22:26:19
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff -U3 /Users/admin/pgsql/src/test/regress/expected/generated_virtual.out /Users/admin/pgsql/build/testrun/recovery/02...
--- /Users/admin/pgsql/src/test/regress/expected/generated_virtual.out 2025-11-10 22:23:06
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out 2025-11-10 22:26: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 /Users/admin/pgsql/src/test/regress/expected/generated_stored.out /Users/admin/pgsql/build/testrun/regress/regr...
--- /Users/admin/pgsql/src/test/regress/expected/generated_stored.out 2025-11-10 22:23:06
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/generated_stored.out 2025-11-10 22:25:29
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff -U3 /Users/admin/pgsql/src/test/regress/expected/generated_virtual.out /Users/admin/pgsql/build/testrun/regress/reg...
--- /Users/admin/pgsql/src/test/regress/expected/generated_virtual.out 2025-11-10 22:23:06
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/generated_virtual.out 2025-11-10 22:25:33
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
|
Linux - Debian Trixie - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_stored.out /tmp/cirrus-ci-build/build/testrun/pg_upgra...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_stored.out 2025-11-10 22:24:17.946712317 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_stored.out 2025-11-10 22:26:10.7...
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out /tmp/cirrus-ci-build/build/testrun/pg_upgr...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out 2025-11-10 22:24:17.946712317 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out 2025-11-10 22:26: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 /tmp/cirrus-ci-build/src/test/regress/expected/generated_stored.out /tmp/cirrus-ci-build/build/testrun/recovery...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_stored.out 2025-11-10 22:24:17.946712317 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/generated_stored.out 2025-11-10 22:27:29...
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out /tmp/cirrus-ci-build/build/testrun/recover...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out 2025-11-10 22:24:17.946712317 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out 2025-11-10 22:27:4...
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_stored.out /tmp/cirrus-ci-build/build/testrun/regress/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_stored.out 2025-11-10 22:24:17.946712317 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/generated_stored.out 2025-11-10 22:26:06.663351711 +0000
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out /tmp/cirrus-ci-build/build/testrun/regress...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out 2025-11-10 22:24:17.946712317 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/generated_virtual.out 2025-11-10 22:26:18.775393658 +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 Mon Nov 10 22:23:59 2025
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_stored.out Mon Nov 10 22:26: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 Mon Nov 10 22:23:59 2025
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out Mon Nov 10 22:26:...
@@ -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 Mon Nov 10 22:23:59 2025
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/generated_stored.out Mon Nov 10 22:28...
@@ -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 Mon Nov 10 22:23:59 2025
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out Mon Nov 10 22:2...
@@ -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 Mon Nov 10 22:23:59 2025
+++ /home/postgres/postgres/build/testrun/regress/regress/results/generated_stored.out Mon Nov 10 22:26:02 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 Mon Nov 10 22:23:59 2025
+++ /home/postgres/postgres/build/testrun/regress/regress/results/generated_virtual.out Mon Nov 10 22:26:12 2025
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
|
Linux - Debian Trixie - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_stored.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_stored.out 2025-11-10 22:23:25.756315442 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/generated_stored.out 2025-11-10 22:28:33.224051362 +0000
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tm...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out 2025-11-10 22:23:25.756315442 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/generated_virtual.out 2025-11-10 22:29:07.472050307 +0000
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_stored.out /tmp/cirrus-ci-build/src/test/recovery/tmp_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_stored.out 2025-11-10 22:23:25.756315442 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/generated_stored.out 2025-11-10 22:30:23.088062405 +0000
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out /tmp/cirrus-ci-build/src/test/recovery/tmp...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out 2025-11-10 22:23:25.756315442 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/generated_virtual.out 2025-11-10 22:30:38.588066142 +0000
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_stored.out /tmp/cirrus-ci-build/src/test/regress/resul...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_stored.out 2025-11-10 22:23:25.756315442 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/generated_stored.out 2025-11-10 22:25:38.076059518 +0000
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out /tmp/cirrus-ci-build/src/test/regress/resu...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out 2025-11-10 22:23:25.756315442 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/generated_virtual.out 2025-11-10 22:26:08.600094639 +0000
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_stored.out /tmp/cirrus-ci-build/build/testrun/pg_upgra...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_stored.out 2025-11-10 22:24:11.223903000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_stored.out 2025-11-10 22:26:09.8...
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out /tmp/cirrus-ci-build/build/testrun/pg_upgr...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out 2025-11-10 22:24:11.223953000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out 2025-11-10 22:26:29....
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_stored.out /tmp/cirrus-ci-build/build/testrun/recovery...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_stored.out 2025-11-10 22:24:11.223903000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/generated_stored.out 2025-11-10 22:27:19...
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out /tmp/cirrus-ci-build/build/testrun/recover...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out 2025-11-10 22:24:11.223953000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out 2025-11-10 22:27:5...
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_stored.out /tmp/cirrus-ci-build/build/testrun/regress/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_stored.out 2025-11-10 22:24:11.223903000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/generated_stored.out 2025-11-10 22:26:14.849286000 +0000
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out /tmp/cirrus-ci-build/build/testrun/regress...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out 2025-11-10 22:24:11.223953000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/generated_virtual.out 2025-11-10 22:26:39.666673000 +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
... |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/generated_stored.out /home/postgres/postgres/build/testrun/pg...
--- /home/postgres/postgres/src/test/regress/expected/generated_stored.out 2025-11-10 22:24:01.559014391 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_stored.out 2025-11-10 22:25:3...
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff -U3 /home/postgres/postgres/src/test/regress/expected/generated_virtual.out /home/postgres/postgres/build/testrun/p...
--- /home/postgres/postgres/src/test/regress/expected/generated_virtual.out 2025-11-10 22:24:01.559807491 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out 2025-11-10 22:25:...
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/generated_stored.out /home/postgres/postgres/build/testrun/re...
--- /home/postgres/postgres/src/test/regress/expected/generated_stored.out 2025-11-10 22:24:01.559014391 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/generated_stored.out 2025-11-10 22:26...
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff -U3 /home/postgres/postgres/src/test/regress/expected/generated_virtual.out /home/postgres/postgres/build/testrun/r...
--- /home/postgres/postgres/src/test/regress/expected/generated_virtual.out 2025-11-10 22:24:01.559807491 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out 2025-11-10 22:2...
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/generated_stored.out /home/postgres/postgres/build/testrun/re...
--- /home/postgres/postgres/src/test/regress/expected/generated_stored.out 2025-11-10 22:24:01.559014391 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/generated_stored.out 2025-11-10 22:25:20.610875118 +00...
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff -U3 /home/postgres/postgres/src/test/regress/expected/generated_virtual.out /home/postgres/postgres/build/testrun/r...
--- /home/postgres/postgres/src/test/regress/expected/generated_virtual.out 2025-11-10 22:24:01.559807491 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/generated_virtual.out 2025-11-10 22:25:36.613694727 +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
... |
| 56/6184 |
pg_plan_advice |
|
Windows - Server 2022, MinGW64 - Meson |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/test_setup.out C:/cirrus/build/testrun/pg_plan_advice/0...
--- C:/cirrus/src/test/regress/expected/test_setup.out 2025-11-10 11:28:26.541445700 +0000
+++ C:/cirrus/build/testrun/pg_plan_advice/001_regress/data/results/test_setup.out 2025-11-10 11:43:16.995594100 +0000
@@ -205,6 +205,7 @@
RETURNS bool
AS :'regresslib', 'binary_coercible'
LANGUAGE C STRICT STABLE PARALLEL SAFE;
+ERROR: could not access file "/usr/local/pgsql/lib/regress.dll": No such file or directory
-- Use hand-rolled hash functions and operator classes to get predictable
-- result on different machines. The hash function for int4 simply returns
-- the sum of the values passed to it and the one for text returns the length
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/type_sanity.out C:/cirrus/build/testrun/pg_plan_advice/...
--- C:/cirrus/src/test/regress/expected/type_sanity.out 2025-11-10 11:28:26.557294000 +0000
+++ C:/cirrus/build/testrun/pg_plan_advice/001_regress/data/results/type_sanity.out 2025-11-10 11:43:20.826551000 +0000
@@ -595,6 +595,7 @@
CREATE FUNCTION is_catalog_text_unique_index_oid(oid) RETURNS bool
AS :'regresslib', 'is_catalog_text_unique_index_oid'
LANGUAGE C STRICT;
+ERROR: could not access file "/usr/local/pgsql/lib/regress.dll": No such file or directory
SELECT indexrelid::regclass
... |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/test_setup.out C:/cirrus/build/testrun/pg_plan_advice/0...
--- C:/cirrus/src/test/regress/expected/test_setup.out 2025-11-10 11:28:24.023206900 +0000
+++ C:/cirrus/build/testrun/pg_plan_advice/001_regress/data/results/test_setup.out 2025-11-10 11:39:49.592084200 +0000
@@ -205,6 +205,7 @@
RETURNS bool
AS :'regresslib', 'binary_coercible'
LANGUAGE C STRICT STABLE PARALLEL SAFE;
+ERROR: could not access file "/usr/local/pgsql/lib/regress.dll": No such file or directory
-- Use hand-rolled hash functions and operator classes to get predictable
-- result on different machines. The hash function for int4 simply returns
-- the sum of the values passed to it and the one for text returns the length
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/type_sanity.out C:/cirrus/build/testrun/pg_plan_advice/...
--- C:/cirrus/src/test/regress/expected/type_sanity.out 2025-11-10 11:28:24.033543200 +0000
+++ C:/cirrus/build/testrun/pg_plan_advice/001_regress/data/results/type_sanity.out 2025-11-10 11:39:57.304007200 +0000
@@ -595,6 +595,7 @@
CREATE FUNCTION is_catalog_text_unique_index_oid(oid) RETURNS bool
AS :'regresslib', 'is_catalog_text_unique_index_oid'
LANGUAGE C STRICT;
+ERROR: could not access file "/usr/local/pgsql/lib/regress.dll": No such file or directory
SELECT indexrelid::regclass
... |
|
macOS - Sequoia - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/test_setup.out /Users/admin/pgsql/build/testrun/pg_plan_advice/001...
--- /Users/admin/pgsql/src/test/regress/expected/test_setup.out 2025-11-10 11:28:02
+++ /Users/admin/pgsql/build/testrun/pg_plan_advice/001_regress/data/results/test_setup.out 2025-11-10 11:36:47
@@ -205,6 +205,7 @@
RETURNS bool
AS :'regresslib', 'binary_coercible'
LANGUAGE C STRICT STABLE PARALLEL SAFE;
+ERROR: could not access file "/usr/local/pgsql/lib/regress.dylib": No such file or directory
-- Use hand-rolled hash functions and operator classes to get predictable
-- result on different machines. The hash function for int4 simply returns
-- the sum of the values passed to it and the one for text returns the length
diff -U3 /Users/admin/pgsql/src/test/regress/expected/type_sanity.out /Users/admin/pgsql/build/testrun/pg_plan_advice/00...
--- /Users/admin/pgsql/src/test/regress/expected/type_sanity.out 2025-11-10 11:28:02
+++ /Users/admin/pgsql/build/testrun/pg_plan_advice/001_regress/data/results/type_sanity.out 2025-11-10 11:36:51
@@ -595,6 +595,7 @@
CREATE FUNCTION is_catalog_text_unique_index_oid(oid) RETURNS bool
AS :'regresslib', 'is_catalog_text_unique_index_oid'
LANGUAGE C STRICT;
+ERROR: could not access file "/usr/local/pgsql/lib/regress.dylib": No such file or directory
SELECT indexrelid::regclass
... |
|
Linux - Debian Trixie - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/test_setup.out /tmp/cirrus-ci-build/build/testrun/pg_plan_advice...
--- /tmp/cirrus-ci-build/src/test/regress/expected/test_setup.out 2025-11-10 11:28:11.620159385 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_plan_advice/001_regress/data/results/test_setup.out 2025-11-10 11:35:35.727184...
@@ -205,6 +205,7 @@
RETURNS bool
AS :'regresslib', 'binary_coercible'
LANGUAGE C STRICT STABLE PARALLEL SAFE;
+ERROR: could not access file "/usr/local/pgsql/lib/x86_64-linux-gnu/regress.so": No such file or directory
-- Use hand-rolled hash functions and operator classes to get predictable
-- result on different machines. The hash function for int4 simply returns
-- the sum of the values passed to it and the one for text returns the length
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/type_sanity.out /tmp/cirrus-ci-build/build/testrun/pg_plan_advic...
--- /tmp/cirrus-ci-build/src/test/regress/expected/type_sanity.out 2025-11-10 11:28:11.628159386 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_plan_advice/001_regress/data/results/type_sanity.out 2025-11-10 11:35:38.86718...
@@ -595,6 +595,7 @@
CREATE FUNCTION is_catalog_text_unique_index_oid(oid) RETURNS bool
AS :'regresslib', 'is_catalog_text_unique_index_oid'
LANGUAGE C STRICT;
+ERROR: could not access file "/usr/local/pgsql/lib/x86_64-linux-gnu/regress.so": No such file or directory
SELECT indexrelid::regclass
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out 2025-11-10 11:28:11.620159385 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/subselect.out 2025-11-10 11:32:40.39943507...
@@ -2767,436 +2767,10 @@
-- Pull up direct-correlated ANY_SUBLINKs
explain (costs off)
select * from tenk1 A where hundred in (select hundred from tenk2 B where B.odd = A.odd);
- QUERY PLAN
-------------------------------------------------------------
- Hash Join
- Hash Cond: ((a.odd = b.odd) AND (a.hundred = b.hundred))
- -> Seq Scan on tenk1 a
- -> Hash
- -> HashAggregate
- Group Key: b.odd, b.hundred
- -> Seq Scan on tenk2 b
-(7 rows)
-
-explain (costs off)
-select * from tenk1 A where exists
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/pl/plpgsql/src/expected/plpgsql_simple.out /tmp/cirrus-ci-build/build/testrun/plpgsql/...
--- /tmp/cirrus-ci-build/src/pl/plpgsql/src/expected/plpgsql_simple.out 2025-11-10 11:28:11.376159376 +0000
+++ /tmp/cirrus-ci-build/build/testrun/plpgsql/regress/results/plpgsql_simple.out 2025-11-10 11:33:38.775322718 +0000
@@ -128,4 +128,7 @@
fetch p_CurData into val;
raise notice 'val = %', val;
end; $$;
-NOTICE: val = 42
+server closed the connection unexpectedly
+ This probably means the server terminated abnormally
+ before or while processing the request.
+connection to server was lost
diff -U3 /tmp/cirrus-ci-build/src/pl/plpgsql/src/expected/plpgsql_transaction.out /tmp/cirrus-ci-build/build/testrun/plp...
--- /tmp/cirrus-ci-build/src/pl/plpgsql/src/expected/plpgsql_transaction.out 2025-11-10 11:28:11.376159376 +0000
+++ /tmp/cirrus-ci-build/build/testrun/plpgsql/regress/results/plpgsql_transaction.out 2025-11-10 11:33:38.839322621 +00...
@@ -1,741 +1 @@
-CREATE TABLE test1 (a int, b text);
-CREATE PROCEDURE transaction_test1(x int, y text)
-LANGUAGE plpgsql
-AS $$
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out /tmp/cirrus-ci-build/build/testrun/recovery/027_st...
--- /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out 2025-11-10 11:28:11.620159385 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/subselect.out 2025-11-10 11:33:25.419344...
@@ -1436,1767 +1436,10 @@
--
begin;
set local enable_sort = off;
-explain (costs off)
-select count(*) from
- onek o cross join lateral (
- select * from onek i1 where i1.unique1 = o.unique1
- except
- select * from onek i2 where i2.unique1 = o.unique2
- ) ss
-where o.ten = 1;
- QUERY PLAN
-------------------------------------------------------------
- Aggregate
- -> Nested Loop
- -> Seq Scan on onek o
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out /tmp/cirrus-ci-build/build/testrun/regress/regress...
--- /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out 2025-11-10 11:28:11.620159385 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/subselect.out 2025-11-10 11:32:38.827438989 +0000
@@ -2783,420 +2783,10 @@
(select 1 from tenk2 B
where A.hundred in (select C.hundred FROM tenk2 C
WHERE c.odd = b.odd));
- QUERY PLAN
----------------------------------------------------------
- Nested Loop Semi Join
- Join Filter: (ANY (a.hundred = (SubPlan any_1).col1))
- -> Seq Scan on tenk1 a
- -> Materialize
- -> Seq Scan on tenk2 b
- SubPlan any_1
- -> Seq Scan on tenk2 c
- Filter: (odd = b.odd)
-(8 rows)
-
--- we should only try to pull up the sublink into RHS of a left join
... |
|
OpenBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/test_setup.out /home/postgres/postgres/build/testrun/pg_plan_...
--- /home/postgres/postgres/src/test/regress/expected/test_setup.out Mon Nov 10 11:28:28 2025
+++ /home/postgres/postgres/build/testrun/pg_plan_advice/001_regress/data/results/test_setup.out Mon Nov 10 11:37:18 202...
@@ -205,6 +205,7 @@
RETURNS bool
AS :'regresslib', 'binary_coercible'
LANGUAGE C STRICT STABLE PARALLEL SAFE;
+ERROR: could not access file "/usr/local/pgsql/lib/regress.so": No such file or directory
-- Use hand-rolled hash functions and operator classes to get predictable
-- result on different machines. The hash function for int4 simply returns
-- the sum of the values passed to it and the one for text returns the length
diff -U3 /home/postgres/postgres/src/test/regress/expected/type_sanity.out /home/postgres/postgres/build/testrun/pg_plan...
--- /home/postgres/postgres/src/test/regress/expected/type_sanity.out Mon Nov 10 11:28:28 2025
+++ /home/postgres/postgres/build/testrun/pg_plan_advice/001_regress/data/results/type_sanity.out Mon Nov 10 11:37:26 20...
@@ -595,6 +595,7 @@
CREATE FUNCTION is_catalog_text_unique_index_oid(oid) RETURNS bool
AS :'regresslib', 'is_catalog_text_unique_index_oid'
LANGUAGE C STRICT;
+ERROR: could not access file "/usr/local/pgsql/lib/regress.so": No such file or directory
SELECT indexrelid::regclass
... |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/test_setup.out /home/postgres/postgres/build/testrun/pg_plan_...
--- /home/postgres/postgres/src/test/regress/expected/test_setup.out 2025-11-10 11:28:40.436160449 +0000
+++ /home/postgres/postgres/build/testrun/pg_plan_advice/001_regress/data/results/test_setup.out 2025-11-10 11:33:39.494...
@@ -205,6 +205,7 @@
RETURNS bool
AS :'regresslib', 'binary_coercible'
LANGUAGE C STRICT STABLE PARALLEL SAFE;
+ERROR: could not access file "/usr/local/pgsql/lib/regress.so": No such file or directory
-- Use hand-rolled hash functions and operator classes to get predictable
-- result on different machines. The hash function for int4 simply returns
-- the sum of the values passed to it and the one for text returns the length
diff -U3 /home/postgres/postgres/src/test/regress/expected/type_sanity.out /home/postgres/postgres/build/testrun/pg_plan...
--- /home/postgres/postgres/src/test/regress/expected/type_sanity.out 2025-11-10 11:28:40.461981728 +0000
+++ /home/postgres/postgres/build/testrun/pg_plan_advice/001_regress/data/results/type_sanity.out 2025-11-10 11:33:41.64...
@@ -595,6 +595,7 @@
CREATE FUNCTION is_catalog_text_unique_index_oid(oid) RETURNS bool
AS :'regresslib', 'is_catalog_text_unique_index_oid'
LANGUAGE C STRICT;
+ERROR: could not access file "/usr/local/pgsql/lib/regress.so": No such file or directory
SELECT indexrelid::regclass
... |
|
Linux - Debian Trixie - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/test_setup.out /tmp/cirrus-ci-build/contrib/pg_plan_advice/tmp_c...
--- /tmp/cirrus-ci-build/src/test/regress/expected/test_setup.out 2025-11-10 11:28:19.550820240 +0000
+++ /tmp/cirrus-ci-build/contrib/pg_plan_advice/tmp_check/results/test_setup.out 2025-11-10 11:35:00.926811563 +0000
@@ -205,6 +205,7 @@
RETURNS bool
AS :'regresslib', 'binary_coercible'
LANGUAGE C STRICT STABLE PARALLEL SAFE;
+ERROR: could not access file "/usr/local/pgsql/lib/regress.so": No such file or directory
-- Use hand-rolled hash functions and operator classes to get predictable
-- result on different machines. The hash function for int4 simply returns
-- the sum of the values passed to it and the one for text returns the length
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/type_sanity.out /tmp/cirrus-ci-build/contrib/pg_plan_advice/tmp_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/type_sanity.out 2025-11-10 11:28:19.554844490 +0000
+++ /tmp/cirrus-ci-build/contrib/pg_plan_advice/tmp_check/results/type_sanity.out 2025-11-10 11:35:07.794951755 +0000
@@ -595,6 +595,7 @@
CREATE FUNCTION is_catalog_text_unique_index_oid(oid) RETURNS bool
AS :'regresslib', 'is_catalog_text_unique_index_oid'
LANGUAGE C STRICT;
+ERROR: could not access file "/usr/local/pgsql/lib/regress.so": No such file or directory
SELECT indexrelid::regclass
... |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/test_setup.out /tmp/cirrus-ci-build/build/testrun/pg_plan_advice...
--- /tmp/cirrus-ci-build/src/test/regress/expected/test_setup.out 2025-11-10 11:28:10.061725000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_plan_advice/001_regress/data/results/test_setup.out 2025-11-10 11:34:46.527555...
@@ -205,6 +205,7 @@
RETURNS bool
AS :'regresslib', 'binary_coercible'
LANGUAGE C STRICT STABLE PARALLEL SAFE;
+ERROR: could not access file "/usr/local/pgsql/lib/regress.so": No such file or directory
-- Use hand-rolled hash functions and operator classes to get predictable
-- result on different machines. The hash function for int4 simply returns
-- the sum of the values passed to it and the one for text returns the length
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/type_sanity.out /tmp/cirrus-ci-build/build/testrun/pg_plan_advic...
--- /tmp/cirrus-ci-build/src/test/regress/expected/type_sanity.out 2025-11-10 11:28:10.067748000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_plan_advice/001_regress/data/results/type_sanity.out 2025-11-10 11:35:03.53687...
@@ -595,6 +595,7 @@
CREATE FUNCTION is_catalog_text_unique_index_oid(oid) RETURNS bool
AS :'regresslib', 'is_catalog_text_unique_index_oid'
LANGUAGE C STRICT;
+ERROR: could not access file "/usr/local/pgsql/lib/regress.so": No such file or directory
SELECT indexrelid::regclass
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/pg_plan_advice/expected/local_collector.out /tmp/cirrus-ci-build/build/testrun/pg_...
--- /tmp/cirrus-ci-build/contrib/pg_plan_advice/expected/local_collector.out 2025-11-10 11:28:08.447929000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_plan_advice/regress/results/local_collector.out 2025-11-10 11:33:48.944863000 ...
@@ -24,10 +24,10 @@
-- Should return the advice from the second test query.
SELECT advice FROM pg_get_collected_local_advice() ORDER BY id LIMIT 1;
- advice
-------------------------
- SEQ_SCAN(dummy_table) +
- NO_GATHER(dummy_table)
+ advice
+-----------------------
+ SEQ_SCAN(dummy_table)+
+ GATHER(dummy_table)
(1 row)
-- Now try clearing advice again. |
| 56/6054 |
let ALTER COLUMN SET DATA TYPE cope with POLICY dependency |
|
macOS - Sequoia - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/rowsecurity.out /Users/admin/pgsql/build/testrun/recovery/027_stre...
--- /Users/admin/pgsql/src/test/regress/expected/rowsecurity.out 2025-11-09 20:11:05
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/rowsecurity.out 2025-11-09 20:14:42
@@ -376,15 +376,15 @@
--------------------+----------+-------+----------------------------------------------+-------------------+------------...
regress_rls_schema | category | table | regress_rls_alice=arwdDxtm/regress_rls_alice+| |
| | | =arwdDxtm/regress_rls_alice | |
- regress_rls_schema | document | table | regress_rls_alice=arwdDxtm/regress_rls_alice+| | p1: ...
- | | | =arwdDxtm/regress_rls_alice | | (u): (dle...
+ regress_rls_schema | document | table | regress_rls_alice=arwdDxtm/regress_rls_alice+| | p1r (RESTRI...
+ | | | =arwdDxtm/regress_rls_alice | | (u): (cid...
+ | | | | | to: regre...
+ | | | | | p1: ...
+ | | | | | (u): (dle...
| | | | | FROM uac...
| | | | | WHERE (ua...
| | | | | p2r (RESTRI...
| | | | | (u): ((ci...
- | | | | | to: regre...
- | | | | | p1r (RESTRI...
... |
| 56/6198 |
Change initdb default to the builtin collation provider |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/contrib/citext/expected/citext_utf8.out /home/postgres/postgres/build/testrun/citext/re...
--- /home/postgres/postgres/contrib/citext/expected/citext_utf8.out 2025-11-09 00:59:19.680370385 +0000
+++ /home/postgres/postgres/build/testrun/citext/regress/results/citext_utf8.out 2025-11-09 01:01:24.665082762 +0000
@@ -30,7 +30,7 @@
SELECT 'À'::citext = 'à'::citext AS t;
t
---
- t
+ f
(1 row)
SELECT 'À'::text = 'à'::text AS f; -- text wins.
@@ -64,7 +64,7 @@
SELECT 'i'::citext = 'İ'::citext AS t;
t
---
- t
+ f
(1 row)
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/modules/test_regex/expected/test_regex_utf8.out /home/postgres/postgres/build/...
--- /home/postgres/postgres/src/test/modules/test_regex/expected/test_regex_utf8.out 2025-11-09 00:59:27.418008183 +0000
+++ /home/postgres/postgres/build/testrun/test_regex/regress/results/test_regex_utf8.out 2025-11-09 01:01:47.677586869 +...
@@ -152,7 +152,7 @@
test_regex
-----------------
{0,REG_ULOCALE}
- {xᔀሷ}
+ {x}
(2 rows)
select * from test_regex('[[:lower:]]+', E'x\u1500\u1237', 'L');
@@ -166,7 +166,7 @@
test_regex
-----------------
{0,REG_ULOCALE}
- {xᔀሷ}
+ {x}
(2 rows)
... |
| 56/5958 |
Per backend relation statistics tracking |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/stats.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_u...
--- /tmp/cirrus-ci-build/src/test/regress/expected/stats.out 2025-11-05 13:07:53.517859000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/stats.out 2025-11-05 13:12:36.460976000 +0...
@@ -243,7 +243,7 @@
SELECT :seq_scan_after > :seq_scan_before;
?column?
----------
- t
+ f
(1 row)
---- |
| 56/6087 |
CREATE TABLE LIKE INCLUDING TRIGGERS |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/triggers.out C:/cirrus/build/testrun/regress/regress/re...
--- C:/cirrus/src/test/regress/expected/triggers.out 2025-11-05 00:24:02.065787400 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/triggers.out 2025-11-05 00:26:45.121603600 +0000
@@ -407,6 +407,7 @@
--create table like tests
COMMENT ON TRIGGER before_ins_stmt_trig ON main_table IS 'trigger before_ins_stmt_trig';
CREATE TABLE main_table1(c INT, LIKE main_table INCLUDING TRIGGERS INCLUDING COMMENTS);
+ERROR: trigger "after_ins_stmt_trig" for relation "main_table1" already exists
\d main_table
Table "public.main_table"
Column | Type | Collation | Nullable | Default
@@ -424,22 +425,6 @@
before_upd_a_stmt_trig BEFORE UPDATE OF a ON main_table FOR EACH STATEMENT EXECUTE FUNCTION trigger_func('before_up...
\d main_table1
- Table "public.main_table1"
- Column | Type | Collation | Nullable | Default
---------+---------+-----------+----------+---------
- c | integer | | |
- a | integer | | |
... |
|
Linux - Debian Trixie - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/build/testrun/recovery/027_str...
--- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out 2025-11-05 00:23:58.919191853 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/triggers.out 2025-11-05 00:29:29.3986958...
@@ -431,14 +431,14 @@
a | integer | | |
b | integer | | |
Triggers:
+ "0 0 0 0 0 0 0 ]} :resulttype 26 :resulttypmod -1 :resultcollid " BEFORE INSERT ON main_table1 FOR EACH STATEMENT E...
after_ins_stmt_trig AFTER INSERT ON main_table1 FOR EACH STATEMENT EXECUTE FUNCTION trigger_func('after_ins_stmt')
after_upd_a_b_row_trig AFTER UPDATE OF a, b ON main_table1 FOR EACH ROW EXECUTE FUNCTION trigger_func('after_upd_a_...
after_upd_b_row_trig AFTER UPDATE OF b ON main_table1 FOR EACH ROW EXECUTE FUNCTION trigger_func('after_upd_b_row')
after_upd_b_stmt_trig AFTER UPDATE OF b ON main_table1 FOR EACH STATEMENT EXECUTE FUNCTION trigger_func('after_upd_...
- after_upd_stmt_trig AFTER UPDATE ON main_table1 FOR EACH STATEMENT EXECUTE FUNCTION trigger_func('after_upd_stmt')
- before_ins_stmt_trig BEFORE INSERT ON main_table1 FOR EACH STATEMENT EXECUTE FUNCTION trigger_func('before_ins_stmt...
before_upd_a_row_trig BEFORE UPDATE OF a ON main_table1 FOR EACH ROW EXECUTE FUNCTION trigger_func('before_upd_a_ro...
before_upd_a_stmt_trig BEFORE UPDATE OF a ON main_table1 FOR EACH STATEMENT EXECUTE FUNCTION trigger_func('before_u...
+ "false :opcollid 0 :inputcollid 0 :args ({VAR :varno 2 :varattno" AFTER UPDATE ON main_table1 FOR EACH STATEMENT EX...
\dd before_ins_stmt_trig
Object descriptions |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/build/testrun/recovery/027_str...
--- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out 2025-11-05 00:23:57.461266000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/triggers.out 2025-11-05 00:27:34.9832430...
@@ -431,6 +431,7 @@
a | integer | | |
b | integer | | |
Triggers:
+ "" BEFORE UPDATE OF a ON main_table1 FOR EACH STATEMENT EXECUTE FUNCTION trigger_func('before_upd_a_stmt')
after_ins_stmt_trig AFTER INSERT ON main_table1 FOR EACH STATEMENT EXECUTE FUNCTION trigger_func('after_ins_stmt')
after_upd_a_b_row_trig AFTER UPDATE OF a, b ON main_table1 FOR EACH ROW EXECUTE FUNCTION trigger_func('after_upd_a_...
after_upd_b_row_trig AFTER UPDATE OF b ON main_table1 FOR EACH ROW EXECUTE FUNCTION trigger_func('after_upd_b_row')
@@ -438,7 +439,6 @@
after_upd_stmt_trig AFTER UPDATE ON main_table1 FOR EACH STATEMENT EXECUTE FUNCTION trigger_func('after_upd_stmt')
before_ins_stmt_trig BEFORE INSERT ON main_table1 FOR EACH STATEMENT EXECUTE FUNCTION trigger_func('before_ins_stmt...
before_upd_a_row_trig BEFORE UPDATE OF a ON main_table1 FOR EACH ROW EXECUTE FUNCTION trigger_func('before_upd_a_ro...
- before_upd_a_stmt_trig BEFORE UPDATE OF a ON main_table1 FOR EACH STATEMENT EXECUTE FUNCTION trigger_func('before_u...
\dd before_ins_stmt_trig
Object descriptions |
|
OpenBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/triggers.out /home/postgres/postgres/build/testrun/recovery/0...
--- /home/postgres/postgres/src/test/regress/expected/triggers.out Wed Nov 5 00:24:19 2025
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/triggers.out Wed Nov 5 00:29:35 2025
@@ -407,6 +407,7 @@
--create table like tests
COMMENT ON TRIGGER before_ins_stmt_trig ON main_table IS 'trigger before_ins_stmt_trig';
CREATE TABLE main_table1(c INT, LIKE main_table INCLUDING TRIGGERS INCLUDING COMMENTS);
+ERROR: trigger "" for relation "main_table1" already exists
\d main_table
Table "public.main_table"
Column | Type | Collation | Nullable | Default
@@ -424,22 +425,6 @@
before_upd_a_stmt_trig BEFORE UPDATE OF a ON main_table FOR EACH STATEMENT EXECUTE FUNCTION trigger_func('before_up...
\d main_table1
- Table "public.main_table1"
- Column | Type | Collation | Nullable | Default
---------+---------+-----------+----------+---------
- c | integer | | |
- a | integer | | |
... |