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/6431 |
[BUG#19384] Fix Server crash at textout |
 |
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/indirect_toast.out /home/postgres/postgres/build/testrun/pg_u...
--- /home/postgres/postgres/src/test/regress/expected/indirect_toast.out 2026-01-30 05:10:40.212251198 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/indirect_toast.out 2026-01-30 05:12:51....
@@ -29,6 +29,10 @@
-- modification without changing varlenas
UPDATE indtoasttest SET cnt = cnt +1 RETURNING substring(indtoasttest::text, 1, 200);
+ERROR: type indtoasttest has changed
+DETAIL: The composite value was created using a previous definition of type indtoasttest.
+-- modification without modifying assigned value
+UPDATE indtoasttest SET cnt = cnt +1, f1 = f1 RETURNING substring(indtoasttest::text, 1, 200);
substring ...
-----------------------------------------------------------------------------------------------------------------------...
(two-compressed,1,1234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890...
@@ -37,8 +41,8 @@
("one-toasted,one-null",1,,1234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901...
(4 rows)
--- modification without modifying assigned value
-UPDATE indtoasttest SET cnt = cnt +1, f1 = f1 RETURNING substring(indtoasttest::text, 1, 200);
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/indirect_toast.out /home/postgres/postgres/build/testrun/regr...
--- /home/postgres/postgres/src/test/regress/expected/indirect_toast.out 2026-01-30 05:10:40.212251198 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/indirect_toast.out 2026-01-30 05:12:45.220181796 +0000
@@ -58,21 +58,15 @@
(4 rows)
UPDATE indtoasttest SET cnt = cnt +1, f1 = '-'||f1||'-' RETURNING substring(indtoasttest::text, 1, 200);
- substring ...
------------------------------------------------------------------------------------------------------------------------...
- (two-compressed,4,-123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789...
- (two-toasted,4,-123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012...
- ("one-compressed,one-null",4,,1234567890123456789012345678901234567890123456789012345678901234567890123456789012345678...
- ("one-toasted,one-null",4,,1234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901...
-(4 rows)
-
+ERROR: type indtoasttest has changed
+DETAIL: The composite value was created using a previous definition of type indtoasttest.
SELECT substring(indtoasttest::text, 1, 200) FROM indtoasttest;
substring ...
-----------------------------------------------------------------------------------------------------------------------...
... |
| 58/6418 |
Reduce build times of pg_trgm GIN indexes |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/pg_trgm/expected/pg_trgm.out C:/cirrus/build/testrun/pg_trgm/regress/resu...
--- C:/cirrus/contrib/pg_trgm/expected/pg_trgm.out 2026-01-30 04:33:57.622268000 +0000
+++ C:/cirrus/build/testrun/pg_trgm/regress/results/pg_trgm.out 2026-01-30 04:43:15.052703600 +0000
@@ -22,5429 +22,7 @@
(1 row)
select show_trgm('a b c');
- show_trgm
----------------------------------------
- {" a"," b"," c"," a "," b "," c "}
-(1 row)
-
-select show_trgm(' a b c ');
- show_trgm
----------------------------------------
- {" a"," b"," c"," a "," b "," c "}
-(1 row)
-
-select show_trgm('aA bB cC');
- show_trgm
... |
|
macOS - Sequoia - Meson |
| regress |
diff -U3 /Users/admin/pgsql/contrib/pg_trgm/expected/pg_trgm.out /Users/admin/pgsql/build/testrun/pg_trgm/regress/result...
--- /Users/admin/pgsql/contrib/pg_trgm/expected/pg_trgm.out 2026-01-30 04:34:00
+++ /Users/admin/pgsql/build/testrun/pg_trgm/regress/results/pg_trgm.out 2026-01-30 04:41:37
@@ -22,5429 +22,7 @@
(1 row)
select show_trgm('a b c');
- show_trgm
----------------------------------------
- {" a"," b"," c"," a "," b "," c "}
-(1 row)
-
-select show_trgm(' a b c ');
- show_trgm
----------------------------------------
- {" a"," b"," c"," a "," b "," c "}
-(1 row)
-
-select show_trgm('aA bB cC');
- show_trgm
... |
|
Windows - Server 2022, MinGW64 - Meson |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/pg_trgm/expected/pg_trgm.out C:/cirrus/build/testrun/pg_trgm/regress/resu...
--- C:/cirrus/contrib/pg_trgm/expected/pg_trgm.out 2026-01-30 04:34:02.370842000 +0000
+++ C:/cirrus/build/testrun/pg_trgm/regress/results/pg_trgm.out 2026-01-30 04:45:34.904085600 +0000
@@ -22,5429 +22,7 @@
(1 row)
select show_trgm('a b c');
- show_trgm
----------------------------------------
- {" a"," b"," c"," a "," b "," c "}
-(1 row)
-
-select show_trgm(' a b c ');
- show_trgm
----------------------------------------
- {" a"," b"," c"," a "," b "," c "}
-(1 row)
-
-select show_trgm('aA bB cC');
- show_trgm
... |
|
Linux - Debian Trixie - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/pg_trgm/expected/pg_trgm.out /tmp/cirrus-ci-build/build/testrun/pg_trgm/regress/re...
--- /tmp/cirrus-ci-build/contrib/pg_trgm/expected/pg_trgm.out 2026-01-30 04:33:58.062735676 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_trgm/regress/results/pg_trgm.out 2026-01-30 04:40:03.567959984 +0000
@@ -22,5429 +22,7 @@
(1 row)
select show_trgm('a b c');
- show_trgm
----------------------------------------
- {" a"," b"," c"," a "," b "," c "}
-(1 row)
-
-select show_trgm(' a b c ');
- show_trgm
----------------------------------------
- {" a"," b"," c"," a "," b "," c "}
-(1 row)
-
-select show_trgm('aA bB cC');
- show_trgm
... |
|
Linux - Debian Trixie - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/pg_trgm/expected/pg_trgm.out /tmp/cirrus-ci-build/contrib/pg_trgm/results/pg_trgm....
--- /tmp/cirrus-ci-build/contrib/pg_trgm/expected/pg_trgm.out 2026-01-30 04:34:03.484643082 +0000
+++ /tmp/cirrus-ci-build/contrib/pg_trgm/results/pg_trgm.out 2026-01-30 04:40:23.518340090 +0000
@@ -22,5429 +22,7 @@
(1 row)
select show_trgm('a b c');
- show_trgm
----------------------------------------
- {" a"," b"," c"," a "," b "," c "}
-(1 row)
-
-select show_trgm(' a b c ');
- show_trgm
----------------------------------------
- {" a"," b"," c"," a "," b "," c "}
-(1 row)
-
-select show_trgm('aA bB cC');
- show_trgm
... |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/pg_trgm/expected/pg_trgm.out /tmp/cirrus-ci-build/build/testrun/pg_trgm/regress/re...
--- /tmp/cirrus-ci-build/contrib/pg_trgm/expected/pg_trgm.out 2026-01-30 04:33:54.423922000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_trgm/regress/results/pg_trgm.out 2026-01-30 04:37:47.742917000 +0000
@@ -22,5429 +22,7 @@
(1 row)
select show_trgm('a b c');
- show_trgm
----------------------------------------
- {" a"," b"," c"," a "," b "," c "}
-(1 row)
-
-select show_trgm(' a b c ');
- show_trgm
----------------------------------------
- {" a"," b"," c"," a "," b "," c "}
-(1 row)
-
-select show_trgm('aA bB cC');
- show_trgm
... |
|
OpenBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/contrib/pg_trgm/expected/pg_trgm.out /home/postgres/postgres/build/testrun/pg_trgm/regr...
--- /home/postgres/postgres/contrib/pg_trgm/expected/pg_trgm.out Fri Jan 30 04:34:01 2026
+++ /home/postgres/postgres/build/testrun/pg_trgm/regress/results/pg_trgm.out Fri Jan 30 04:39:44 2026
@@ -22,5429 +22,7 @@
(1 row)
select show_trgm('a b c');
- show_trgm
----------------------------------------
- {" a"," b"," c"," a "," b "," c "}
-(1 row)
-
-select show_trgm(' a b c ');
- show_trgm
----------------------------------------
- {" a"," b"," c"," a "," b "," c "}
-(1 row)
-
-select show_trgm('aA bB cC');
- show_trgm
... |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/contrib/pg_trgm/expected/pg_trgm.out /home/postgres/postgres/build/testrun/pg_trgm/regr...
--- /home/postgres/postgres/contrib/pg_trgm/expected/pg_trgm.out 2026-01-30 04:34:13.986722460 +0000
+++ /home/postgres/postgres/build/testrun/pg_trgm/regress/results/pg_trgm.out 2026-01-30 04:37:40.646790581 +0000
@@ -22,5429 +22,7 @@
(1 row)
select show_trgm('a b c');
- show_trgm
----------------------------------------
- {" a"," b"," c"," a "," b "," c "}
-(1 row)
-
-select show_trgm(' a b c ');
- show_trgm
----------------------------------------
- {" a"," b"," c"," a "," b "," c "}
-(1 row)
-
-select show_trgm('aA bB cC');
- show_trgm
... |
| 57/6176 |
Batching in executor, part 1: add batch variant of table AM scan API |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/explain.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg...
--- /tmp/cirrus-ci-build/src/test/regress/expected/explain.out 2026-01-29 08:20:16.009584000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/explain.out 2026-01-29 08:25:25.838841000 ...
@@ -844,10 +844,9 @@
Seq Scan on batch_test (actual time=N.N..N.N rows=N.N loops=N)
Filter: (a > N)
Rows Removed by Filter: N
- Batches: N Avg Rows: N.N Max: N Min: N
Planning Time: N.N ms
Execution Time: N.N ms
-(6 rows)
+(5 rows)
-- With LIMIT - partial scan shows fewer batches
select explain_filter('explain (analyze, batches, buffers off, costs off) select * from batch_test limit 100');
@@ -855,10 +854,9 @@
----------------------------------------------------------------------
Limit (actual time=N.N..N.N rows=N.N loops=N)
-> Seq Scan on batch_test (actual time=N.N..N.N rows=N.N loops=N)
- Batches: N Avg Rows: N.N Max: N Min: N
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/explain.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stre...
--- /tmp/cirrus-ci-build/src/test/regress/expected/explain.out 2026-01-29 08:20:16.009584000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/explain.out 2026-01-29 08:26:58.52903500...
@@ -832,10 +832,9 @@
explain_filter
----------------------------------------------------------------
Seq Scan on batch_test (actual time=N.N..N.N rows=N.N loops=N)
- Batches: N Avg Rows: N.N Max: N Min: N
Planning Time: N.N ms
Execution Time: N.N ms
-(4 rows)
+(3 rows)
-- With filter
select explain_filter('explain (analyze, batches, buffers off, costs off) select * from batch_test where a > 5000');
@@ -844,10 +843,9 @@
Seq Scan on batch_test (actual time=N.N..N.N rows=N.N loops=N)
Filter: (a > N)
Rows Removed by Filter: N
- Batches: N Avg Rows: N.N Max: N Min: N
... |
| 57/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/recovery/027_st...
--- C:/cirrus/src/test/regress/expected/rowsecurity.out 2026-01-29 07:36:41.572305400 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/rowsecurity.out 2026-01-29 07:46:24.665039900 +0000
@@ -378,15 +378,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...
... |
| 57/6334 |
Remove header lock BufferGetLSNAtomic() on architectures with 64 bit atomic operations |
|
Linux - Debian Trixie - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/pageinspect/expected/page.out /tmp/cirrus-ci-build/build/testrun/pageinspect/regre...
--- /tmp/cirrus-ci-build/contrib/pageinspect/expected/page.out 2026-01-29 07:00:48.706682628 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pageinspect/regress/results/page.out 2026-01-29 07:07:10.039444827 +0000
@@ -62,227 +62,7 @@
ERROR: invalid block number
SELECT tuple_data_split('test1'::regclass, t_data, t_infomask, t_infomask2, t_bits)
FROM heap_page_items(get_raw_page('test1', 0));
- tuple_data_split
--------------------------------
- {"\\x01000001","\\x00020200"}
-(1 row)
-
-SELECT * FROM fsm_page_contents(get_raw_page('test1', 'fsm', 0));
- fsm_page_contents
--------------------
- 0: 254 +
- 1: 254 +
- 3: 254 +
- 7: 254 +
- 15: 254 +
... |
| 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-01-29 06:58:11.098132200 +0000
+++ C:/cirrus/build/testrun/pageinspect/regress/results/btree.out 2026-01-29 07:06:56.418289300 +0000
@@ -148,23 +148,25 @@
ERROR: block number 7 is out of range
DROP TABLE test2;
SELECT * FROM bt_page_items('test1_a_idx', -1);
-ERROR: invalid block number -1
+ERROR: function bt_page_items(unknown, integer) does not exist
+LINE 1: SELECT * FROM bt_page_items('test1_a_idx', -1);
+ ^
+DETAIL: No function of that name accepts the given number of arguments.
SELECT * FROM bt_page_items('test1_a_idx', 0);
-ERROR: block 0 is a meta page
+ERROR: function bt_page_items(unknown, integer) does not exist
+LINE 1: SELECT * FROM bt_page_items('test1_a_idx', 0);
+ ^
+DETAIL: No function of that name accepts the given number of arguments.
SELECT * FROM bt_page_items('test1_a_idx', 1);
--[ RECORD 1 ]-----------------------
... |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/pageinspect/expected/btree.out C:/cirrus/build/testrun/pageinspect/regres...
--- C:/cirrus/contrib/pageinspect/expected/btree.out 2026-01-29 06:57:36.983009700 +0000
+++ C:/cirrus/build/testrun/pageinspect/regress/results/btree.out 2026-01-29 07:06:17.798892700 +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-01-29 07:29:22
+++ /Users/admin/pgsql/build/testrun/pageinspect/regress/results/btree.out 2026-01-29 07:34:02
@@ -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-01-29 06:57:39.789189127 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pageinspect/regress/results/btree.out 2026-01-29 07:01:35.392377169 +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-01-29 06:58:42.556807162 +0000
+++ /home/postgres/postgres/build/testrun/pageinspect/regress/results/btree.out 2026-01-29 07:01:02.628918652 +0000
@@ -148,23 +148,25 @@
ERROR: block number 7 is out of range
DROP TABLE test2;
SELECT * FROM bt_page_items('test1_a_idx', -1);
-ERROR: invalid block number -1
+ERROR: function bt_page_items(unknown, integer) does not exist
+LINE 1: SELECT * FROM bt_page_items('test1_a_idx', -1);
+ ^
+DETAIL: No function of that name accepts the given number of arguments.
SELECT * FROM bt_page_items('test1_a_idx', 0);
-ERROR: block 0 is a meta page
+ERROR: function bt_page_items(unknown, integer) does not exist
+LINE 1: SELECT * FROM bt_page_items('test1_a_idx', 0);
+ ^
+DETAIL: No function of that name accepts the given number of arguments.
SELECT * FROM bt_page_items('test1_a_idx', 1);
--[ RECORD 1 ]-----------------------
... |
|
Linux - Debian Trixie - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/pageinspect/expected/btree.out /tmp/cirrus-ci-build/contrib/pageinspect/results/bt...
--- /tmp/cirrus-ci-build/contrib/pageinspect/expected/btree.out 2026-01-29 06:58:47.112675017 +0000
+++ /tmp/cirrus-ci-build/contrib/pageinspect/results/btree.out 2026-01-29 07:02:37.933266472 +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 Thu Jan 29 06:57:56 2026
+++ /home/postgres/postgres/build/testrun/pageinspect/regress/results/btree.out Thu Jan 29 07:02:47 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 ]-----------------------
... |
|
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-01-29 06:57:40.122485000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pageinspect/regress/results/btree.out 2026-01-29 07:00:47.945203000 +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 ]-----------------------
... |
| 57/6274 |
Add a greedy join search algorithm to handle large join problems |
|
Windows - Server 2022, MinGW64 - Meson |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/goo.out C:/cirrus/build/testrun/pg_upgrade/002_pg_upgra...
--- C:/cirrus/src/test/regress/expected/goo.out 2026-01-29 06:51:25.129634200 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/goo.out 2026-01-29 06:57:35.665993700 +0000
@@ -177,66 +177,66 @@
JOIN t13 ON t11.l = t13.l
JOIN t14 ON t12.m = t14.m
JOIN t15 ON t13.n = t15.n;
- QUERY PLAN
-----------------------------------------------------------------
+ QUERY PLAN
+----------------------------------------------------------------------------
Aggregate
-> Hash Join
- Hash Cond: (t7.h = t9.h)
+ Hash Cond: (t11.l = t13.l)
-> Hash Join
- Hash Cond: (t8.i = t10.i)
+ Hash Cond: (t9.j = t11.j)
-> Hash Join
- Hash Cond: (t2.c = t4.c)
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/goo.out C:/cirrus/build/testrun/recovery/027_stream_reg...
--- C:/cirrus/src/test/regress/expected/goo.out 2026-01-29 06:51:25.129634200 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/goo.out 2026-01-29 07:00:37.283296200 +0000
@@ -177,66 +177,66 @@
JOIN t13 ON t11.l = t13.l
JOIN t14 ON t12.m = t14.m
JOIN t15 ON t13.n = t15.n;
- QUERY PLAN
-----------------------------------------------------------------
+ QUERY PLAN
+----------------------------------------------------------------------------
Aggregate
-> Hash Join
- Hash Cond: (t7.h = t9.h)
+ Hash Cond: (t11.l = t13.l)
-> Hash Join
- Hash Cond: (t8.i = t10.i)
+ Hash Cond: (t9.j = t11.j)
-> Hash Join
- Hash Cond: (t2.c = t4.c)
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/goo.out C:/cirrus/build/testrun/regress/regress/results...
--- C:/cirrus/src/test/regress/expected/goo.out 2026-01-29 06:51:25.129634200 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/goo.out 2026-01-29 06:57:35.102532800 +0000
@@ -177,66 +177,66 @@
JOIN t13 ON t11.l = t13.l
JOIN t14 ON t12.m = t14.m
JOIN t15 ON t13.n = t15.n;
- QUERY PLAN
-----------------------------------------------------------------
+ QUERY PLAN
+----------------------------------------------------------------------------
Aggregate
-> Hash Join
- Hash Cond: (t7.h = t9.h)
+ Hash Cond: (t11.l = t13.l)
-> Hash Join
- Hash Cond: (t8.i = t10.i)
+ Hash Cond: (t9.j = t11.j)
-> Hash Join
- Hash Cond: (t2.c = t4.c)
... |
|
Linux - Debian Trixie - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/goo.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upg...
--- /tmp/cirrus-ci-build/src/test/regress/expected/goo.out 2026-01-29 06:52:15.558098567 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/goo.out 2026-01-29 06:56:43.857370794 +000...
@@ -177,66 +177,66 @@
JOIN t13 ON t11.l = t13.l
JOIN t14 ON t12.m = t14.m
JOIN t15 ON t13.n = t15.n;
- QUERY PLAN
-----------------------------------------------------------------
+ QUERY PLAN
+----------------------------------------------------------------------------
Aggregate
-> Hash Join
- Hash Cond: (t7.h = t9.h)
+ Hash Cond: (t11.l = t13.l)
-> Hash Join
- Hash Cond: (t8.i = t10.i)
+ Hash Cond: (t9.j = t11.j)
-> Hash Join
- Hash Cond: (t2.c = t4.c)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/goo.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/goo.out 2026-01-29 06:52:15.558098567 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/goo.out 2026-01-29 06:58:09.401278020 +0...
@@ -177,66 +177,66 @@
JOIN t13 ON t11.l = t13.l
JOIN t14 ON t12.m = t14.m
JOIN t15 ON t13.n = t15.n;
- QUERY PLAN
-----------------------------------------------------------------
+ QUERY PLAN
+----------------------------------------------------------------------------
Aggregate
-> Hash Join
- Hash Cond: (t7.h = t9.h)
+ Hash Cond: (t11.l = t13.l)
-> Hash Join
- Hash Cond: (t8.i = t10.i)
+ Hash Cond: (t9.j = t11.j)
-> Hash Join
- Hash Cond: (t2.c = t4.c)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/goo.out /tmp/cirrus-ci-build/build/testrun/regress/regress/resul...
--- /tmp/cirrus-ci-build/src/test/regress/expected/goo.out 2026-01-29 06:52:15.558098567 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/goo.out 2026-01-29 06:56:40.573375412 +0000
@@ -177,66 +177,66 @@
JOIN t13 ON t11.l = t13.l
JOIN t14 ON t12.m = t14.m
JOIN t15 ON t13.n = t15.n;
- QUERY PLAN
-----------------------------------------------------------------
+ QUERY PLAN
+----------------------------------------------------------------------------
Aggregate
-> Hash Join
- Hash Cond: (t7.h = t9.h)
+ Hash Cond: (t11.l = t13.l)
-> Hash Join
- Hash Cond: (t8.i = t10.i)
+ Hash Cond: (t9.j = t11.j)
-> Hash Join
- Hash Cond: (t2.c = t4.c)
... |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/goo.out C:/cirrus/build/testrun/pg_upgrade/002_pg_upgra...
--- C:/cirrus/src/test/regress/expected/goo.out 2026-01-29 06:51:32.777931400 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/goo.out 2026-01-29 06:55:20.373713900 +0000
@@ -177,66 +177,66 @@
JOIN t13 ON t11.l = t13.l
JOIN t14 ON t12.m = t14.m
JOIN t15 ON t13.n = t15.n;
- QUERY PLAN
-----------------------------------------------------------------
+ QUERY PLAN
+----------------------------------------------------------------------------
Aggregate
-> Hash Join
- Hash Cond: (t7.h = t9.h)
+ Hash Cond: (t11.l = t13.l)
-> Hash Join
- Hash Cond: (t8.i = t10.i)
+ Hash Cond: (t9.j = t11.j)
-> Hash Join
- Hash Cond: (t2.c = t4.c)
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/goo.out C:/cirrus/build/testrun/recovery/027_stream_reg...
--- C:/cirrus/src/test/regress/expected/goo.out 2026-01-29 06:51:32.777931400 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/goo.out 2026-01-29 06:58:38.900219600 +0000
@@ -177,66 +177,66 @@
JOIN t13 ON t11.l = t13.l
JOIN t14 ON t12.m = t14.m
JOIN t15 ON t13.n = t15.n;
- QUERY PLAN
-----------------------------------------------------------------
+ QUERY PLAN
+----------------------------------------------------------------------------
Aggregate
-> Hash Join
- Hash Cond: (t7.h = t9.h)
+ Hash Cond: (t11.l = t13.l)
-> Hash Join
- Hash Cond: (t8.i = t10.i)
+ Hash Cond: (t9.j = t11.j)
-> Hash Join
- Hash Cond: (t2.c = t4.c)
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/goo.out C:/cirrus/build/testrun/regress/regress/results...
--- C:/cirrus/src/test/regress/expected/goo.out 2026-01-29 06:51:32.777931400 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/goo.out 2026-01-29 06:55:19.432797400 +0000
@@ -177,66 +177,66 @@
JOIN t13 ON t11.l = t13.l
JOIN t14 ON t12.m = t14.m
JOIN t15 ON t13.n = t15.n;
- QUERY PLAN
-----------------------------------------------------------------
+ QUERY PLAN
+----------------------------------------------------------------------------
Aggregate
-> Hash Join
- Hash Cond: (t7.h = t9.h)
+ Hash Cond: (t11.l = t13.l)
-> Hash Join
- Hash Cond: (t8.i = t10.i)
+ Hash Cond: (t9.j = t11.j)
-> Hash Join
- Hash Cond: (t2.c = t4.c)
... |
|
macOS - Sequoia - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/goo.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade...
--- /Users/admin/pgsql/src/test/regress/expected/goo.out 2026-01-29 06:52:26
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/goo.out 2026-01-29 06:55:31
@@ -177,66 +177,66 @@
JOIN t13 ON t11.l = t13.l
JOIN t14 ON t12.m = t14.m
JOIN t15 ON t13.n = t15.n;
- QUERY PLAN
-----------------------------------------------------------------
+ QUERY PLAN
+----------------------------------------------------------------------------
Aggregate
-> Hash Join
- Hash Cond: (t7.h = t9.h)
+ Hash Cond: (t11.l = t13.l)
-> Hash Join
- Hash Cond: (t8.i = t10.i)
+ Hash Cond: (t9.j = t11.j)
-> Hash Join
- Hash Cond: (t2.c = t4.c)
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/goo.out /Users/admin/pgsql/build/testrun/recovery/027_stream_regre...
--- /Users/admin/pgsql/src/test/regress/expected/goo.out 2026-01-29 06:52:26
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/goo.out 2026-01-29 06:57:38
@@ -177,66 +177,66 @@
JOIN t13 ON t11.l = t13.l
JOIN t14 ON t12.m = t14.m
JOIN t15 ON t13.n = t15.n;
- QUERY PLAN
-----------------------------------------------------------------
+ QUERY PLAN
+----------------------------------------------------------------------------
Aggregate
-> Hash Join
- Hash Cond: (t7.h = t9.h)
+ Hash Cond: (t11.l = t13.l)
-> Hash Join
- Hash Cond: (t8.i = t10.i)
+ Hash Cond: (t9.j = t11.j)
-> Hash Join
- Hash Cond: (t2.c = t4.c)
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/goo.out /Users/admin/pgsql/build/testrun/regress/regress/results/g...
--- /Users/admin/pgsql/src/test/regress/expected/goo.out 2026-01-29 06:52:26
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/goo.out 2026-01-29 06:55:34
@@ -177,66 +177,66 @@
JOIN t13 ON t11.l = t13.l
JOIN t14 ON t12.m = t14.m
JOIN t15 ON t13.n = t15.n;
- QUERY PLAN
-----------------------------------------------------------------
+ QUERY PLAN
+----------------------------------------------------------------------------
Aggregate
-> Hash Join
- Hash Cond: (t7.h = t9.h)
+ Hash Cond: (t11.l = t13.l)
-> Hash Join
- Hash Cond: (t8.i = t10.i)
+ Hash Cond: (t9.j = t11.j)
-> Hash Join
- Hash Cond: (t2.c = t4.c)
... |
|
OpenBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/goo.out /home/postgres/postgres/build/testrun/pg_upgrade/002_...
--- /home/postgres/postgres/src/test/regress/expected/goo.out Thu Jan 29 06:51:37 2026
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/goo.out Thu Jan 29 06:55:22 2026
@@ -177,66 +177,66 @@
JOIN t13 ON t11.l = t13.l
JOIN t14 ON t12.m = t14.m
JOIN t15 ON t13.n = t15.n;
- QUERY PLAN
-----------------------------------------------------------------
+ QUERY PLAN
+----------------------------------------------------------------------------
Aggregate
-> Hash Join
- Hash Cond: (t7.h = t9.h)
+ Hash Cond: (t11.l = t13.l)
-> Hash Join
- Hash Cond: (t8.i = t10.i)
+ Hash Cond: (t9.j = t11.j)
-> Hash Join
- Hash Cond: (t2.c = t4.c)
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/goo.out /home/postgres/postgres/build/testrun/recovery/027_st...
--- /home/postgres/postgres/src/test/regress/expected/goo.out Thu Jan 29 06:51:37 2026
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/goo.out Thu Jan 29 06:57:40 2026
@@ -177,66 +177,66 @@
JOIN t13 ON t11.l = t13.l
JOIN t14 ON t12.m = t14.m
JOIN t15 ON t13.n = t15.n;
- QUERY PLAN
-----------------------------------------------------------------
+ QUERY PLAN
+----------------------------------------------------------------------------
Aggregate
-> Hash Join
- Hash Cond: (t7.h = t9.h)
+ Hash Cond: (t11.l = t13.l)
-> Hash Join
- Hash Cond: (t8.i = t10.i)
+ Hash Cond: (t9.j = t11.j)
-> Hash Join
- Hash Cond: (t2.c = t4.c)
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/goo.out /home/postgres/postgres/build/testrun/regress/regress...
--- /home/postgres/postgres/src/test/regress/expected/goo.out Thu Jan 29 06:51:37 2026
+++ /home/postgres/postgres/build/testrun/regress/regress/results/goo.out Thu Jan 29 06:55:18 2026
@@ -177,66 +177,66 @@
JOIN t13 ON t11.l = t13.l
JOIN t14 ON t12.m = t14.m
JOIN t15 ON t13.n = t15.n;
- QUERY PLAN
-----------------------------------------------------------------
+ QUERY PLAN
+----------------------------------------------------------------------------
Aggregate
-> Hash Join
- Hash Cond: (t7.h = t9.h)
+ Hash Cond: (t11.l = t13.l)
-> Hash Join
- Hash Cond: (t8.i = t10.i)
+ Hash Cond: (t9.j = t11.j)
-> Hash Join
- Hash Cond: (t2.c = t4.c)
... |
|
Linux - Debian Trixie - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/goo.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/result...
--- /tmp/cirrus-ci-build/src/test/regress/expected/goo.out 2026-01-29 06:51:24.427159672 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/goo.out 2026-01-29 06:58:55.662425657 +0000
@@ -177,66 +177,66 @@
JOIN t13 ON t11.l = t13.l
JOIN t14 ON t12.m = t14.m
JOIN t15 ON t13.n = t15.n;
- QUERY PLAN
-----------------------------------------------------------------
+ QUERY PLAN
+----------------------------------------------------------------------------
Aggregate
-> Hash Join
- Hash Cond: (t7.h = t9.h)
+ Hash Cond: (t11.l = t13.l)
-> Hash Join
- Hash Cond: (t8.i = t10.i)
+ Hash Cond: (t9.j = t11.j)
-> Hash Join
- Hash Cond: (t2.c = t4.c)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/goo.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results...
--- /tmp/cirrus-ci-build/src/test/regress/expected/goo.out 2026-01-29 06:51:24.427159672 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/goo.out 2026-01-29 07:00:43.034206896 +0000
@@ -177,66 +177,66 @@
JOIN t13 ON t11.l = t13.l
JOIN t14 ON t12.m = t14.m
JOIN t15 ON t13.n = t15.n;
- QUERY PLAN
-----------------------------------------------------------------
+ QUERY PLAN
+----------------------------------------------------------------------------
Aggregate
-> Hash Join
- Hash Cond: (t7.h = t9.h)
+ Hash Cond: (t11.l = t13.l)
-> Hash Join
- Hash Cond: (t8.i = t10.i)
+ Hash Cond: (t9.j = t11.j)
-> Hash Join
- Hash Cond: (t2.c = t4.c)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/goo.out /tmp/cirrus-ci-build/src/test/regress/results/goo.out
--- /tmp/cirrus-ci-build/src/test/regress/expected/goo.out 2026-01-29 06:51:24.427159672 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/goo.out 2026-01-29 06:57:00.586512333 +0000
@@ -177,66 +177,66 @@
JOIN t13 ON t11.l = t13.l
JOIN t14 ON t12.m = t14.m
JOIN t15 ON t13.n = t15.n;
- QUERY PLAN
-----------------------------------------------------------------
+ QUERY PLAN
+----------------------------------------------------------------------------
Aggregate
-> Hash Join
- Hash Cond: (t7.h = t9.h)
+ Hash Cond: (t11.l = t13.l)
-> Hash Join
- Hash Cond: (t8.i = t10.i)
+ Hash Cond: (t9.j = t11.j)
-> Hash Join
- Hash Cond: (t2.c = t4.c)
... |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/goo.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upg...
--- /tmp/cirrus-ci-build/src/test/regress/expected/goo.out 2026-01-29 06:52:04.919202000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/goo.out 2026-01-29 06:55:15.696602000 +000...
@@ -177,66 +177,66 @@
JOIN t13 ON t11.l = t13.l
JOIN t14 ON t12.m = t14.m
JOIN t15 ON t13.n = t15.n;
- QUERY PLAN
-----------------------------------------------------------------
+ QUERY PLAN
+----------------------------------------------------------------------------
Aggregate
-> Hash Join
- Hash Cond: (t7.h = t9.h)
+ Hash Cond: (t11.l = t13.l)
-> Hash Join
- Hash Cond: (t8.i = t10.i)
+ Hash Cond: (t9.j = t11.j)
-> Hash Join
- Hash Cond: (t2.c = t4.c)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/goo.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/goo.out 2026-01-29 06:52:04.919202000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/goo.out 2026-01-29 06:56:50.653587000 +0...
@@ -177,66 +177,66 @@
JOIN t13 ON t11.l = t13.l
JOIN t14 ON t12.m = t14.m
JOIN t15 ON t13.n = t15.n;
- QUERY PLAN
-----------------------------------------------------------------
+ QUERY PLAN
+----------------------------------------------------------------------------
Aggregate
-> Hash Join
- Hash Cond: (t7.h = t9.h)
+ Hash Cond: (t11.l = t13.l)
-> Hash Join
- Hash Cond: (t8.i = t10.i)
+ Hash Cond: (t9.j = t11.j)
-> Hash Join
- Hash Cond: (t2.c = t4.c)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/goo.out /tmp/cirrus-ci-build/build/testrun/regress/regress/resul...
--- /tmp/cirrus-ci-build/src/test/regress/expected/goo.out 2026-01-29 06:52:04.919202000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/goo.out 2026-01-29 06:55:08.412315000 +0000
@@ -177,66 +177,66 @@
JOIN t13 ON t11.l = t13.l
JOIN t14 ON t12.m = t14.m
JOIN t15 ON t13.n = t15.n;
- QUERY PLAN
-----------------------------------------------------------------
+ QUERY PLAN
+----------------------------------------------------------------------------
Aggregate
-> Hash Join
- Hash Cond: (t7.h = t9.h)
+ Hash Cond: (t11.l = t13.l)
-> Hash Join
- Hash Cond: (t8.i = t10.i)
+ Hash Cond: (t9.j = t11.j)
-> Hash Join
- Hash Cond: (t2.c = t4.c)
... |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/goo.out /home/postgres/postgres/build/testrun/pg_upgrade/002_...
--- /home/postgres/postgres/src/test/regress/expected/goo.out 2026-01-29 06:51:46.312564461 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/goo.out 2026-01-29 06:54:33.952919345 +...
@@ -177,66 +177,66 @@
JOIN t13 ON t11.l = t13.l
JOIN t14 ON t12.m = t14.m
JOIN t15 ON t13.n = t15.n;
- QUERY PLAN
-----------------------------------------------------------------
+ QUERY PLAN
+----------------------------------------------------------------------------
Aggregate
-> Hash Join
- Hash Cond: (t7.h = t9.h)
+ Hash Cond: (t11.l = t13.l)
-> Hash Join
- Hash Cond: (t8.i = t10.i)
+ Hash Cond: (t9.j = t11.j)
-> Hash Join
- Hash Cond: (t2.c = t4.c)
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/goo.out /home/postgres/postgres/build/testrun/recovery/027_st...
--- /home/postgres/postgres/src/test/regress/expected/goo.out 2026-01-29 06:51:46.312564461 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/goo.out 2026-01-29 06:55:27.461744639...
@@ -177,66 +177,66 @@
JOIN t13 ON t11.l = t13.l
JOIN t14 ON t12.m = t14.m
JOIN t15 ON t13.n = t15.n;
- QUERY PLAN
-----------------------------------------------------------------
+ QUERY PLAN
+----------------------------------------------------------------------------
Aggregate
-> Hash Join
- Hash Cond: (t7.h = t9.h)
+ Hash Cond: (t11.l = t13.l)
-> Hash Join
- Hash Cond: (t8.i = t10.i)
+ Hash Cond: (t9.j = t11.j)
-> Hash Join
- Hash Cond: (t2.c = t4.c)
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/goo.out /home/postgres/postgres/build/testrun/regress/regress...
--- /home/postgres/postgres/src/test/regress/expected/goo.out 2026-01-29 06:51:46.312564461 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/goo.out 2026-01-29 06:54:28.090377288 +0000
@@ -177,66 +177,66 @@
JOIN t13 ON t11.l = t13.l
JOIN t14 ON t12.m = t14.m
JOIN t15 ON t13.n = t15.n;
- QUERY PLAN
-----------------------------------------------------------------
+ QUERY PLAN
+----------------------------------------------------------------------------
Aggregate
-> Hash Join
- Hash Cond: (t7.h = t9.h)
+ Hash Cond: (t11.l = t13.l)
-> Hash Join
- Hash Cond: (t8.i = t10.i)
+ Hash Cond: (t9.j = t11.j)
-> Hash Join
- Hash Cond: (t2.c = t4.c)
... |
| 57/6299 |
New grouping strategy - Index Aggregate |
|
Windows - Server 2022, MinGW64 - Meson |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/subselect.out C:/cirrus/build/testrun/pg_upgrade/002_pg...
--- C:/cirrus/src/test/regress/expected/subselect.out 2026-01-29 06:40:09.334859800 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/subselect.out 2026-01-29 06:46:46.741268000 +0000
@@ -1964,23 +1964,20 @@
select * from
(select tattle(3, ten) as v, count(*) from tenk1 where unique1 < 3 group by 1) ss
where ss.v;
- QUERY PLAN
-------------------------------------------------------------
+ QUERY PLAN
+------------------------------------------------------
Subquery Scan on ss
Output: ss.v, ss.count
Filter: ss.v
- -> GroupAggregate
+ -> IndexAggregate
Output: (tattle(3, tenk1.ten)), count(*)
- Group Key: (tattle(3, tenk1.ten))
- -> Sort
- Output: (tattle(3, tenk1.ten))
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/subselect.out C:/cirrus/build/testrun/recovery/027_stre...
--- C:/cirrus/src/test/regress/expected/subselect.out 2026-01-29 06:40:09.334859800 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/subselect.out 2026-01-29 06:49:49.185067600 +0000
@@ -1964,23 +1964,20 @@
select * from
(select tattle(3, ten) as v, count(*) from tenk1 where unique1 < 3 group by 1) ss
where ss.v;
- QUERY PLAN
-------------------------------------------------------------
+ QUERY PLAN
+------------------------------------------------------
Subquery Scan on ss
Output: ss.v, ss.count
Filter: ss.v
- -> GroupAggregate
+ -> IndexAggregate
Output: (tattle(3, tenk1.ten)), count(*)
- Group Key: (tattle(3, tenk1.ten))
- -> Sort
- Output: (tattle(3, tenk1.ten))
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/subselect.out C:/cirrus/build/testrun/regress/regress/r...
--- C:/cirrus/src/test/regress/expected/subselect.out 2026-01-29 06:40:09.334859800 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/subselect.out 2026-01-29 06:46:44.130421100 +0000
@@ -1964,23 +1964,20 @@
select * from
(select tattle(3, ten) as v, count(*) from tenk1 where unique1 < 3 group by 1) ss
where ss.v;
- QUERY PLAN
-------------------------------------------------------------
+ QUERY PLAN
+------------------------------------------------------
Subquery Scan on ss
Output: ss.v, ss.count
Filter: ss.v
- -> GroupAggregate
+ -> IndexAggregate
Output: (tattle(3, tenk1.ten)), count(*)
- Group Key: (tattle(3, tenk1.ten))
- -> Sort
- Output: (tattle(3, tenk1.ten))
... |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/subselect.out C:/cirrus/build/testrun/pg_upgrade/002_pg...
--- C:/cirrus/src/test/regress/expected/subselect.out 2026-01-29 06:37:47.579491200 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/subselect.out 2026-01-29 06:41:01.710674300 +0000
@@ -1964,23 +1964,20 @@
select * from
(select tattle(3, ten) as v, count(*) from tenk1 where unique1 < 3 group by 1) ss
where ss.v;
- QUERY PLAN
-------------------------------------------------------------
+ QUERY PLAN
+------------------------------------------------------
Subquery Scan on ss
Output: ss.v, ss.count
Filter: ss.v
- -> GroupAggregate
+ -> IndexAggregate
Output: (tattle(3, tenk1.ten)), count(*)
- Group Key: (tattle(3, tenk1.ten))
- -> Sort
- Output: (tattle(3, tenk1.ten))
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/subselect.out C:/cirrus/build/testrun/recovery/027_stre...
--- C:/cirrus/src/test/regress/expected/subselect.out 2026-01-29 06:37:47.579491200 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/subselect.out 2026-01-29 06:44:14.080755500 +0000
@@ -1964,23 +1964,20 @@
select * from
(select tattle(3, ten) as v, count(*) from tenk1 where unique1 < 3 group by 1) ss
where ss.v;
- QUERY PLAN
-------------------------------------------------------------
+ QUERY PLAN
+------------------------------------------------------
Subquery Scan on ss
Output: ss.v, ss.count
Filter: ss.v
- -> GroupAggregate
+ -> IndexAggregate
Output: (tattle(3, tenk1.ten)), count(*)
- Group Key: (tattle(3, tenk1.ten))
- -> Sort
- Output: (tattle(3, tenk1.ten))
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/subselect.out C:/cirrus/build/testrun/regress/regress/r...
--- C:/cirrus/src/test/regress/expected/subselect.out 2026-01-29 06:37:47.579491200 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/subselect.out 2026-01-29 06:40:56.286839900 +0000
@@ -1964,23 +1964,20 @@
select * from
(select tattle(3, ten) as v, count(*) from tenk1 where unique1 < 3 group by 1) ss
where ss.v;
- QUERY PLAN
-------------------------------------------------------------
+ QUERY PLAN
+------------------------------------------------------
Subquery Scan on ss
Output: ss.v, ss.count
Filter: ss.v
- -> GroupAggregate
+ -> IndexAggregate
Output: (tattle(3, tenk1.ten)), count(*)
- Group Key: (tattle(3, tenk1.ten))
- -> Sort
- Output: (tattle(3, tenk1.ten))
... |
|
macOS - Sequoia - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/subselect.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_u...
--- /Users/admin/pgsql/src/test/regress/expected/subselect.out 2026-01-29 06:37:44
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/subselect.out 2026-01-29 06:40:43
@@ -1964,23 +1964,20 @@
select * from
(select tattle(3, ten) as v, count(*) from tenk1 where unique1 < 3 group by 1) ss
where ss.v;
- QUERY PLAN
-------------------------------------------------------------
+ QUERY PLAN
+------------------------------------------------------
Subquery Scan on ss
Output: ss.v, ss.count
Filter: ss.v
- -> GroupAggregate
+ -> IndexAggregate
Output: (tattle(3, tenk1.ten)), count(*)
- Group Key: (tattle(3, tenk1.ten))
- -> Sort
- Output: (tattle(3, tenk1.ten))
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/subselect.out /Users/admin/pgsql/build/testrun/recovery/027_stream...
--- /Users/admin/pgsql/src/test/regress/expected/subselect.out 2026-01-29 06:37:44
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/subselect.out 2026-01-29 06:42:42
@@ -1964,23 +1964,20 @@
select * from
(select tattle(3, ten) as v, count(*) from tenk1 where unique1 < 3 group by 1) ss
where ss.v;
- QUERY PLAN
-------------------------------------------------------------
+ QUERY PLAN
+------------------------------------------------------
Subquery Scan on ss
Output: ss.v, ss.count
Filter: ss.v
- -> GroupAggregate
+ -> IndexAggregate
Output: (tattle(3, tenk1.ten)), count(*)
- Group Key: (tattle(3, tenk1.ten))
- -> Sort
- Output: (tattle(3, tenk1.ten))
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/subselect.out /Users/admin/pgsql/build/testrun/regress/regress/res...
--- /Users/admin/pgsql/src/test/regress/expected/subselect.out 2026-01-29 06:37:44
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/subselect.out 2026-01-29 06:40:40
@@ -1964,23 +1964,20 @@
select * from
(select tattle(3, ten) as v, count(*) from tenk1 where unique1 < 3 group by 1) ss
where ss.v;
- QUERY PLAN
-------------------------------------------------------------
+ QUERY PLAN
+------------------------------------------------------
Subquery Scan on ss
Output: ss.v, ss.count
Filter: ss.v
- -> GroupAggregate
+ -> IndexAggregate
Output: (tattle(3, tenk1.ten)), count(*)
- Group Key: (tattle(3, tenk1.ten))
- -> Sort
- Output: (tattle(3, tenk1.ten))
... |
|
Linux - Debian Trixie - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out 2026-01-29 06:36:41.269028437 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/subselect.out 2026-01-29 06:41:18.35278954...
@@ -1964,23 +1964,20 @@
select * from
(select tattle(3, ten) as v, count(*) from tenk1 where unique1 < 3 group by 1) ss
where ss.v;
- QUERY PLAN
-------------------------------------------------------------
+ QUERY PLAN
+------------------------------------------------------
Subquery Scan on ss
Output: ss.v, ss.count
Filter: ss.v
- -> GroupAggregate
+ -> IndexAggregate
Output: (tattle(3, tenk1.ten)), count(*)
- Group Key: (tattle(3, tenk1.ten))
- -> Sort
- Output: (tattle(3, tenk1.ten))
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out /tmp/cirrus-ci-build/build/testrun/recovery/027_st...
--- /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out 2026-01-29 06:36:41.269028437 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/subselect.out 2026-01-29 06:42:38.332796...
@@ -1964,23 +1964,20 @@
select * from
(select tattle(3, ten) as v, count(*) from tenk1 where unique1 < 3 group by 1) ss
where ss.v;
- QUERY PLAN
-------------------------------------------------------------
+ QUERY PLAN
+------------------------------------------------------
Subquery Scan on ss
Output: ss.v, ss.count
Filter: ss.v
- -> GroupAggregate
+ -> IndexAggregate
Output: (tattle(3, tenk1.ten)), count(*)
- Group Key: (tattle(3, tenk1.ten))
- -> Sort
- Output: (tattle(3, tenk1.ten))
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out /tmp/cirrus-ci-build/build/testrun/regress/regress...
--- /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out 2026-01-29 06:36:41.269028437 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/subselect.out 2026-01-29 06:41:15.108789266 +0000
@@ -1964,23 +1964,20 @@
select * from
(select tattle(3, ten) as v, count(*) from tenk1 where unique1 < 3 group by 1) ss
where ss.v;
- QUERY PLAN
-------------------------------------------------------------
+ QUERY PLAN
+------------------------------------------------------
Subquery Scan on ss
Output: ss.v, ss.count
Filter: ss.v
- -> GroupAggregate
+ -> IndexAggregate
Output: (tattle(3, tenk1.ten)), count(*)
- Group Key: (tattle(3, tenk1.ten))
- -> Sort
- Output: (tattle(3, tenk1.ten))
... |
|
OpenBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/subselect.out /home/postgres/postgres/build/testrun/pg_upgrad...
--- /home/postgres/postgres/src/test/regress/expected/subselect.out Thu Jan 29 06:37:19 2026
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/subselect.out Thu Jan 29 06:41:19 2026
@@ -1964,23 +1964,20 @@
select * from
(select tattle(3, ten) as v, count(*) from tenk1 where unique1 < 3 group by 1) ss
where ss.v;
- QUERY PLAN
-------------------------------------------------------------
+ QUERY PLAN
+------------------------------------------------------
Subquery Scan on ss
Output: ss.v, ss.count
Filter: ss.v
- -> GroupAggregate
+ -> IndexAggregate
Output: (tattle(3, tenk1.ten)), count(*)
- Group Key: (tattle(3, tenk1.ten))
- -> Sort
- Output: (tattle(3, tenk1.ten))
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/subselect.out /home/postgres/postgres/build/testrun/recovery/...
--- /home/postgres/postgres/src/test/regress/expected/subselect.out Thu Jan 29 06:37:19 2026
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/subselect.out Thu Jan 29 06:43:00 202...
@@ -1964,23 +1964,20 @@
select * from
(select tattle(3, ten) as v, count(*) from tenk1 where unique1 < 3 group by 1) ss
where ss.v;
- QUERY PLAN
-------------------------------------------------------------
+ QUERY PLAN
+------------------------------------------------------
Subquery Scan on ss
Output: ss.v, ss.count
Filter: ss.v
- -> GroupAggregate
+ -> IndexAggregate
Output: (tattle(3, tenk1.ten)), count(*)
- Group Key: (tattle(3, tenk1.ten))
- -> Sort
- Output: (tattle(3, tenk1.ten))
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/subselect.out /home/postgres/postgres/build/testrun/regress/r...
--- /home/postgres/postgres/src/test/regress/expected/subselect.out Thu Jan 29 06:37:19 2026
+++ /home/postgres/postgres/build/testrun/regress/regress/results/subselect.out Thu Jan 29 06:41:12 2026
@@ -1964,23 +1964,20 @@
select * from
(select tattle(3, ten) as v, count(*) from tenk1 where unique1 < 3 group by 1) ss
where ss.v;
- QUERY PLAN
-------------------------------------------------------------
+ QUERY PLAN
+------------------------------------------------------
Subquery Scan on ss
Output: ss.v, ss.count
Filter: ss.v
- -> GroupAggregate
+ -> IndexAggregate
Output: (tattle(3, tenk1.ten)), count(*)
- Group Key: (tattle(3, tenk1.ten))
- -> Sort
- Output: (tattle(3, tenk1.ten))
... |
|
Linux - Debian Trixie - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out 2026-01-29 06:38:03.335458723 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/subselect.out 2026-01-29 06:46:03.858044500 +0000
@@ -1964,23 +1964,20 @@
select * from
(select tattle(3, ten) as v, count(*) from tenk1 where unique1 < 3 group by 1) ss
where ss.v;
- QUERY PLAN
-------------------------------------------------------------
+ QUERY PLAN
+------------------------------------------------------
Subquery Scan on ss
Output: ss.v, ss.count
Filter: ss.v
- -> GroupAggregate
+ -> IndexAggregate
Output: (tattle(3, tenk1.ten)), count(*)
- Group Key: (tattle(3, tenk1.ten))
- -> Sort
- Output: (tattle(3, tenk1.ten))
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check/r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out 2026-01-29 06:38:03.335458723 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/subselect.out 2026-01-29 06:47:21.281856440 +0000
@@ -1964,23 +1964,20 @@
select * from
(select tattle(3, ten) as v, count(*) from tenk1 where unique1 < 3 group by 1) ss
where ss.v;
- QUERY PLAN
-------------------------------------------------------------
+ QUERY PLAN
+------------------------------------------------------
Subquery Scan on ss
Output: ss.v, ss.count
Filter: ss.v
- -> GroupAggregate
+ -> IndexAggregate
Output: (tattle(3, tenk1.ten)), count(*)
- Group Key: (tattle(3, tenk1.ten))
- -> Sort
- Output: (tattle(3, tenk1.ten))
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out /tmp/cirrus-ci-build/src/test/regress/results/subs...
--- /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out 2026-01-29 06:38:03.335458723 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/subselect.out 2026-01-29 06:43:24.154695900 +0000
@@ -1964,23 +1964,20 @@
select * from
(select tattle(3, ten) as v, count(*) from tenk1 where unique1 < 3 group by 1) ss
where ss.v;
- QUERY PLAN
-------------------------------------------------------------
+ QUERY PLAN
+------------------------------------------------------
Subquery Scan on ss
Output: ss.v, ss.count
Filter: ss.v
- -> GroupAggregate
+ -> IndexAggregate
Output: (tattle(3, tenk1.ten)), count(*)
- Group Key: (tattle(3, tenk1.ten))
- -> Sort
- Output: (tattle(3, tenk1.ten))
... |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/subselect.out /home/postgres/postgres/build/testrun/pg_upgrad...
--- /home/postgres/postgres/src/test/regress/expected/subselect.out 2026-01-29 06:38:50.257460098 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/subselect.out 2026-01-29 06:41:39.81343...
@@ -1964,23 +1964,20 @@
select * from
(select tattle(3, ten) as v, count(*) from tenk1 where unique1 < 3 group by 1) ss
where ss.v;
- QUERY PLAN
-------------------------------------------------------------
+ QUERY PLAN
+------------------------------------------------------
Subquery Scan on ss
Output: ss.v, ss.count
Filter: ss.v
- -> GroupAggregate
+ -> IndexAggregate
Output: (tattle(3, tenk1.ten)), count(*)
- Group Key: (tattle(3, tenk1.ten))
- -> Sort
- Output: (tattle(3, tenk1.ten))
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/subselect.out /home/postgres/postgres/build/testrun/recovery/...
--- /home/postgres/postgres/src/test/regress/expected/subselect.out 2026-01-29 06:38:50.257460098 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/subselect.out 2026-01-29 06:42:21.231...
@@ -1964,23 +1964,20 @@
select * from
(select tattle(3, ten) as v, count(*) from tenk1 where unique1 < 3 group by 1) ss
where ss.v;
- QUERY PLAN
-------------------------------------------------------------
+ QUERY PLAN
+------------------------------------------------------
Subquery Scan on ss
Output: ss.v, ss.count
Filter: ss.v
- -> GroupAggregate
+ -> IndexAggregate
Output: (tattle(3, tenk1.ten)), count(*)
- Group Key: (tattle(3, tenk1.ten))
- -> Sort
- Output: (tattle(3, tenk1.ten))
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/subselect.out /home/postgres/postgres/build/testrun/regress/r...
--- /home/postgres/postgres/src/test/regress/expected/subselect.out 2026-01-29 06:38:50.257460098 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/subselect.out 2026-01-29 06:41:38.241317061 +0000
@@ -1964,23 +1964,20 @@
select * from
(select tattle(3, ten) as v, count(*) from tenk1 where unique1 < 3 group by 1) ss
where ss.v;
- QUERY PLAN
-------------------------------------------------------------
+ QUERY PLAN
+------------------------------------------------------
Subquery Scan on ss
Output: ss.v, ss.count
Filter: ss.v
- -> GroupAggregate
+ -> IndexAggregate
Output: (tattle(3, tenk1.ten)), count(*)
- Group Key: (tattle(3, tenk1.ten))
- -> Sort
- Output: (tattle(3, tenk1.ten))
... |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out 2026-01-29 06:36:51.722257000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/subselect.out 2026-01-29 06:39:33.08479400...
@@ -1964,23 +1964,20 @@
select * from
(select tattle(3, ten) as v, count(*) from tenk1 where unique1 < 3 group by 1) ss
where ss.v;
- QUERY PLAN
-------------------------------------------------------------
+ QUERY PLAN
+------------------------------------------------------
Subquery Scan on ss
Output: ss.v, ss.count
Filter: ss.v
- -> GroupAggregate
+ -> IndexAggregate
Output: (tattle(3, tenk1.ten)), count(*)
- Group Key: (tattle(3, tenk1.ten))
- -> Sort
- Output: (tattle(3, tenk1.ten))
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out /tmp/cirrus-ci-build/build/testrun/recovery/027_st...
--- /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out 2026-01-29 06:36:51.722257000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/subselect.out 2026-01-29 06:40:37.625558...
@@ -1964,23 +1964,20 @@
select * from
(select tattle(3, ten) as v, count(*) from tenk1 where unique1 < 3 group by 1) ss
where ss.v;
- QUERY PLAN
-------------------------------------------------------------
+ QUERY PLAN
+------------------------------------------------------
Subquery Scan on ss
Output: ss.v, ss.count
Filter: ss.v
- -> GroupAggregate
+ -> IndexAggregate
Output: (tattle(3, tenk1.ten)), count(*)
- Group Key: (tattle(3, tenk1.ten))
- -> Sort
- Output: (tattle(3, tenk1.ten))
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out /tmp/cirrus-ci-build/build/testrun/regress/regress...
--- /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out 2026-01-29 06:36:51.722257000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/subselect.out 2026-01-29 06:39:27.344168000 +0000
@@ -1964,23 +1964,20 @@
select * from
(select tattle(3, ten) as v, count(*) from tenk1 where unique1 < 3 group by 1) ss
where ss.v;
- QUERY PLAN
-------------------------------------------------------------
+ QUERY PLAN
+------------------------------------------------------
Subquery Scan on ss
Output: ss.v, ss.count
Filter: ss.v
- -> GroupAggregate
+ -> IndexAggregate
Output: (tattle(3, tenk1.ten)), count(*)
- Group Key: (tattle(3, tenk1.ten))
- -> Sort
- Output: (tattle(3, tenk1.ten))
... |
| 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-01-29 06:17:23.588663400 +0000
+++ C:/cirrus/build/testrun/pageinspect/regress/results/spgist.out 2026-01-29 06:26:18.042267300 +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-01-29 06:20:30
+++ /Users/admin/pgsql/build/testrun/pageinspect/regress/results/spgist.out 2026-01-29 06:24:11
@@ -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-01-29 06:15:29.154583100 +0000
+++ C:/cirrus/build/testrun/pageinspect/regress/results/spgist.out 2026-01-29 06:24:22.028058200 +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-01-29 06:15:40.364022159 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pageinspect/regress/results/spgist.out 2026-01-29 06:19:42.203593802 +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 | {}
... |
|
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 Thu Jan 29 06:15:43 2026
+++ /home/postgres/postgres/build/testrun/pageinspect/regress/results/spgist.out Thu Jan 29 06:20:15 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 | {}
... |
|
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-01-29 06:15:35.103546000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pageinspect/regress/results/spgist.out 2026-01-29 06:18:49.245852000 +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 | {}
... |
|
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-01-29 06:15:46.520897515 +0000
+++ /home/postgres/postgres/build/testrun/pageinspect/regress/results/spgist.out 2026-01-29 06:18:20.394842419 +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 | {}
... |
| 57/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-01-29 05:50:35.047507400 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_stored.out 2026-01-29 05:55:15.097832400 +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-01-29 05:50:35.048460700 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out 2026-01-29 05:55:23.922047500 +...
@@ -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-01-29 05:50:35.047507400 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/generated_stored.out 2026-01-29 05:58:09.415147200 ...
@@ -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-01-29 05:50:35.048460700 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out 2026-01-29 05:58:17.579693700...
@@ -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-01-29 05:50:35.047507400 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/generated_stored.out 2026-01-29 05:55:09.528987500 +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-01-29 05:50:35.048460700 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/generated_virtual.out 2026-01-29 05:55:19.507498100 +0000
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/generated_stored.out C:/cirrus/build/testrun/pg_upgrade...
--- C:/cirrus/src/test/regress/expected/generated_stored.out 2026-01-29 05:50:18.516562100 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_stored.out 2026-01-29 05:53:47.262217900 +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-01-29 05:50:18.516562100 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out 2026-01-29 05:54:04.809080200 +...
@@ -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-01-29 05:50:18.516562100 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/generated_stored.out 2026-01-29 05:56:56.300642800 ...
@@ -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-01-29 05:50:18.516562100 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out 2026-01-29 05:57:15.214196900...
@@ -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-01-29 05:50:18.516562100 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/generated_stored.out 2026-01-29 05:53:41.002456300 +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-01-29 05:50:18.516562100 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/generated_virtual.out 2026-01-29 05:53:59.682130600 +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-01-29 05:56:36
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_stored.out 2026-01-29 05:59:07
@@ -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-01-29 05:56:36
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out 2026-01-29 05:59:11
@@ -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-01-29 05:56:36
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/generated_stored.out 2026-01-29 06:00:09
@@ -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-01-29 05:56:36
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out 2026-01-29 06:00:15
@@ -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-01-29 05:56:36
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/generated_stored.out 2026-01-29 05:59:04
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff -U3 /Users/admin/pgsql/src/test/regress/expected/generated_virtual.out /Users/admin/pgsql/build/testrun/regress/reg...
--- /Users/admin/pgsql/src/test/regress/expected/generated_virtual.out 2026-01-29 05:56:36
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/generated_virtual.out 2026-01-29 05:59:09
@@ -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-01-29 05:50:38.856911719 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_stored.out 2026-01-29 05:54:15.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 -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-01-29 05:50:38.856911719 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out 2026-01-29 05:54:22....
@@ -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-01-29 05:50:38.856911719 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/generated_stored.out 2026-01-29 05:55:38...
@@ -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-01-29 05:50:38.856911719 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out 2026-01-29 05:55:4...
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_stored.out /tmp/cirrus-ci-build/build/testrun/regress/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_stored.out 2026-01-29 05:50:38.856911719 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/generated_stored.out 2026-01-29 05:54:13.289682386 +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-01-29 05:50:38.856911719 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/generated_virtual.out 2026-01-29 05:54:19.865615731 +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-01-29 05:51:26.978996985 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_stored.out 2026-01-29 05:53:4...
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff -U3 /home/postgres/postgres/src/test/regress/expected/generated_virtual.out /home/postgres/postgres/build/testrun/p...
--- /home/postgres/postgres/src/test/regress/expected/generated_virtual.out 2026-01-29 05:51:26.979759835 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out 2026-01-29 05:54:...
@@ -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-01-29 05:51:26.978996985 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/generated_stored.out 2026-01-29 05: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 2026-01-29 05:51:26.979759835 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out 2026-01-29 05: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-01-29 05:51:26.978996985 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/generated_stored.out 2026-01-29 05:53:41.137253179 +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-01-29 05:51:26.979759835 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/generated_virtual.out 2026-01-29 05:53:53.980144768 +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-01-29 05:50:44.878495651 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/generated_stored.out 2026-01-29 05:57:58.718486781 +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-01-29 05:50:44.878495651 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/generated_virtual.out 2026-01-29 05:58:12.415177117 +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-01-29 05:50:44.878495651 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/generated_stored.out 2026-01-29 05:59:05.917792327 +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-01-29 05:50:44.878495651 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/generated_virtual.out 2026-01-29 05:59:20.817250323 +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-01-29 05:50:44.878495651 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/generated_stored.out 2026-01-29 05:55:08.140822492 +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-01-29 05:50:44.878495651 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/generated_virtual.out 2026-01-29 05:55:21.660820683 +0000
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_stored.out /tmp/cirrus-ci-build/build/testrun/pg_upgra...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_stored.out 2026-01-29 05:50:39.183201000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_stored.out 2026-01-29 05:53:24.6...
@@ -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-01-29 05:50:39.183259000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out 2026-01-29 05:53:47....
@@ -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-01-29 05:50:39.183201000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/generated_stored.out 2026-01-29 05:54:37...
@@ -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-01-29 05:50:39.183259000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out 2026-01-29 05:55:1...
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
| regress |
diff -U3 /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-01-29 05:50:39.183201000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/generated_stored.out 2026-01-29 05:53:24.406573000 +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-01-29 05:50:39.183259000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/generated_virtual.out 2026-01-29 05:53:43.792566000 +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 Thu Jan 29 05:50:43 2026
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_stored.out Thu Jan 29 05:53: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 Thu Jan 29 05:50:43 2026
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out Thu Jan 29 05:54:...
@@ -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 Thu Jan 29 05:50:43 2026
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/generated_stored.out Thu Jan 29 05: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 /home/postgres/postgres/src/test/regress/expected/generated_virtual.out /home/postgres/postgres/build/testrun/r...
--- /home/postgres/postgres/src/test/regress/expected/generated_virtual.out Thu Jan 29 05:50:43 2026
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out Thu Jan 29 05: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 Thu Jan 29 05:50:43 2026
+++ /home/postgres/postgres/build/testrun/regress/regress/results/generated_stored.out Thu Jan 29 05:53:44 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 Thu Jan 29 05:50:43 2026
+++ /home/postgres/postgres/build/testrun/regress/regress/results/generated_virtual.out Thu Jan 29 05:53:56 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
... |
| 57/6343 |
Reuse data from readRecordBuf in XLogDecodeNextRecord |
|
Windows - Server 2022, MinGW64 - Meson |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/test_decoding/expected/rewrite.out C:/cirrus/build/testrun/test_decoding/...
--- C:/cirrus/contrib/test_decoding/expected/rewrite.out 2026-01-29 05:41:15.741688200 +0000
+++ C:/cirrus/build/testrun/test_decoding/regress/results/rewrite.out 2026-01-29 06:02:58.134972100 +0000
@@ -116,49 +116,7 @@
-- make old files go away
CHECKPOINT;
SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1...
- data ...
------------------------------------------------------------------------------------------------------------------------...
- BEGIN
- table public.replication_example: INSERT: id[integer]:2 somedata[integer]:2 text[character varying]:null
- table public.replication_example: INSERT: id[integer]:3 somedata[integer]:3 text[character varying]:null testcolumn1[i...
- COMMIT
- BEGIN
- table public.replication_example: INSERT: id[integer]:4 somedata[integer]:3 text[character varying]:null testcolumn1[i...
- table public.replication_example: INSERT: id[integer]:5 somedata[integer]:4 text[character varying]:null testcolumn1[i...
- COMMIT
- BEGIN
- table public.replication_example: INSERT: id[integer]:6 somedata[integer]:5 text[character varying]:null testcolumn1[i...
- COMMIT
... |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/test_decoding/expected/rewrite.out C:/cirrus/build/testrun/test_decoding/...
--- C:/cirrus/contrib/test_decoding/expected/rewrite.out 2026-01-29 05:41:20.140404500 +0000
+++ C:/cirrus/build/testrun/test_decoding/regress/results/rewrite.out 2026-01-29 05:52:58.525685100 +0000
@@ -116,49 +116,7 @@
-- make old files go away
CHECKPOINT;
SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1...
- data ...
------------------------------------------------------------------------------------------------------------------------...
- BEGIN
- table public.replication_example: INSERT: id[integer]:2 somedata[integer]:2 text[character varying]:null
- table public.replication_example: INSERT: id[integer]:3 somedata[integer]:3 text[character varying]:null testcolumn1[i...
- COMMIT
- BEGIN
- table public.replication_example: INSERT: id[integer]:4 somedata[integer]:3 text[character varying]:null testcolumn1[i...
- table public.replication_example: INSERT: id[integer]:5 somedata[integer]:4 text[character varying]:null testcolumn1[i...
- COMMIT
- BEGIN
- table public.replication_example: INSERT: id[integer]:6 somedata[integer]:5 text[character varying]:null testcolumn1[i...
- COMMIT
... |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/contrib/test_decoding/expected/rewrite.out /home/postgres/postgres/build/testrun/test_d...
--- /home/postgres/postgres/contrib/test_decoding/expected/rewrite.out 2026-01-29 05:40:18.238577065 +0000
+++ /home/postgres/postgres/build/testrun/test_decoding/regress/results/rewrite.out 2026-01-29 05:48:01.831161007 +0000
@@ -116,49 +116,7 @@
-- make old files go away
CHECKPOINT;
SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1...
- data ...
------------------------------------------------------------------------------------------------------------------------...
- BEGIN
- table public.replication_example: INSERT: id[integer]:2 somedata[integer]:2 text[character varying]:null
- table public.replication_example: INSERT: id[integer]:3 somedata[integer]:3 text[character varying]:null testcolumn1[i...
- COMMIT
- BEGIN
- table public.replication_example: INSERT: id[integer]:4 somedata[integer]:3 text[character varying]:null testcolumn1[i...
- table public.replication_example: INSERT: id[integer]:5 somedata[integer]:4 text[character varying]:null testcolumn1[i...
- COMMIT
- BEGIN
- table public.replication_example: INSERT: id[integer]:6 somedata[integer]:5 text[character varying]:null testcolumn1[i...
- COMMIT
... |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/test_decoding/expected/rewrite.out /tmp/cirrus-ci-build/build/testrun/test_decodin...
--- /tmp/cirrus-ci-build/contrib/test_decoding/expected/rewrite.out 2026-01-29 05:40:37.964018000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_decoding/regress/results/rewrite.out 2026-01-29 05:48:40.165643000 +0000
@@ -116,49 +116,7 @@
-- make old files go away
CHECKPOINT;
SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1...
- data ...
------------------------------------------------------------------------------------------------------------------------...
- BEGIN
- table public.replication_example: INSERT: id[integer]:2 somedata[integer]:2 text[character varying]:null
- table public.replication_example: INSERT: id[integer]:3 somedata[integer]:3 text[character varying]:null testcolumn1[i...
- COMMIT
- BEGIN
- table public.replication_example: INSERT: id[integer]:4 somedata[integer]:3 text[character varying]:null testcolumn1[i...
- table public.replication_example: INSERT: id[integer]:5 somedata[integer]:4 text[character varying]:null testcolumn1[i...
- COMMIT
- BEGIN
- table public.replication_example: INSERT: id[integer]:6 somedata[integer]:5 text[character varying]:null testcolumn1[i...
- COMMIT
... |
| 57/6198 |
Change initdb default to the builtin collation provider |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/contrib/citext/expected/citext_utf8.out /home/postgres/postgres/build/testrun/citext/re...
--- /home/postgres/postgres/contrib/citext/expected/citext_utf8.out 2026-01-29 05:02:10.031164601 +0000
+++ /home/postgres/postgres/build/testrun/citext/regress/results/citext_utf8.out 2026-01-29 05:05:05.163878950 +0000
@@ -30,7 +30,7 @@
SELECT 'À'::citext = 'à'::citext AS t;
t
---
- t
+ f
(1 row)
SELECT 'À'::text = 'à'::text AS f; -- text wins.
@@ -64,7 +64,7 @@
SELECT 'i'::citext = 'İ'::citext AS t;
t
---
- t
+ f
(1 row)
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/modules/test_regex/expected/test_regex_utf8.out /home/postgres/postgres/build/...
--- /home/postgres/postgres/src/test/modules/test_regex/expected/test_regex_utf8.out 2026-01-29 05:02:18.224499197 +0000
+++ /home/postgres/postgres/build/testrun/test_regex/regress/results/test_regex_utf8.out 2026-01-29 05:05:28.406709171 +...
@@ -151,7 +151,7 @@
test_regex
-----------------
{0,REG_ULOCALE}
- {xᔀሷ}
+ {x}
(2 rows)
select * from test_regex('[[:lower:]]+', E'x\u1500\u1237', 'L');
@@ -165,7 +165,7 @@
test_regex
-----------------
{0,REG_ULOCALE}
- {xᔀሷ}
+ {x}
(2 rows)
... |
| 57/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-01-29 04:58:25.110178000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/stats.out 2026-01-29 05:03:17.542678000 +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/regress/regress/res...
--- /tmp/cirrus-ci-build/src/test/regress/expected/stats.out 2026-01-29 04:58:25.110178000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/stats.out 2026-01-29 05:03:17.953792000 +0000
@@ -243,7 +243,7 @@
SELECT :seq_scan_after > :seq_scan_before;
?column?
----------
- t
+ f
(1 row)
---- |
| 58/6372 |
XSD schema validation |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/xml_1.out C:/cirrus/build/testrun/pg_upgrade/002_pg_upg...
--- C:/cirrus/src/test/regress/expected/xml_1.out 2026-01-28 16:08:06.358200600 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/xml.out 2026-01-28 16:12:45.726481500 +0000
@@ -1496,3 +1496,305 @@
LINE 1: SELECT xmltext('x'|| '<P>73</P>'::xml || .42 || true || 'j':...
^
DETAIL: This functionality requires the server to be built with libxml support.
+CREATE XMLSCHEMA person_schema AS '<?xml version="1.0"?>
+<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema">
+ <xs:element name="person">
+ <xs:complexType>
+ <xs:sequence>
+ <xs:element name="name" type="xs:string"/>
+ <xs:element name="age" type="xs:integer"/>
+ </xs:sequence>
+ </xs:complexType>
+ </xs:element>
+</xs:schema>';
+ERROR: unsupported XML feature
+LINE 1: CREATE XMLSCHEMA person_schema AS '<?xml version="1.0"?>
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/xml_1.out C:/cirrus/build/testrun/recovery/027_stream_r...
--- C:/cirrus/src/test/regress/expected/xml_1.out 2026-01-28 16:08:06.358200600 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/xml.out 2026-01-28 16:15:42.537449000 +0000
@@ -1496,3 +1496,305 @@
LINE 1: SELECT xmltext('x'|| '<P>73</P>'::xml || .42 || true || 'j':...
^
DETAIL: This functionality requires the server to be built with libxml support.
+CREATE XMLSCHEMA person_schema AS '<?xml version="1.0"?>
+<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema">
+ <xs:element name="person">
+ <xs:complexType>
+ <xs:sequence>
+ <xs:element name="name" type="xs:string"/>
+ <xs:element name="age" type="xs:integer"/>
+ </xs:sequence>
+ </xs:complexType>
+ </xs:element>
+</xs:schema>';
+ERROR: unsupported XML feature
+LINE 1: CREATE XMLSCHEMA person_schema AS '<?xml version="1.0"?>
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/xml_1.out C:/cirrus/build/testrun/regress/regress/resul...
--- C:/cirrus/src/test/regress/expected/xml_1.out 2026-01-28 16:08:06.358200600 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/xml.out 2026-01-28 16:12:42.314872100 +0000
@@ -1496,3 +1496,305 @@
LINE 1: SELECT xmltext('x'|| '<P>73</P>'::xml || .42 || true || 'j':...
^
DETAIL: This functionality requires the server to be built with libxml support.
+CREATE XMLSCHEMA person_schema AS '<?xml version="1.0"?>
+<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema">
+ <xs:element name="person">
+ <xs:complexType>
+ <xs:sequence>
+ <xs:element name="name" type="xs:string"/>
+ <xs:element name="age" type="xs:integer"/>
+ </xs:sequence>
+ </xs:complexType>
+ </xs:element>
+</xs:schema>';
+ERROR: unsupported XML feature
+LINE 1: CREATE XMLSCHEMA person_schema AS '<?xml version="1.0"?>
... |
| 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-01-28 15:26:01.353526600 +0000
+++ C:/cirrus/build/testrun/citext/regress/results/create_index_acl.out 2026-01-28 15:33:31.656813200 +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-01-28 15:26:01.408208000 +0000
+++ C:/cirrus/build/testrun/dict_xsyn/regress/results/dict_xsyn.out 2026-01-28 15:33:36.089420500 +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-01-28 15:26:01.833979100 +0000
+++ C:/cirrus/build/testrun/postgres_fdw/regress/results/postgres_fdw.out 2026-01-28 15:34:03.069394900 +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-01-28 15:26:06.497159600 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/strings.out 2026-01-28 15:31:30.569464000 +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-01-28 15:26:06.497159600 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/strings.out 2026-01-28 15:28:24.540244500 +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-01-28 15:26:06.138742200 +0000
+++ C:/cirrus/build/testrun/test_parser/regress/results/test_parser.out 2026-01-28 15:34:24.292047600 +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
... |
|
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-01-28 15:24:17.300970800 +0000
+++ C:/cirrus/build/testrun/citext/regress/results/create_index_acl.out 2026-01-28 15:32:14.117538000 +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-01-28 15:24:17.348329200 +0000
+++ C:/cirrus/build/testrun/dict_xsyn/regress/results/dict_xsyn.out 2026-01-28 15:32:22.801603500 +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-01-28 15:24:17.778331800 +0000
+++ C:/cirrus/build/testrun/postgres_fdw/regress/results/postgres_fdw.out 2026-01-28 15:32:59.644345000 +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-01-28 15:24:22.269580500 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/strings.out 2026-01-28 15:30:05.184042300 +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-01-28 15:24:22.269580500 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/strings.out 2026-01-28 15:26:54.381452900 +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-01-28 15:24:21.916269300 +0000
+++ C:/cirrus/build/testrun/test_parser/regress/results/test_parser.out 2026-01-28 15:33:17.380208500 +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-01-28 15:24:03.222616517 +0000
+++ /tmp/cirrus-ci-build/build-32/testrun/citext/regress/results/create_index_acl.out 2026-01-28 15:33:52.084038918 +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-01-28 15:24:03.230577801 +0000
+++ /tmp/cirrus-ci-build/build-32/testrun/dict_xsyn/regress/results/dict_xsyn.out 2026-01-28 15:33:56.484041014 +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-01-28 15:24:03.306209998 +0000
+++ /tmp/cirrus-ci-build/build-32/testrun/postgres_fdw/regress/results/postgres_fdw.out 2026-01-28 15:34:33.640055657 +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-01-28 15:24:05.161977818 +0000
+++ /tmp/cirrus-ci-build/build-32/testrun/recovery/027_stream_regress/data/results/tstypes.out 2026-01-28 15:33:01.33600...
@@ -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-01-28 15:24:05.161977818 +0000
+++ /tmp/cirrus-ci-build/build-32/testrun/regress/regress/results/tstypes.out 2026-01-28 15:31:30.019937632 +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-01-28 15:24:05.010541018 +0000
+++ /tmp/cirrus-ci-build/build-32/testrun/test_parser/regress/results/test_parser.out 2026-01-28 15:34:48.276060130 +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
... |
|
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-01-28 15:25:37.878536056 +0000
+++ /home/postgres/postgres/build/testrun/citext/regress/results/create_index_acl.out 2026-01-28 15:27:53.745395994 +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-01-28 15:25:37.952175119 +0000
+++ /home/postgres/postgres/build/testrun/dict_xsyn/regress/results/dict_xsyn.out 2026-01-28 15:27:54.939750174 +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-01-28 15:25:38.637658489 +0000
+++ /home/postgres/postgres/build/testrun/postgres_fdw/regress/results/postgres_fdw.out 2026-01-28 15:28:07.717876665 +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-01-28 15:25:46.124839138 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/tstypes.out 2026-01-28 15:27:15.80075...
@@ -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-01-28 15:25:46.124839138 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/tstypes.out 2026-01-28 15:26:42.733794106 +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-01-28 15:25:45.498671032 +0000
+++ /home/postgres/postgres/build/testrun/test_parser/regress/results/test_parser.out 2026-01-28 15:28:15.270225226 +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
... |
| 57/5319 |
Changing shared_buffers without restart |
|
Linux - Debian Trixie - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/pg_buffercache/expected/pg_buffercache.out /tmp/cirrus-ci-build/build/testrun/pg_b...
--- /tmp/cirrus-ci-build/contrib/pg_buffercache/expected/pg_buffercache.out 2026-01-28 13:50:56.433249453 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_buffercache/regress/results/pg_buffercache.out 2026-01-28 13:58:02.756211525 +...
@@ -3,21 +3,13 @@
from pg_settings
where name = 'shared_buffers')
from pg_buffercache;
- ?column?
-----------
- t
-(1 row)
-
+ERROR: invalid input syntax for type bigint: "128MB"
-- For pg_buffercache_os_pages, we expect at least one entry for each buffer
select count(*) >= (select setting::bigint
from pg_settings
where name = 'shared_buffers')
from pg_buffercache_os_pages;
- ?column?
-----------
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/numeric.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stre...
--- /tmp/cirrus-ci-build/src/test/regress/expected/numeric.out 2026-01-28 13:50:58.293158033 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/numeric.out 2026-01-28 13:56:42.41687091...
@@ -3757,11 +3757,8 @@
SET LOCAL parallel_setup_cost = 0;
SET LOCAL max_parallel_workers_per_gather = 4;
SELECT trim_scale(variance(a) * 1e1000) FROM num_variance;
- trim_scale
-------------
- 12
-(1 row)
-
+ERROR: failed to initialize shared_buffers to 16384
+CONTEXT: parallel worker
ROLLBACK;
-- case where sum of squares would overflow but variance does not
DELETE FROM num_variance;
@@ -3778,11 +3775,8 @@
SET LOCAL parallel_setup_cost = 0;
SET LOCAL max_parallel_workers_per_gather = 4;
... |
|
Linux - Debian Trixie - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/pg_buffercache/expected/pg_buffercache.out /tmp/cirrus-ci-build/contrib/pg_bufferc...
--- /tmp/cirrus-ci-build/contrib/pg_buffercache/expected/pg_buffercache.out 2026-01-28 13:50:04.112981165 +0000
+++ /tmp/cirrus-ci-build/contrib/pg_buffercache/results/pg_buffercache.out 2026-01-28 13:56:50.496479431 +0000
@@ -3,21 +3,13 @@
from pg_settings
where name = 'shared_buffers')
from pg_buffercache;
- ?column?
-----------
- t
-(1 row)
-
+ERROR: invalid input syntax for type bigint: "128MB"
-- For pg_buffercache_os_pages, we expect at least one entry for each buffer
select count(*) >= (select setting::bigint
from pg_settings
where name = 'shared_buffers')
from pg_buffercache_os_pages;
- ?column?
-----------
... |