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/6410 |
Enhance btree's pageinspect |
 |
Windows - Server 2022, MinGW64 - Meson |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/pageinspect/expected/btree.out C:/cirrus/build/testrun/pageinspect/regres...
--- C:/cirrus/contrib/pageinspect/expected/btree.out 2026-02-13 12:16:22.568631300 +0000
+++ C:/cirrus/build/testrun/pageinspect/regress/results/btree.out 2026-02-13 12:25:43.225721800 +0000
@@ -148,23 +148,25 @@
ERROR: block number 7 is out of range
DROP TABLE test2;
SELECT * FROM bt_page_items('test1_a_idx', -1);
-ERROR: invalid block number -1
+ERROR: function bt_page_items(unknown, integer) does not exist
+LINE 1: SELECT * FROM bt_page_items('test1_a_idx', -1);
+ ^
+DETAIL: No function of that name accepts the given number of arguments.
SELECT * FROM bt_page_items('test1_a_idx', 0);
-ERROR: block 0 is a meta page
+ERROR: function bt_page_items(unknown, integer) does not exist
+LINE 1: SELECT * FROM bt_page_items('test1_a_idx', 0);
+ ^
+DETAIL: No function of that name accepts the given number of arguments.
SELECT * FROM bt_page_items('test1_a_idx', 1);
--[ RECORD 1 ]-----------------------
... |
|
macOS - Sequoia - Meson |
| regress |
diff -U3 /Users/admin/pgsql/contrib/pageinspect/expected/btree.out /Users/admin/pgsql/build/testrun/pageinspect/regress/...
--- /Users/admin/pgsql/contrib/pageinspect/expected/btree.out 2026-02-13 12:14:49
+++ /Users/admin/pgsql/build/testrun/pageinspect/regress/results/btree.out 2026-02-13 12:20:24
@@ -148,23 +148,25 @@
ERROR: block number 7 is out of range
DROP TABLE test2;
SELECT * FROM bt_page_items('test1_a_idx', -1);
-ERROR: invalid block number -1
+ERROR: function bt_page_items(unknown, integer) does not exist
+LINE 1: SELECT * FROM bt_page_items('test1_a_idx', -1);
+ ^
+DETAIL: No function of that name accepts the given number of arguments.
SELECT * FROM bt_page_items('test1_a_idx', 0);
-ERROR: block 0 is a meta page
+ERROR: function bt_page_items(unknown, integer) does not exist
+LINE 1: SELECT * FROM bt_page_items('test1_a_idx', 0);
+ ^
+DETAIL: No function of that name accepts the given number of arguments.
SELECT * FROM bt_page_items('test1_a_idx', 1);
--[ RECORD 1 ]-----------------------
... |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/pageinspect/expected/btree.out C:/cirrus/build/testrun/pageinspect/regres...
--- C:/cirrus/contrib/pageinspect/expected/btree.out 2026-02-13 12:15:53.895636900 +0000
+++ C:/cirrus/build/testrun/pageinspect/regress/results/btree.out 2026-02-13 12:25:25.938187100 +0000
@@ -148,23 +148,25 @@
ERROR: block number 7 is out of range
DROP TABLE test2;
SELECT * FROM bt_page_items('test1_a_idx', -1);
-ERROR: invalid block number -1
+ERROR: function bt_page_items(unknown, integer) does not exist
+LINE 1: SELECT * FROM bt_page_items('test1_a_idx', -1);
+ ^
+DETAIL: No function of that name accepts the given number of arguments.
SELECT * FROM bt_page_items('test1_a_idx', 0);
-ERROR: block 0 is a meta page
+ERROR: function bt_page_items(unknown, integer) does not exist
+LINE 1: SELECT * FROM bt_page_items('test1_a_idx', 0);
+ ^
+DETAIL: No function of that name accepts the given number of arguments.
SELECT * FROM bt_page_items('test1_a_idx', 1);
--[ RECORD 1 ]-----------------------
... |
|
Linux - Debian Trixie - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/pageinspect/expected/btree.out /tmp/cirrus-ci-build/build/testrun/pageinspect/regr...
--- /tmp/cirrus-ci-build/contrib/pageinspect/expected/btree.out 2026-02-13 12:15:25.826489843 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pageinspect/regress/results/btree.out 2026-02-13 12:19:30.162011997 +0000
@@ -148,23 +148,25 @@
ERROR: block number 7 is out of range
DROP TABLE test2;
SELECT * FROM bt_page_items('test1_a_idx', -1);
-ERROR: invalid block number -1
+ERROR: function bt_page_items(unknown, integer) does not exist
+LINE 1: SELECT * FROM bt_page_items('test1_a_idx', -1);
+ ^
+DETAIL: No function of that name accepts the given number of arguments.
SELECT * FROM bt_page_items('test1_a_idx', 0);
-ERROR: block 0 is a meta page
+ERROR: function bt_page_items(unknown, integer) does not exist
+LINE 1: SELECT * FROM bt_page_items('test1_a_idx', 0);
+ ^
+DETAIL: No function of that name accepts the given number of arguments.
SELECT * FROM bt_page_items('test1_a_idx', 1);
--[ RECORD 1 ]-----------------------
... |
|
OpenBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/contrib/pageinspect/expected/btree.out /home/postgres/postgres/build/testrun/pageinspec...
--- /home/postgres/postgres/contrib/pageinspect/expected/btree.out Fri Feb 13 12:15:29 2026
+++ /home/postgres/postgres/build/testrun/pageinspect/regress/results/btree.out Fri Feb 13 12:20:52 2026
@@ -148,23 +148,25 @@
ERROR: block number 7 is out of range
DROP TABLE test2;
SELECT * FROM bt_page_items('test1_a_idx', -1);
-ERROR: invalid block number -1
+ERROR: function bt_page_items(unknown, integer) does not exist
+LINE 1: SELECT * FROM bt_page_items('test1_a_idx', -1);
+ ^
+DETAIL: No function of that name accepts the given number of arguments.
SELECT * FROM bt_page_items('test1_a_idx', 0);
-ERROR: block 0 is a meta page
+ERROR: function bt_page_items(unknown, integer) does not exist
+LINE 1: SELECT * FROM bt_page_items('test1_a_idx', 0);
+ ^
+DETAIL: No function of that name accepts the given number of arguments.
SELECT * FROM bt_page_items('test1_a_idx', 1);
--[ RECORD 1 ]-----------------------
... |
|
Linux - Debian Trixie - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/pageinspect/expected/btree.out /tmp/cirrus-ci-build/contrib/pageinspect/results/bt...
--- /tmp/cirrus-ci-build/contrib/pageinspect/expected/btree.out 2026-02-13 12:15:55.076628321 +0000
+++ /tmp/cirrus-ci-build/contrib/pageinspect/results/btree.out 2026-02-13 12:20:17.711389108 +0000
@@ -148,23 +148,25 @@
ERROR: block number 7 is out of range
DROP TABLE test2;
SELECT * FROM bt_page_items('test1_a_idx', -1);
-ERROR: invalid block number -1
+ERROR: function bt_page_items(unknown, integer) does not exist
+LINE 1: SELECT * FROM bt_page_items('test1_a_idx', -1);
+ ^
+DETAIL: No function of that name accepts the given number of arguments.
SELECT * FROM bt_page_items('test1_a_idx', 0);
-ERROR: block 0 is a meta page
+ERROR: function bt_page_items(unknown, integer) does not exist
+LINE 1: SELECT * FROM bt_page_items('test1_a_idx', 0);
+ ^
+DETAIL: No function of that name accepts the given number of arguments.
SELECT * FROM bt_page_items('test1_a_idx', 1);
--[ RECORD 1 ]-----------------------
... |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/pageinspect/expected/btree.out /tmp/cirrus-ci-build/build/testrun/pageinspect/regr...
--- /tmp/cirrus-ci-build/contrib/pageinspect/expected/btree.out 2026-02-13 12:15:18.555819000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pageinspect/regress/results/btree.out 2026-02-13 12:18:29.191818000 +0000
@@ -148,23 +148,25 @@
ERROR: block number 7 is out of range
DROP TABLE test2;
SELECT * FROM bt_page_items('test1_a_idx', -1);
-ERROR: invalid block number -1
+ERROR: function bt_page_items(unknown, integer) does not exist
+LINE 1: SELECT * FROM bt_page_items('test1_a_idx', -1);
+ ^
+DETAIL: No function of that name accepts the given number of arguments.
SELECT * FROM bt_page_items('test1_a_idx', 0);
-ERROR: block 0 is a meta page
+ERROR: function bt_page_items(unknown, integer) does not exist
+LINE 1: SELECT * FROM bt_page_items('test1_a_idx', 0);
+ ^
+DETAIL: No function of that name accepts the given number of arguments.
SELECT * FROM bt_page_items('test1_a_idx', 1);
--[ RECORD 1 ]-----------------------
... |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/contrib/pageinspect/expected/btree.out /home/postgres/postgres/build/testrun/pageinspec...
--- /home/postgres/postgres/contrib/pageinspect/expected/btree.out 2026-02-13 12:16:41.946461799 +0000
+++ /home/postgres/postgres/build/testrun/pageinspect/regress/results/btree.out 2026-02-13 12:19:16.740391350 +0000
@@ -148,23 +148,25 @@
ERROR: block number 7 is out of range
DROP TABLE test2;
SELECT * FROM bt_page_items('test1_a_idx', -1);
-ERROR: invalid block number -1
+ERROR: function bt_page_items(unknown, integer) does not exist
+LINE 1: SELECT * FROM bt_page_items('test1_a_idx', -1);
+ ^
+DETAIL: No function of that name accepts the given number of arguments.
SELECT * FROM bt_page_items('test1_a_idx', 0);
-ERROR: block 0 is a meta page
+ERROR: function bt_page_items(unknown, integer) does not exist
+LINE 1: SELECT * FROM bt_page_items('test1_a_idx', 0);
+ ^
+DETAIL: No function of that name accepts the given number of arguments.
SELECT * FROM bt_page_items('test1_a_idx', 1);
--[ RECORD 1 ]-----------------------
... |
| 58/6388 |
pageinspect support for SpGiST |
|
Windows - Server 2022, MinGW64 - Meson |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/pageinspect/expected/spgist.out C:/cirrus/build/testrun/pageinspect/regre...
--- C:/cirrus/contrib/pageinspect/expected/spgist.out 2026-02-13 11:16:58.413070000 +0000
+++ C:/cirrus/build/testrun/pageinspect/regress/results/spgist.out 2026-02-13 11:25:49.718744900 +0000
@@ -5,40 +5,36 @@
CREATE INDEX test_spgist_idx ON test_gist USING spgist (p);
-- Page 0 is the root, the rest are leaf pages
SELECT * FROM spgist_page_opaque_info(get_raw_page('test_spgist_idx', 0));
- lsn | nplaceholder | nredirection | flags
-------------+--------------+--------------+--------
- 0/00000000 | 0 | 0 | {meta}
-(1 row)
-
+ERROR: function get_raw_page(unknown, integer) does not exist
+LINE 1: SELECT * FROM spgist_page_opaque_info(get_raw_page('test_spg...
+ ^
+DETAIL: There is no function of that name.
SELECT * FROM spgist_page_opaque_info(get_raw_page('test_spgist_idx', 1));
- lsn | nplaceholder | nredirection | flags
-------------+--------------+--------------+-------
- 0/00000000 | 0 | 0 | {}
... |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/pageinspect/expected/spgist.out C:/cirrus/build/testrun/pageinspect/regre...
--- C:/cirrus/contrib/pageinspect/expected/spgist.out 2026-02-13 11:16:56.434408200 +0000
+++ C:/cirrus/build/testrun/pageinspect/regress/results/spgist.out 2026-02-13 11:26:31.580636300 +0000
@@ -5,40 +5,36 @@
CREATE INDEX test_spgist_idx ON test_gist USING spgist (p);
-- Page 0 is the root, the rest are leaf pages
SELECT * FROM spgist_page_opaque_info(get_raw_page('test_spgist_idx', 0));
- lsn | nplaceholder | nredirection | flags
-------------+--------------+--------------+--------
- 0/00000000 | 0 | 0 | {meta}
-(1 row)
-
+ERROR: function get_raw_page(unknown, integer) does not exist
+LINE 1: SELECT * FROM spgist_page_opaque_info(get_raw_page('test_spg...
+ ^
+DETAIL: There is no function of that name.
SELECT * FROM spgist_page_opaque_info(get_raw_page('test_spgist_idx', 1));
- lsn | nplaceholder | nredirection | flags
-------------+--------------+--------------+-------
- 0/00000000 | 0 | 0 | {}
... |
|
Linux - Debian Trixie - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/pageinspect/expected/spgist.out /tmp/cirrus-ci-build/build/testrun/pageinspect/reg...
--- /tmp/cirrus-ci-build/contrib/pageinspect/expected/spgist.out 2026-02-13 11:16:50.273197662 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pageinspect/regress/results/spgist.out 2026-02-13 11:20:58.255377259 +0000
@@ -5,40 +5,36 @@
CREATE INDEX test_spgist_idx ON test_gist USING spgist (p);
-- Page 0 is the root, the rest are leaf pages
SELECT * FROM spgist_page_opaque_info(get_raw_page('test_spgist_idx', 0));
- lsn | nplaceholder | nredirection | flags
-------------+--------------+--------------+--------
- 0/00000000 | 0 | 0 | {meta}
-(1 row)
-
+ERROR: function get_raw_page(unknown, integer) does not exist
+LINE 1: SELECT * FROM spgist_page_opaque_info(get_raw_page('test_spg...
+ ^
+DETAIL: There is no function of that name.
SELECT * FROM spgist_page_opaque_info(get_raw_page('test_spgist_idx', 1));
- lsn | nplaceholder | nredirection | flags
-------------+--------------+--------------+-------
- 0/00000000 | 0 | 0 | {}
... |
|
macOS - Sequoia - Meson |
| regress |
diff -U3 /Users/admin/pgsql/contrib/pageinspect/expected/spgist.out /Users/admin/pgsql/build/testrun/pageinspect/regress...
--- /Users/admin/pgsql/contrib/pageinspect/expected/spgist.out 2026-02-13 11:16:50
+++ /Users/admin/pgsql/build/testrun/pageinspect/regress/results/spgist.out 2026-02-13 11:21:27
@@ -5,40 +5,36 @@
CREATE INDEX test_spgist_idx ON test_gist USING spgist (p);
-- Page 0 is the root, the rest are leaf pages
SELECT * FROM spgist_page_opaque_info(get_raw_page('test_spgist_idx', 0));
- lsn | nplaceholder | nredirection | flags
-------------+--------------+--------------+--------
- 0/00000000 | 0 | 0 | {meta}
-(1 row)
-
+ERROR: function get_raw_page(unknown, integer) does not exist
+LINE 1: SELECT * FROM spgist_page_opaque_info(get_raw_page('test_spg...
+ ^
+DETAIL: There is no function of that name.
SELECT * FROM spgist_page_opaque_info(get_raw_page('test_spgist_idx', 1));
- lsn | nplaceholder | nredirection | flags
-------------+--------------+--------------+-------
- 0/00000000 | 0 | 0 | {}
... |
|
OpenBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/contrib/pageinspect/expected/spgist.out /home/postgres/postgres/build/testrun/pageinspe...
--- /home/postgres/postgres/contrib/pageinspect/expected/spgist.out Fri Feb 13 11:16:58 2026
+++ /home/postgres/postgres/build/testrun/pageinspect/regress/results/spgist.out Fri Feb 13 11:22:19 2026
@@ -5,40 +5,36 @@
CREATE INDEX test_spgist_idx ON test_gist USING spgist (p);
-- Page 0 is the root, the rest are leaf pages
SELECT * FROM spgist_page_opaque_info(get_raw_page('test_spgist_idx', 0));
- lsn | nplaceholder | nredirection | flags
-------------+--------------+--------------+--------
- 0/00000000 | 0 | 0 | {meta}
-(1 row)
-
+ERROR: function get_raw_page(unknown, integer) does not exist
+LINE 1: SELECT * FROM spgist_page_opaque_info(get_raw_page('test_spg...
+ ^
+DETAIL: There is no function of that name.
SELECT * FROM spgist_page_opaque_info(get_raw_page('test_spgist_idx', 1));
- lsn | nplaceholder | nredirection | flags
-------------+--------------+--------------+-------
- 0/00000000 | 0 | 0 | {}
... |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/contrib/pageinspect/expected/spgist.out /home/postgres/postgres/build/testrun/pageinspe...
--- /home/postgres/postgres/contrib/pageinspect/expected/spgist.out 2026-02-13 11:17:57.584883547 +0000
+++ /home/postgres/postgres/build/testrun/pageinspect/regress/results/spgist.out 2026-02-13 11:20:34.816870466 +0000
@@ -5,40 +5,36 @@
CREATE INDEX test_spgist_idx ON test_gist USING spgist (p);
-- Page 0 is the root, the rest are leaf pages
SELECT * FROM spgist_page_opaque_info(get_raw_page('test_spgist_idx', 0));
- lsn | nplaceholder | nredirection | flags
-------------+--------------+--------------+--------
- 0/00000000 | 0 | 0 | {meta}
-(1 row)
-
+ERROR: function get_raw_page(unknown, integer) does not exist
+LINE 1: SELECT * FROM spgist_page_opaque_info(get_raw_page('test_spg...
+ ^
+DETAIL: There is no function of that name.
SELECT * FROM spgist_page_opaque_info(get_raw_page('test_spgist_idx', 1));
- lsn | nplaceholder | nredirection | flags
-------------+--------------+--------------+-------
- 0/00000000 | 0 | 0 | {}
... |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/pageinspect/expected/spgist.out /tmp/cirrus-ci-build/build/testrun/pageinspect/reg...
--- /tmp/cirrus-ci-build/contrib/pageinspect/expected/spgist.out 2026-02-13 11:16:40.985712000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pageinspect/regress/results/spgist.out 2026-02-13 11:19:53.825179000 +0000
@@ -5,40 +5,36 @@
CREATE INDEX test_spgist_idx ON test_gist USING spgist (p);
-- Page 0 is the root, the rest are leaf pages
SELECT * FROM spgist_page_opaque_info(get_raw_page('test_spgist_idx', 0));
- lsn | nplaceholder | nredirection | flags
-------------+--------------+--------------+--------
- 0/00000000 | 0 | 0 | {meta}
-(1 row)
-
+ERROR: function get_raw_page(unknown, integer) does not exist
+LINE 1: SELECT * FROM spgist_page_opaque_info(get_raw_page('test_spg...
+ ^
+DETAIL: There is no function of that name.
SELECT * FROM spgist_page_opaque_info(get_raw_page('test_spgist_idx', 1));
- lsn | nplaceholder | nredirection | flags
-------------+--------------+--------------+-------
- 0/00000000 | 0 | 0 | {}
... |
| 58/6455 |
Convert NOT IN sublinks to anti-joins when safe |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/pg_stat_statements/expected/level_tracking.out C:/cirrus/build/testrun/pg...
--- C:/cirrus/contrib/pg_stat_statements/expected/level_tracking.out 2026-02-13 01:27:06.740641600 +0000
+++ C:/cirrus/build/testrun/pg_stat_statements/regress/results/level_tracking.out 2026-02-13 01:35:27.905420700 +0000
@@ -1342,14 +1342,7 @@
SELECT toplevel, calls, rows, query FROM pg_stat_statements
WHERE toplevel IS FALSE
ORDER BY query COLLATE "C";
- toplevel | calls | rows | query
-----------+-------+------+-------------------------------------
- f | 1 | 0 | CREATE TABLE pgss_do_table (id INT)
- f | 1 | 0 | DROP TABLE pgss_do_table
- f | 1 | 0 | SELECT a FROM pgss_do_util_tab_1
- f | 1 | 0 | SELECT a FROM pgss_do_util_tab_2
-(4 rows)
-
+ERROR: no relation entry for relid 2
SELECT pg_stat_statements_reset() IS NOT NULL AS t;
t
---
@@ -1365,14 +1358,7 @@
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/boolean.out C:/cirrus/build/testrun/pg_upgrade/002_pg_u...
--- C:/cirrus/src/test/regress/expected/boolean.out 2026-02-13 01:27:11.672250900 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/boolean.out 2026-02-13 01:29:44.187287600 +0000
@@ -392,75 +392,35 @@
SELECT f1
FROM BOOLTBL1
WHERE f1 IS TRUE;
- f1
-----
- t
- t
- t
-(3 rows)
-
+ERROR: no relation entry for relid 1
SELECT f1
FROM BOOLTBL1
WHERE f1 IS NOT FALSE;
- f1
-----
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/postgres_fdw/expected/postgres_fdw.out C:/cirrus/build/testrun/postgres_f...
--- C:/cirrus/contrib/postgres_fdw/expected/postgres_fdw.out 2026-02-13 01:27:06.942070000 +0000
+++ C:/cirrus/build/testrun/postgres_fdw/regress/results/postgres_fdw.out 2026-02-13 01:35:41.731101800 +0000
@@ -699,13 +699,7 @@
(3 rows)
EXPLAIN (VERBOSE, COSTS OFF) SELECT * FROM ft1 t1 WHERE c3 IS DISTINCT FROM c3; -- DistinctExpr
- QUERY PLAN
-----------------------------------------------------------------------------------------------------------
- Foreign Scan on public.ft1 t1
- Output: c1, c2, c3, c4, c5, c6, c7, c8
- Remote SQL: SELECT "C 1", c2, c3, c4, c5, c6, c7, c8 FROM "S 1"."T 1" WHERE ((c3 IS DISTINCT FROM c3))
-(3 rows)
-
+ERROR: no relation entry for relid 1
EXPLAIN (VERBOSE, COSTS OFF) SELECT * FROM ft1 t1 WHERE c1 = ANY(ARRAY[c2, 1, c1 + 0]); -- ScalarArrayOpExpr
QUERY PLAN ...
-----------------------------------------------------------------------------------------------------------------------...
@@ -12705,11 +12699,7 @@
remote_backend_pid = (SELECT pid FROM pg_stat_activity
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/boolean.out C:/cirrus/build/testrun/recovery/027_stream...
--- C:/cirrus/src/test/regress/expected/boolean.out 2026-02-13 01:27:11.672250900 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/boolean.out 2026-02-13 01:32:27.631560300 +0000
@@ -392,75 +392,35 @@
SELECT f1
FROM BOOLTBL1
WHERE f1 IS TRUE;
- f1
-----
- t
- t
- t
-(3 rows)
-
+ERROR: no relation entry for relid 1
SELECT f1
FROM BOOLTBL1
WHERE f1 IS NOT FALSE;
- f1
-----
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/boolean.out C:/cirrus/build/testrun/regress/regress/res...
--- C:/cirrus/src/test/regress/expected/boolean.out 2026-02-13 01:27:11.672250900 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/boolean.out 2026-02-13 01:29:39.259053200 +0000
@@ -392,75 +392,35 @@
SELECT f1
FROM BOOLTBL1
WHERE f1 IS TRUE;
- f1
-----
- t
- t
- t
-(3 rows)
-
+ERROR: no relation entry for relid 1
SELECT f1
FROM BOOLTBL1
WHERE f1 IS NOT FALSE;
- f1
-----
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/modules/test_predtest/expected/test_predtest.out C:/cirrus/build/testrun...
--- C:/cirrus/src/test/modules/test_predtest/expected/test_predtest.out 2026-02-13 01:27:11.503880600 +0000
+++ C:/cirrus/build/testrun/test_predtest/regress/results/test_predtest.out 2026-02-13 01:36:01.148567700 +0000
@@ -125,86 +125,56 @@
select x is not true, x
from booleans
$$);
--[ RECORD 1 ]-----+--
-strong_implied_by | f
-weak_implied_by | f
-strong_refuted_by | t
-weak_refuted_by | t
-s_i_holds | f
-w_i_holds | f
-s_r_holds | t
-w_r_holds | t
-
+ERROR: no relation entry for relid 1
+CONTEXT: SQL statement "
+select x is not true, x
... |
|
macOS - Sequoia - Meson |
| regress |
diff -U3 /Users/admin/pgsql/contrib/pg_stat_statements/expected/level_tracking.out /Users/admin/pgsql/build/testrun/pg_s...
--- /Users/admin/pgsql/contrib/pg_stat_statements/expected/level_tracking.out 2026-02-13 01:26:50
+++ /Users/admin/pgsql/build/testrun/pg_stat_statements/regress/results/level_tracking.out 2026-02-13 01:31:48
@@ -1342,14 +1342,7 @@
SELECT toplevel, calls, rows, query FROM pg_stat_statements
WHERE toplevel IS FALSE
ORDER BY query COLLATE "C";
- toplevel | calls | rows | query
-----------+-------+------+-------------------------------------
- f | 1 | 0 | CREATE TABLE pgss_do_table (id INT)
- f | 1 | 0 | DROP TABLE pgss_do_table
- f | 1 | 0 | SELECT a FROM pgss_do_util_tab_1
- f | 1 | 0 | SELECT a FROM pgss_do_util_tab_2
-(4 rows)
-
+ERROR: no relation entry for relid 2
SELECT pg_stat_statements_reset() IS NOT NULL AS t;
t
---
@@ -1365,14 +1358,7 @@
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/boolean.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upg...
--- /Users/admin/pgsql/src/test/regress/expected/boolean.out 2026-02-13 01:26:52
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/boolean.out 2026-02-13 01:28:48
@@ -392,75 +392,35 @@
SELECT f1
FROM BOOLTBL1
WHERE f1 IS TRUE;
- f1
-----
- t
- t
- t
-(3 rows)
-
+ERROR: no relation entry for relid 1
SELECT f1
FROM BOOLTBL1
WHERE f1 IS NOT FALSE;
- f1
-----
... |
| regress |
diff -U3 /Users/admin/pgsql/contrib/postgres_fdw/expected/postgres_fdw.out /Users/admin/pgsql/build/testrun/postgres_fdw...
--- /Users/admin/pgsql/contrib/postgres_fdw/expected/postgres_fdw.out 2026-02-13 01:26:51
+++ /Users/admin/pgsql/build/testrun/postgres_fdw/regress/results/postgres_fdw.out 2026-02-13 01:31:59
@@ -699,13 +699,7 @@
(3 rows)
EXPLAIN (VERBOSE, COSTS OFF) SELECT * FROM ft1 t1 WHERE c3 IS DISTINCT FROM c3; -- DistinctExpr
- QUERY PLAN
-----------------------------------------------------------------------------------------------------------
- Foreign Scan on public.ft1 t1
- Output: c1, c2, c3, c4, c5, c6, c7, c8
- Remote SQL: SELECT "C 1", c2, c3, c4, c5, c6, c7, c8 FROM "S 1"."T 1" WHERE ((c3 IS DISTINCT FROM c3))
-(3 rows)
-
+ERROR: no relation entry for relid 1
EXPLAIN (VERBOSE, COSTS OFF) SELECT * FROM ft1 t1 WHERE c1 = ANY(ARRAY[c2, 1, c1 + 0]); -- ScalarArrayOpExpr
QUERY PLAN ...
-----------------------------------------------------------------------------------------------------------------------...
@@ -12705,11 +12699,7 @@
remote_backend_pid = (SELECT pid FROM pg_stat_activity
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/boolean.out /Users/admin/pgsql/build/testrun/recovery/027_stream_r...
--- /Users/admin/pgsql/src/test/regress/expected/boolean.out 2026-02-13 01:26:52
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/boolean.out 2026-02-13 01:30:18
@@ -392,75 +392,35 @@
SELECT f1
FROM BOOLTBL1
WHERE f1 IS TRUE;
- f1
-----
- t
- t
- t
-(3 rows)
-
+ERROR: no relation entry for relid 1
SELECT f1
FROM BOOLTBL1
WHERE f1 IS NOT FALSE;
- f1
-----
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/boolean.out /Users/admin/pgsql/build/testrun/regress/regress/resul...
--- /Users/admin/pgsql/src/test/regress/expected/boolean.out 2026-02-13 01:26:52
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/boolean.out 2026-02-13 01:28:46
@@ -392,75 +392,35 @@
SELECT f1
FROM BOOLTBL1
WHERE f1 IS TRUE;
- f1
-----
- t
- t
- t
-(3 rows)
-
+ERROR: no relation entry for relid 1
SELECT f1
FROM BOOLTBL1
WHERE f1 IS NOT FALSE;
- f1
-----
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/modules/test_predtest/expected/test_predtest.out /Users/admin/pgsql/build/testrun/t...
--- /Users/admin/pgsql/src/test/modules/test_predtest/expected/test_predtest.out 2026-02-13 01:26:52
+++ /Users/admin/pgsql/build/testrun/test_predtest/regress/results/test_predtest.out 2026-02-13 01:32:09
@@ -125,86 +125,56 @@
select x is not true, x
from booleans
$$);
--[ RECORD 1 ]-----+--
-strong_implied_by | f
-weak_implied_by | f
-strong_refuted_by | t
-weak_refuted_by | t
-s_i_holds | f
-w_i_holds | f
-s_r_holds | t
-w_r_holds | t
-
+ERROR: no relation entry for relid 1
+CONTEXT: SQL statement "
+select x is not true, x
... |
|
Windows - Server 2022, MinGW64 - Meson |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/pg_stat_statements/expected/level_tracking.out C:/cirrus/build/testrun/pg...
--- C:/cirrus/contrib/pg_stat_statements/expected/level_tracking.out 2026-02-13 01:27:21.675669400 +0000
+++ C:/cirrus/build/testrun/pg_stat_statements/regress/results/level_tracking.out 2026-02-13 01:36:39.609935400 +0000
@@ -1342,14 +1342,7 @@
SELECT toplevel, calls, rows, query FROM pg_stat_statements
WHERE toplevel IS FALSE
ORDER BY query COLLATE "C";
- toplevel | calls | rows | query
-----------+-------+------+-------------------------------------
- f | 1 | 0 | CREATE TABLE pgss_do_table (id INT)
- f | 1 | 0 | DROP TABLE pgss_do_table
- f | 1 | 0 | SELECT a FROM pgss_do_util_tab_1
- f | 1 | 0 | SELECT a FROM pgss_do_util_tab_2
-(4 rows)
-
+ERROR: no relation entry for relid 2
SELECT pg_stat_statements_reset() IS NOT NULL AS t;
t
---
@@ -1365,14 +1358,7 @@
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/boolean.out C:/cirrus/build/testrun/pg_upgrade/002_pg_u...
--- C:/cirrus/src/test/regress/expected/boolean.out 2026-02-13 01:27:26.816187100 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/boolean.out 2026-02-13 01:31:00.084689200 +0000
@@ -392,75 +392,35 @@
SELECT f1
FROM BOOLTBL1
WHERE f1 IS TRUE;
- f1
-----
- t
- t
- t
-(3 rows)
-
+ERROR: no relation entry for relid 1
SELECT f1
FROM BOOLTBL1
WHERE f1 IS NOT FALSE;
- f1
-----
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/postgres_fdw/expected/postgres_fdw.out C:/cirrus/build/testrun/postgres_f...
--- C:/cirrus/contrib/postgres_fdw/expected/postgres_fdw.out 2026-02-13 01:27:21.886450100 +0000
+++ C:/cirrus/build/testrun/postgres_fdw/regress/results/postgres_fdw.out 2026-02-13 01:36:49.722234500 +0000
@@ -699,13 +699,7 @@
(3 rows)
EXPLAIN (VERBOSE, COSTS OFF) SELECT * FROM ft1 t1 WHERE c3 IS DISTINCT FROM c3; -- DistinctExpr
- QUERY PLAN
-----------------------------------------------------------------------------------------------------------
- Foreign Scan on public.ft1 t1
- Output: c1, c2, c3, c4, c5, c6, c7, c8
- Remote SQL: SELECT "C 1", c2, c3, c4, c5, c6, c7, c8 FROM "S 1"."T 1" WHERE ((c3 IS DISTINCT FROM c3))
-(3 rows)
-
+ERROR: no relation entry for relid 1
EXPLAIN (VERBOSE, COSTS OFF) SELECT * FROM ft1 t1 WHERE c1 = ANY(ARRAY[c2, 1, c1 + 0]); -- ScalarArrayOpExpr
QUERY PLAN ...
-----------------------------------------------------------------------------------------------------------------------...
@@ -12705,11 +12699,7 @@
remote_backend_pid = (SELECT pid FROM pg_stat_activity
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/boolean.out C:/cirrus/build/testrun/recovery/027_stream...
--- C:/cirrus/src/test/regress/expected/boolean.out 2026-02-13 01:27:26.816187100 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/boolean.out 2026-02-13 01:33:48.252581700 +0000
@@ -392,75 +392,35 @@
SELECT f1
FROM BOOLTBL1
WHERE f1 IS TRUE;
- f1
-----
- t
- t
- t
-(3 rows)
-
+ERROR: no relation entry for relid 1
SELECT f1
FROM BOOLTBL1
WHERE f1 IS NOT FALSE;
- f1
-----
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/boolean.out C:/cirrus/build/testrun/regress/regress/res...
--- C:/cirrus/src/test/regress/expected/boolean.out 2026-02-13 01:27:26.816187100 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/boolean.out 2026-02-13 01:30:56.877656500 +0000
@@ -392,75 +392,35 @@
SELECT f1
FROM BOOLTBL1
WHERE f1 IS TRUE;
- f1
-----
- t
- t
- t
-(3 rows)
-
+ERROR: no relation entry for relid 1
SELECT f1
FROM BOOLTBL1
WHERE f1 IS NOT FALSE;
- f1
-----
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/modules/test_predtest/expected/test_predtest.out C:/cirrus/build/testrun...
--- C:/cirrus/src/test/modules/test_predtest/expected/test_predtest.out 2026-02-13 01:27:26.584894900 +0000
+++ C:/cirrus/build/testrun/test_predtest/regress/results/test_predtest.out 2026-02-13 01:37:15.325734400 +0000
@@ -125,86 +125,56 @@
select x is not true, x
from booleans
$$);
--[ RECORD 1 ]-----+--
-strong_implied_by | f
-weak_implied_by | f
-strong_refuted_by | t
-weak_refuted_by | t
-s_i_holds | f
-w_i_holds | f
-s_r_holds | t
-w_r_holds | t
-
+ERROR: no relation entry for relid 1
+CONTEXT: SQL statement "
+select x is not true, x
... |
|
Linux - Debian Trixie - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/pg_stat_statements/expected/level_tracking.out /tmp/cirrus-ci-build/build/testrun/...
--- /tmp/cirrus-ci-build/contrib/pg_stat_statements/expected/level_tracking.out 2026-02-13 01:27:06.367117749 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_stat_statements/regress/results/level_tracking.out 2026-02-13 01:32:40.1737491...
@@ -1342,14 +1342,7 @@
SELECT toplevel, calls, rows, query FROM pg_stat_statements
WHERE toplevel IS FALSE
ORDER BY query COLLATE "C";
- toplevel | calls | rows | query
-----------+-------+------+-------------------------------------
- f | 1 | 0 | CREATE TABLE pgss_do_table (id INT)
- f | 1 | 0 | DROP TABLE pgss_do_table
- f | 1 | 0 | SELECT a FROM pgss_do_util_tab_1
- f | 1 | 0 | SELECT a FROM pgss_do_util_tab_2
-(4 rows)
-
+ERROR: no relation entry for relid 2
SELECT pg_stat_statements_reset() IS NOT NULL AS t;
t
---
@@ -1365,14 +1358,7 @@
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/boolean.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg...
--- /tmp/cirrus-ci-build/src/test/regress/expected/boolean.out 2026-02-13 01:27:08.159117679 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/boolean.out 2026-02-13 01:30:05.273777787 ...
@@ -392,75 +392,35 @@
SELECT f1
FROM BOOLTBL1
WHERE f1 IS TRUE;
- f1
-----
- t
- t
- t
-(3 rows)
-
+ERROR: no relation entry for relid 1
SELECT f1
FROM BOOLTBL1
WHERE f1 IS NOT FALSE;
- f1
-----
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out /tmp/cirrus-ci-build/build/testrun/postgres...
--- /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out 2026-02-13 01:27:06.411117747 +0000
+++ /tmp/cirrus-ci-build/build/testrun/postgres_fdw/regress/results/postgres_fdw.out 2026-02-13 01:32:57.717746498 +0000
@@ -699,13 +699,7 @@
(3 rows)
EXPLAIN (VERBOSE, COSTS OFF) SELECT * FROM ft1 t1 WHERE c3 IS DISTINCT FROM c3; -- DistinctExpr
- QUERY PLAN
-----------------------------------------------------------------------------------------------------------
- Foreign Scan on public.ft1 t1
- Output: c1, c2, c3, c4, c5, c6, c7, c8
- Remote SQL: SELECT "C 1", c2, c3, c4, c5, c6, c7, c8 FROM "S 1"."T 1" WHERE ((c3 IS DISTINCT FROM c3))
-(3 rows)
-
+ERROR: no relation entry for relid 1
EXPLAIN (VERBOSE, COSTS OFF) SELECT * FROM ft1 t1 WHERE c1 = ANY(ARRAY[c2, 1, c1 + 0]); -- ScalarArrayOpExpr
QUERY PLAN ...
-----------------------------------------------------------------------------------------------------------------------...
@@ -12705,11 +12699,7 @@
remote_backend_pid = (SELECT pid FROM pg_stat_activity
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/boolean.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stre...
--- /tmp/cirrus-ci-build/src/test/regress/expected/boolean.out 2026-02-13 01:27:08.159117679 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/boolean.out 2026-02-13 01:31:19.68576313...
@@ -392,75 +392,35 @@
SELECT f1
FROM BOOLTBL1
WHERE f1 IS TRUE;
- f1
-----
- t
- t
- t
-(3 rows)
-
+ERROR: no relation entry for relid 1
SELECT f1
FROM BOOLTBL1
WHERE f1 IS NOT FALSE;
- f1
-----
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/boolean.out /tmp/cirrus-ci-build/build/testrun/regress/regress/r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/boolean.out 2026-02-13 01:27:08.159117679 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/boolean.out 2026-02-13 01:30:04.141777940 +0000
@@ -392,75 +392,35 @@
SELECT f1
FROM BOOLTBL1
WHERE f1 IS TRUE;
- f1
-----
- t
- t
- t
-(3 rows)
-
+ERROR: no relation entry for relid 1
SELECT f1
FROM BOOLTBL1
WHERE f1 IS NOT FALSE;
- f1
-----
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/modules/test_predtest/expected/test_predtest.out /tmp/cirrus-ci-build/build/testr...
--- /tmp/cirrus-ci-build/src/test/modules/test_predtest/expected/test_predtest.out 2026-02-13 01:27:08.103117681 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_predtest/regress/results/test_predtest.out 2026-02-13 01:33:07.969745007 +00...
@@ -125,86 +125,56 @@
select x is not true, x
from booleans
$$);
--[ RECORD 1 ]-----+--
-strong_implied_by | f
-weak_implied_by | f
-strong_refuted_by | t
-weak_refuted_by | t
-s_i_holds | f
-w_i_holds | f
-s_r_holds | t
-w_r_holds | t
-
+ERROR: no relation entry for relid 1
+CONTEXT: SQL statement "
+select x is not true, x
... |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/pg_stat_statements/expected/level_tracking.out /tmp/cirrus-ci-build/build/testrun/...
--- /tmp/cirrus-ci-build/contrib/pg_stat_statements/expected/level_tracking.out 2026-02-13 01:27:02.619062000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_stat_statements/regress/results/level_tracking.out 2026-02-13 01:30:43.2551780...
@@ -1342,14 +1342,7 @@
SELECT toplevel, calls, rows, query FROM pg_stat_statements
WHERE toplevel IS FALSE
ORDER BY query COLLATE "C";
- toplevel | calls | rows | query
-----------+-------+------+-------------------------------------
- f | 1 | 0 | CREATE TABLE pgss_do_table (id INT)
- f | 1 | 0 | DROP TABLE pgss_do_table
- f | 1 | 0 | SELECT a FROM pgss_do_util_tab_1
- f | 1 | 0 | SELECT a FROM pgss_do_util_tab_2
-(4 rows)
-
+ERROR: no relation entry for relid 2
SELECT pg_stat_statements_reset() IS NOT NULL AS t;
t
---
@@ -1365,14 +1358,7 @@
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/boolean.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg...
--- /tmp/cirrus-ci-build/src/test/regress/expected/boolean.out 2026-02-13 01:27:04.271092000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/boolean.out 2026-02-13 01:28:26.926960000 ...
@@ -392,75 +392,35 @@
SELECT f1
FROM BOOLTBL1
WHERE f1 IS TRUE;
- f1
-----
- t
- t
- t
-(3 rows)
-
+ERROR: no relation entry for relid 1
SELECT f1
FROM BOOLTBL1
WHERE f1 IS NOT FALSE;
- f1
-----
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out /tmp/cirrus-ci-build/build/testrun/postgres...
--- /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out 2026-02-13 01:27:02.654460000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/postgres_fdw/regress/results/postgres_fdw.out 2026-02-13 01:31:26.328487000 +0000
@@ -699,13 +699,7 @@
(3 rows)
EXPLAIN (VERBOSE, COSTS OFF) SELECT * FROM ft1 t1 WHERE c3 IS DISTINCT FROM c3; -- DistinctExpr
- QUERY PLAN
-----------------------------------------------------------------------------------------------------------
- Foreign Scan on public.ft1 t1
- Output: c1, c2, c3, c4, c5, c6, c7, c8
- Remote SQL: SELECT "C 1", c2, c3, c4, c5, c6, c7, c8 FROM "S 1"."T 1" WHERE ((c3 IS DISTINCT FROM c3))
-(3 rows)
-
+ERROR: no relation entry for relid 1
EXPLAIN (VERBOSE, COSTS OFF) SELECT * FROM ft1 t1 WHERE c1 = ANY(ARRAY[c2, 1, c1 + 0]); -- ScalarArrayOpExpr
QUERY PLAN ...
-----------------------------------------------------------------------------------------------------------------------...
@@ -12705,11 +12699,7 @@
remote_backend_pid = (SELECT pid FROM pg_stat_activity
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/boolean.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stre...
--- /tmp/cirrus-ci-build/src/test/regress/expected/boolean.out 2026-02-13 01:27:04.271092000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/boolean.out 2026-02-13 01:29:09.51540600...
@@ -392,75 +392,35 @@
SELECT f1
FROM BOOLTBL1
WHERE f1 IS TRUE;
- f1
-----
- t
- t
- t
-(3 rows)
-
+ERROR: no relation entry for relid 1
SELECT f1
FROM BOOLTBL1
WHERE f1 IS NOT FALSE;
- f1
-----
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/boolean.out /tmp/cirrus-ci-build/build/testrun/regress/regress/r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/boolean.out 2026-02-13 01:27:04.271092000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/boolean.out 2026-02-13 01:28:25.698735000 +0000
@@ -392,75 +392,35 @@
SELECT f1
FROM BOOLTBL1
WHERE f1 IS TRUE;
- f1
-----
- t
- t
- t
-(3 rows)
-
+ERROR: no relation entry for relid 1
SELECT f1
FROM BOOLTBL1
WHERE f1 IS NOT FALSE;
- f1
-----
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/modules/test_predtest/expected/test_predtest.out /tmp/cirrus-ci-build/build/testr...
--- /tmp/cirrus-ci-build/src/test/modules/test_predtest/expected/test_predtest.out 2026-02-13 01:27:04.219066000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_predtest/regress/results/test_predtest.out 2026-02-13 01:31:19.346397000 +00...
@@ -125,86 +125,56 @@
select x is not true, x
from booleans
$$);
--[ RECORD 1 ]-----+--
-strong_implied_by | f
-weak_implied_by | f
-strong_refuted_by | t
-weak_refuted_by | t
-s_i_holds | f
-w_i_holds | f
-s_r_holds | t
-w_r_holds | t
-
+ERROR: no relation entry for relid 1
+CONTEXT: SQL statement "
+select x is not true, x
... |
|
Linux - Debian Trixie - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/pg_stat_statements/expected/level_tracking.out /tmp/cirrus-ci-build/contrib/pg_sta...
--- /tmp/cirrus-ci-build/contrib/pg_stat_statements/expected/level_tracking.out 2026-02-13 01:27:18.772076900 +0000
+++ /tmp/cirrus-ci-build/contrib/pg_stat_statements/results/level_tracking.out 2026-02-13 01:33:00.750994960 +0000
@@ -1342,14 +1342,7 @@
SELECT toplevel, calls, rows, query FROM pg_stat_statements
WHERE toplevel IS FALSE
ORDER BY query COLLATE "C";
- toplevel | calls | rows | query
-----------+-------+------+-------------------------------------
- f | 1 | 0 | CREATE TABLE pgss_do_table (id INT)
- f | 1 | 0 | DROP TABLE pgss_do_table
- f | 1 | 0 | SELECT a FROM pgss_do_util_tab_1
- f | 1 | 0 | SELECT a FROM pgss_do_util_tab_2
-(4 rows)
-
+ERROR: no relation entry for relid 2
SELECT pg_stat_statements_reset() IS NOT NULL AS t;
t
---
@@ -1365,14 +1358,7 @@
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/modules/test_predtest/expected/test_predtest.out /tmp/cirrus-ci-build/src/test/mo...
--- /tmp/cirrus-ci-build/src/test/modules/test_predtest/expected/test_predtest.out 2026-02-13 01:27:20.539057134 +0000
+++ /tmp/cirrus-ci-build/src/test/modules/test_predtest/results/test_predtest.out 2026-02-13 01:33:07.731019294 +0000
@@ -125,86 +125,56 @@
select x is not true, x
from booleans
$$);
--[ RECORD 1 ]-----+--
-strong_implied_by | f
-weak_implied_by | f
-strong_refuted_by | t
-weak_refuted_by | t
-s_i_holds | f
-w_i_holds | f
-s_r_holds | t
-w_r_holds | t
-
+ERROR: no relation entry for relid 1
+CONTEXT: SQL statement "
+select x is not true, x
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/boolean.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check/res...
--- /tmp/cirrus-ci-build/src/test/regress/expected/boolean.out 2026-02-13 01:27:20.595150516 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/boolean.out 2026-02-13 01:33:54.879159700 +0000
@@ -392,75 +392,35 @@
SELECT f1
FROM BOOLTBL1
WHERE f1 IS TRUE;
- f1
-----
- t
- t
- t
-(3 rows)
-
+ERROR: no relation entry for relid 1
SELECT f1
FROM BOOLTBL1
WHERE f1 IS NOT FALSE;
- f1
-----
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/boolean.out /tmp/cirrus-ci-build/src/test/regress/results/boolea...
--- /tmp/cirrus-ci-build/src/test/regress/expected/boolean.out 2026-02-13 01:27:20.595150516 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/boolean.out 2026-02-13 01:30:51.220968855 +0000
@@ -392,75 +392,35 @@
SELECT f1
FROM BOOLTBL1
WHERE f1 IS TRUE;
- f1
-----
- t
- t
- t
-(3 rows)
-
+ERROR: no relation entry for relid 1
SELECT f1
FROM BOOLTBL1
WHERE f1 IS NOT FALSE;
- f1
-----
... |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/contrib/pg_stat_statements/expected/level_tracking.out /home/postgres/postgres/build/te...
--- /home/postgres/postgres/contrib/pg_stat_statements/expected/level_tracking.out 2026-02-13 01:27:36.964084596 +0000
+++ /home/postgres/postgres/build/testrun/pg_stat_statements/regress/results/level_tracking.out 2026-02-13 01:30:56.5238...
@@ -1342,14 +1342,7 @@
SELECT toplevel, calls, rows, query FROM pg_stat_statements
WHERE toplevel IS FALSE
ORDER BY query COLLATE "C";
- toplevel | calls | rows | query
-----------+-------+------+-------------------------------------
- f | 1 | 0 | CREATE TABLE pgss_do_table (id INT)
- f | 1 | 0 | DROP TABLE pgss_do_table
- f | 1 | 0 | SELECT a FROM pgss_do_util_tab_1
- f | 1 | 0 | SELECT a FROM pgss_do_util_tab_2
-(4 rows)
-
+ERROR: no relation entry for relid 2
SELECT pg_stat_statements_reset() IS NOT NULL AS t;
t
---
@@ -1365,14 +1358,7 @@
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/boolean.out /home/postgres/postgres/build/testrun/pg_upgrade/...
--- /home/postgres/postgres/src/test/regress/expected/boolean.out 2026-02-13 01:27:47.464365869 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/boolean.out 2026-02-13 01:29:42.3480042...
@@ -392,75 +392,35 @@
SELECT f1
FROM BOOLTBL1
WHERE f1 IS TRUE;
- f1
-----
- t
- t
- t
-(3 rows)
-
+ERROR: no relation entry for relid 1
SELECT f1
FROM BOOLTBL1
WHERE f1 IS NOT FALSE;
- f1
-----
... |
| regress |
diff -U3 /home/postgres/postgres/contrib/postgres_fdw/expected/postgres_fdw.out /home/postgres/postgres/build/testrun/po...
--- /home/postgres/postgres/contrib/postgres_fdw/expected/postgres_fdw.out 2026-02-13 01:27:37.352616793 +0000
+++ /home/postgres/postgres/build/testrun/postgres_fdw/regress/results/postgres_fdw.out 2026-02-13 01:31:03.344408853 +0...
@@ -699,13 +699,7 @@
(3 rows)
EXPLAIN (VERBOSE, COSTS OFF) SELECT * FROM ft1 t1 WHERE c3 IS DISTINCT FROM c3; -- DistinctExpr
- QUERY PLAN
-----------------------------------------------------------------------------------------------------------
- Foreign Scan on public.ft1 t1
- Output: c1, c2, c3, c4, c5, c6, c7, c8
- Remote SQL: SELECT "C 1", c2, c3, c4, c5, c6, c7, c8 FROM "S 1"."T 1" WHERE ((c3 IS DISTINCT FROM c3))
-(3 rows)
-
+ERROR: no relation entry for relid 1
EXPLAIN (VERBOSE, COSTS OFF) SELECT * FROM ft1 t1 WHERE c1 = ANY(ARRAY[c2, 1, c1 + 0]); -- ScalarArrayOpExpr
QUERY PLAN ...
-----------------------------------------------------------------------------------------------------------------------...
@@ -12705,11 +12699,7 @@
remote_backend_pid = (SELECT pid FROM pg_stat_activity
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/boolean.out /home/postgres/postgres/build/testrun/recovery/02...
--- /home/postgres/postgres/src/test/regress/expected/boolean.out 2026-02-13 01:27:47.464365869 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/boolean.out 2026-02-13 01:30:06.70109...
@@ -392,75 +392,35 @@
SELECT f1
FROM BOOLTBL1
WHERE f1 IS TRUE;
- f1
-----
- t
- t
- t
-(3 rows)
-
+ERROR: no relation entry for relid 1
SELECT f1
FROM BOOLTBL1
WHERE f1 IS NOT FALSE;
- f1
-----
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/boolean.out /home/postgres/postgres/build/testrun/regress/reg...
--- /home/postgres/postgres/src/test/regress/expected/boolean.out 2026-02-13 01:27:47.464365869 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/boolean.out 2026-02-13 01:29:37.983507807 +0000
@@ -392,75 +392,35 @@
SELECT f1
FROM BOOLTBL1
WHERE f1 IS TRUE;
- f1
-----
- t
- t
- t
-(3 rows)
-
+ERROR: no relation entry for relid 1
SELECT f1
FROM BOOLTBL1
WHERE f1 IS NOT FALSE;
- f1
-----
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/modules/test_predtest/expected/test_predtest.out /home/postgres/postgres/build...
--- /home/postgres/postgres/src/test/modules/test_predtest/expected/test_predtest.out 2026-02-13 01:27:47.032067823 +000...
+++ /home/postgres/postgres/build/testrun/test_predtest/regress/results/test_predtest.out 2026-02-13 01:31:12.066093727 ...
@@ -125,86 +125,56 @@
select x is not true, x
from booleans
$$);
--[ RECORD 1 ]-----+--
-strong_implied_by | f
-weak_implied_by | f
-strong_refuted_by | t
-weak_refuted_by | t
-s_i_holds | f
-w_i_holds | f
-s_r_holds | t
-w_r_holds | t
-
+ERROR: no relation entry for relid 1
+CONTEXT: SQL statement "
+select x is not true, x
... |
| 58/6054 |
let ALTER COLUMN SET DATA TYPE cope with POLICY dependency |
|
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-12 23:24:49.327623700 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/rowsecurity.out 2026-02-12 23:29:55.804907200 +0000
@@ -423,15 +423,15 @@
--------------------+----------+-------+----------------------------------------------+-------------------+------------...
regress_rls_schema | category | table | regress_rls_alice=arwdDxtm/regress_rls_alice+| |
| | | =arwdDxtm/regress_rls_alice | |
- regress_rls_schema | document | table | regress_rls_alice=arwdDxtm/regress_rls_alice+| | p1: ...
- | | | =arwdDxtm/regress_rls_alice | | (u): (dle...
+ regress_rls_schema | document | table | regress_rls_alice=arwdDxtm/regress_rls_alice+| | p1r (RESTRI...
+ | | | =arwdDxtm/regress_rls_alice | | (u): (cid...
+ | | | | | to: regre...
+ | | | | | p1: ...
+ | | | | | (u): (dle...
| | | | | FROM uac...
| | | | | WHERE (ua...
| | | | | p2r (RESTRI...
| | | | | (u): ((ci...
- | | | | | to: regre...
- | | | | | p1r (RESTRI...
... |
| 58/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-12 21:29:38.557874000 +00...
+++ /tmp/cirrus-ci-build/build/testrun/test_extensions/regress/results/test_extensions.out 2026-02-12 21:33:53.683771000...
@@ -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-12 21:29:51.990965013 +00...
+++ /tmp/cirrus-ci-build/src/test/modules/test_extensions/results/test_extensions.out 2026-02-12 21:33:33.280108742 +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/6432 |
docs: warn about post-data-only schema dumps with parallel restore. |
|
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-12 15:44:42.131305569 +0000
+++ /home/postgres/postgres/build/testrun/isolation/isolation/results/timeouts.out 2026-02-12 15:47:13.276642799 +0000
@@ -11,7 +11,7 @@
step sto: SET statement_timeout = '10ms';
step locktbl: LOCK TABLE accounts; <waiting ...>
step locktbl: <... completed>
-ERROR: canceling statement due to statement timeout
+ERROR: canceling statement due to user request
starting permutation: rdtbl lto locktbl
step rdtbl: SELECT * FROM accounts; |
| 58/6180 |
minor error message enhance: print RLS policy name when only one permissive policy exists |
|
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-12 11:41:00.100819700 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/rowsecurity.out 2026-02-12 11:44:54.484628200 +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-12 11:41:00.100819700 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/rowsecurity.out 2026-02-12 11:48:17.056721200 +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-12 11:41:00.100819700 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/rowsecurity.out 2026-02-12 11:44:48.011484900 +0000
@@ -2462,7 +2462,7 @@
-- DO SELECT requires SELECT rights, should fail for non-novel
INSERT INTO document VALUES (33, (SELECT cid from category WHERE cname = 'science fiction'), 1, 'regress_rls_bob', 'ano...
ON CONFLICT (did) DO SELECT RETURNING did, dauthor, dtitle;
-ERROR: new row violates row-level security policy for table "document"
+ERROR: new row violates row-level security policy "p1_select_novels" for table "document"
-- DO SELECT with WHERE and EXCLUDED reference
INSERT INTO document VALUES (1, (SELECT cid from category WHERE cname = 'novel'), 1, 'regress_rls_bob', 'another novel'...
ON CONFLICT (did) DO SELECT WHERE excluded.dlevel = 1 RETURNING did, dauthor, dtitle;
@@ -2482,7 +2482,7 @@
-- should fail UPDATE USING policy for novel with dlevel = 2
INSERT INTO document VALUES (2, (SELECT cid from category WHERE cname = 'novel'), 1, 'regress_rls_bob', 'another novel'...
ON CONFLICT (did) DO SELECT FOR UPDATE RETURNING did, dauthor, dtitle;
-ERROR: new row violates row-level security policy (USING expression) for table "document"
+ERROR: new row violates row-level security policy "p3_update_novels" (USING expression) for table "document"
SET SESSION AUTHORIZATION regress_rls_alice;
DROP POLICY p1_select_novels ON document;
... |
|
Windows - Server 2022, MinGW64 - Meson |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/rowsecurity.out C:/cirrus/build/testrun/pg_upgrade/002_...
--- C:/cirrus/src/test/regress/expected/rowsecurity.out 2026-02-12 11:42:09.855314100 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/rowsecurity.out 2026-02-12 11:47:19.257512900 +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-12 11:42:09.855314100 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/rowsecurity.out 2026-02-12 11:50:49.949860600 +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-12 11:42:09.855314100 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/rowsecurity.out 2026-02-12 11:47:15.801442400 +0000
@@ -2462,7 +2462,7 @@
-- DO SELECT requires SELECT rights, should fail for non-novel
INSERT INTO document VALUES (33, (SELECT cid from category WHERE cname = 'science fiction'), 1, 'regress_rls_bob', 'ano...
ON CONFLICT (did) DO SELECT RETURNING did, dauthor, dtitle;
-ERROR: new row violates row-level security policy for table "document"
+ERROR: new row violates row-level security policy "p1_select_novels" for table "document"
-- DO SELECT with WHERE and EXCLUDED reference
INSERT INTO document VALUES (1, (SELECT cid from category WHERE cname = 'novel'), 1, 'regress_rls_bob', 'another novel'...
ON CONFLICT (did) DO SELECT WHERE excluded.dlevel = 1 RETURNING did, dauthor, dtitle;
@@ -2482,7 +2482,7 @@
-- should fail UPDATE USING policy for novel with dlevel = 2
INSERT INTO document VALUES (2, (SELECT cid from category WHERE cname = 'novel'), 1, 'regress_rls_bob', 'another novel'...
ON CONFLICT (did) DO SELECT FOR UPDATE RETURNING did, dauthor, dtitle;
-ERROR: new row violates row-level security policy (USING expression) for table "document"
+ERROR: new row violates row-level security policy "p3_update_novels" (USING expression) for table "document"
SET SESSION AUTHORIZATION regress_rls_alice;
DROP POLICY p1_select_novels ON document;
... |
|
Linux - Debian Trixie - 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-12 11:41:18.752049944 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/rowsecurity.out 2026-02-12 11:45:40.038204...
@@ -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-12 11:41:18.752049944 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/rowsecurity.out 2026-02-12 11:47:08.8105...
@@ -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-12 11:41:18.752049944 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/rowsecurity.out 2026-02-12 11:45:39.918204355 +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-12 11:41:02
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/rowsecurity.out 2026-02-12 11:44:51
@@ -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-12 11:41:02
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/rowsecurity.out 2026-02-12 11:46:38
@@ -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-12 11:41:02
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/rowsecurity.out 2026-02-12 11:44:52
@@ -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-12 11:41:31.896602277 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/rowsecurity.out 2026-02-12 11:49:13.403294282 +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-12 11:41:31.896602277 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/rowsecurity.out 2026-02-12 11:50:24.611413780 +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-12 11:41:31.896602277 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/rowsecurity.out 2026-02-12 11:46:15.446715442 +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-12 11:40:54.945500000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/rowsecurity.out 2026-02-12 11:44:12.476801...
@@ -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-12 11:40:54.945500000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/rowsecurity.out 2026-02-12 11:45:39.9008...
@@ -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-12 11:40:54.945500000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/rowsecurity.out 2026-02-12 11:44:06.342488000 +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-12 11:42:05.505037700 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/rowsecurity.out 2026-02-12 11:44:44.422...
@@ -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-12 11:42:05.505037700 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/rowsecurity.out 2026-02-12 11:45:23.0...
@@ -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-12 11:42:05.505037700 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/rowsecurity.out 2026-02-12 11:44:38.017648782 +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 Thu Feb 12 11:42:12 2026
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/rowsecurity.out Thu Feb 12 11:46:05 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 Thu Feb 12 11:42:12 2026
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/rowsecurity.out Thu Feb 12 11:48:14 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 Thu Feb 12 11:42:12 2026
+++ /home/postgres/postgres/build/testrun/regress/regress/results/rowsecurity.out Thu Feb 12 11:45:51 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;
... |
| 58/6409 |
Documentation update clarifying usage of PASSING clause |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/contrib/postgres_fdw/expected/query_cancel.out /home/postgres/postgres/build/testrun/po...
--- /home/postgres/postgres/contrib/postgres_fdw/expected/query_cancel.out 2026-02-11 22:19:32.168647404 +0000
+++ /home/postgres/postgres/build/testrun/postgres_fdw/regress/results/query_cancel.out 2026-02-11 22:22:00.031229666 +0...
@@ -30,5 +30,5 @@
SET LOCAL statement_timeout = '10ms';
-- This would take very long if not canceled:
SELECT count(*) FROM ft1 a CROSS JOIN ft1 b CROSS JOIN ft1 c CROSS JOIN ft1 d;
-ERROR: canceling statement due to statement timeout
+ERROR: canceling statement due to user request
COMMIT; |
| 58/6391 |
Use CASEFOLD() internally rather than LOWER() |
|
Windows - Server 2022, MinGW64 - Meson |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/citext/expected/create_index_acl.out C:/cirrus/build/testrun/citext/regre...
--- C:/cirrus/contrib/citext/expected/create_index_acl.out 2026-02-11 17:18:35.523097100 +0000
+++ C:/cirrus/build/testrun/citext/regress/results/create_index_acl.out 2026-02-11 17:29:25.616478800 +0000
@@ -57,21 +57,26 @@
WHERE (s.index_row_if(y));
-- Make the table nonempty.
INSERT INTO s.x VALUES ('foo'), ('bar');
+ERROR: Unicode case folding can only be performed if server encoding is UTF8
-- If the INSERT runs the planner on index expressions, a search_path change
-- survives. As of 2022-06, the INSERT reuses a cached plan. It does so even
-- under debug_discard_caches, since each index is new-in-transaction. If
-- future work changes a cache lifecycle, this RESET may become necessary.
RESET search_path;
+ERROR: current transaction is aborted, commands ignored until end of transaction block
-- For a nonempty table, owner needs permissions throughout ii_Expressions.
GRANT EXECUTE ON FUNCTION s.index_this_expr TO regress_minimal;
+ERROR: current transaction is aborted, commands ignored until end of transaction block
CREATE UNIQUE INDEX u2rows ON s.x USING btree
((s.index_this_expr(y, s.const())) COLLATE s.coll s.citext_pattern_ops)
TABLESPACE regress_create_idx_tblspace
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/dict_xsyn/expected/dict_xsyn.out C:/cirrus/build/testrun/dict_xsyn/regres...
--- C:/cirrus/contrib/dict_xsyn/expected/dict_xsyn.out 2026-02-11 17:18:35.578774400 +0000
+++ C:/cirrus/build/testrun/dict_xsyn/regress/results/dict_xsyn.out 2026-02-11 17:29:31.806405400 +0000
@@ -1,11 +1,14 @@
CREATE EXTENSION dict_xsyn;
-- default configuration - match first word and return it among with all synonyms
ALTER TEXT SEARCH DICTIONARY xsyn (RULES='xsyn_sample', KEEPORIG=true, MATCHORIG=true, KEEPSYNONYMS=true, MATCHSYNONYMS...
+ERROR: Unicode case folding can only be performed if server encoding is UTF8
+CONTEXT: line 1 of configuration file "C:/cirrus/build/tmp_install/usr/local/pgsql/share/tsearch_data/xsyn_sample.rule...
+"
--lexize
SELECT ts_lexize('xsyn', 'supernova');
- ts_lexize
---------------------------
- {supernova,sn,sne,1987a}
+ ts_lexize
+-----------
+
(1 row)
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/postgres_fdw/expected/postgres_fdw.out C:/cirrus/build/testrun/postgres_f...
--- C:/cirrus/contrib/postgres_fdw/expected/postgres_fdw.out 2026-02-11 17:18:35.985505200 +0000
+++ C:/cirrus/build/testrun/postgres_fdw/regress/results/postgres_fdw.out 2026-02-11 17:30:07.397219600 +0000
@@ -1206,11 +1206,7 @@
SELECT c1, to_tsvector('custom_search'::regconfig, c3) FROM ft1
WHERE c1 = 642 AND length(to_tsvector('custom_search'::regconfig, c3)) > 0;
- c1 | to_tsvector
------+-------------
- 642 | '00642':1
-(1 row)
-
+ERROR: Unicode case folding can only be performed if server encoding is UTF8
-- but if it's in a shippable extension, it can be shipped
ALTER EXTENSION postgres_fdw ADD TEXT SEARCH CONFIGURATION public.custom_search;
-- however, that doesn't flush the shippability cache, so do a quick reconnect
@@ -1227,11 +1223,8 @@
SELECT c1, to_tsvector('custom_search'::regconfig, c3) FROM ft1
WHERE c1 = 642 AND length(to_tsvector('custom_search'::regconfig, c3)) > 0;
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/strings.out C:/cirrus/build/testrun/recovery/027_stream...
--- C:/cirrus/src/test/regress/expected/strings.out 2026-02-11 17:18:40.412750900 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/strings.out 2026-02-11 17:26:31.407956700 +0000
@@ -1837,53 +1837,21 @@
-- Be sure to form every test as an ILIKE/NOT ILIKE pair.
--
SELECT 'hawkeye' ILIKE 'h%' AS "true";
- true
-------
- t
-(1 row)
-
+ERROR: Unicode case folding can only be performed if server encoding is UTF8
SELECT 'hawkeye' NOT ILIKE 'h%' AS "false";
- false
--------
- f
-(1 row)
-
+ERROR: Unicode case folding can only be performed if server encoding is UTF8
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/strings.out C:/cirrus/build/testrun/regress/regress/res...
--- C:/cirrus/src/test/regress/expected/strings.out 2026-02-11 17:18:40.412750900 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/strings.out 2026-02-11 17:23:07.283470900 +0000
@@ -1837,53 +1837,21 @@
-- Be sure to form every test as an ILIKE/NOT ILIKE pair.
--
SELECT 'hawkeye' ILIKE 'h%' AS "true";
- true
-------
- t
-(1 row)
-
+ERROR: Unicode case folding can only be performed if server encoding is UTF8
SELECT 'hawkeye' NOT ILIKE 'h%' AS "false";
- false
--------
- f
-(1 row)
-
+ERROR: Unicode case folding can only be performed if server encoding is UTF8
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/modules/test_parser/expected/test_parser.out C:/cirrus/build/testrun/tes...
--- C:/cirrus/src/test/modules/test_parser/expected/test_parser.out 2026-02-11 17:18:40.061164600 +0000
+++ C:/cirrus/build/testrun/test_parser/regress/results/test_parser.out 2026-02-11 17:30:35.111092800 +0000
@@ -24,21 +24,9 @@
(15 rows)
SELECT to_tsvector('testcfg','That''s my first own parser');
- to_tsvector
--------------------------------------------------
- 'first':3 'my':2 'own':4 'parser':5 'that''s':1
-(1 row)
-
+ERROR: Unicode case folding can only be performed if server encoding is UTF8
SELECT to_tsquery('testcfg', 'star');
- to_tsquery
-------------
- 'star'
-(1 row)
-
+ERROR: Unicode case folding can only be performed if server encoding is UTF8
... |
|
Linux - Debian Trixie - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/citext/expected/create_index_acl.out /tmp/cirrus-ci-build/build-32/testrun/citext/...
--- /tmp/cirrus-ci-build/contrib/citext/expected/create_index_acl.out 2026-02-11 17:18:32.783063861 +0000
+++ /tmp/cirrus-ci-build/build-32/testrun/citext/regress/results/create_index_acl.out 2026-02-11 17:31:11.329258562 +000...
@@ -57,21 +57,26 @@
WHERE (s.index_row_if(y));
-- Make the table nonempty.
INSERT INTO s.x VALUES ('foo'), ('bar');
+ERROR: Unicode case folding can only be performed if server encoding is UTF8
-- If the INSERT runs the planner on index expressions, a search_path change
-- survives. As of 2022-06, the INSERT reuses a cached plan. It does so even
-- under debug_discard_caches, since each index is new-in-transaction. If
-- future work changes a cache lifecycle, this RESET may become necessary.
RESET search_path;
+ERROR: current transaction is aborted, commands ignored until end of transaction block
-- For a nonempty table, owner needs permissions throughout ii_Expressions.
GRANT EXECUTE ON FUNCTION s.index_this_expr TO regress_minimal;
+ERROR: current transaction is aborted, commands ignored until end of transaction block
CREATE UNIQUE INDEX u2rows ON s.x USING btree
((s.index_this_expr(y, s.const())) COLLATE s.coll s.citext_pattern_ops)
TABLESPACE regress_create_idx_tblspace
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/dict_xsyn/expected/dict_xsyn.out /tmp/cirrus-ci-build/build-32/testrun/dict_xsyn/r...
--- /tmp/cirrus-ci-build/contrib/dict_xsyn/expected/dict_xsyn.out 2026-02-11 17:18:32.791092794 +0000
+++ /tmp/cirrus-ci-build/build-32/testrun/dict_xsyn/regress/results/dict_xsyn.out 2026-02-11 17:31:15.893276043 +0000
@@ -1,11 +1,14 @@
CREATE EXTENSION dict_xsyn;
-- default configuration - match first word and return it among with all synonyms
ALTER TEXT SEARCH DICTIONARY xsyn (RULES='xsyn_sample', KEEPORIG=true, MATCHORIG=true, KEEPSYNONYMS=true, MATCHSYNONYMS...
+ERROR: Unicode case folding can only be performed if server encoding is UTF8
+CONTEXT: line 1 of configuration file "/tmp/cirrus-ci-build/build-32/tmp_install/usr/local/pgsql/share/tsearch_data/xs...
+"
--lexize
SELECT ts_lexize('xsyn', 'supernova');
- ts_lexize
---------------------------
- {supernova,sn,sne,1987a}
+ ts_lexize
+-----------
+
(1 row)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out /tmp/cirrus-ci-build/build-32/testrun/postg...
--- /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out 2026-02-11 17:18:32.875396601 +0000
+++ /tmp/cirrus-ci-build/build-32/testrun/postgres_fdw/regress/results/postgres_fdw.out 2026-02-11 17:31:56.505435961 +0...
@@ -1206,11 +1206,7 @@
SELECT c1, to_tsvector('custom_search'::regconfig, c3) FROM ft1
WHERE c1 = 642 AND length(to_tsvector('custom_search'::regconfig, c3)) > 0;
- c1 | to_tsvector
------+-------------
- 642 | '00642':1
-(1 row)
-
+ERROR: Unicode case folding can only be performed if server encoding is UTF8
-- but if it's in a shippable extension, it can be shipped
ALTER EXTENSION postgres_fdw ADD TEXT SEARCH CONFIGURATION public.custom_search;
-- however, that doesn't flush the shippability cache, so do a quick reconnect
@@ -1227,11 +1223,8 @@
SELECT c1, to_tsvector('custom_search'::regconfig, c3) FROM ft1
WHERE c1 = 642 AND length(to_tsvector('custom_search'::regconfig, c3)) > 0;
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/tstypes.out /tmp/cirrus-ci-build/build-32/testrun/recovery/027_s...
--- /tmp/cirrus-ci-build/src/test/regress/expected/tstypes.out 2026-02-11 17:18:34.729806923 +0000
+++ /tmp/cirrus-ci-build/build-32/testrun/recovery/027_stream_regress/data/results/tstypes.out 2026-02-11 17:30:19.20506...
@@ -686,294 +686,102 @@
--phrase search
SELECT to_tsvector('simple', '1 2 3 1') @@ '1 <-> 2' AS "true";
- true
-------
- t
-(1 row)
-
+ERROR: Unicode case folding can only be performed if server encoding is UTF8
SELECT to_tsvector('simple', '1 2 3 1') @@ '1 <2> 2' AS "false";
- false
--------
- f
-(1 row)
-
+ERROR: Unicode case folding can only be performed if server encoding is UTF8
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/tstypes.out /tmp/cirrus-ci-build/build-32/testrun/regress/regres...
--- /tmp/cirrus-ci-build/src/test/regress/expected/tstypes.out 2026-02-11 17:18:34.729806923 +0000
+++ /tmp/cirrus-ci-build/build-32/testrun/regress/regress/results/tstypes.out 2026-02-11 17:28:44.096785739 +0000
@@ -686,294 +686,102 @@
--phrase search
SELECT to_tsvector('simple', '1 2 3 1') @@ '1 <-> 2' AS "true";
- true
-------
- t
-(1 row)
-
+ERROR: Unicode case folding can only be performed if server encoding is UTF8
SELECT to_tsvector('simple', '1 2 3 1') @@ '1 <2> 2' AS "false";
- false
--------
- f
-(1 row)
-
+ERROR: Unicode case folding can only be performed if server encoding is UTF8
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/modules/test_parser/expected/test_parser.out /tmp/cirrus-ci-build/build-32/testru...
--- /tmp/cirrus-ci-build/src/test/modules/test_parser/expected/test_parser.out 2026-02-11 17:18:34.577291000 +0000
+++ /tmp/cirrus-ci-build/build-32/testrun/test_parser/regress/results/test_parser.out 2026-02-11 17:32:08.381484003 +000...
@@ -24,21 +24,9 @@
(15 rows)
SELECT to_tsvector('testcfg','That''s my first own parser');
- to_tsvector
--------------------------------------------------
- 'first':3 'my':2 'own':4 'parser':5 'that''s':1
-(1 row)
-
+ERROR: Unicode case folding can only be performed if server encoding is UTF8
SELECT to_tsquery('testcfg', 'star');
- to_tsquery
-------------
- 'star'
-(1 row)
-
+ERROR: Unicode case folding can only be performed if server encoding is UTF8
... |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/citext/expected/create_index_acl.out C:/cirrus/build/testrun/citext/regre...
--- C:/cirrus/contrib/citext/expected/create_index_acl.out 2026-02-11 17:18:29.651810700 +0000
+++ C:/cirrus/build/testrun/citext/regress/results/create_index_acl.out 2026-02-11 17:27:08.532959600 +0000
@@ -57,21 +57,26 @@
WHERE (s.index_row_if(y));
-- Make the table nonempty.
INSERT INTO s.x VALUES ('foo'), ('bar');
+ERROR: Unicode case folding can only be performed if server encoding is UTF8
-- If the INSERT runs the planner on index expressions, a search_path change
-- survives. As of 2022-06, the INSERT reuses a cached plan. It does so even
-- under debug_discard_caches, since each index is new-in-transaction. If
-- future work changes a cache lifecycle, this RESET may become necessary.
RESET search_path;
+ERROR: current transaction is aborted, commands ignored until end of transaction block
-- For a nonempty table, owner needs permissions throughout ii_Expressions.
GRANT EXECUTE ON FUNCTION s.index_this_expr TO regress_minimal;
+ERROR: current transaction is aborted, commands ignored until end of transaction block
CREATE UNIQUE INDEX u2rows ON s.x USING btree
((s.index_this_expr(y, s.const())) COLLATE s.coll s.citext_pattern_ops)
TABLESPACE regress_create_idx_tblspace
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/dict_xsyn/expected/dict_xsyn.out C:/cirrus/build/testrun/dict_xsyn/regres...
--- C:/cirrus/contrib/dict_xsyn/expected/dict_xsyn.out 2026-02-11 17:18:29.698084000 +0000
+++ C:/cirrus/build/testrun/dict_xsyn/regress/results/dict_xsyn.out 2026-02-11 17:27:14.106195500 +0000
@@ -1,11 +1,14 @@
CREATE EXTENSION dict_xsyn;
-- default configuration - match first word and return it among with all synonyms
ALTER TEXT SEARCH DICTIONARY xsyn (RULES='xsyn_sample', KEEPORIG=true, MATCHORIG=true, KEEPSYNONYMS=true, MATCHSYNONYMS...
+ERROR: Unicode case folding can only be performed if server encoding is UTF8
+CONTEXT: line 1 of configuration file "C:/cirrus/build/tmp_install/usr/local/pgsql/share/tsearch_data/xsyn_sample.rule...
+"
--lexize
SELECT ts_lexize('xsyn', 'supernova');
- ts_lexize
---------------------------
- {supernova,sn,sne,1987a}
+ ts_lexize
+-----------
+
(1 row)
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/postgres_fdw/expected/postgres_fdw.out C:/cirrus/build/testrun/postgres_f...
--- C:/cirrus/contrib/postgres_fdw/expected/postgres_fdw.out 2026-02-11 17:18:30.136656400 +0000
+++ C:/cirrus/build/testrun/postgres_fdw/regress/results/postgres_fdw.out 2026-02-11 17:27:53.557372500 +0000
@@ -1206,11 +1206,7 @@
SELECT c1, to_tsvector('custom_search'::regconfig, c3) FROM ft1
WHERE c1 = 642 AND length(to_tsvector('custom_search'::regconfig, c3)) > 0;
- c1 | to_tsvector
------+-------------
- 642 | '00642':1
-(1 row)
-
+ERROR: Unicode case folding can only be performed if server encoding is UTF8
-- but if it's in a shippable extension, it can be shipped
ALTER EXTENSION postgres_fdw ADD TEXT SEARCH CONFIGURATION public.custom_search;
-- however, that doesn't flush the shippability cache, so do a quick reconnect
@@ -1227,11 +1223,8 @@
SELECT c1, to_tsvector('custom_search'::regconfig, c3) FROM ft1
WHERE c1 = 642 AND length(to_tsvector('custom_search'::regconfig, c3)) > 0;
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/strings.out C:/cirrus/build/testrun/recovery/027_stream...
--- C:/cirrus/src/test/regress/expected/strings.out 2026-02-11 17:18:34.645990400 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/strings.out 2026-02-11 17:24:32.914312900 +0000
@@ -1837,53 +1837,21 @@
-- Be sure to form every test as an ILIKE/NOT ILIKE pair.
--
SELECT 'hawkeye' ILIKE 'h%' AS "true";
- true
-------
- t
-(1 row)
-
+ERROR: Unicode case folding can only be performed if server encoding is UTF8
SELECT 'hawkeye' NOT ILIKE 'h%' AS "false";
- false
--------
- f
-(1 row)
-
+ERROR: Unicode case folding can only be performed if server encoding is UTF8
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/strings.out C:/cirrus/build/testrun/regress/regress/res...
--- C:/cirrus/src/test/regress/expected/strings.out 2026-02-11 17:18:34.645990400 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/strings.out 2026-02-11 17:21:13.381599300 +0000
@@ -1837,53 +1837,21 @@
-- Be sure to form every test as an ILIKE/NOT ILIKE pair.
--
SELECT 'hawkeye' ILIKE 'h%' AS "true";
- true
-------
- t
-(1 row)
-
+ERROR: Unicode case folding can only be performed if server encoding is UTF8
SELECT 'hawkeye' NOT ILIKE 'h%' AS "false";
- false
--------
- f
-(1 row)
-
+ERROR: Unicode case folding can only be performed if server encoding is UTF8
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/modules/test_parser/expected/test_parser.out C:/cirrus/build/testrun/tes...
--- C:/cirrus/src/test/modules/test_parser/expected/test_parser.out 2026-02-11 17:18:34.274723100 +0000
+++ C:/cirrus/build/testrun/test_parser/regress/results/test_parser.out 2026-02-11 17:28:12.757084100 +0000
@@ -24,21 +24,9 @@
(15 rows)
SELECT to_tsvector('testcfg','That''s my first own parser');
- to_tsvector
--------------------------------------------------
- 'first':3 'my':2 'own':4 'parser':5 'that''s':1
-(1 row)
-
+ERROR: Unicode case folding can only be performed if server encoding is UTF8
SELECT to_tsquery('testcfg', 'star');
- to_tsquery
-------------
- 'star'
-(1 row)
-
+ERROR: Unicode case folding can only be performed if server encoding is UTF8
... |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/contrib/citext/expected/create_index_acl.out /home/postgres/postgres/build/testrun/cite...
--- /home/postgres/postgres/contrib/citext/expected/create_index_acl.out 2026-02-11 17:18:52.770823603 +0000
+++ /home/postgres/postgres/build/testrun/citext/regress/results/create_index_acl.out 2026-02-11 17:21:12.968945245 +000...
@@ -57,21 +57,26 @@
WHERE (s.index_row_if(y));
-- Make the table nonempty.
INSERT INTO s.x VALUES ('foo'), ('bar');
+ERROR: Unicode case folding can only be performed if server encoding is UTF8
-- If the INSERT runs the planner on index expressions, a search_path change
-- survives. As of 2022-06, the INSERT reuses a cached plan. It does so even
-- under debug_discard_caches, since each index is new-in-transaction. If
-- future work changes a cache lifecycle, this RESET may become necessary.
RESET search_path;
+ERROR: current transaction is aborted, commands ignored until end of transaction block
-- For a nonempty table, owner needs permissions throughout ii_Expressions.
GRANT EXECUTE ON FUNCTION s.index_this_expr TO regress_minimal;
+ERROR: current transaction is aborted, commands ignored until end of transaction block
CREATE UNIQUE INDEX u2rows ON s.x USING btree
((s.index_this_expr(y, s.const())) COLLATE s.coll s.citext_pattern_ops)
TABLESPACE regress_create_idx_tblspace
... |
| regress |
diff -U3 /home/postgres/postgres/contrib/dict_xsyn/expected/dict_xsyn.out /home/postgres/postgres/build/testrun/dict_xsy...
--- /home/postgres/postgres/contrib/dict_xsyn/expected/dict_xsyn.out 2026-02-11 17:18:52.843572691 +0000
+++ /home/postgres/postgres/build/testrun/dict_xsyn/regress/results/dict_xsyn.out 2026-02-11 17:21:14.003134358 +0000
@@ -1,11 +1,14 @@
CREATE EXTENSION dict_xsyn;
-- default configuration - match first word and return it among with all synonyms
ALTER TEXT SEARCH DICTIONARY xsyn (RULES='xsyn_sample', KEEPORIG=true, MATCHORIG=true, KEEPSYNONYMS=true, MATCHSYNONYMS...
+ERROR: Unicode case folding can only be performed if server encoding is UTF8
+CONTEXT: line 1 of configuration file "/home/postgres/postgres/build/tmp_install/usr/local/pgsql/share/tsearch_data/xs...
+"
--lexize
SELECT ts_lexize('xsyn', 'supernova');
- ts_lexize
---------------------------
- {supernova,sn,sne,1987a}
+ ts_lexize
+-----------
+
(1 row)
... |
| regress |
diff -U3 /home/postgres/postgres/contrib/postgres_fdw/expected/postgres_fdw.out /home/postgres/postgres/build/testrun/po...
--- /home/postgres/postgres/contrib/postgres_fdw/expected/postgres_fdw.out 2026-02-11 17:18:53.565583113 +0000
+++ /home/postgres/postgres/build/testrun/postgres_fdw/regress/results/postgres_fdw.out 2026-02-11 17:21:26.255248727 +0...
@@ -1206,11 +1206,7 @@
SELECT c1, to_tsvector('custom_search'::regconfig, c3) FROM ft1
WHERE c1 = 642 AND length(to_tsvector('custom_search'::regconfig, c3)) > 0;
- c1 | to_tsvector
------+-------------
- 642 | '00642':1
-(1 row)
-
+ERROR: Unicode case folding can only be performed if server encoding is UTF8
-- but if it's in a shippable extension, it can be shipped
ALTER EXTENSION postgres_fdw ADD TEXT SEARCH CONFIGURATION public.custom_search;
-- however, that doesn't flush the shippability cache, so do a quick reconnect
@@ -1227,11 +1223,8 @@
SELECT c1, to_tsvector('custom_search'::regconfig, c3) FROM ft1
WHERE c1 = 642 AND length(to_tsvector('custom_search'::regconfig, c3)) > 0;
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/tstypes.out /home/postgres/postgres/build/testrun/recovery/02...
--- /home/postgres/postgres/src/test/regress/expected/tstypes.out 2026-02-11 17:19:01.425388630 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/tstypes.out 2026-02-11 17:20:34.43836...
@@ -686,294 +686,102 @@
--phrase search
SELECT to_tsvector('simple', '1 2 3 1') @@ '1 <-> 2' AS "true";
- true
-------
- t
-(1 row)
-
+ERROR: Unicode case folding can only be performed if server encoding is UTF8
SELECT to_tsvector('simple', '1 2 3 1') @@ '1 <2> 2' AS "false";
- false
--------
- f
-(1 row)
-
+ERROR: Unicode case folding can only be performed if server encoding is UTF8
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/tstypes.out /home/postgres/postgres/build/testrun/regress/reg...
--- /home/postgres/postgres/src/test/regress/expected/tstypes.out 2026-02-11 17:19:01.425388630 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/tstypes.out 2026-02-11 17:19:58.682097078 +0000
@@ -686,294 +686,102 @@
--phrase search
SELECT to_tsvector('simple', '1 2 3 1') @@ '1 <-> 2' AS "true";
- true
-------
- t
-(1 row)
-
+ERROR: Unicode case folding can only be performed if server encoding is UTF8
SELECT to_tsvector('simple', '1 2 3 1') @@ '1 <2> 2' AS "false";
- false
--------
- f
-(1 row)
-
+ERROR: Unicode case folding can only be performed if server encoding is UTF8
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/modules/test_parser/expected/test_parser.out /home/postgres/postgres/build/tes...
--- /home/postgres/postgres/src/test/modules/test_parser/expected/test_parser.out 2026-02-11 17:19:00.771556135 +0000
+++ /home/postgres/postgres/build/testrun/test_parser/regress/results/test_parser.out 2026-02-11 17:21:35.012938950 +000...
@@ -24,21 +24,9 @@
(15 rows)
SELECT to_tsvector('testcfg','That''s my first own parser');
- to_tsvector
--------------------------------------------------
- 'first':3 'my':2 'own':4 'parser':5 'that''s':1
-(1 row)
-
+ERROR: Unicode case folding can only be performed if server encoding is UTF8
SELECT to_tsquery('testcfg', 'star');
- to_tsquery
-------------
- 'star'
-(1 row)
-
+ERROR: Unicode case folding can only be performed if server encoding is UTF8
... |
| 58/6431 |
[BUG#19384] Fix Server crash at textout |
|
macOS - Sequoia - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/indirect_toast.out /Users/admin/pgsql/build/testrun/recovery/027_s...
--- /Users/admin/pgsql/src/test/regress/expected/indirect_toast.out 2026-02-11 06:44:28
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/indirect_toast.out 2026-02-11 06:47:35
@@ -152,15 +152,8 @@
-- check we didn't screw with main/toast tuple visibility
VACUUM FREEZE indtoasttest;
SELECT substring(indtoasttest::text, 1, 200) FROM indtoasttest;
- substring ...
------------------------------------------------------------------------------------------------------------------------...
- (two-compressed,8,--12345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678...
- (two-toasted,8,--12345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901...
- ("one-compressed,one-null",8,,1234567890123456789012345678901234567890123456789012345678901234567890123456789012345678...
- ("one-toasted,one-null",8,,1234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901...
- ("one-toasted,one-null, via indirect",0,123456789012345678901234567890123456789012345678901234567890123456789012345678...
-(5 rows)
-
+ERROR: type indtoasttest has changed
+DETAIL: The composite value was created using a previous definition of type indtoasttest.
DROP TABLE indtoasttest;
DROP FUNCTION update_using_indirect();
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/indirect_toast.out /Users/admin/pgsql/build/testrun/regress/regres...
--- /Users/admin/pgsql/src/test/regress/expected/indirect_toast.out 2026-02-11 06:44:28
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/indirect_toast.out 2026-02-11 06:46:36
@@ -140,15 +140,8 @@
INSERT INTO indtoasttest(descr, f1, f2) VALUES('one-toasted,one-null, via indirect', repeat('1234567890',30000), NULL);
SELECT substring(indtoasttest::text, 1, 200) FROM indtoasttest;
- substring ...
------------------------------------------------------------------------------------------------------------------------...
- (two-compressed,8,--12345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678...
- (two-toasted,8,--12345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901...
- ("one-compressed,one-null",8,,1234567890123456789012345678901234567890123456789012345678901234567890123456789012345678...
- ("one-toasted,one-null",8,,1234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901...
- ("one-toasted,one-null, via indirect",0,123456789012345678901234567890123456789012345678901234567890123456789012345678...
-(5 rows)
-
+ERROR: type indtoasttest has changed
+DETAIL: The composite value was created using a previous definition of type indtoasttest.
-- check we didn't screw with main/toast tuple visibility
VACUUM FREEZE indtoasttest;
... |
| 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-11 05:00:59.648554296 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/jsonb.out 2026-02-11 05:04:26.311665341 +0...
@@ -3428,2527 +3428,10 @@
(1 row)
SELECT key, count(*) FROM (SELECT (jsonb_each(j)).key FROM testjsonb) AS wow GROUP BY key ORDER BY count DESC, key;
- key | count
------------+-------
- line | 884
- query | 207
- pos | 203
- node | 202
- space | 197
- status | 195
- public | 194
- title | 190
- wait | 190
- org | 189
- user | 189
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/jsonb.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stream...
--- /tmp/cirrus-ci-build/src/test/regress/expected/jsonb.out 2026-02-11 05:00:59.648554296 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/jsonb.out 2026-02-11 05:05:43.200779097 ...
@@ -3309,2646 +3309,10 @@
(1 row)
SELECT count(*) FROM testjsonb WHERE j @@ 'exists($.public) || exists($.disabled)';
- count
--------
- 337
-(1 row)
-
-SELECT count(*) FROM testjsonb WHERE j @@ 'exists($.public) && exists($.disabled)';
- count
--------
- 42
-(1 row)
-
-EXPLAIN (COSTS OFF)
-SELECT count(*) FROM testjsonb WHERE j @? '$.wait ? (@ == null)';
... |
| 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-11 05:00:59.648554296 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/jsonb.out 2026-02-11 05:04:22.055500729 +0000
@@ -3084,2871 +3084,7 @@
(1 row)
SELECT count(*) FROM testjsonb WHERE j @? '$.wait ? (@ == null)';
- count
--------
- 1
-(1 row)
-
-SELECT count(*) FROM testjsonb WHERE j @? '$.wait ? ("CC" == @)';
- count
--------
- 15
-(1 row)
-
-SELECT count(*) FROM testjsonb WHERE j @? '$ ? (@.wait == "CC" && true == @.public)';
- count
... |
| 58/5992 |
Fix ALTER TABLE DROP EXPRESSION with ONLY option |
|
Windows - Server 2022, MinGW64 - Meson |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/generated_stored.out C:/cirrus/build/testrun/pg_upgrade...
--- C:/cirrus/src/test/regress/expected/generated_stored.out 2026-02-09 17:50:48.336130400 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_stored.out 2026-02-09 17:53:42.453313500 +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-09 17:50:48.336130400 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out 2026-02-09 17:53:51.275102600 +...
@@ -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-09 17:50:48.336130400 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/generated_stored.out 2026-02-09 17:56:43.614451000 ...
@@ -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-09 17:50:48.336130400 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out 2026-02-09 17:56:53.459655000...
@@ -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-09 17:50:48.336130400 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/generated_stored.out 2026-02-09 17:53:36.630573900 +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-09 17:50:48.336130400 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/generated_virtual.out 2026-02-09 17:53:47.255078000 +0000
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
|
Linux - Debian Trixie - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_stored.out /tmp/cirrus-ci-build/build/testrun/pg_upgra...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_stored.out 2026-02-09 17:50:36.081064988 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_stored.out 2026-02-09 17:52:27.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-09 17:50:36.081064988 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out 2026-02-09 17:52:34....
@@ -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-09 17:50:36.081064988 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/generated_stored.out 2026-02-09 17:53:50...
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff -U3 /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-09 17:50:36.081064988 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out 2026-02-09 17:53:5...
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_stored.out /tmp/cirrus-ci-build/build/testrun/regress/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_stored.out 2026-02-09 17:50:36.081064988 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/generated_stored.out 2026-02-09 17:52:26.156291939 +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-09 17:50:36.081064988 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/generated_virtual.out 2026-02-09 17:52:33.905118962 +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-09 17:50:28
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_stored.out 2026-02-09 17:52:19
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff -U3 /Users/admin/pgsql/src/test/regress/expected/generated_virtual.out /Users/admin/pgsql/build/testrun/pg_upgrade/...
--- /Users/admin/pgsql/src/test/regress/expected/generated_virtual.out 2026-02-09 17:50:28
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out 2026-02-09 17:52:23
@@ -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-09 17:50:28
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/generated_stored.out 2026-02-09 17:53:13
@@ -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-09 17:50:28
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out 2026-02-09 17:53: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 /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-09 17:50:28
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/generated_stored.out 2026-02-09 17:52:16
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff -U3 /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-09 17:50:28
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/generated_virtual.out 2026-02-09 17:52:21
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
|
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-09 17:50:37.045551000 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_stored.out 2026-02-09 17:53:59.584224700 +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-09 17:50:37.046509300 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out 2026-02-09 17:54:15.456771100 +...
@@ -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-09 17:50:37.045551000 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/generated_stored.out 2026-02-09 17:57:03.965906600 ...
@@ -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-09 17:50:37.046509300 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out 2026-02-09 17:57:24.865788800...
@@ -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-09 17:50:37.045551000 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/generated_stored.out 2026-02-09 17:53:53.546146300 +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-09 17:50:37.046509300 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/generated_virtual.out 2026-02-09 17:54:10.451404600 +0000
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
|
OpenBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/generated_stored.out /home/postgres/postgres/build/testrun/pg...
--- /home/postgres/postgres/src/test/regress/expected/generated_stored.out Mon Feb 9 17:50:49 2026
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_stored.out Mon Feb 9 17:52: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 Mon Feb 9 17:50:49 2026
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out Mon Feb 9 17:53:...
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/generated_stored.out /home/postgres/postgres/build/testrun/re...
--- /home/postgres/postgres/src/test/regress/expected/generated_stored.out Mon Feb 9 17:50:49 2026
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/generated_stored.out Mon Feb 9 17:54...
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff -U3 /home/postgres/postgres/src/test/regress/expected/generated_virtual.out /home/postgres/postgres/build/testrun/r...
--- /home/postgres/postgres/src/test/regress/expected/generated_virtual.out Mon Feb 9 17:50:49 2026
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out Mon Feb 9 17:5...
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/generated_stored.out /home/postgres/postgres/build/testrun/re...
--- /home/postgres/postgres/src/test/regress/expected/generated_stored.out Mon Feb 9 17:50:49 2026
+++ /home/postgres/postgres/build/testrun/regress/regress/results/generated_stored.out Mon Feb 9 17:52:46 2026
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff -U3 /home/postgres/postgres/src/test/regress/expected/generated_virtual.out /home/postgres/postgres/build/testrun/r...
--- /home/postgres/postgres/src/test/regress/expected/generated_virtual.out Mon Feb 9 17:50:49 2026
+++ /home/postgres/postgres/build/testrun/regress/regress/results/generated_virtual.out Mon Feb 9 17:52:58 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
... |
|
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-09 17:50:33.530655000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_stored.out 2026-02-09 17:52:37.4...
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out /tmp/cirrus-ci-build/build/testrun/pg_upgr...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out 2026-02-09 17:50:33.530918000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out 2026-02-09 17:52: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 /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-09 17:50:33.530655000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/generated_stored.out 2026-02-09 17:53:55...
@@ -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-09 17:50:33.530918000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out 2026-02-09 17:54:3...
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
| regress |
diff -U3 /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-09 17:50:33.530655000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/generated_stored.out 2026-02-09 17:52:34.989654000 +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-09 17:50:33.530918000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/generated_virtual.out 2026-02-09 17:52:57.288035000 +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-09 17:51:04.636190685 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_stored.out 2026-02-09 17:52:2...
@@ -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-09 17:51:04.636761561 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out 2026-02-09 17: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 /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-09 17:51:04.636190685 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/generated_stored.out 2026-02-09 17: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 /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-09 17:51:04.636761561 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out 2026-02-09 17:5...
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
| regress |
diff -U3 /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-09 17:51:04.636190685 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/generated_stored.out 2026-02-09 17:52:24.992102646 +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-09 17:51:04.636761561 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/generated_virtual.out 2026-02-09 17:52:36.722903674 +0...
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
|
Linux - Debian Trixie - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_stored.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_stored.out 2026-02-09 17:50:45.281292000 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/generated_stored.out 2026-02-09 17:56:36.384005955 +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-09 17:50:45.281292000 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/generated_virtual.out 2026-02-09 17:56:51.216012485 +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-09 17:50:45.281292000 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/generated_stored.out 2026-02-09 17:58:12.224040298 +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-09 17:50:45.281292000 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/generated_virtual.out 2026-02-09 17:58:21.276042779 +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-09 17:50:45.281292000 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/generated_stored.out 2026-02-09 17:54:08.183088361 +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-09 17:50:45.281292000 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/generated_virtual.out 2026-02-09 17:54:21.399424056 +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
... |
| 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-09 14:10:05.583216000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/stats.out 2026-02-09 14:15:32.762012000 +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-09 14:10:05.583216000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/stats.out 2026-02-09 14:16:56.818012000 ...
@@ -243,7 +243,7 @@
SELECT :seq_scan_after > :seq_scan_before;
?column?
----------
- t
+ f
(1 row)
---- |