This robot generates gigabytes of CI logs every week. Here is an attempt to
search for "highlights", so it's easier to find actionable information
quickly. New ideas for what patterns to search for are very welcome.
"Current" shows only the most recent results from each submission. The
wider time ranges also show information about historical versions, which
may be useful for flapping tests, and also for hunting for bugs in master.
| 56/6175 |
Add pg_get_tablespace_ddl() function to reconstruct CREATE TABLESPACE statement |
 |
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/tablespace.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002...
--- /tmp/cirrus-ci-build/src/test/regress/expected/tablespace.out 2025-11-04 00:22:03.953589000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/tablespace.out 2025-11-04 00:27:32.0758110...
@@ -986,6 +986,7 @@
DROP TABLESPACE regress_noopt_tblsp;
-- create a tablespace with a space in the name
CREATE TABLESPACE "regress tblsp" LOCATION ''; -- ok
+WARNING: tablespaces created by regression test cases should have names starting with "regress_"
-- see that the tablespace ddl is correctly returned
SELECT pg_get_tablespace_ddl('regress tblsp');
pg_get_tablespace_ddl |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/tablespace.out /tmp/cirrus-ci-build/build/testrun/recovery/027_s...
--- /tmp/cirrus-ci-build/src/test/regress/expected/tablespace.out 2025-11-04 00:22:03.953589000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/tablespace.out 2025-11-04 00:28:34.02515...
@@ -986,6 +986,7 @@
DROP TABLESPACE regress_noopt_tblsp;
-- create a tablespace with a space in the name
CREATE TABLESPACE "regress tblsp" LOCATION ''; -- ok
+WARNING: tablespaces created by regression test cases should have names starting with "regress_"
-- see that the tablespace ddl is correctly returned
SELECT pg_get_tablespace_ddl('regress tblsp');
pg_get_tablespace_ddl |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/tablespace.out /tmp/cirrus-ci-build/build/testrun/regress/regres...
--- /tmp/cirrus-ci-build/src/test/regress/expected/tablespace.out 2025-11-04 00:22:03.953589000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/tablespace.out 2025-11-04 00:27:40.747566000 +0000
@@ -986,6 +986,7 @@
DROP TABLESPACE regress_noopt_tblsp;
-- create a tablespace with a space in the name
CREATE TABLESPACE "regress tblsp" LOCATION ''; -- ok
+WARNING: tablespaces created by regression test cases should have names starting with "regress_"
-- see that the tablespace ddl is correctly returned
SELECT pg_get_tablespace_ddl('regress tblsp');
pg_get_tablespace_ddl |
| 56/5617 |
Beautify read stream "per buffer data" APIs |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/isolation/expected/read-only-anomaly.out /home/postgres/postgres/build/testrun...
--- /home/postgres/postgres/src/test/isolation/expected/read-only-anomaly.out 2025-11-03 16:44:21.170970971 +0000
+++ /home/postgres/postgres/build/testrun/isolation/isolation/results/read-only-anomaly.out 2025-11-03 16:46:14.26769346...
@@ -1,33 +1,3 @@
Parsed test spec with 3 sessions
-
-starting permutation: s2rx s2ry s1ry s1wy s1c s3r s2wx s2c s3c
-step s2rx: SELECT balance FROM bank_account WHERE id = 'X';
-balance
--------
- 0
-(1 row)
-
-step s2ry: SELECT balance FROM bank_account WHERE id = 'Y';
-balance
--------
- 0
-(1 row)
-
-step s1ry: SELECT balance FROM bank_account WHERE id = 'Y';
... |
| 56/6184 |
pg_plan_advice |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/pg_plan_advice/expected/gather.out /tmp/cirrus-ci-build/build/testrun/pg_plan_advi...
--- /tmp/cirrus-ci-build/contrib/pg_plan_advice/expected/gather.out 2025-11-03 12:51:14.011106000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_plan_advice/regress/results/gather.out 2025-11-03 12:55:33.057089000 +0000
@@ -260,14 +260,14 @@
Sort Key: f.dim_id
-> Seq Scan on gt_fact f
Supplied Plan Advice:
- NO_GATHER(f) /* matched */
- NO_GATHER(d) /* matched */
+ NO_GATHER(f) /* matched, failed */
+ NO_GATHER(d) /* matched, failed */
Generated Plan Advice:
JOIN_ORDER(d f)
MERGE_JOIN_PLAIN(f)
SEQ_SCAN(f)
INDEX_SCAN(d public.gt_dim_pkey)
- NO_GATHER(f d)
+ GATHER((f d))
(15 rows)
... |
| 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-03 00:02:44.159427769 +0000
+++ /home/postgres/postgres/build/testrun/citext/regress/results/citext_utf8.out 2025-11-03 00:04:56.796463601 +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-03 00:02:51.590353092 +0000
+++ /home/postgres/postgres/build/testrun/test_regex/regress/results/test_regex_utf8.out 2025-11-03 00:05:18.706906284 +...
@@ -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/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/pg_upgrade/002_pg...
--- /Users/admin/pgsql/src/test/regress/expected/rowsecurity.out 2025-11-02 06:25:04
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/rowsecurity.out 2025-11-02 06:27:31
@@ -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...
... |
| 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-02 06:25:04
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/rowsecurity.out 2025-11-02 06:28:22
@@ -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/6078 |
Optimize LISTEN/NOTIFY |
|
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-02 00:25:56.656769000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/postgres_fdw-running/regress/results/postgres_fdw.out 2025-11-02 00:34:10.7006520...
@@ -12713,8 +12713,7 @@
FROM postgres_fdw_get_connections(true);
server_name | closed | remote_backend_pid
-------------+--------+--------------------
- loopback | t | t
-(1 row)
+(0 rows)
-- Clean up
\set VERBOSITY default |
| 56/5699 |
Adding error messages to a few slash commands |
|
Windows - Server 2022, MinGW64 - Meson |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/matview.out C:/cirrus/build/testrun/pg_upgrade/002_pg_u...
--- C:/cirrus/src/test/regress/expected/matview.out 2025-11-02 00:13:31.684350700 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/matview.out 2025-11-02 00:16:13.822746200 +0000
@@ -141,6 +141,11 @@
CREATE SCHEMA mvtest_mvschema;
ALTER MATERIALIZED VIEW mvtest_tvm SET SCHEMA mvtest_mvschema;
\d+ mvtest_tvm
+ List of relations
+ Schema | Name | Type | Owner | Persistence | Size | Description
+--------+------+------+-------+-------------+------+-------------
+(0 rows)
+
\d+ mvtest_tvmm
Materialized view "public.mvtest_tvmm"
Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/identity.out C:/cirrus/build/testrun/pg_upgrade/002_pg_...
--- C:/cirrus/src/test/regress/expected/identity.out 2025-11-02 00:13:31.653792500 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/identity.out 2025-11-02 00:16:13.319820400 +0000
@@ -607,6 +607,11 @@
Sequence for identity column: public.itest8.f4
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/matview.out C:/cirrus/build/testrun/recovery/027_stream...
--- C:/cirrus/src/test/regress/expected/matview.out 2025-11-02 00:13:31.684350700 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/matview.out 2025-11-02 00:19:03.140047900 +0000
@@ -141,6 +141,11 @@
CREATE SCHEMA mvtest_mvschema;
ALTER MATERIALIZED VIEW mvtest_tvm SET SCHEMA mvtest_mvschema;
\d+ mvtest_tvm
+ List of relations
+ Schema | Name | Type | Owner | Persistence | Size | Description
+--------+------+------+-------+-------------+------+-------------
+(0 rows)
+
\d+ mvtest_tvmm
Materialized view "public.mvtest_tvmm"
Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/identity.out C:/cirrus/build/testrun/recovery/027_strea...
--- C:/cirrus/src/test/regress/expected/identity.out 2025-11-02 00:13:31.653792500 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/identity.out 2025-11-02 00:19:04.000889100 +0000
@@ -607,6 +607,11 @@
Sequence for identity column: public.itest8.f4
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/matview.out C:/cirrus/build/testrun/regress/regress/res...
--- C:/cirrus/src/test/regress/expected/matview.out 2025-11-02 00:13:31.684350700 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/matview.out 2025-11-02 00:16:07.576663900 +0000
@@ -141,6 +141,11 @@
CREATE SCHEMA mvtest_mvschema;
ALTER MATERIALIZED VIEW mvtest_tvm SET SCHEMA mvtest_mvschema;
\d+ mvtest_tvm
+ List of relations
+ Schema | Name | Type | Owner | Persistence | Size | Description
+--------+------+------+-------+-------------+------+-------------
+(0 rows)
+
\d+ mvtest_tvmm
Materialized view "public.mvtest_tvmm"
Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/identity.out C:/cirrus/build/testrun/regress/regress/re...
--- C:/cirrus/src/test/regress/expected/identity.out 2025-11-02 00:13:31.653792500 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/identity.out 2025-11-02 00:16:07.108020400 +0000
@@ -607,6 +607,11 @@
Sequence for identity column: public.itest8.f4
... |
|
macOS - Sequoia - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/matview.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upg...
--- /Users/admin/pgsql/src/test/regress/expected/matview.out 2025-11-02 00:13:16
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/matview.out 2025-11-02 00:15:56
@@ -141,6 +141,11 @@
CREATE SCHEMA mvtest_mvschema;
ALTER MATERIALIZED VIEW mvtest_tvm SET SCHEMA mvtest_mvschema;
\d+ mvtest_tvm
+ List of relations
+ Schema | Name | Type | Owner | Persistence | Size | Description
+--------+------+------+-------+-------------+------+-------------
+(0 rows)
+
\d+ mvtest_tvmm
Materialized view "public.mvtest_tvmm"
Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
diff -U3 /Users/admin/pgsql/src/test/regress/expected/identity.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_up...
--- /Users/admin/pgsql/src/test/regress/expected/identity.out 2025-11-02 00:13:16
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/identity.out 2025-11-02 00:15:55
@@ -607,6 +607,11 @@
Sequence for identity column: public.itest8.f4
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/matview.out /Users/admin/pgsql/build/testrun/recovery/027_stream_r...
--- /Users/admin/pgsql/src/test/regress/expected/matview.out 2025-11-02 00:13:16
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/matview.out 2025-11-02 00:16:47
@@ -141,6 +141,11 @@
CREATE SCHEMA mvtest_mvschema;
ALTER MATERIALIZED VIEW mvtest_tvm SET SCHEMA mvtest_mvschema;
\d+ mvtest_tvm
+ List of relations
+ Schema | Name | Type | Owner | Persistence | Size | Description
+--------+------+------+-------+-------------+------+-------------
+(0 rows)
+
\d+ mvtest_tvmm
Materialized view "public.mvtest_tvmm"
Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
diff -U3 /Users/admin/pgsql/src/test/regress/expected/identity.out /Users/admin/pgsql/build/testrun/recovery/027_stream_...
--- /Users/admin/pgsql/src/test/regress/expected/identity.out 2025-11-02 00:13:16
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/identity.out 2025-11-02 00:16:48
@@ -607,6 +607,11 @@
Sequence for identity column: public.itest8.f4
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/matview.out /Users/admin/pgsql/build/testrun/regress/regress/resul...
--- /Users/admin/pgsql/src/test/regress/expected/matview.out 2025-11-02 00:13:16
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/matview.out 2025-11-02 00:15:56
@@ -141,6 +141,11 @@
CREATE SCHEMA mvtest_mvschema;
ALTER MATERIALIZED VIEW mvtest_tvm SET SCHEMA mvtest_mvschema;
\d+ mvtest_tvm
+ List of relations
+ Schema | Name | Type | Owner | Persistence | Size | Description
+--------+------+------+-------+-------------+------+-------------
+(0 rows)
+
\d+ mvtest_tvmm
Materialized view "public.mvtest_tvmm"
Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
diff -U3 /Users/admin/pgsql/src/test/regress/expected/identity.out /Users/admin/pgsql/build/testrun/regress/regress/resu...
--- /Users/admin/pgsql/src/test/regress/expected/identity.out 2025-11-02 00:13:16
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/identity.out 2025-11-02 00:15:56
@@ -607,6 +607,11 @@
Sequence for identity column: public.itest8.f4
... |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/matview.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg...
--- /tmp/cirrus-ci-build/src/test/regress/expected/matview.out 2025-11-02 00:13:15.992329656 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/matview.out 2025-11-02 00:15:14.236936584 ...
@@ -141,6 +141,11 @@
CREATE SCHEMA mvtest_mvschema;
ALTER MATERIALIZED VIEW mvtest_tvm SET SCHEMA mvtest_mvschema;
\d+ mvtest_tvm
+ List of relations
+ Schema | Name | Type | Owner | Persistence | Size | Description
+--------+------+------+-------+-------------+------+-------------
+(0 rows)
+
\d+ mvtest_tvmm
Materialized view "public.mvtest_tvmm"
Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/identity.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_p...
--- /tmp/cirrus-ci-build/src/test/regress/expected/identity.out 2025-11-02 00:13:15.976329322 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/identity.out 2025-11-02 00:15:14.376935580...
@@ -607,6 +607,11 @@
Sequence for identity column: public.itest8.f4
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/matview.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stre...
--- /tmp/cirrus-ci-build/src/test/regress/expected/matview.out 2025-11-02 00:13:15.992329656 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/matview.out 2025-11-02 00:16:35.51257813...
@@ -141,6 +141,11 @@
CREATE SCHEMA mvtest_mvschema;
ALTER MATERIALIZED VIEW mvtest_tvm SET SCHEMA mvtest_mvschema;
\d+ mvtest_tvm
+ List of relations
+ Schema | Name | Type | Owner | Persistence | Size | Description
+--------+------+------+-------+-------------+------+-------------
+(0 rows)
+
\d+ mvtest_tvmm
Materialized view "public.mvtest_tvmm"
Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/identity.out /tmp/cirrus-ci-build/build/testrun/recovery/027_str...
--- /tmp/cirrus-ci-build/src/test/regress/expected/identity.out 2025-11-02 00:13:15.976329322 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/identity.out 2025-11-02 00:16:35.5365780...
@@ -607,6 +607,11 @@
Sequence for identity column: public.itest8.f4
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/matview.out /tmp/cirrus-ci-build/build/testrun/regress/regress/r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/matview.out 2025-11-02 00:13:15.992329656 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/matview.out 2025-11-02 00:15:11.364957662 +0000
@@ -141,6 +141,11 @@
CREATE SCHEMA mvtest_mvschema;
ALTER MATERIALIZED VIEW mvtest_tvm SET SCHEMA mvtest_mvschema;
\d+ mvtest_tvm
+ List of relations
+ Schema | Name | Type | Owner | Persistence | Size | Description
+--------+------+------+-------+-------------+------+-------------
+(0 rows)
+
\d+ mvtest_tvmm
Materialized view "public.mvtest_tvmm"
Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/identity.out /tmp/cirrus-ci-build/build/testrun/regress/regress/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/identity.out 2025-11-02 00:13:15.976329322 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/identity.out 2025-11-02 00:15:11.208958827 +0000
@@ -607,6 +607,11 @@
Sequence for identity column: public.itest8.f4
... |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/matview.out C:/cirrus/build/testrun/pg_upgrade/002_pg_u...
--- C:/cirrus/src/test/regress/expected/matview.out 2025-11-02 00:13:18.784205100 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/matview.out 2025-11-02 00:16:22.563714600 +0000
@@ -141,6 +141,11 @@
CREATE SCHEMA mvtest_mvschema;
ALTER MATERIALIZED VIEW mvtest_tvm SET SCHEMA mvtest_mvschema;
\d+ mvtest_tvm
+ List of relations
+ Schema | Name | Type | Owner | Persistence | Size | Description
+--------+------+------+-------+-------------+------+-------------
+(0 rows)
+
\d+ mvtest_tvmm
Materialized view "public.mvtest_tvmm"
Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/identity.out C:/cirrus/build/testrun/pg_upgrade/002_pg_...
--- C:/cirrus/src/test/regress/expected/identity.out 2025-11-02 00:13:18.748864100 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/identity.out 2025-11-02 00:16:22.313712200 +0000
@@ -607,6 +607,11 @@
Sequence for identity column: public.itest8.f4
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/matview.out C:/cirrus/build/testrun/recovery/027_stream...
--- C:/cirrus/src/test/regress/expected/matview.out 2025-11-02 00:13:18.784205100 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/matview.out 2025-11-02 00:18:57.883954700 +0000
@@ -141,6 +141,11 @@
CREATE SCHEMA mvtest_mvschema;
ALTER MATERIALIZED VIEW mvtest_tvm SET SCHEMA mvtest_mvschema;
\d+ mvtest_tvm
+ List of relations
+ Schema | Name | Type | Owner | Persistence | Size | Description
+--------+------+------+-------+-------------+------+-------------
+(0 rows)
+
\d+ mvtest_tvmm
Materialized view "public.mvtest_tvmm"
Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/identity.out C:/cirrus/build/testrun/recovery/027_strea...
--- C:/cirrus/src/test/regress/expected/identity.out 2025-11-02 00:13:18.748864100 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/identity.out 2025-11-02 00:18:56.740889600 +0000
@@ -607,6 +607,11 @@
Sequence for identity column: public.itest8.f4
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/matview.out C:/cirrus/build/testrun/regress/regress/res...
--- C:/cirrus/src/test/regress/expected/matview.out 2025-11-02 00:13:18.784205100 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/matview.out 2025-11-02 00:16:16.448975300 +0000
@@ -141,6 +141,11 @@
CREATE SCHEMA mvtest_mvschema;
ALTER MATERIALIZED VIEW mvtest_tvm SET SCHEMA mvtest_mvschema;
\d+ mvtest_tvm
+ List of relations
+ Schema | Name | Type | Owner | Persistence | Size | Description
+--------+------+------+-------+-------------+------+-------------
+(0 rows)
+
\d+ mvtest_tvmm
Materialized view "public.mvtest_tvmm"
Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/identity.out C:/cirrus/build/testrun/regress/regress/re...
--- C:/cirrus/src/test/regress/expected/identity.out 2025-11-02 00:13:18.748864100 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/identity.out 2025-11-02 00:16:16.182367000 +0000
@@ -607,6 +607,11 @@
Sequence for identity column: public.itest8.f4
... |
|
OpenBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/matview.out /home/postgres/postgres/build/testrun/pg_upgrade/...
--- /home/postgres/postgres/src/test/regress/expected/matview.out Sun Nov 2 00:13:30 2025
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/matview.out Sun Nov 2 00:15:42 2025
@@ -141,6 +141,11 @@
CREATE SCHEMA mvtest_mvschema;
ALTER MATERIALIZED VIEW mvtest_tvm SET SCHEMA mvtest_mvschema;
\d+ mvtest_tvm
+ List of relations
+ Schema | Name | Type | Owner | Persistence | Size | Description
+--------+------+------+-------+-------------+------+-------------
+(0 rows)
+
\d+ mvtest_tvmm
Materialized view "public.mvtest_tvmm"
Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
diff -U3 /home/postgres/postgres/src/test/regress/expected/identity.out /home/postgres/postgres/build/testrun/pg_upgrade...
--- /home/postgres/postgres/src/test/regress/expected/identity.out Sun Nov 2 00:13:30 2025
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/identity.out Sun Nov 2 00:15:42 2025
@@ -607,6 +607,11 @@
Sequence for identity column: public.itest8.f4
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/matview.out /home/postgres/postgres/build/testrun/recovery/02...
--- /home/postgres/postgres/src/test/regress/expected/matview.out Sun Nov 2 00:13:30 2025
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/matview.out Sun Nov 2 00:17:23 2025
@@ -141,6 +141,11 @@
CREATE SCHEMA mvtest_mvschema;
ALTER MATERIALIZED VIEW mvtest_tvm SET SCHEMA mvtest_mvschema;
\d+ mvtest_tvm
+ List of relations
+ Schema | Name | Type | Owner | Persistence | Size | Description
+--------+------+------+-------+-------------+------+-------------
+(0 rows)
+
\d+ mvtest_tvmm
Materialized view "public.mvtest_tvmm"
Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
diff -U3 /home/postgres/postgres/src/test/regress/expected/identity.out /home/postgres/postgres/build/testrun/recovery/0...
--- /home/postgres/postgres/src/test/regress/expected/identity.out Sun Nov 2 00:13:30 2025
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/identity.out Sun Nov 2 00:17:24 2025
@@ -607,6 +607,11 @@
Sequence for identity column: public.itest8.f4
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/matview.out /home/postgres/postgres/build/testrun/regress/reg...
--- /home/postgres/postgres/src/test/regress/expected/matview.out Sun Nov 2 00:13:30 2025
+++ /home/postgres/postgres/build/testrun/regress/regress/results/matview.out Sun Nov 2 00:15:33 2025
@@ -141,6 +141,11 @@
CREATE SCHEMA mvtest_mvschema;
ALTER MATERIALIZED VIEW mvtest_tvm SET SCHEMA mvtest_mvschema;
\d+ mvtest_tvm
+ List of relations
+ Schema | Name | Type | Owner | Persistence | Size | Description
+--------+------+------+-------+-------------+------+-------------
+(0 rows)
+
\d+ mvtest_tvmm
Materialized view "public.mvtest_tvmm"
Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
diff -U3 /home/postgres/postgres/src/test/regress/expected/identity.out /home/postgres/postgres/build/testrun/regress/re...
--- /home/postgres/postgres/src/test/regress/expected/identity.out Sun Nov 2 00:13:30 2025
+++ /home/postgres/postgres/build/testrun/regress/regress/results/identity.out Sun Nov 2 00:15:33 2025
@@ -607,6 +607,11 @@
Sequence for identity column: public.itest8.f4
... |
|
Linux - Debian Bookworm - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/matview.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/re...
--- /tmp/cirrus-ci-build/src/test/regress/expected/matview.out 2025-11-02 00:13:20.704323133 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/matview.out 2025-11-02 00:18:21.731607052 +0000
@@ -141,6 +141,11 @@
CREATE SCHEMA mvtest_mvschema;
ALTER MATERIALIZED VIEW mvtest_tvm SET SCHEMA mvtest_mvschema;
\d+ mvtest_tvm
+ List of relations
+ Schema | Name | Type | Owner | Persistence | Size | Description
+--------+------+------+-------+-------------+------+-------------
+(0 rows)
+
\d+ mvtest_tvmm
Materialized view "public.mvtest_tvmm"
Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/identity.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/identity.out 2025-11-02 00:13:20.688314607 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/identity.out 2025-11-02 00:18:21.507594795 +0000
@@ -607,6 +607,11 @@
Sequence for identity column: public.itest8.f4
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/matview.out /tmp/cirrus-ci-build/src/test/regress/results/matvie...
--- /tmp/cirrus-ci-build/src/test/regress/expected/matview.out 2025-11-02 00:13:20.704323133 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/matview.out 2025-11-02 00:15:35.251084356 +0000
@@ -141,6 +141,11 @@
CREATE SCHEMA mvtest_mvschema;
ALTER MATERIALIZED VIEW mvtest_tvm SET SCHEMA mvtest_mvschema;
\d+ mvtest_tvm
+ List of relations
+ Schema | Name | Type | Owner | Persistence | Size | Description
+--------+------+------+-------+-------------+------+-------------
+(0 rows)
+
\d+ mvtest_tvmm
Materialized view "public.mvtest_tvmm"
Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/identity.out /tmp/cirrus-ci-build/src/test/regress/results/ident...
--- /tmp/cirrus-ci-build/src/test/regress/expected/identity.out 2025-11-02 00:13:20.688314607 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/identity.out 2025-11-02 00:15:34.959056506 +0000
@@ -607,6 +607,11 @@
Sequence for identity column: public.itest8.f4
... |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/matview.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg...
--- /tmp/cirrus-ci-build/src/test/regress/expected/matview.out 2025-11-02 00:13:13.882246000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/matview.out 2025-11-02 00:15:03.510158000 ...
@@ -141,6 +141,11 @@
CREATE SCHEMA mvtest_mvschema;
ALTER MATERIALIZED VIEW mvtest_tvm SET SCHEMA mvtest_mvschema;
\d+ mvtest_tvm
+ List of relations
+ Schema | Name | Type | Owner | Persistence | Size | Description
+--------+------+------+-------+-------------+------+-------------
+(0 rows)
+
\d+ mvtest_tvmm
Materialized view "public.mvtest_tvmm"
Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/identity.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_p...
--- /tmp/cirrus-ci-build/src/test/regress/expected/identity.out 2025-11-02 00:13:13.868921000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/identity.out 2025-11-02 00:15:02.348727000...
@@ -607,6 +607,11 @@
Sequence for identity column: public.itest8.f4
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/matview.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stre...
--- /tmp/cirrus-ci-build/src/test/regress/expected/matview.out 2025-11-02 00:13:13.882246000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/matview.out 2025-11-02 00:16:06.29691200...
@@ -141,6 +141,11 @@
CREATE SCHEMA mvtest_mvschema;
ALTER MATERIALIZED VIEW mvtest_tvm SET SCHEMA mvtest_mvschema;
\d+ mvtest_tvm
+ List of relations
+ Schema | Name | Type | Owner | Persistence | Size | Description
+--------+------+------+-------+-------------+------+-------------
+(0 rows)
+
\d+ mvtest_tvmm
Materialized view "public.mvtest_tvmm"
Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/identity.out /tmp/cirrus-ci-build/build/testrun/recovery/027_str...
--- /tmp/cirrus-ci-build/src/test/regress/expected/identity.out 2025-11-02 00:13:13.868921000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/identity.out 2025-11-02 00:16:03.2077040...
@@ -607,6 +607,11 @@
Sequence for identity column: public.itest8.f4
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/matview.out /tmp/cirrus-ci-build/build/testrun/regress/regress/r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/matview.out 2025-11-02 00:13:13.882246000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/matview.out 2025-11-02 00:15:02.551748000 +0000
@@ -141,6 +141,11 @@
CREATE SCHEMA mvtest_mvschema;
ALTER MATERIALIZED VIEW mvtest_tvm SET SCHEMA mvtest_mvschema;
\d+ mvtest_tvm
+ List of relations
+ Schema | Name | Type | Owner | Persistence | Size | Description
+--------+------+------+-------+-------------+------+-------------
+(0 rows)
+
\d+ mvtest_tvmm
Materialized view "public.mvtest_tvmm"
Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/identity.out /tmp/cirrus-ci-build/build/testrun/regress/regress/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/identity.out 2025-11-02 00:13:13.868921000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/identity.out 2025-11-02 00:14:56.530023000 +0000
@@ -607,6 +607,11 @@
Sequence for identity column: public.itest8.f4
... |
| 56/6158 |
Use log_newpage_range in HASH index build |
|
Windows - Server 2022, MinGW64 - Meson |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/create_index.out C:/cirrus/build/testrun/pg_upgrade/002...
--- C:/cirrus/src/test/regress/expected/create_index.out 2025-10-31 17:36:23.471843500 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/create_index.out 2025-10-31 17:39:43.159051500 +0000
@@ -1216,6 +1216,7 @@
-- maintenance_work_mem setting and fillfactor:
SET maintenance_work_mem = '1MB';
CREATE INDEX hash_tuplesort_idx ON tenk1 USING hash (stringu1 name_ops) WITH (fillfactor = 10);
+WARNING: spool init
EXPLAIN (COSTS OFF)
SELECT count(*) FROM tenk1 WHERE stringu1 = 'TVAAAA';
QUERY PLAN |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/create_index.out C:/cirrus/build/testrun/recovery/027_s...
--- C:/cirrus/src/test/regress/expected/create_index.out 2025-10-31 17:36:23.471843500 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/create_index.out 2025-10-31 17:42:30.711787700 +000...
@@ -1216,6 +1216,7 @@
-- maintenance_work_mem setting and fillfactor:
SET maintenance_work_mem = '1MB';
CREATE INDEX hash_tuplesort_idx ON tenk1 USING hash (stringu1 name_ops) WITH (fillfactor = 10);
+WARNING: spool init
EXPLAIN (COSTS OFF)
SELECT count(*) FROM tenk1 WHERE stringu1 = 'TVAAAA';
QUERY PLAN
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/hash_index.out C:/cirrus/build/testrun/recovery/027_str...
--- C:/cirrus/src/test/regress/expected/hash_index.out 2025-10-31 17:36:23.507586800 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/hash_index.out 2025-10-31 17:42:37.705437500 +0000
@@ -269,6 +269,7 @@
-- Rebuild the index using a different fillfactor
ALTER INDEX hash_split_index SET (fillfactor = 10);
REINDEX INDEX hash_split_index;
+WARNING: spool init
-- Clean up.
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/create_index.out C:/cirrus/build/testrun/regress/regres...
--- C:/cirrus/src/test/regress/expected/create_index.out 2025-10-31 17:36:23.471843500 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/create_index.out 2025-10-31 17:39:39.030147000 +0000
@@ -1216,6 +1216,7 @@
-- maintenance_work_mem setting and fillfactor:
SET maintenance_work_mem = '1MB';
CREATE INDEX hash_tuplesort_idx ON tenk1 USING hash (stringu1 name_ops) WITH (fillfactor = 10);
+WARNING: spool init
EXPLAIN (COSTS OFF)
SELECT count(*) FROM tenk1 WHERE stringu1 = 'TVAAAA';
QUERY PLAN |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/create_index.out C:/cirrus/build/testrun/pg_upgrade/002...
--- C:/cirrus/src/test/regress/expected/create_index.out 2025-10-31 17:36:29.998076400 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/create_index.out 2025-10-31 17:39:27.531620200 +0000
@@ -1216,6 +1216,7 @@
-- maintenance_work_mem setting and fillfactor:
SET maintenance_work_mem = '1MB';
CREATE INDEX hash_tuplesort_idx ON tenk1 USING hash (stringu1 name_ops) WITH (fillfactor = 10);
+WARNING: spool init
EXPLAIN (COSTS OFF)
SELECT count(*) FROM tenk1 WHERE stringu1 = 'TVAAAA';
QUERY PLAN |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/create_index.out C:/cirrus/build/testrun/recovery/027_s...
--- C:/cirrus/src/test/regress/expected/create_index.out 2025-10-31 17:36:29.998076400 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/create_index.out 2025-10-31 17:42:16.836796700 +000...
@@ -1216,6 +1216,7 @@
-- maintenance_work_mem setting and fillfactor:
SET maintenance_work_mem = '1MB';
CREATE INDEX hash_tuplesort_idx ON tenk1 USING hash (stringu1 name_ops) WITH (fillfactor = 10);
+WARNING: spool init
EXPLAIN (COSTS OFF)
SELECT count(*) FROM tenk1 WHERE stringu1 = 'TVAAAA';
QUERY PLAN
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/hash_index.out C:/cirrus/build/testrun/recovery/027_str...
--- C:/cirrus/src/test/regress/expected/hash_index.out 2025-10-31 17:36:30.032668000 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/hash_index.out 2025-10-31 17:42:30.566768200 +0000
@@ -269,6 +269,7 @@
-- Rebuild the index using a different fillfactor
ALTER INDEX hash_split_index SET (fillfactor = 10);
REINDEX INDEX hash_split_index;
+WARNING: spool init
-- Clean up.
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/create_index.out C:/cirrus/build/testrun/regress/regres...
--- C:/cirrus/src/test/regress/expected/create_index.out 2025-10-31 17:36:29.998076400 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/create_index.out 2025-10-31 17:39:18.016489200 +0000
@@ -1216,6 +1216,7 @@
-- maintenance_work_mem setting and fillfactor:
SET maintenance_work_mem = '1MB';
CREATE INDEX hash_tuplesort_idx ON tenk1 USING hash (stringu1 name_ops) WITH (fillfactor = 10);
+WARNING: spool init
EXPLAIN (COSTS OFF)
SELECT count(*) FROM tenk1 WHERE stringu1 = 'TVAAAA';
QUERY PLAN |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/0...
--- /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out 2025-10-31 17:36:22.399171294 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/create_index.out 2025-10-31 17:38:23.73339...
@@ -1216,6 +1216,7 @@
-- maintenance_work_mem setting and fillfactor:
SET maintenance_work_mem = '1MB';
CREATE INDEX hash_tuplesort_idx ON tenk1 USING hash (stringu1 name_ops) WITH (fillfactor = 10);
+WARNING: spool init
EXPLAIN (COSTS OFF)
SELECT count(*) FROM tenk1 WHERE stringu1 = 'TVAAAA';
QUERY PLAN |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out /tmp/cirrus-ci-build/build/testrun/recovery/027...
--- /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out 2025-10-31 17:36:22.399171294 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/create_index.out 2025-10-31 17:39:45.042...
@@ -1216,6 +1216,7 @@
-- maintenance_work_mem setting and fillfactor:
SET maintenance_work_mem = '1MB';
CREATE INDEX hash_tuplesort_idx ON tenk1 USING hash (stringu1 name_ops) WITH (fillfactor = 10);
+WARNING: spool init
EXPLAIN (COSTS OFF)
SELECT count(*) FROM tenk1 WHERE stringu1 = 'TVAAAA';
QUERY PLAN
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/hash_index.out /tmp/cirrus-ci-build/build/testrun/recovery/027_s...
--- /tmp/cirrus-ci-build/src/test/regress/expected/hash_index.out 2025-10-31 17:36:22.419169819 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/hash_index.out 2025-10-31 17:39:54.27830...
@@ -269,6 +269,7 @@
-- Rebuild the index using a different fillfactor
ALTER INDEX hash_split_index SET (fillfactor = 10);
REINDEX INDEX hash_split_index;
+WARNING: spool init
-- Clean up.
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out /tmp/cirrus-ci-build/build/testrun/regress/regr...
--- /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out 2025-10-31 17:36:22.399171294 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/create_index.out 2025-10-31 17:38:20.737409034 +0000
@@ -1216,6 +1216,7 @@
-- maintenance_work_mem setting and fillfactor:
SET maintenance_work_mem = '1MB';
CREATE INDEX hash_tuplesort_idx ON tenk1 USING hash (stringu1 name_ops) WITH (fillfactor = 10);
+WARNING: spool init
EXPLAIN (COSTS OFF)
SELECT count(*) FROM tenk1 WHERE stringu1 = 'TVAAAA';
QUERY PLAN |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/create_index.out /home/postgres/postgres/build/testrun/pg_upg...
--- /home/postgres/postgres/src/test/regress/expected/create_index.out 2025-10-31 17:36:36.769645173 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/create_index.out 2025-10-31 17:37:51.23...
@@ -1216,6 +1216,7 @@
-- maintenance_work_mem setting and fillfactor:
SET maintenance_work_mem = '1MB';
CREATE INDEX hash_tuplesort_idx ON tenk1 USING hash (stringu1 name_ops) WITH (fillfactor = 10);
+WARNING: spool init
EXPLAIN (COSTS OFF)
SELECT count(*) FROM tenk1 WHERE stringu1 = 'TVAAAA';
QUERY PLAN |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/create_index.out /home/postgres/postgres/build/testrun/recove...
--- /home/postgres/postgres/src/test/regress/expected/create_index.out 2025-10-31 17:36:36.769645173 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/create_index.out 2025-10-31 17:38:21....
@@ -1216,6 +1216,7 @@
-- maintenance_work_mem setting and fillfactor:
SET maintenance_work_mem = '1MB';
CREATE INDEX hash_tuplesort_idx ON tenk1 USING hash (stringu1 name_ops) WITH (fillfactor = 10);
+WARNING: spool init
EXPLAIN (COSTS OFF)
SELECT count(*) FROM tenk1 WHERE stringu1 = 'TVAAAA';
QUERY PLAN
diff -U3 /home/postgres/postgres/src/test/regress/expected/hash_index.out /home/postgres/postgres/build/testrun/recovery...
--- /home/postgres/postgres/src/test/regress/expected/hash_index.out 2025-10-31 17:36:36.822174424 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/hash_index.out 2025-10-31 17:38:34.64...
@@ -269,6 +269,7 @@
-- Rebuild the index using a different fillfactor
ALTER INDEX hash_split_index SET (fillfactor = 10);
REINDEX INDEX hash_split_index;
+WARNING: spool init
-- Clean up.
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/create_index.out /home/postgres/postgres/build/testrun/regres...
--- /home/postgres/postgres/src/test/regress/expected/create_index.out 2025-10-31 17:36:36.769645173 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/create_index.out 2025-10-31 17:37:46.785277404 +0000
@@ -1216,6 +1216,7 @@
-- maintenance_work_mem setting and fillfactor:
SET maintenance_work_mem = '1MB';
CREATE INDEX hash_tuplesort_idx ON tenk1 USING hash (stringu1 name_ops) WITH (fillfactor = 10);
+WARNING: spool init
EXPLAIN (COSTS OFF)
SELECT count(*) FROM tenk1 WHERE stringu1 = 'TVAAAA';
QUERY PLAN |
|
Linux - Debian Bookworm - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_che...
--- /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out 2025-10-31 17:36:22.132186942 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/create_index.out 2025-10-31 17:41:34.221174753 +0000
@@ -1216,6 +1216,7 @@
-- maintenance_work_mem setting and fillfactor:
SET maintenance_work_mem = '1MB';
CREATE INDEX hash_tuplesort_idx ON tenk1 USING hash (stringu1 name_ops) WITH (fillfactor = 10);
+WARNING: spool init
EXPLAIN (COSTS OFF)
SELECT count(*) FROM tenk1 WHERE stringu1 = 'TVAAAA';
QUERY PLAN |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out /tmp/cirrus-ci-build/src/test/recovery/tmp_chec...
--- /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out 2025-10-31 17:36:22.132186942 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/create_index.out 2025-10-31 17:43:20.369047591 +0000
@@ -1216,6 +1216,7 @@
-- maintenance_work_mem setting and fillfactor:
SET maintenance_work_mem = '1MB';
CREATE INDEX hash_tuplesort_idx ON tenk1 USING hash (stringu1 name_ops) WITH (fillfactor = 10);
+WARNING: spool init
EXPLAIN (COSTS OFF)
SELECT count(*) FROM tenk1 WHERE stringu1 = 'TVAAAA';
QUERY PLAN
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/hash_index.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/hash_index.out 2025-10-31 17:36:22.152187310 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/hash_index.out 2025-10-31 17:43:27.621022592 +0000
@@ -269,6 +269,7 @@
-- Rebuild the index using a different fillfactor
ALTER INDEX hash_split_index SET (fillfactor = 10);
REINDEX INDEX hash_split_index;
+WARNING: spool init
-- Clean up.
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out /tmp/cirrus-ci-build/src/test/regress/results/c...
--- /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out 2025-10-31 17:36:22.132186942 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/create_index.out 2025-10-31 17:38:26.736895478 +0000
@@ -1216,6 +1216,7 @@
-- maintenance_work_mem setting and fillfactor:
SET maintenance_work_mem = '1MB';
CREATE INDEX hash_tuplesort_idx ON tenk1 USING hash (stringu1 name_ops) WITH (fillfactor = 10);
+WARNING: spool init
EXPLAIN (COSTS OFF)
SELECT count(*) FROM tenk1 WHERE stringu1 = 'TVAAAA';
QUERY PLAN |
|
OpenBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/create_index.out /home/postgres/postgres/build/testrun/pg_upg...
--- /home/postgres/postgres/src/test/regress/expected/create_index.out Fri Oct 31 17:36:45 2025
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/create_index.out Fri Oct 31 17:38:39 20...
@@ -1216,6 +1216,7 @@
-- maintenance_work_mem setting and fillfactor:
SET maintenance_work_mem = '1MB';
CREATE INDEX hash_tuplesort_idx ON tenk1 USING hash (stringu1 name_ops) WITH (fillfactor = 10);
+WARNING: spool init
EXPLAIN (COSTS OFF)
SELECT count(*) FROM tenk1 WHERE stringu1 = 'TVAAAA';
QUERY PLAN |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/create_index.out /home/postgres/postgres/build/testrun/recove...
--- /home/postgres/postgres/src/test/regress/expected/create_index.out Fri Oct 31 17:36:45 2025
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/create_index.out Fri Oct 31 17:40:08 ...
@@ -1216,6 +1216,7 @@
-- maintenance_work_mem setting and fillfactor:
SET maintenance_work_mem = '1MB';
CREATE INDEX hash_tuplesort_idx ON tenk1 USING hash (stringu1 name_ops) WITH (fillfactor = 10);
+WARNING: spool init
EXPLAIN (COSTS OFF)
SELECT count(*) FROM tenk1 WHERE stringu1 = 'TVAAAA';
QUERY PLAN
diff -U3 /home/postgres/postgres/src/test/regress/expected/hash_index.out /home/postgres/postgres/build/testrun/recovery...
--- /home/postgres/postgres/src/test/regress/expected/hash_index.out Fri Oct 31 17:36:45 2025
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/hash_index.out Fri Oct 31 17:40:33 20...
@@ -269,6 +269,7 @@
-- Rebuild the index using a different fillfactor
ALTER INDEX hash_split_index SET (fillfactor = 10);
REINDEX INDEX hash_split_index;
+WARNING: spool init
-- Clean up.
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/create_index.out /home/postgres/postgres/build/testrun/regres...
--- /home/postgres/postgres/src/test/regress/expected/create_index.out Fri Oct 31 17:36:45 2025
+++ /home/postgres/postgres/build/testrun/regress/regress/results/create_index.out Fri Oct 31 17:38:28 2025
@@ -1216,6 +1216,7 @@
-- maintenance_work_mem setting and fillfactor:
SET maintenance_work_mem = '1MB';
CREATE INDEX hash_tuplesort_idx ON tenk1 USING hash (stringu1 name_ops) WITH (fillfactor = 10);
+WARNING: spool init
EXPLAIN (COSTS OFF)
SELECT count(*) FROM tenk1 WHERE stringu1 = 'TVAAAA';
QUERY PLAN |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/0...
--- /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out 2025-10-31 17:36:19.857054000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/create_index.out 2025-10-31 17:37:40.36672...
@@ -1216,6 +1216,7 @@
-- maintenance_work_mem setting and fillfactor:
SET maintenance_work_mem = '1MB';
CREATE INDEX hash_tuplesort_idx ON tenk1 USING hash (stringu1 name_ops) WITH (fillfactor = 10);
+WARNING: spool init
EXPLAIN (COSTS OFF)
SELECT count(*) FROM tenk1 WHERE stringu1 = 'TVAAAA';
QUERY PLAN |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out /tmp/cirrus-ci-build/build/testrun/recovery/027...
--- /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out 2025-10-31 17:36:19.857054000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/create_index.out 2025-10-31 17:38:46.948...
@@ -1216,6 +1216,7 @@
-- maintenance_work_mem setting and fillfactor:
SET maintenance_work_mem = '1MB';
CREATE INDEX hash_tuplesort_idx ON tenk1 USING hash (stringu1 name_ops) WITH (fillfactor = 10);
+WARNING: spool init
EXPLAIN (COSTS OFF)
SELECT count(*) FROM tenk1 WHERE stringu1 = 'TVAAAA';
QUERY PLAN
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/hash_index.out /tmp/cirrus-ci-build/build/testrun/recovery/027_s...
--- /tmp/cirrus-ci-build/src/test/regress/expected/hash_index.out 2025-10-31 17:36:19.871813000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/hash_index.out 2025-10-31 17:39:08.88014...
@@ -269,6 +269,7 @@
-- Rebuild the index using a different fillfactor
ALTER INDEX hash_split_index SET (fillfactor = 10);
REINDEX INDEX hash_split_index;
+WARNING: spool init
-- Clean up.
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out /tmp/cirrus-ci-build/build/testrun/regress/regr...
--- /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out 2025-10-31 17:36:19.857054000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/create_index.out 2025-10-31 17:37:39.307642000 +0000
@@ -1216,6 +1216,7 @@
-- maintenance_work_mem setting and fillfactor:
SET maintenance_work_mem = '1MB';
CREATE INDEX hash_tuplesort_idx ON tenk1 USING hash (stringu1 name_ops) WITH (fillfactor = 10);
+WARNING: spool init
EXPLAIN (COSTS OFF)
SELECT count(*) FROM tenk1 WHERE stringu1 = 'TVAAAA';
QUERY PLAN |
| 56/5382 |
Adding compression of temporary files |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/join_hash_pglz.out C:/cirrus/build/testrun/pg_upgrade/0...
--- C:/cirrus/src/test/regress/expected/join_hash_pglz.out 2025-10-31 12:25:45.819769100 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/join_hash_pglz.out 2025-10-31 12:30:21.632630400 +000...
@@ -1032,30 +1032,30 @@
------------------------------------------------------------------------------------------------
Hash Join
Output: hjtest_1.a, hjtest_2.a, (hjtest_1.tableoid)::regclass, (hjtest_2.tableoid)::regclass
- Hash Cond: ((hjtest_1.id = (SubPlan 1)) AND ((SubPlan 2) = (SubPlan 3)))
+ Hash Cond: ((hjtest_1.id = (SubPlan expr_1)) AND ((SubPlan expr_2) = (SubPlan expr_3)))
Join Filter: (hjtest_1.a <> hjtest_2.b)
-> Seq Scan on public.hjtest_1
Output: hjtest_1.a, hjtest_1.tableoid, hjtest_1.id, hjtest_1.b
- Filter: ((SubPlan 4) < 50)
- SubPlan 4
+ Filter: ((SubPlan expr_4) < 50)
+ SubPlan expr_4
-> Result
Output: (hjtest_1.b * 5)
-> Hash
Output: hjtest_2.a, hjtest_2.tableoid, hjtest_2.id, hjtest_2.c, hjtest_2.b
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/join_hash_pglz.out C:/cirrus/build/testrun/recovery/027...
--- C:/cirrus/src/test/regress/expected/join_hash_pglz.out 2025-10-31 12:25:45.819769100 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/join_hash_pglz.out 2025-10-31 12:33:30.277467100 +0...
@@ -1032,30 +1032,30 @@
------------------------------------------------------------------------------------------------
Hash Join
Output: hjtest_1.a, hjtest_2.a, (hjtest_1.tableoid)::regclass, (hjtest_2.tableoid)::regclass
- Hash Cond: ((hjtest_1.id = (SubPlan 1)) AND ((SubPlan 2) = (SubPlan 3)))
+ Hash Cond: ((hjtest_1.id = (SubPlan expr_1)) AND ((SubPlan expr_2) = (SubPlan expr_3)))
Join Filter: (hjtest_1.a <> hjtest_2.b)
-> Seq Scan on public.hjtest_1
Output: hjtest_1.a, hjtest_1.tableoid, hjtest_1.id, hjtest_1.b
- Filter: ((SubPlan 4) < 50)
- SubPlan 4
+ Filter: ((SubPlan expr_4) < 50)
+ SubPlan expr_4
-> Result
Output: (hjtest_1.b * 5)
-> Hash
Output: hjtest_2.a, hjtest_2.tableoid, hjtest_2.id, hjtest_2.c, hjtest_2.b
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/join_hash_pglz.out C:/cirrus/build/testrun/regress/regr...
--- C:/cirrus/src/test/regress/expected/join_hash_pglz.out 2025-10-31 12:25:45.819769100 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/join_hash_pglz.out 2025-10-31 12:30:20.068173800 +0000
@@ -1032,30 +1032,30 @@
------------------------------------------------------------------------------------------------
Hash Join
Output: hjtest_1.a, hjtest_2.a, (hjtest_1.tableoid)::regclass, (hjtest_2.tableoid)::regclass
- Hash Cond: ((hjtest_1.id = (SubPlan 1)) AND ((SubPlan 2) = (SubPlan 3)))
+ Hash Cond: ((hjtest_1.id = (SubPlan expr_1)) AND ((SubPlan expr_2) = (SubPlan expr_3)))
Join Filter: (hjtest_1.a <> hjtest_2.b)
-> Seq Scan on public.hjtest_1
Output: hjtest_1.a, hjtest_1.tableoid, hjtest_1.id, hjtest_1.b
- Filter: ((SubPlan 4) < 50)
- SubPlan 4
+ Filter: ((SubPlan expr_4) < 50)
+ SubPlan expr_4
-> Result
Output: (hjtest_1.b * 5)
-> Hash
Output: hjtest_2.a, hjtest_2.tableoid, hjtest_2.id, hjtest_2.c, hjtest_2.b
... |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/join_hash_pglz.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade...
--- /tmp/cirrus-ci-build/src/test/regress/expected/join_hash_pglz.out 2025-10-31 12:25:53.704331566 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/join_hash_pglz.out 2025-10-31 12:29:06.132...
@@ -1032,30 +1032,30 @@
------------------------------------------------------------------------------------------------
Hash Join
Output: hjtest_1.a, hjtest_2.a, (hjtest_1.tableoid)::regclass, (hjtest_2.tableoid)::regclass
- Hash Cond: ((hjtest_1.id = (SubPlan 1)) AND ((SubPlan 2) = (SubPlan 3)))
+ Hash Cond: ((hjtest_1.id = (SubPlan expr_1)) AND ((SubPlan expr_2) = (SubPlan expr_3)))
Join Filter: (hjtest_1.a <> hjtest_2.b)
-> Seq Scan on public.hjtest_1
Output: hjtest_1.a, hjtest_1.tableoid, hjtest_1.id, hjtest_1.b
- Filter: ((SubPlan 4) < 50)
- SubPlan 4
+ Filter: ((SubPlan expr_4) < 50)
+ SubPlan expr_4
-> Result
Output: (hjtest_1.b * 5)
-> Hash
Output: hjtest_2.a, hjtest_2.tableoid, hjtest_2.id, hjtest_2.c, hjtest_2.b
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/join_hash_pglz.out /tmp/cirrus-ci-build/build/testrun/recovery/0...
--- /tmp/cirrus-ci-build/src/test/regress/expected/join_hash_pglz.out 2025-10-31 12:25:53.704331566 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/join_hash_pglz.out 2025-10-31 12:30:28.9...
@@ -1032,30 +1032,30 @@
------------------------------------------------------------------------------------------------
Hash Join
Output: hjtest_1.a, hjtest_2.a, (hjtest_1.tableoid)::regclass, (hjtest_2.tableoid)::regclass
- Hash Cond: ((hjtest_1.id = (SubPlan 1)) AND ((SubPlan 2) = (SubPlan 3)))
+ Hash Cond: ((hjtest_1.id = (SubPlan expr_1)) AND ((SubPlan expr_2) = (SubPlan expr_3)))
Join Filter: (hjtest_1.a <> hjtest_2.b)
-> Seq Scan on public.hjtest_1
Output: hjtest_1.a, hjtest_1.tableoid, hjtest_1.id, hjtest_1.b
- Filter: ((SubPlan 4) < 50)
- SubPlan 4
+ Filter: ((SubPlan expr_4) < 50)
+ SubPlan expr_4
-> Result
Output: (hjtest_1.b * 5)
-> Hash
Output: hjtest_2.a, hjtest_2.tableoid, hjtest_2.id, hjtest_2.c, hjtest_2.b
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/join_hash_pglz.out /tmp/cirrus-ci-build/build/testrun/regress/re...
--- /tmp/cirrus-ci-build/src/test/regress/expected/join_hash_pglz.out 2025-10-31 12:25:53.704331566 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/join_hash_pglz.out 2025-10-31 12:29:05.904385443 +0000
@@ -1032,30 +1032,30 @@
------------------------------------------------------------------------------------------------
Hash Join
Output: hjtest_1.a, hjtest_2.a, (hjtest_1.tableoid)::regclass, (hjtest_2.tableoid)::regclass
- Hash Cond: ((hjtest_1.id = (SubPlan 1)) AND ((SubPlan 2) = (SubPlan 3)))
+ Hash Cond: ((hjtest_1.id = (SubPlan expr_1)) AND ((SubPlan expr_2) = (SubPlan expr_3)))
Join Filter: (hjtest_1.a <> hjtest_2.b)
-> Seq Scan on public.hjtest_1
Output: hjtest_1.a, hjtest_1.tableoid, hjtest_1.id, hjtest_1.b
- Filter: ((SubPlan 4) < 50)
- SubPlan 4
+ Filter: ((SubPlan expr_4) < 50)
+ SubPlan expr_4
-> Result
Output: (hjtest_1.b * 5)
-> Hash
Output: hjtest_2.a, hjtest_2.tableoid, hjtest_2.id, hjtest_2.c, hjtest_2.b
... |
|
Linux - Debian Bookworm - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/join_hash_pglz.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_c...
--- /tmp/cirrus-ci-build/src/test/regress/expected/join_hash_pglz.out 2025-10-31 12:25:40.988295406 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/join_hash_pglz.out 2025-10-31 12:33:46.668456037 +0000
@@ -1032,30 +1032,30 @@
------------------------------------------------------------------------------------------------
Hash Join
Output: hjtest_1.a, hjtest_2.a, (hjtest_1.tableoid)::regclass, (hjtest_2.tableoid)::regclass
- Hash Cond: ((hjtest_1.id = (SubPlan 1)) AND ((SubPlan 2) = (SubPlan 3)))
+ Hash Cond: ((hjtest_1.id = (SubPlan expr_1)) AND ((SubPlan expr_2) = (SubPlan expr_3)))
Join Filter: (hjtest_1.a <> hjtest_2.b)
-> Seq Scan on public.hjtest_1
Output: hjtest_1.a, hjtest_1.tableoid, hjtest_1.id, hjtest_1.b
- Filter: ((SubPlan 4) < 50)
- SubPlan 4
+ Filter: ((SubPlan expr_4) < 50)
+ SubPlan expr_4
-> Result
Output: (hjtest_1.b * 5)
-> Hash
Output: hjtest_2.a, hjtest_2.tableoid, hjtest_2.id, hjtest_2.c, hjtest_2.b
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/join_hash_pglz.out /tmp/cirrus-ci-build/src/test/recovery/tmp_ch...
--- /tmp/cirrus-ci-build/src/test/regress/expected/join_hash_pglz.out 2025-10-31 12:25:40.988295406 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/join_hash_pglz.out 2025-10-31 12:34:34.176455299 +0000
@@ -1032,30 +1032,30 @@
------------------------------------------------------------------------------------------------
Hash Join
Output: hjtest_1.a, hjtest_2.a, (hjtest_1.tableoid)::regclass, (hjtest_2.tableoid)::regclass
- Hash Cond: ((hjtest_1.id = (SubPlan 1)) AND ((SubPlan 2) = (SubPlan 3)))
+ Hash Cond: ((hjtest_1.id = (SubPlan expr_1)) AND ((SubPlan expr_2) = (SubPlan expr_3)))
Join Filter: (hjtest_1.a <> hjtest_2.b)
-> Seq Scan on public.hjtest_1
Output: hjtest_1.a, hjtest_1.tableoid, hjtest_1.id, hjtest_1.b
- Filter: ((SubPlan 4) < 50)
- SubPlan 4
+ Filter: ((SubPlan expr_4) < 50)
+ SubPlan expr_4
-> Result
Output: (hjtest_1.b * 5)
-> Hash
Output: hjtest_2.a, hjtest_2.tableoid, hjtest_2.id, hjtest_2.c, hjtest_2.b
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/join_hash_pglz.out /tmp/cirrus-ci-build/src/test/regress/results...
--- /tmp/cirrus-ci-build/src/test/regress/expected/join_hash_pglz.out 2025-10-31 12:25:40.988295406 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/join_hash_pglz.out 2025-10-31 12:30:10.648494959 +0000
@@ -1032,30 +1032,30 @@
------------------------------------------------------------------------------------------------
Hash Join
Output: hjtest_1.a, hjtest_2.a, (hjtest_1.tableoid)::regclass, (hjtest_2.tableoid)::regclass
- Hash Cond: ((hjtest_1.id = (SubPlan 1)) AND ((SubPlan 2) = (SubPlan 3)))
+ Hash Cond: ((hjtest_1.id = (SubPlan expr_1)) AND ((SubPlan expr_2) = (SubPlan expr_3)))
Join Filter: (hjtest_1.a <> hjtest_2.b)
-> Seq Scan on public.hjtest_1
Output: hjtest_1.a, hjtest_1.tableoid, hjtest_1.id, hjtest_1.b
- Filter: ((SubPlan 4) < 50)
- SubPlan 4
+ Filter: ((SubPlan expr_4) < 50)
+ SubPlan expr_4
-> Result
Output: (hjtest_1.b * 5)
-> Hash
Output: hjtest_2.a, hjtest_2.tableoid, hjtest_2.id, hjtest_2.c, hjtest_2.b
... |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/join_hash_pglz.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade...
--- /tmp/cirrus-ci-build/src/test/regress/expected/join_hash_pglz.out 2025-10-31 12:25:48.397205000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/join_hash_pglz.out 2025-10-31 12:30:13.536...
@@ -1032,30 +1032,30 @@
------------------------------------------------------------------------------------------------
Hash Join
Output: hjtest_1.a, hjtest_2.a, (hjtest_1.tableoid)::regclass, (hjtest_2.tableoid)::regclass
- Hash Cond: ((hjtest_1.id = (SubPlan 1)) AND ((SubPlan 2) = (SubPlan 3)))
+ Hash Cond: ((hjtest_1.id = (SubPlan expr_1)) AND ((SubPlan expr_2) = (SubPlan expr_3)))
Join Filter: (hjtest_1.a <> hjtest_2.b)
-> Seq Scan on public.hjtest_1
Output: hjtest_1.a, hjtest_1.tableoid, hjtest_1.id, hjtest_1.b
- Filter: ((SubPlan 4) < 50)
- SubPlan 4
+ Filter: ((SubPlan expr_4) < 50)
+ SubPlan expr_4
-> Result
Output: (hjtest_1.b * 5)
-> Hash
Output: hjtest_2.a, hjtest_2.tableoid, hjtest_2.id, hjtest_2.c, hjtest_2.b
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/join_hash_pglz.out /tmp/cirrus-ci-build/build/testrun/recovery/0...
--- /tmp/cirrus-ci-build/src/test/regress/expected/join_hash_pglz.out 2025-10-31 12:25:48.397205000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/join_hash_pglz.out 2025-10-31 12:31:04.7...
@@ -1032,30 +1032,30 @@
------------------------------------------------------------------------------------------------
Hash Join
Output: hjtest_1.a, hjtest_2.a, (hjtest_1.tableoid)::regclass, (hjtest_2.tableoid)::regclass
- Hash Cond: ((hjtest_1.id = (SubPlan 1)) AND ((SubPlan 2) = (SubPlan 3)))
+ Hash Cond: ((hjtest_1.id = (SubPlan expr_1)) AND ((SubPlan expr_2) = (SubPlan expr_3)))
Join Filter: (hjtest_1.a <> hjtest_2.b)
-> Seq Scan on public.hjtest_1
Output: hjtest_1.a, hjtest_1.tableoid, hjtest_1.id, hjtest_1.b
- Filter: ((SubPlan 4) < 50)
- SubPlan 4
+ Filter: ((SubPlan expr_4) < 50)
+ SubPlan expr_4
-> Result
Output: (hjtest_1.b * 5)
-> Hash
Output: hjtest_2.a, hjtest_2.tableoid, hjtest_2.id, hjtest_2.c, hjtest_2.b
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/join_hash_pglz.out /tmp/cirrus-ci-build/build/testrun/regress/re...
--- /tmp/cirrus-ci-build/src/test/regress/expected/join_hash_pglz.out 2025-10-31 12:25:48.397205000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/join_hash_pglz.out 2025-10-31 12:30:03.193552000 +0000
@@ -1032,30 +1032,30 @@
------------------------------------------------------------------------------------------------
Hash Join
Output: hjtest_1.a, hjtest_2.a, (hjtest_1.tableoid)::regclass, (hjtest_2.tableoid)::regclass
- Hash Cond: ((hjtest_1.id = (SubPlan 1)) AND ((SubPlan 2) = (SubPlan 3)))
+ Hash Cond: ((hjtest_1.id = (SubPlan expr_1)) AND ((SubPlan expr_2) = (SubPlan expr_3)))
Join Filter: (hjtest_1.a <> hjtest_2.b)
-> Seq Scan on public.hjtest_1
Output: hjtest_1.a, hjtest_1.tableoid, hjtest_1.id, hjtest_1.b
- Filter: ((SubPlan 4) < 50)
- SubPlan 4
+ Filter: ((SubPlan expr_4) < 50)
+ SubPlan expr_4
-> Result
Output: (hjtest_1.b * 5)
-> Hash
Output: hjtest_2.a, hjtest_2.tableoid, hjtest_2.id, hjtest_2.c, hjtest_2.b
... |
|
OpenBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/join_hash_pglz.out /home/postgres/postgres/build/testrun/pg_u...
--- /home/postgres/postgres/src/test/regress/expected/join_hash_pglz.out Fri Oct 31 12:26:00 2025
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/join_hash_pglz.out Fri Oct 31 12:29:16 ...
@@ -1032,30 +1032,30 @@
------------------------------------------------------------------------------------------------
Hash Join
Output: hjtest_1.a, hjtest_2.a, (hjtest_1.tableoid)::regclass, (hjtest_2.tableoid)::regclass
- Hash Cond: ((hjtest_1.id = (SubPlan 1)) AND ((SubPlan 2) = (SubPlan 3)))
+ Hash Cond: ((hjtest_1.id = (SubPlan expr_1)) AND ((SubPlan expr_2) = (SubPlan expr_3)))
Join Filter: (hjtest_1.a <> hjtest_2.b)
-> Seq Scan on public.hjtest_1
Output: hjtest_1.a, hjtest_1.tableoid, hjtest_1.id, hjtest_1.b
- Filter: ((SubPlan 4) < 50)
- SubPlan 4
+ Filter: ((SubPlan expr_4) < 50)
+ SubPlan expr_4
-> Result
Output: (hjtest_1.b * 5)
-> Hash
Output: hjtest_2.a, hjtest_2.tableoid, hjtest_2.id, hjtest_2.c, hjtest_2.b
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/join_hash_pglz.out /home/postgres/postgres/build/testrun/reco...
--- /home/postgres/postgres/src/test/regress/expected/join_hash_pglz.out Fri Oct 31 12:26:00 2025
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/join_hash_pglz.out Fri Oct 31 12:31:1...
@@ -1032,30 +1032,30 @@
------------------------------------------------------------------------------------------------
Hash Join
Output: hjtest_1.a, hjtest_2.a, (hjtest_1.tableoid)::regclass, (hjtest_2.tableoid)::regclass
- Hash Cond: ((hjtest_1.id = (SubPlan 1)) AND ((SubPlan 2) = (SubPlan 3)))
+ Hash Cond: ((hjtest_1.id = (SubPlan expr_1)) AND ((SubPlan expr_2) = (SubPlan expr_3)))
Join Filter: (hjtest_1.a <> hjtest_2.b)
-> Seq Scan on public.hjtest_1
Output: hjtest_1.a, hjtest_1.tableoid, hjtest_1.id, hjtest_1.b
- Filter: ((SubPlan 4) < 50)
- SubPlan 4
+ Filter: ((SubPlan expr_4) < 50)
+ SubPlan expr_4
-> Result
Output: (hjtest_1.b * 5)
-> Hash
Output: hjtest_2.a, hjtest_2.tableoid, hjtest_2.id, hjtest_2.c, hjtest_2.b
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/join_hash_pglz.out /home/postgres/postgres/build/testrun/regr...
--- /home/postgres/postgres/src/test/regress/expected/join_hash_pglz.out Fri Oct 31 12:26:00 2025
+++ /home/postgres/postgres/build/testrun/regress/regress/results/join_hash_pglz.out Fri Oct 31 12:29:09 2025
@@ -1032,30 +1032,30 @@
------------------------------------------------------------------------------------------------
Hash Join
Output: hjtest_1.a, hjtest_2.a, (hjtest_1.tableoid)::regclass, (hjtest_2.tableoid)::regclass
- Hash Cond: ((hjtest_1.id = (SubPlan 1)) AND ((SubPlan 2) = (SubPlan 3)))
+ Hash Cond: ((hjtest_1.id = (SubPlan expr_1)) AND ((SubPlan expr_2) = (SubPlan expr_3)))
Join Filter: (hjtest_1.a <> hjtest_2.b)
-> Seq Scan on public.hjtest_1
Output: hjtest_1.a, hjtest_1.tableoid, hjtest_1.id, hjtest_1.b
- Filter: ((SubPlan 4) < 50)
- SubPlan 4
+ Filter: ((SubPlan expr_4) < 50)
+ SubPlan expr_4
-> Result
Output: (hjtest_1.b * 5)
-> Hash
Output: hjtest_2.a, hjtest_2.tableoid, hjtest_2.id, hjtest_2.c, hjtest_2.b
... |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/join_hash_pglz.out /home/postgres/postgres/build/testrun/pg_u...
--- /home/postgres/postgres/src/test/regress/expected/join_hash_pglz.out 2025-10-31 12:26:02.472388934 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/join_hash_pglz.out 2025-10-31 12:28:35....
@@ -1032,30 +1032,30 @@
------------------------------------------------------------------------------------------------
Hash Join
Output: hjtest_1.a, hjtest_2.a, (hjtest_1.tableoid)::regclass, (hjtest_2.tableoid)::regclass
- Hash Cond: ((hjtest_1.id = (SubPlan 1)) AND ((SubPlan 2) = (SubPlan 3)))
+ Hash Cond: ((hjtest_1.id = (SubPlan expr_1)) AND ((SubPlan expr_2) = (SubPlan expr_3)))
Join Filter: (hjtest_1.a <> hjtest_2.b)
-> Seq Scan on public.hjtest_1
Output: hjtest_1.a, hjtest_1.tableoid, hjtest_1.id, hjtest_1.b
- Filter: ((SubPlan 4) < 50)
- SubPlan 4
+ Filter: ((SubPlan expr_4) < 50)
+ SubPlan expr_4
-> Result
Output: (hjtest_1.b * 5)
-> Hash
Output: hjtest_2.a, hjtest_2.tableoid, hjtest_2.id, hjtest_2.c, hjtest_2.b
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/join_hash_pglz.out /home/postgres/postgres/build/testrun/reco...
--- /home/postgres/postgres/src/test/regress/expected/join_hash_pglz.out 2025-10-31 12:26:02.472388934 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/join_hash_pglz.out 2025-10-31 12:29:1...
@@ -1032,30 +1032,30 @@
------------------------------------------------------------------------------------------------
Hash Join
Output: hjtest_1.a, hjtest_2.a, (hjtest_1.tableoid)::regclass, (hjtest_2.tableoid)::regclass
- Hash Cond: ((hjtest_1.id = (SubPlan 1)) AND ((SubPlan 2) = (SubPlan 3)))
+ Hash Cond: ((hjtest_1.id = (SubPlan expr_1)) AND ((SubPlan expr_2) = (SubPlan expr_3)))
Join Filter: (hjtest_1.a <> hjtest_2.b)
-> Seq Scan on public.hjtest_1
Output: hjtest_1.a, hjtest_1.tableoid, hjtest_1.id, hjtest_1.b
- Filter: ((SubPlan 4) < 50)
- SubPlan 4
+ Filter: ((SubPlan expr_4) < 50)
+ SubPlan expr_4
-> Result
Output: (hjtest_1.b * 5)
-> Hash
Output: hjtest_2.a, hjtest_2.tableoid, hjtest_2.id, hjtest_2.c, hjtest_2.b
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/join_hash_pglz.out /home/postgres/postgres/build/testrun/regr...
--- /home/postgres/postgres/src/test/regress/expected/join_hash_pglz.out 2025-10-31 12:26:02.472388934 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/join_hash_pglz.out 2025-10-31 12:28:29.564890649 +0000
@@ -1032,30 +1032,30 @@
------------------------------------------------------------------------------------------------
Hash Join
Output: hjtest_1.a, hjtest_2.a, (hjtest_1.tableoid)::regclass, (hjtest_2.tableoid)::regclass
- Hash Cond: ((hjtest_1.id = (SubPlan 1)) AND ((SubPlan 2) = (SubPlan 3)))
+ Hash Cond: ((hjtest_1.id = (SubPlan expr_1)) AND ((SubPlan expr_2) = (SubPlan expr_3)))
Join Filter: (hjtest_1.a <> hjtest_2.b)
-> Seq Scan on public.hjtest_1
Output: hjtest_1.a, hjtest_1.tableoid, hjtest_1.id, hjtest_1.b
- Filter: ((SubPlan 4) < 50)
- SubPlan 4
+ Filter: ((SubPlan expr_4) < 50)
+ SubPlan expr_4
-> Result
Output: (hjtest_1.b * 5)
-> Hash
Output: hjtest_2.a, hjtest_2.tableoid, hjtest_2.id, hjtest_2.c, hjtest_2.b
... |
| 56/5992 |
Fix ALTER TABLE DROP EXPRESSION with ONLY option |
|
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-10-30 11:36:31.073465000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_stored.out 2025-10-30 11:38:35.5...
@@ -1290,6 +1290,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-10-30 11:36:31.074016000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out 2025-10-30 11:38:54....
@@ -1260,6 +1260,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-10-30 11:36:31.073465000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/generated_stored.out 2025-10-30 11:39:39...
@@ -1290,6 +1290,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-10-30 11:36:31.074016000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out 2025-10-30 11:40:1...
@@ -1260,6 +1260,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-10-30 11:36:31.073465000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/generated_stored.out 2025-10-30 11:38:33.708612000 +0000
@@ -1290,6 +1290,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-10-30 11:36:31.074016000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/generated_virtual.out 2025-10-30 11:38:54.468590000 +0000
@@ -1260,6 +1260,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 Bookworm - 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-10-30 11:36:33.083180431 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/generated_stored.out 2025-10-30 11:43:20.157377091 +0000
@@ -1290,6 +1290,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-10-30 11:36:33.083180431 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/generated_virtual.out 2025-10-30 11:43:46.560561180 +0000
@@ -1260,6 +1260,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-10-30 11:36:33.083180431 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/generated_stored.out 2025-10-30 11:46:09.165628684 +0000
@@ -1290,6 +1290,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-10-30 11:36:33.083180431 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/generated_virtual.out 2025-10-30 11:46:21.081647572 +0000
@@ -1260,6 +1260,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-10-30 11:36:33.083180431 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/generated_stored.out 2025-10-30 11:41:02.144042833 +0000
@@ -1290,6 +1290,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-10-30 11:36:33.083180431 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/generated_virtual.out 2025-10-30 11:41:28.775929541 +0000
@@ -1260,6 +1260,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 Bookworm - 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-10-30 11:36:34.525701272 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_stored.out 2025-10-30 11:41:05.7...
@@ -1290,6 +1290,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-10-30 11:36:34.525701272 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out 2025-10-30 11:41:16....
@@ -1260,6 +1260,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-10-30 11:36:34.525701272 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/generated_stored.out 2025-10-30 11:42:21...
@@ -1290,6 +1290,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-10-30 11:36:34.525701272 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out 2025-10-30 11:42:3...
@@ -1260,6 +1260,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-10-30 11:36:34.525701272 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/generated_stored.out 2025-10-30 11:41:04.989024993 +0000
@@ -1290,6 +1290,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-10-30 11:36:34.525701272 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/generated_virtual.out 2025-10-30 11:41:15.145000750 +0000
@@ -1260,6 +1260,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 - Sonoma - 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-10-30 11:36:12
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_stored.out 2025-10-30 11:37:56
@@ -1290,6 +1290,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-10-30 11:36:12
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out 2025-10-30 11:38:00
@@ -1260,6 +1260,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-10-30 11:36:12
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/generated_stored.out 2025-10-30 11:38:41
@@ -1290,6 +1290,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-10-30 11:36:12
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out 2025-10-30 11:38:45
@@ -1260,6 +1260,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-10-30 11:36:12
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/generated_stored.out 2025-10-30 11:37:57
@@ -1290,6 +1290,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-10-30 11:36:12
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/generated_virtual.out 2025-10-30 11:38:00
@@ -1260,6 +1260,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-10-30 11:36:48.021036050 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_stored.out 2025-10-30 11:38:0...
@@ -1290,6 +1290,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-10-30 11:36:48.022217928 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out 2025-10-30 11:38:...
@@ -1260,6 +1260,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-10-30 11:36:48.021036050 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/generated_stored.out 2025-10-30 11:38...
@@ -1290,6 +1290,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-10-30 11:36:48.022217928 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out 2025-10-30 11:3...
@@ -1260,6 +1260,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-10-30 11:36:48.021036050 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/generated_stored.out 2025-10-30 11:38:04.913401224 +00...
@@ -1290,6 +1290,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-10-30 11:36:48.022217928 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/generated_virtual.out 2025-10-30 11:38:15.929353728 +0...
@@ -1260,6 +1260,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 Oct 30 11:36:58 2025
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_stored.out Thu Oct 30 11:39:3...
@@ -1290,6 +1290,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 Oct 30 11:36:58 2025
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out Thu Oct 30 11:39:...
@@ -1260,6 +1260,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 Oct 30 11:36:58 2025
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/generated_stored.out Thu Oct 30 11:41...
@@ -1290,6 +1290,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 Oct 30 11:36:58 2025
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out Thu Oct 30 11:4...
@@ -1260,6 +1260,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 Oct 30 11:36:58 2025
+++ /home/postgres/postgres/build/testrun/regress/regress/results/generated_stored.out Thu Oct 30 11:39:24 2025
@@ -1290,6 +1290,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 Oct 30 11:36:58 2025
+++ /home/postgres/postgres/build/testrun/regress/regress/results/generated_virtual.out Thu Oct 30 11:39:37 2025
@@ -1260,6 +1260,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 2019, 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-10-30 11:36:36.322255300 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_stored.out 2025-10-30 11:41:42.998056500 +0...
@@ -1290,6 +1290,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-10-30 11:36:36.324142300 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out 2025-10-30 11:41:50.541030800 +...
@@ -1260,6 +1260,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-10-30 11:36:36.322255300 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/generated_stored.out 2025-10-30 11:44:29.837889900 ...
@@ -1290,6 +1290,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-10-30 11:36:36.324142300 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out 2025-10-30 11:44:38.127929500...
@@ -1260,6 +1260,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-10-30 11:36:36.322255300 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/generated_stored.out 2025-10-30 11:41:37.413583100 +0000
@@ -1290,6 +1290,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-10-30 11:36:36.324142300 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/generated_virtual.out 2025-10-30 11:41:46.971689500 +0000
@@ -1260,6 +1260,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 2019, 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-10-30 11:36:48.785043500 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_stored.out 2025-10-30 11:39:50.612127900 +0...
@@ -1290,6 +1290,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-10-30 11:36:48.786006600 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out 2025-10-30 11:40:04.158512300 +...
@@ -1260,6 +1260,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-10-30 11:36:48.785043500 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/generated_stored.out 2025-10-30 11:42:25.639880700 ...
@@ -1290,6 +1290,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-10-30 11:36:48.786006600 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out 2025-10-30 11:42:42.724353900...
@@ -1260,6 +1260,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-10-30 11:36:48.785043500 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/generated_stored.out 2025-10-30 11:39:43.838200600 +0000
@@ -1290,6 +1290,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-10-30 11:36:48.786006600 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/generated_virtual.out 2025-10-30 11:40:00.250795300 +0000
@@ -1260,6 +1260,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
| 56/6128 |
GIN pageinspect support for entry tree and non-leaf posting tree |
|
Windows - Server 2019, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/modules/brin/expected/summarization-and-inprogress-insertion.out C:/cirr...
--- C:/cirrus/src/test/modules/brin/expected/summarization-and-inprogress-insertion.out 2025-10-29 12:21:19.280608600 +0...
+++ C:/cirrus/build/testrun/brin/isolation/results/summarization-and-inprogress-insertion.out 2025-10-29 12:29:21.312651...
@@ -1,51 +1,4 @@
Parsed test spec with 2 sessions
starting permutation: s2check s1b s2b s1i s2summ s1c s2c s2check
-step s2check: SELECT * FROM brin_page_items(get_raw_page('brinidx', 2), 'brinidx'::regclass);
-itemoffset|blknum|attnum|allnulls|hasnulls|placeholder|empty|value
-----------+------+------+--------+--------+-----------+-----+--------
- 1| 0| 1|f |t |f |f |{1 .. 1}
-(1 row)
-
-step s1b: BEGIN ISOLATION LEVEL REPEATABLE READ;
-step s2b: BEGIN ISOLATION LEVEL REPEATABLE READ; SELECT 1;
-?column?
---------
- 1
-(1 row)
-
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/pageinspect/expected/page.out C:/cirrus/build/testrun/pageinspect/regress...
--- C:/cirrus/contrib/pageinspect/expected/page.out 2025-10-29 12:21:15.342135900 +0000
+++ C:/cirrus/build/testrun/pageinspect/regress/results/page.out 2025-10-29 12:28:58.519934000 +0000
@@ -1,4 +1,5 @@
CREATE EXTENSION pageinspect;
+ERROR: extension "pageinspect" has no installation script nor update path for version "1.14"
-- Use a temp table so that effects of VACUUM are predictable
CREATE TEMP TABLE test1 (a int, b int);
INSERT INTO test1 VALUES (16777217, 131584);
@@ -6,207 +7,177 @@
-- The page contents can vary, so just test that it can be read
-- successfully, but don't keep the output.
SELECT octet_length(get_raw_page('test1', 'main', 0)) AS main_0;
- main_0
---------
- 8192
-(1 row)
-
+ERROR: function get_raw_page(unknown, unknown, integer) does not exist
+LINE 1: SELECT octet_length(get_raw_page('test1', 'main', 0)) AS mai...
... |
|
Windows - Server 2019, MinGW64 - Meson |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/modules/brin/expected/summarization-and-inprogress-insertion.out C:/cirr...
--- C:/cirrus/src/test/modules/brin/expected/summarization-and-inprogress-insertion.out 2025-10-29 12:21:05.893912500 +0...
+++ C:/cirrus/build/testrun/brin/isolation/results/summarization-and-inprogress-insertion.out 2025-10-29 12:32:34.536571...
@@ -1,51 +1,4 @@
Parsed test spec with 2 sessions
starting permutation: s2check s1b s2b s1i s2summ s1c s2c s2check
-step s2check: SELECT * FROM brin_page_items(get_raw_page('brinidx', 2), 'brinidx'::regclass);
-itemoffset|blknum|attnum|allnulls|hasnulls|placeholder|empty|value
-----------+------+------+--------+--------+-----------+-----+--------
- 1| 0| 1|f |t |f |f |{1 .. 1}
-(1 row)
-
-step s1b: BEGIN ISOLATION LEVEL REPEATABLE READ;
-step s2b: BEGIN ISOLATION LEVEL REPEATABLE READ; SELECT 1;
-?column?
---------
- 1
-(1 row)
-
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/pageinspect/expected/page.out C:/cirrus/build/testrun/pageinspect/regress...
--- C:/cirrus/contrib/pageinspect/expected/page.out 2025-10-29 12:21:01.904168500 +0000
+++ C:/cirrus/build/testrun/pageinspect/regress/results/page.out 2025-10-29 12:32:11.045842700 +0000
@@ -1,4 +1,5 @@
CREATE EXTENSION pageinspect;
+ERROR: extension "pageinspect" has no installation script nor update path for version "1.14"
-- Use a temp table so that effects of VACUUM are predictable
CREATE TEMP TABLE test1 (a int, b int);
INSERT INTO test1 VALUES (16777217, 131584);
@@ -6,207 +7,177 @@
-- The page contents can vary, so just test that it can be read
-- successfully, but don't keep the output.
SELECT octet_length(get_raw_page('test1', 'main', 0)) AS main_0;
- main_0
---------
- 8192
-(1 row)
-
+ERROR: function get_raw_page(unknown, unknown, integer) does not exist
+LINE 1: SELECT octet_length(get_raw_page('test1', 'main', 0)) AS mai...
... |
|
macOS - Sonoma - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/modules/brin/expected/summarization-and-inprogress-insertion.out /Users/admin/pgsql...
--- /Users/admin/pgsql/src/test/modules/brin/expected/summarization-and-inprogress-insertion.out 2025-10-29 12:20:11
+++ /Users/admin/pgsql/build/testrun/brin/isolation/results/summarization-and-inprogress-insertion.out 2025-10-29 12:23:...
@@ -1,51 +1,4 @@
Parsed test spec with 2 sessions
starting permutation: s2check s1b s2b s1i s2summ s1c s2c s2check
-step s2check: SELECT * FROM brin_page_items(get_raw_page('brinidx', 2), 'brinidx'::regclass);
-itemoffset|blknum|attnum|allnulls|hasnulls|placeholder|empty|value
-----------+------+------+--------+--------+-----------+-----+--------
- 1| 0| 1|f |t |f |f |{1 .. 1}
-(1 row)
-
-step s1b: BEGIN ISOLATION LEVEL REPEATABLE READ;
-step s2b: BEGIN ISOLATION LEVEL REPEATABLE READ; SELECT 1;
-?column?
---------
- 1
-(1 row)
-
... |
| regress |
diff -U3 /Users/admin/pgsql/contrib/pageinspect/expected/page.out /Users/admin/pgsql/build/testrun/pageinspect/regress/r...
--- /Users/admin/pgsql/contrib/pageinspect/expected/page.out 2025-10-29 12:20:09
+++ /Users/admin/pgsql/build/testrun/pageinspect/regress/results/page.out 2025-10-29 12:23:20
@@ -1,4 +1,5 @@
CREATE EXTENSION pageinspect;
+ERROR: extension "pageinspect" has no installation script nor update path for version "1.14"
-- Use a temp table so that effects of VACUUM are predictable
CREATE TEMP TABLE test1 (a int, b int);
INSERT INTO test1 VALUES (16777217, 131584);
@@ -6,207 +7,177 @@
-- The page contents can vary, so just test that it can be read
-- successfully, but don't keep the output.
SELECT octet_length(get_raw_page('test1', 'main', 0)) AS main_0;
- main_0
---------
- 8192
-(1 row)
-
+ERROR: function get_raw_page(unknown, unknown, integer) does not exist
+LINE 1: SELECT octet_length(get_raw_page('test1', 'main', 0)) AS mai...
... |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/modules/brin/expected/summarization-and-inprogress-insertion.out /tmp/cirrus-ci-b...
--- /tmp/cirrus-ci-build/src/test/modules/brin/expected/summarization-and-inprogress-insertion.out 2025-10-29 12:21:12.3...
+++ /tmp/cirrus-ci-build/build/testrun/brin/isolation/results/summarization-and-inprogress-insertion.out 2025-10-29 12:2...
@@ -1,51 +1,4 @@
Parsed test spec with 2 sessions
starting permutation: s2check s1b s2b s1i s2summ s1c s2c s2check
-step s2check: SELECT * FROM brin_page_items(get_raw_page('brinidx', 2), 'brinidx'::regclass);
-itemoffset|blknum|attnum|allnulls|hasnulls|placeholder|empty|value
-----------+------+------+--------+--------+-----------+-----+--------
- 1| 0| 1|f |t |f |f |{1 .. 1}
-(1 row)
-
-step s1b: BEGIN ISOLATION LEVEL REPEATABLE READ;
-step s2b: BEGIN ISOLATION LEVEL REPEATABLE READ; SELECT 1;
-?column?
---------
- 1
-(1 row)
-
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/pageinspect/expected/page.out /tmp/cirrus-ci-build/build/testrun/pageinspect/regre...
--- /tmp/cirrus-ci-build/contrib/pageinspect/expected/page.out 2025-10-29 12:21:10.528456479 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pageinspect/regress/results/page.out 2025-10-29 12:28:10.424424722 +0000
@@ -1,4 +1,5 @@
CREATE EXTENSION pageinspect;
+ERROR: extension "pageinspect" has no installation script nor update path for version "1.14"
-- Use a temp table so that effects of VACUUM are predictable
CREATE TEMP TABLE test1 (a int, b int);
INSERT INTO test1 VALUES (16777217, 131584);
@@ -6,207 +7,177 @@
-- The page contents can vary, so just test that it can be read
-- successfully, but don't keep the output.
SELECT octet_length(get_raw_page('test1', 'main', 0)) AS main_0;
- main_0
---------
- 8192
-(1 row)
-
+ERROR: function get_raw_page(unknown, unknown, integer) does not exist
+LINE 1: SELECT octet_length(get_raw_page('test1', 'main', 0)) AS mai...
... |
|
OpenBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/modules/brin/expected/summarization-and-inprogress-insertion.out /home/postgre...
--- /home/postgres/postgres/src/test/modules/brin/expected/summarization-and-inprogress-insertion.out Wed Oct 29 12:21:3...
+++ /home/postgres/postgres/build/testrun/brin/isolation/results/summarization-and-inprogress-insertion.out Wed Oct 29 1...
@@ -1,51 +1,4 @@
Parsed test spec with 2 sessions
starting permutation: s2check s1b s2b s1i s2summ s1c s2c s2check
-step s2check: SELECT * FROM brin_page_items(get_raw_page('brinidx', 2), 'brinidx'::regclass);
-itemoffset|blknum|attnum|allnulls|hasnulls|placeholder|empty|value
-----------+------+------+--------+--------+-----------+-----+--------
- 1| 0| 1|f |t |f |f |{1 .. 1}
-(1 row)
-
-step s1b: BEGIN ISOLATION LEVEL REPEATABLE READ;
-step s2b: BEGIN ISOLATION LEVEL REPEATABLE READ; SELECT 1;
-?column?
---------
- 1
-(1 row)
-
... |
| regress |
diff -U3 /home/postgres/postgres/contrib/pageinspect/expected/page.out /home/postgres/postgres/build/testrun/pageinspect...
--- /home/postgres/postgres/contrib/pageinspect/expected/page.out Wed Oct 29 12:21:23 2025
+++ /home/postgres/postgres/build/testrun/pageinspect/regress/results/page.out Wed Oct 29 12:26:33 2025
@@ -1,4 +1,5 @@
CREATE EXTENSION pageinspect;
+ERROR: extension "pageinspect" has no installation script nor update path for version "1.14"
-- Use a temp table so that effects of VACUUM are predictable
CREATE TEMP TABLE test1 (a int, b int);
INSERT INTO test1 VALUES (16777217, 131584);
@@ -6,207 +7,177 @@
-- The page contents can vary, so just test that it can be read
-- successfully, but don't keep the output.
SELECT octet_length(get_raw_page('test1', 'main', 0)) AS main_0;
- main_0
---------
- 8192
-(1 row)
-
+ERROR: function get_raw_page(unknown, unknown, integer) does not exist
+LINE 1: SELECT octet_length(get_raw_page('test1', 'main', 0)) AS mai...
... |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/modules/brin/expected/summarization-and-inprogress-insertion.out /home/postgre...
--- /home/postgres/postgres/src/test/modules/brin/expected/summarization-and-inprogress-insertion.out 2025-10-29 12:21:1...
+++ /home/postgres/postgres/build/testrun/brin/isolation/results/summarization-and-inprogress-insertion.out 2025-10-29 1...
@@ -1,51 +1,4 @@
Parsed test spec with 2 sessions
starting permutation: s2check s1b s2b s1i s2summ s1c s2c s2check
-step s2check: SELECT * FROM brin_page_items(get_raw_page('brinidx', 2), 'brinidx'::regclass);
-itemoffset|blknum|attnum|allnulls|hasnulls|placeholder|empty|value
-----------+------+------+--------+--------+-----------+-----+--------
- 1| 0| 1|f |t |f |f |{1 .. 1}
-(1 row)
-
-step s1b: BEGIN ISOLATION LEVEL REPEATABLE READ;
-step s2b: BEGIN ISOLATION LEVEL REPEATABLE READ; SELECT 1;
-?column?
---------
- 1
-(1 row)
-
... |
| regress |
diff -U3 /home/postgres/postgres/contrib/pageinspect/expected/page.out /home/postgres/postgres/build/testrun/pageinspect...
--- /home/postgres/postgres/contrib/pageinspect/expected/page.out 2025-10-29 12:21:09.077935001 +0000
+++ /home/postgres/postgres/build/testrun/pageinspect/regress/results/page.out 2025-10-29 12:24:25.097233923 +0000
@@ -1,4 +1,5 @@
CREATE EXTENSION pageinspect;
+ERROR: extension "pageinspect" has no installation script nor update path for version "1.14"
-- Use a temp table so that effects of VACUUM are predictable
CREATE TEMP TABLE test1 (a int, b int);
INSERT INTO test1 VALUES (16777217, 131584);
@@ -6,207 +7,177 @@
-- The page contents can vary, so just test that it can be read
-- successfully, but don't keep the output.
SELECT octet_length(get_raw_page('test1', 'main', 0)) AS main_0;
- main_0
---------
- 8192
-(1 row)
-
+ERROR: function get_raw_page(unknown, unknown, integer) does not exist
+LINE 1: SELECT octet_length(get_raw_page('test1', 'main', 0)) AS mai...
... |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/modules/brin/expected/summarization-and-inprogress-insertion.out /tmp/cirrus-ci-b...
--- /tmp/cirrus-ci-build/src/test/modules/brin/expected/summarization-and-inprogress-insertion.out 2025-10-29 12:21:02.7...
+++ /tmp/cirrus-ci-build/build/testrun/brin/isolation/results/summarization-and-inprogress-insertion.out 2025-10-29 12:2...
@@ -1,51 +1,4 @@
Parsed test spec with 2 sessions
starting permutation: s2check s1b s2b s1i s2summ s1c s2c s2check
-step s2check: SELECT * FROM brin_page_items(get_raw_page('brinidx', 2), 'brinidx'::regclass);
-itemoffset|blknum|attnum|allnulls|hasnulls|placeholder|empty|value
-----------+------+------+--------+--------+-----------+-----+--------
- 1| 0| 1|f |t |f |f |{1 .. 1}
-(1 row)
-
-step s1b: BEGIN ISOLATION LEVEL REPEATABLE READ;
-step s2b: BEGIN ISOLATION LEVEL REPEATABLE READ; SELECT 1;
-?column?
---------
- 1
-(1 row)
-
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/pageinspect/expected/page.out /tmp/cirrus-ci-build/build/testrun/pageinspect/regre...
--- /tmp/cirrus-ci-build/contrib/pageinspect/expected/page.out 2025-10-29 12:21:01.330757000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pageinspect/regress/results/page.out 2025-10-29 12:24:28.565783000 +0000
@@ -1,4 +1,5 @@
CREATE EXTENSION pageinspect;
+ERROR: extension "pageinspect" has no installation script nor update path for version "1.14"
-- Use a temp table so that effects of VACUUM are predictable
CREATE TEMP TABLE test1 (a int, b int);
INSERT INTO test1 VALUES (16777217, 131584);
@@ -6,207 +7,177 @@
-- The page contents can vary, so just test that it can be read
-- successfully, but don't keep the output.
SELECT octet_length(get_raw_page('test1', 'main', 0)) AS main_0;
- main_0
---------
- 8192
-(1 row)
-
+ERROR: function get_raw_page(unknown, unknown, integer) does not exist
+LINE 1: SELECT octet_length(get_raw_page('test1', 'main', 0)) AS mai...
... |
| 56/5553 |
starjoin join order planning |
|
Windows - Server 2019, MinGW64 - Meson |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/sysviews.out C:/cirrus/build/testrun/pg_upgrade/002_pg_...
--- C:/cirrus/src/test/regress/expected/sysviews.out 2025-10-27 08:26:33.829862200 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/sysviews.out 2025-10-27 08:30:19.014291700 +0000
@@ -172,8 +172,9 @@
enable_self_join_elimination | on
enable_seqscan | on
enable_sort | on
+ enable_starjoin_join_search | off
enable_tidscan | on
-(25 rows)
+(26 rows)
-- There are always wait event descriptions for various types. InjectionPoint
-- may be present or absent, depending on history since last postmaster start. |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/sysviews.out C:/cirrus/build/testrun/recovery/027_strea...
--- C:/cirrus/src/test/regress/expected/sysviews.out 2025-10-27 08:26:33.829862200 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/sysviews.out 2025-10-27 08:33:22.574165400 +0000
@@ -172,8 +172,9 @@
enable_self_join_elimination | on
enable_seqscan | on
enable_sort | on
+ enable_starjoin_join_search | off
enable_tidscan | on
-(25 rows)
+(26 rows)
-- There are always wait event descriptions for various types. InjectionPoint
-- may be present or absent, depending on history since last postmaster start. |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/sysviews.out C:/cirrus/build/testrun/regress/regress/re...
--- C:/cirrus/src/test/regress/expected/sysviews.out 2025-10-27 08:26:33.829862200 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/sysviews.out 2025-10-27 08:30:14.321904700 +0000
@@ -172,8 +172,9 @@
enable_self_join_elimination | on
enable_seqscan | on
enable_sort | on
+ enable_starjoin_join_search | off
enable_tidscan | on
-(25 rows)
+(26 rows)
-- There are always wait event descriptions for various types. InjectionPoint
-- may be present or absent, depending on history since last postmaster start. |
|
Windows - Server 2019, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/sysviews.out C:/cirrus/build/testrun/pg_upgrade/002_pg_...
--- C:/cirrus/src/test/regress/expected/sysviews.out 2025-10-27 08:26:46.225964700 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/sysviews.out 2025-10-27 08:30:23.725673600 +0000
@@ -172,8 +172,9 @@
enable_self_join_elimination | on
enable_seqscan | on
enable_sort | on
+ enable_starjoin_join_search | off
enable_tidscan | on
-(25 rows)
+(26 rows)
-- There are always wait event descriptions for various types. InjectionPoint
-- may be present or absent, depending on history since last postmaster start. |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/sysviews.out C:/cirrus/build/testrun/recovery/027_strea...
--- C:/cirrus/src/test/regress/expected/sysviews.out 2025-10-27 08:26:46.225964700 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/sysviews.out 2025-10-27 08:33:16.085531000 +0000
@@ -172,8 +172,9 @@
enable_self_join_elimination | on
enable_seqscan | on
enable_sort | on
+ enable_starjoin_join_search | off
enable_tidscan | on
-(25 rows)
+(26 rows)
-- There are always wait event descriptions for various types. InjectionPoint
-- may be present or absent, depending on history since last postmaster start. |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/sysviews.out C:/cirrus/build/testrun/regress/regress/re...
--- C:/cirrus/src/test/regress/expected/sysviews.out 2025-10-27 08:26:46.225964700 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/sysviews.out 2025-10-27 08:30:17.968842600 +0000
@@ -172,8 +172,9 @@
enable_self_join_elimination | on
enable_seqscan | on
enable_sort | on
+ enable_starjoin_join_search | off
enable_tidscan | on
-(25 rows)
+(26 rows)
-- There are always wait event descriptions for various types. InjectionPoint
-- may be present or absent, depending on history since last postmaster start. |
|
macOS - Sonoma - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/sysviews.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_up...
--- /Users/admin/pgsql/src/test/regress/expected/sysviews.out 2025-10-27 08:26:12
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/sysviews.out 2025-10-27 08:28:00
@@ -172,8 +172,9 @@
enable_self_join_elimination | on
enable_seqscan | on
enable_sort | on
+ enable_starjoin_join_search | off
enable_tidscan | on
-(25 rows)
+(26 rows)
-- There are always wait event descriptions for various types. InjectionPoint
-- may be present or absent, depending on history since last postmaster start. |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/sysviews.out /Users/admin/pgsql/build/testrun/recovery/027_stream_...
--- /Users/admin/pgsql/src/test/regress/expected/sysviews.out 2025-10-27 08:26:12
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/sysviews.out 2025-10-27 08:29:11
@@ -172,8 +172,9 @@
enable_self_join_elimination | on
enable_seqscan | on
enable_sort | on
+ enable_starjoin_join_search | off
enable_tidscan | on
-(25 rows)
+(26 rows)
-- There are always wait event descriptions for various types. InjectionPoint
-- may be present or absent, depending on history since last postmaster start. |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/sysviews.out /Users/admin/pgsql/build/testrun/regress/regress/resu...
--- /Users/admin/pgsql/src/test/regress/expected/sysviews.out 2025-10-27 08:26:12
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/sysviews.out 2025-10-27 08:27:58
@@ -172,8 +172,9 @@
enable_self_join_elimination | on
enable_seqscan | on
enable_sort | on
+ enable_starjoin_join_search | off
enable_tidscan | on
-(25 rows)
+(26 rows)
-- There are always wait event descriptions for various types. InjectionPoint
-- may be present or absent, depending on history since last postmaster start. |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_p...
--- /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out 2025-10-27 08:26:39.916673805 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/sysviews.out 2025-10-27 08:29:28.544996752...
@@ -172,8 +172,9 @@
enable_self_join_elimination | on
enable_seqscan | on
enable_sort | on
+ enable_starjoin_join_search | off
enable_tidscan | on
-(25 rows)
+(26 rows)
-- There are always wait event descriptions for various types. InjectionPoint
-- may be present or absent, depending on history since last postmaster start. |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out /tmp/cirrus-ci-build/build/testrun/recovery/027_str...
--- /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out 2025-10-27 08:26:39.916673805 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/sysviews.out 2025-10-27 08:30:44.7640611...
@@ -172,8 +172,9 @@
enable_self_join_elimination | on
enable_seqscan | on
enable_sort | on
+ enable_starjoin_join_search | off
enable_tidscan | on
-(25 rows)
+(26 rows)
-- There are always wait event descriptions for various types. InjectionPoint
-- may be present or absent, depending on history since last postmaster start. |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out /tmp/cirrus-ci-build/build/testrun/regress/regress/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out 2025-10-27 08:26:39.916673805 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/sysviews.out 2025-10-27 08:29:26.173041217 +0000
@@ -172,8 +172,9 @@
enable_self_join_elimination | on
enable_seqscan | on
enable_sort | on
+ enable_starjoin_join_search | off
enable_tidscan | on
-(25 rows)
+(26 rows)
-- There are always wait event descriptions for various types. InjectionPoint
-- may be present or absent, depending on history since last postmaster start. |
|
OpenBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/sysviews.out /home/postgres/postgres/build/testrun/pg_upgrade...
--- /home/postgres/postgres/src/test/regress/expected/sysviews.out Mon Oct 27 08:26:57 2025
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/sysviews.out Mon Oct 27 08:29:43 2025
@@ -172,8 +172,9 @@
enable_self_join_elimination | on
enable_seqscan | on
enable_sort | on
+ enable_starjoin_join_search | off
enable_tidscan | on
-(25 rows)
+(26 rows)
-- There are always wait event descriptions for various types. InjectionPoint
-- may be present or absent, depending on history since last postmaster start. |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/sysviews.out /home/postgres/postgres/build/testrun/recovery/0...
--- /home/postgres/postgres/src/test/regress/expected/sysviews.out Mon Oct 27 08:26:57 2025
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/sysviews.out Mon Oct 27 08:31:36 2025
@@ -172,8 +172,9 @@
enable_self_join_elimination | on
enable_seqscan | on
enable_sort | on
+ enable_starjoin_join_search | off
enable_tidscan | on
-(25 rows)
+(26 rows)
-- There are always wait event descriptions for various types. InjectionPoint
-- may be present or absent, depending on history since last postmaster start. |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/sysviews.out /home/postgres/postgres/build/testrun/regress/re...
--- /home/postgres/postgres/src/test/regress/expected/sysviews.out Mon Oct 27 08:26:57 2025
+++ /home/postgres/postgres/build/testrun/regress/regress/results/sysviews.out Mon Oct 27 08:29:28 2025
@@ -172,8 +172,9 @@
enable_self_join_elimination | on
enable_seqscan | on
enable_sort | on
+ enable_starjoin_join_search | off
enable_tidscan | on
-(25 rows)
+(26 rows)
-- There are always wait event descriptions for various types. InjectionPoint
-- may be present or absent, depending on history since last postmaster start. |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/sysviews.out /home/postgres/postgres/build/testrun/pg_upgrade...
--- /home/postgres/postgres/src/test/regress/expected/sysviews.out 2025-10-27 08:26:46.044032940 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/sysviews.out 2025-10-27 08:28:41.416696...
@@ -172,8 +172,9 @@
enable_self_join_elimination | on
enable_seqscan | on
enable_sort | on
+ enable_starjoin_join_search | off
enable_tidscan | on
-(25 rows)
+(26 rows)
-- There are always wait event descriptions for various types. InjectionPoint
-- may be present or absent, depending on history since last postmaster start. |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/sysviews.out /home/postgres/postgres/build/testrun/recovery/0...
--- /home/postgres/postgres/src/test/regress/expected/sysviews.out 2025-10-27 08:26:46.044032940 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/sysviews.out 2025-10-27 08:29:16.3843...
@@ -172,8 +172,9 @@
enable_self_join_elimination | on
enable_seqscan | on
enable_sort | on
+ enable_starjoin_join_search | off
enable_tidscan | on
-(25 rows)
+(26 rows)
-- There are always wait event descriptions for various types. InjectionPoint
-- may be present or absent, depending on history since last postmaster start. |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/sysviews.out /home/postgres/postgres/build/testrun/regress/re...
--- /home/postgres/postgres/src/test/regress/expected/sysviews.out 2025-10-27 08:26:46.044032940 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/sysviews.out 2025-10-27 08:28:38.230009689 +0000
@@ -172,8 +172,9 @@
enable_self_join_elimination | on
enable_seqscan | on
enable_sort | on
+ enable_starjoin_join_search | off
enable_tidscan | on
-(25 rows)
+(26 rows)
-- There are always wait event descriptions for various types. InjectionPoint
-- may be present or absent, depending on history since last postmaster start. |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_p...
--- /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out 2025-10-27 08:26:30.498111000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/sysviews.out 2025-10-27 08:29:02.147193000...
@@ -172,8 +172,9 @@
enable_self_join_elimination | on
enable_seqscan | on
enable_sort | on
+ enable_starjoin_join_search | off
enable_tidscan | on
-(25 rows)
+(26 rows)
-- There are always wait event descriptions for various types. InjectionPoint
-- may be present or absent, depending on history since last postmaster start. |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out /tmp/cirrus-ci-build/build/testrun/recovery/027_str...
--- /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out 2025-10-27 08:26:30.498111000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/sysviews.out 2025-10-27 08:30:16.9818340...
@@ -172,8 +172,9 @@
enable_self_join_elimination | on
enable_seqscan | on
enable_sort | on
+ enable_starjoin_join_search | off
enable_tidscan | on
-(25 rows)
+(26 rows)
-- There are always wait event descriptions for various types. InjectionPoint
-- may be present or absent, depending on history since last postmaster start. |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out /tmp/cirrus-ci-build/build/testrun/regress/regress/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out 2025-10-27 08:26:30.498111000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/sysviews.out 2025-10-27 08:28:52.198374000 +0000
@@ -172,8 +172,9 @@
enable_self_join_elimination | on
enable_seqscan | on
enable_sort | on
+ enable_starjoin_join_search | off
enable_tidscan | on
-(25 rows)
+(26 rows)
-- There are always wait event descriptions for various types. InjectionPoint
-- may be present or absent, depending on history since last postmaster start. |
|
Linux - Debian Bookworm - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out 2025-10-27 08:26:30.421168951 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/sysviews.out 2025-10-27 08:32:58.261635075 +0000
@@ -172,8 +172,9 @@
enable_self_join_elimination | on
enable_seqscan | on
enable_sort | on
+ enable_starjoin_join_search | off
enable_tidscan | on
-(25 rows)
+(26 rows)
-- There are always wait event descriptions for various types. InjectionPoint
-- may be present or absent, depending on history since last postmaster start. |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check/re...
--- /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out 2025-10-27 08:26:30.421168951 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/sysviews.out 2025-10-27 08:34:49.881242799 +0000
@@ -172,8 +172,9 @@
enable_self_join_elimination | on
enable_seqscan | on
enable_sort | on
+ enable_starjoin_join_search | off
enable_tidscan | on
-(25 rows)
+(26 rows)
-- There are always wait event descriptions for various types. InjectionPoint
-- may be present or absent, depending on history since last postmaster start. |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out /tmp/cirrus-ci-build/src/test/regress/results/sysvi...
--- /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out 2025-10-27 08:26:30.421168951 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/sysviews.out 2025-10-27 08:29:52.210888599 +0000
@@ -172,8 +172,9 @@
enable_self_join_elimination | on
enable_seqscan | on
enable_sort | on
+ enable_starjoin_join_search | off
enable_tidscan | on
-(25 rows)
+(26 rows)
-- There are always wait event descriptions for various types. InjectionPoint
-- may be present or absent, depending on history since last postmaster start. |
| 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-10-20 12:52:35.117614000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/stats.out 2025-10-20 12:57:36.702563000 +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-10-20 12:52:35.117614000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/stats.out 2025-10-20 12:59:10.235887000 ...
@@ -243,7 +243,7 @@
SELECT :seq_scan_after > :seq_scan_before;
?column?
----------
- t
+ f
(1 row)
---- |
| 56/6087 |
CREATE TABLE LIKE INCLUDING TRIGGERS |
|
macOS - Sonoma - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/triggers.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_up...
--- /Users/admin/pgsql/src/test/regress/expected/triggers.out 2025-10-20 00:10:12
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/triggers.out 2025-10-20 00:12:40
@@ -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 | | |
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/triggers.out /Users/admin/pgsql/build/testrun/recovery/027_stream_...
--- /Users/admin/pgsql/src/test/regress/expected/triggers.out 2025-10-20 00:10:12
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/triggers.out 2025-10-20 00:13:26
@@ -431,10 +431,10 @@
a | integer | | |
b | integer | | |
Triggers:
+ "" AFTER UPDATE OF b ON main_table1 FOR EACH STATEMENT EXECUTE FUNCTION trigger_func('after_upd_b_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')
- 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... |
|
Windows - Server 2019, MinGW64 - Meson |
| 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-10-20 00:11:19.336175400 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/triggers.out 2025-10-20 00:20:14.286004100 +0000
@@ -431,12 +431,12 @@
a | integer | | |
b | integer | | |
Triggers:
+ "" BEFORE INSERT ON main_table1 FOR EACH STATEMENT EXECUTE FUNCTION trigger_func('before_ins_stmt')
+ " :varnosyn 2 :varattnosyn -6 :location -1} {RELABELTYPE :arg {C" AFTER UPDATE ON main_table1 FOR EACH STATEMENT EX...
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...
|
|
Windows - Server 2019, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/triggers.out C:/cirrus/build/testrun/pg_upgrade/002_pg_...
--- C:/cirrus/src/test/regress/expected/triggers.out 2025-10-20 00:11:06.183476400 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/triggers.out 2025-10-20 00:13:59.528191500 +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 "before_upd_a_row_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 Bookworm - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check/re...
--- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out 2025-10-20 00:11:16.735712693 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/triggers.out 2025-10-20 00:21:11.523163146 +0000
@@ -431,13 +431,13 @@
a | integer | | |
b | integer | | |
Triggers:
+ "" BEFORE UPDATE OF a ON main_table1 FOR EACH ROW EXECUTE FUNCTION trigger_func('before_upd_a_row')
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...
\dd before_ins_stmt_trig |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_p...
--- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out 2025-10-20 00:11:02.370976000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/triggers.out 2025-10-20 00:13:28.412526000...
@@ -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 | | |
... |
| 56/6133 |
Extend documentation for pg_stat_replication.backend_xmin |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out /tmp/cirrus-ci-build/build/testrun/postgres...
--- /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out 2025-10-16 06:33:40.644031000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/postgres_fdw-running/regress/results/postgres_fdw.out 2025-10-16 06:40:47.4528710...
@@ -12691,8 +12691,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
@@ -12708,8 +12707,7 @@
FROM postgres_fdw_get_connections(true);
server_name | closed | remote_backend_pid
-------------+--------+--------------------
- loopback | t | t
-(1 row)
+(0 rows)
... |