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.
| 58/5877 |
Report bytes and transactions actually sent downtream |
 |
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/isolation/expected/timeouts.out /home/postgres/postgres/build/testrun/isolatio...
--- /home/postgres/postgres/src/test/isolation/expected/timeouts.out 2026-03-10 09:33:19.915498475 +0000
+++ /home/postgres/postgres/build/testrun/isolation/isolation/results/timeouts.out 2026-03-10 09:36:13.836874546 +0000
@@ -11,7 +11,7 @@
step sto: SET statement_timeout = '10ms';
step locktbl: LOCK TABLE accounts; <waiting ...>
step locktbl: <... completed>
-ERROR: canceling statement due to statement timeout
+ERROR: canceling statement due to user request
starting permutation: rdtbl lto locktbl
step rdtbl: SELECT * FROM accounts; |
| 58/6546 |
Fix slotsync worker busy loop causing repeated log messages |
|
Linux - Debian Trixie - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/pg_logicalinspect/expected/logical_inspect.out /tmp/cirrus-ci-build/build/testrun/...
--- /tmp/cirrus-ci-build/contrib/pg_logicalinspect/expected/logical_inspect.out 2026-03-10 06:13:47.637427777 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_logicalinspect/isolation/results/logical_inspect.out 2026-03-10 06:17:42.62520...
@@ -20,13 +20,13 @@
step s1_check_snapshot_info: SELECT count(*) > 0 as has_info FROM pg_ls_logicalsnapdir(), pg_get_logical_snapshot_info(...
has_info
--------
-t
+f
(1 row)
step s1_check_snapshot_meta: SELECT count(meta.*) > 0 AS has_meta from pg_ls_logicalsnapdir(), pg_get_logical_snapshot_...
has_meta
--------
-t
+f
(1 row)
step s0_commit: COMMIT; |
|
macOS - Sequoia - Meson |
| regress |
diff -U3 /Users/admin/pgsql/contrib/pg_logicalinspect/expected/logical_inspect.out /Users/admin/pgsql/build/testrun/pg_l...
--- /Users/admin/pgsql/contrib/pg_logicalinspect/expected/logical_inspect.out 2026-03-10 06:13:34
+++ /Users/admin/pgsql/build/testrun/pg_logicalinspect/isolation/results/logical_inspect.out 2026-03-10 06:19:20
@@ -20,13 +20,13 @@
step s1_check_snapshot_info: SELECT count(*) > 0 as has_info FROM pg_ls_logicalsnapdir(), pg_get_logical_snapshot_info(...
has_info
--------
-t
+f
(1 row)
step s1_check_snapshot_meta: SELECT count(meta.*) > 0 AS has_meta from pg_ls_logicalsnapdir(), pg_get_logical_snapshot_...
has_meta
--------
-t
+f
(1 row)
step s0_commit: COMMIT; |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/pg_logicalinspect/expected/logical_inspect.out C:/cirrus/build/testrun/pg...
--- C:/cirrus/contrib/pg_logicalinspect/expected/logical_inspect.out 2026-03-10 06:14:08.137209600 +0000
+++ C:/cirrus/build/testrun/pg_logicalinspect/isolation/results/logical_inspect.out 2026-03-10 06:23:10.885382800 +0000
@@ -20,13 +20,13 @@
step s1_check_snapshot_info: SELECT count(*) > 0 as has_info FROM pg_ls_logicalsnapdir(), pg_get_logical_snapshot_info(...
has_info
--------
-t
+f
(1 row)
step s1_check_snapshot_meta: SELECT count(meta.*) > 0 AS has_meta from pg_ls_logicalsnapdir(), pg_get_logical_snapshot_...
has_meta
--------
-t
+f
(1 row)
step s0_commit: COMMIT; |
|
Windows - Server 2022, MinGW64 - Meson |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/pg_logicalinspect/expected/logical_inspect.out C:/cirrus/build/testrun/pg...
--- C:/cirrus/contrib/pg_logicalinspect/expected/logical_inspect.out 2026-03-10 06:13:42.760600900 +0000
+++ C:/cirrus/build/testrun/pg_logicalinspect/isolation/results/logical_inspect.out 2026-03-10 06:22:16.334806500 +0000
@@ -20,13 +20,13 @@
step s1_check_snapshot_info: SELECT count(*) > 0 as has_info FROM pg_ls_logicalsnapdir(), pg_get_logical_snapshot_info(...
has_info
--------
-t
+f
(1 row)
step s1_check_snapshot_meta: SELECT count(meta.*) > 0 AS has_meta from pg_ls_logicalsnapdir(), pg_get_logical_snapshot_...
has_meta
--------
-t
+f
(1 row)
step s0_commit: COMMIT; |
|
Linux - Debian Trixie - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/pg_logicalinspect/expected/logical_inspect.out /tmp/cirrus-ci-build/contrib/pg_log...
--- /tmp/cirrus-ci-build/contrib/pg_logicalinspect/expected/logical_inspect.out 2026-03-10 06:13:46.511616992 +0000
+++ /tmp/cirrus-ci-build/contrib/pg_logicalinspect/output_iso/results/logical_inspect.out 2026-03-10 06:18:22.285892688 ...
@@ -20,13 +20,13 @@
step s1_check_snapshot_info: SELECT count(*) > 0 as has_info FROM pg_ls_logicalsnapdir(), pg_get_logical_snapshot_info(...
has_info
--------
-t
+f
(1 row)
step s1_check_snapshot_meta: SELECT count(meta.*) > 0 AS has_meta from pg_ls_logicalsnapdir(), pg_get_logical_snapshot_...
has_meta
--------
-t
+f
(1 row)
step s0_commit: COMMIT; |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/pg_logicalinspect/expected/logical_inspect.out /tmp/cirrus-ci-build/build/testrun/...
--- /tmp/cirrus-ci-build/contrib/pg_logicalinspect/expected/logical_inspect.out 2026-03-10 06:13:41.841907000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_logicalinspect/isolation/results/logical_inspect.out 2026-03-10 06:16:47.95532...
@@ -20,13 +20,13 @@
step s1_check_snapshot_info: SELECT count(*) > 0 as has_info FROM pg_ls_logicalsnapdir(), pg_get_logical_snapshot_info(...
has_info
--------
-t
+f
(1 row)
step s1_check_snapshot_meta: SELECT count(meta.*) > 0 AS has_meta from pg_ls_logicalsnapdir(), pg_get_logical_snapshot_...
has_meta
--------
-t
+f
(1 row)
step s0_commit: COMMIT; |
|
OpenBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/contrib/pg_logicalinspect/expected/logical_inspect.out /home/postgres/postgres/build/te...
--- /home/postgres/postgres/contrib/pg_logicalinspect/expected/logical_inspect.out Tue Mar 10 06:14:20 2026
+++ /home/postgres/postgres/build/testrun/pg_logicalinspect/isolation/results/logical_inspect.out Tue Mar 10 06:19:27 20...
@@ -20,13 +20,13 @@
step s1_check_snapshot_info: SELECT count(*) > 0 as has_info FROM pg_ls_logicalsnapdir(), pg_get_logical_snapshot_info(...
has_info
--------
-t
+f
(1 row)
step s1_check_snapshot_meta: SELECT count(meta.*) > 0 AS has_meta from pg_ls_logicalsnapdir(), pg_get_logical_snapshot_...
has_meta
--------
-t
+f
(1 row)
step s0_commit: COMMIT; |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/contrib/pg_logicalinspect/expected/logical_inspect.out /home/postgres/postgres/build/te...
--- /home/postgres/postgres/contrib/pg_logicalinspect/expected/logical_inspect.out 2026-03-10 06:13:52.996887468 +0000
+++ /home/postgres/postgres/build/testrun/pg_logicalinspect/isolation/results/logical_inspect.out 2026-03-10 06:16:20.21...
@@ -20,13 +20,13 @@
step s1_check_snapshot_info: SELECT count(*) > 0 as has_info FROM pg_ls_logicalsnapdir(), pg_get_logical_snapshot_info(...
has_info
--------
-t
+f
(1 row)
step s1_check_snapshot_meta: SELECT count(meta.*) > 0 AS has_meta from pg_ls_logicalsnapdir(), pg_get_logical_snapshot_...
has_meta
--------
-t
+f
(1 row)
step s0_commit: COMMIT; |
| 58/6352 |
Improve performance of tuple deformation |
|
Linux - Debian Trixie - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/horology.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_p...
--- /tmp/cirrus-ci-build/src/test/regress/expected/horology.out 2026-03-09 20:33:04.240864015 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/horology.out 2026-03-09 20:38:00.464782987...
@@ -1351,2540 +1351,8 @@
FROM TIME_TBL t, INTERVAL_TBL i
WHERE isfinite(i.f1)
ORDER BY 1,2;
- t | i | add | subtract
--------------+-------------------------------+-------------+-------------
- 00:00:00 | @ 14 secs ago | 23:59:46 | 00:00:14
- 00:00:00 | @ 1 min | 00:01:00 | 23:59:00
- 00:00:00 | @ 5 hours | 05:00:00 | 19:00:00
- 00:00:00 | @ 1 day 2 hours 3 mins 4 secs | 02:03:04 | 21:56:56
- 00:00:00 | @ 10 days | 00:00:00 | 00:00:00
- 00:00:00 | @ 3 mons | 00:00:00 | 00:00:00
- 00:00:00 | @ 5 mons | 00:00:00 | 00:00:00
- 00:00:00 | @ 5 mons 12 hours | 12:00:00 | 12:00:00
- 00:00:00 | @ 6 years | 00:00:00 | 00:00:00
- 00:00:00 | @ 34 years | 00:00:00 | 00:00:00
- 01:00:00 | @ 14 secs ago | 00:59:46 | 01:00:14
... |
| 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 2026-03-09 20:33:02.409250430 +0000
+++ /tmp/cirrus-ci-build/build/testrun/postgres_fdw/regress/results/postgres_fdw.out 2026-03-09 20:41:03.694702008 +0000
@@ -12429,312 +12429,8 @@
(11 rows)
SELECT a FROM base_tbl WHERE (a, random() > 0) IN (SELECT a, random() > 0 FROM foreign_tbl);
- a
----
- 1
- 2
- 3
-(3 rows)
-
--- Clean up
-DROP FOREIGN TABLE foreign_tbl CASCADE;
-NOTICE: drop cascades to foreign table foreign_tbl2
-DROP TABLE base_tbl;
-ALTER SERVER loopback OPTIONS (DROP async_capable);
-ALTER SERVER loopback2 OPTIONS (DROP async_capable);
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/horology.out /tmp/cirrus-ci-build/build/testrun/recovery/027_str...
--- /tmp/cirrus-ci-build/src/test/regress/expected/horology.out 2026-03-09 20:33:04.240864015 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/horology.out 2026-03-09 20:39:31.8994463...
@@ -1351,2540 +1351,8 @@
FROM TIME_TBL t, INTERVAL_TBL i
WHERE isfinite(i.f1)
ORDER BY 1,2;
- t | i | add | subtract
--------------+-------------------------------+-------------+-------------
- 00:00:00 | @ 14 secs ago | 23:59:46 | 00:00:14
- 00:00:00 | @ 1 min | 00:01:00 | 23:59:00
- 00:00:00 | @ 5 hours | 05:00:00 | 19:00:00
- 00:00:00 | @ 1 day 2 hours 3 mins 4 secs | 02:03:04 | 21:56:56
- 00:00:00 | @ 10 days | 00:00:00 | 00:00:00
- 00:00:00 | @ 3 mons | 00:00:00 | 00:00:00
- 00:00:00 | @ 5 mons | 00:00:00 | 00:00:00
- 00:00:00 | @ 5 mons 12 hours | 12:00:00 | 12:00:00
- 00:00:00 | @ 6 years | 00:00:00 | 00:00:00
- 00:00:00 | @ 34 years | 00:00:00 | 00:00:00
- 01:00:00 | @ 14 secs ago | 00:59:46 | 01:00:14
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/horology.out /tmp/cirrus-ci-build/build/testrun/regress/regress/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/horology.out 2026-03-09 20:33:04.240864015 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/horology.out 2026-03-09 20:37:59.744797776 +0000
@@ -1351,2540 +1351,8 @@
FROM TIME_TBL t, INTERVAL_TBL i
WHERE isfinite(i.f1)
ORDER BY 1,2;
- t | i | add | subtract
--------------+-------------------------------+-------------+-------------
- 00:00:00 | @ 14 secs ago | 23:59:46 | 00:00:14
- 00:00:00 | @ 1 min | 00:01:00 | 23:59:00
- 00:00:00 | @ 5 hours | 05:00:00 | 19:00:00
- 00:00:00 | @ 1 day 2 hours 3 mins 4 secs | 02:03:04 | 21:56:56
- 00:00:00 | @ 10 days | 00:00:00 | 00:00:00
- 00:00:00 | @ 3 mons | 00:00:00 | 00:00:00
- 00:00:00 | @ 5 mons | 00:00:00 | 00:00:00
- 00:00:00 | @ 5 mons 12 hours | 12:00:00 | 12:00:00
- 00:00:00 | @ 6 years | 00:00:00 | 00:00:00
- 00:00:00 | @ 34 years | 00:00:00 | 00:00:00
- 01:00:00 | @ 14 secs ago | 00:59:46 | 01:00:14
... |
|
Linux - Debian Trixie - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out /tmp/cirrus-ci-build/contrib/postgres_fdw/r...
--- /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out 2026-03-09 20:33:43.408333732 +0000
+++ /tmp/cirrus-ci-build/contrib/postgres_fdw/results/postgres_fdw.out 2026-03-09 20:40:52.208078448 +0000
@@ -12429,312 +12429,8 @@
(11 rows)
SELECT a FROM base_tbl WHERE (a, random() > 0) IN (SELECT a, random() > 0 FROM foreign_tbl);
- a
----
- 1
- 2
- 3
-(3 rows)
-
--- Clean up
-DROP FOREIGN TABLE foreign_tbl CASCADE;
-NOTICE: drop cascades to foreign table foreign_tbl2
-DROP TABLE base_tbl;
-ALTER SERVER loopback OPTIONS (DROP async_capable);
-ALTER SERVER loopback2 OPTIONS (DROP async_capable);
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/horology.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/horology.out 2026-03-09 20:33:45.160311140 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/horology.out 2026-03-09 20:40:48.156078824 +0000
@@ -1351,2540 +1351,8 @@
FROM TIME_TBL t, INTERVAL_TBL i
WHERE isfinite(i.f1)
ORDER BY 1,2;
- t | i | add | subtract
--------------+-------------------------------+-------------+-------------
- 00:00:00 | @ 14 secs ago | 23:59:46 | 00:00:14
- 00:00:00 | @ 1 min | 00:01:00 | 23:59:00
- 00:00:00 | @ 5 hours | 05:00:00 | 19:00:00
- 00:00:00 | @ 1 day 2 hours 3 mins 4 secs | 02:03:04 | 21:56:56
- 00:00:00 | @ 10 days | 00:00:00 | 00:00:00
- 00:00:00 | @ 3 mons | 00:00:00 | 00:00:00
- 00:00:00 | @ 5 mons | 00:00:00 | 00:00:00
- 00:00:00 | @ 5 mons 12 hours | 12:00:00 | 12:00:00
- 00:00:00 | @ 6 years | 00:00:00 | 00:00:00
- 00:00:00 | @ 34 years | 00:00:00 | 00:00:00
- 01:00:00 | @ 14 secs ago | 00:59:46 | 01:00:14
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/horology.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check/re...
--- /tmp/cirrus-ci-build/src/test/regress/expected/horology.out 2026-03-09 20:33:45.160311140 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/horology.out 2026-03-09 20:42:15.704080017 +0000
@@ -1351,2540 +1351,8 @@
FROM TIME_TBL t, INTERVAL_TBL i
WHERE isfinite(i.f1)
ORDER BY 1,2;
- t | i | add | subtract
--------------+-------------------------------+-------------+-------------
- 00:00:00 | @ 14 secs ago | 23:59:46 | 00:00:14
- 00:00:00 | @ 1 min | 00:01:00 | 23:59:00
- 00:00:00 | @ 5 hours | 05:00:00 | 19:00:00
- 00:00:00 | @ 1 day 2 hours 3 mins 4 secs | 02:03:04 | 21:56:56
- 00:00:00 | @ 10 days | 00:00:00 | 00:00:00
- 00:00:00 | @ 3 mons | 00:00:00 | 00:00:00
- 00:00:00 | @ 5 mons | 00:00:00 | 00:00:00
- 00:00:00 | @ 5 mons 12 hours | 12:00:00 | 12:00:00
- 00:00:00 | @ 6 years | 00:00:00 | 00:00:00
- 00:00:00 | @ 34 years | 00:00:00 | 00:00:00
- 01:00:00 | @ 14 secs ago | 00:59:46 | 01:00:14
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/horology.out /tmp/cirrus-ci-build/src/test/regress/results/horol...
--- /tmp/cirrus-ci-build/src/test/regress/expected/horology.out 2026-03-09 20:33:45.160311140 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/horology.out 2026-03-09 20:38:46.792091014 +0000
@@ -1351,2540 +1351,8 @@
FROM TIME_TBL t, INTERVAL_TBL i
WHERE isfinite(i.f1)
ORDER BY 1,2;
- t | i | add | subtract
--------------+-------------------------------+-------------+-------------
- 00:00:00 | @ 14 secs ago | 23:59:46 | 00:00:14
- 00:00:00 | @ 1 min | 00:01:00 | 23:59:00
- 00:00:00 | @ 5 hours | 05:00:00 | 19:00:00
- 00:00:00 | @ 1 day 2 hours 3 mins 4 secs | 02:03:04 | 21:56:56
- 00:00:00 | @ 10 days | 00:00:00 | 00:00:00
- 00:00:00 | @ 3 mons | 00:00:00 | 00:00:00
- 00:00:00 | @ 5 mons | 00:00:00 | 00:00:00
- 00:00:00 | @ 5 mons 12 hours | 12:00:00 | 12:00:00
- 00:00:00 | @ 6 years | 00:00:00 | 00:00:00
- 00:00:00 | @ 34 years | 00:00:00 | 00:00:00
- 01:00:00 | @ 14 secs ago | 00:59:46 | 01:00:14
... |
| 58/5992 |
Fix ALTER TABLE DROP EXPRESSION with ONLY option |
|
Linux - Debian Trixie - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_stored.out /tmp/cirrus-ci-build/build/testrun/pg_upgra...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_stored.out 2026-03-09 18:44:43.205478237 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_stored.out 2026-03-09 18:46:48.4...
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out /tmp/cirrus-ci-build/build/testrun/pg_upgr...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out 2026-03-09 18:44:43.205478237 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out 2026-03-09 18:46:56....
@@ -1308,6 +1308,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 2026-03-09 18:44:43.205478237 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/generated_stored.out 2026-03-09 18:48:16...
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out /tmp/cirrus-ci-build/build/testrun/recover...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out 2026-03-09 18:44:43.205478237 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out 2026-03-09 18:48:2...
@@ -1308,6 +1308,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 2026-03-09 18:44:43.205478237 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/generated_stored.out 2026-03-09 18:46:44.945051840 +0000
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out /tmp/cirrus-ci-build/build/testrun/regress...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out 2026-03-09 18:44:43.205478237 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/generated_virtual.out 2026-03-09 18:46:52.805140473 +0000
@@ -1308,6 +1308,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/generated_stored.out C:/cirrus/build/testrun/pg_upgrade...
--- C:/cirrus/src/test/regress/expected/generated_stored.out 2026-03-09 18:46:32.509728400 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_stored.out 2026-03-09 18:50:32.337315500 +0...
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/generated_virtual.out C:/cirrus/build/testrun/pg_upgrad...
--- C:/cirrus/src/test/regress/expected/generated_virtual.out 2026-03-09 18:46:32.509728400 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out 2026-03-09 18:50:53.353435200 +...
@@ -1308,6 +1308,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 2026-03-09 18:46:32.509728400 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/generated_stored.out 2026-03-09 18:53:57.992057900 ...
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/generated_virtual.out C:/cirrus/build/testrun/recovery/...
--- C:/cirrus/src/test/regress/expected/generated_virtual.out 2026-03-09 18:46:32.509728400 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out 2026-03-09 18:54:21.298693000...
@@ -1308,6 +1308,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 2026-03-09 18:46:32.509728400 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/generated_stored.out 2026-03-09 18:50:22.526293700 +0000
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/generated_virtual.out C:/cirrus/build/testrun/regress/r...
--- C:/cirrus/src/test/regress/expected/generated_virtual.out 2026-03-09 18:46:32.509728400 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/generated_virtual.out 2026-03-09 18:50:47.048271000 +0000
@@ -1308,6 +1308,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
|
Windows - Server 2022, MinGW64 - Meson |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/generated_stored.out C:/cirrus/build/testrun/pg_upgrade...
--- C:/cirrus/src/test/regress/expected/generated_stored.out 2026-03-09 18:44:23.023187500 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_stored.out 2026-03-09 18:47:39.630901000 +0...
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/generated_virtual.out C:/cirrus/build/testrun/pg_upgrad...
--- C:/cirrus/src/test/regress/expected/generated_virtual.out 2026-03-09 18:44:23.023187500 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out 2026-03-09 18:47:50.112351100 +...
@@ -1308,6 +1308,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 2026-03-09 18:44:23.023187500 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/generated_stored.out 2026-03-09 18:51:17.563664700 ...
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/generated_virtual.out C:/cirrus/build/testrun/recovery/...
--- C:/cirrus/src/test/regress/expected/generated_virtual.out 2026-03-09 18:44:23.023187500 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out 2026-03-09 18:51:29.983110100...
@@ -1308,6 +1308,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 2026-03-09 18:44:23.023187500 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/generated_stored.out 2026-03-09 18:47:33.453161800 +0000
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/generated_virtual.out C:/cirrus/build/testrun/regress/r...
--- C:/cirrus/src/test/regress/expected/generated_virtual.out 2026-03-09 18:44:23.023187500 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/generated_virtual.out 2026-03-09 18:47:44.525439000 +0000
@@ -1308,6 +1308,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
|
macOS - Sequoia - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/generated_stored.out /Users/admin/pgsql/build/testrun/pg_upgrade/0...
--- /Users/admin/pgsql/src/test/regress/expected/generated_stored.out 2026-03-09 18:44:00
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_stored.out 2026-03-09 18:46:04
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff -U3 /Users/admin/pgsql/src/test/regress/expected/generated_virtual.out /Users/admin/pgsql/build/testrun/pg_upgrade/...
--- /Users/admin/pgsql/src/test/regress/expected/generated_virtual.out 2026-03-09 18:44:00
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out 2026-03-09 18:46:08
@@ -1308,6 +1308,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 2026-03-09 18:44:00
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/generated_stored.out 2026-03-09 18:47:22
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff -U3 /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 2026-03-09 18:44:00
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out 2026-03-09 18:47:36
@@ -1308,6 +1308,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 2026-03-09 18:44:00
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/generated_stored.out 2026-03-09 18:46:03
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff -U3 /Users/admin/pgsql/src/test/regress/expected/generated_virtual.out /Users/admin/pgsql/build/testrun/regress/reg...
--- /Users/admin/pgsql/src/test/regress/expected/generated_virtual.out 2026-03-09 18:44:00
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/generated_virtual.out 2026-03-09 18:46:08
@@ -1308,6 +1308,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
|
Linux - Debian Trixie - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_stored.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_stored.out 2026-03-09 18:44:18.980469716 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/generated_stored.out 2026-03-09 18:50:00.750092415 +0000
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tm...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out 2026-03-09 18:44:18.980469716 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/generated_virtual.out 2026-03-09 18:50:16.549935337 +0000
@@ -1308,6 +1308,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 2026-03-09 18:44:18.980469716 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/generated_stored.out 2026-03-09 18:51:57.497285419 +0000
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out /tmp/cirrus-ci-build/src/test/recovery/tmp...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out 2026-03-09 18:44:18.980469716 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/generated_virtual.out 2026-03-09 18:52:08.421241366 +0000
@@ -1308,6 +1308,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 2026-03-09 18:44:18.980469716 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/generated_stored.out 2026-03-09 18:47:37.216904364 +0000
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out /tmp/cirrus-ci-build/src/test/regress/resu...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out 2026-03-09 18:44:18.980469716 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/generated_virtual.out 2026-03-09 18:47:52.688428424 +0000
@@ -1308,6 +1308,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
|
OpenBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/generated_stored.out /home/postgres/postgres/build/testrun/pg...
--- /home/postgres/postgres/src/test/regress/expected/generated_stored.out Mon Mar 9 18:45:33 2026
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_stored.out Mon Mar 9 18:48:1...
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff -U3 /home/postgres/postgres/src/test/regress/expected/generated_virtual.out /home/postgres/postgres/build/testrun/p...
--- /home/postgres/postgres/src/test/regress/expected/generated_virtual.out Mon Mar 9 18:45:33 2026
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out Mon Mar 9 18:48:...
@@ -1308,6 +1308,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/generated_stored.out /home/postgres/postgres/build/testrun/re...
--- /home/postgres/postgres/src/test/regress/expected/generated_stored.out Mon Mar 9 18:45:33 2026
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/generated_stored.out Mon Mar 9 18:50...
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff -U3 /home/postgres/postgres/src/test/regress/expected/generated_virtual.out /home/postgres/postgres/build/testrun/r...
--- /home/postgres/postgres/src/test/regress/expected/generated_virtual.out Mon Mar 9 18:45:33 2026
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out Mon Mar 9 18:5...
@@ -1308,6 +1308,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/generated_stored.out /home/postgres/postgres/build/testrun/re...
--- /home/postgres/postgres/src/test/regress/expected/generated_stored.out Mon Mar 9 18:45:33 2026
+++ /home/postgres/postgres/build/testrun/regress/regress/results/generated_stored.out Mon Mar 9 18:48:05 2026
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff -U3 /home/postgres/postgres/src/test/regress/expected/generated_virtual.out /home/postgres/postgres/build/testrun/r...
--- /home/postgres/postgres/src/test/regress/expected/generated_virtual.out Mon Mar 9 18:45:33 2026
+++ /home/postgres/postgres/build/testrun/regress/regress/results/generated_virtual.out Mon Mar 9 18:48:18 2026
@@ -1308,6 +1308,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_stored.out /tmp/cirrus-ci-build/build/testrun/pg_upgra...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_stored.out 2026-03-09 18:44:20.989703000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_stored.out 2026-03-09 18:46:26.8...
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out /tmp/cirrus-ci-build/build/testrun/pg_upgr...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out 2026-03-09 18:44:20.990327000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out 2026-03-09 18:46:49....
@@ -1308,6 +1308,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 2026-03-09 18:44:20.989703000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/generated_stored.out 2026-03-09 18:47:47...
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out /tmp/cirrus-ci-build/build/testrun/recover...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out 2026-03-09 18:44:20.990327000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out 2026-03-09 18:48:2...
@@ -1308,6 +1308,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 2026-03-09 18:44:20.989703000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/generated_stored.out 2026-03-09 18:46:26.646291000 +0000
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out /tmp/cirrus-ci-build/build/testrun/regress...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out 2026-03-09 18:44:20.990327000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/generated_virtual.out 2026-03-09 18:46:47.812471000 +0000
@@ -1308,6 +1308,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 2026-03-09 18:46:13.775114999 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_stored.out 2026-03-09 18:49:4...
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff -U3 /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 2026-03-09 18:46:13.778850754 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out 2026-03-09 18:50:...
@@ -1308,6 +1308,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 2026-03-09 18:46:13.775114999 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/generated_stored.out 2026-03-09 18:51...
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff -U3 /home/postgres/postgres/src/test/regress/expected/generated_virtual.out /home/postgres/postgres/build/testrun/r...
--- /home/postgres/postgres/src/test/regress/expected/generated_virtual.out 2026-03-09 18:46:13.778850754 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out 2026-03-09 18:5...
@@ -1308,6 +1308,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 2026-03-09 18:46:13.775114999 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/generated_stored.out 2026-03-09 18:49:35.488860442 +00...
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff -U3 /home/postgres/postgres/src/test/regress/expected/generated_virtual.out /home/postgres/postgres/build/testrun/r...
--- /home/postgres/postgres/src/test/regress/expected/generated_virtual.out 2026-03-09 18:46:13.778850754 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/generated_virtual.out 2026-03-09 18:50:01.711136261 +0...
@@ -1308,6 +1308,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
... |
| 58/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/regress/regress/res...
--- /tmp/cirrus-ci-build/src/test/regress/expected/stats.out 2026-03-09 15:06:25.037120000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/stats.out 2026-03-09 15:11:10.760946000 +0000
@@ -243,7 +243,7 @@
SELECT :seq_scan_after > :seq_scan_before;
?column?
----------
- t
+ f
(1 row)
---- |
| 58/6543 |
synchronized_standby_slots behavior inconsistent with quorum-based synchronous replication |
|
macOS - Sequoia - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/modules/unsafe_tests/expected/guc_privs.out /Users/admin/pgsql/build/testrun/unsafe...
--- /Users/admin/pgsql/src/test/modules/unsafe_tests/expected/guc_privs.out 2026-03-09 14:33:44
+++ /Users/admin/pgsql/build/testrun/unsafe_tests/regress/results/guc_privs.out 2026-03-09 14:38:19
@@ -590,8 +590,7 @@
-- Cannot set synchronized_standby_slots to an invalid slot name
ALTER SYSTEM SET synchronized_standby_slots='invalid*';
ERROR: invalid value for parameter "synchronized_standby_slots": "invalid*"
-DETAIL: replication slot name "invalid*" contains invalid character
-HINT: Replication slot names may only contain lower case letters, numbers, and the underscore character.
+DETAIL: syntax error at or near "*"
-- Can set synchronized_standby_slots to a non-existent slot name
ALTER SYSTEM SET synchronized_standby_slots='missing';
-- Reset the GUC |
|
Windows - Server 2022, MinGW64 - Meson |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/modules/unsafe_tests/expected/guc_privs.out C:/cirrus/build/testrun/unsa...
--- C:/cirrus/src/test/modules/unsafe_tests/expected/guc_privs.out 2026-03-09 14:33:52.712801600 +0000
+++ C:/cirrus/build/testrun/unsafe_tests/regress/results/guc_privs.out 2026-03-09 14:44:31.475781200 +0000
@@ -590,8 +590,7 @@
-- Cannot set synchronized_standby_slots to an invalid slot name
ALTER SYSTEM SET synchronized_standby_slots='invalid*';
ERROR: invalid value for parameter "synchronized_standby_slots": "invalid*"
-DETAIL: replication slot name "invalid*" contains invalid character
-HINT: Replication slot names may only contain lower case letters, numbers, and the underscore character.
+DETAIL: syntax error at or near "*"
-- Can set synchronized_standby_slots to a non-existent slot name
ALTER SYSTEM SET synchronized_standby_slots='missing';
-- Reset the GUC |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/modules/unsafe_tests/expected/guc_privs.out C:/cirrus/build/testrun/unsa...
--- C:/cirrus/src/test/modules/unsafe_tests/expected/guc_privs.out 2026-03-09 14:33:52.651479200 +0000
+++ C:/cirrus/build/testrun/unsafe_tests/regress/results/guc_privs.out 2026-03-09 14:43:22.613185000 +0000
@@ -590,8 +590,7 @@
-- Cannot set synchronized_standby_slots to an invalid slot name
ALTER SYSTEM SET synchronized_standby_slots='invalid*';
ERROR: invalid value for parameter "synchronized_standby_slots": "invalid*"
-DETAIL: replication slot name "invalid*" contains invalid character
-HINT: Replication slot names may only contain lower case letters, numbers, and the underscore character.
+DETAIL: syntax error at or near "*"
-- Can set synchronized_standby_slots to a non-existent slot name
ALTER SYSTEM SET synchronized_standby_slots='missing';
-- Reset the GUC |
|
Linux - Debian Trixie - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/modules/unsafe_tests/expected/guc_privs.out /tmp/cirrus-ci-build/build/testrun/un...
--- /tmp/cirrus-ci-build/src/test/modules/unsafe_tests/expected/guc_privs.out 2026-03-09 14:34:01.040899301 +0000
+++ /tmp/cirrus-ci-build/build/testrun/unsafe_tests/regress/results/guc_privs.out 2026-03-09 14:40:15.616299786 +0000
@@ -590,8 +590,7 @@
-- Cannot set synchronized_standby_slots to an invalid slot name
ALTER SYSTEM SET synchronized_standby_slots='invalid*';
ERROR: invalid value for parameter "synchronized_standby_slots": "invalid*"
-DETAIL: replication slot name "invalid*" contains invalid character
-HINT: Replication slot names may only contain lower case letters, numbers, and the underscore character.
+DETAIL: syntax error at or near "*"
-- Can set synchronized_standby_slots to a non-existent slot name
ALTER SYSTEM SET synchronized_standby_slots='missing';
-- Reset the GUC |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/modules/unsafe_tests/expected/guc_privs.out /home/postgres/postgres/build/test...
--- /home/postgres/postgres/src/test/modules/unsafe_tests/expected/guc_privs.out 2026-03-09 14:34:49.870210309 +0000
+++ /home/postgres/postgres/build/testrun/unsafe_tests/regress/results/guc_privs.out 2026-03-09 14:43:22.427230737 +0000
@@ -590,8 +590,7 @@
-- Cannot set synchronized_standby_slots to an invalid slot name
ALTER SYSTEM SET synchronized_standby_slots='invalid*';
ERROR: invalid value for parameter "synchronized_standby_slots": "invalid*"
-DETAIL: replication slot name "invalid*" contains invalid character
-HINT: Replication slot names may only contain lower case letters, numbers, and the underscore character.
+DETAIL: syntax error at or near "*"
-- Can set synchronized_standby_slots to a non-existent slot name
ALTER SYSTEM SET synchronized_standby_slots='missing';
-- Reset the GUC |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/modules/unsafe_tests/expected/guc_privs.out /tmp/cirrus-ci-build/build/testrun/un...
--- /tmp/cirrus-ci-build/src/test/modules/unsafe_tests/expected/guc_privs.out 2026-03-09 14:34:37.379430000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/unsafe_tests/regress/results/guc_privs.out 2026-03-09 14:39:04.534416000 +0000
@@ -590,8 +590,7 @@
-- Cannot set synchronized_standby_slots to an invalid slot name
ALTER SYSTEM SET synchronized_standby_slots='invalid*';
ERROR: invalid value for parameter "synchronized_standby_slots": "invalid*"
-DETAIL: replication slot name "invalid*" contains invalid character
-HINT: Replication slot names may only contain lower case letters, numbers, and the underscore character.
+DETAIL: syntax error at or near "*"
-- Can set synchronized_standby_slots to a non-existent slot name
ALTER SYSTEM SET synchronized_standby_slots='missing';
-- Reset the GUC |
|
OpenBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/modules/unsafe_tests/expected/guc_privs.out /home/postgres/postgres/build/test...
--- /home/postgres/postgres/src/test/modules/unsafe_tests/expected/guc_privs.out Mon Mar 9 14:34:05 2026
+++ /home/postgres/postgres/build/testrun/unsafe_tests/regress/results/guc_privs.out Mon Mar 9 14:40:16 2026
@@ -590,8 +590,7 @@
-- Cannot set synchronized_standby_slots to an invalid slot name
ALTER SYSTEM SET synchronized_standby_slots='invalid*';
ERROR: invalid value for parameter "synchronized_standby_slots": "invalid*"
-DETAIL: replication slot name "invalid*" contains invalid character
-HINT: Replication slot names may only contain lower case letters, numbers, and the underscore character.
+DETAIL: syntax error at or near "*"
-- Can set synchronized_standby_slots to a non-existent slot name
ALTER SYSTEM SET synchronized_standby_slots='missing';
-- Reset the GUC |
|
Linux - Debian Trixie - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/modules/unsafe_tests/expected/guc_privs.out /tmp/cirrus-ci-build/src/test/modules...
--- /tmp/cirrus-ci-build/src/test/modules/unsafe_tests/expected/guc_privs.out 2026-03-09 14:33:49.376355563 +0000
+++ /tmp/cirrus-ci-build/src/test/modules/unsafe_tests/results/guc_privs.out 2026-03-09 14:41:27.699507132 +0000
@@ -590,8 +590,7 @@
-- Cannot set synchronized_standby_slots to an invalid slot name
ALTER SYSTEM SET synchronized_standby_slots='invalid*';
ERROR: invalid value for parameter "synchronized_standby_slots": "invalid*"
-DETAIL: replication slot name "invalid*" contains invalid character
-HINT: Replication slot names may only contain lower case letters, numbers, and the underscore character.
+DETAIL: syntax error at or near "*"
-- Can set synchronized_standby_slots to a non-existent slot name
ALTER SYSTEM SET synchronized_standby_slots='missing';
-- Reset the GUC |
| 58/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 2026-03-09 12:26:03
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/rowsecurity.out 2026-03-09 12:28:58
@@ -423,15 +423,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...
... |
|
Windows - Server 2022, MinGW64 - Meson |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/rowsecurity.out C:/cirrus/build/testrun/pg_upgrade/002_...
--- C:/cirrus/src/test/regress/expected/rowsecurity.out 2026-03-09 12:26:40.028315800 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/rowsecurity.out 2026-03-09 12:31:27.343017500 +0000
@@ -423,15 +423,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...
... |
| 58/6432 |
docs: warn about post-data-only schema dumps with parallel restore. |
|
OpenBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/isolation/expected/timeouts.out /home/postgres/postgres/build/testrun/isolatio...
--- /home/postgres/postgres/src/test/isolation/expected/timeouts.out Mon Mar 9 01:09:19 2026
+++ /home/postgres/postgres/build/testrun/isolation/isolation/results/timeouts.out Mon Mar 9 01:14:34 2026
@@ -57,7 +57,7 @@
step sto: SET statement_timeout = '10ms';
step update: DELETE FROM accounts WHERE accountid = 'checking'; <waiting ...>
step update: <... completed>
-ERROR: canceling statement due to statement timeout
+ERROR: canceling statement due to user request
starting permutation: wrtbl lto update
step wrtbl: UPDATE accounts SET balance = balance + 100; |
| 58/5556 |
Expanding HOT updates for expression and partial indexes |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/hot_updates.out C:/cirrus/build/testrun/recovery/027_st...
--- C:/cirrus/src/test/regress/expected/hot_updates.out 2026-03-08 21:14:32.887686400 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/hot_updates.out 2026-03-08 21:23:17.768733800 +0000
@@ -258,8 +258,9 @@
LATERAL print_hot_chain('hot_test', current_tuple.ctid);
phase | has_chain | chain_position | ctid | lp_flags | t_ctid
--------------+-----------+----------------+-------+------------+--------
- After VACUUM | f | 0 | (0,4) | normal (1) | (0,4)
-(1 row)
+ After VACUUM | t | 0 | (0,1) | normal (1) | (0,4)
+ After VACUUM | t | 1 | (0,4) | normal (1) | (0,4)
+(2 rows)
-- Non-HOT update (update indexed column)
UPDATE hot_test SET indexed_col = 150 WHERE id = 1; |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/triggers.out C:/cirrus/build/testrun/regress/regress/re...
--- C:/cirrus/src/test/regress/expected/triggers.out 2026-03-08 21:14:33.068901300 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/triggers.out 2026-03-08 21:17:46.772132200 +0000
@@ -277,8 +277,8 @@
NOTICE: trigger_func(delete_when) called: action = DELETE, when = AFTER, level = STATEMENT
UPDATE main_table SET a = 50, b = 60;
NOTICE: trigger_func(modified_any) called: action = UPDATE, when = BEFORE, level = ROW
-NOTICE: trigger_func(modified_any) called: action = UPDATE, when = BEFORE, level = ROW
NOTICE: trigger_func(modified_a) called: action = UPDATE, when = BEFORE, level = ROW
+NOTICE: trigger_func(modified_any) called: action = UPDATE, when = BEFORE, level = ROW
NOTICE: trigger_func(modified_a) called: action = UPDATE, when = BEFORE, level = ROW
NOTICE: trigger_func(modified_a) called: action = UPDATE, when = BEFORE, level = ROW
NOTICE: trigger_func(modified_a) called: action = UPDATE, when = BEFORE, level = ROW |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/triggers.out /home/postgres/postgres/build/testrun/recovery/0...
--- /home/postgres/postgres/src/test/regress/expected/triggers.out 2026-03-08 21:15:35.390160114 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/triggers.out 2026-03-08 21:18:52.1670...
@@ -277,8 +277,8 @@
NOTICE: trigger_func(delete_when) called: action = DELETE, when = AFTER, level = STATEMENT
UPDATE main_table SET a = 50, b = 60;
NOTICE: trigger_func(modified_any) called: action = UPDATE, when = BEFORE, level = ROW
-NOTICE: trigger_func(modified_any) called: action = UPDATE, when = BEFORE, level = ROW
NOTICE: trigger_func(modified_a) called: action = UPDATE, when = BEFORE, level = ROW
+NOTICE: trigger_func(modified_any) called: action = UPDATE, when = BEFORE, level = ROW
NOTICE: trigger_func(modified_a) called: action = UPDATE, when = BEFORE, level = ROW
NOTICE: trigger_func(modified_a) called: action = UPDATE, when = BEFORE, level = ROW
NOTICE: trigger_func(modified_a) called: action = UPDATE, when = BEFORE, level = ROW |
| 58/6037 |
Fix race condition in SSI when reading PredXact->SxactGlobalXmin |
|
Windows - Server 2022, MinGW64 - Meson |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/modules/injection_points/expected/predicate-lock-page-split.out C:/cirru...
--- C:/cirrus/src/test/modules/injection_points/expected/predicate-lock-page-split.out 2026-03-08 19:49:38.859332400 +00...
+++ C:/cirrus/build/testrun/injection_points/isolation/results/predicate-lock-page-split.out 2026-03-08 19:59:44.8615749...
@@ -76,7 +76,6 @@
step s3_insert:
INSERT INTO test_table VALUES (1000000);
-ERROR: could not serialize access due to read/write dependencies among transactions
step wakeup_s2_then_s1: <... completed>
injection_points_wakeup
-----------------------
@@ -100,6 +99,6 @@
inserted
--------
-f
+t
(1 row)
|
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/modules/injection_points/expected/predicate-lock-page-split.out C:/cirru...
--- C:/cirrus/src/test/modules/injection_points/expected/predicate-lock-page-split.out 2026-03-08 19:49:44.655808600 +00...
+++ C:/cirrus/build/testrun/injection_points/isolation/results/predicate-lock-page-split.out 2026-03-08 19:59:11.6585051...
@@ -76,7 +76,6 @@
step s3_insert:
INSERT INTO test_table VALUES (1000000);
-ERROR: could not serialize access due to read/write dependencies among transactions
step wakeup_s2_then_s1: <... completed>
injection_points_wakeup
-----------------------
@@ -100,6 +99,6 @@
inserted
--------
-f
+t
(1 row)
|
|
macOS - Sequoia - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/modules/injection_points/expected/predicate-lock-page-split.out /Users/admin/pgsql/...
--- /Users/admin/pgsql/src/test/modules/injection_points/expected/predicate-lock-page-split.out 2026-03-08 19:49:22
+++ /Users/admin/pgsql/build/testrun/injection_points/isolation/results/predicate-lock-page-split.out 2026-03-08 19:53:3...
@@ -76,7 +76,6 @@
step s3_insert:
INSERT INTO test_table VALUES (1000000);
-ERROR: could not serialize access due to read/write dependencies among transactions
step wakeup_s2_then_s1: <... completed>
injection_points_wakeup
-----------------------
@@ -100,6 +99,6 @@
inserted
--------
-f
+t
(1 row)
|
|
OpenBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/modules/injection_points/expected/predicate-lock-page-split.out /home/postgres...
--- /home/postgres/postgres/src/test/modules/injection_points/expected/predicate-lock-page-split.out Sun Mar 8 19:49:59...
+++ /home/postgres/postgres/build/testrun/injection_points/isolation/results/predicate-lock-page-split.out Sun Mar 8 19...
@@ -76,7 +76,6 @@
step s3_insert:
INSERT INTO test_table VALUES (1000000);
-ERROR: could not serialize access due to read/write dependencies among transactions
step wakeup_s2_then_s1: <... completed>
injection_points_wakeup
-----------------------
@@ -100,6 +99,6 @@
inserted
--------
-f
+t
(1 row)
|
|
Linux - Debian Trixie - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/predicate-lock-page-split.out /tmp/cirrus-ci-bu...
--- /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/predicate-lock-page-split.out 2026-03-08 19:49:33.78...
+++ /tmp/cirrus-ci-build/src/test/modules/injection_points/output_iso/results/predicate-lock-page-split.out 2026-03-08 1...
@@ -76,7 +76,6 @@
step s3_insert:
INSERT INTO test_table VALUES (1000000);
-ERROR: could not serialize access due to read/write dependencies among transactions
step wakeup_s2_then_s1: <... completed>
injection_points_wakeup
-----------------------
@@ -100,6 +99,6 @@
inserted
--------
-f
+t
(1 row)
|
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/predicate-lock-page-split.out /tmp/cirrus-ci-bu...
--- /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/predicate-lock-page-split.out 2026-03-08 19:49:37.75...
+++ /tmp/cirrus-ci-build/build/testrun/injection_points/isolation/results/predicate-lock-page-split.out 2026-03-08 19:53...
@@ -76,7 +76,6 @@
step s3_insert:
INSERT INTO test_table VALUES (1000000);
-ERROR: could not serialize access due to read/write dependencies among transactions
step wakeup_s2_then_s1: <... completed>
injection_points_wakeup
-----------------------
@@ -100,6 +99,6 @@
inserted
--------
-f
+t
(1 row)
|
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/modules/injection_points/expected/predicate-lock-page-split.out /home/postgres...
--- /home/postgres/postgres/src/test/modules/injection_points/expected/predicate-lock-page-split.out 2026-03-08 19:50:01...
+++ /home/postgres/postgres/build/testrun/injection_points/isolation/results/predicate-lock-page-split.out 2026-03-08 19...
@@ -76,7 +76,6 @@
step s3_insert:
INSERT INTO test_table VALUES (1000000);
-ERROR: could not serialize access due to read/write dependencies among transactions
step wakeup_s2_then_s1: <... completed>
injection_points_wakeup
-----------------------
@@ -100,6 +99,6 @@
inserted
--------
-f
+t
(1 row)
|
| 58/6516 |
Optional skipping of unchanged relations during ANALYZE? |
|
Linux - Debian Trixie - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/analyze_missing_stats_only.out /tmp/cirrus-ci-build/build/testru...
--- /tmp/cirrus-ci-build/src/test/regress/expected/analyze_missing_stats_only.out 2026-03-08 14:36:32.482436662 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/analyze_missing_stats_only.out 2026-03-08 ...
@@ -33,65 +33,7 @@
SELECT count(*) AS stat_rows
FROM pg_statistic
WHERE starelid = 'ms1'::regclass;
- stat_rows
------------
- 1
-(1 row)
-
--- 4. Add new column → missing stats for column b
-ALTER TABLE ms1 ADD COLUMN b int;
--- Should analyze again
-ANALYZE (MISSING_STATS_ONLY) ms1;
--- Now both columns should have stats
-SELECT count(*) AS stat_rows
-FROM pg_statistic
-WHERE starelid = 'ms1'::regclass;
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/analyze_missing_stats_only.out /tmp/cirrus-ci-build/build/testru...
--- /tmp/cirrus-ci-build/src/test/regress/expected/analyze_missing_stats_only.out 2026-03-08 14:36:32.482436662 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/analyze_missing_stats_only.out 2026-03-0...
@@ -33,65 +33,7 @@
SELECT count(*) AS stat_rows
FROM pg_statistic
WHERE starelid = 'ms1'::regclass;
- stat_rows
------------
- 1
-(1 row)
-
--- 4. Add new column → missing stats for column b
-ALTER TABLE ms1 ADD COLUMN b int;
--- Should analyze again
-ANALYZE (MISSING_STATS_ONLY) ms1;
--- Now both columns should have stats
-SELECT count(*) AS stat_rows
-FROM pg_statistic
-WHERE starelid = 'ms1'::regclass;
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/analyze_missing_stats_only.out /tmp/cirrus-ci-build/build/testru...
--- /tmp/cirrus-ci-build/src/test/regress/expected/analyze_missing_stats_only.out 2026-03-08 14:36:32.482436662 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/analyze_missing_stats_only.out 2026-03-08 14:40:11.303478...
@@ -33,65 +33,7 @@
SELECT count(*) AS stat_rows
FROM pg_statistic
WHERE starelid = 'ms1'::regclass;
- stat_rows
------------
- 1
-(1 row)
-
--- 4. Add new column → missing stats for column b
-ALTER TABLE ms1 ADD COLUMN b int;
--- Should analyze again
-ANALYZE (MISSING_STATS_ONLY) ms1;
--- Now both columns should have stats
-SELECT count(*) AS stat_rows
-FROM pg_statistic
-WHERE starelid = 'ms1'::regclass;
... |
|
macOS - Sequoia - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/analyze_missing_stats_only.out /Users/admin/pgsql/build/testrun/pg...
--- /Users/admin/pgsql/src/test/regress/expected/analyze_missing_stats_only.out 2026-03-08 14:36:13
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/analyze_missing_stats_only.out 2026-03-08 14...
@@ -33,65 +33,7 @@
SELECT count(*) AS stat_rows
FROM pg_statistic
WHERE starelid = 'ms1'::regclass;
- stat_rows
------------
- 1
-(1 row)
-
--- 4. Add new column → missing stats for column b
-ALTER TABLE ms1 ADD COLUMN b int;
--- Should analyze again
-ANALYZE (MISSING_STATS_ONLY) ms1;
--- Now both columns should have stats
-SELECT count(*) AS stat_rows
-FROM pg_statistic
-WHERE starelid = 'ms1'::regclass;
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/analyze_missing_stats_only.out /Users/admin/pgsql/build/testrun/re...
--- /Users/admin/pgsql/src/test/regress/expected/analyze_missing_stats_only.out 2026-03-08 14:36:13
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/analyze_missing_stats_only.out 2026-03-08 ...
@@ -33,65 +33,7 @@
SELECT count(*) AS stat_rows
FROM pg_statistic
WHERE starelid = 'ms1'::regclass;
- stat_rows
------------
- 1
-(1 row)
-
--- 4. Add new column → missing stats for column b
-ALTER TABLE ms1 ADD COLUMN b int;
--- Should analyze again
-ANALYZE (MISSING_STATS_ONLY) ms1;
--- Now both columns should have stats
-SELECT count(*) AS stat_rows
-FROM pg_statistic
-WHERE starelid = 'ms1'::regclass;
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/analyze_missing_stats_only.out /Users/admin/pgsql/build/testrun/re...
--- /Users/admin/pgsql/src/test/regress/expected/analyze_missing_stats_only.out 2026-03-08 14:36:13
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/analyze_missing_stats_only.out 2026-03-08 14:39:50
@@ -33,65 +33,7 @@
SELECT count(*) AS stat_rows
FROM pg_statistic
WHERE starelid = 'ms1'::regclass;
- stat_rows
------------
- 1
-(1 row)
-
--- 4. Add new column → missing stats for column b
-ALTER TABLE ms1 ADD COLUMN b int;
--- Should analyze again
-ANALYZE (MISSING_STATS_ONLY) ms1;
--- Now both columns should have stats
-SELECT count(*) AS stat_rows
-FROM pg_statistic
-WHERE starelid = 'ms1'::regclass;
... |
|
Windows - Server 2022, MinGW64 - Meson |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/analyze_missing_stats_only.out C:/cirrus/build/testrun/...
--- C:/cirrus/src/test/regress/expected/analyze_missing_stats_only.out 2026-03-08 14:36:52.095687700 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/analyze_missing_stats_only.out 2026-03-08 14:41:17.83...
@@ -33,65 +33,7 @@
SELECT count(*) AS stat_rows
FROM pg_statistic
WHERE starelid = 'ms1'::regclass;
- stat_rows
------------
- 1
-(1 row)
-
--- 4. Add new column → missing stats for column b
-ALTER TABLE ms1 ADD COLUMN b int;
--- Should analyze again
-ANALYZE (MISSING_STATS_ONLY) ms1;
--- Now both columns should have stats
-SELECT count(*) AS stat_rows
-FROM pg_statistic
-WHERE starelid = 'ms1'::regclass;
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/analyze_missing_stats_only.out C:/cirrus/build/testrun/...
--- C:/cirrus/src/test/regress/expected/analyze_missing_stats_only.out 2026-03-08 14:36:52.095687700 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/analyze_missing_stats_only.out 2026-03-08 14:44:11....
@@ -33,65 +33,7 @@
SELECT count(*) AS stat_rows
FROM pg_statistic
WHERE starelid = 'ms1'::regclass;
- stat_rows
------------
- 1
-(1 row)
-
--- 4. Add new column → missing stats for column b
-ALTER TABLE ms1 ADD COLUMN b int;
--- Should analyze again
-ANALYZE (MISSING_STATS_ONLY) ms1;
--- Now both columns should have stats
-SELECT count(*) AS stat_rows
-FROM pg_statistic
-WHERE starelid = 'ms1'::regclass;
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/analyze_missing_stats_only.out C:/cirrus/build/testrun/...
--- C:/cirrus/src/test/regress/expected/analyze_missing_stats_only.out 2026-03-08 14:36:52.095687700 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/analyze_missing_stats_only.out 2026-03-08 14:41:17.520065500 +0000
@@ -33,65 +33,7 @@
SELECT count(*) AS stat_rows
FROM pg_statistic
WHERE starelid = 'ms1'::regclass;
- stat_rows
------------
- 1
-(1 row)
-
--- 4. Add new column → missing stats for column b
-ALTER TABLE ms1 ADD COLUMN b int;
--- Should analyze again
-ANALYZE (MISSING_STATS_ONLY) ms1;
--- Now both columns should have stats
-SELECT count(*) AS stat_rows
-FROM pg_statistic
-WHERE starelid = 'ms1'::regclass;
... |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/analyze_missing_stats_only.out C:/cirrus/build/testrun/...
--- C:/cirrus/src/test/regress/expected/analyze_missing_stats_only.out 2026-03-08 14:36:38.968599600 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/analyze_missing_stats_only.out 2026-03-08 14:40:48.80...
@@ -33,65 +33,7 @@
SELECT count(*) AS stat_rows
FROM pg_statistic
WHERE starelid = 'ms1'::regclass;
- stat_rows
------------
- 1
-(1 row)
-
--- 4. Add new column → missing stats for column b
-ALTER TABLE ms1 ADD COLUMN b int;
--- Should analyze again
-ANALYZE (MISSING_STATS_ONLY) ms1;
--- Now both columns should have stats
-SELECT count(*) AS stat_rows
-FROM pg_statistic
-WHERE starelid = 'ms1'::regclass;
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/analyze_missing_stats_only.out C:/cirrus/build/testrun/...
--- C:/cirrus/src/test/regress/expected/analyze_missing_stats_only.out 2026-03-08 14:36:38.968599600 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/analyze_missing_stats_only.out 2026-03-08 14:43:26....
@@ -33,65 +33,7 @@
SELECT count(*) AS stat_rows
FROM pg_statistic
WHERE starelid = 'ms1'::regclass;
- stat_rows
------------
- 1
-(1 row)
-
--- 4. Add new column → missing stats for column b
-ALTER TABLE ms1 ADD COLUMN b int;
--- Should analyze again
-ANALYZE (MISSING_STATS_ONLY) ms1;
--- Now both columns should have stats
-SELECT count(*) AS stat_rows
-FROM pg_statistic
-WHERE starelid = 'ms1'::regclass;
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/analyze_missing_stats_only.out C:/cirrus/build/testrun/...
--- C:/cirrus/src/test/regress/expected/analyze_missing_stats_only.out 2026-03-08 14:36:38.968599600 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/analyze_missing_stats_only.out 2026-03-08 14:40:48.207782100 +0000
@@ -33,65 +33,7 @@
SELECT count(*) AS stat_rows
FROM pg_statistic
WHERE starelid = 'ms1'::regclass;
- stat_rows
------------
- 1
-(1 row)
-
--- 4. Add new column → missing stats for column b
-ALTER TABLE ms1 ADD COLUMN b int;
--- Should analyze again
-ANALYZE (MISSING_STATS_ONLY) ms1;
--- Now both columns should have stats
-SELECT count(*) AS stat_rows
-FROM pg_statistic
-WHERE starelid = 'ms1'::regclass;
... |
|
OpenBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/analyze_missing_stats_only.out /home/postgres/postgres/build/...
--- /home/postgres/postgres/src/test/regress/expected/analyze_missing_stats_only.out Sun Mar 8 14:36:46 2026
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/analyze_missing_stats_only.out Sun Mar ...
@@ -33,65 +33,7 @@
SELECT count(*) AS stat_rows
FROM pg_statistic
WHERE starelid = 'ms1'::regclass;
- stat_rows
------------
- 1
-(1 row)
-
--- 4. Add new column → missing stats for column b
-ALTER TABLE ms1 ADD COLUMN b int;
--- Should analyze again
-ANALYZE (MISSING_STATS_ONLY) ms1;
--- Now both columns should have stats
-SELECT count(*) AS stat_rows
-FROM pg_statistic
-WHERE starelid = 'ms1'::regclass;
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/analyze_missing_stats_only.out /home/postgres/postgres/build/...
--- /home/postgres/postgres/src/test/regress/expected/analyze_missing_stats_only.out Sun Mar 8 14:36:46 2026
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/analyze_missing_stats_only.out Sun Ma...
@@ -33,65 +33,7 @@
SELECT count(*) AS stat_rows
FROM pg_statistic
WHERE starelid = 'ms1'::regclass;
- stat_rows
------------
- 1
-(1 row)
-
--- 4. Add new column → missing stats for column b
-ALTER TABLE ms1 ADD COLUMN b int;
--- Should analyze again
-ANALYZE (MISSING_STATS_ONLY) ms1;
--- Now both columns should have stats
-SELECT count(*) AS stat_rows
-FROM pg_statistic
-WHERE starelid = 'ms1'::regclass;
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/analyze_missing_stats_only.out /home/postgres/postgres/build/...
--- /home/postgres/postgres/src/test/regress/expected/analyze_missing_stats_only.out Sun Mar 8 14:36:46 2026
+++ /home/postgres/postgres/build/testrun/regress/regress/results/analyze_missing_stats_only.out Sun Mar 8 14:40:06 202...
@@ -33,65 +33,7 @@
SELECT count(*) AS stat_rows
FROM pg_statistic
WHERE starelid = 'ms1'::regclass;
- stat_rows
------------
- 1
-(1 row)
-
--- 4. Add new column → missing stats for column b
-ALTER TABLE ms1 ADD COLUMN b int;
--- Should analyze again
-ANALYZE (MISSING_STATS_ONLY) ms1;
--- Now both columns should have stats
-SELECT count(*) AS stat_rows
-FROM pg_statistic
-WHERE starelid = 'ms1'::regclass;
... |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/analyze_missing_stats_only.out /home/postgres/postgres/build/...
--- /home/postgres/postgres/src/test/regress/expected/analyze_missing_stats_only.out 2026-03-08 14:37:23.967496267 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/analyze_missing_stats_only.out 2026-03-...
@@ -33,65 +33,7 @@
SELECT count(*) AS stat_rows
FROM pg_statistic
WHERE starelid = 'ms1'::regclass;
- stat_rows
------------
- 1
-(1 row)
-
--- 4. Add new column → missing stats for column b
-ALTER TABLE ms1 ADD COLUMN b int;
--- Should analyze again
-ANALYZE (MISSING_STATS_ONLY) ms1;
--- Now both columns should have stats
-SELECT count(*) AS stat_rows
-FROM pg_statistic
-WHERE starelid = 'ms1'::regclass;
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/analyze_missing_stats_only.out /home/postgres/postgres/build/...
--- /home/postgres/postgres/src/test/regress/expected/analyze_missing_stats_only.out 2026-03-08 14:37:23.967496267 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/analyze_missing_stats_only.out 2026-0...
@@ -33,65 +33,7 @@
SELECT count(*) AS stat_rows
FROM pg_statistic
WHERE starelid = 'ms1'::regclass;
- stat_rows
------------
- 1
-(1 row)
-
--- 4. Add new column → missing stats for column b
-ALTER TABLE ms1 ADD COLUMN b int;
--- Should analyze again
-ANALYZE (MISSING_STATS_ONLY) ms1;
--- Now both columns should have stats
-SELECT count(*) AS stat_rows
-FROM pg_statistic
-WHERE starelid = 'ms1'::regclass;
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/analyze_missing_stats_only.out /home/postgres/postgres/build/...
--- /home/postgres/postgres/src/test/regress/expected/analyze_missing_stats_only.out 2026-03-08 14:37:23.967496267 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/analyze_missing_stats_only.out 2026-03-08 14:40:53.848...
@@ -33,65 +33,7 @@
SELECT count(*) AS stat_rows
FROM pg_statistic
WHERE starelid = 'ms1'::regclass;
- stat_rows
------------
- 1
-(1 row)
-
--- 4. Add new column → missing stats for column b
-ALTER TABLE ms1 ADD COLUMN b int;
--- Should analyze again
-ANALYZE (MISSING_STATS_ONLY) ms1;
--- Now both columns should have stats
-SELECT count(*) AS stat_rows
-FROM pg_statistic
-WHERE starelid = 'ms1'::regclass;
... |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/analyze_missing_stats_only.out /tmp/cirrus-ci-build/build/testru...
--- /tmp/cirrus-ci-build/src/test/regress/expected/analyze_missing_stats_only.out 2026-03-08 14:36:33.650521000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/analyze_missing_stats_only.out 2026-03-08 ...
@@ -33,65 +33,7 @@
SELECT count(*) AS stat_rows
FROM pg_statistic
WHERE starelid = 'ms1'::regclass;
- stat_rows
------------
- 1
-(1 row)
-
--- 4. Add new column → missing stats for column b
-ALTER TABLE ms1 ADD COLUMN b int;
--- Should analyze again
-ANALYZE (MISSING_STATS_ONLY) ms1;
--- Now both columns should have stats
-SELECT count(*) AS stat_rows
-FROM pg_statistic
-WHERE starelid = 'ms1'::regclass;
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/analyze_missing_stats_only.out /tmp/cirrus-ci-build/build/testru...
--- /tmp/cirrus-ci-build/src/test/regress/expected/analyze_missing_stats_only.out 2026-03-08 14:36:33.650521000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/analyze_missing_stats_only.out 2026-03-0...
@@ -33,65 +33,7 @@
SELECT count(*) AS stat_rows
FROM pg_statistic
WHERE starelid = 'ms1'::regclass;
- stat_rows
------------
- 1
-(1 row)
-
--- 4. Add new column → missing stats for column b
-ALTER TABLE ms1 ADD COLUMN b int;
--- Should analyze again
-ANALYZE (MISSING_STATS_ONLY) ms1;
--- Now both columns should have stats
-SELECT count(*) AS stat_rows
-FROM pg_statistic
-WHERE starelid = 'ms1'::regclass;
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/analyze_missing_stats_only.out /tmp/cirrus-ci-build/build/testru...
--- /tmp/cirrus-ci-build/src/test/regress/expected/analyze_missing_stats_only.out 2026-03-08 14:36:33.650521000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/analyze_missing_stats_only.out 2026-03-08 14:39:51.790044...
@@ -33,65 +33,7 @@
SELECT count(*) AS stat_rows
FROM pg_statistic
WHERE starelid = 'ms1'::regclass;
- stat_rows
------------
- 1
-(1 row)
-
--- 4. Add new column → missing stats for column b
-ALTER TABLE ms1 ADD COLUMN b int;
--- Should analyze again
-ANALYZE (MISSING_STATS_ONLY) ms1;
--- Now both columns should have stats
-SELECT count(*) AS stat_rows
-FROM pg_statistic
-WHERE starelid = 'ms1'::regclass;
... |
|
Linux - Debian Trixie - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/analyze_missing_stats_only.out /tmp/cirrus-ci-build/src/bin/pg_u...
--- /tmp/cirrus-ci-build/src/test/regress/expected/analyze_missing_stats_only.out 2026-03-08 14:37:01.404428271 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/analyze_missing_stats_only.out 2026-03-08 14:44:26.6191608...
@@ -33,65 +33,7 @@
SELECT count(*) AS stat_rows
FROM pg_statistic
WHERE starelid = 'ms1'::regclass;
- stat_rows
------------
- 1
-(1 row)
-
--- 4. Add new column → missing stats for column b
-ALTER TABLE ms1 ADD COLUMN b int;
--- Should analyze again
-ANALYZE (MISSING_STATS_ONLY) ms1;
--- Now both columns should have stats
-SELECT count(*) AS stat_rows
-FROM pg_statistic
-WHERE starelid = 'ms1'::regclass;
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/analyze_missing_stats_only.out /tmp/cirrus-ci-build/src/test/rec...
--- /tmp/cirrus-ci-build/src/test/regress/expected/analyze_missing_stats_only.out 2026-03-08 14:37:01.404428271 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/analyze_missing_stats_only.out 2026-03-08 14:46:05.60693963...
@@ -33,65 +33,7 @@
SELECT count(*) AS stat_rows
FROM pg_statistic
WHERE starelid = 'ms1'::regclass;
- stat_rows
------------
- 1
-(1 row)
-
--- 4. Add new column → missing stats for column b
-ALTER TABLE ms1 ADD COLUMN b int;
--- Should analyze again
-ANALYZE (MISSING_STATS_ONLY) ms1;
--- Now both columns should have stats
-SELECT count(*) AS stat_rows
-FROM pg_statistic
-WHERE starelid = 'ms1'::regclass;
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/analyze_missing_stats_only.out /tmp/cirrus-ci-build/src/test/reg...
--- /tmp/cirrus-ci-build/src/test/regress/expected/analyze_missing_stats_only.out 2026-03-08 14:37:01.404428271 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/analyze_missing_stats_only.out 2026-03-08 14:42:38.715242944 +0000
@@ -33,65 +33,7 @@
SELECT count(*) AS stat_rows
FROM pg_statistic
WHERE starelid = 'ms1'::regclass;
- stat_rows
------------
- 1
-(1 row)
-
--- 4. Add new column → missing stats for column b
-ALTER TABLE ms1 ADD COLUMN b int;
--- Should analyze again
-ANALYZE (MISSING_STATS_ONLY) ms1;
--- Now both columns should have stats
-SELECT count(*) AS stat_rows
-FROM pg_statistic
-WHERE starelid = 'ms1'::regclass;
... |
| 58/6024 |
Improve read_local_xlog_page_guts by replacing polling with latch-based waiting |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out /tmp/cirrus-ci-build/build/testrun/regress-runn...
--- /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out 2026-03-08 13:10:01.505893000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress-running/regress/results/create_index.out 2026-03-08 13:19:57.718068000 +0...
@@ -2056,7 +2056,7 @@
QUERY PLAN
----------------------------------------------------------------------------
Aggregate
- -> Index Only Scan using tenk1_thous_tenthous on tenk1 t1
+ -> Seq Scan on tenk1 t1
Filter: ((thousand = 42) OR (thousand = (SubPlan expr_1)))
SubPlan expr_1
-> Limit
@@ -2225,9 +2225,11 @@
Filter: ((thousand = 42) OR (thousand = 41) OR (tenthous = 2))
-> Bitmap Index Scan on tenk2_hundred
Index Cond: (hundred = 42)
- -> Index Only Scan using tenk1_hundred on tenk1
- Index Cond: (hundred = 42)
-(9 rows)
+ -> Bitmap Heap Scan on tenk1
... |
| 58/6490 |
Change the default wal_blocksize to 4KB |
|
Windows - Server 2022, MinGW64 - Meson |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/interfaces/ecpg/test/expected/sql-twophase.stderr C:/cirrus/build/testrun/ecp...
--- C:/cirrus/src/interfaces/ecpg/test/expected/sql-twophase.stderr 2026-03-07 12:47:49.469211400 +0000
+++ C:/cirrus/build/testrun/ecpg/ecpg/results/sql-twophase.stderr 2026-03-07 13:01:39.840901500 +0000
@@ -24,11 +24,21 @@
[NO_PID]: sqlca: code: 0, state: 00000
[NO_PID]: ECPGtrans on line 35: action "commit prepared 'ecpg_twophase'"; connection "ecpg1_regression"
[NO_PID]: sqlca: code: 0, state: 00000
+[NO_PID]: ecpg_check_PQresult on line 35: bad response - server closed the connection unexpectedly
+ This probably means the server terminated abnormally
+ before or while processing the request.
+[NO_PID]: sqlca: code: 0, state: 00000
+[NO_PID]: raising sqlstate 57P02 (sqlcode -400): the connection to the server was lost on line 35
+[NO_PID]: sqlca: code: -400, state: 57P02
+SQL error: the connection to the server was lost on line 35
[NO_PID]: ecpg_execute on line 38: query: drop table t1; with 0 parameter(s) on connection ecpg1_regression
[NO_PID]: sqlca: code: 0, state: 00000
[NO_PID]: ecpg_execute on line 38: using PQexec
[NO_PID]: sqlca: code: 0, state: 00000
-[NO_PID]: ecpg_process_output on line 38: OK: DROP TABLE
+[NO_PID]: ecpg_check_PQresult on line 38: no result - no connection to the server
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/isolation/expected/stats.out C:/cirrus/build/testrun/isolation/isolation...
--- C:/cirrus/src/test/isolation/expected/stats.out 2026-03-07 12:47:49.944428300 +0000
+++ C:/cirrus/build/testrun/isolation/isolation/results/stats.out 2026-03-07 13:02:00.664652900 +0000
@@ -1863,95 +1863,7 @@
(1 row)
step s1_commit_prepared_a: COMMIT PREPARED 'a';
-step s1_func_stats:
- SELECT
- tso.name,
- pg_stat_get_function_calls(tso.oid),
- pg_stat_get_function_total_time(tso.oid) > 0 total_above_zero,
- pg_stat_get_function_self_time(tso.oid) > 0 self_above_zero
- FROM test_stat_oid AS tso
- WHERE tso.name = 'test_stat_func'
-
-name |pg_stat_get_function_calls|total_above_zero|self_above_zero
---------------+--------------------------+----------------+---------------
-test_stat_func| | |
-(1 row)
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/pg_logicalinspect/expected/logical_inspect.out C:/cirrus/build/testrun/pg...
--- C:/cirrus/contrib/pg_logicalinspect/expected/logical_inspect.out 2026-03-07 12:47:45.429331000 +0000
+++ C:/cirrus/build/testrun/pg_logicalinspect/isolation/results/logical_inspect.out 2026-03-07 12:59:40.657814400 +0000
@@ -1,32 +1,7 @@
Parsed test spec with 2 sessions
starting permutation: s0_init s0_begin s0_savepoint s0_truncate s1_create_table s1_checkpoint s1_get_changes s1_check_s...
-step s0_init: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding');
-?column?
---------
-init
-(1 row)
+PQconsumeInput failed: server closed the connection unexpectedly
+ This probably means the server terminated abnormally
+ before or while processing the request.
-step s0_begin: BEGIN;
-step s0_savepoint: SAVEPOINT sp1;
-step s0_truncate: TRUNCATE tbl1;
-step s1_create_table: CREATE TABLE tbl2 (val1 integer, val2 integer);
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/pg_stat_statements/expected/utility.out C:/cirrus/build/testrun/pg_stat_s...
--- C:/cirrus/contrib/pg_stat_statements/expected/utility.out 2026-03-07 12:47:45.465801600 +0000
+++ C:/cirrus/build/testrun/pg_stat_statements/regress/results/utility.out 2026-03-07 12:59:45.929821100 +0000
@@ -203,537 +203,7 @@
BEGIN;
PREPARE TRANSACTION 'stat_trans1';
COMMIT PREPARED 'stat_trans1';
-BEGIN;
-PREPARE TRANSACTION 'stat_trans2';
-ROLLBACK PREPARED 'stat_trans2';
-SELECT calls, rows, query FROM pg_stat_statements ORDER BY query COLLATE "C";
- calls | rows | query
--------+------+----------------------------------------------------
- 2 | 0 | BEGIN
- 1 | 0 | COMMIT PREPARED $1
- 2 | 0 | PREPARE TRANSACTION $1
- 1 | 0 | ROLLBACK PREPARED $1
- 1 | 1 | SELECT pg_stat_statements_reset() IS NOT NULL AS t
-(5 rows)
-
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/subselect.out C:/cirrus/build/testrun/pg_upgrade/002_pg...
--- C:/cirrus/src/test/regress/expected/subselect.out 2026-03-07 12:47:50.797663200 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/subselect.out 2026-03-07 12:53:00.407436800 +0000
@@ -1300,2026 +1300,7 @@
create temp table exists_tbl_def partition of exists_tbl default;
insert into exists_tbl select x, x/2, x+1 from generate_series(0,10) x;
analyze exists_tbl;
-explain (costs off)
-select * from exists_tbl t1
- where (exists(select 1 from exists_tbl t2 where t1.c1 = t2.c2) or c3 < 0);
- QUERY PLAN
----------------------------------------------------------------------------
- Append
- -> Seq Scan on exists_tbl_null t1_1
- Filter: (EXISTS(SubPlan exists_1) OR (c3 < 0))
- SubPlan exists_1
- -> Append
- -> Seq Scan on exists_tbl_null t2_1
- Filter: (t1_1.c1 = c2)
- -> Seq Scan on exists_tbl_def t2_2
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/pg_walinspect/expected/pg_walinspect.out C:/cirrus/build/testrun/pg_walin...
--- C:/cirrus/contrib/pg_walinspect/expected/pg_walinspect.out 2026-03-07 12:47:45.550851800 +0000
+++ C:/cirrus/build/testrun/pg_walinspect/regress/results/pg_walinspect.out 2026-03-07 12:59:52.855561600 +0000
@@ -39,235 +39,7 @@
ERROR: WAL input LSN must be less than current LSN
-- Success with end LSNs.
SELECT COUNT(*) >= 1 AS ok FROM pg_get_wal_records_info(:'wal_lsn1', 'FFFFFFFF/FFFFFFFF');
- ok
-----
- t
-(1 row)
-
-SELECT COUNT(*) >= 1 AS ok FROM pg_get_wal_stats(:'wal_lsn1', 'FFFFFFFF/FFFFFFFF');
- ok
-----
- t
-(1 row)
-
-SELECT COUNT(*) >= 1 AS ok FROM pg_get_wal_block_info(:'wal_lsn1', 'FFFFFFFF/FFFFFFFF');
- ok
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/select_distinct.out C:/cirrus/build/testrun/recovery/02...
--- C:/cirrus/src/test/regress/expected/select_distinct.out 2026-03-07 12:47:50.774621600 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/select_distinct.out 2026-03-07 12:55:34.164699900 +...
@@ -596,3 +596,10 @@
RESET enable_hashagg;
DROP TABLE distinct_tbl;
+WARNING: terminating connection because of crash of another server process
+DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because anothe...
+HINT: In a moment you should be able to reconnect to the database and repeat your command.
+server closed the connection unexpectedly
+ This probably means the server terminated abnormally
+ before or while processing the request.
+connection to server was lost
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/subselect.out C:/cirrus/build/testrun/recovery/027_stre...
--- C:/cirrus/src/test/regress/expected/subselect.out 2026-03-07 12:47:50.797663200 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/subselect.out 2026-03-07 12:55:34.164699900 +0000
@@ -2080,1246 +2080,10 @@
drop function explain_sq_limit();
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/aggregates.out C:/cirrus/build/testrun/regress/regress/...
--- C:/cirrus/src/test/regress/expected/aggregates.out 2026-03-07 12:47:50.589928100 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/aggregates.out 2026-03-07 12:52:55.581223800 +0000
@@ -2421,1504 +2421,10 @@
group by y;
-- Ensure results are correct.
select * from v_pagg_test order by y;
- y | tmin | tmax | tndistinct | bmin | bmax | bndistinct | amin | amax | andistinct | aamin | aamax | aandistinct
----+------+------+------------+------+------+------------+------+------+------------+-------+-------+-------------
- 0 | 10 | 5000 | 500 | 10 | 990 | 500 | 10 | 5000 | 500 | 10 | 5000 | 500
- 1 | 11 | 4991 | 250 | 1011 | 991 | 250 | 11 | 4991 | 250 | 11 | 4991 | 250
- 2 | 2 | 4992 | 500 | 1002 | 992 | 500 | 2 | 4992 | 500 | 2 | 4992 | 500
- 3 | 3 | 4983 | 250 | 1003 | 983 | 250 | 3 | 4983 | 250 | 3 | 4983 | 250
- 4 | 4 | 4994 | 500 | 1004 | 994 | 500 | 4 | 4994 | 500 | 4 | 4994 | 500
- 5 | 15 | 4995 | 250 | 1015 | 995 | 250 | 15 | 4995 | 250 | 15 | 4995 | 250
- 6 | 6 | 4996 | 500 | 1006 | 996 | 500 | 6 | 4996 | 500 | 6 | 4996 | 500
- 7 | 7 | 4987 | 250 | 1007 | 987 | 250 | 7 | 4987 | 250 | 7 | 4987 | 250
- 8 | 8 | 4998 | 500 | 1008 | 998 | 500 | 8 | 4998 | 500 | 8 | 4998 | 500
- 9 | 19 | 4999 | 250 | 1019 | 999 | 250 | 19 | 4999 | 250 | 19 | 4999 | 250
-(10 rows)
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/test_decoding/expected/mxact.out C:/cirrus/build/testrun/test_decoding/is...
--- C:/cirrus/contrib/test_decoding/expected/mxact.out 2026-03-07 12:47:45.822670400 +0000
+++ C:/cirrus/build/testrun/test_decoding/isolation/results/mxact.out 2026-03-07 13:00:04.458595200 +0000
@@ -1,90 +1,7 @@
Parsed test spec with 3 sessions
starting permutation: s0init s0start s1begin s1sharepgclass s2begin s2sharepgclass s0w s0start s2commit s1commit
-step s0init: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding');
-?column?
---------
-init
-(1 row)
-
-step s0start: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', 'false');
-data
-----
-(0 rows)
-
-step s1begin: BEGIN;
-step s1sharepgclass: SELECT count(*) > 1 FROM (SELECT * FROM pg_class FOR SHARE) s;
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/test_decoding/expected/ddl.out C:/cirrus/build/testrun/test_decoding/regr...
--- C:/cirrus/contrib/test_decoding/expected/ddl.out 2026-03-07 12:47:45.818723900 +0000
+++ C:/cirrus/build/testrun/test_decoding/regress/results/ddl.out 2026-03-07 13:00:04.270128200 +0000
@@ -1,857 +1,7 @@
-- predictability
SET synchronous_commit = on;
SELECT 'init' FROM pg_create_logical_replication_slot('regression_slot', 'test_decoding');
- ?column?
-----------
- init
-(1 row)
-
--- fail because of an already existing slot
-SELECT 'init' FROM pg_create_logical_replication_slot('regression_slot', 'test_decoding');
-ERROR: replication slot "regression_slot" already exists
--- fail because of an invalid name
-SELECT 'init' FROM pg_create_logical_replication_slot('Invalid Name', 'test_decoding');
-ERROR: replication slot name "Invalid Name" contains invalid character
-HINT: Replication slot names may only contain lower case letters, numbers, and the underscore character.
--- fail twice because of an invalid parameter values
... |
| 58/6388 |
pageinspect support for SpGiST |
|
macOS - Sequoia - Meson |
| regress |
diff -U3 /Users/admin/pgsql/contrib/pageinspect/expected/spgist.out /Users/admin/pgsql/build/testrun/pageinspect/regress...
--- /Users/admin/pgsql/contrib/pageinspect/expected/spgist.out 2026-03-07 11:19:19
+++ /Users/admin/pgsql/build/testrun/pageinspect/regress/results/spgist.out 2026-03-07 11:35:07
@@ -5,40 +5,36 @@
CREATE INDEX test_spgist_idx ON test_gist USING spgist (p);
-- Page 0 is the root, the rest are leaf pages
SELECT * FROM spgist_page_opaque_info(get_raw_page('test_spgist_idx', 0));
- lsn | nplaceholder | nredirection | flags
-------------+--------------+--------------+--------
- 0/00000000 | 0 | 0 | {meta}
-(1 row)
-
+ERROR: function get_raw_page(unknown, integer) does not exist
+LINE 1: SELECT * FROM spgist_page_opaque_info(get_raw_page('test_spg...
+ ^
+DETAIL: There is no function of that name.
SELECT * FROM spgist_page_opaque_info(get_raw_page('test_spgist_idx', 1));
- lsn | nplaceholder | nredirection | flags
-------------+--------------+--------------+-------
- 0/00000000 | 0 | 0 | {}
... |
| 58/6436 |
Add `tsmatch` JSONPath operator for granular Full Text Search |
|
Linux - Debian Trixie - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/jsonb.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_u...
--- /tmp/cirrus-ci-build/src/test/regress/expected/jsonb.out 2026-03-07 05:50:54.668335778 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/jsonb.out 2026-03-07 05:55:17.521732015 +0...
@@ -3000,2955 +3000,10 @@
(1 row)
SELECT count(*) FROM testjsonb WHERE j ? 'public';
- count
--------
- 194
-(1 row)
-
-SELECT count(*) FROM testjsonb WHERE j ? 'bar';
- count
--------
- 0
-(1 row)
-
-SELECT count(*) FROM testjsonb WHERE j ?| ARRAY['public','disabled'];
- count
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/json.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/json.out 2026-03-07 05:50:54.668335778 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/json.out 2026-03-07 05:56:41.297888118 +...
@@ -2056,713 +2056,10 @@
DROP TYPE jsrec_i_not_null;
DROP DOMAIN js_int_not_null;
DROP DOMAIN js_int_array_1d;
-DROP DOMAIN js_int_array_2d;
-DROP DOMAIN j_ordered_pair;
-DROP TYPE j_unordered_pair;
---json_typeof() function
-select value, json_typeof(value)
- from (values (json '123.4'),
- (json '-1'),
- (json '"foo"'),
- (json 'true'),
- (json 'false'),
- (json 'null'),
- (json '[1, 2, 3]'),
- (json '[]'),
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/jsonb.out /tmp/cirrus-ci-build/build/testrun/regress/regress/res...
--- /tmp/cirrus-ci-build/src/test/regress/expected/jsonb.out 2026-03-07 05:50:54.668335778 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/jsonb.out 2026-03-07 05:55:18.113730955 +0000
@@ -2767,3188 +2767,10 @@
SELECT i, jsonb_populate_recordset(row(i,50), '[{"f1":"42"},{"f2":"43"}]')
FROM (VALUES (1),(2)) v(i);
- i | jsonb_populate_recordset
----+--------------------------
- 1 | (42,50)
- 1 | (1,43)
- 2 | (42,50)
- 2 | (2,43)
-(4 rows)
-
-SELECT * FROM
- jsonb_populate_recordset(null::record, '[{"x": 776}]') AS (x int, y int);
- x | y
------+---
- 776 |
... |
| 58/6274 |
Add a greedy join search algorithm to handle large join problems |
|
macOS - Sequoia - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/goo.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade...
--- /Users/admin/pgsql/src/test/regress/expected/goo.out 2026-03-06 14:12:33
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/goo.out 2026-03-06 14:14:45
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/goo.out /Users/admin/pgsql/build/testrun/recovery/027_stream_regre...
--- /Users/admin/pgsql/src/test/regress/expected/goo.out 2026-03-06 14:12:33
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/goo.out 2026-03-06 14:16:24
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/goo.out /Users/admin/pgsql/build/testrun/regress/regress/results/g...
--- /Users/admin/pgsql/src/test/regress/expected/goo.out 2026-03-06 14:12:33
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/goo.out 2026-03-06 14:14:49
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/goo.out C:/cirrus/build/testrun/pg_upgrade/002_pg_upgra...
--- C:/cirrus/src/test/regress/expected/goo.out 2026-03-06 14:12:47.049705300 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/goo.out 2026-03-06 14:16:20.267902200 +0000
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/goo.out C:/cirrus/build/testrun/recovery/027_stream_reg...
--- C:/cirrus/src/test/regress/expected/goo.out 2026-03-06 14:12:47.049705300 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/goo.out 2026-03-06 14:19:19.658931600 +0000
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/goo.out C:/cirrus/build/testrun/regress/regress/results...
--- C:/cirrus/src/test/regress/expected/goo.out 2026-03-06 14:12:47.049705300 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/goo.out 2026-03-06 14:16:21.549146600 +0000
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
|
Windows - Server 2022, MinGW64 - Meson |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/goo.out C:/cirrus/build/testrun/pg_upgrade/002_pg_upgra...
--- C:/cirrus/src/test/regress/expected/goo.out 2026-03-06 14:12:58.408215700 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/goo.out 2026-03-06 14:16:38.983039600 +0000
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/goo.out C:/cirrus/build/testrun/recovery/027_stream_reg...
--- C:/cirrus/src/test/regress/expected/goo.out 2026-03-06 14:12:58.408215700 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/goo.out 2026-03-06 14:20:01.581086900 +0000
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/goo.out C:/cirrus/build/testrun/regress/regress/results...
--- C:/cirrus/src/test/regress/expected/goo.out 2026-03-06 14:12:58.408215700 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/goo.out 2026-03-06 14:16:36.270147700 +0000
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
|
Linux - Debian Trixie - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/goo.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upg...
--- /tmp/cirrus-ci-build/src/test/regress/expected/goo.out 2026-03-06 14:12:43.722897727 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/goo.out 2026-03-06 14:14:57.625128886 +000...
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/goo.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/goo.out 2026-03-06 14:12:43.722897727 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/goo.out 2026-03-06 14:16:19.452805167 +0...
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/goo.out /tmp/cirrus-ci-build/build/testrun/regress/regress/resul...
--- /tmp/cirrus-ci-build/src/test/regress/expected/goo.out 2026-03-06 14:12:43.722897727 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/goo.out 2026-03-06 14:14:54.229003540 +0000
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/goo.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upg...
--- /tmp/cirrus-ci-build/src/test/regress/expected/goo.out 2026-03-06 14:12:49.575276000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/goo.out 2026-03-06 14:15:04.770383000 +000...
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/goo.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/goo.out 2026-03-06 14:12:49.575276000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/goo.out 2026-03-06 14:16:42.595939000 +0...
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/goo.out /tmp/cirrus-ci-build/build/testrun/regress/regress/resul...
--- /tmp/cirrus-ci-build/src/test/regress/expected/goo.out 2026-03-06 14:12:49.575276000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/goo.out 2026-03-06 14:15:06.145073000 +0000
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
|
OpenBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/goo.out /home/postgres/postgres/build/testrun/pg_upgrade/002_...
--- /home/postgres/postgres/src/test/regress/expected/goo.out Fri Mar 6 14:12:58 2026
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/goo.out Fri Mar 6 14:15:37 2026
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/goo.out /home/postgres/postgres/build/testrun/recovery/027_st...
--- /home/postgres/postgres/src/test/regress/expected/goo.out Fri Mar 6 14:12:58 2026
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/goo.out Fri Mar 6 14:18:01 2026
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/goo.out /home/postgres/postgres/build/testrun/regress/regress...
--- /home/postgres/postgres/src/test/regress/expected/goo.out Fri Mar 6 14:12:58 2026
+++ /home/postgres/postgres/build/testrun/regress/regress/results/goo.out Fri Mar 6 14:15:31 2026
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/goo.out /home/postgres/postgres/build/testrun/pg_upgrade/002_...
--- /home/postgres/postgres/src/test/regress/expected/goo.out 2026-03-06 14:13:16.316265615 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/goo.out 2026-03-06 14:15:05.717055672 +...
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/goo.out /home/postgres/postgres/build/testrun/recovery/027_st...
--- /home/postgres/postgres/src/test/regress/expected/goo.out 2026-03-06 14:13:16.316265615 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/goo.out 2026-03-06 14:15:48.215604640...
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/goo.out /home/postgres/postgres/build/testrun/regress/regress...
--- /home/postgres/postgres/src/test/regress/expected/goo.out 2026-03-06 14:13:16.316265615 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/goo.out 2026-03-06 14:15:01.680439652 +0000
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
|
Linux - Debian Trixie - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/goo.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/result...
--- /tmp/cirrus-ci-build/src/test/regress/expected/goo.out 2026-03-06 14:12:52.982518809 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/goo.out 2026-03-06 14:18:40.518184476 +0000
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/goo.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results...
--- /tmp/cirrus-ci-build/src/test/regress/expected/goo.out 2026-03-06 14:12:52.982518809 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/goo.out 2026-03-06 14:20:13.398917940 +0000
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/goo.out /tmp/cirrus-ci-build/src/test/regress/results/goo.out
--- /tmp/cirrus-ci-build/src/test/regress/expected/goo.out 2026-03-06 14:12:52.982518809 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/goo.out 2026-03-06 14:16:16.162215899 +0000
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| 58/6438 |
Introduces pg_stat_recovery system view |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/rules.out C:/cirrus/build/testrun/pg_upgrade/002_pg_upg...
--- C:/cirrus/src/test/regress/expected/rules.out 2026-03-05 13:38:03.975801600 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/rules.out 2026-03-05 13:42:07.356468800 +0000
@@ -2137,7 +2137,7 @@
pause_state,
wal_source
FROM pg_stat_get_recovery() s(promote_triggered, last_replayed_read_lsn, last_replayed_end_lsn, last_replayed_tli, r...
- WHERE (s.promote_triggered IS NOT NULL);
+ WHERE (promote_triggered IS NOT NULL);
pg_stat_recovery_prefetch| SELECT stats_reset,
prefetch,
hit, |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/rules.out C:/cirrus/build/testrun/recovery/027_stream_r...
--- C:/cirrus/src/test/regress/expected/rules.out 2026-03-05 13:38:03.975801600 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/rules.out 2026-03-05 13:45:18.455596400 +0000
@@ -2137,7 +2137,7 @@
pause_state,
wal_source
FROM pg_stat_get_recovery() s(promote_triggered, last_replayed_read_lsn, last_replayed_end_lsn, last_replayed_tli, r...
- WHERE (s.promote_triggered IS NOT NULL);
+ WHERE (promote_triggered IS NOT NULL);
pg_stat_recovery_prefetch| SELECT stats_reset,
prefetch,
hit, |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/rules.out C:/cirrus/build/testrun/regress/regress/resul...
--- C:/cirrus/src/test/regress/expected/rules.out 2026-03-05 13:38:03.975801600 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/rules.out 2026-03-05 13:42:02.622102300 +0000
@@ -2137,7 +2137,7 @@
pause_state,
wal_source
FROM pg_stat_get_recovery() s(promote_triggered, last_replayed_read_lsn, last_replayed_end_lsn, last_replayed_tli, r...
- WHERE (s.promote_triggered IS NOT NULL);
+ WHERE (promote_triggered IS NOT NULL);
pg_stat_recovery_prefetch| SELECT stats_reset,
prefetch,
hit, |
|
Windows - Server 2022, MinGW64 - Meson |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/rules.out C:/cirrus/build/testrun/pg_upgrade/002_pg_upg...
--- C:/cirrus/src/test/regress/expected/rules.out 2026-03-05 13:38:46.331014200 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/rules.out 2026-03-05 13:43:13.565681900 +0000
@@ -2137,7 +2137,7 @@
pause_state,
wal_source
FROM pg_stat_get_recovery() s(promote_triggered, last_replayed_read_lsn, last_replayed_end_lsn, last_replayed_tli, r...
- WHERE (s.promote_triggered IS NOT NULL);
+ WHERE (promote_triggered IS NOT NULL);
pg_stat_recovery_prefetch| SELECT stats_reset,
prefetch,
hit, |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/rules.out C:/cirrus/build/testrun/recovery/027_stream_r...
--- C:/cirrus/src/test/regress/expected/rules.out 2026-03-05 13:38:46.331014200 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/rules.out 2026-03-05 13:46:43.936385700 +0000
@@ -2137,7 +2137,7 @@
pause_state,
wal_source
FROM pg_stat_get_recovery() s(promote_triggered, last_replayed_read_lsn, last_replayed_end_lsn, last_replayed_tli, r...
- WHERE (s.promote_triggered IS NOT NULL);
+ WHERE (promote_triggered IS NOT NULL);
pg_stat_recovery_prefetch| SELECT stats_reset,
prefetch,
hit, |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/rules.out C:/cirrus/build/testrun/regress/regress/resul...
--- C:/cirrus/src/test/regress/expected/rules.out 2026-03-05 13:38:46.331014200 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/rules.out 2026-03-05 13:43:09.668214300 +0000
@@ -2137,7 +2137,7 @@
pause_state,
wal_source
FROM pg_stat_get_recovery() s(promote_triggered, last_replayed_read_lsn, last_replayed_end_lsn, last_replayed_tli, r...
- WHERE (s.promote_triggered IS NOT NULL);
+ WHERE (promote_triggered IS NOT NULL);
pg_stat_recovery_prefetch| SELECT stats_reset,
prefetch,
hit, |
|
macOS - Sequoia - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/rules.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgra...
--- /Users/admin/pgsql/src/test/regress/expected/rules.out 2026-03-05 13:37:45
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/rules.out 2026-03-05 13:42:10
@@ -2137,7 +2137,7 @@
pause_state,
wal_source
FROM pg_stat_get_recovery() s(promote_triggered, last_replayed_read_lsn, last_replayed_end_lsn, last_replayed_tli, r...
- WHERE (s.promote_triggered IS NOT NULL);
+ WHERE (promote_triggered IS NOT NULL);
pg_stat_recovery_prefetch| SELECT stats_reset,
prefetch,
hit, |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/rules.out /Users/admin/pgsql/build/testrun/recovery/027_stream_reg...
--- /Users/admin/pgsql/src/test/regress/expected/rules.out 2026-03-05 13:37:45
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/rules.out 2026-03-05 13:44:44
@@ -2137,7 +2137,7 @@
pause_state,
wal_source
FROM pg_stat_get_recovery() s(promote_triggered, last_replayed_read_lsn, last_replayed_end_lsn, last_replayed_tli, r...
- WHERE (s.promote_triggered IS NOT NULL);
+ WHERE (promote_triggered IS NOT NULL);
pg_stat_recovery_prefetch| SELECT stats_reset,
prefetch,
hit, |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/rules.out /Users/admin/pgsql/build/testrun/regress/regress/results...
--- /Users/admin/pgsql/src/test/regress/expected/rules.out 2026-03-05 13:37:45
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/rules.out 2026-03-05 13:42:07
@@ -2137,7 +2137,7 @@
pause_state,
wal_source
FROM pg_stat_get_recovery() s(promote_triggered, last_replayed_read_lsn, last_replayed_end_lsn, last_replayed_tli, r...
- WHERE (s.promote_triggered IS NOT NULL);
+ WHERE (promote_triggered IS NOT NULL);
pg_stat_recovery_prefetch| SELECT stats_reset,
prefetch,
hit, |
|
Linux - Debian Trixie - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/rules.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_u...
--- /tmp/cirrus-ci-build/src/test/regress/expected/rules.out 2026-03-05 13:38:18.270283413 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/rules.out 2026-03-05 13:42:09.828461569 +0...
@@ -2137,7 +2137,7 @@
pause_state,
wal_source
FROM pg_stat_get_recovery() s(promote_triggered, last_replayed_read_lsn, last_replayed_end_lsn, last_replayed_tli, r...
- WHERE (s.promote_triggered IS NOT NULL);
+ WHERE (promote_triggered IS NOT NULL);
pg_stat_recovery_prefetch| SELECT stats_reset,
prefetch,
hit, |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/rules.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stream...
--- /tmp/cirrus-ci-build/src/test/regress/expected/rules.out 2026-03-05 13:38:18.270283413 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/rules.out 2026-03-05 13:43:37.712479825 ...
@@ -2137,7 +2137,7 @@
pause_state,
wal_source
FROM pg_stat_get_recovery() s(promote_triggered, last_replayed_read_lsn, last_replayed_end_lsn, last_replayed_tli, r...
- WHERE (s.promote_triggered IS NOT NULL);
+ WHERE (promote_triggered IS NOT NULL);
pg_stat_recovery_prefetch| SELECT stats_reset,
prefetch,
hit, |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/rules.out /tmp/cirrus-ci-build/build/testrun/regress/regress/res...
--- /tmp/cirrus-ci-build/src/test/regress/expected/rules.out 2026-03-05 13:38:18.270283413 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/rules.out 2026-03-05 13:42:12.236378638 +0000
@@ -2137,7 +2137,7 @@
pause_state,
wal_source
FROM pg_stat_get_recovery() s(promote_triggered, last_replayed_read_lsn, last_replayed_end_lsn, last_replayed_tli, r...
- WHERE (s.promote_triggered IS NOT NULL);
+ WHERE (promote_triggered IS NOT NULL);
pg_stat_recovery_prefetch| SELECT stats_reset,
prefetch,
hit, |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/rules.out /home/postgres/postgres/build/testrun/pg_upgrade/00...
--- /home/postgres/postgres/src/test/regress/expected/rules.out 2026-03-05 13:38:19.725972967 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/rules.out 2026-03-05 13:41:13.324636632...
@@ -2137,7 +2137,7 @@
pause_state,
wal_source
FROM pg_stat_get_recovery() s(promote_triggered, last_replayed_read_lsn, last_replayed_end_lsn, last_replayed_tli, r...
- WHERE (s.promote_triggered IS NOT NULL);
+ WHERE (promote_triggered IS NOT NULL);
pg_stat_recovery_prefetch| SELECT stats_reset,
prefetch,
hit, |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/rules.out /home/postgres/postgres/build/testrun/recovery/027_...
--- /home/postgres/postgres/src/test/regress/expected/rules.out 2026-03-05 13:38:19.725972967 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/rules.out 2026-03-05 13:41:55.8830575...
@@ -2137,7 +2137,7 @@
pause_state,
wal_source
FROM pg_stat_get_recovery() s(promote_triggered, last_replayed_read_lsn, last_replayed_end_lsn, last_replayed_tli, r...
- WHERE (s.promote_triggered IS NOT NULL);
+ WHERE (promote_triggered IS NOT NULL);
pg_stat_recovery_prefetch| SELECT stats_reset,
prefetch,
hit, |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/rules.out /home/postgres/postgres/build/testrun/regress/regre...
--- /home/postgres/postgres/src/test/regress/expected/rules.out 2026-03-05 13:38:19.725972967 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/rules.out 2026-03-05 13:41:05.669779476 +0000
@@ -2137,7 +2137,7 @@
pause_state,
wal_source
FROM pg_stat_get_recovery() s(promote_triggered, last_replayed_read_lsn, last_replayed_end_lsn, last_replayed_tli, r...
- WHERE (s.promote_triggered IS NOT NULL);
+ WHERE (promote_triggered IS NOT NULL);
pg_stat_recovery_prefetch| SELECT stats_reset,
prefetch,
hit, |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/rules.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_u...
--- /tmp/cirrus-ci-build/src/test/regress/expected/rules.out 2026-03-05 13:39:26.008380000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/rules.out 2026-03-05 13:42:42.101215000 +0...
@@ -2137,7 +2137,7 @@
pause_state,
wal_source
FROM pg_stat_get_recovery() s(promote_triggered, last_replayed_read_lsn, last_replayed_end_lsn, last_replayed_tli, r...
- WHERE (s.promote_triggered IS NOT NULL);
+ WHERE (promote_triggered IS NOT NULL);
pg_stat_recovery_prefetch| SELECT stats_reset,
prefetch,
hit, |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/rules.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stream...
--- /tmp/cirrus-ci-build/src/test/regress/expected/rules.out 2026-03-05 13:39:26.008380000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/rules.out 2026-03-05 13:44:11.157434000 ...
@@ -2137,7 +2137,7 @@
pause_state,
wal_source
FROM pg_stat_get_recovery() s(promote_triggered, last_replayed_read_lsn, last_replayed_end_lsn, last_replayed_tli, r...
- WHERE (s.promote_triggered IS NOT NULL);
+ WHERE (promote_triggered IS NOT NULL);
pg_stat_recovery_prefetch| SELECT stats_reset,
prefetch,
hit, |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/rules.out /tmp/cirrus-ci-build/build/testrun/regress/regress/res...
--- /tmp/cirrus-ci-build/src/test/regress/expected/rules.out 2026-03-05 13:39:26.008380000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/rules.out 2026-03-05 13:42:40.610305000 +0000
@@ -2137,7 +2137,7 @@
pause_state,
wal_source
FROM pg_stat_get_recovery() s(promote_triggered, last_replayed_read_lsn, last_replayed_end_lsn, last_replayed_tli, r...
- WHERE (s.promote_triggered IS NOT NULL);
+ WHERE (promote_triggered IS NOT NULL);
pg_stat_recovery_prefetch| SELECT stats_reset,
prefetch,
hit, |
|
Linux - Debian Trixie - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/rules.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/resu...
--- /tmp/cirrus-ci-build/src/test/regress/expected/rules.out 2026-03-05 13:37:56.195452277 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/rules.out 2026-03-05 13:45:08.475254452 +0000
@@ -2137,7 +2137,7 @@
pause_state,
wal_source
FROM pg_stat_get_recovery() s(promote_triggered, last_replayed_read_lsn, last_replayed_end_lsn, last_replayed_tli, r...
- WHERE (s.promote_triggered IS NOT NULL);
+ WHERE (promote_triggered IS NOT NULL);
pg_stat_recovery_prefetch| SELECT stats_reset,
prefetch,
hit, |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/rules.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check/resul...
--- /tmp/cirrus-ci-build/src/test/regress/expected/rules.out 2026-03-05 13:37:56.195452277 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/rules.out 2026-03-05 13:46:59.810399442 +0000
@@ -2137,7 +2137,7 @@
pause_state,
wal_source
FROM pg_stat_get_recovery() s(promote_triggered, last_replayed_read_lsn, last_replayed_end_lsn, last_replayed_tli, r...
- WHERE (s.promote_triggered IS NOT NULL);
+ WHERE (promote_triggered IS NOT NULL);
pg_stat_recovery_prefetch| SELECT stats_reset,
prefetch,
hit, |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/rules.out /tmp/cirrus-ci-build/src/test/regress/results/rules.ou...
--- /tmp/cirrus-ci-build/src/test/regress/expected/rules.out 2026-03-05 13:37:56.195452277 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/rules.out 2026-03-05 13:43:10.509173746 +0000
@@ -2137,7 +2137,7 @@
pause_state,
wal_source
FROM pg_stat_get_recovery() s(promote_triggered, last_replayed_read_lsn, last_replayed_end_lsn, last_replayed_tli, r...
- WHERE (s.promote_triggered IS NOT NULL);
+ WHERE (promote_triggered IS NOT NULL);
pg_stat_recovery_prefetch| SELECT stats_reset,
prefetch,
hit, |
|
OpenBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/rules.out /home/postgres/postgres/build/testrun/pg_upgrade/00...
--- /home/postgres/postgres/src/test/regress/expected/rules.out Thu Mar 5 13:38:26 2026
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/rules.out Thu Mar 5 13:42:10 2026
@@ -2137,7 +2137,7 @@
pause_state,
wal_source
FROM pg_stat_get_recovery() s(promote_triggered, last_replayed_read_lsn, last_replayed_end_lsn, last_replayed_tli, r...
- WHERE (s.promote_triggered IS NOT NULL);
+ WHERE (promote_triggered IS NOT NULL);
pg_stat_recovery_prefetch| SELECT stats_reset,
prefetch,
hit, |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/rules.out /home/postgres/postgres/build/testrun/recovery/027_...
--- /home/postgres/postgres/src/test/regress/expected/rules.out Thu Mar 5 13:38:26 2026
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/rules.out Thu Mar 5 13:44:17 2026
@@ -2137,7 +2137,7 @@
pause_state,
wal_source
FROM pg_stat_get_recovery() s(promote_triggered, last_replayed_read_lsn, last_replayed_end_lsn, last_replayed_tli, r...
- WHERE (s.promote_triggered IS NOT NULL);
+ WHERE (promote_triggered IS NOT NULL);
pg_stat_recovery_prefetch| SELECT stats_reset,
prefetch,
hit, |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/rules.out /home/postgres/postgres/build/testrun/regress/regre...
--- /home/postgres/postgres/src/test/regress/expected/rules.out Thu Mar 5 13:38:26 2026
+++ /home/postgres/postgres/build/testrun/regress/regress/results/rules.out Thu Mar 5 13:42:05 2026
@@ -2137,7 +2137,7 @@
pause_state,
wal_source
FROM pg_stat_get_recovery() s(promote_triggered, last_replayed_read_lsn, last_replayed_end_lsn, last_replayed_tli, r...
- WHERE (s.promote_triggered IS NOT NULL);
+ WHERE (promote_triggered IS NOT NULL);
pg_stat_recovery_prefetch| SELECT stats_reset,
prefetch,
hit, |
| 58/6410 |
Enhance btree's pageinspect |
|
Windows - Server 2022, MinGW64 - Meson |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/pageinspect/expected/btree.out C:/cirrus/build/testrun/pageinspect/regres...
--- C:/cirrus/contrib/pageinspect/expected/btree.out 2026-03-01 12:30:29.368101900 +0000
+++ C:/cirrus/build/testrun/pageinspect/regress/results/btree.out 2026-03-01 12:39:47.054528900 +0000
@@ -148,23 +148,25 @@
ERROR: block number 7 is out of range
DROP TABLE test2;
SELECT * FROM bt_page_items('test1_a_idx', -1);
-ERROR: invalid block number -1
+ERROR: function bt_page_items(unknown, integer) does not exist
+LINE 1: SELECT * FROM bt_page_items('test1_a_idx', -1);
+ ^
+DETAIL: No function of that name accepts the given number of arguments.
SELECT * FROM bt_page_items('test1_a_idx', 0);
-ERROR: block 0 is a meta page
+ERROR: function bt_page_items(unknown, integer) does not exist
+LINE 1: SELECT * FROM bt_page_items('test1_a_idx', 0);
+ ^
+DETAIL: No function of that name accepts the given number of arguments.
SELECT * FROM bt_page_items('test1_a_idx', 1);
--[ RECORD 1 ]-----------------------
... |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/pageinspect/expected/btree.out C:/cirrus/build/testrun/pageinspect/regres...
--- C:/cirrus/contrib/pageinspect/expected/btree.out 2026-03-01 12:30:37.648379600 +0000
+++ C:/cirrus/build/testrun/pageinspect/regress/results/btree.out 2026-03-01 12:39:28.003834700 +0000
@@ -148,23 +148,25 @@
ERROR: block number 7 is out of range
DROP TABLE test2;
SELECT * FROM bt_page_items('test1_a_idx', -1);
-ERROR: invalid block number -1
+ERROR: function bt_page_items(unknown, integer) does not exist
+LINE 1: SELECT * FROM bt_page_items('test1_a_idx', -1);
+ ^
+DETAIL: No function of that name accepts the given number of arguments.
SELECT * FROM bt_page_items('test1_a_idx', 0);
-ERROR: block 0 is a meta page
+ERROR: function bt_page_items(unknown, integer) does not exist
+LINE 1: SELECT * FROM bt_page_items('test1_a_idx', 0);
+ ^
+DETAIL: No function of that name accepts the given number of arguments.
SELECT * FROM bt_page_items('test1_a_idx', 1);
--[ RECORD 1 ]-----------------------
... |
|
macOS - Sequoia - Meson |
| regress |
diff -U3 /Users/admin/pgsql/contrib/pageinspect/expected/btree.out /Users/admin/pgsql/build/testrun/pageinspect/regress/...
--- /Users/admin/pgsql/contrib/pageinspect/expected/btree.out 2026-03-01 12:30:14
+++ /Users/admin/pgsql/build/testrun/pageinspect/regress/results/btree.out 2026-03-01 12:35:14
@@ -148,23 +148,25 @@
ERROR: block number 7 is out of range
DROP TABLE test2;
SELECT * FROM bt_page_items('test1_a_idx', -1);
-ERROR: invalid block number -1
+ERROR: function bt_page_items(unknown, integer) does not exist
+LINE 1: SELECT * FROM bt_page_items('test1_a_idx', -1);
+ ^
+DETAIL: No function of that name accepts the given number of arguments.
SELECT * FROM bt_page_items('test1_a_idx', 0);
-ERROR: block 0 is a meta page
+ERROR: function bt_page_items(unknown, integer) does not exist
+LINE 1: SELECT * FROM bt_page_items('test1_a_idx', 0);
+ ^
+DETAIL: No function of that name accepts the given number of arguments.
SELECT * FROM bt_page_items('test1_a_idx', 1);
--[ RECORD 1 ]-----------------------
... |
|
Linux - Debian Trixie - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/pageinspect/expected/btree.out /tmp/cirrus-ci-build/build/testrun/pageinspect/regr...
--- /tmp/cirrus-ci-build/contrib/pageinspect/expected/btree.out 2026-03-01 12:30:31.330367242 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pageinspect/regress/results/btree.out 2026-03-01 12:34:24.409883607 +0000
@@ -148,23 +148,25 @@
ERROR: block number 7 is out of range
DROP TABLE test2;
SELECT * FROM bt_page_items('test1_a_idx', -1);
-ERROR: invalid block number -1
+ERROR: function bt_page_items(unknown, integer) does not exist
+LINE 1: SELECT * FROM bt_page_items('test1_a_idx', -1);
+ ^
+DETAIL: No function of that name accepts the given number of arguments.
SELECT * FROM bt_page_items('test1_a_idx', 0);
-ERROR: block 0 is a meta page
+ERROR: function bt_page_items(unknown, integer) does not exist
+LINE 1: SELECT * FROM bt_page_items('test1_a_idx', 0);
+ ^
+DETAIL: No function of that name accepts the given number of arguments.
SELECT * FROM bt_page_items('test1_a_idx', 1);
--[ RECORD 1 ]-----------------------
... |
|
Linux - Debian Trixie - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/pageinspect/expected/btree.out /tmp/cirrus-ci-build/contrib/pageinspect/results/bt...
--- /tmp/cirrus-ci-build/contrib/pageinspect/expected/btree.out 2026-03-01 12:30:31.225607995 +0000
+++ /tmp/cirrus-ci-build/contrib/pageinspect/results/btree.out 2026-03-01 12:34:56.860619840 +0000
@@ -148,23 +148,25 @@
ERROR: block number 7 is out of range
DROP TABLE test2;
SELECT * FROM bt_page_items('test1_a_idx', -1);
-ERROR: invalid block number -1
+ERROR: function bt_page_items(unknown, integer) does not exist
+LINE 1: SELECT * FROM bt_page_items('test1_a_idx', -1);
+ ^
+DETAIL: No function of that name accepts the given number of arguments.
SELECT * FROM bt_page_items('test1_a_idx', 0);
-ERROR: block 0 is a meta page
+ERROR: function bt_page_items(unknown, integer) does not exist
+LINE 1: SELECT * FROM bt_page_items('test1_a_idx', 0);
+ ^
+DETAIL: No function of that name accepts the given number of arguments.
SELECT * FROM bt_page_items('test1_a_idx', 1);
--[ RECORD 1 ]-----------------------
... |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/pageinspect/expected/btree.out /tmp/cirrus-ci-build/build/testrun/pageinspect/regr...
--- /tmp/cirrus-ci-build/contrib/pageinspect/expected/btree.out 2026-03-01 12:30:34.467812000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pageinspect/regress/results/btree.out 2026-03-01 12:33:38.476111000 +0000
@@ -148,23 +148,25 @@
ERROR: block number 7 is out of range
DROP TABLE test2;
SELECT * FROM bt_page_items('test1_a_idx', -1);
-ERROR: invalid block number -1
+ERROR: function bt_page_items(unknown, integer) does not exist
+LINE 1: SELECT * FROM bt_page_items('test1_a_idx', -1);
+ ^
+DETAIL: No function of that name accepts the given number of arguments.
SELECT * FROM bt_page_items('test1_a_idx', 0);
-ERROR: block 0 is a meta page
+ERROR: function bt_page_items(unknown, integer) does not exist
+LINE 1: SELECT * FROM bt_page_items('test1_a_idx', 0);
+ ^
+DETAIL: No function of that name accepts the given number of arguments.
SELECT * FROM bt_page_items('test1_a_idx', 1);
--[ RECORD 1 ]-----------------------
... |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/contrib/pageinspect/expected/btree.out /home/postgres/postgres/build/testrun/pageinspec...
--- /home/postgres/postgres/contrib/pageinspect/expected/btree.out 2026-03-01 12:30:42.089549037 +0000
+++ /home/postgres/postgres/build/testrun/pageinspect/regress/results/btree.out 2026-03-01 12:33:10.359036479 +0000
@@ -148,23 +148,25 @@
ERROR: block number 7 is out of range
DROP TABLE test2;
SELECT * FROM bt_page_items('test1_a_idx', -1);
-ERROR: invalid block number -1
+ERROR: function bt_page_items(unknown, integer) does not exist
+LINE 1: SELECT * FROM bt_page_items('test1_a_idx', -1);
+ ^
+DETAIL: No function of that name accepts the given number of arguments.
SELECT * FROM bt_page_items('test1_a_idx', 0);
-ERROR: block 0 is a meta page
+ERROR: function bt_page_items(unknown, integer) does not exist
+LINE 1: SELECT * FROM bt_page_items('test1_a_idx', 0);
+ ^
+DETAIL: No function of that name accepts the given number of arguments.
SELECT * FROM bt_page_items('test1_a_idx', 1);
--[ RECORD 1 ]-----------------------
... |
|
OpenBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/contrib/pageinspect/expected/btree.out /home/postgres/postgres/build/testrun/pageinspec...
--- /home/postgres/postgres/contrib/pageinspect/expected/btree.out Sun Mar 1 12:30:50 2026
+++ /home/postgres/postgres/build/testrun/pageinspect/regress/results/btree.out Sun Mar 1 12:35:44 2026
@@ -148,23 +148,25 @@
ERROR: block number 7 is out of range
DROP TABLE test2;
SELECT * FROM bt_page_items('test1_a_idx', -1);
-ERROR: invalid block number -1
+ERROR: function bt_page_items(unknown, integer) does not exist
+LINE 1: SELECT * FROM bt_page_items('test1_a_idx', -1);
+ ^
+DETAIL: No function of that name accepts the given number of arguments.
SELECT * FROM bt_page_items('test1_a_idx', 0);
-ERROR: block 0 is a meta page
+ERROR: function bt_page_items(unknown, integer) does not exist
+LINE 1: SELECT * FROM bt_page_items('test1_a_idx', 0);
+ ^
+DETAIL: No function of that name accepts the given number of arguments.
SELECT * FROM bt_page_items('test1_a_idx', 1);
--[ RECORD 1 ]-----------------------
... |
| 54/5087 |
Doc: Move and modify standalone hot backups section |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/contrib/postgres_fdw/expected/query_cancel.out /home/postgres/postgres/build/testrun/po...
--- /home/postgres/postgres/contrib/postgres_fdw/expected/query_cancel.out 2026-02-28 22:03:49.812858512 +0000
+++ /home/postgres/postgres/build/testrun/postgres_fdw/regress/results/query_cancel.out 2026-02-28 22:11:07.097715363 +0...
@@ -30,5 +30,5 @@
SET LOCAL statement_timeout = '10ms';
-- This would take very long if not canceled:
SELECT count(*) FROM ft1 a CROSS JOIN ft1 b CROSS JOIN ft1 c CROSS JOIN ft1 d;
-ERROR: canceling statement due to statement timeout
+ERROR: canceling statement due to user request
COMMIT; |
| 58/5018 |
Extension security improvement: Add support for extensions with an owned schema |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/modules/test_extensions/expected/test_extensions.out /tmp/cirrus-ci-build/build/t...
--- /tmp/cirrus-ci-build/src/test/modules/test_extensions/expected/test_extensions.out 2026-02-28 16:56:17.634540000 +00...
+++ /tmp/cirrus-ci-build/build/testrun/test_extensions/regress/results/test_extensions.out 2026-02-28 17:00:43.053007000...
@@ -755,6 +755,7 @@
ERROR: schema "some_other_name" does not exist
-- Test owned_schema + superuser=false extension
CREATE USER test_ext_user;
+WARNING: roles created by regression test cases should have names starting with "regress_"
GRANT CREATE ON DATABASE regression_test_extensions TO test_ext_user;
SET SESSION AUTHORIZATION test_ext_user;
CREATE EXTENSION test_ext_owned_schema_nosuperuser; |
|
Linux - Debian Trixie - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/modules/test_extensions/expected/test_extensions.out /tmp/cirrus-ci-build/src/tes...
--- /tmp/cirrus-ci-build/src/test/modules/test_extensions/expected/test_extensions.out 2026-02-28 16:56:09.560656340 +00...
+++ /tmp/cirrus-ci-build/src/test/modules/test_extensions/results/test_extensions.out 2026-02-28 17:01:48.620247767 +000...
@@ -756,71 +756,48 @@
-- Test owned_schema + superuser=false extension
CREATE USER test_ext_user;
GRANT CREATE ON DATABASE regression_test_extensions TO test_ext_user;
+ERROR: database "regression_test_extensions" does not exist
SET SESSION AUTHORIZATION test_ext_user;
CREATE EXTENSION test_ext_owned_schema_nosuperuser;
+ERROR: permission denied for database contrib_regression
\dx+ test_ext_owned_schema_nosuperuser;
-Objects in extension "test_ext_owned_schema_nosuperuser"
- Object description
--------------------------------------------------
- function test_owned_schema_nosuperuser.owned1()
- schema test_owned_schema_nosuperuser
-(2 rows)
-
-- Check that schema is owned by the creating user (not bootstrap superuser)
... |
| 58/6180 |
minor error message enhance: print RLS policy name when only one permissive policy exists |
|
Linux - Debian Trixie - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/rowsecurity.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/00...
--- /tmp/cirrus-ci-build/src/test/regress/expected/rowsecurity.out 2026-02-28 08:30:46.715619481 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/rowsecurity.out 2026-02-28 08:32:38.853764...
@@ -2462,7 +2462,7 @@
-- DO SELECT requires SELECT rights, should fail for non-novel
INSERT INTO document VALUES (33, (SELECT cid from category WHERE cname = 'science fiction'), 1, 'regress_rls_bob', 'ano...
ON CONFLICT (did) DO SELECT RETURNING did, dauthor, dtitle;
-ERROR: new row violates row-level security policy for table "document"
+ERROR: new row violates row-level security policy "p1_select_novels" for table "document"
-- DO SELECT with WHERE and EXCLUDED reference
INSERT INTO document VALUES (1, (SELECT cid from category WHERE cname = 'novel'), 1, 'regress_rls_bob', 'another novel'...
ON CONFLICT (did) DO SELECT WHERE excluded.dlevel = 1 RETURNING did, dauthor, dtitle;
@@ -2482,7 +2482,7 @@
-- should fail UPDATE USING policy for novel with dlevel = 2
INSERT INTO document VALUES (2, (SELECT cid from category WHERE cname = 'novel'), 1, 'regress_rls_bob', 'another novel'...
ON CONFLICT (did) DO SELECT FOR UPDATE RETURNING did, dauthor, dtitle;
-ERROR: new row violates row-level security policy (USING expression) for table "document"
+ERROR: new row violates row-level security policy "p3_update_novels" (USING expression) for table "document"
SET SESSION AUTHORIZATION regress_rls_alice;
DROP POLICY p1_select_novels ON document;
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/rowsecurity.out /tmp/cirrus-ci-build/build/testrun/recovery/027_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/rowsecurity.out 2026-02-28 08:30:46.715619481 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/rowsecurity.out 2026-02-28 08:34:04.8368...
@@ -2462,7 +2462,7 @@
-- DO SELECT requires SELECT rights, should fail for non-novel
INSERT INTO document VALUES (33, (SELECT cid from category WHERE cname = 'science fiction'), 1, 'regress_rls_bob', 'ano...
ON CONFLICT (did) DO SELECT RETURNING did, dauthor, dtitle;
-ERROR: new row violates row-level security policy for table "document"
+ERROR: new row violates row-level security policy "p1_select_novels" for table "document"
-- DO SELECT with WHERE and EXCLUDED reference
INSERT INTO document VALUES (1, (SELECT cid from category WHERE cname = 'novel'), 1, 'regress_rls_bob', 'another novel'...
ON CONFLICT (did) DO SELECT WHERE excluded.dlevel = 1 RETURNING did, dauthor, dtitle;
@@ -2482,7 +2482,7 @@
-- should fail UPDATE USING policy for novel with dlevel = 2
INSERT INTO document VALUES (2, (SELECT cid from category WHERE cname = 'novel'), 1, 'regress_rls_bob', 'another novel'...
ON CONFLICT (did) DO SELECT FOR UPDATE RETURNING did, dauthor, dtitle;
-ERROR: new row violates row-level security policy (USING expression) for table "document"
+ERROR: new row violates row-level security policy "p3_update_novels" (USING expression) for table "document"
SET SESSION AUTHORIZATION regress_rls_alice;
DROP POLICY p1_select_novels ON document;
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/rowsecurity.out /tmp/cirrus-ci-build/build/testrun/regress/regre...
--- /tmp/cirrus-ci-build/src/test/regress/expected/rowsecurity.out 2026-02-28 08:30:46.715619481 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/rowsecurity.out 2026-02-28 08:32:38.621729764 +0000
@@ -2462,7 +2462,7 @@
-- DO SELECT requires SELECT rights, should fail for non-novel
INSERT INTO document VALUES (33, (SELECT cid from category WHERE cname = 'science fiction'), 1, 'regress_rls_bob', 'ano...
ON CONFLICT (did) DO SELECT RETURNING did, dauthor, dtitle;
-ERROR: new row violates row-level security policy for table "document"
+ERROR: new row violates row-level security policy "p1_select_novels" for table "document"
-- DO SELECT with WHERE and EXCLUDED reference
INSERT INTO document VALUES (1, (SELECT cid from category WHERE cname = 'novel'), 1, 'regress_rls_bob', 'another novel'...
ON CONFLICT (did) DO SELECT WHERE excluded.dlevel = 1 RETURNING did, dauthor, dtitle;
@@ -2482,7 +2482,7 @@
-- should fail UPDATE USING policy for novel with dlevel = 2
INSERT INTO document VALUES (2, (SELECT cid from category WHERE cname = 'novel'), 1, 'regress_rls_bob', 'another novel'...
ON CONFLICT (did) DO SELECT FOR UPDATE RETURNING did, dauthor, dtitle;
-ERROR: new row violates row-level security policy (USING expression) for table "document"
+ERROR: new row violates row-level security policy "p3_update_novels" (USING expression) for table "document"
SET SESSION AUTHORIZATION regress_rls_alice;
DROP POLICY p1_select_novels ON document;
... |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/rowsecurity.out C:/cirrus/build/testrun/pg_upgrade/002_...
--- C:/cirrus/src/test/regress/expected/rowsecurity.out 2026-02-28 08:30:50.642559800 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/rowsecurity.out 2026-02-28 08:34:17.627507400 +0000
@@ -2462,7 +2462,7 @@
-- DO SELECT requires SELECT rights, should fail for non-novel
INSERT INTO document VALUES (33, (SELECT cid from category WHERE cname = 'science fiction'), 1, 'regress_rls_bob', 'ano...
ON CONFLICT (did) DO SELECT RETURNING did, dauthor, dtitle;
-ERROR: new row violates row-level security policy for table "document"
+ERROR: new row violates row-level security policy "p1_select_novels" for table "document"
-- DO SELECT with WHERE and EXCLUDED reference
INSERT INTO document VALUES (1, (SELECT cid from category WHERE cname = 'novel'), 1, 'regress_rls_bob', 'another novel'...
ON CONFLICT (did) DO SELECT WHERE excluded.dlevel = 1 RETURNING did, dauthor, dtitle;
@@ -2482,7 +2482,7 @@
-- should fail UPDATE USING policy for novel with dlevel = 2
INSERT INTO document VALUES (2, (SELECT cid from category WHERE cname = 'novel'), 1, 'regress_rls_bob', 'another novel'...
ON CONFLICT (did) DO SELECT FOR UPDATE RETURNING did, dauthor, dtitle;
-ERROR: new row violates row-level security policy (USING expression) for table "document"
+ERROR: new row violates row-level security policy "p3_update_novels" (USING expression) for table "document"
SET SESSION AUTHORIZATION regress_rls_alice;
DROP POLICY p1_select_novels ON document;
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/rowsecurity.out C:/cirrus/build/testrun/recovery/027_st...
--- C:/cirrus/src/test/regress/expected/rowsecurity.out 2026-02-28 08:30:50.642559800 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/rowsecurity.out 2026-02-28 08:37:42.826751300 +0000
@@ -2462,7 +2462,7 @@
-- DO SELECT requires SELECT rights, should fail for non-novel
INSERT INTO document VALUES (33, (SELECT cid from category WHERE cname = 'science fiction'), 1, 'regress_rls_bob', 'ano...
ON CONFLICT (did) DO SELECT RETURNING did, dauthor, dtitle;
-ERROR: new row violates row-level security policy for table "document"
+ERROR: new row violates row-level security policy "p1_select_novels" for table "document"
-- DO SELECT with WHERE and EXCLUDED reference
INSERT INTO document VALUES (1, (SELECT cid from category WHERE cname = 'novel'), 1, 'regress_rls_bob', 'another novel'...
ON CONFLICT (did) DO SELECT WHERE excluded.dlevel = 1 RETURNING did, dauthor, dtitle;
@@ -2482,7 +2482,7 @@
-- should fail UPDATE USING policy for novel with dlevel = 2
INSERT INTO document VALUES (2, (SELECT cid from category WHERE cname = 'novel'), 1, 'regress_rls_bob', 'another novel'...
ON CONFLICT (did) DO SELECT FOR UPDATE RETURNING did, dauthor, dtitle;
-ERROR: new row violates row-level security policy (USING expression) for table "document"
+ERROR: new row violates row-level security policy "p3_update_novels" (USING expression) for table "document"
SET SESSION AUTHORIZATION regress_rls_alice;
DROP POLICY p1_select_novels ON document;
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/rowsecurity.out C:/cirrus/build/testrun/regress/regress...
--- C:/cirrus/src/test/regress/expected/rowsecurity.out 2026-02-28 08:30:50.642559800 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/rowsecurity.out 2026-02-28 08:34:10.114331800 +0000
@@ -2462,7 +2462,7 @@
-- DO SELECT requires SELECT rights, should fail for non-novel
INSERT INTO document VALUES (33, (SELECT cid from category WHERE cname = 'science fiction'), 1, 'regress_rls_bob', 'ano...
ON CONFLICT (did) DO SELECT RETURNING did, dauthor, dtitle;
-ERROR: new row violates row-level security policy for table "document"
+ERROR: new row violates row-level security policy "p1_select_novels" for table "document"
-- DO SELECT with WHERE and EXCLUDED reference
INSERT INTO document VALUES (1, (SELECT cid from category WHERE cname = 'novel'), 1, 'regress_rls_bob', 'another novel'...
ON CONFLICT (did) DO SELECT WHERE excluded.dlevel = 1 RETURNING did, dauthor, dtitle;
@@ -2482,7 +2482,7 @@
-- should fail UPDATE USING policy for novel with dlevel = 2
INSERT INTO document VALUES (2, (SELECT cid from category WHERE cname = 'novel'), 1, 'regress_rls_bob', 'another novel'...
ON CONFLICT (did) DO SELECT FOR UPDATE RETURNING did, dauthor, dtitle;
-ERROR: new row violates row-level security policy (USING expression) for table "document"
+ERROR: new row violates row-level security policy "p3_update_novels" (USING expression) for table "document"
SET SESSION AUTHORIZATION regress_rls_alice;
DROP POLICY p1_select_novels ON document;
... |
|
Windows - Server 2022, MinGW64 - Meson |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/rowsecurity.out C:/cirrus/build/testrun/pg_upgrade/002_...
--- C:/cirrus/src/test/regress/expected/rowsecurity.out 2026-02-28 08:31:02.688061100 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/rowsecurity.out 2026-02-28 08:33:47.663571500 +0000
@@ -2462,7 +2462,7 @@
-- DO SELECT requires SELECT rights, should fail for non-novel
INSERT INTO document VALUES (33, (SELECT cid from category WHERE cname = 'science fiction'), 1, 'regress_rls_bob', 'ano...
ON CONFLICT (did) DO SELECT RETURNING did, dauthor, dtitle;
-ERROR: new row violates row-level security policy for table "document"
+ERROR: new row violates row-level security policy "p1_select_novels" for table "document"
-- DO SELECT with WHERE and EXCLUDED reference
INSERT INTO document VALUES (1, (SELECT cid from category WHERE cname = 'novel'), 1, 'regress_rls_bob', 'another novel'...
ON CONFLICT (did) DO SELECT WHERE excluded.dlevel = 1 RETURNING did, dauthor, dtitle;
@@ -2482,7 +2482,7 @@
-- should fail UPDATE USING policy for novel with dlevel = 2
INSERT INTO document VALUES (2, (SELECT cid from category WHERE cname = 'novel'), 1, 'regress_rls_bob', 'another novel'...
ON CONFLICT (did) DO SELECT FOR UPDATE RETURNING did, dauthor, dtitle;
-ERROR: new row violates row-level security policy (USING expression) for table "document"
+ERROR: new row violates row-level security policy "p3_update_novels" (USING expression) for table "document"
SET SESSION AUTHORIZATION regress_rls_alice;
DROP POLICY p1_select_novels ON document;
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/rowsecurity.out C:/cirrus/build/testrun/recovery/027_st...
--- C:/cirrus/src/test/regress/expected/rowsecurity.out 2026-02-28 08:31:02.688061100 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/rowsecurity.out 2026-02-28 08:37:30.120534700 +0000
@@ -2462,7 +2462,7 @@
-- DO SELECT requires SELECT rights, should fail for non-novel
INSERT INTO document VALUES (33, (SELECT cid from category WHERE cname = 'science fiction'), 1, 'regress_rls_bob', 'ano...
ON CONFLICT (did) DO SELECT RETURNING did, dauthor, dtitle;
-ERROR: new row violates row-level security policy for table "document"
+ERROR: new row violates row-level security policy "p1_select_novels" for table "document"
-- DO SELECT with WHERE and EXCLUDED reference
INSERT INTO document VALUES (1, (SELECT cid from category WHERE cname = 'novel'), 1, 'regress_rls_bob', 'another novel'...
ON CONFLICT (did) DO SELECT WHERE excluded.dlevel = 1 RETURNING did, dauthor, dtitle;
@@ -2482,7 +2482,7 @@
-- should fail UPDATE USING policy for novel with dlevel = 2
INSERT INTO document VALUES (2, (SELECT cid from category WHERE cname = 'novel'), 1, 'regress_rls_bob', 'another novel'...
ON CONFLICT (did) DO SELECT FOR UPDATE RETURNING did, dauthor, dtitle;
-ERROR: new row violates row-level security policy (USING expression) for table "document"
+ERROR: new row violates row-level security policy "p3_update_novels" (USING expression) for table "document"
SET SESSION AUTHORIZATION regress_rls_alice;
DROP POLICY p1_select_novels ON document;
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/rowsecurity.out C:/cirrus/build/testrun/regress/regress...
--- C:/cirrus/src/test/regress/expected/rowsecurity.out 2026-02-28 08:31:02.688061100 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/rowsecurity.out 2026-02-28 08:33:41.846662300 +0000
@@ -2462,7 +2462,7 @@
-- DO SELECT requires SELECT rights, should fail for non-novel
INSERT INTO document VALUES (33, (SELECT cid from category WHERE cname = 'science fiction'), 1, 'regress_rls_bob', 'ano...
ON CONFLICT (did) DO SELECT RETURNING did, dauthor, dtitle;
-ERROR: new row violates row-level security policy for table "document"
+ERROR: new row violates row-level security policy "p1_select_novels" for table "document"
-- DO SELECT with WHERE and EXCLUDED reference
INSERT INTO document VALUES (1, (SELECT cid from category WHERE cname = 'novel'), 1, 'regress_rls_bob', 'another novel'...
ON CONFLICT (did) DO SELECT WHERE excluded.dlevel = 1 RETURNING did, dauthor, dtitle;
@@ -2482,7 +2482,7 @@
-- should fail UPDATE USING policy for novel with dlevel = 2
INSERT INTO document VALUES (2, (SELECT cid from category WHERE cname = 'novel'), 1, 'regress_rls_bob', 'another novel'...
ON CONFLICT (did) DO SELECT FOR UPDATE RETURNING did, dauthor, dtitle;
-ERROR: new row violates row-level security policy (USING expression) for table "document"
+ERROR: new row violates row-level security policy "p3_update_novels" (USING expression) for table "document"
SET SESSION AUTHORIZATION regress_rls_alice;
DROP POLICY p1_select_novels ON document;
... |
|
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 2026-02-28 08:30:50
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/rowsecurity.out 2026-02-28 08:34:20
@@ -2462,7 +2462,7 @@
-- DO SELECT requires SELECT rights, should fail for non-novel
INSERT INTO document VALUES (33, (SELECT cid from category WHERE cname = 'science fiction'), 1, 'regress_rls_bob', 'ano...
ON CONFLICT (did) DO SELECT RETURNING did, dauthor, dtitle;
-ERROR: new row violates row-level security policy for table "document"
+ERROR: new row violates row-level security policy "p1_select_novels" for table "document"
-- DO SELECT with WHERE and EXCLUDED reference
INSERT INTO document VALUES (1, (SELECT cid from category WHERE cname = 'novel'), 1, 'regress_rls_bob', 'another novel'...
ON CONFLICT (did) DO SELECT WHERE excluded.dlevel = 1 RETURNING did, dauthor, dtitle;
@@ -2482,7 +2482,7 @@
-- should fail UPDATE USING policy for novel with dlevel = 2
INSERT INTO document VALUES (2, (SELECT cid from category WHERE cname = 'novel'), 1, 'regress_rls_bob', 'another novel'...
ON CONFLICT (did) DO SELECT FOR UPDATE RETURNING did, dauthor, dtitle;
-ERROR: new row violates row-level security policy (USING expression) for table "document"
+ERROR: new row violates row-level security policy "p3_update_novels" (USING expression) for table "document"
SET SESSION AUTHORIZATION regress_rls_alice;
DROP POLICY p1_select_novels ON document;
... |
| 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 2026-02-28 08:30:50
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/rowsecurity.out 2026-02-28 08:36:42
@@ -2462,7 +2462,7 @@
-- DO SELECT requires SELECT rights, should fail for non-novel
INSERT INTO document VALUES (33, (SELECT cid from category WHERE cname = 'science fiction'), 1, 'regress_rls_bob', 'ano...
ON CONFLICT (did) DO SELECT RETURNING did, dauthor, dtitle;
-ERROR: new row violates row-level security policy for table "document"
+ERROR: new row violates row-level security policy "p1_select_novels" for table "document"
-- DO SELECT with WHERE and EXCLUDED reference
INSERT INTO document VALUES (1, (SELECT cid from category WHERE cname = 'novel'), 1, 'regress_rls_bob', 'another novel'...
ON CONFLICT (did) DO SELECT WHERE excluded.dlevel = 1 RETURNING did, dauthor, dtitle;
@@ -2482,7 +2482,7 @@
-- should fail UPDATE USING policy for novel with dlevel = 2
INSERT INTO document VALUES (2, (SELECT cid from category WHERE cname = 'novel'), 1, 'regress_rls_bob', 'another novel'...
ON CONFLICT (did) DO SELECT FOR UPDATE RETURNING did, dauthor, dtitle;
-ERROR: new row violates row-level security policy (USING expression) for table "document"
+ERROR: new row violates row-level security policy "p3_update_novels" (USING expression) for table "document"
SET SESSION AUTHORIZATION regress_rls_alice;
DROP POLICY p1_select_novels ON document;
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/rowsecurity.out /Users/admin/pgsql/build/testrun/regress/regress/r...
--- /Users/admin/pgsql/src/test/regress/expected/rowsecurity.out 2026-02-28 08:30:50
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/rowsecurity.out 2026-02-28 08:34:22
@@ -2462,7 +2462,7 @@
-- DO SELECT requires SELECT rights, should fail for non-novel
INSERT INTO document VALUES (33, (SELECT cid from category WHERE cname = 'science fiction'), 1, 'regress_rls_bob', 'ano...
ON CONFLICT (did) DO SELECT RETURNING did, dauthor, dtitle;
-ERROR: new row violates row-level security policy for table "document"
+ERROR: new row violates row-level security policy "p1_select_novels" for table "document"
-- DO SELECT with WHERE and EXCLUDED reference
INSERT INTO document VALUES (1, (SELECT cid from category WHERE cname = 'novel'), 1, 'regress_rls_bob', 'another novel'...
ON CONFLICT (did) DO SELECT WHERE excluded.dlevel = 1 RETURNING did, dauthor, dtitle;
@@ -2482,7 +2482,7 @@
-- should fail UPDATE USING policy for novel with dlevel = 2
INSERT INTO document VALUES (2, (SELECT cid from category WHERE cname = 'novel'), 1, 'regress_rls_bob', 'another novel'...
ON CONFLICT (did) DO SELECT FOR UPDATE RETURNING did, dauthor, dtitle;
-ERROR: new row violates row-level security policy (USING expression) for table "document"
+ERROR: new row violates row-level security policy "p3_update_novels" (USING expression) for table "document"
SET SESSION AUTHORIZATION regress_rls_alice;
DROP POLICY p1_select_novels ON document;
... |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/rowsecurity.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/00...
--- /tmp/cirrus-ci-build/src/test/regress/expected/rowsecurity.out 2026-02-28 08:30:45.748270000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/rowsecurity.out 2026-02-28 08:32:36.108808...
@@ -2462,7 +2462,7 @@
-- DO SELECT requires SELECT rights, should fail for non-novel
INSERT INTO document VALUES (33, (SELECT cid from category WHERE cname = 'science fiction'), 1, 'regress_rls_bob', 'ano...
ON CONFLICT (did) DO SELECT RETURNING did, dauthor, dtitle;
-ERROR: new row violates row-level security policy for table "document"
+ERROR: new row violates row-level security policy "p1_select_novels" for table "document"
-- DO SELECT with WHERE and EXCLUDED reference
INSERT INTO document VALUES (1, (SELECT cid from category WHERE cname = 'novel'), 1, 'regress_rls_bob', 'another novel'...
ON CONFLICT (did) DO SELECT WHERE excluded.dlevel = 1 RETURNING did, dauthor, dtitle;
@@ -2482,7 +2482,7 @@
-- should fail UPDATE USING policy for novel with dlevel = 2
INSERT INTO document VALUES (2, (SELECT cid from category WHERE cname = 'novel'), 1, 'regress_rls_bob', 'another novel'...
ON CONFLICT (did) DO SELECT FOR UPDATE RETURNING did, dauthor, dtitle;
-ERROR: new row violates row-level security policy (USING expression) for table "document"
+ERROR: new row violates row-level security policy "p3_update_novels" (USING expression) for table "document"
SET SESSION AUTHORIZATION regress_rls_alice;
DROP POLICY p1_select_novels ON document;
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/rowsecurity.out /tmp/cirrus-ci-build/build/testrun/recovery/027_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/rowsecurity.out 2026-02-28 08:30:45.748270000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/rowsecurity.out 2026-02-28 08:33:54.1013...
@@ -2462,7 +2462,7 @@
-- DO SELECT requires SELECT rights, should fail for non-novel
INSERT INTO document VALUES (33, (SELECT cid from category WHERE cname = 'science fiction'), 1, 'regress_rls_bob', 'ano...
ON CONFLICT (did) DO SELECT RETURNING did, dauthor, dtitle;
-ERROR: new row violates row-level security policy for table "document"
+ERROR: new row violates row-level security policy "p1_select_novels" for table "document"
-- DO SELECT with WHERE and EXCLUDED reference
INSERT INTO document VALUES (1, (SELECT cid from category WHERE cname = 'novel'), 1, 'regress_rls_bob', 'another novel'...
ON CONFLICT (did) DO SELECT WHERE excluded.dlevel = 1 RETURNING did, dauthor, dtitle;
@@ -2482,7 +2482,7 @@
-- should fail UPDATE USING policy for novel with dlevel = 2
INSERT INTO document VALUES (2, (SELECT cid from category WHERE cname = 'novel'), 1, 'regress_rls_bob', 'another novel'...
ON CONFLICT (did) DO SELECT FOR UPDATE RETURNING did, dauthor, dtitle;
-ERROR: new row violates row-level security policy (USING expression) for table "document"
+ERROR: new row violates row-level security policy "p3_update_novels" (USING expression) for table "document"
SET SESSION AUTHORIZATION regress_rls_alice;
DROP POLICY p1_select_novels ON document;
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/rowsecurity.out /tmp/cirrus-ci-build/build/testrun/regress/regre...
--- /tmp/cirrus-ci-build/src/test/regress/expected/rowsecurity.out 2026-02-28 08:30:45.748270000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/rowsecurity.out 2026-02-28 08:32:45.152278000 +0000
@@ -2462,7 +2462,7 @@
-- DO SELECT requires SELECT rights, should fail for non-novel
INSERT INTO document VALUES (33, (SELECT cid from category WHERE cname = 'science fiction'), 1, 'regress_rls_bob', 'ano...
ON CONFLICT (did) DO SELECT RETURNING did, dauthor, dtitle;
-ERROR: new row violates row-level security policy for table "document"
+ERROR: new row violates row-level security policy "p1_select_novels" for table "document"
-- DO SELECT with WHERE and EXCLUDED reference
INSERT INTO document VALUES (1, (SELECT cid from category WHERE cname = 'novel'), 1, 'regress_rls_bob', 'another novel'...
ON CONFLICT (did) DO SELECT WHERE excluded.dlevel = 1 RETURNING did, dauthor, dtitle;
@@ -2482,7 +2482,7 @@
-- should fail UPDATE USING policy for novel with dlevel = 2
INSERT INTO document VALUES (2, (SELECT cid from category WHERE cname = 'novel'), 1, 'regress_rls_bob', 'another novel'...
ON CONFLICT (did) DO SELECT FOR UPDATE RETURNING did, dauthor, dtitle;
-ERROR: new row violates row-level security policy (USING expression) for table "document"
+ERROR: new row violates row-level security policy "p3_update_novels" (USING expression) for table "document"
SET SESSION AUTHORIZATION regress_rls_alice;
DROP POLICY p1_select_novels ON document;
... |
|
Linux - Debian Trixie - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/rowsecurity.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_chec...
--- /tmp/cirrus-ci-build/src/test/regress/expected/rowsecurity.out 2026-02-28 08:31:02.867890470 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/rowsecurity.out 2026-02-28 08:36:30.808022849 +0000
@@ -2462,7 +2462,7 @@
-- DO SELECT requires SELECT rights, should fail for non-novel
INSERT INTO document VALUES (33, (SELECT cid from category WHERE cname = 'science fiction'), 1, 'regress_rls_bob', 'ano...
ON CONFLICT (did) DO SELECT RETURNING did, dauthor, dtitle;
-ERROR: new row violates row-level security policy for table "document"
+ERROR: new row violates row-level security policy "p1_select_novels" for table "document"
-- DO SELECT with WHERE and EXCLUDED reference
INSERT INTO document VALUES (1, (SELECT cid from category WHERE cname = 'novel'), 1, 'regress_rls_bob', 'another novel'...
ON CONFLICT (did) DO SELECT WHERE excluded.dlevel = 1 RETURNING did, dauthor, dtitle;
@@ -2482,7 +2482,7 @@
-- should fail UPDATE USING policy for novel with dlevel = 2
INSERT INTO document VALUES (2, (SELECT cid from category WHERE cname = 'novel'), 1, 'regress_rls_bob', 'another novel'...
ON CONFLICT (did) DO SELECT FOR UPDATE RETURNING did, dauthor, dtitle;
-ERROR: new row violates row-level security policy (USING expression) for table "document"
+ERROR: new row violates row-level security policy "p3_update_novels" (USING expression) for table "document"
SET SESSION AUTHORIZATION regress_rls_alice;
DROP POLICY p1_select_novels ON document;
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/rowsecurity.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check...
--- /tmp/cirrus-ci-build/src/test/regress/expected/rowsecurity.out 2026-02-28 08:31:02.867890470 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/rowsecurity.out 2026-02-28 08:38:08.078850713 +0000
@@ -2462,7 +2462,7 @@
-- DO SELECT requires SELECT rights, should fail for non-novel
INSERT INTO document VALUES (33, (SELECT cid from category WHERE cname = 'science fiction'), 1, 'regress_rls_bob', 'ano...
ON CONFLICT (did) DO SELECT RETURNING did, dauthor, dtitle;
-ERROR: new row violates row-level security policy for table "document"
+ERROR: new row violates row-level security policy "p1_select_novels" for table "document"
-- DO SELECT with WHERE and EXCLUDED reference
INSERT INTO document VALUES (1, (SELECT cid from category WHERE cname = 'novel'), 1, 'regress_rls_bob', 'another novel'...
ON CONFLICT (did) DO SELECT WHERE excluded.dlevel = 1 RETURNING did, dauthor, dtitle;
@@ -2482,7 +2482,7 @@
-- should fail UPDATE USING policy for novel with dlevel = 2
INSERT INTO document VALUES (2, (SELECT cid from category WHERE cname = 'novel'), 1, 'regress_rls_bob', 'another novel'...
ON CONFLICT (did) DO SELECT FOR UPDATE RETURNING did, dauthor, dtitle;
-ERROR: new row violates row-level security policy (USING expression) for table "document"
+ERROR: new row violates row-level security policy "p3_update_novels" (USING expression) for table "document"
SET SESSION AUTHORIZATION regress_rls_alice;
DROP POLICY p1_select_novels ON document;
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/rowsecurity.out /tmp/cirrus-ci-build/src/test/regress/results/ro...
--- /tmp/cirrus-ci-build/src/test/regress/expected/rowsecurity.out 2026-02-28 08:31:02.867890470 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/rowsecurity.out 2026-02-28 08:34:02.907964435 +0000
@@ -2462,7 +2462,7 @@
-- DO SELECT requires SELECT rights, should fail for non-novel
INSERT INTO document VALUES (33, (SELECT cid from category WHERE cname = 'science fiction'), 1, 'regress_rls_bob', 'ano...
ON CONFLICT (did) DO SELECT RETURNING did, dauthor, dtitle;
-ERROR: new row violates row-level security policy for table "document"
+ERROR: new row violates row-level security policy "p1_select_novels" for table "document"
-- DO SELECT with WHERE and EXCLUDED reference
INSERT INTO document VALUES (1, (SELECT cid from category WHERE cname = 'novel'), 1, 'regress_rls_bob', 'another novel'...
ON CONFLICT (did) DO SELECT WHERE excluded.dlevel = 1 RETURNING did, dauthor, dtitle;
@@ -2482,7 +2482,7 @@
-- should fail UPDATE USING policy for novel with dlevel = 2
INSERT INTO document VALUES (2, (SELECT cid from category WHERE cname = 'novel'), 1, 'regress_rls_bob', 'another novel'...
ON CONFLICT (did) DO SELECT FOR UPDATE RETURNING did, dauthor, dtitle;
-ERROR: new row violates row-level security policy (USING expression) for table "document"
+ERROR: new row violates row-level security policy "p3_update_novels" (USING expression) for table "document"
SET SESSION AUTHORIZATION regress_rls_alice;
DROP POLICY p1_select_novels ON document;
... |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/rowsecurity.out /home/postgres/postgres/build/testrun/pg_upgr...
--- /home/postgres/postgres/src/test/regress/expected/rowsecurity.out 2026-02-28 08:31:12.095023112 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/rowsecurity.out 2026-02-28 08:32:37.711...
@@ -2462,7 +2462,7 @@
-- DO SELECT requires SELECT rights, should fail for non-novel
INSERT INTO document VALUES (33, (SELECT cid from category WHERE cname = 'science fiction'), 1, 'regress_rls_bob', 'ano...
ON CONFLICT (did) DO SELECT RETURNING did, dauthor, dtitle;
-ERROR: new row violates row-level security policy for table "document"
+ERROR: new row violates row-level security policy "p1_select_novels" for table "document"
-- DO SELECT with WHERE and EXCLUDED reference
INSERT INTO document VALUES (1, (SELECT cid from category WHERE cname = 'novel'), 1, 'regress_rls_bob', 'another novel'...
ON CONFLICT (did) DO SELECT WHERE excluded.dlevel = 1 RETURNING did, dauthor, dtitle;
@@ -2482,7 +2482,7 @@
-- should fail UPDATE USING policy for novel with dlevel = 2
INSERT INTO document VALUES (2, (SELECT cid from category WHERE cname = 'novel'), 1, 'regress_rls_bob', 'another novel'...
ON CONFLICT (did) DO SELECT FOR UPDATE RETURNING did, dauthor, dtitle;
-ERROR: new row violates row-level security policy (USING expression) for table "document"
+ERROR: new row violates row-level security policy "p3_update_novels" (USING expression) for table "document"
SET SESSION AUTHORIZATION regress_rls_alice;
DROP POLICY p1_select_novels ON document;
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/rowsecurity.out /home/postgres/postgres/build/testrun/recover...
--- /home/postgres/postgres/src/test/regress/expected/rowsecurity.out 2026-02-28 08:31:12.095023112 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/rowsecurity.out 2026-02-28 08:33:14.9...
@@ -2462,7 +2462,7 @@
-- DO SELECT requires SELECT rights, should fail for non-novel
INSERT INTO document VALUES (33, (SELECT cid from category WHERE cname = 'science fiction'), 1, 'regress_rls_bob', 'ano...
ON CONFLICT (did) DO SELECT RETURNING did, dauthor, dtitle;
-ERROR: new row violates row-level security policy for table "document"
+ERROR: new row violates row-level security policy "p1_select_novels" for table "document"
-- DO SELECT with WHERE and EXCLUDED reference
INSERT INTO document VALUES (1, (SELECT cid from category WHERE cname = 'novel'), 1, 'regress_rls_bob', 'another novel'...
ON CONFLICT (did) DO SELECT WHERE excluded.dlevel = 1 RETURNING did, dauthor, dtitle;
@@ -2482,7 +2482,7 @@
-- should fail UPDATE USING policy for novel with dlevel = 2
INSERT INTO document VALUES (2, (SELECT cid from category WHERE cname = 'novel'), 1, 'regress_rls_bob', 'another novel'...
ON CONFLICT (did) DO SELECT FOR UPDATE RETURNING did, dauthor, dtitle;
-ERROR: new row violates row-level security policy (USING expression) for table "document"
+ERROR: new row violates row-level security policy "p3_update_novels" (USING expression) for table "document"
SET SESSION AUTHORIZATION regress_rls_alice;
DROP POLICY p1_select_novels ON document;
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/rowsecurity.out /home/postgres/postgres/build/testrun/regress...
--- /home/postgres/postgres/src/test/regress/expected/rowsecurity.out 2026-02-28 08:31:12.095023112 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/rowsecurity.out 2026-02-28 08:32:35.120083550 +0000
@@ -2462,7 +2462,7 @@
-- DO SELECT requires SELECT rights, should fail for non-novel
INSERT INTO document VALUES (33, (SELECT cid from category WHERE cname = 'science fiction'), 1, 'regress_rls_bob', 'ano...
ON CONFLICT (did) DO SELECT RETURNING did, dauthor, dtitle;
-ERROR: new row violates row-level security policy for table "document"
+ERROR: new row violates row-level security policy "p1_select_novels" for table "document"
-- DO SELECT with WHERE and EXCLUDED reference
INSERT INTO document VALUES (1, (SELECT cid from category WHERE cname = 'novel'), 1, 'regress_rls_bob', 'another novel'...
ON CONFLICT (did) DO SELECT WHERE excluded.dlevel = 1 RETURNING did, dauthor, dtitle;
@@ -2482,7 +2482,7 @@
-- should fail UPDATE USING policy for novel with dlevel = 2
INSERT INTO document VALUES (2, (SELECT cid from category WHERE cname = 'novel'), 1, 'regress_rls_bob', 'another novel'...
ON CONFLICT (did) DO SELECT FOR UPDATE RETURNING did, dauthor, dtitle;
-ERROR: new row violates row-level security policy (USING expression) for table "document"
+ERROR: new row violates row-level security policy "p3_update_novels" (USING expression) for table "document"
SET SESSION AUTHORIZATION regress_rls_alice;
DROP POLICY p1_select_novels ON document;
... |
|
OpenBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/rowsecurity.out /home/postgres/postgres/build/testrun/pg_upgr...
--- /home/postgres/postgres/src/test/regress/expected/rowsecurity.out Sat Feb 28 08:30:57 2026
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/rowsecurity.out Sat Feb 28 08:33:12 202...
@@ -2462,7 +2462,7 @@
-- DO SELECT requires SELECT rights, should fail for non-novel
INSERT INTO document VALUES (33, (SELECT cid from category WHERE cname = 'science fiction'), 1, 'regress_rls_bob', 'ano...
ON CONFLICT (did) DO SELECT RETURNING did, dauthor, dtitle;
-ERROR: new row violates row-level security policy for table "document"
+ERROR: new row violates row-level security policy "p1_select_novels" for table "document"
-- DO SELECT with WHERE and EXCLUDED reference
INSERT INTO document VALUES (1, (SELECT cid from category WHERE cname = 'novel'), 1, 'regress_rls_bob', 'another novel'...
ON CONFLICT (did) DO SELECT WHERE excluded.dlevel = 1 RETURNING did, dauthor, dtitle;
@@ -2482,7 +2482,7 @@
-- should fail UPDATE USING policy for novel with dlevel = 2
INSERT INTO document VALUES (2, (SELECT cid from category WHERE cname = 'novel'), 1, 'regress_rls_bob', 'another novel'...
ON CONFLICT (did) DO SELECT FOR UPDATE RETURNING did, dauthor, dtitle;
-ERROR: new row violates row-level security policy (USING expression) for table "document"
+ERROR: new row violates row-level security policy "p3_update_novels" (USING expression) for table "document"
SET SESSION AUTHORIZATION regress_rls_alice;
DROP POLICY p1_select_novels ON document;
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/rowsecurity.out /home/postgres/postgres/build/testrun/recover...
--- /home/postgres/postgres/src/test/regress/expected/rowsecurity.out Sat Feb 28 08:30:57 2026
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/rowsecurity.out Sat Feb 28 08:35:06 2...
@@ -2462,7 +2462,7 @@
-- DO SELECT requires SELECT rights, should fail for non-novel
INSERT INTO document VALUES (33, (SELECT cid from category WHERE cname = 'science fiction'), 1, 'regress_rls_bob', 'ano...
ON CONFLICT (did) DO SELECT RETURNING did, dauthor, dtitle;
-ERROR: new row violates row-level security policy for table "document"
+ERROR: new row violates row-level security policy "p1_select_novels" for table "document"
-- DO SELECT with WHERE and EXCLUDED reference
INSERT INTO document VALUES (1, (SELECT cid from category WHERE cname = 'novel'), 1, 'regress_rls_bob', 'another novel'...
ON CONFLICT (did) DO SELECT WHERE excluded.dlevel = 1 RETURNING did, dauthor, dtitle;
@@ -2482,7 +2482,7 @@
-- should fail UPDATE USING policy for novel with dlevel = 2
INSERT INTO document VALUES (2, (SELECT cid from category WHERE cname = 'novel'), 1, 'regress_rls_bob', 'another novel'...
ON CONFLICT (did) DO SELECT FOR UPDATE RETURNING did, dauthor, dtitle;
-ERROR: new row violates row-level security policy (USING expression) for table "document"
+ERROR: new row violates row-level security policy "p3_update_novels" (USING expression) for table "document"
SET SESSION AUTHORIZATION regress_rls_alice;
DROP POLICY p1_select_novels ON document;
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/rowsecurity.out /home/postgres/postgres/build/testrun/regress...
--- /home/postgres/postgres/src/test/regress/expected/rowsecurity.out Sat Feb 28 08:30:57 2026
+++ /home/postgres/postgres/build/testrun/regress/regress/results/rowsecurity.out Sat Feb 28 08:33:03 2026
@@ -2462,7 +2462,7 @@
-- DO SELECT requires SELECT rights, should fail for non-novel
INSERT INTO document VALUES (33, (SELECT cid from category WHERE cname = 'science fiction'), 1, 'regress_rls_bob', 'ano...
ON CONFLICT (did) DO SELECT RETURNING did, dauthor, dtitle;
-ERROR: new row violates row-level security policy for table "document"
+ERROR: new row violates row-level security policy "p1_select_novels" for table "document"
-- DO SELECT with WHERE and EXCLUDED reference
INSERT INTO document VALUES (1, (SELECT cid from category WHERE cname = 'novel'), 1, 'regress_rls_bob', 'another novel'...
ON CONFLICT (did) DO SELECT WHERE excluded.dlevel = 1 RETURNING did, dauthor, dtitle;
@@ -2482,7 +2482,7 @@
-- should fail UPDATE USING policy for novel with dlevel = 2
INSERT INTO document VALUES (2, (SELECT cid from category WHERE cname = 'novel'), 1, 'regress_rls_bob', 'another novel'...
ON CONFLICT (did) DO SELECT FOR UPDATE RETURNING did, dauthor, dtitle;
-ERROR: new row violates row-level security policy (USING expression) for table "document"
+ERROR: new row violates row-level security policy "p3_update_novels" (USING expression) for table "document"
SET SESSION AUTHORIZATION regress_rls_alice;
DROP POLICY p1_select_novels ON document;
... |