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/6029 |
NOT NULL NOT ENFORCED |
 |
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/constraints.out /home/postgres/postgres/build/testrun/recover...
--- /home/postgres/postgres/src/test/regress/expected/constraints.out 2026-02-23 10:48:22.050408394 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/constraints.out 2026-02-23 10:50:34.2...
@@ -1039,10 +1039,11 @@
ERROR: conflicting NOT ENFORCED declaration for not-null constraint on column "x"
CREATE TABLE ne_nn_tbl (x int, CONSTRAINT nn NOT NULL x NOT ENFORCED);
SELECT pg_get_constraintdef(oid) FROM pg_constraint WHERE conname = 'nn';
- pg_get_constraintdef
--------------------------
+ pg_get_constraintdef
+-------------------------------------
NOT NULL x NOT ENFORCED
-(1 row)
+ NOT NULL f1 NO INHERIT NOT ENFORCED
+(2 rows)
INSERT INTO ne_nn_tbl VALUES (NULL); --ok
ALTER TABLE ne_nn_tbl ALTER CONSTRAINT nn ENFORCED; --error |
| 58/5556 |
Expanding HOT updates for expression and partial indexes |
|
Windows - Server 2022, MinGW64 - Meson |
| 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-02-23 10:11:47.060007600 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/triggers.out 2026-02-23 10:16:39.584219000 +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 |
|
macOS - Sequoia - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/triggers.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_up...
--- /Users/admin/pgsql/src/test/regress/expected/triggers.out 2026-02-23 10:11:32
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/triggers.out 2026-02-23 10:16:33
@@ -276,9 +276,9 @@
NOTICE: trigger_func(delete_a) called: action = DELETE, when = AFTER, level = ROW
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 |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/triggers.out /Users/admin/pgsql/build/testrun/recovery/027_stream_...
--- /Users/admin/pgsql/src/test/regress/expected/triggers.out 2026-02-23 10:11:32
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/triggers.out 2026-02-23 10:19:20
@@ -961,12 +961,12 @@
-- Delete from view using trigger
DELETE FROM main_view WHERE a IN (20,21);
NOTICE: main_view BEFORE DELETE STATEMENT (before_view_del_stmt)
-NOTICE: main_view INSTEAD OF DELETE ROW (instead_of_del)
-NOTICE: OLD: (21,10)
NOTICE: main_view INSTEAD OF DELETE ROW (instead_of_del)
NOTICE: OLD: (20,31)
NOTICE: main_view INSTEAD OF DELETE ROW (instead_of_del)
NOTICE: OLD: (21,32)
+NOTICE: main_view INSTEAD OF DELETE ROW (instead_of_del)
+NOTICE: OLD: (21,10)
NOTICE: main_view AFTER DELETE STATEMENT (after_view_del_stmt)
DELETE 3
DELETE FROM main_view WHERE a = 31 RETURNING a, b; |
|
Linux - Debian Trixie - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_p...
--- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out 2026-02-23 10:11:34.851654511 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/triggers.out 2026-02-23 10:16:04.755712766...
@@ -962,11 +962,11 @@
DELETE FROM main_view WHERE a IN (20,21);
NOTICE: main_view BEFORE DELETE STATEMENT (before_view_del_stmt)
NOTICE: main_view INSTEAD OF DELETE ROW (instead_of_del)
-NOTICE: OLD: (21,10)
-NOTICE: main_view INSTEAD OF DELETE ROW (instead_of_del)
NOTICE: OLD: (20,31)
NOTICE: main_view INSTEAD OF DELETE ROW (instead_of_del)
NOTICE: OLD: (21,32)
+NOTICE: main_view INSTEAD OF DELETE ROW (instead_of_del)
+NOTICE: OLD: (21,10)
NOTICE: main_view AFTER DELETE STATEMENT (after_view_del_stmt)
DELETE 3
DELETE FROM main_view WHERE a = 31 RETURNING a, b; |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/build/testrun/regress/regress/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out 2026-02-23 10:11:34.851654511 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/triggers.out 2026-02-23 10:16:04.475712950 +0000
@@ -962,11 +962,11 @@
DELETE FROM main_view WHERE a IN (20,21);
NOTICE: main_view BEFORE DELETE STATEMENT (before_view_del_stmt)
NOTICE: main_view INSTEAD OF DELETE ROW (instead_of_del)
-NOTICE: OLD: (21,10)
-NOTICE: main_view INSTEAD OF DELETE ROW (instead_of_del)
NOTICE: OLD: (20,31)
NOTICE: main_view INSTEAD OF DELETE ROW (instead_of_del)
NOTICE: OLD: (21,32)
+NOTICE: main_view INSTEAD OF DELETE ROW (instead_of_del)
+NOTICE: OLD: (21,10)
NOTICE: main_view AFTER DELETE STATEMENT (after_view_del_stmt)
DELETE 3
DELETE FROM main_view WHERE a = 31 RETURNING a, b; |
|
OpenBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/triggers.out /home/postgres/postgres/build/testrun/recovery/0...
--- /home/postgres/postgres/src/test/regress/expected/triggers.out Mon Feb 23 10:11:46 2026
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/triggers.out Mon Feb 23 10:17:30 2026
@@ -962,11 +962,11 @@
DELETE FROM main_view WHERE a IN (20,21);
NOTICE: main_view BEFORE DELETE STATEMENT (before_view_del_stmt)
NOTICE: main_view INSTEAD OF DELETE ROW (instead_of_del)
-NOTICE: OLD: (21,10)
-NOTICE: main_view INSTEAD OF DELETE ROW (instead_of_del)
NOTICE: OLD: (20,31)
NOTICE: main_view INSTEAD OF DELETE ROW (instead_of_del)
NOTICE: OLD: (21,32)
+NOTICE: main_view INSTEAD OF DELETE ROW (instead_of_del)
+NOTICE: OLD: (21,10)
NOTICE: main_view AFTER DELETE STATEMENT (after_view_del_stmt)
DELETE 3
DELETE FROM main_view WHERE a = 31 RETURNING a, b; |
|
Linux - Debian Trixie - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check/re...
--- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out 2026-02-23 10:11:46.388211410 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/triggers.out 2026-02-23 10:23:02.665736560 +0000
@@ -962,11 +962,11 @@
DELETE FROM main_view WHERE a IN (20,21);
NOTICE: main_view BEFORE DELETE STATEMENT (before_view_del_stmt)
NOTICE: main_view INSTEAD OF DELETE ROW (instead_of_del)
-NOTICE: OLD: (21,10)
-NOTICE: main_view INSTEAD OF DELETE ROW (instead_of_del)
NOTICE: OLD: (20,31)
NOTICE: main_view INSTEAD OF DELETE ROW (instead_of_del)
NOTICE: OLD: (21,32)
+NOTICE: main_view INSTEAD OF DELETE ROW (instead_of_del)
+NOTICE: OLD: (21,10)
NOTICE: main_view AFTER DELETE STATEMENT (after_view_del_stmt)
DELETE 3
DELETE FROM main_view WHERE a = 31 RETURNING a, b; |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/src/test/regress/results/trigg...
--- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out 2026-02-23 10:11:46.388211410 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/triggers.out 2026-02-23 10:18:26.173385578 +0000
@@ -962,11 +962,11 @@
DELETE FROM main_view WHERE a IN (20,21);
NOTICE: main_view BEFORE DELETE STATEMENT (before_view_del_stmt)
NOTICE: main_view INSTEAD OF DELETE ROW (instead_of_del)
+NOTICE: OLD: (21,32)
+NOTICE: main_view INSTEAD OF DELETE ROW (instead_of_del)
NOTICE: OLD: (21,10)
NOTICE: main_view INSTEAD OF DELETE ROW (instead_of_del)
NOTICE: OLD: (20,31)
-NOTICE: main_view INSTEAD OF DELETE ROW (instead_of_del)
-NOTICE: OLD: (21,32)
NOTICE: main_view AFTER DELETE STATEMENT (after_view_del_stmt)
DELETE 3
DELETE FROM main_view WHERE a = 31 RETURNING a, b; |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_p...
--- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out 2026-02-23 10:11:30.934303000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/triggers.out 2026-02-23 10:14:06.825511000...
@@ -962,11 +962,11 @@
DELETE FROM main_view WHERE a IN (20,21);
NOTICE: main_view BEFORE DELETE STATEMENT (before_view_del_stmt)
NOTICE: main_view INSTEAD OF DELETE ROW (instead_of_del)
-NOTICE: OLD: (21,10)
-NOTICE: main_view INSTEAD OF DELETE ROW (instead_of_del)
NOTICE: OLD: (20,31)
NOTICE: main_view INSTEAD OF DELETE ROW (instead_of_del)
NOTICE: OLD: (21,32)
+NOTICE: main_view INSTEAD OF DELETE ROW (instead_of_del)
+NOTICE: OLD: (21,10)
NOTICE: main_view AFTER DELETE STATEMENT (after_view_del_stmt)
DELETE 3
DELETE FROM main_view WHERE a = 31 RETURNING a, b; |
| 58/6515 |
Fix incorrect Spanish translation and remove obsolete FIXME comments in es.po |
|
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-02-23 07:13:25.549753000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress-running/regress/results/create_index.out 2026-02-23 07:21:51.858092000 +0...
@@ -2042,7 +2042,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
@@ -2211,9 +2211,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/4460 |
Implement row pattern recognition feature |
|
Linux - Debian Trixie - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/rpr_explain.out /tmp/cirrus-ci-build/build-32/testrun/pg_upgrade...
--- /tmp/cirrus-ci-build/src/test/regress/expected/rpr_explain.out 2026-02-22 21:38:36.225141533 +0000
+++ /tmp/cirrus-ci-build/build-32/testrun/pg_upgrade/002_pg_upgrade/data/results/rpr_explain.out 2026-02-22 21:50:41.507...
@@ -1625,7 +1625,7 @@
NFA: 54 absorbed (len 1/1/1.0), 18 skipped (len 1/1/1.0)
-> Sort (actual rows=90.00 loops=1)
Sort Key: p.p
- Sort Method: quicksort Memory: 27kB
+ Sort Method: quicksort Memory: 22kB
-> Nested Loop (actual rows=90.00 loops=1)
-> Function Scan on generate_series p (actual rows=3.00 loops=1)
-> Function Scan on generate_series v (actual rows=30.00 loops=3)
@@ -1682,7 +1682,7 @@
NFA: 19 absorbed (len 1/1/1.0), 5 skipped (len 1/1/1.0)
-> Sort (actual rows=50.00 loops=1)
Sort Key: (CASE WHEN (v.v <= 25) THEN 1 ELSE 2 END)
- Sort Method: quicksort Memory: 26kB
+ Sort Method: quicksort Memory: 21kB
-> Function Scan on generate_series v (actual rows=50.00 loops=1)
(12 rows)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/rpr_explain.out /tmp/cirrus-ci-build/build-32/testrun/recovery/0...
--- /tmp/cirrus-ci-build/src/test/regress/expected/rpr_explain.out 2026-02-22 21:38:36.225141533 +0000
+++ /tmp/cirrus-ci-build/build-32/testrun/recovery/027_stream_regress/data/results/rpr_explain.out 2026-02-22 21:52:18.3...
@@ -1625,7 +1625,7 @@
NFA: 54 absorbed (len 1/1/1.0), 18 skipped (len 1/1/1.0)
-> Sort (actual rows=90.00 loops=1)
Sort Key: p.p
- Sort Method: quicksort Memory: 27kB
+ Sort Method: quicksort Memory: 22kB
-> Nested Loop (actual rows=90.00 loops=1)
-> Function Scan on generate_series p (actual rows=3.00 loops=1)
-> Function Scan on generate_series v (actual rows=30.00 loops=3)
@@ -1682,7 +1682,7 @@
NFA: 19 absorbed (len 1/1/1.0), 5 skipped (len 1/1/1.0)
-> Sort (actual rows=50.00 loops=1)
Sort Key: (CASE WHEN (v.v <= 25) THEN 1 ELSE 2 END)
- Sort Method: quicksort Memory: 26kB
+ Sort Method: quicksort Memory: 21kB
-> Function Scan on generate_series v (actual rows=50.00 loops=1)
(12 rows)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/rpr_explain.out /tmp/cirrus-ci-build/build-32/testrun/regress/re...
--- /tmp/cirrus-ci-build/src/test/regress/expected/rpr_explain.out 2026-02-22 21:38:36.225141533 +0000
+++ /tmp/cirrus-ci-build/build-32/testrun/regress/regress/results/rpr_explain.out 2026-02-22 21:50:38.759582796 +0000
@@ -1625,7 +1625,7 @@
NFA: 54 absorbed (len 1/1/1.0), 18 skipped (len 1/1/1.0)
-> Sort (actual rows=90.00 loops=1)
Sort Key: p.p
- Sort Method: quicksort Memory: 27kB
+ Sort Method: quicksort Memory: 22kB
-> Nested Loop (actual rows=90.00 loops=1)
-> Function Scan on generate_series p (actual rows=3.00 loops=1)
-> Function Scan on generate_series v (actual rows=30.00 loops=3)
@@ -1682,7 +1682,7 @@
NFA: 19 absorbed (len 1/1/1.0), 5 skipped (len 1/1/1.0)
-> Sort (actual rows=50.00 loops=1)
Sort Key: (CASE WHEN (v.v <= 25) THEN 1 ELSE 2 END)
- Sort Method: quicksort Memory: 26kB
+ Sort Method: quicksort Memory: 21kB
-> Function Scan on generate_series v (actual rows=50.00 loops=1)
(12 rows)
... |
| 58/6040 |
Fix read/write races with pg_control file in case when postgres was compiled with DEXEC_BACKEND option |
|
OpenBSD - 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 Sun Feb 22 14:50:42 2026
+++ /home/postgres/postgres/build/testrun/postgres_fdw/regress/results/query_cancel.out Sun Feb 22 14:56:26 2026
@@ -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/5118 |
SendProcSignal(), SetLatch() → SendInterrupt() |
|
macOS - Sequoia - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/rowsecurity.out /Users/admin/pgsql/build/testrun/recovery/027_stre...
--- /Users/admin/pgsql/src/test/regress/expected/rowsecurity.out 2026-02-22 09:34:17
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/rowsecurity.out 2026-02-22 09:43:47
@@ -4766,6 +4766,8 @@
CREATE POLICY p0 ON r1 USING (b * 10 = c);
CREATE POLICY p1 ON r1 AS RESTRICTIVE USING (b > 10);
CREATE POLICY p2 ON r1 AS RESTRICTIVE USING ((SELECT c) < 400);
+ERROR: could not extend file "base/16384/3256": No space left on device
+HINT: Check free disk space.
ALTER TABLE r1 ENABLE ROW LEVEL SECURITY;
ALTER TABLE r1 FORCE ROW LEVEL SECURITY;
-- Should fail p1
@@ -4773,15 +4775,16 @@
ERROR: new row violates row-level security policy "p1" for table "r1"
-- Should fail p2
INSERT INTO r1 VALUES (4);
-ERROR: new row violates row-level security policy "p2" for table "r1"
-- OK
INSERT INTO r1 VALUES (3);
SELECT * FROM r1;
... |
| 58/6507 |
convert SpinLock* macros to static inline functions |
|
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-02-21 22:35:38.666972143 +0000
+++ /home/postgres/postgres/build/testrun/isolation/isolation/results/timeouts.out 2026-02-21 22:39:13.272859016 +0000
@@ -57,7 +57,7 @@
step sto: SET statement_timeout = '10ms';
step update: DELETE FROM accounts WHERE accountid = 'checking'; <waiting ...>
step update: <... completed>
-ERROR: canceling statement due to statement timeout
+ERROR: canceling statement due to user request
starting permutation: wrtbl lto update
step wrtbl: UPDATE accounts SET balance = balance + 100; |
| 58/6037 |
Fix race condition in SSI when reading PredXact->SxactGlobalXmin |
|
Linux - Debian Trixie - 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-02-21 21:45:45.60...
+++ /tmp/cirrus-ci-build/build/testrun/injection_points/isolation/results/predicate-lock-page-split.out 2026-02-21 21:51...
@@ -64,6 +64,7 @@
step s3_insert:
INSERT INTO test_table SELECT max(id) + 1 FROM test_table;
+ERROR: could not serialize access due to read/write dependencies among transactions
step wakeup_s2_then_s1: <... completed>
step s3_commit:
COMMIT;
@@ -78,9 +79,9 @@
id
---
407
-407
406
405
404
+403
... |
| 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-02-21 18:16:13.901379852 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_stored.out 2026-02-21 18:19:45.7...
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out /tmp/cirrus-ci-build/build/testrun/pg_upgr...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out 2026-02-21 18:16:13.901379852 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out 2026-02-21 18:19:52....
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_stored.out /tmp/cirrus-ci-build/build/testrun/recovery...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_stored.out 2026-02-21 18:16:13.901379852 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/generated_stored.out 2026-02-21 18:21:12...
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff -U3 /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-02-21 18:16:13.901379852 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out 2026-02-21 18:21:2...
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
| regress |
diff -U3 /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-02-21 18:16:13.901379852 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/generated_stored.out 2026-02-21 18:19:44.724556607 +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-02-21 18:16:13.901379852 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/generated_virtual.out 2026-02-21 18:19:52.680545812 +0000
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
|
macOS - Sequoia - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/generated_stored.out /Users/admin/pgsql/build/testrun/pg_upgrade/0...
--- /Users/admin/pgsql/src/test/regress/expected/generated_stored.out 2026-02-21 18:15:59
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_stored.out 2026-02-21 18:18:53
@@ -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-02-21 18:15:59
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out 2026-02-21 18:18:57
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/generated_stored.out /Users/admin/pgsql/build/testrun/recovery/027...
--- /Users/admin/pgsql/src/test/regress/expected/generated_stored.out 2026-02-21 18:15:59
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/generated_stored.out 2026-02-21 18:20:17
@@ -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-02-21 18:15:59
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out 2026-02-21 18:20:25
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
| regress |
diff -U3 /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-02-21 18:15:59
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/generated_stored.out 2026-02-21 18:18:49
@@ -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-02-21 18:15:59
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/generated_virtual.out 2026-02-21 18:18:55
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
|
Windows - Server 2022, MinGW64 - Meson |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/generated_stored.out C:/cirrus/build/testrun/pg_upgrade...
--- C:/cirrus/src/test/regress/expected/generated_stored.out 2026-02-21 18:16:08.725860000 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_stored.out 2026-02-21 18:20:18.033768000 +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-02-21 18:16:08.726846000 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out 2026-02-21 18:20:27.420974900 +...
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/generated_stored.out C:/cirrus/build/testrun/recovery/0...
--- C:/cirrus/src/test/regress/expected/generated_stored.out 2026-02-21 18:16:08.725860000 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/generated_stored.out 2026-02-21 18:23:20.667485300 ...
@@ -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-02-21 18:16:08.726846000 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out 2026-02-21 18:23:29.351545400...
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/generated_stored.out C:/cirrus/build/testrun/regress/re...
--- C:/cirrus/src/test/regress/expected/generated_stored.out 2026-02-21 18:16:08.725860000 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/generated_stored.out 2026-02-21 18:20:11.015697800 +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-02-21 18:16:08.726846000 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/generated_virtual.out 2026-02-21 18:20:22.166580200 +0000
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/generated_stored.out C:/cirrus/build/testrun/pg_upgrade...
--- C:/cirrus/src/test/regress/expected/generated_stored.out 2026-02-21 18:16:17.251268400 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_stored.out 2026-02-21 18:19:51.170187700 +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-02-21 18:16:17.251268400 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out 2026-02-21 18:20:10.939730500 +...
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/generated_stored.out C:/cirrus/build/testrun/recovery/0...
--- C:/cirrus/src/test/regress/expected/generated_stored.out 2026-02-21 18:16:17.251268400 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/generated_stored.out 2026-02-21 18:23:08.559411300 ...
@@ -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-02-21 18:16:17.251268400 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out 2026-02-21 18:23:28.442716600...
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/generated_stored.out C:/cirrus/build/testrun/regress/re...
--- C:/cirrus/src/test/regress/expected/generated_stored.out 2026-02-21 18:16:17.251268400 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/generated_stored.out 2026-02-21 18:19:44.220967800 +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-02-21 18:16:17.251268400 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/generated_virtual.out 2026-02-21 18:20:05.360608700 +0000
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
|
Linux - Debian Trixie - 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-02-21 18:16:06.993056064 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/generated_stored.out 2026-02-21 18:22:05.331902631 +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-02-21 18:16:06.993056064 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/generated_virtual.out 2026-02-21 18:22:21.484564859 +0000
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_stored.out /tmp/cirrus-ci-build/src/test/recovery/tmp_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_stored.out 2026-02-21 18:16:06.993056064 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/generated_stored.out 2026-02-21 18:24:05.499652628 +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-02-21 18:16:06.993056064 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/generated_virtual.out 2026-02-21 18:24:14.095192674 +0000
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_stored.out /tmp/cirrus-ci-build/src/test/regress/resul...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_stored.out 2026-02-21 18:16:06.993056064 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/generated_stored.out 2026-02-21 18:20:41.473807332 +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-02-21 18:16:06.993056064 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/generated_virtual.out 2026-02-21 18:20:54.169900896 +0000
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/generated_stored.out /home/postgres/postgres/build/testrun/pg...
--- /home/postgres/postgres/src/test/regress/expected/generated_stored.out 2026-02-21 18:16:20.547979572 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_stored.out 2026-02-21 18:18:3...
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff -U3 /home/postgres/postgres/src/test/regress/expected/generated_virtual.out /home/postgres/postgres/build/testrun/p...
--- /home/postgres/postgres/src/test/regress/expected/generated_virtual.out 2026-02-21 18:16:20.548862383 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out 2026-02-21 18:18:...
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/generated_stored.out /home/postgres/postgres/build/testrun/re...
--- /home/postgres/postgres/src/test/regress/expected/generated_stored.out 2026-02-21 18:16:20.547979572 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/generated_stored.out 2026-02-21 18:19...
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff -U3 /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-02-21 18:16:20.548862383 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out 2026-02-21 18:1...
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/generated_stored.out /home/postgres/postgres/build/testrun/re...
--- /home/postgres/postgres/src/test/regress/expected/generated_stored.out 2026-02-21 18:16:20.547979572 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/generated_stored.out 2026-02-21 18:18:43.371944457 +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-02-21 18:16:20.548862383 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/generated_virtual.out 2026-02-21 18:18:56.363479700 +0...
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
|
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-02-21 18:16:05.270439000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_stored.out 2026-02-21 18:18:42.3...
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out /tmp/cirrus-ci-build/build/testrun/pg_upgr...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out 2026-02-21 18:16:05.270493000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out 2026-02-21 18:19:05....
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_stored.out /tmp/cirrus-ci-build/build/testrun/recovery...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_stored.out 2026-02-21 18:16:05.270439000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/generated_stored.out 2026-02-21 18:19:57...
@@ -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-02-21 18:16:05.270493000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out 2026-02-21 18:20:2...
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
| regress |
diff -U3 /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-02-21 18:16:05.270439000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/generated_stored.out 2026-02-21 18:18:42.663205000 +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-02-21 18:16:05.270493000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/generated_virtual.out 2026-02-21 18:19:02.926968000 +0000
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
|
OpenBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/generated_stored.out /home/postgres/postgres/build/testrun/pg...
--- /home/postgres/postgres/src/test/regress/expected/generated_stored.out Sat Feb 21 18:16:31 2026
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_stored.out Sat Feb 21 18:19:5...
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff -U3 /home/postgres/postgres/src/test/regress/expected/generated_virtual.out /home/postgres/postgres/build/testrun/p...
--- /home/postgres/postgres/src/test/regress/expected/generated_virtual.out Sat Feb 21 18:16:31 2026
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out Sat Feb 21 18:19:...
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/generated_stored.out /home/postgres/postgres/build/testrun/re...
--- /home/postgres/postgres/src/test/regress/expected/generated_stored.out Sat Feb 21 18:16:31 2026
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/generated_stored.out Sat Feb 21 18:21...
@@ -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 Sat Feb 21 18:16:31 2026
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out Sat Feb 21 18:2...
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/generated_stored.out /home/postgres/postgres/build/testrun/re...
--- /home/postgres/postgres/src/test/regress/expected/generated_stored.out Sat Feb 21 18:16:31 2026
+++ /home/postgres/postgres/build/testrun/regress/regress/results/generated_stored.out Sat Feb 21 18:19:39 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 Sat Feb 21 18:16:31 2026
+++ /home/postgres/postgres/build/testrun/regress/regress/results/generated_virtual.out Sat Feb 21 18:19:50 2026
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
| 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/pg_upgrade/002_pg_u...
--- /tmp/cirrus-ci-build/src/test/regress/expected/stats.out 2026-02-21 14:49:42.971973000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/stats.out 2026-02-21 14:54:44.295503000 +0...
@@ -243,7 +243,7 @@
SELECT :seq_scan_after > :seq_scan_before;
?column?
----------
- t
+ f
(1 row)
---- |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/stats.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stream...
--- /tmp/cirrus-ci-build/src/test/regress/expected/stats.out 2026-02-21 14:49:42.971973000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/stats.out 2026-02-21 14:56:11.197873000 ...
@@ -243,7 +243,7 @@
SELECT :seq_scan_after > :seq_scan_before;
?column?
----------
- t
+ f
(1 row)
---- |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/stats.out /tmp/cirrus-ci-build/build/testrun/regress/regress/res...
--- /tmp/cirrus-ci-build/src/test/regress/expected/stats.out 2026-02-21 14:49:42.971973000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/stats.out 2026-02-21 14:54:46.312770000 +0000
@@ -243,7 +243,7 @@
SELECT :seq_scan_after > :seq_scan_before;
?column?
----------
- t
+ f
(1 row)
---- |
| 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-20 16:30:28.721857000 +00...
+++ /tmp/cirrus-ci-build/build/testrun/test_extensions/regress/results/test_extensions.out 2026-02-20 16:34:34.841102000...
@@ -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-20 16:29:53.090349145 +00...
+++ /tmp/cirrus-ci-build/src/test/modules/test_extensions/results/test_extensions.out 2026-02-20 16:33:52.903042327 +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 |
|
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-20 08:18:26.224415300 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/rowsecurity.out 2026-02-20 08:21:42.436265900 +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-20 08:18:26.224415300 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/rowsecurity.out 2026-02-20 08:25:22.494319000 +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-20 08:18:26.224415300 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/rowsecurity.out 2026-02-20 08:21:39.723847300 +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-20 08:19:45.173938800 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/rowsecurity.out 2026-02-20 08:23:43.274891900 +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-20 08:19:45.173938800 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/rowsecurity.out 2026-02-20 08:27:10.389630000 +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-20 08:19:45.173938800 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/rowsecurity.out 2026-02-20 08:23:34.464357400 +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-20 08:17:55
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/rowsecurity.out 2026-02-20 08:19:47
@@ -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-20 08:17:55
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/rowsecurity.out 2026-02-20 08:20:40
@@ -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-20 08:17:55
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/rowsecurity.out 2026-02-20 08:19:47
@@ -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 - 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-20 08:19:05.814544485 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/rowsecurity.out 2026-02-20 08:21:11.446438...
@@ -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-20 08:19:05.814544485 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/rowsecurity.out 2026-02-20 08:22:43.2623...
@@ -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-20 08:19:05.814544485 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/rowsecurity.out 2026-02-20 08:21:11.226438213 +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 Fri Feb 20 08:19:12 2026
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/rowsecurity.out Fri Feb 20 08:21:35 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 Fri Feb 20 08:19:12 2026
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/rowsecurity.out Fri Feb 20 08:23:32 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 Fri Feb 20 08:19:12 2026
+++ /home/postgres/postgres/build/testrun/regress/regress/results/rowsecurity.out Fri Feb 20 08:21:27 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;
... |
|
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-20 08:17:56.177341244 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/rowsecurity.out 2026-02-20 08:24:14.954950494 +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-20 08:17:56.177341244 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/rowsecurity.out 2026-02-20 08:25:34.178472106 +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-20 08:17:56.177341244 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/rowsecurity.out 2026-02-20 08:21:24.098246051 +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-20 08:18:13.515241135 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/rowsecurity.out 2026-02-20 08:19:47.331...
@@ -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-20 08:18:13.515241135 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/rowsecurity.out 2026-02-20 08:20:34.1...
@@ -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-20 08:18:13.515241135 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/rowsecurity.out 2026-02-20 08:19:41.318995660 +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;
... |
|
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-20 08:18:52.688476000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/rowsecurity.out 2026-02-20 08:20:58.198416...
@@ -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-20 08:18:52.688476000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/rowsecurity.out 2026-02-20 08:22:21.1041...
@@ -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-20 08:18:52.688476000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/rowsecurity.out 2026-02-20 08:20:56.957403000 +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;
... |
| 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-02-19 05:14:49.202599115 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/jsonb.out 2026-02-19 05:17:38.634282021 +0...
@@ -3279,2676 +3279,10 @@
(1 row)
SELECT count(*) FROM testjsonb WHERE j @@ 'exists($.array ? (@[*] == "bar"))';
- count
--------
- 3
-(1 row)
-
-SELECT count(*) FROM testjsonb WHERE j @@ 'exists($.array[*] ? (@ == "bar"))';
- count
--------
- 3
-(1 row)
-
-SELECT count(*) FROM testjsonb WHERE j @@ 'exists($)';
- 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-02-19 05:14:49.202599115 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/json.out 2026-02-19 05:18:58.874258326 +...
@@ -2584,185 +2584,10 @@
-- json_to_tsvector
select json_to_tsvector('english', '{"a": "aaa in bbb", "b": 123, "c": 456, "d": true, "f": false, "g": null}'::json, '...
- json_to_tsvector
-----------------------------------------------------------------------------------------
- '123':8 '456':12 'aaa':2 'b':6 'bbb':4 'c':10 'd':14 'f':18 'fals':20 'g':22 'true':16
-(1 row)
-
-select json_to_tsvector('english', '{"a": "aaa in bbb", "b": 123, "c": 456, "d": true, "f": false, "g": null}'::json, '...
- json_to_tsvector
---------------------------------
- 'b':2 'c':4 'd':6 'f':8 'g':10
-(1 row)
-
-select json_to_tsvector('english', '{"a": "aaa in bbb", "b": 123, "c": 456, "d": true, "f": false, "g": null}'::json, '...
- json_to_tsvector
... |
| 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-02-19 05:14:49.202599115 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/jsonb.out 2026-02-19 05:17:38.338281982 +0000
@@ -3466,2489 +3466,7 @@
(1 row)
SET enable_hashagg = off;
-SELECT count(*) FROM (SELECT j FROM (SELECT * FROM testjsonb UNION ALL SELECT * FROM testjsonb) js GROUP BY j) js2;
- count
--------
- 894
-(1 row)
-
-SET enable_hashagg = on;
-SET enable_sort = off;
-SELECT count(*) FROM (SELECT j FROM (SELECT * FROM testjsonb UNION ALL SELECT * FROM testjsonb) js GROUP BY j) js2;
- count
--------
- 894
-(1 row)
... |