Current commitfest | Next commitfest | FAQ | Statistics | Highlights
Highlight type: all assertion compiler core linker panic regress sanitizer tap test
Time range: current 7-day 30-day 90-day
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.
| 54/5829 | VCI (columnar store extension) |
| Linux - Debian Trixie - Meson | |
| regress | diff -U3 /tmp/cirrus-ci-build/contrib/vci/expected/vci.out /tmp/cirrus-ci-build/build/testrun/vci/regress/results/vci.ou... --- /tmp/cirrus-ci-build/contrib/vci/expected/vci.out 2026-01-13 01:30:27.197073887 +0000 +++ /tmp/cirrus-ci-build/build/testrun/vci/regress/results/vci.out 2026-01-13 01:37:45.812023947 +0000 @@ -88,41 +88,7 @@ INSERT INTO testtable (key, cond, c01a, c01b, c02, c03, c05, c06, c07, c08, c09, c10, c13, c15, c16, c17, c18, c19, c20... -- Create an index which uses VCI index access method CREATE INDEX testindex ON testtable USING vci (key, cond, c01a, c01b, c02, c03, c05, c06, c07, c08, c09, c10, c13, c15,... --- We expect VCI plans are chosen here -EXPLAIN (ANALYZE, TIMING OFF, COSTS OFF, SUMMARY OFF, BUFFERS OFF) -SELECT key, count(*) AS count_star, count(c05) AS count_c05 FROM testtable WHERE NOT cond = 0 GROUP BY key ORDER BY key... - QUERY PLAN ------------------------------------------------------------------------------------------------- - Sort (actual rows=14.00 loops=1) - Sort Key: key - Sort Method: quicksort Memory: 25kB - -> Custom Scan (VCI HashAggregate) (actual rows=14.00 loops=1) - Group Key: key - -> Custom Scan (VCI Scan) using testindex on testtable (actual rows=10221.00 loops=1) - Filter: (cond <> 0) - Rows Removed by Filter: 476 ... |
| 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-12 21:47:33.391553400 +0000
+++ C:/cirrus/build/testrun/pageinspect/regress/results/spgist.out 2026-01-12 21:56:30.744256500 +0000
@@ -5,40 +5,36 @@
CREATE INDEX test_spgist_idx ON test_gist USING spgist (p);
-- Page 0 is the root, the rest are leaf pages
SELECT * FROM spgist_page_opaque_info(get_raw_page('test_spgist_idx', 0));
- lsn | nplaceholder | nredirection | flags
-------------+--------------+--------------+--------
- 0/00000000 | 0 | 0 | {meta}
-(1 row)
-
+ERROR: function get_raw_page(unknown, integer) does not exist
+LINE 1: SELECT * FROM spgist_page_opaque_info(get_raw_page('test_spg...
+ ^
+DETAIL: There is no function of that name.
SELECT * FROM spgist_page_opaque_info(get_raw_page('test_spgist_idx', 1));
- lsn | nplaceholder | nredirection | flags
-------------+--------------+--------------+-------
- 0/00000000 | 0 | 0 | {}
... |
| Windows - Server 2022, VS 2019 - Meson & ninja | |
| regress | diff --strip-trailing-cr -U3 C:/cirrus/contrib/pageinspect/expected/spgist.out C:/cirrus/build/testrun/pageinspect/regre...
--- C:/cirrus/contrib/pageinspect/expected/spgist.out 2026-01-12 21:47:26.722277300 +0000
+++ C:/cirrus/build/testrun/pageinspect/regress/results/spgist.out 2026-01-12 21:55:40.279096200 +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-12 21:47:36
+++ /Users/admin/pgsql/build/testrun/pageinspect/regress/results/spgist.out 2026-01-12 21:53:18
@@ -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-12 21:47:31.736033752 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pageinspect/regress/results/spgist.out 2026-01-12 21:52:00.222659319 +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-12 21:47:53.680739070 +0000
+++ /home/postgres/postgres/build/testrun/pageinspect/regress/results/spgist.out 2026-01-12 21:50:35.994689328 +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 Mon Jan 12 21:47:33 2026
+++ /home/postgres/postgres/build/testrun/pageinspect/regress/results/spgist.out Mon Jan 12 21:52:18 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-12 21:47:25.134034000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pageinspect/regress/results/spgist.out 2026-01-12 21:50:39.375587000 +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/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-12 19:29:59.139149806 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pageinspect/regress/results/page.out 2026-01-12 19:36:25.404968959 +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/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-12 18:45:50.577963300 +0000
+++ C:/cirrus/build/testrun/citext/regress/results/create_index_acl.out 2026-01-12 18:54:51.990409100 +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-12 18:45:50.629492800 +0000
+++ C:/cirrus/build/testrun/dict_xsyn/regress/results/dict_xsyn.out 2026-01-12 18:54:56.355644800 +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-12 18:45:51.042222700 +0000
+++ C:/cirrus/build/testrun/postgres_fdw/regress/results/postgres_fdw.out 2026-01-12 18:55:24.443037900 +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-12 18:45:55.685928200 +0000 +++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/strings.out 2026-01-12 18:52:46.140368000 +0000 @@ -1869,53 +1869,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-12 18:45:55.685928200 +0000 +++ C:/cirrus/build/testrun/regress/regress/results/strings.out 2026-01-12 18:49:46.828423800 +0000 @@ -1869,53 +1869,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-12 18:45:55.279568400 +0000
+++ C:/cirrus/build/testrun/test_parser/regress/results/test_parser.out 2026-01-12 18:55:46.291171200 +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-12 18:46:05.607836200 +0000
+++ C:/cirrus/build/testrun/citext/regress/results/create_index_acl.out 2026-01-12 18:54:01.597908500 +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-12 18:46:05.659977800 +0000
+++ C:/cirrus/build/testrun/dict_xsyn/regress/results/dict_xsyn.out 2026-01-12 18:54:07.597408000 +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-12 18:46:06.110667600 +0000
+++ C:/cirrus/build/testrun/postgres_fdw/regress/results/postgres_fdw.out 2026-01-12 18:54:41.240966700 +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-12 18:46:10.860678100 +0000 +++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/strings.out 2026-01-12 18:51:48.548585500 +0000 @@ -1869,53 +1869,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-12 18:46:10.860678100 +0000 +++ C:/cirrus/build/testrun/regress/regress/results/strings.out 2026-01-12 18:48:41.222436900 +0000 @@ -1869,53 +1869,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-12 18:46:10.504405100 +0000
+++ C:/cirrus/build/testrun/test_parser/regress/results/test_parser.out 2026-01-12 18:54:59.775624000 +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-12 18:46:05.410682529 +0000
+++ /tmp/cirrus-ci-build/build-32/testrun/citext/regress/results/create_index_acl.out 2026-01-12 18:56:25.016768855 +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-12 18:46:05.418654040 +0000
+++ /tmp/cirrus-ci-build/build-32/testrun/dict_xsyn/regress/results/dict_xsyn.out 2026-01-12 18:56:28.232760072 +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-12 18:46:05.494383390 +0000
+++ /tmp/cirrus-ci-build/build-32/testrun/postgres_fdw/regress/results/postgres_fdw.out 2026-01-12 18:57:01.656662882 +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-12 18:46:07.284160706 +0000
+++ /tmp/cirrus-ci-build/build-32/testrun/recovery/027_stream_regress/data/results/tstypes.out 2026-01-12 18:55:39.73287...
@@ -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-12 18:46:07.284160706 +0000
+++ /tmp/cirrus-ci-build/build-32/testrun/regress/regress/results/tstypes.out 2026-01-12 18:54:15.268990836 +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-12 18:46:07.124695442 +0000
+++ /tmp/cirrus-ci-build/build-32/testrun/test_parser/regress/results/test_parser.out 2026-01-12 18:57:16.156617784 +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-12 18:46:10.585455907 +0000
+++ /home/postgres/postgres/build/testrun/citext/regress/results/create_index_acl.out 2026-01-12 18:48:59.308118474 +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-12 18:46:10.651710164 +0000
+++ /home/postgres/postgres/build/testrun/dict_xsyn/regress/results/dict_xsyn.out 2026-01-12 18:49:00.689933527 +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-12 18:46:11.286729287 +0000
+++ /home/postgres/postgres/build/testrun/postgres_fdw/regress/results/postgres_fdw.out 2026-01-12 18:49:13.773740383 +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-12 18:46:18.593820931 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/tstypes.out 2026-01-12 18:48:21.90497...
@@ -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-12 18:46:18.593820931 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/tstypes.out 2026-01-12 18:47:48.507482460 +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-12 18:46:17.964341199 +0000
+++ /home/postgres/postgres/build/testrun/test_parser/regress/results/test_parser.out 2026-01-12 18:49:18.280106546 +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/5985 | CREATE SCHEMA ... CREATE DOMAIN support |
| Windows - Server 2022, MinGW64 - Meson | |
| regress | diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/create_type.out C:/cirrus/build/testrun/recovery/027_st...
--- C:/cirrus/src/test/regress/expected/create_type.out 2026-01-12 04:54:07.059677800 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/create_type.out 2026-01-12 05:03:26.052533900 +0000
@@ -46,7 +46,7 @@
typmod_out = numerictypmodout,
alignment = double
);
-ERROR: CREATE TYPE specifies a schema (public) different from the one being created (regress_schema_1)
+ERROR: schema "regress_schema_1" already exists
CREATE TYPE widget (
internallength = 24,
input = widget_in, |
| 57/6252 | Proposal: Conflict log history table for Logical Replication |
| NetBSD - Meson | |
| regress | diff -U3 /home/postgres/postgres/src/test/isolation/expected/timeouts.out /home/postgres/postgres/build/testrun/isolatio... --- /home/postgres/postgres/src/test/isolation/expected/timeouts.out 2026-01-11 23:39:10.787090128 +0000 +++ /home/postgres/postgres/build/testrun/isolation/isolation/results/timeouts.out 2026-01-11 23:42:39.007019229 +0000 @@ -78,4 +78,4 @@ step slto: SET lock_timeout = '10s'; SET statement_timeout = '10ms'; step update: DELETE FROM accounts WHERE accountid = 'checking'; <waiting ...> step update: <... completed> -ERROR: canceling statement due to statement timeout +ERROR: canceling statement due to user request |
| 58/6372 | XSD schema validation |
| Windows - Server 2022, MinGW64 - Meson | |
| regress | diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/oidjoins.out C:/cirrus/build/testrun/pg_upgrade/002_pg_...
--- C:/cirrus/src/test/regress/expected/oidjoins.out 2026-01-11 16:51:02.367612000 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/oidjoins.out 2026-01-11 16:58:09.479914100 +0000
@@ -239,6 +239,8 @@
NOTICE: checking pg_shseclabel {classoid} => pg_class {oid}
NOTICE: checking pg_collation {collnamespace} => pg_namespace {oid}
NOTICE: checking pg_collation {collowner} => pg_authid {oid}
+NOTICE: checking pg_xmlschema {schemanamespace} => pg_namespace {oid}
+NOTICE: checking pg_xmlschema {schemaowner} => pg_authid {oid}
NOTICE: checking pg_partitioned_table {partrelid} => pg_class {oid}
NOTICE: checking pg_partitioned_table {partdefid} => pg_class {oid}
NOTICE: checking pg_partitioned_table {partclass} => pg_opclass {oid} |
| regress | diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/oidjoins.out C:/cirrus/build/testrun/recovery/027_strea...
--- C:/cirrus/src/test/regress/expected/oidjoins.out 2026-01-11 16:51:02.367612000 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/oidjoins.out 2026-01-11 17:01:11.807464300 +0000
@@ -239,6 +239,8 @@
NOTICE: checking pg_shseclabel {classoid} => pg_class {oid}
NOTICE: checking pg_collation {collnamespace} => pg_namespace {oid}
NOTICE: checking pg_collation {collowner} => pg_authid {oid}
+NOTICE: checking pg_xmlschema {schemanamespace} => pg_namespace {oid}
+NOTICE: checking pg_xmlschema {schemaowner} => pg_authid {oid}
NOTICE: checking pg_partitioned_table {partrelid} => pg_class {oid}
NOTICE: checking pg_partitioned_table {partdefid} => pg_class {oid}
NOTICE: checking pg_partitioned_table {partclass} => pg_opclass {oid} |
| regress | diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/oidjoins.out C:/cirrus/build/testrun/regress/regress/re...
--- C:/cirrus/src/test/regress/expected/oidjoins.out 2026-01-11 16:51:02.367612000 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/oidjoins.out 2026-01-11 16:58:02.958934400 +0000
@@ -239,6 +239,8 @@
NOTICE: checking pg_shseclabel {classoid} => pg_class {oid}
NOTICE: checking pg_collation {collnamespace} => pg_namespace {oid}
NOTICE: checking pg_collation {collowner} => pg_authid {oid}
+NOTICE: checking pg_xmlschema {schemanamespace} => pg_namespace {oid}
+NOTICE: checking pg_xmlschema {schemaowner} => pg_authid {oid}
NOTICE: checking pg_partitioned_table {partrelid} => pg_class {oid}
NOTICE: checking pg_partitioned_table {partdefid} => pg_class {oid}
NOTICE: checking pg_partitioned_table {partclass} => pg_opclass {oid} |
| 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-11 16:51:09.410521500 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/xml.out 2026-01-11 16:55:37.350618000 +0000
@@ -1496,3 +1496,272 @@
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: xmlschema support requires libxml
+CREATE XMLSCHEMA IF NOT EXISTS 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-11 16:51:09.410521500 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/xml.out 2026-01-11 16:58:47.696786000 +0000
@@ -1496,3 +1496,272 @@
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: xmlschema support requires libxml
+CREATE XMLSCHEMA IF NOT EXISTS 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-11 16:51:09.410521500 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/xml.out 2026-01-11 16:55:29.025907300 +0000
@@ -1496,3 +1496,272 @@
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: xmlschema support requires libxml
+CREATE XMLSCHEMA IF NOT EXISTS person_schema AS '<?xml version="1.0"?>
... |
| macOS - Sequoia - Meson | |
| regress | diff -U3 /Users/admin/pgsql/src/test/regress/expected/oidjoins.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_up...
--- /Users/admin/pgsql/src/test/regress/expected/oidjoins.out 2026-01-11 16:58:27
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/oidjoins.out 2026-01-11 17:03:47
@@ -239,6 +239,8 @@
NOTICE: checking pg_shseclabel {classoid} => pg_class {oid}
NOTICE: checking pg_collation {collnamespace} => pg_namespace {oid}
NOTICE: checking pg_collation {collowner} => pg_authid {oid}
+NOTICE: checking pg_xmlschema {schemanamespace} => pg_namespace {oid}
+NOTICE: checking pg_xmlschema {schemaowner} => pg_authid {oid}
NOTICE: checking pg_partitioned_table {partrelid} => pg_class {oid}
NOTICE: checking pg_partitioned_table {partdefid} => pg_class {oid}
NOTICE: checking pg_partitioned_table {partclass} => pg_opclass {oid} |
| regress | diff -U3 /Users/admin/pgsql/src/test/regress/expected/oidjoins.out /Users/admin/pgsql/build/testrun/recovery/027_stream_...
--- /Users/admin/pgsql/src/test/regress/expected/oidjoins.out 2026-01-11 16:58:27
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/oidjoins.out 2026-01-11 17:06:06
@@ -239,6 +239,8 @@
NOTICE: checking pg_shseclabel {classoid} => pg_class {oid}
NOTICE: checking pg_collation {collnamespace} => pg_namespace {oid}
NOTICE: checking pg_collation {collowner} => pg_authid {oid}
+NOTICE: checking pg_xmlschema {schemanamespace} => pg_namespace {oid}
+NOTICE: checking pg_xmlschema {schemaowner} => pg_authid {oid}
NOTICE: checking pg_partitioned_table {partrelid} => pg_class {oid}
NOTICE: checking pg_partitioned_table {partdefid} => pg_class {oid}
NOTICE: checking pg_partitioned_table {partclass} => pg_opclass {oid} |
| regress | diff -U3 /Users/admin/pgsql/src/test/regress/expected/oidjoins.out /Users/admin/pgsql/build/testrun/regress/regress/resu...
--- /Users/admin/pgsql/src/test/regress/expected/oidjoins.out 2026-01-11 16:58:27
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/oidjoins.out 2026-01-11 17:03:47
@@ -239,6 +239,8 @@
NOTICE: checking pg_shseclabel {classoid} => pg_class {oid}
NOTICE: checking pg_collation {collnamespace} => pg_namespace {oid}
NOTICE: checking pg_collation {collowner} => pg_authid {oid}
+NOTICE: checking pg_xmlschema {schemanamespace} => pg_namespace {oid}
+NOTICE: checking pg_xmlschema {schemaowner} => pg_authid {oid}
NOTICE: checking pg_partitioned_table {partrelid} => pg_class {oid}
NOTICE: checking pg_partitioned_table {partdefid} => pg_class {oid}
NOTICE: checking pg_partitioned_table {partclass} => pg_opclass {oid} |
| Linux - Debian Trixie - Meson | |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/oidjoins.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_p...
--- /tmp/cirrus-ci-build/src/test/regress/expected/oidjoins.out 2026-01-11 16:50:59.189655651 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/oidjoins.out 2026-01-11 16:56:05.679613072...
@@ -239,6 +239,8 @@
NOTICE: checking pg_shseclabel {classoid} => pg_class {oid}
NOTICE: checking pg_collation {collnamespace} => pg_namespace {oid}
NOTICE: checking pg_collation {collowner} => pg_authid {oid}
+NOTICE: checking pg_xmlschema {schemanamespace} => pg_namespace {oid}
+NOTICE: checking pg_xmlschema {schemaowner} => pg_authid {oid}
NOTICE: checking pg_partitioned_table {partrelid} => pg_class {oid}
NOTICE: checking pg_partitioned_table {partdefid} => pg_class {oid}
NOTICE: checking pg_partitioned_table {partclass} => pg_opclass {oid} |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/oidjoins.out /tmp/cirrus-ci-build/build/testrun/recovery/027_str...
--- /tmp/cirrus-ci-build/src/test/regress/expected/oidjoins.out 2026-01-11 16:50:59.189655651 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/oidjoins.out 2026-01-11 16:57:30.4456042...
@@ -239,6 +239,8 @@
NOTICE: checking pg_shseclabel {classoid} => pg_class {oid}
NOTICE: checking pg_collation {collnamespace} => pg_namespace {oid}
NOTICE: checking pg_collation {collowner} => pg_authid {oid}
+NOTICE: checking pg_xmlschema {schemanamespace} => pg_namespace {oid}
+NOTICE: checking pg_xmlschema {schemaowner} => pg_authid {oid}
NOTICE: checking pg_partitioned_table {partrelid} => pg_class {oid}
NOTICE: checking pg_partitioned_table {partdefid} => pg_class {oid}
NOTICE: checking pg_partitioned_table {partclass} => pg_opclass {oid} |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/oidjoins.out /tmp/cirrus-ci-build/build/testrun/regress/regress/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/oidjoins.out 2026-01-11 16:50:59.189655651 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/oidjoins.out 2026-01-11 16:56:04.755587854 +0000
@@ -239,6 +239,8 @@
NOTICE: checking pg_shseclabel {classoid} => pg_class {oid}
NOTICE: checking pg_collation {collnamespace} => pg_namespace {oid}
NOTICE: checking pg_collation {collowner} => pg_authid {oid}
+NOTICE: checking pg_xmlschema {schemanamespace} => pg_namespace {oid}
+NOTICE: checking pg_xmlschema {schemaowner} => pg_authid {oid}
NOTICE: checking pg_partitioned_table {partrelid} => pg_class {oid}
NOTICE: checking pg_partitioned_table {partdefid} => pg_class {oid}
NOTICE: checking pg_partitioned_table {partclass} => pg_opclass {oid} |
| NetBSD - Meson | |
| regress | diff -U3 /home/postgres/postgres/src/test/regress/expected/oidjoins.out /home/postgres/postgres/build/testrun/pg_upgrade...
--- /home/postgres/postgres/src/test/regress/expected/oidjoins.out 2026-01-11 16:51:12.361301693 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/oidjoins.out 2026-01-11 16:55:06.985583...
@@ -239,6 +239,8 @@
NOTICE: checking pg_shseclabel {classoid} => pg_class {oid}
NOTICE: checking pg_collation {collnamespace} => pg_namespace {oid}
NOTICE: checking pg_collation {collowner} => pg_authid {oid}
+NOTICE: checking pg_xmlschema {schemanamespace} => pg_namespace {oid}
+NOTICE: checking pg_xmlschema {schemaowner} => pg_authid {oid}
NOTICE: checking pg_partitioned_table {partrelid} => pg_class {oid}
NOTICE: checking pg_partitioned_table {partdefid} => pg_class {oid}
NOTICE: checking pg_partitioned_table {partclass} => pg_opclass {oid} |
| regress | diff -U3 /home/postgres/postgres/src/test/regress/expected/oidjoins.out /home/postgres/postgres/build/testrun/recovery/0...
--- /home/postgres/postgres/src/test/regress/expected/oidjoins.out 2026-01-11 16:51:12.361301693 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/oidjoins.out 2026-01-11 16:55:53.2097...
@@ -239,6 +239,8 @@
NOTICE: checking pg_shseclabel {classoid} => pg_class {oid}
NOTICE: checking pg_collation {collnamespace} => pg_namespace {oid}
NOTICE: checking pg_collation {collowner} => pg_authid {oid}
+NOTICE: checking pg_xmlschema {schemanamespace} => pg_namespace {oid}
+NOTICE: checking pg_xmlschema {schemaowner} => pg_authid {oid}
NOTICE: checking pg_partitioned_table {partrelid} => pg_class {oid}
NOTICE: checking pg_partitioned_table {partdefid} => pg_class {oid}
NOTICE: checking pg_partitioned_table {partclass} => pg_opclass {oid} |
| regress | diff -U3 /home/postgres/postgres/src/test/regress/expected/oidjoins.out /home/postgres/postgres/build/testrun/regress/re...
--- /home/postgres/postgres/src/test/regress/expected/oidjoins.out 2026-01-11 16:51:12.361301693 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/oidjoins.out 2026-01-11 16:55:07.341298680 +0000
@@ -239,6 +239,8 @@
NOTICE: checking pg_shseclabel {classoid} => pg_class {oid}
NOTICE: checking pg_collation {collnamespace} => pg_namespace {oid}
NOTICE: checking pg_collation {collowner} => pg_authid {oid}
+NOTICE: checking pg_xmlschema {schemanamespace} => pg_namespace {oid}
+NOTICE: checking pg_xmlschema {schemaowner} => pg_authid {oid}
NOTICE: checking pg_partitioned_table {partrelid} => pg_class {oid}
NOTICE: checking pg_partitioned_table {partdefid} => pg_class {oid}
NOTICE: checking pg_partitioned_table {partclass} => pg_opclass {oid} |
| OpenBSD - Meson | |
| regress | diff -U3 /home/postgres/postgres/src/test/regress/expected/oidjoins.out /home/postgres/postgres/build/testrun/pg_upgrade...
--- /home/postgres/postgres/src/test/regress/expected/oidjoins.out Sun Jan 11 16:51:29 2026
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/oidjoins.out Sun Jan 11 16:56:30 2026
@@ -239,6 +239,8 @@
NOTICE: checking pg_shseclabel {classoid} => pg_class {oid}
NOTICE: checking pg_collation {collnamespace} => pg_namespace {oid}
NOTICE: checking pg_collation {collowner} => pg_authid {oid}
+NOTICE: checking pg_xmlschema {schemanamespace} => pg_namespace {oid}
+NOTICE: checking pg_xmlschema {schemaowner} => pg_authid {oid}
NOTICE: checking pg_partitioned_table {partrelid} => pg_class {oid}
NOTICE: checking pg_partitioned_table {partdefid} => pg_class {oid}
NOTICE: checking pg_partitioned_table {partclass} => pg_opclass {oid} |
| regress | diff -U3 /home/postgres/postgres/src/test/regress/expected/oidjoins.out /home/postgres/postgres/build/testrun/recovery/0...
--- /home/postgres/postgres/src/test/regress/expected/oidjoins.out Sun Jan 11 16:51:29 2026
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/oidjoins.out Sun Jan 11 16:58:58 2026
@@ -239,6 +239,8 @@
NOTICE: checking pg_shseclabel {classoid} => pg_class {oid}
NOTICE: checking pg_collation {collnamespace} => pg_namespace {oid}
NOTICE: checking pg_collation {collowner} => pg_authid {oid}
+NOTICE: checking pg_xmlschema {schemanamespace} => pg_namespace {oid}
+NOTICE: checking pg_xmlschema {schemaowner} => pg_authid {oid}
NOTICE: checking pg_partitioned_table {partrelid} => pg_class {oid}
NOTICE: checking pg_partitioned_table {partdefid} => pg_class {oid}
NOTICE: checking pg_partitioned_table {partclass} => pg_opclass {oid} |
| regress | diff -U3 /home/postgres/postgres/src/test/regress/expected/oidjoins.out /home/postgres/postgres/build/testrun/regress/re...
--- /home/postgres/postgres/src/test/regress/expected/oidjoins.out Sun Jan 11 16:51:29 2026
+++ /home/postgres/postgres/build/testrun/regress/regress/results/oidjoins.out Sun Jan 11 16:56:26 2026
@@ -239,6 +239,8 @@
NOTICE: checking pg_shseclabel {classoid} => pg_class {oid}
NOTICE: checking pg_collation {collnamespace} => pg_namespace {oid}
NOTICE: checking pg_collation {collowner} => pg_authid {oid}
+NOTICE: checking pg_xmlschema {schemanamespace} => pg_namespace {oid}
+NOTICE: checking pg_xmlschema {schemaowner} => pg_authid {oid}
NOTICE: checking pg_partitioned_table {partrelid} => pg_class {oid}
NOTICE: checking pg_partitioned_table {partdefid} => pg_class {oid}
NOTICE: checking pg_partitioned_table {partclass} => pg_opclass {oid} |
| FreeBSD - Meson | |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/xml.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upg... --- /tmp/cirrus-ci-build/src/test/regress/expected/xml.out 2026-01-11 16:50:59.109285000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/xml.out 2026-01-11 16:55:53.833009000 +000... @@ -2051,6 +2051,7 @@ (1 row) CREATE ROLE xmlschema_test_role; +WARNING: roles created by regression test cases should have names starting with "regress_" ALTER XMLSCHEMA test_xmlschema_ns.library_book_schema OWNER TO xmlschema_test_role; SELECT schemaname, schemanamespace::regnamespace, schemaowner::regrole FROM pg_xmlschema @@ -2099,7 +2100,9 @@ owner of XML schema public.should_fail_schema DROP SCHEMA test_xmlschema_ns CASCADE; CREATE ROLE xmlschema_user1; +WARNING: roles created by regression test cases should have names starting with "regress_" CREATE ROLE xmlschema_user2; +WARNING: roles created by regression test cases should have names starting with "regress_" CREATE XMLSCHEMA permission_test_schema AS '<?xml version="1.0"?> <xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema"> ... |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/xml.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_r... --- /tmp/cirrus-ci-build/src/test/regress/expected/xml.out 2026-01-11 16:50:59.109285000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/xml.out 2026-01-11 16:57:12.769590000 +0... @@ -2051,6 +2051,7 @@ (1 row) CREATE ROLE xmlschema_test_role; +WARNING: roles created by regression test cases should have names starting with "regress_" ALTER XMLSCHEMA test_xmlschema_ns.library_book_schema OWNER TO xmlschema_test_role; SELECT schemaname, schemanamespace::regnamespace, schemaowner::regrole FROM pg_xmlschema @@ -2099,7 +2100,9 @@ owner of XML schema public.should_fail_schema DROP SCHEMA test_xmlschema_ns CASCADE; CREATE ROLE xmlschema_user1; +WARNING: roles created by regression test cases should have names starting with "regress_" CREATE ROLE xmlschema_user2; +WARNING: roles created by regression test cases should have names starting with "regress_" CREATE XMLSCHEMA permission_test_schema AS '<?xml version="1.0"?> <xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema"> ... |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/xml.out /tmp/cirrus-ci-build/build/testrun/regress/regress/resul... --- /tmp/cirrus-ci-build/src/test/regress/expected/xml.out 2026-01-11 16:50:59.109285000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/xml.out 2026-01-11 16:55:52.098260000 +0000 @@ -2051,6 +2051,7 @@ (1 row) CREATE ROLE xmlschema_test_role; +WARNING: roles created by regression test cases should have names starting with "regress_" ALTER XMLSCHEMA test_xmlschema_ns.library_book_schema OWNER TO xmlschema_test_role; SELECT schemaname, schemanamespace::regnamespace, schemaowner::regrole FROM pg_xmlschema @@ -2099,7 +2100,9 @@ owner of XML schema public.should_fail_schema DROP SCHEMA test_xmlschema_ns CASCADE; CREATE ROLE xmlschema_user1; +WARNING: roles created by regression test cases should have names starting with "regress_" CREATE ROLE xmlschema_user2; +WARNING: roles created by regression test cases should have names starting with "regress_" CREATE XMLSCHEMA permission_test_schema AS '<?xml version="1.0"?> <xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema"> ... |
| 58/6371 | Allowing ALTER COLUMN TYPE for columns in publication column lists |
| Windows - Server 2022, MinGW64 - Meson | |
| regress | diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/publication.out C:/cirrus/build/testrun/pg_upgrade/002_... --- C:/cirrus/src/test/regress/expected/publication.out 2026-01-10 16:22:48.951729700 +0000 +++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/publication.out 2026-01-10 16:29:41.450595300 +0000 @@ -629,8 +629,6 @@ -- test that ALTER COLUMN ALTER [ SET DATA ] TYPE is rejected when the column is in a row filter CREATE TABLE testpub_rf_tbl8 (id int PRIMARY KEY, x int, y int, z int); CREATE PUBLICATION testpub9 FOR TABLE testpub_rf_tbl8 WHERE (x > 100 AND y < 200); -WARNING: "wal_level" is insufficient to publish logical changes -HINT: Set "wal_level" to "logical" before creating subscriptions. SET client_min_messages = 'ERROR'; -- fail ALTER TABLE testpub_rf_tbl8 ALTER COLUMN x TYPE bigint; |
| regress | diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/publication.out C:/cirrus/build/testrun/recovery/027_st... --- C:/cirrus/src/test/regress/expected/publication.out 2026-01-10 16:22:48.951729700 +0000 +++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/publication.out 2026-01-10 16:32:56.137996800 +0000 @@ -629,8 +629,6 @@ -- test that ALTER COLUMN ALTER [ SET DATA ] TYPE is rejected when the column is in a row filter CREATE TABLE testpub_rf_tbl8 (id int PRIMARY KEY, x int, y int, z int); CREATE PUBLICATION testpub9 FOR TABLE testpub_rf_tbl8 WHERE (x > 100 AND y < 200); -WARNING: "wal_level" is insufficient to publish logical changes -HINT: Set "wal_level" to "logical" before creating subscriptions. SET client_min_messages = 'ERROR'; -- fail ALTER TABLE testpub_rf_tbl8 ALTER COLUMN x TYPE bigint; |
| regress | diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/publication.out C:/cirrus/build/testrun/regress/regress... --- C:/cirrus/src/test/regress/expected/publication.out 2026-01-10 16:22:48.951729700 +0000 +++ C:/cirrus/build/testrun/regress/regress/results/publication.out 2026-01-10 16:29:37.377810100 +0000 @@ -629,8 +629,6 @@ -- test that ALTER COLUMN ALTER [ SET DATA ] TYPE is rejected when the column is in a row filter CREATE TABLE testpub_rf_tbl8 (id int PRIMARY KEY, x int, y int, z int); CREATE PUBLICATION testpub9 FOR TABLE testpub_rf_tbl8 WHERE (x > 100 AND y < 200); -WARNING: "wal_level" is insufficient to publish logical changes -HINT: Set "wal_level" to "logical" before creating subscriptions. SET client_min_messages = 'ERROR'; -- fail ALTER TABLE testpub_rf_tbl8 ALTER COLUMN x TYPE bigint; |
| Linux - Debian Trixie - Meson | |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/publication.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/00... --- /tmp/cirrus-ci-build/src/test/regress/expected/publication.out 2026-01-10 16:22:50.130900806 +0000 +++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/publication.out 2026-01-10 16:27:00.750500... @@ -629,8 +629,6 @@ -- test that ALTER COLUMN ALTER [ SET DATA ] TYPE is rejected when the column is in a row filter CREATE TABLE testpub_rf_tbl8 (id int PRIMARY KEY, x int, y int, z int); CREATE PUBLICATION testpub9 FOR TABLE testpub_rf_tbl8 WHERE (x > 100 AND y < 200); -WARNING: "wal_level" is insufficient to publish logical changes -HINT: Set "wal_level" to "logical" before creating subscriptions. SET client_min_messages = 'ERROR'; -- fail ALTER TABLE testpub_rf_tbl8 ALTER COLUMN x TYPE bigint; |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/publication.out /tmp/cirrus-ci-build/build/testrun/recovery/027_... --- /tmp/cirrus-ci-build/src/test/regress/expected/publication.out 2026-01-10 16:22:50.130900806 +0000 +++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/publication.out 2026-01-10 16:28:29.9714... @@ -629,8 +629,6 @@ -- test that ALTER COLUMN ALTER [ SET DATA ] TYPE is rejected when the column is in a row filter CREATE TABLE testpub_rf_tbl8 (id int PRIMARY KEY, x int, y int, z int); CREATE PUBLICATION testpub9 FOR TABLE testpub_rf_tbl8 WHERE (x > 100 AND y < 200); -WARNING: "wal_level" is insufficient to publish logical changes -HINT: Set "wal_level" to "logical" before creating subscriptions. SET client_min_messages = 'ERROR'; -- fail ALTER TABLE testpub_rf_tbl8 ALTER COLUMN x TYPE bigint; |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/publication.out /tmp/cirrus-ci-build/build/testrun/regress/regre... --- /tmp/cirrus-ci-build/src/test/regress/expected/publication.out 2026-01-10 16:22:50.130900806 +0000 +++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/publication.out 2026-01-10 16:27:03.386537777 +0000 @@ -629,8 +629,6 @@ -- test that ALTER COLUMN ALTER [ SET DATA ] TYPE is rejected when the column is in a row filter CREATE TABLE testpub_rf_tbl8 (id int PRIMARY KEY, x int, y int, z int); CREATE PUBLICATION testpub9 FOR TABLE testpub_rf_tbl8 WHERE (x > 100 AND y < 200); -WARNING: "wal_level" is insufficient to publish logical changes -HINT: Set "wal_level" to "logical" before creating subscriptions. SET client_min_messages = 'ERROR'; -- fail ALTER TABLE testpub_rf_tbl8 ALTER COLUMN x TYPE bigint; |
| macOS - Sequoia - Meson | |
| regress | diff -U3 /Users/admin/pgsql/src/test/regress/expected/publication.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg... --- /Users/admin/pgsql/src/test/regress/expected/publication.out 2026-01-10 16:23:02 +++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/publication.out 2026-01-10 16:27:35 @@ -629,8 +629,6 @@ -- test that ALTER COLUMN ALTER [ SET DATA ] TYPE is rejected when the column is in a row filter CREATE TABLE testpub_rf_tbl8 (id int PRIMARY KEY, x int, y int, z int); CREATE PUBLICATION testpub9 FOR TABLE testpub_rf_tbl8 WHERE (x > 100 AND y < 200); -WARNING: "wal_level" is insufficient to publish logical changes -HINT: Set "wal_level" to "logical" before creating subscriptions. SET client_min_messages = 'ERROR'; -- fail ALTER TABLE testpub_rf_tbl8 ALTER COLUMN x TYPE bigint; |
| regress | diff -U3 /Users/admin/pgsql/src/test/regress/expected/publication.out /Users/admin/pgsql/build/testrun/recovery/027_stre... --- /Users/admin/pgsql/src/test/regress/expected/publication.out 2026-01-10 16:23:02 +++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/publication.out 2026-01-10 16:29:21 @@ -629,8 +629,6 @@ -- test that ALTER COLUMN ALTER [ SET DATA ] TYPE is rejected when the column is in a row filter CREATE TABLE testpub_rf_tbl8 (id int PRIMARY KEY, x int, y int, z int); CREATE PUBLICATION testpub9 FOR TABLE testpub_rf_tbl8 WHERE (x > 100 AND y < 200); -WARNING: "wal_level" is insufficient to publish logical changes -HINT: Set "wal_level" to "logical" before creating subscriptions. SET client_min_messages = 'ERROR'; -- fail ALTER TABLE testpub_rf_tbl8 ALTER COLUMN x TYPE bigint; |
| regress | diff -U3 /Users/admin/pgsql/src/test/regress/expected/publication.out /Users/admin/pgsql/build/testrun/regress/regress/r... --- /Users/admin/pgsql/src/test/regress/expected/publication.out 2026-01-10 16:23:02 +++ /Users/admin/pgsql/build/testrun/regress/regress/results/publication.out 2026-01-10 16:27:35 @@ -629,8 +629,6 @@ -- test that ALTER COLUMN ALTER [ SET DATA ] TYPE is rejected when the column is in a row filter CREATE TABLE testpub_rf_tbl8 (id int PRIMARY KEY, x int, y int, z int); CREATE PUBLICATION testpub9 FOR TABLE testpub_rf_tbl8 WHERE (x > 100 AND y < 200); -WARNING: "wal_level" is insufficient to publish logical changes -HINT: Set "wal_level" to "logical" before creating subscriptions. SET client_min_messages = 'ERROR'; -- fail ALTER TABLE testpub_rf_tbl8 ALTER COLUMN x TYPE bigint; |
| Windows - Server 2022, VS 2019 - Meson & ninja | |
| regress | diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/publication.out C:/cirrus/build/testrun/pg_upgrade/002_... --- C:/cirrus/src/test/regress/expected/publication.out 2026-01-10 16:23:01.709510400 +0000 +++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/publication.out 2026-01-10 16:27:27.300808500 +0000 @@ -629,8 +629,6 @@ -- test that ALTER COLUMN ALTER [ SET DATA ] TYPE is rejected when the column is in a row filter CREATE TABLE testpub_rf_tbl8 (id int PRIMARY KEY, x int, y int, z int); CREATE PUBLICATION testpub9 FOR TABLE testpub_rf_tbl8 WHERE (x > 100 AND y < 200); -WARNING: "wal_level" is insufficient to publish logical changes -HINT: Set "wal_level" to "logical" before creating subscriptions. SET client_min_messages = 'ERROR'; -- fail ALTER TABLE testpub_rf_tbl8 ALTER COLUMN x TYPE bigint; |
| regress | diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/publication.out C:/cirrus/build/testrun/recovery/027_st... --- C:/cirrus/src/test/regress/expected/publication.out 2026-01-10 16:23:01.709510400 +0000 +++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/publication.out 2026-01-10 16:30:45.534614700 +0000 @@ -629,8 +629,6 @@ -- test that ALTER COLUMN ALTER [ SET DATA ] TYPE is rejected when the column is in a row filter CREATE TABLE testpub_rf_tbl8 (id int PRIMARY KEY, x int, y int, z int); CREATE PUBLICATION testpub9 FOR TABLE testpub_rf_tbl8 WHERE (x > 100 AND y < 200); -WARNING: "wal_level" is insufficient to publish logical changes -HINT: Set "wal_level" to "logical" before creating subscriptions. SET client_min_messages = 'ERROR'; -- fail ALTER TABLE testpub_rf_tbl8 ALTER COLUMN x TYPE bigint; |
| regress | diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/publication.out C:/cirrus/build/testrun/regress/regress... --- C:/cirrus/src/test/regress/expected/publication.out 2026-01-10 16:23:01.709510400 +0000 +++ C:/cirrus/build/testrun/regress/regress/results/publication.out 2026-01-10 16:27:18.294463900 +0000 @@ -629,8 +629,6 @@ -- test that ALTER COLUMN ALTER [ SET DATA ] TYPE is rejected when the column is in a row filter CREATE TABLE testpub_rf_tbl8 (id int PRIMARY KEY, x int, y int, z int); CREATE PUBLICATION testpub9 FOR TABLE testpub_rf_tbl8 WHERE (x > 100 AND y < 200); -WARNING: "wal_level" is insufficient to publish logical changes -HINT: Set "wal_level" to "logical" before creating subscriptions. SET client_min_messages = 'ERROR'; -- fail ALTER TABLE testpub_rf_tbl8 ALTER COLUMN x TYPE bigint; |
| OpenBSD - Meson | |
| regress | diff -U3 /home/postgres/postgres/src/test/regress/expected/publication.out /home/postgres/postgres/build/testrun/pg_upgr... --- /home/postgres/postgres/src/test/regress/expected/publication.out Sat Jan 10 16:23:07 2026 +++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/publication.out Sat Jan 10 16:26:52 202... @@ -629,8 +629,6 @@ -- test that ALTER COLUMN ALTER [ SET DATA ] TYPE is rejected when the column is in a row filter CREATE TABLE testpub_rf_tbl8 (id int PRIMARY KEY, x int, y int, z int); CREATE PUBLICATION testpub9 FOR TABLE testpub_rf_tbl8 WHERE (x > 100 AND y < 200); -WARNING: "wal_level" is insufficient to publish logical changes -HINT: Set "wal_level" to "logical" before creating subscriptions. SET client_min_messages = 'ERROR'; -- fail ALTER TABLE testpub_rf_tbl8 ALTER COLUMN x TYPE bigint; |
| regress | diff -U3 /home/postgres/postgres/src/test/regress/expected/publication.out /home/postgres/postgres/build/testrun/recover... --- /home/postgres/postgres/src/test/regress/expected/publication.out Sat Jan 10 16:23:07 2026 +++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/publication.out Sat Jan 10 16:29:13 2... @@ -629,8 +629,6 @@ -- test that ALTER COLUMN ALTER [ SET DATA ] TYPE is rejected when the column is in a row filter CREATE TABLE testpub_rf_tbl8 (id int PRIMARY KEY, x int, y int, z int); CREATE PUBLICATION testpub9 FOR TABLE testpub_rf_tbl8 WHERE (x > 100 AND y < 200); -WARNING: "wal_level" is insufficient to publish logical changes -HINT: Set "wal_level" to "logical" before creating subscriptions. SET client_min_messages = 'ERROR'; -- fail ALTER TABLE testpub_rf_tbl8 ALTER COLUMN x TYPE bigint; |
| regress | diff -U3 /home/postgres/postgres/src/test/regress/expected/publication.out /home/postgres/postgres/build/testrun/regress... --- /home/postgres/postgres/src/test/regress/expected/publication.out Sat Jan 10 16:23:07 2026 +++ /home/postgres/postgres/build/testrun/regress/regress/results/publication.out Sat Jan 10 16:26:47 2026 @@ -629,8 +629,6 @@ -- test that ALTER COLUMN ALTER [ SET DATA ] TYPE is rejected when the column is in a row filter CREATE TABLE testpub_rf_tbl8 (id int PRIMARY KEY, x int, y int, z int); CREATE PUBLICATION testpub9 FOR TABLE testpub_rf_tbl8 WHERE (x > 100 AND y < 200); -WARNING: "wal_level" is insufficient to publish logical changes -HINT: Set "wal_level" to "logical" before creating subscriptions. SET client_min_messages = 'ERROR'; -- fail ALTER TABLE testpub_rf_tbl8 ALTER COLUMN x TYPE bigint; |
| NetBSD - Meson | |
| regress | diff -U3 /home/postgres/postgres/src/test/regress/expected/publication.out /home/postgres/postgres/build/testrun/pg_upgr... --- /home/postgres/postgres/src/test/regress/expected/publication.out 2026-01-10 16:23:07.323715539 +0000 +++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/publication.out 2026-01-10 16:26:04.113... @@ -629,8 +629,6 @@ -- test that ALTER COLUMN ALTER [ SET DATA ] TYPE is rejected when the column is in a row filter CREATE TABLE testpub_rf_tbl8 (id int PRIMARY KEY, x int, y int, z int); CREATE PUBLICATION testpub9 FOR TABLE testpub_rf_tbl8 WHERE (x > 100 AND y < 200); -WARNING: "wal_level" is insufficient to publish logical changes -HINT: Set "wal_level" to "logical" before creating subscriptions. SET client_min_messages = 'ERROR'; -- fail ALTER TABLE testpub_rf_tbl8 ALTER COLUMN x TYPE bigint; |
| regress | diff -U3 /home/postgres/postgres/src/test/regress/expected/publication.out /home/postgres/postgres/build/testrun/recover... --- /home/postgres/postgres/src/test/regress/expected/publication.out 2026-01-10 16:23:07.323715539 +0000 +++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/publication.out 2026-01-10 16:27:01.1... @@ -629,8 +629,6 @@ -- test that ALTER COLUMN ALTER [ SET DATA ] TYPE is rejected when the column is in a row filter CREATE TABLE testpub_rf_tbl8 (id int PRIMARY KEY, x int, y int, z int); CREATE PUBLICATION testpub9 FOR TABLE testpub_rf_tbl8 WHERE (x > 100 AND y < 200); -WARNING: "wal_level" is insufficient to publish logical changes -HINT: Set "wal_level" to "logical" before creating subscriptions. SET client_min_messages = 'ERROR'; -- fail ALTER TABLE testpub_rf_tbl8 ALTER COLUMN x TYPE bigint; |
| regress | diff -U3 /home/postgres/postgres/src/test/regress/expected/publication.out /home/postgres/postgres/build/testrun/regress... --- /home/postgres/postgres/src/test/regress/expected/publication.out 2026-01-10 16:23:07.323715539 +0000 +++ /home/postgres/postgres/build/testrun/regress/regress/results/publication.out 2026-01-10 16:26:04.108547758 +0000 @@ -629,8 +629,6 @@ -- test that ALTER COLUMN ALTER [ SET DATA ] TYPE is rejected when the column is in a row filter CREATE TABLE testpub_rf_tbl8 (id int PRIMARY KEY, x int, y int, z int); CREATE PUBLICATION testpub9 FOR TABLE testpub_rf_tbl8 WHERE (x > 100 AND y < 200); -WARNING: "wal_level" is insufficient to publish logical changes -HINT: Set "wal_level" to "logical" before creating subscriptions. SET client_min_messages = 'ERROR'; -- fail ALTER TABLE testpub_rf_tbl8 ALTER COLUMN x TYPE bigint; |
| Linux - Debian Trixie - Autoconf | |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/publication.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_chec... --- /tmp/cirrus-ci-build/src/test/regress/expected/publication.out 2026-01-10 16:22:46.823670277 +0000 +++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/publication.out 2026-01-10 16:30:46.076371724 +0000 @@ -629,8 +629,6 @@ -- test that ALTER COLUMN ALTER [ SET DATA ] TYPE is rejected when the column is in a row filter CREATE TABLE testpub_rf_tbl8 (id int PRIMARY KEY, x int, y int, z int); CREATE PUBLICATION testpub9 FOR TABLE testpub_rf_tbl8 WHERE (x > 100 AND y < 200); -WARNING: "wal_level" is insufficient to publish logical changes -HINT: Set "wal_level" to "logical" before creating subscriptions. SET client_min_messages = 'ERROR'; -- fail ALTER TABLE testpub_rf_tbl8 ALTER COLUMN x TYPE bigint; |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/publication.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check... --- /tmp/cirrus-ci-build/src/test/regress/expected/publication.out 2026-01-10 16:22:46.823670277 +0000 +++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/publication.out 2026-01-10 16:31:54.431910673 +0000 @@ -629,8 +629,6 @@ -- test that ALTER COLUMN ALTER [ SET DATA ] TYPE is rejected when the column is in a row filter CREATE TABLE testpub_rf_tbl8 (id int PRIMARY KEY, x int, y int, z int); CREATE PUBLICATION testpub9 FOR TABLE testpub_rf_tbl8 WHERE (x > 100 AND y < 200); -WARNING: "wal_level" is insufficient to publish logical changes -HINT: Set "wal_level" to "logical" before creating subscriptions. SET client_min_messages = 'ERROR'; -- fail ALTER TABLE testpub_rf_tbl8 ALTER COLUMN x TYPE bigint; |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/publication.out /tmp/cirrus-ci-build/src/test/regress/results/pu... --- /tmp/cirrus-ci-build/src/test/regress/expected/publication.out 2026-01-10 16:22:46.823670277 +0000 +++ /tmp/cirrus-ci-build/src/test/regress/results/publication.out 2026-01-10 16:28:25.130585846 +0000 @@ -629,8 +629,6 @@ -- test that ALTER COLUMN ALTER [ SET DATA ] TYPE is rejected when the column is in a row filter CREATE TABLE testpub_rf_tbl8 (id int PRIMARY KEY, x int, y int, z int); CREATE PUBLICATION testpub9 FOR TABLE testpub_rf_tbl8 WHERE (x > 100 AND y < 200); -WARNING: "wal_level" is insufficient to publish logical changes -HINT: Set "wal_level" to "logical" before creating subscriptions. SET client_min_messages = 'ERROR'; -- fail ALTER TABLE testpub_rf_tbl8 ALTER COLUMN x TYPE bigint; |
| FreeBSD - Meson | |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/publication.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/00... --- /tmp/cirrus-ci-build/src/test/regress/expected/publication.out 2026-01-10 16:22:46.354487000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/publication.out 2026-01-10 16:26:43.571092... @@ -629,8 +629,6 @@ -- test that ALTER COLUMN ALTER [ SET DATA ] TYPE is rejected when the column is in a row filter CREATE TABLE testpub_rf_tbl8 (id int PRIMARY KEY, x int, y int, z int); CREATE PUBLICATION testpub9 FOR TABLE testpub_rf_tbl8 WHERE (x > 100 AND y < 200); -WARNING: "wal_level" is insufficient to publish logical changes -HINT: Set "wal_level" to "logical" before creating subscriptions. SET client_min_messages = 'ERROR'; -- fail ALTER TABLE testpub_rf_tbl8 ALTER COLUMN x TYPE bigint; |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/publication.out /tmp/cirrus-ci-build/build/testrun/recovery/027_... --- /tmp/cirrus-ci-build/src/test/regress/expected/publication.out 2026-01-10 16:22:46.354487000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/publication.out 2026-01-10 16:28:04.0296... @@ -629,8 +629,6 @@ -- test that ALTER COLUMN ALTER [ SET DATA ] TYPE is rejected when the column is in a row filter CREATE TABLE testpub_rf_tbl8 (id int PRIMARY KEY, x int, y int, z int); CREATE PUBLICATION testpub9 FOR TABLE testpub_rf_tbl8 WHERE (x > 100 AND y < 200); -WARNING: "wal_level" is insufficient to publish logical changes -HINT: Set "wal_level" to "logical" before creating subscriptions. SET client_min_messages = 'ERROR'; -- fail ALTER TABLE testpub_rf_tbl8 ALTER COLUMN x TYPE bigint; |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/publication.out /tmp/cirrus-ci-build/build/testrun/regress/regre... --- /tmp/cirrus-ci-build/src/test/regress/expected/publication.out 2026-01-10 16:22:46.354487000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/publication.out 2026-01-10 16:26:31.609271000 +0000 @@ -629,8 +629,6 @@ -- test that ALTER COLUMN ALTER [ SET DATA ] TYPE is rejected when the column is in a row filter CREATE TABLE testpub_rf_tbl8 (id int PRIMARY KEY, x int, y int, z int); CREATE PUBLICATION testpub9 FOR TABLE testpub_rf_tbl8 WHERE (x > 100 AND y < 200); -WARNING: "wal_level" is insufficient to publish logical changes -HINT: Set "wal_level" to "logical" before creating subscriptions. SET client_min_messages = 'ERROR'; -- fail ALTER TABLE testpub_rf_tbl8 ALTER COLUMN x TYPE bigint; |
| 57/6303 | refactor handling optional argument in system functions |
| Linux - Debian Trixie - Autoconf | |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out 2026-01-10 13:28:54.659746547 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/triggers.out 2026-01-10 13:34:35.819667995 +0000
@@ -2545,1087 +2545,10 @@
tgfoid::regproc, tgenabled
from pg_trigger where tgrelid in ('parent'::regclass, 'child1'::regclass)
order by tgrelid::regclass::text, tgfoid;
- tgrelid | tgname | tgfoid | tgenabled
----------+-------------------------+------------------------+-----------
- child1 | RI_ConstraintTrigger_c_ | "RI_FKey_check_ins" | O
- child1 | RI_ConstraintTrigger_c_ | "RI_FKey_check_upd" | O
- child1 | RI_ConstraintTrigger_a_ | "RI_FKey_noaction_del" | O
- child1 | RI_ConstraintTrigger_a_ | "RI_FKey_noaction_upd" | O
- parent | RI_ConstraintTrigger_c_ | "RI_FKey_check_ins" | O
- parent | RI_ConstraintTrigger_c_ | "RI_FKey_check_upd" | O
- parent | RI_ConstraintTrigger_a_ | "RI_FKey_noaction_del" | O
- parent | RI_ConstraintTrigger_a_ | "RI_FKey_noaction_upd" | O
-(8 rows)
-
-alter table parent disable trigger all;
... |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check/re...
--- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out 2026-01-10 13:28:54.659746547 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/triggers.out 2026-01-10 13:36:16.531961525 +0000
@@ -2766,866 +2766,10 @@
NOTICE: trigger = child2_delete_trig, old table = (BBB,42)
delete from child3;
NOTICE: trigger = child3_delete_trig, old table = (42,CCC)
--- copy into parent sees parent-format tuples
-copy parent (a, b) from stdin;
-NOTICE: trigger = parent_insert_trig, new table = (AAA,42), (BBB,42), (CCC,42)
--- check detach/reattach behavior; statement triggers with transition tables
--- should not prevent a table from becoming a partition again
-alter table parent detach partition child1;
-alter table parent attach partition child1 for values in ('AAA');
--- DML affecting parent sees tuples collected from children even if
--- there is no transition table trigger on the children
-drop trigger child1_insert_trig on child1;
-drop trigger child1_update_trig on child1;
-drop trigger child1_delete_trig on child1;
-drop trigger child2_insert_trig on child2;
... |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/src/test/regress/results/trigg... --- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out 2026-01-10 13:28:54.659746547 +0000 +++ /tmp/cirrus-ci-build/src/test/regress/results/triggers.out 2026-01-10 13:33:08.195412485 +0000 @@ -2451,1181 +2451,10 @@ (5 rows) drop table trg_clone; --- Test the interaction between ALTER TABLE .. DISABLE TRIGGER and --- both kinds of inheritance. Historically, legacy inheritance has --- not recursed to children, so that behavior is preserved. -create table parent (a int); -create table child1 () inherits (parent); -create function trig_nothing() returns trigger language plpgsql - as $$ begin return null; end $$; -create trigger tg after insert on parent - for each row execute function trig_nothing(); -create trigger tg after insert on child1 - for each row execute function trig_nothing(); -alter table parent disable trigger tg; -select tgrelid::regclass, tgname, tgenabled from pg_trigger ... |
| 57/5957 | implement CAST(expr AS type FORMAT 'template') |
| Windows - Server 2022, MinGW64 - Meson | |
| regress | diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/misc.out C:/cirrus/build/testrun/pg_upgrade/002_pg_upgr...
--- C:/cirrus/src/test/regress/expected/misc.out 2026-01-10 03:33:09.758022200 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/misc.out 2026-01-10 03:39:23.869231500 +0000
@@ -510,8 +510,12 @@
create index s1 on tcast(cast(col1 as date format 'YYYY-MM-DD')); --error
ERROR: functions in index expression must be marked IMMUTABLE
+LINE 1: create index s1 on tcast(cast(col1 as date format 'YYYY-MM-D...
+ ^
create index s1 on tcast(cast(col1 as date format stable_const())); --error
ERROR: functions in index expression must be marked IMMUTABLE
+LINE 1: create index s1 on tcast(cast(col1 as date format stable_con...
+ ^
create view tcast_v1 as select cast(col1 as date format 'YYYY-MM-DD') from tcast;
select pg_get_viewdef('tcast_v1', false);
pg_get_viewdef |
| regress | diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/misc.out C:/cirrus/build/testrun/recovery/027_stream_re...
--- C:/cirrus/src/test/regress/expected/misc.out 2026-01-10 03:33:09.758022200 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/misc.out 2026-01-10 03:42:24.653404900 +0000
@@ -510,8 +510,12 @@
create index s1 on tcast(cast(col1 as date format 'YYYY-MM-DD')); --error
ERROR: functions in index expression must be marked IMMUTABLE
+LINE 1: create index s1 on tcast(cast(col1 as date format 'YYYY-MM-D...
+ ^
create index s1 on tcast(cast(col1 as date format stable_const())); --error
ERROR: functions in index expression must be marked IMMUTABLE
+LINE 1: create index s1 on tcast(cast(col1 as date format stable_con...
+ ^
create view tcast_v1 as select cast(col1 as date format 'YYYY-MM-DD') from tcast;
select pg_get_viewdef('tcast_v1', false);
pg_get_viewdef |
| regress | diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/misc.out C:/cirrus/build/testrun/regress/regress/result...
--- C:/cirrus/src/test/regress/expected/misc.out 2026-01-10 03:33:09.758022200 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/misc.out 2026-01-10 03:39:18.769136200 +0000
@@ -510,8 +510,12 @@
create index s1 on tcast(cast(col1 as date format 'YYYY-MM-DD')); --error
ERROR: functions in index expression must be marked IMMUTABLE
+LINE 1: create index s1 on tcast(cast(col1 as date format 'YYYY-MM-D...
+ ^
create index s1 on tcast(cast(col1 as date format stable_const())); --error
ERROR: functions in index expression must be marked IMMUTABLE
+LINE 1: create index s1 on tcast(cast(col1 as date format stable_con...
+ ^
create view tcast_v1 as select cast(col1 as date format 'YYYY-MM-DD') from tcast;
select pg_get_viewdef('tcast_v1', false);
pg_get_viewdef |
| macOS - Sequoia - Meson | |
| regress | diff -U3 /Users/admin/pgsql/src/test/regress/expected/misc.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrad...
--- /Users/admin/pgsql/src/test/regress/expected/misc.out 2026-01-10 03:39:32
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/misc.out 2026-01-10 03:42:24
@@ -510,8 +510,12 @@
create index s1 on tcast(cast(col1 as date format 'YYYY-MM-DD')); --error
ERROR: functions in index expression must be marked IMMUTABLE
+LINE 1: create index s1 on tcast(cast(col1 as date format 'YYYY-MM-D...
+ ^
create index s1 on tcast(cast(col1 as date format stable_const())); --error
ERROR: functions in index expression must be marked IMMUTABLE
+LINE 1: create index s1 on tcast(cast(col1 as date format stable_con...
+ ^
create view tcast_v1 as select cast(col1 as date format 'YYYY-MM-DD') from tcast;
select pg_get_viewdef('tcast_v1', false);
pg_get_viewdef |
| regress | diff -U3 /Users/admin/pgsql/src/test/regress/expected/misc.out /Users/admin/pgsql/build/testrun/recovery/027_stream_regr...
--- /Users/admin/pgsql/src/test/regress/expected/misc.out 2026-01-10 03:39:32
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/misc.out 2026-01-10 03:44:00
@@ -510,8 +510,12 @@
create index s1 on tcast(cast(col1 as date format 'YYYY-MM-DD')); --error
ERROR: functions in index expression must be marked IMMUTABLE
+LINE 1: create index s1 on tcast(cast(col1 as date format 'YYYY-MM-D...
+ ^
create index s1 on tcast(cast(col1 as date format stable_const())); --error
ERROR: functions in index expression must be marked IMMUTABLE
+LINE 1: create index s1 on tcast(cast(col1 as date format stable_con...
+ ^
create view tcast_v1 as select cast(col1 as date format 'YYYY-MM-DD') from tcast;
select pg_get_viewdef('tcast_v1', false);
pg_get_viewdef |
| regress | diff -U3 /Users/admin/pgsql/src/test/regress/expected/misc.out /Users/admin/pgsql/build/testrun/regress/regress/results/...
--- /Users/admin/pgsql/src/test/regress/expected/misc.out 2026-01-10 03:39:32
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/misc.out 2026-01-10 03:42:24
@@ -510,8 +510,12 @@
create index s1 on tcast(cast(col1 as date format 'YYYY-MM-DD')); --error
ERROR: functions in index expression must be marked IMMUTABLE
+LINE 1: create index s1 on tcast(cast(col1 as date format 'YYYY-MM-D...
+ ^
create index s1 on tcast(cast(col1 as date format stable_const())); --error
ERROR: functions in index expression must be marked IMMUTABLE
+LINE 1: create index s1 on tcast(cast(col1 as date format stable_con...
+ ^
create view tcast_v1 as select cast(col1 as date format 'YYYY-MM-DD') from tcast;
select pg_get_viewdef('tcast_v1', false);
pg_get_viewdef |
| Windows - Server 2022, VS 2019 - Meson & ninja | |
| regress | diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/misc.out C:/cirrus/build/testrun/pg_upgrade/002_pg_upgr...
--- C:/cirrus/src/test/regress/expected/misc.out 2026-01-10 03:33:06.567519500 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/misc.out 2026-01-10 03:36:39.106387000 +0000
@@ -510,8 +510,12 @@
create index s1 on tcast(cast(col1 as date format 'YYYY-MM-DD')); --error
ERROR: functions in index expression must be marked IMMUTABLE
+LINE 1: create index s1 on tcast(cast(col1 as date format 'YYYY-MM-D...
+ ^
create index s1 on tcast(cast(col1 as date format stable_const())); --error
ERROR: functions in index expression must be marked IMMUTABLE
+LINE 1: create index s1 on tcast(cast(col1 as date format stable_con...
+ ^
create view tcast_v1 as select cast(col1 as date format 'YYYY-MM-DD') from tcast;
select pg_get_viewdef('tcast_v1', false);
pg_get_viewdef |
| regress | diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/misc.out C:/cirrus/build/testrun/recovery/027_stream_re...
--- C:/cirrus/src/test/regress/expected/misc.out 2026-01-10 03:33:06.567519500 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/misc.out 2026-01-10 03:39:23.443300600 +0000
@@ -510,8 +510,12 @@
create index s1 on tcast(cast(col1 as date format 'YYYY-MM-DD')); --error
ERROR: functions in index expression must be marked IMMUTABLE
+LINE 1: create index s1 on tcast(cast(col1 as date format 'YYYY-MM-D...
+ ^
create index s1 on tcast(cast(col1 as date format stable_const())); --error
ERROR: functions in index expression must be marked IMMUTABLE
+LINE 1: create index s1 on tcast(cast(col1 as date format stable_con...
+ ^
create view tcast_v1 as select cast(col1 as date format 'YYYY-MM-DD') from tcast;
select pg_get_viewdef('tcast_v1', false);
pg_get_viewdef |
| regress | diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/misc.out C:/cirrus/build/testrun/regress/regress/result...
--- C:/cirrus/src/test/regress/expected/misc.out 2026-01-10 03:33:06.567519500 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/misc.out 2026-01-10 03:36:34.834904200 +0000
@@ -510,8 +510,12 @@
create index s1 on tcast(cast(col1 as date format 'YYYY-MM-DD')); --error
ERROR: functions in index expression must be marked IMMUTABLE
+LINE 1: create index s1 on tcast(cast(col1 as date format 'YYYY-MM-D...
+ ^
create index s1 on tcast(cast(col1 as date format stable_const())); --error
ERROR: functions in index expression must be marked IMMUTABLE
+LINE 1: create index s1 on tcast(cast(col1 as date format stable_con...
+ ^
create view tcast_v1 as select cast(col1 as date format 'YYYY-MM-DD') from tcast;
select pg_get_viewdef('tcast_v1', false);
pg_get_viewdef |
| Linux - Debian Trixie - Meson | |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/misc.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_up...
--- /tmp/cirrus-ci-build/src/test/regress/expected/misc.out 2026-01-10 03:33:20.253303976 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/misc.out 2026-01-10 03:37:54.642180153 +00...
@@ -510,8 +510,12 @@
create index s1 on tcast(cast(col1 as date format 'YYYY-MM-DD')); --error
ERROR: functions in index expression must be marked IMMUTABLE
+LINE 1: create index s1 on tcast(cast(col1 as date format 'YYYY-MM-D...
+ ^
create index s1 on tcast(cast(col1 as date format stable_const())); --error
ERROR: functions in index expression must be marked IMMUTABLE
+LINE 1: create index s1 on tcast(cast(col1 as date format stable_con...
+ ^
create view tcast_v1 as select cast(col1 as date format 'YYYY-MM-DD') from tcast;
select pg_get_viewdef('tcast_v1', false);
pg_get_viewdef |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/misc.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/misc.out 2026-01-10 03:33:20.253303976 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/misc.out 2026-01-10 03:39:15.091035120 +...
@@ -510,8 +510,12 @@
create index s1 on tcast(cast(col1 as date format 'YYYY-MM-DD')); --error
ERROR: functions in index expression must be marked IMMUTABLE
+LINE 1: create index s1 on tcast(cast(col1 as date format 'YYYY-MM-D...
+ ^
create index s1 on tcast(cast(col1 as date format stable_const())); --error
ERROR: functions in index expression must be marked IMMUTABLE
+LINE 1: create index s1 on tcast(cast(col1 as date format stable_con...
+ ^
create view tcast_v1 as select cast(col1 as date format 'YYYY-MM-DD') from tcast;
select pg_get_viewdef('tcast_v1', false);
pg_get_viewdef |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/misc.out /tmp/cirrus-ci-build/build/testrun/regress/regress/resu...
--- /tmp/cirrus-ci-build/src/test/regress/expected/misc.out 2026-01-10 03:33:20.253303976 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/misc.out 2026-01-10 03:37:54.626179934 +0000
@@ -510,8 +510,12 @@
create index s1 on tcast(cast(col1 as date format 'YYYY-MM-DD')); --error
ERROR: functions in index expression must be marked IMMUTABLE
+LINE 1: create index s1 on tcast(cast(col1 as date format 'YYYY-MM-D...
+ ^
create index s1 on tcast(cast(col1 as date format stable_const())); --error
ERROR: functions in index expression must be marked IMMUTABLE
+LINE 1: create index s1 on tcast(cast(col1 as date format stable_con...
+ ^
create view tcast_v1 as select cast(col1 as date format 'YYYY-MM-DD') from tcast;
select pg_get_viewdef('tcast_v1', false);
pg_get_viewdef |
| Linux - Debian Trixie - Autoconf | |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/misc.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/resul...
--- /tmp/cirrus-ci-build/src/test/regress/expected/misc.out 2026-01-10 03:33:11.095754349 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/misc.out 2026-01-10 03:40:58.314826665 +0000
@@ -510,8 +510,12 @@
create index s1 on tcast(cast(col1 as date format 'YYYY-MM-DD')); --error
ERROR: functions in index expression must be marked IMMUTABLE
+LINE 1: create index s1 on tcast(cast(col1 as date format 'YYYY-MM-D...
+ ^
create index s1 on tcast(cast(col1 as date format stable_const())); --error
ERROR: functions in index expression must be marked IMMUTABLE
+LINE 1: create index s1 on tcast(cast(col1 as date format stable_con...
+ ^
create view tcast_v1 as select cast(col1 as date format 'YYYY-MM-DD') from tcast;
select pg_get_viewdef('tcast_v1', false);
pg_get_viewdef |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/misc.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check/result...
--- /tmp/cirrus-ci-build/src/test/regress/expected/misc.out 2026-01-10 03:33:11.095754349 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/misc.out 2026-01-10 03:42:20.474724610 +0000
@@ -510,8 +510,12 @@
create index s1 on tcast(cast(col1 as date format 'YYYY-MM-DD')); --error
ERROR: functions in index expression must be marked IMMUTABLE
+LINE 1: create index s1 on tcast(cast(col1 as date format 'YYYY-MM-D...
+ ^
create index s1 on tcast(cast(col1 as date format stable_const())); --error
ERROR: functions in index expression must be marked IMMUTABLE
+LINE 1: create index s1 on tcast(cast(col1 as date format stable_con...
+ ^
create view tcast_v1 as select cast(col1 as date format 'YYYY-MM-DD') from tcast;
select pg_get_viewdef('tcast_v1', false);
pg_get_viewdef |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/misc.out /tmp/cirrus-ci-build/src/test/regress/results/misc.out
--- /tmp/cirrus-ci-build/src/test/regress/expected/misc.out 2026-01-10 03:33:11.095754349 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/misc.out 2026-01-10 03:38:38.742892907 +0000
@@ -510,8 +510,12 @@
create index s1 on tcast(cast(col1 as date format 'YYYY-MM-DD')); --error
ERROR: functions in index expression must be marked IMMUTABLE
+LINE 1: create index s1 on tcast(cast(col1 as date format 'YYYY-MM-D...
+ ^
create index s1 on tcast(cast(col1 as date format stable_const())); --error
ERROR: functions in index expression must be marked IMMUTABLE
+LINE 1: create index s1 on tcast(cast(col1 as date format stable_con...
+ ^
create view tcast_v1 as select cast(col1 as date format 'YYYY-MM-DD') from tcast;
select pg_get_viewdef('tcast_v1', false);
pg_get_viewdef |
| OpenBSD - Meson | |
| regress | diff -U3 /home/postgres/postgres/src/test/regress/expected/misc.out /home/postgres/postgres/build/testrun/pg_upgrade/002...
--- /home/postgres/postgres/src/test/regress/expected/misc.out Sat Jan 10 03:33:14 2026
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/misc.out Sat Jan 10 03:36:54 2026
@@ -510,8 +510,12 @@
create index s1 on tcast(cast(col1 as date format 'YYYY-MM-DD')); --error
ERROR: functions in index expression must be marked IMMUTABLE
+LINE 1: create index s1 on tcast(cast(col1 as date format 'YYYY-MM-D...
+ ^
create index s1 on tcast(cast(col1 as date format stable_const())); --error
ERROR: functions in index expression must be marked IMMUTABLE
+LINE 1: create index s1 on tcast(cast(col1 as date format stable_con...
+ ^
create view tcast_v1 as select cast(col1 as date format 'YYYY-MM-DD') from tcast;
select pg_get_viewdef('tcast_v1', false);
pg_get_viewdef |
| regress | diff -U3 /home/postgres/postgres/src/test/regress/expected/misc.out /home/postgres/postgres/build/testrun/recovery/027_s...
--- /home/postgres/postgres/src/test/regress/expected/misc.out Sat Jan 10 03:33:14 2026
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/misc.out Sat Jan 10 03:38:47 2026
@@ -510,8 +510,12 @@
create index s1 on tcast(cast(col1 as date format 'YYYY-MM-DD')); --error
ERROR: functions in index expression must be marked IMMUTABLE
+LINE 1: create index s1 on tcast(cast(col1 as date format 'YYYY-MM-D...
+ ^
create index s1 on tcast(cast(col1 as date format stable_const())); --error
ERROR: functions in index expression must be marked IMMUTABLE
+LINE 1: create index s1 on tcast(cast(col1 as date format stable_con...
+ ^
create view tcast_v1 as select cast(col1 as date format 'YYYY-MM-DD') from tcast;
select pg_get_viewdef('tcast_v1', false);
pg_get_viewdef |
| regress | diff -U3 /home/postgres/postgres/src/test/regress/expected/misc.out /home/postgres/postgres/build/testrun/regress/regres...
--- /home/postgres/postgres/src/test/regress/expected/misc.out Sat Jan 10 03:33:14 2026
+++ /home/postgres/postgres/build/testrun/regress/regress/results/misc.out Sat Jan 10 03:36:50 2026
@@ -510,8 +510,12 @@
create index s1 on tcast(cast(col1 as date format 'YYYY-MM-DD')); --error
ERROR: functions in index expression must be marked IMMUTABLE
+LINE 1: create index s1 on tcast(cast(col1 as date format 'YYYY-MM-D...
+ ^
create index s1 on tcast(cast(col1 as date format stable_const())); --error
ERROR: functions in index expression must be marked IMMUTABLE
+LINE 1: create index s1 on tcast(cast(col1 as date format stable_con...
+ ^
create view tcast_v1 as select cast(col1 as date format 'YYYY-MM-DD') from tcast;
select pg_get_viewdef('tcast_v1', false);
pg_get_viewdef |
| NetBSD - Meson | |
| regress | diff -U3 /home/postgres/postgres/src/test/regress/expected/misc.out /home/postgres/postgres/build/testrun/pg_upgrade/002...
--- /home/postgres/postgres/src/test/regress/expected/misc.out 2026-01-10 03:33:31.366826768 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/misc.out 2026-01-10 03:36:22.028232535 ...
@@ -510,8 +510,12 @@
create index s1 on tcast(cast(col1 as date format 'YYYY-MM-DD')); --error
ERROR: functions in index expression must be marked IMMUTABLE
+LINE 1: create index s1 on tcast(cast(col1 as date format 'YYYY-MM-D...
+ ^
create index s1 on tcast(cast(col1 as date format stable_const())); --error
ERROR: functions in index expression must be marked IMMUTABLE
+LINE 1: create index s1 on tcast(cast(col1 as date format stable_con...
+ ^
create view tcast_v1 as select cast(col1 as date format 'YYYY-MM-DD') from tcast;
select pg_get_viewdef('tcast_v1', false);
pg_get_viewdef |
| regress | diff -U3 /home/postgres/postgres/src/test/regress/expected/misc.out /home/postgres/postgres/build/testrun/recovery/027_s...
--- /home/postgres/postgres/src/test/regress/expected/misc.out 2026-01-10 03:33:31.366826768 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/misc.out 2026-01-10 03:37:13.97835162...
@@ -510,8 +510,12 @@
create index s1 on tcast(cast(col1 as date format 'YYYY-MM-DD')); --error
ERROR: functions in index expression must be marked IMMUTABLE
+LINE 1: create index s1 on tcast(cast(col1 as date format 'YYYY-MM-D...
+ ^
create index s1 on tcast(cast(col1 as date format stable_const())); --error
ERROR: functions in index expression must be marked IMMUTABLE
+LINE 1: create index s1 on tcast(cast(col1 as date format stable_con...
+ ^
create view tcast_v1 as select cast(col1 as date format 'YYYY-MM-DD') from tcast;
select pg_get_viewdef('tcast_v1', false);
pg_get_viewdef |
| regress | diff -U3 /home/postgres/postgres/src/test/regress/expected/misc.out /home/postgres/postgres/build/testrun/regress/regres...
--- /home/postgres/postgres/src/test/regress/expected/misc.out 2026-01-10 03:33:31.366826768 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/misc.out 2026-01-10 03:36:26.129049190 +0000
@@ -510,8 +510,12 @@
create index s1 on tcast(cast(col1 as date format 'YYYY-MM-DD')); --error
ERROR: functions in index expression must be marked IMMUTABLE
+LINE 1: create index s1 on tcast(cast(col1 as date format 'YYYY-MM-D...
+ ^
create index s1 on tcast(cast(col1 as date format stable_const())); --error
ERROR: functions in index expression must be marked IMMUTABLE
+LINE 1: create index s1 on tcast(cast(col1 as date format stable_con...
+ ^
create view tcast_v1 as select cast(col1 as date format 'YYYY-MM-DD') from tcast;
select pg_get_viewdef('tcast_v1', false);
pg_get_viewdef |
| FreeBSD - Meson | |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/misc.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_up...
--- /tmp/cirrus-ci-build/src/test/regress/expected/misc.out 2026-01-10 03:33:01.382098000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/misc.out 2026-01-10 03:35:59.088905000 +00...
@@ -510,8 +510,12 @@
create index s1 on tcast(cast(col1 as date format 'YYYY-MM-DD')); --error
ERROR: functions in index expression must be marked IMMUTABLE
+LINE 1: create index s1 on tcast(cast(col1 as date format 'YYYY-MM-D...
+ ^
create index s1 on tcast(cast(col1 as date format stable_const())); --error
ERROR: functions in index expression must be marked IMMUTABLE
+LINE 1: create index s1 on tcast(cast(col1 as date format stable_con...
+ ^
create view tcast_v1 as select cast(col1 as date format 'YYYY-MM-DD') from tcast;
select pg_get_viewdef('tcast_v1', false);
pg_get_viewdef |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/misc.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/misc.out 2026-01-10 03:33:01.382098000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/misc.out 2026-01-10 03:37:18.942545000 +...
@@ -510,8 +510,12 @@
create index s1 on tcast(cast(col1 as date format 'YYYY-MM-DD')); --error
ERROR: functions in index expression must be marked IMMUTABLE
+LINE 1: create index s1 on tcast(cast(col1 as date format 'YYYY-MM-D...
+ ^
create index s1 on tcast(cast(col1 as date format stable_const())); --error
ERROR: functions in index expression must be marked IMMUTABLE
+LINE 1: create index s1 on tcast(cast(col1 as date format stable_con...
+ ^
create view tcast_v1 as select cast(col1 as date format 'YYYY-MM-DD') from tcast;
select pg_get_viewdef('tcast_v1', false);
pg_get_viewdef |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/misc.out /tmp/cirrus-ci-build/build/testrun/regress/regress/resu...
--- /tmp/cirrus-ci-build/src/test/regress/expected/misc.out 2026-01-10 03:33:01.382098000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/misc.out 2026-01-10 03:36:02.008371000 +0000
@@ -510,8 +510,12 @@
create index s1 on tcast(cast(col1 as date format 'YYYY-MM-DD')); --error
ERROR: functions in index expression must be marked IMMUTABLE
+LINE 1: create index s1 on tcast(cast(col1 as date format 'YYYY-MM-D...
+ ^
create index s1 on tcast(cast(col1 as date format stable_const())); --error
ERROR: functions in index expression must be marked IMMUTABLE
+LINE 1: create index s1 on tcast(cast(col1 as date format stable_con...
+ ^
create view tcast_v1 as select cast(col1 as date format 'YYYY-MM-DD') from tcast;
select pg_get_viewdef('tcast_v1', false);
pg_get_viewdef |
| 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-09 15:28:14.808994800 +0000
+++ C:/cirrus/build/testrun/test_decoding/regress/results/rewrite.out 2026-01-09 15:48:43.383702700 +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-09 15:28:09.617955200 +0000
+++ C:/cirrus/build/testrun/test_decoding/regress/results/rewrite.out 2026-01-09 15:39:33.428518500 +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-09 15:28:29.078294545 +0000
+++ /home/postgres/postgres/build/testrun/test_decoding/regress/results/rewrite.out 2026-01-09 15:35:07.565373968 +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-09 15:28:07.980218000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_decoding/regress/results/rewrite.out 2026-01-09 15:35:04.869168000 +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/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-09 06:00:53.812525600 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/goo.out 2026-01-09 06:06:31.943236600 +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-09 06:00:53.812525600 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/goo.out 2026-01-09 06:09:39.160020900 +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-09 06:00:53.812525600 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/goo.out 2026-01-09 06:06:30.581423900 +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-09 06:00:50.607698400 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/goo.out 2026-01-09 06:04:31.149735900 +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-09 06:00:50.607698400 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/goo.out 2026-01-09 06:07:35.214586800 +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-09 06:00:50.607698400 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/goo.out 2026-01-09 06:04:31.509103100 +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-09 06:00:39
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/goo.out 2026-01-09 06:02:58
@@ -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-09 06:00:39
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/goo.out 2026-01-09 06:03:57
@@ -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-09 06:00:39
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/goo.out 2026-01-09 06:03:02
@@ -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-09 06:00:48.410210984 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/goo.out 2026-01-09 06:04:32.241788562 +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-09 06:00:48.410210984 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/goo.out 2026-01-09 06:05:57.993643579 +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-09 06:00:48.410210984 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/goo.out 2026-01-09 06:04:32.141789290 +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 - 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-09 06:00:52.233677126 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/goo.out 2026-01-09 06:08:06.911367623 +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-09 06:00:52.233677126 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/goo.out 2026-01-09 06:09:19.823033271 +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-09 06:00:52.233677126 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/goo.out 2026-01-09 06:05:48.900504584 +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-09 06:01:11.127453323 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/goo.out 2026-01-09 06:03:47.319446352 +...
@@ -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-09 06:01:11.127453323 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/goo.out 2026-01-09 06:04:28.946084250...
@@ -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-09 06:01:11.127453323 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/goo.out 2026-01-09 06:03:40.191475339 +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-09 06:00:45.030114000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/goo.out 2026-01-09 06:03:28.845263000 +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-09 06:00:45.030114000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/goo.out 2026-01-09 06:05:04.923747000 +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-09 06:00:45.030114000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/goo.out 2026-01-09 06:03:30.162097000 +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)
... |
| OpenBSD - Meson | |
| regress | diff -U3 /home/postgres/postgres/src/test/regress/expected/goo.out /home/postgres/postgres/build/testrun/pg_upgrade/002_...
--- /home/postgres/postgres/src/test/regress/expected/goo.out Fri Jan 9 06:00:58 2026
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/goo.out Fri Jan 9 06:04:21 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 Fri Jan 9 06:00:58 2026
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/goo.out Fri Jan 9 06:06:30 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 Fri Jan 9 06:00:58 2026
+++ /home/postgres/postgres/build/testrun/regress/regress/results/goo.out Fri Jan 9 06:04: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)
... |
| 57/6299 | New grouping strategy - Index Aggregate |
| Linux - Debian Trixie - Meson | |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/partition_aggregate.out /tmp/cirrus-ci-build/build-32/testrun/pg...
--- /tmp/cirrus-ci-build/src/test/regress/expected/partition_aggregate.out 2026-01-09 05:34:08.297873425 +0000
+++ /tmp/cirrus-ci-build/build-32/testrun/pg_upgrade/002_pg_upgrade/data/results/partition_aggregate.out 2026-01-09 05:4...
@@ -1010,7 +1010,7 @@
--------------------------------------------------------------------
Sort
Sort Key: pagg_tab_m.a, (sum(pagg_tab_m.b)), (avg(pagg_tab_m.c))
- -> Finalize IndexAggregate
+ -> Finalize HashAggregate
Group Key: pagg_tab_m.a
Filter: (avg(pagg_tab_m.c) < '22'::numeric)
-> Append |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/partition_aggregate.out /tmp/cirrus-ci-build/build-32/testrun/re...
--- /tmp/cirrus-ci-build/src/test/regress/expected/partition_aggregate.out 2026-01-09 05:34:08.297873425 +0000
+++ /tmp/cirrus-ci-build/build-32/testrun/recovery/027_stream_regress/data/results/partition_aggregate.out 2026-01-09 05...
@@ -1010,7 +1010,7 @@
--------------------------------------------------------------------
Sort
Sort Key: pagg_tab_m.a, (sum(pagg_tab_m.b)), (avg(pagg_tab_m.c))
- -> Finalize IndexAggregate
+ -> Finalize HashAggregate
Group Key: pagg_tab_m.a
Filter: (avg(pagg_tab_m.c) < '22'::numeric)
-> Append |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/partition_aggregate.out /tmp/cirrus-ci-build/build-32/testrun/re...
--- /tmp/cirrus-ci-build/src/test/regress/expected/partition_aggregate.out 2026-01-09 05:34:08.297873425 +0000
+++ /tmp/cirrus-ci-build/build-32/testrun/regress/regress/results/partition_aggregate.out 2026-01-09 05:45:39.566959863 ...
@@ -1010,7 +1010,7 @@
--------------------------------------------------------------------
Sort
Sort Key: pagg_tab_m.a, (sum(pagg_tab_m.b)), (avg(pagg_tab_m.c))
- -> Finalize IndexAggregate
+ -> Finalize HashAggregate
Group Key: pagg_tab_m.a
Filter: (avg(pagg_tab_m.c) < '22'::numeric)
-> Append |
| OpenBSD - Meson | |
| regress | diff -U3 /home/postgres/postgres/src/test/regress/expected/brin.out /home/postgres/postgres/build/testrun/pg_upgrade/002... --- /home/postgres/postgres/src/test/regress/expected/brin.out Fri Jan 9 05:34:20 2026 +++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/brin.out Fri Jan 9 05:38:36 2026 @@ -588,4 +588,10 @@ CREATE INDEX brin_insert_optimization_idx ON brin_insert_optimization USING brin (a); UPDATE brin_insert_optimization SET a = a; REINDEX INDEX CONCURRENTLY brin_insert_optimization_idx; -DROP TABLE brin_insert_optimization; +WARNING: terminating connection because of crash of another server process +DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because anothe... +HINT: In a moment you should be able to reconnect to the database and repeat your command. +server closed the connection unexpectedly + This probably means the server terminated abnormally + before or while processing the request. +connection to server was lost diff -U3 /home/postgres/postgres/src/test/regress/expected/privileges.out /home/postgres/postgres/build/testrun/pg_upgra... --- /home/postgres/postgres/src/test/regress/expected/privileges.out Fri Jan 9 05:34:21 2026 +++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/privileges.out Fri Jan 9 05:38:36 2026 @@ -1860,1600 +1860,10 @@ REINDEX TABLE sro_tab; ... |
| regress | diff -U3 /home/postgres/postgres/src/test/regress/expected/brin.out /home/postgres/postgres/build/testrun/recovery/027_s...
--- /home/postgres/postgres/src/test/regress/expected/brin.out Fri Jan 9 05:34:20 2026
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/brin.out Fri Jan 9 05:40:30 2026
@@ -363,229 +363,10 @@
END LOOP;
END;
$x$;
-RESET enable_seqscan;
-RESET enable_bitmapscan;
-INSERT INTO brintest SELECT
- repeat(stringu1, 42)::bytea,
- substr(stringu1, 1, 1)::"char",
- stringu1::name, 142857 * tenthous,
- thousand,
- twothousand,
- repeat(stringu1, 42),
- unique1::oid,
- format('(%s,%s)', tenthous, twenty)::tid,
- (four + 1.0)/(hundred+1),
- odd::float8 / (tenthous + 1),
... |
| regress | diff -U3 /home/postgres/postgres/src/test/regress/expected/brin.out /home/postgres/postgres/build/testrun/regress/regres... --- /home/postgres/postgres/src/test/regress/expected/brin.out Fri Jan 9 05:34:20 2026 +++ /home/postgres/postgres/build/testrun/regress/regress/results/brin.out Fri Jan 9 05:38:25 2026 @@ -539,53 +539,10 @@ -- vacuum actually removes the TOAST rows. Creating an index concurrently -- is a one way to achieve that, because it does exactly such wait. CREATE INDEX CONCURRENTLY brin_test_temp_idx ON brintest_3(a); -DROP INDEX brin_test_temp_idx; --- vacuum the table, to discard TOAST data -VACUUM brintest_3; --- retry insert with a different random-looking (but deterministic) value --- the value is different, and so should replace either min or max in the --- brin summary -WITH rand_value AS (SELECT string_agg(fipshash((-i)::text),'') AS val FROM generate_series(1,60) s(i)) -INSERT INTO brintest_3 -SELECT val, val, val, val FROM rand_value; --- now try some queries, accessing the brin index -SET enable_seqscan = off; -EXPLAIN (COSTS OFF) -SELECT * FROM brintest_3 WHERE b < '0'; ... |
| 57/6357 | Wrong comment for ReplicationSlotCreate |
| OpenBSD - Meson | |
| regress | diff -U3 /home/postgres/postgres/src/test/isolation/expected/timeouts.out /home/postgres/postgres/build/testrun/isolatio... --- /home/postgres/postgres/src/test/isolation/expected/timeouts.out Thu Jan 8 17:34:22 2026 +++ /home/postgres/postgres/build/testrun/isolation/isolation/results/timeouts.out Thu Jan 8 17:39:05 2026 @@ -11,7 +11,7 @@ step sto: SET statement_timeout = '10ms'; step locktbl: LOCK TABLE accounts; <waiting ...> step locktbl: <... completed> -ERROR: canceling statement due to statement timeout +ERROR: canceling statement due to user request starting permutation: rdtbl lto locktbl step rdtbl: SELECT * FROM accounts; |
| 57/6235 | Implement pg_add_size_overflow() and friends |
| regress | diff -U3 /home/postgres/postgres/src/test/isolation/expected/timeouts.out /home/postgres/postgres/build/testrun/isolatio... --- /home/postgres/postgres/src/test/isolation/expected/timeouts.out Thu Jan 8 17:34:22 2026 +++ /home/postgres/postgres/build/testrun/isolation/isolation/results/timeouts.out Thu Jan 8 17:39:05 2026 @@ -11,7 +11,7 @@ step sto: SET statement_timeout = '10ms'; step locktbl: LOCK TABLE accounts; <waiting ...> step locktbl: <... completed> -ERROR: canceling statement due to statement timeout +ERROR: canceling statement due to user request starting permutation: rdtbl lto locktbl step rdtbl: SELECT * FROM accounts; |
| 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/recovery/027_stre...
--- /tmp/cirrus-ci-build/src/test/regress/expected/explain.out 2026-01-08 15:42:58.889435000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/explain.out 2026-01-08 15:49:28.42903900...
@@ -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
... |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/explain.out /tmp/cirrus-ci-build/build/testrun/regress/regress/r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/explain.out 2026-01-08 15:42:58.889435000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/explain.out 2026-01-08 15:47:59.491532000 +0000
@@ -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
... |
| 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-08 13:02:38.406319897 +0000 +++ /home/postgres/postgres/build/testrun/citext/regress/results/citext_utf8.out 2026-01-08 13:04:54.553006846 +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-08 13:02:46.231678288 +0000
+++ /home/postgres/postgres/build/testrun/test_regex/regress/results/test_regex_utf8.out 2026-01-08 13:05:15.818380097 +...
@@ -152,7 +152,7 @@
test_regex
-----------------
{0,REG_ULOCALE}
- {xᔀሷ}
+ {x}
(2 rows)
select * from test_regex('[[:lower:]]+', E'x\u1500\u1237', 'L');
@@ -166,7 +166,7 @@
test_regex
-----------------
{0,REG_ULOCALE}
- {xᔀሷ}
+ {x}
(2 rows)
... |
| 57/5992 | Fix ALTER TABLE DROP EXPRESSION with ONLY option |
| 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-07 01:30:21.591377200 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_stored.out 2026-01-07 01:33:37.431308000 +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-07 01:30:21.592355800 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out 2026-01-07 01:33:54.328777800 +...
@@ -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-07 01:30:21.591377200 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/generated_stored.out 2026-01-07 01:36:34.997589900 ...
@@ -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-07 01:30:21.592355800 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out 2026-01-07 01:36:50.533220500...
@@ -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-07 01:30:21.591377200 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/generated_stored.out 2026-01-07 01:33:30.529968100 +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-07 01:30:21.592355800 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/generated_virtual.out 2026-01-07 01:33:50.027026700 +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-07 01:30:37
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_stored.out 2026-01-07 01:32:32
@@ -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-07 01:30:37
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out 2026-01-07 01:32:35
@@ -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-07 01:30:37
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/generated_stored.out 2026-01-07 01:33:25
@@ -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-07 01:30:37
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out 2026-01-07 01:33:29
@@ -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-07 01:30:37
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/generated_stored.out 2026-01-07 01:32:32
@@ -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-07 01:30:37
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/generated_virtual.out 2026-01-07 01:32:36
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
| Windows - Server 2022, MinGW64 - Meson | |
| regress | diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/generated_stored.out C:/cirrus/build/testrun/pg_upgrade...
--- C:/cirrus/src/test/regress/expected/generated_stored.out 2026-01-07 01:30:36.926499800 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_stored.out 2026-01-07 01:33:34.274230200 +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-07 01:30:36.926499800 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out 2026-01-07 01:33:44.004706500 +...
@@ -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-07 01:30:36.926499800 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/generated_stored.out 2026-01-07 01:36:43.754717300 ...
@@ -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-07 01:30:36.926499800 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out 2026-01-07 01:36:53.940246800...
@@ -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-07 01:30:36.926499800 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/generated_stored.out 2026-01-07 01:33:27.468558200 +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-07 01:30:36.926499800 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/generated_virtual.out 2026-01-07 01:33:38.606756800 +0000
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
| Linux - Debian Trixie - Meson | |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_stored.out /tmp/cirrus-ci-build/build/testrun/pg_upgra...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_stored.out 2026-01-07 01:30:20.069396779 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_stored.out 2026-01-07 01:32:16.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-07 01:30:20.069396779 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out 2026-01-07 01:32:24....
@@ -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-07 01:30:20.069396779 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/generated_stored.out 2026-01-07 01:33:35...
@@ -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-07 01:30:20.069396779 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out 2026-01-07 01:33: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-07 01:30:20.069396779 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/generated_stored.out 2026-01-07 01:32:12.643718419 +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-07 01:30:20.069396779 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/generated_virtual.out 2026-01-07 01:32:20.832181937 +0000
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
| Linux - Debian Trixie - Autoconf | |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_stored.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_stored.out 2026-01-07 01:30:32.488991720 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/generated_stored.out 2026-01-07 01:35:33.129760697 +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-07 01:30:32.488991720 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/generated_virtual.out 2026-01-07 01:35:46.145861077 +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-07 01:30:32.488991720 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/generated_stored.out 2026-01-07 01:37:30.573887031 +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-07 01:30:32.488991720 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/generated_virtual.out 2026-01-07 01:37:38.917851191 +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-07 01:30:32.488991720 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/generated_stored.out 2026-01-07 01:33:47.000536586 +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-07 01:30:32.488991720 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/generated_virtual.out 2026-01-07 01:34:00.656762485 +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 Wed Jan 7 01:30:40 2026
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_stored.out Wed Jan 7 01:32: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 Wed Jan 7 01:30:40 2026
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out Wed Jan 7 01:32:...
@@ -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 Wed Jan 7 01:30:40 2026
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/generated_stored.out Wed Jan 7 01:34...
@@ -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 Wed Jan 7 01:30:40 2026
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out Wed Jan 7 01:3...
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
| regress | diff -U3 /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 Wed Jan 7 01:30:40 2026
+++ /home/postgres/postgres/build/testrun/regress/regress/results/generated_stored.out Wed Jan 7 01:32:40 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 Wed Jan 7 01:30:40 2026
+++ /home/postgres/postgres/build/testrun/regress/regress/results/generated_virtual.out Wed Jan 7 01:32:53 2026
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
| FreeBSD - Meson | |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_stored.out /tmp/cirrus-ci-build/build/testrun/pg_upgra...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_stored.out 2026-01-07 01:30:17.660995000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_stored.out 2026-01-07 01:32:10.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-07 01:30:17.661037000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out 2026-01-07 01:32:25....
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
| regress | diff -U3 /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-07 01:30:17.660995000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/generated_stored.out 2026-01-07 01:33:16...
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out /tmp/cirrus-ci-build/build/testrun/recover...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out 2026-01-07 01:30:17.661037000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out 2026-01-07 01:33: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-07 01:30:17.660995000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/generated_stored.out 2026-01-07 01:32:11.924976000 +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-07 01:30:17.661037000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/generated_virtual.out 2026-01-07 01:32:27.560122000 +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-07 01:30:45.938386032 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_stored.out 2026-01-07 01:32: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 /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-07 01:30:45.939124576 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out 2026-01-07 01:32:...
@@ -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-07 01:30:45.938386032 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/generated_stored.out 2026-01-07 01:32...
@@ -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-07 01:30:45.939124576 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out 2026-01-07 01:3...
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
| regress | diff -U3 /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-07 01:30:45.938386032 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/generated_stored.out 2026-01-07 01:32:06.169511684 +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-07 01:30:45.939124576 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/generated_virtual.out 2026-01-07 01:32:17.118877289 +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
... |