This robot generates gigabytes of CI logs every week. Here is an attempt to
search for "highlights", so it's easier to find actionable information
quickly. New ideas for what patterns to search for are very welcome.
"Current" shows only the most recent results from each submission. The
wider time ranges also show information about historical versions, which
may be useful for flapping tests, and also for hunting for bugs in master.
| 58/6363 |
Add a berief general comment on BTScanInsertData's nextkey and backward |
 |
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/updatable_views.out /home/postgres/postgres/build/testrun/tes...
--- /home/postgres/postgres/src/test/regress/expected/updatable_views.out 2026-03-23 19:45:10.176113535 +0000
+++ /home/postgres/postgres/build/testrun/test_plan_advice/001_replan_regress/data/results/updatable_views.out 2026-03-2...
@@ -1013,6 +1013,9 @@
FROM information_schema.views
WHERE table_name LIKE 'rw_view%'
ORDER BY table_name;
+WARNING: supplied plan advice was not enforced
+DETAIL: advice SEQ_SCAN(pg_trigger@exists_1) feedback is "matched, failed"
+advice NO_GATHER(pg_trigger@exists_1) feedback is "matched, failed"
table_name | is_updatable | is_insertable_into | is_trigger_updatable | is_trigger_deletable | is_trigger_insertable_i...
------------+--------------+--------------------+----------------------+----------------------+------------------------...
rw_view1 | NO | NO | NO | NO | NO |
| 58/5556 |
Expanding HOT updates for expression and partial indexes |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/hot_updates.out C:/cirrus/build/testrun/pg_upgrade/002_...
--- C:/cirrus/src/test/regress/expected/hot_updates.out 2026-03-23 19:26:03.710277100 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/hot_updates.out 2026-03-23 19:32:12.712066900 +0000
@@ -640,7 +640,10 @@
INSERT INTO hot_xml_test VALUES
(1, '<person><name>Alice</name><age>30</age></person>'),
(2, '<person><name>Bob</name><age>25</age></person>');
-ERROR: could not identify a comparison function for type xml
+ERROR: unsupported XML feature
+LINE 2: (1, '<person><name>Alice</name><age>30</age></person>'),
+ ^
+DETAIL: This functionality requires the server to be built with libxml support.
SELECT * FROM get_hot_count('hot_xml_test');
updates | hot
---------+-----
@@ -650,6 +653,10 @@
-- Update non-indexed XPath (age) - behavior depends on XML comparison fallback
-- Full XML value replacement means non-indexed path updates still require index comparison
UPDATE hot_xml_test SET doc = '<person><name>Alice</name><age>31</age></person>' WHERE id = 1;
+ERROR: unsupported XML feature
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/hot_updates.out C:/cirrus/build/testrun/recovery/027_st...
--- C:/cirrus/src/test/regress/expected/hot_updates.out 2026-03-23 19:26:03.710277100 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/hot_updates.out 2026-03-23 19:36:29.848234400 +0000
@@ -640,7 +640,10 @@
INSERT INTO hot_xml_test VALUES
(1, '<person><name>Alice</name><age>30</age></person>'),
(2, '<person><name>Bob</name><age>25</age></person>');
-ERROR: could not identify a comparison function for type xml
+ERROR: unsupported XML feature
+LINE 2: (1, '<person><name>Alice</name><age>30</age></person>'),
+ ^
+DETAIL: This functionality requires the server to be built with libxml support.
SELECT * FROM get_hot_count('hot_xml_test');
updates | hot
---------+-----
@@ -650,6 +653,10 @@
-- Update non-indexed XPath (age) - behavior depends on XML comparison fallback
-- Full XML value replacement means non-indexed path updates still require index comparison
UPDATE hot_xml_test SET doc = '<person><name>Alice</name><age>31</age></person>' WHERE id = 1;
+ERROR: unsupported XML feature
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/hot_updates.out C:/cirrus/build/testrun/regress/regress...
--- C:/cirrus/src/test/regress/expected/hot_updates.out 2026-03-23 19:26:03.710277100 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/hot_updates.out 2026-03-23 19:32:09.330289800 +0000
@@ -640,7 +640,10 @@
INSERT INTO hot_xml_test VALUES
(1, '<person><name>Alice</name><age>30</age></person>'),
(2, '<person><name>Bob</name><age>25</age></person>');
-ERROR: could not identify a comparison function for type xml
+ERROR: unsupported XML feature
+LINE 2: (1, '<person><name>Alice</name><age>30</age></person>'),
+ ^
+DETAIL: This functionality requires the server to be built with libxml support.
SELECT * FROM get_hot_count('hot_xml_test');
updates | hot
---------+-----
@@ -650,6 +653,10 @@
-- Update non-indexed XPath (age) - behavior depends on XML comparison fallback
-- Full XML value replacement means non-indexed path updates still require index comparison
UPDATE hot_xml_test SET doc = '<person><name>Alice</name><age>31</age></person>' WHERE id = 1;
+ERROR: unsupported XML feature
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/hot_updates.out C:/cirrus/build/testrun/test_plan_advic...
--- C:/cirrus/src/test/regress/expected/hot_updates.out 2026-03-23 19:26:03.710277100 +0000
+++ C:/cirrus/build/testrun/test_plan_advice/001_replan_regress/data/results/hot_updates.out 2026-03-23 19:32:07.4039580...
@@ -640,7 +640,10 @@
INSERT INTO hot_xml_test VALUES
(1, '<person><name>Alice</name><age>30</age></person>'),
(2, '<person><name>Bob</name><age>25</age></person>');
-ERROR: could not identify a comparison function for type xml
+ERROR: unsupported XML feature
+LINE 2: (1, '<person><name>Alice</name><age>30</age></person>'),
+ ^
+DETAIL: This functionality requires the server to be built with libxml support.
SELECT * FROM get_hot_count('hot_xml_test');
updates | hot
---------+-----
@@ -650,6 +653,10 @@
-- Update non-indexed XPath (age) - behavior depends on XML comparison fallback
-- Full XML value replacement means non-indexed path updates still require index comparison
UPDATE hot_xml_test SET doc = '<person><name>Alice</name><age>31</age></person>' WHERE id = 1;
+ERROR: unsupported XML feature
... |
| 59/6607 |
New pg_stat_tablespace view for tablespace level metrics |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/partition_prune.out C:/cirrus/build/testrun/pg_upgrade/...
--- C:/cirrus/src/test/regress/expected/partition_prune.out 2026-03-23 19:24:04.804717100 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/partition_prune.out 2026-03-23 19:29:46.960341000 +00...
@@ -3534,1293 +3534,10 @@
insert into boolvalues values('t'),('f');
create table boolp (a bool) partition by list (a);
create table boolp_t partition of boolp for values in('t');
-create table boolp_f partition of boolp for values in('f');
-explain (analyze, costs off, summary off, timing off, buffers off)
-select * from boolp where a = (select value from boolvalues where value);
- QUERY PLAN
---------------------------------------------------------------
- Append (actual rows=0.00 loops=1)
- InitPlan expr_1
- -> Seq Scan on boolvalues (actual rows=1.00 loops=1)
- Filter: value
- Rows Removed by Filter: 1
- -> Seq Scan on boolp_f boolp_1 (never executed)
- Filter: (a = (InitPlan expr_1).col1)
- -> Seq Scan on boolp_t boolp_2 (actual rows=0.00 loops=1)
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/partition_prune.out C:/cirrus/build/testrun/recovery/02...
--- C:/cirrus/src/test/regress/expected/partition_prune.out 2026-03-23 19:24:04.804717100 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/partition_prune.out 2026-03-23 19:33:35.588923800 +...
@@ -3684,1143 +3684,10 @@
-- array type list partition key
create table pp_arrpart (a int[]) partition by list (a);
create table pp_arrpart1 partition of pp_arrpart for values in ('{1}');
-create table pp_arrpart2 partition of pp_arrpart for values in ('{2, 3}', '{4, 5}');
-explain (costs off) select * from pp_arrpart where a = '{1}';
- QUERY PLAN
-------------------------------------
- Seq Scan on pp_arrpart1 pp_arrpart
- Filter: (a = '{1}'::integer[])
-(2 rows)
-
-explain (costs off) select * from pp_arrpart where a = '{1, 2}';
- QUERY PLAN
---------------------------------
- Result
- Replaces: Scan on pp_arrpart
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/stats.out C:/cirrus/build/testrun/regress/regress/resul...
--- C:/cirrus/src/test/regress/expected/stats.out 2026-03-23 19:24:04.937477600 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/stats.out 2026-03-23 19:29:39.460799600 +0000
@@ -1960,83 +1960,7 @@
DROP TABLE table_fillfactor;
-- Test pg_stat_tablespace
SELECT count(*) > 0 FROM pg_stat_tablespace;
- ?column?
-----------
- t
-(1 row)
-
-SELECT tablespace_name FROM pg_stat_tablespace WHERE tablespace_name IN ('pg_default', 'pg_global') ORDER BY tablespace...
- tablespace_name
------------------
- pg_default
- pg_global
-(2 rows)
-
--- Test block stats in pg_stat_tablespace
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/partition_prune.out C:/cirrus/build/testrun/test_plan_a...
--- C:/cirrus/src/test/regress/expected/partition_prune.out 2026-03-23 19:24:04.804717100 +0000
+++ C:/cirrus/build/testrun/test_plan_advice/001_replan_regress/data/results/partition_prune.out 2026-03-23 19:29:45.096...
@@ -3224,1603 +3224,10 @@
select tbl1.col1, tprt.col1 from tbl1
inner join tprt on tbl1.col1 < tprt.col1
order by tbl1.col1, tprt.col1;
- col1 | col1
-------+------
- 4400 | 4500
-(1 row)
-
--- No matching partition
-delete from tbl1;
-insert into tbl1 values (10000);
-explain (analyze, costs off, summary off, timing off, buffers off)
-select * from tbl1 join tprt on tbl1.col1 = tprt.col1;
- QUERY PLAN
--------------------------------------------------------------------
- Nested Loop (actual rows=0.00 loops=1)
... |
|
macOS - Sequoia - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/indexing.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_up...
--- /Users/admin/pgsql/src/test/regress/expected/indexing.out 2026-03-23 19:20:25
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/indexing.out 2026-03-23 19:24:42
@@ -1661,11 +1661,10 @@
select array_agg(n) b from generate_series(1, 10000) n \gset
create index concurrently test_pg_index_toast_index
on test_pg_index_toast_table (test_pg_index_toast_func(a, :'b'));
-reindex index concurrently test_pg_index_toast_index;
-drop index concurrently test_pg_index_toast_index;
-create index test_pg_index_toast_index
- on test_pg_index_toast_table (test_pg_index_toast_func(a, :'b'));
-reindex index test_pg_index_toast_index;
-drop index test_pg_index_toast_index;
-drop function test_pg_index_toast_func;
-drop table test_pg_index_toast_table;
+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
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/indexing.out /Users/admin/pgsql/build/testrun/recovery/027_stream_...
--- /Users/admin/pgsql/src/test/regress/expected/indexing.out 2026-03-23 19:20:25
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/indexing.out 2026-03-23 19:27:11
@@ -1661,11 +1661,10 @@
select array_agg(n) b from generate_series(1, 10000) n \gset
create index concurrently test_pg_index_toast_index
on test_pg_index_toast_table (test_pg_index_toast_func(a, :'b'));
-reindex index concurrently test_pg_index_toast_index;
-drop index concurrently test_pg_index_toast_index;
-create index test_pg_index_toast_index
- on test_pg_index_toast_table (test_pg_index_toast_func(a, :'b'));
-reindex index test_pg_index_toast_index;
-drop index test_pg_index_toast_index;
-drop function test_pg_index_toast_func;
-drop table test_pg_index_toast_table;
+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
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/stats.out /Users/admin/pgsql/build/testrun/regress/regress/results...
--- /Users/admin/pgsql/src/test/regress/expected/stats.out 2026-03-23 19:20:25
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/stats.out 2026-03-23 19:24:41
@@ -1960,83 +1960,7 @@
DROP TABLE table_fillfactor;
-- Test pg_stat_tablespace
SELECT count(*) > 0 FROM pg_stat_tablespace;
- ?column?
-----------
- t
-(1 row)
-
-SELECT tablespace_name FROM pg_stat_tablespace WHERE tablespace_name IN ('pg_default', 'pg_global') ORDER BY tablespace...
- tablespace_name
------------------
- pg_default
- pg_global
-(2 rows)
-
--- Test block stats in pg_stat_tablespace
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/stats.out /Users/admin/pgsql/build/testrun/test_plan_advice/001_re...
--- /Users/admin/pgsql/src/test/regress/expected/stats.out 2026-03-23 19:20:25
+++ /Users/admin/pgsql/build/testrun/test_plan_advice/001_replan_regress/data/results/stats.out 2026-03-23 19:24:42
@@ -1960,83 +1960,7 @@
DROP TABLE table_fillfactor;
-- Test pg_stat_tablespace
SELECT count(*) > 0 FROM pg_stat_tablespace;
- ?column?
-----------
- t
-(1 row)
-
-SELECT tablespace_name FROM pg_stat_tablespace WHERE tablespace_name IN ('pg_default', 'pg_global') ORDER BY tablespace...
- tablespace_name
------------------
- pg_default
- pg_global
-(2 rows)
-
--- Test block stats in pg_stat_tablespace
... |
|
Windows - Server 2022, MinGW64 - Meson |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/stats.out C:/cirrus/build/testrun/pg_upgrade/002_pg_upg...
--- C:/cirrus/src/test/regress/expected/stats.out 2026-03-23 19:23:27.840891900 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/stats.out 2026-03-23 19:30:03.535475100 +0000
@@ -1960,83 +1960,7 @@
DROP TABLE table_fillfactor;
-- Test pg_stat_tablespace
SELECT count(*) > 0 FROM pg_stat_tablespace;
- ?column?
-----------
- t
-(1 row)
-
-SELECT tablespace_name FROM pg_stat_tablespace WHERE tablespace_name IN ('pg_default', 'pg_global') ORDER BY tablespace...
- tablespace_name
------------------
- pg_default
- pg_global
-(2 rows)
-
--- Test block stats in pg_stat_tablespace
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/partition_prune.out C:/cirrus/build/testrun/recovery/02...
--- C:/cirrus/src/test/regress/expected/partition_prune.out 2026-03-23 19:23:27.787731700 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/partition_prune.out 2026-03-23 19:34:01.308595700 +...
@@ -4338,489 +4338,7 @@
\gexec
create table hp_prefix_test_p0 partition of hp_prefix_test for values with (modulus 8, remainder 0);
create table hp_prefix_test_p1 partition of hp_prefix_test for values with (modulus 8, remainder 1);
-create table hp_prefix_test_p2 partition of hp_prefix_test for values with (modulus 8, remainder 2);
-create table hp_prefix_test_p3 partition of hp_prefix_test for values with (modulus 8, remainder 3);
-create table hp_prefix_test_p4 partition of hp_prefix_test for values with (modulus 8, remainder 4);
-create table hp_prefix_test_p5 partition of hp_prefix_test for values with (modulus 8, remainder 5);
-create table hp_prefix_test_p6 partition of hp_prefix_test for values with (modulus 8, remainder 6);
-create table hp_prefix_test_p7 partition of hp_prefix_test for values with (modulus 8, remainder 7);
--- insert 16 rows, one row for each test to perform.
-insert into hp_prefix_test
-select
- case a when 0 then null else 1 end,
- case b when 0 then null else 2 end,
- case c when 0 then null else 3 end,
- case d when 0 then null else 4 end
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/stats.out C:/cirrus/build/testrun/regress/regress/resul...
--- C:/cirrus/src/test/regress/expected/stats.out 2026-03-23 19:23:27.840891900 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/stats.out 2026-03-23 19:29:50.771801100 +0000
@@ -1960,83 +1960,7 @@
DROP TABLE table_fillfactor;
-- Test pg_stat_tablespace
SELECT count(*) > 0 FROM pg_stat_tablespace;
- ?column?
-----------
- t
-(1 row)
-
-SELECT tablespace_name FROM pg_stat_tablespace WHERE tablespace_name IN ('pg_default', 'pg_global') ORDER BY tablespace...
- tablespace_name
------------------
- pg_default
- pg_global
-(2 rows)
-
--- Test block stats in pg_stat_tablespace
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/stats.out C:/cirrus/build/testrun/test_plan_advice/001_...
--- C:/cirrus/src/test/regress/expected/stats.out 2026-03-23 19:23:27.840891900 +0000
+++ C:/cirrus/build/testrun/test_plan_advice/001_replan_regress/data/results/stats.out 2026-03-23 19:30:01.689768300 +00...
@@ -1960,83 +1960,7 @@
DROP TABLE table_fillfactor;
-- Test pg_stat_tablespace
SELECT count(*) > 0 FROM pg_stat_tablespace;
- ?column?
-----------
- t
-(1 row)
-
-SELECT tablespace_name FROM pg_stat_tablespace WHERE tablespace_name IN ('pg_default', 'pg_global') ORDER BY tablespace...
- tablespace_name
------------------
- pg_default
- pg_global
-(2 rows)
-
--- Test block stats in pg_stat_tablespace
... |
|
Linux - Debian Trixie - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/partition_merge.out /tmp/cirrus-ci-build/build/testrun/pg_upgrad...
--- /tmp/cirrus-ci-build/src/test/regress/expected/partition_merge.out 2026-03-23 19:20:31.683748315 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/partition_merge.out 2026-03-23 19:26:23.07...
@@ -1061,37 +1061,7 @@
-- Test for generated columns (different order of columns in partitioned table
-- and partitions).
CREATE TABLE t (i int, g int GENERATED ALWAYS AS (i + tableoid::int)) PARTITION BY RANGE (i);
-CREATE TABLE tp_1 (g int GENERATED ALWAYS AS (i + tableoid::int), i int);
-CREATE TABLE tp_2 (g int GENERATED ALWAYS AS (i + tableoid::int), i int);
-ALTER TABLE t ATTACH PARTITION tp_1 FOR VALUES FROM (-1) TO (10);
-ALTER TABLE t ATTACH PARTITION tp_2 FOR VALUES FROM (10) TO (20);
-ALTER TABLE t ADD CHECK (g > 0);
-ALTER TABLE t ADD CHECK (i > 0);
-INSERT INTO t VALUES (5), (15);
-ALTER TABLE t MERGE PARTITIONS (tp_1, tp_2) INTO tp_12;
-INSERT INTO t VALUES (16);
--- ERROR: new row for relation "tp_12" violates check constraint "t_i_check"
-INSERT INTO t VALUES (0);
-ERROR: new row for relation "tp_12" violates check constraint "t_i_check"
-DETAIL: Failing row contains (0, virtual).
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/partition_merge.out /tmp/cirrus-ci-build/build/testrun/recovery/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/partition_merge.out 2026-03-23 19:20:31.683748315 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/partition_merge.out 2026-03-23 19:27:54....
@@ -652,446 +652,10 @@
ALTER TABLE t MERGE PARTITIONS (tp_1_2, tp_0_1) INTO tp_1_2;
-- Indexname values should be 'tp_1_2_pkey' and 'tp_1_2_i_idx'.
\d+ tp_1_2
- Table "partitions_merge_schema.tp_1_2"
- Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
---------+---------+-----------+----------+---------+---------+--------------+-------------
- i | integer | | not null | | plain | |
-Partition of: t FOR VALUES FROM (0) TO (2)
-Partition constraint: ((i IS NOT NULL) AND (i >= 0) AND (i < 2))
-Indexes:
- "tp_1_2_pkey" PRIMARY KEY, btree (i)
- "tp_1_2_i_idx" btree (i)
-Not-null constraints:
- "t_i_not_null" NOT NULL "i" (inherited)
-
-DROP TABLE t;
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/partition_join.out /tmp/cirrus-ci-build/build/testrun/regress/re...
--- /tmp/cirrus-ci-build/src/test/regress/expected/partition_join.out 2026-03-23 19:20:31.683748315 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/partition_join.out 2026-03-23 19:26:23.667035352 +0000
@@ -4190,1185 +4190,7 @@
(21 rows)
SELECT t1.a, t1.c, t2.a, t2.c FROM plt1_adv t1 LEFT JOIN plt2_adv t2 ON (t1.a = t2.a AND t1.c = t2.c) WHERE t1.b < 10 O...
- a | c | a | c
-----+------+---+------
- -1 | | |
- 1 | 0001 | |
- 3 | 0003 | 3 | 0003
- 4 | 0004 | 4 | 0004
- 6 | 0006 | 6 | 0006
- 8 | 0008 | |
- 9 | 0009 | 9 | 0009
-(7 rows)
-
--- anti join
-EXPLAIN (COSTS OFF)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/partition_join.out /tmp/cirrus-ci-build/build/testrun/test_plan_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/partition_join.out 2026-03-23 19:20:31.683748315 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/partition_join.out 2026-03-23 19...
@@ -3760,1615 +3760,7 @@
-- semi join
EXPLAIN (COSTS OFF)
SELECT t1.* FROM plt1_adv t1 WHERE EXISTS (SELECT 1 FROM plt2_adv t2 WHERE t1.a = t2.a AND t1.c = t2.c) AND t1.b < 10 O...
- QUERY PLAN
---------------------------------------------------------------------
- Sort
- Sort Key: t1.a
- -> Append
- -> Hash Right Semi Join
- Hash Cond: ((t2_1.a = t1_1.a) AND (t2_1.c = t1_1.c))
- -> Seq Scan on plt2_adv_p1 t2_1
- -> Hash
- -> Seq Scan on plt1_adv_p1 t1_1
- Filter: (b < 10)
- -> Hash Right Semi Join
- Hash Cond: ((t2_2.a = t1_2.a) AND (t2_2.c = t1_2.c))
... |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/partition_split.out /home/postgres/postgres/build/testrun/pg_...
--- /home/postgres/postgres/src/test/regress/expected/partition_split.out 2026-03-23 19:23:39.415708076 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/partition_split.out 2026-03-23 19:27:45...
@@ -1333,260 +1333,10 @@
ALTER TABLE t_bigint SPLIT PARTITION t_bigint_default INTO
(PARTITION t_bigint_01_10 FOR VALUES FROM (0) TO (10),
PARTITION t_bigint_default DEFAULT);
--- Show defaults/constraints after SPLIT PARTITION
-\d+ t_bigint_default
- Table "partition_split_schema.t_bigint_default"
- Column | Type | Collation | Nullable | Default | Storage | Stats target | Description...
---------+---------+-----------+----------+---------------------------------------+---------+--------------+------------...
- b | bigint | | | | plain | |
- i | integer | | | 3 + 10 | plain | |
- j | integer | | | 101 | plain | |
- k | integer | | | generated always as ((b + 10)) stored | plain | |
-Partition of: t_bigint DEFAULT
-Partition constraint: (NOT ((b IS NOT NULL) AND ((b >= '0'::bigint) AND (b < '10'::bigint))))
-
-\d+ t_bigint_01_10
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/partition_join.out /home/postgres/postgres/build/testrun/reco...
--- /home/postgres/postgres/src/test/regress/expected/partition_join.out 2026-03-23 19:23:39.408583323 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/partition_join.out 2026-03-23 19:28:4...
@@ -2672,2703 +2672,10 @@
-- semi join
EXPLAIN (COSTS OFF)
SELECT t1.* FROM prt1_adv t1 WHERE EXISTS (SELECT 1 FROM prt2_adv t2 WHERE t1.a = t2.b) AND t1.b = 0 ORDER BY t1.a;
- QUERY PLAN
-------------------------------------------------------
- Sort
- Sort Key: t1.a
- -> Append
- -> Hash Right Semi Join
- Hash Cond: (t2_1.b = t1_1.a)
- -> Seq Scan on prt2_adv_p1 t2_1
- -> Hash
- -> Seq Scan on prt1_adv_p1 t1_1
- Filter: (b = 0)
- -> Hash Right Semi Join
- Hash Cond: (t2_2.b = t1_2.a)
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/partition_prune.out /home/postgres/postgres/build/testrun/reg...
--- /home/postgres/postgres/src/test/regress/expected/partition_prune.out 2026-03-23 19:23:39.413776866 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/partition_prune.out 2026-03-23 19:27:51.679781477 +000...
@@ -3529,1298 +3529,10 @@
deallocate ps2;
drop table mc3p;
--- Ensure runtime pruning works with initplans params with boolean types
-create table boolvalues (value bool not null);
-insert into boolvalues values('t'),('f');
-create table boolp (a bool) partition by list (a);
-create table boolp_t partition of boolp for values in('t');
-create table boolp_f partition of boolp for values in('f');
-explain (analyze, costs off, summary off, timing off, buffers off)
-select * from boolp where a = (select value from boolvalues where value);
- QUERY PLAN
---------------------------------------------------------------
- Append (actual rows=0.00 loops=1)
- InitPlan expr_1
- -> Seq Scan on boolvalues (actual rows=1.00 loops=1)
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/partition_join.out /home/postgres/postgres/build/testrun/test...
--- /home/postgres/postgres/src/test/regress/expected/partition_join.out 2026-03-23 19:23:39.408583323 +0000
+++ /home/postgres/postgres/build/testrun/test_plan_advice/001_replan_regress/data/results/partition_join.out 2026-03-23...
@@ -3524,1851 +3524,10 @@
CREATE TABLE plt2_adv (a int, b int, c text) PARTITION BY LIST (c);
CREATE TABLE plt2_adv_p1 PARTITION OF plt2_adv FOR VALUES IN ('0002', '0003');
CREATE TABLE plt2_adv_p2 PARTITION OF plt2_adv FOR VALUES IN ('0004', '0006');
-CREATE TABLE plt2_adv_p3 PARTITION OF plt2_adv FOR VALUES IN ('0007', '0009');
-INSERT INTO plt2_adv SELECT i, i, to_char(i % 10, 'FM0000') FROM generate_series(1, 299) i WHERE i % 10 IN (2, 3, 4, 6,...
-ANALYZE plt2_adv;
--- inner join
-EXPLAIN (COSTS OFF)
-SELECT t1.a, t1.c, t2.a, t2.c FROM plt1_adv t1 INNER JOIN plt2_adv t2 ON (t1.a = t2.a AND t1.c = t2.c) WHERE t1.b < 10 ...
- QUERY PLAN
---------------------------------------------------------------------
- Sort
- Sort Key: t1.a
- -> Append
- -> Hash Join
- Hash Cond: ((t2_1.a = t1_1.a) AND (t2_1.c = t1_1.c))
... |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/partition_prune.out /tmp/cirrus-ci-build/build/testrun/pg_upgrad...
--- /tmp/cirrus-ci-build/src/test/regress/expected/partition_prune.out 2026-03-23 19:21:05.578321000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/partition_prune.out 2026-03-23 19:27:02.26...
@@ -2613,2214 +2613,10 @@
(27 rows)
select explain_parallel_append('select avg(ab.a) from ab inner join lprt_a a on ab.a = a.a where a.a in(1, 0, 0)');
- explain_parallel_append
---------------------------------------------------------------------------------------------------------
- Finalize Aggregate (actual rows=N loops=N)
- -> Gather (actual rows=N loops=N)
- Workers Planned: 1
- Workers Launched: N
- -> Partial Aggregate (actual rows=N loops=N)
- -> Nested Loop (actual rows=N loops=N)
- -> Parallel Seq Scan on lprt_a a (actual rows=N loops=N)
- Filter: (a = ANY ('{1,0,0}'::integer[]))
- Rows Removed by Filter: N
- -> Append (actual rows=N loops=N)
- -> Index Scan using ab_a1_b1_a_idx on ab_a1_b1 ab_1 (actual rows=N loops=N)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/partition_merge.out /tmp/cirrus-ci-build/build/testrun/recovery/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/partition_merge.out 2026-03-23 19:21:05.576813000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/partition_merge.out 2026-03-23 19:28:08....
@@ -945,153 +945,10 @@
tp_0_1_before_insert_row_trigger BEFORE INSERT ON tp_0_1 FOR EACH ROW EXECUTE FUNCTION trigger_function('tp_0_1')
ALTER TABLE t MERGE PARTITIONS (tp_0_1, tp_1_2) INTO tp_0_1;
-\d+ tp_0_1
- Table "partitions_merge_schema.tp_0_1"
- Column | Type | Collation | Nullable | Default | Storage | Compression | S...
---------+---------+-----------+----------+-------------------------------------------------+----------+-------------+--...
- i | integer | | not null | | plain | | ...
- t | text | | | 'default_t'::text | extended | pglz | ...
- b | bigint | | not null | | plain | | ...
- d | date | | | generated always as ('01-01-2022'::date) stored | plain | | ...
-Partition of: t FOR VALUES FROM (0) TO (2)
-Partition constraint: ((abs(i) IS NOT NULL) AND (abs(i) >= 0) AND (abs(i) < 2))
-Check constraints:
- "t_b_check" CHECK (b > 0)
- "t_b_check1" CHECK (b > 0) NOT ENFORCED
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/partition_prune.out /tmp/cirrus-ci-build/build/testrun/regress/r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/partition_prune.out 2026-03-23 19:21:05.578321000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/partition_prune.out 2026-03-23 19:27:08.079735000 +0000
@@ -2613,2214 +2613,10 @@
(27 rows)
select explain_parallel_append('select avg(ab.a) from ab inner join lprt_a a on ab.a = a.a where a.a in(1, 0, 0)');
- explain_parallel_append
---------------------------------------------------------------------------------------------------------
- Finalize Aggregate (actual rows=N loops=N)
- -> Gather (actual rows=N loops=N)
- Workers Planned: 1
- Workers Launched: N
- -> Partial Aggregate (actual rows=N loops=N)
- -> Nested Loop (actual rows=N loops=N)
- -> Parallel Seq Scan on lprt_a a (actual rows=N loops=N)
- Filter: (a = ANY ('{1,0,0}'::integer[]))
- Rows Removed by Filter: N
- -> Append (actual rows=N loops=N)
- -> Index Scan using ab_a1_b1_a_idx on ab_a1_b1 ab_1 (actual rows=N loops=N)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/partition_prune.out /tmp/cirrus-ci-build/build/testrun/test_plan...
--- /tmp/cirrus-ci-build/src/test/regress/expected/partition_prune.out 2026-03-23 19:21:05.578321000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/partition_prune.out 2026-03-23 1...
@@ -4177,650 +4177,10 @@
-- Ensure that listp_12_2 is not scanned. (The nested Append is not seen in
-- the plan as it's pulled in setref.c due to having just a single subnode).
select explain_parallel_append('select * from listp where a = (select 1);');
- explain_parallel_append
-----------------------------------------------------------------------
- Gather (actual rows=N loops=N)
- Workers Planned: 2
- Workers Launched: N
- InitPlan expr_1
- -> Result (actual rows=N loops=N)
- -> Parallel Append (actual rows=N loops=N)
- -> Seq Scan on listp_12_1 listp_1 (actual rows=N loops=N)
- Filter: (a = (InitPlan expr_1).col1)
- -> Parallel Seq Scan on listp_12_2 listp_2 (never executed)
- Filter: (a = (InitPlan expr_1).col1)
-(10 rows)
... |
|
Linux - Debian Trixie - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/partition_merge.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/partition_merge.out 2026-03-23 19:21:19.014610363 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/partition_merge.out 2026-03-23 19:32:13.149354030 +0000
@@ -1058,40 +1058,10 @@
(1 row)
DROP TABLE t;
--- Test for generated columns (different order of columns in partitioned table
--- and partitions).
-CREATE TABLE t (i int, g int GENERATED ALWAYS AS (i + tableoid::int)) PARTITION BY RANGE (i);
-CREATE TABLE tp_1 (g int GENERATED ALWAYS AS (i + tableoid::int), i int);
-CREATE TABLE tp_2 (g int GENERATED ALWAYS AS (i + tableoid::int), i int);
-ALTER TABLE t ATTACH PARTITION tp_1 FOR VALUES FROM (-1) TO (10);
-ALTER TABLE t ATTACH PARTITION tp_2 FOR VALUES FROM (10) TO (20);
-ALTER TABLE t ADD CHECK (g > 0);
-ALTER TABLE t ADD CHECK (i > 0);
-INSERT INTO t VALUES (5), (15);
-ALTER TABLE t MERGE PARTITIONS (tp_1, tp_2) INTO tp_12;
-INSERT INTO t VALUES (16);
--- ERROR: new row for relation "tp_12" violates check constraint "t_i_check"
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/partition_merge.out /tmp/cirrus-ci-build/src/test/modules/test_p...
--- /tmp/cirrus-ci-build/src/test/regress/expected/partition_merge.out 2026-03-23 19:21:19.014610363 +0000
+++ /tmp/cirrus-ci-build/src/test/modules/test_plan_advice/tmp_check/results/partition_merge.out 2026-03-23 19:31:59.009...
@@ -1061,37 +1061,7 @@
-- Test for generated columns (different order of columns in partitioned table
-- and partitions).
CREATE TABLE t (i int, g int GENERATED ALWAYS AS (i + tableoid::int)) PARTITION BY RANGE (i);
-CREATE TABLE tp_1 (g int GENERATED ALWAYS AS (i + tableoid::int), i int);
-CREATE TABLE tp_2 (g int GENERATED ALWAYS AS (i + tableoid::int), i int);
-ALTER TABLE t ATTACH PARTITION tp_1 FOR VALUES FROM (-1) TO (10);
-ALTER TABLE t ATTACH PARTITION tp_2 FOR VALUES FROM (10) TO (20);
-ALTER TABLE t ADD CHECK (g > 0);
-ALTER TABLE t ADD CHECK (i > 0);
-INSERT INTO t VALUES (5), (15);
-ALTER TABLE t MERGE PARTITIONS (tp_1, tp_2) INTO tp_12;
-INSERT INTO t VALUES (16);
--- ERROR: new row for relation "tp_12" violates check constraint "t_i_check"
-INSERT INTO t VALUES (0);
-ERROR: new row for relation "tp_12" violates check constraint "t_i_check"
-DETAIL: Failing row contains (0, virtual).
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/partition_merge.out /tmp/cirrus-ci-build/src/test/recovery/tmp_c...
--- /tmp/cirrus-ci-build/src/test/regress/expected/partition_merge.out 2026-03-23 19:21:19.014610363 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/partition_merge.out 2026-03-23 19:32:56.933413734 +0000
@@ -922,176 +922,10 @@
CREATE TRIGGER tp_1_2_before_insert_row_trigger BEFORE INSERT ON tp_1_2 FOR EACH ROW
EXECUTE PROCEDURE trigger_function('tp_1_2');
\d+ tp_0_1
- Table "partitions_merge_schema.tp_0_1"
- Column | Type | Collation | Nullable | Default | Storage | Compression | St...
---------+---------+-----------+----------+-------------------------------------------------+---------+-------------+---...
- i | integer | | not null | | plain | | ...
- t | text | | | 'default_tp_0_1'::text | main | | ...
- b | bigint | | not null | | plain | | ...
- d | date | | | generated always as ('02-02-2022'::date) stored | plain | | ...
-Partition of: t FOR VALUES FROM (0) TO (1)
-Partition constraint: ((abs(i) IS NOT NULL) AND (abs(i) >= 0) AND (abs(i) < 1))
-Check constraints:
- "t_b_check" CHECK (b > 0)
- "t_b_check1" CHECK (b > 0) NOT ENFORCED
- "t_b_check2" CHECK (b > 0) NOT VALID
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/partition_split.out /tmp/cirrus-ci-build/src/test/regress/result...
--- /tmp/cirrus-ci-build/src/test/regress/expected/partition_split.out 2026-03-23 19:21:19.014610363 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/partition_split.out 2026-03-23 19:28:03.185720258 +0000
@@ -1335,258 +1335,10 @@
PARTITION t_bigint_default DEFAULT);
-- Show defaults/constraints after SPLIT PARTITION
\d+ t_bigint_default
- Table "partition_split_schema.t_bigint_default"
- Column | Type | Collation | Nullable | Default | Storage | Stats target | Description...
---------+---------+-----------+----------+---------------------------------------+---------+--------------+------------...
- b | bigint | | | | plain | |
- i | integer | | | 3 + 10 | plain | |
- j | integer | | | 101 | plain | |
- k | integer | | | generated always as ((b + 10)) stored | plain | |
-Partition of: t_bigint DEFAULT
-Partition constraint: (NOT ((b IS NOT NULL) AND ((b >= '0'::bigint) AND (b < '10'::bigint))))
-
-\d+ t_bigint_01_10
- Table "partition_split_schema.t_bigint_01_10"
- Column | Type | Collation | Nullable | Default | Storage | Stats target | Description...
... |
| 58/6131 |
Add pg_get_trigger_ddl() to retrieve the CREATE TRIGGER statement |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/updatable_views.out /home/postgres/postgres/build/testrun/tes...
--- /home/postgres/postgres/src/test/regress/expected/updatable_views.out 2026-03-23 15:52:24.219465586 +0000
+++ /home/postgres/postgres/build/testrun/test_plan_advice/001_replan_regress/data/results/updatable_views.out 2026-03-2...
@@ -1071,6 +1071,13 @@
FROM information_schema.views
WHERE table_name LIKE 'rw_view%'
ORDER BY table_name;
+WARNING: supplied plan advice was not enforced
+DETAIL: advice SEQ_SCAN(pg_trigger@exists_2) feedback is "matched, failed"
+advice SEQ_SCAN(pg_trigger@exists_4) feedback is "matched, failed"
+advice SEQ_SCAN(pg_trigger@exists_6) feedback is "matched, failed"
+advice NO_GATHER(pg_trigger@exists_2) feedback is "matched, failed"
+advice NO_GATHER(pg_trigger@exists_4) feedback is "matched, failed"
+advice NO_GATHER(pg_trigger@exists_6) feedback is "matched, failed"
table_name | is_updatable | is_insertable_into | is_trigger_updatable | is_trigger_deletable | is_trigger_insertable_i...
------------+--------------+--------------------+----------------------+----------------------+------------------------...
rw_view1 | NO | NO | NO | NO | YES |
| 58/6287 |
Change comment in `contrib/amcheck` regression suite |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/updatable_views.out /tmp/cirrus-ci-build/build/testrun/test_plan...
--- /tmp/cirrus-ci-build/src/test/regress/expected/updatable_views.out 2026-03-23 14:59:18.729312000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/updatable_views.out 2026-03-23 1...
@@ -1071,6 +1071,9 @@
FROM information_schema.views
WHERE table_name LIKE 'rw_view%'
ORDER BY table_name;
+WARNING: supplied plan advice was not enforced
+DETAIL: advice SEQ_SCAN(pg_trigger@exists_4) feedback is "matched, failed"
+advice NO_GATHER(pg_trigger@exists_4) feedback is "matched, failed"
table_name | is_updatable | is_insertable_into | is_trigger_updatable | is_trigger_deletable | is_trigger_insertable_i...
------------+--------------+--------------------+----------------------+----------------------+------------------------...
rw_view1 | NO | NO | NO | NO | YES |
| 58/6543 |
synchronized_standby_slots behavior inconsistent with quorum-based synchronous replication |
|
Windows - Server 2022, MinGW64 - Meson |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/modules/unsafe_tests/expected/guc_privs.out C:/cirrus/build/testrun/unsa...
--- C:/cirrus/src/test/modules/unsafe_tests/expected/guc_privs.out 2026-03-23 11:13:10.778404000 +0000
+++ C:/cirrus/build/testrun/unsafe_tests/regress/results/guc_privs.out 2026-03-23 11:23:37.794974400 +0000
@@ -590,8 +590,7 @@
-- Cannot set synchronized_standby_slots to an invalid slot name
ALTER SYSTEM SET synchronized_standby_slots='invalid*';
ERROR: invalid value for parameter "synchronized_standby_slots": "invalid*"
-DETAIL: replication slot name "invalid*" contains invalid character
-HINT: Replication slot names may only contain lower case letters, numbers, and the underscore character.
+DETAIL: syntax error at or near "*"
-- Can set synchronized_standby_slots to a non-existent slot name
ALTER SYSTEM SET synchronized_standby_slots='missing';
-- Reset the GUC |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/modules/unsafe_tests/expected/guc_privs.out C:/cirrus/build/testrun/unsa...
--- C:/cirrus/src/test/modules/unsafe_tests/expected/guc_privs.out 2026-03-23 11:11:52.536361000 +0000
+++ C:/cirrus/build/testrun/unsafe_tests/regress/results/guc_privs.out 2026-03-23 11:22:58.115055300 +0000
@@ -590,8 +590,7 @@
-- Cannot set synchronized_standby_slots to an invalid slot name
ALTER SYSTEM SET synchronized_standby_slots='invalid*';
ERROR: invalid value for parameter "synchronized_standby_slots": "invalid*"
-DETAIL: replication slot name "invalid*" contains invalid character
-HINT: Replication slot names may only contain lower case letters, numbers, and the underscore character.
+DETAIL: syntax error at or near "*"
-- Can set synchronized_standby_slots to a non-existent slot name
ALTER SYSTEM SET synchronized_standby_slots='missing';
-- Reset the GUC |
|
macOS - Sequoia - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/modules/unsafe_tests/expected/guc_privs.out /Users/admin/pgsql/build/testrun/unsafe...
--- /Users/admin/pgsql/src/test/modules/unsafe_tests/expected/guc_privs.out 2026-03-23 11:11:28
+++ /Users/admin/pgsql/build/testrun/unsafe_tests/regress/results/guc_privs.out 2026-03-23 11:16:25
@@ -590,8 +590,7 @@
-- Cannot set synchronized_standby_slots to an invalid slot name
ALTER SYSTEM SET synchronized_standby_slots='invalid*';
ERROR: invalid value for parameter "synchronized_standby_slots": "invalid*"
-DETAIL: replication slot name "invalid*" contains invalid character
-HINT: Replication slot names may only contain lower case letters, numbers, and the underscore character.
+DETAIL: syntax error at or near "*"
-- Can set synchronized_standby_slots to a non-existent slot name
ALTER SYSTEM SET synchronized_standby_slots='missing';
-- Reset the GUC |
|
Linux - Debian Trixie - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/modules/unsafe_tests/expected/guc_privs.out /tmp/cirrus-ci-build/build/testrun/un...
--- /tmp/cirrus-ci-build/src/test/modules/unsafe_tests/expected/guc_privs.out 2026-03-23 11:12:03.621931397 +0000
+++ /tmp/cirrus-ci-build/build/testrun/unsafe_tests/regress/results/guc_privs.out 2026-03-23 11:17:21.753451625 +0000
@@ -590,8 +590,7 @@
-- Cannot set synchronized_standby_slots to an invalid slot name
ALTER SYSTEM SET synchronized_standby_slots='invalid*';
ERROR: invalid value for parameter "synchronized_standby_slots": "invalid*"
-DETAIL: replication slot name "invalid*" contains invalid character
-HINT: Replication slot names may only contain lower case letters, numbers, and the underscore character.
+DETAIL: syntax error at or near "*"
-- Can set synchronized_standby_slots to a non-existent slot name
ALTER SYSTEM SET synchronized_standby_slots='missing';
-- Reset the GUC |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/modules/unsafe_tests/expected/guc_privs.out /tmp/cirrus-ci-build/build/testrun/un...
--- /tmp/cirrus-ci-build/src/test/modules/unsafe_tests/expected/guc_privs.out 2026-03-23 11:11:51.467929000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/unsafe_tests/regress/results/guc_privs.out 2026-03-23 11:17:22.083960000 +0000
@@ -590,8 +590,7 @@
-- Cannot set synchronized_standby_slots to an invalid slot name
ALTER SYSTEM SET synchronized_standby_slots='invalid*';
ERROR: invalid value for parameter "synchronized_standby_slots": "invalid*"
-DETAIL: replication slot name "invalid*" contains invalid character
-HINT: Replication slot names may only contain lower case letters, numbers, and the underscore character.
+DETAIL: syntax error at or near "*"
-- Can set synchronized_standby_slots to a non-existent slot name
ALTER SYSTEM SET synchronized_standby_slots='missing';
-- Reset the GUC |
|
Linux - Debian Trixie - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/modules/unsafe_tests/expected/guc_privs.out /tmp/cirrus-ci-build/src/test/modules...
--- /tmp/cirrus-ci-build/src/test/modules/unsafe_tests/expected/guc_privs.out 2026-03-23 11:13:34.519414666 +0000
+++ /tmp/cirrus-ci-build/src/test/modules/unsafe_tests/results/guc_privs.out 2026-03-23 11:21:59.437637262 +0000
@@ -590,8 +590,7 @@
-- Cannot set synchronized_standby_slots to an invalid slot name
ALTER SYSTEM SET synchronized_standby_slots='invalid*';
ERROR: invalid value for parameter "synchronized_standby_slots": "invalid*"
-DETAIL: replication slot name "invalid*" contains invalid character
-HINT: Replication slot names may only contain lower case letters, numbers, and the underscore character.
+DETAIL: syntax error at or near "*"
-- Can set synchronized_standby_slots to a non-existent slot name
ALTER SYSTEM SET synchronized_standby_slots='missing';
-- Reset the GUC |
|
OpenBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/modules/unsafe_tests/expected/guc_privs.out /home/postgres/postgres/build/test...
--- /home/postgres/postgres/src/test/modules/unsafe_tests/expected/guc_privs.out Mon Mar 23 11:12:09 2026
+++ /home/postgres/postgres/build/testrun/unsafe_tests/regress/results/guc_privs.out Mon Mar 23 11:18:31 2026
@@ -590,8 +590,7 @@
-- Cannot set synchronized_standby_slots to an invalid slot name
ALTER SYSTEM SET synchronized_standby_slots='invalid*';
ERROR: invalid value for parameter "synchronized_standby_slots": "invalid*"
-DETAIL: replication slot name "invalid*" contains invalid character
-HINT: Replication slot names may only contain lower case letters, numbers, and the underscore character.
+DETAIL: syntax error at or near "*"
-- Can set synchronized_standby_slots to a non-existent slot name
ALTER SYSTEM SET synchronized_standby_slots='missing';
-- Reset the GUC |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/modules/unsafe_tests/expected/guc_privs.out /home/postgres/postgres/build/test...
--- /home/postgres/postgres/src/test/modules/unsafe_tests/expected/guc_privs.out 2026-03-23 11:13:27.777429299 +0000
+++ /home/postgres/postgres/build/testrun/unsafe_tests/regress/results/guc_privs.out 2026-03-23 11:16:32.560302494 +0000
@@ -590,8 +590,7 @@
-- Cannot set synchronized_standby_slots to an invalid slot name
ALTER SYSTEM SET synchronized_standby_slots='invalid*';
ERROR: invalid value for parameter "synchronized_standby_slots": "invalid*"
-DETAIL: replication slot name "invalid*" contains invalid character
-HINT: Replication slot names may only contain lower case letters, numbers, and the underscore character.
+DETAIL: syntax error at or near "*"
-- Can set synchronized_standby_slots to a non-existent slot name
ALTER SYSTEM SET synchronized_standby_slots='missing';
-- Reset the GUC |
| 58/6535 |
Dump statistic issue with index on expressions |
|
macOS - Sequoia - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/updatable_views.out /Users/admin/pgsql/build/testrun/test_plan_adv...
--- /Users/admin/pgsql/src/test/regress/expected/updatable_views.out 2026-03-23 04:08:10
+++ /Users/admin/pgsql/build/testrun/test_plan_advice/001_replan_regress/data/results/updatable_views.out 2026-03-23 04:...
@@ -2634,6 +2634,9 @@
Options: check_option=local
SELECT * FROM information_schema.views WHERE table_name = 'rw_view2';
+WARNING: supplied plan advice was not enforced
+DETAIL: advice SEQ_SCAN(pg_trigger@exists_3) feedback is "matched, failed"
+advice NO_GATHER(pg_trigger@exists_3) feedback is "matched, failed"
table_catalog | table_schema | table_name | view_definition | check_option | is_updatable | is_insertable_into | is_...
---------------+--------------+------------+-------------------+--------------+--------------+--------------------+----...
regression | public | rw_view2 | SELECT a +| LOCAL | YES | YES | NO ... |
| 58/5444 |
using index to speedup add not null constraints to a table |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/constraints.out C:/cirrus/build/testrun/pg_upgrade/002_...
--- C:/cirrus/src/test/regress/expected/constraints.out 2026-03-23 03:42:17.141749500 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/constraints.out 2026-03-23 03:45:50.970030700 +0000
@@ -1822,6 +1822,7 @@
DEBUG: all new not-null constraints on relation "tp_notnull_1" have been validated by using index scan
--debug message should contain "have been validated by using index scan"
ALTER TABLE tp_notnull_2 ALTER COLUMN b SET NOT NULL;
+DEBUG: rehashing catalog cache id 64 for pg_class; 257 tups, 128 buckets
DEBUG: all new not-null constraints on relation "tp_notnull_2" have been validated by using index scan
ALTER TABLE tp_notnull_2 ADD CONSTRAINT nn_d NOT NULL d NOT VALID;
--debug message should not contain "have been validated by using index scan"
@@ -1845,6 +1846,7 @@
ALTER TABLE tp_notnull ALTER COLUMN b DROP NOT NULL;
--debug message should not contain "have been validated by using index scan"
ALTER TABLE tp_notnull ALTER COLUMN b SET NOT NULL, ALTER COLUMN b SET DATA TYPE BIGINT;
+DEBUG: rehashing catalog cache id 7 for pg_attribute; 257 tups, 128 buckets
DEBUG: rewriting table "tp_notnull_1"
DEBUG: building index "tp_notnull_1_c_idx" on table "tp_notnull_1" serially
DEBUG: index "tp_notnull_1_c_idx" can safely use deduplication |
| 58/6175 |
Add pg_get_tablespace_ddl() function to reconstruct CREATE TABLESPACE statement |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out /tmp/cirrus-ci-build/build/testrun/postgres...
--- /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out 2026-03-23 02:05:40.038746000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/postgres_fdw-running/regress/results/postgres_fdw.out 2026-03-23 02:15:15.6001120...
@@ -12732,8 +12732,7 @@
FROM postgres_fdw_get_connections(true);
server_name | closed | remote_backend_pid
-------------+--------+--------------------
- loopback | t | t
-(1 row)
+(0 rows)
-- Clean up
\set VERBOSITY default |
| 58/5012 |
Vacuum statistics |
|
OpenBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/isolation/expected/vacuum-extending-freeze.out /home/postgres/postgres/build/t...
--- /home/postgres/postgres/src/test/isolation/expected/vacuum-extending-freeze.out Mon Mar 23 01:51:27 2026
+++ /home/postgres/postgres/build/testrun/isolation/isolation/results/vacuum-extending-freeze.out Mon Mar 23 01:57:43 20...
@@ -29,7 +29,7 @@
relallfrozen|relallvisible
------------+-------------
-t |t
+f |f
(1 row)
step s1_update_table:
@@ -62,7 +62,7 @@
visible_page_marks_cleared|frozen_page_marks_cleared
--------------------------+-------------------------
-t |t
+f |f
(1 row)
... |
| 58/4351 |
Index Prefetching |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/bit.out /home/postgres/postgres/build/testrun/regress/regress...
--- /home/postgres/postgres/src/test/regress/expected/bit.out 2026-03-23 01:37:16.180360515 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/bit.out 2026-03-23 01:39:38.572194757 +0000
@@ -1,850 +1,2 @@
---
--- BIT types
---
---
--- Build tables for testing
---
-CREATE TABLE BIT_TABLE(b BIT(11));
-INSERT INTO BIT_TABLE VALUES (B'10'); -- too short
-ERROR: bit string length 2 does not match type bit(11)
-INSERT INTO BIT_TABLE VALUES (B'00000000000');
-INSERT INTO BIT_TABLE VALUES (B'11011000000');
-INSERT INTO BIT_TABLE VALUES (B'01010101010');
-INSERT INTO BIT_TABLE VALUES (B'101011111010'); -- too long
-ERROR: bit string length 12 does not match type bit(11)
---INSERT INTO BIT_TABLE VALUES ('X554');
---INSERT INTO BIT_TABLE VALUES ('X555');
... |
| 58/6454 |
Use correct collation in pg_trgm |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/updatable_views.out /home/postgres/postgres/build/testrun/tes...
--- /home/postgres/postgres/src/test/regress/expected/updatable_views.out 2026-03-23 00:35:50.702765615 +0000
+++ /home/postgres/postgres/build/testrun/test_plan_advice/001_replan_regress/data/results/updatable_views.out 2026-03-2...
@@ -2700,6 +2700,9 @@
CREATE VIEW rw_view2 AS SELECT * FROM rw_view1 WHERE a > 0;
CREATE VIEW rw_view3 AS SELECT * FROM rw_view2 WITH CHECK OPTION;
SELECT * FROM information_schema.views WHERE table_name LIKE E'rw\\_view_' ORDER BY table_name;
+WARNING: supplied plan advice was not enforced
+DETAIL: advice SEQ_SCAN(pg_trigger@exists_5) feedback is "matched, failed"
+advice NO_GATHER(pg_trigger@exists_5) feedback is "matched, failed"
table_catalog | table_schema | table_name | view_definition | check_option | is_updatable | is_insertable_into | is_...
---------------+--------------+------------+-------------------+--------------+--------------+--------------------+----...
regression | public | rw_view1 | SELECT a +| CASCADED | YES | YES | NO ... |
| 58/6054 |
let ALTER COLUMN SET DATA TYPE cope with POLICY dependency |
|
macOS - Sequoia - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/rowsecurity.out /Users/admin/pgsql/build/testrun/test_plan_advice/...
--- /Users/admin/pgsql/src/test/regress/expected/rowsecurity.out 2026-03-23 00:03:43
+++ /Users/admin/pgsql/build/testrun/test_plan_advice/001_replan_regress/data/results/rowsecurity.out 2026-03-23 00:06:4...
@@ -423,15 +423,15 @@
--------------------+----------+-------+----------------------------------------------+-------------------+------------...
regress_rls_schema | category | table | regress_rls_alice=arwdDxtm/regress_rls_alice+| |
| | | =arwdDxtm/regress_rls_alice | |
- regress_rls_schema | document | table | regress_rls_alice=arwdDxtm/regress_rls_alice+| | p1: ...
- | | | =arwdDxtm/regress_rls_alice | | (u): (dle...
+ regress_rls_schema | document | table | regress_rls_alice=arwdDxtm/regress_rls_alice+| | p1r (RESTRI...
+ | | | =arwdDxtm/regress_rls_alice | | (u): (cid...
+ | | | | | to: regre...
+ | | | | | p1: ...
+ | | | | | (u): (dle...
| | | | | FROM uac...
| | | | | WHERE (ua...
| | | | | p2r (RESTRI...
| | | | | (u): ((ci...
- | | | | | to: regre...
- | | | | | p1r (RESTRI...
... |
|
Windows - Server 2022, MinGW64 - Meson |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/rowsecurity.out C:/cirrus/build/testrun/test_plan_advic...
--- C:/cirrus/src/test/regress/expected/rowsecurity.out 2026-03-23 00:05:53.007171800 +0000
+++ C:/cirrus/build/testrun/test_plan_advice/001_replan_regress/data/results/rowsecurity.out 2026-03-23 00:11:10.9798133...
@@ -423,15 +423,15 @@
--------------------+----------+-------+----------------------------------------------+-------------------+------------...
regress_rls_schema | category | table | regress_rls_alice=arwdDxtm/regress_rls_alice+| |
| | | =arwdDxtm/regress_rls_alice | |
- regress_rls_schema | document | table | regress_rls_alice=arwdDxtm/regress_rls_alice+| | p1: ...
- | | | =arwdDxtm/regress_rls_alice | | (u): (dle...
+ regress_rls_schema | document | table | regress_rls_alice=arwdDxtm/regress_rls_alice+| | p1r (RESTRI...
+ | | | =arwdDxtm/regress_rls_alice | | (u): (cid...
+ | | | | | to: regre...
+ | | | | | p1: ...
+ | | | | | (u): (dle...
| | | | | FROM uac...
| | | | | WHERE (ua...
| | | | | p2r (RESTRI...
| | | | | (u): ((ci...
- | | | | | to: regre...
- | | | | | p1r (RESTRI...
... |
| 58/6421 |
aio: warn user if combined io_uring memory mappings are unavailable |
|
OpenBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/updatable_views.out /home/postgres/postgres/build/testrun/tes...
--- /home/postgres/postgres/src/test/regress/expected/updatable_views.out Sun Mar 22 18:42:14 2026
+++ /home/postgres/postgres/build/testrun/test_plan_advice/001_replan_regress/data/results/updatable_views.out Sun Mar 2...
@@ -2519,6 +2519,9 @@
Options: check_option=local
SELECT * FROM information_schema.views WHERE table_name = 'rw_view1';
+WARNING: supplied plan advice was not enforced
+DETAIL: advice SEQ_SCAN(pg_trigger@exists_1) feedback is "matched, failed"
+advice NO_GATHER(pg_trigger@exists_1) feedback is "matched, failed"
table_catalog | table_schema | table_name | view_definition | check_option | is_updatable | is_insertable_into | is_t...
---------------+--------------+------------+------------------+--------------+--------------+--------------------+-----...
regression | public | rw_view1 | SELECT a, +| LOCAL | YES | YES | NO ... |
| 58/5251 |
libpq: Fix processing of SSL records >8kB on async API |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/updatable_views.out /tmp/cirrus-ci-build/build/testrun/test_plan...
--- /tmp/cirrus-ci-build/src/test/regress/expected/updatable_views.out 2026-03-22 18:06:55.078206000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/updatable_views.out 2026-03-22 1...
@@ -1071,6 +1071,9 @@
FROM information_schema.views
WHERE table_name LIKE 'rw_view%'
ORDER BY table_name;
+WARNING: supplied plan advice was not enforced
+DETAIL: advice SEQ_SCAN(pg_trigger@exists_5) feedback is "matched, failed"
+advice NO_GATHER(pg_trigger@exists_5) feedback is "matched, failed"
table_name | is_updatable | is_insertable_into | is_trigger_updatable | is_trigger_deletable | is_trigger_insertable_i...
------------+--------------+--------------------+----------------------+----------------------+------------------------...
rw_view1 | NO | NO | NO | NO | YES |
| 60/5615 |
Corrupted FSM page is not saved after zeroing. |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out /tmp/cirrus-ci-build/build/testrun/postgres...
--- /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out 2026-03-22 16:12:52.378224000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/postgres_fdw-running/regress/results/postgres_fdw.out 2026-03-22 16:21:00.1784980...
@@ -12715,8 +12715,7 @@
FROM postgres_fdw_get_connections(true);
server_name | closed | remote_backend_pid
-------------+--------+--------------------
- loopback | f | t
-(1 row)
+(0 rows)
-- After terminating the remote backend, since the connection is closed,
-- "closed" should be TRUE, or NULL if the connection status check
@@ -12732,8 +12731,7 @@
FROM postgres_fdw_get_connections(true);
server_name | closed | remote_backend_pid
-------------+--------+--------------------
- loopback | t | t
-(1 row)
+(0 rows)
... |
| 58/6215 |
Add pg_get_database_ddl() function to reconstruct CREATE DATABASE statement |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/isolation/expected/timeouts.out /tmp/cirrus-ci-build/build/testrun/isolation/isol...
--- /tmp/cirrus-ci-build/src/test/isolation/expected/timeouts.out 2026-03-22 14:52:40.551675000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/isolation/isolation/results/timeouts.out 2026-03-22 14:56:04.048129000 +0000
@@ -50,7 +50,7 @@
step slto: SET lock_timeout = '10s'; 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: wrtbl sto update
step wrtbl: UPDATE accounts SET balance = balance + 100; |
| 58/6392 |
ALTER TABLE: notice when actions do not recurse to partitions |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/graph_table_rls.out C:/cirrus/build/testrun/pg_upgrade/...
--- C:/cirrus/src/test/regress/expected/graph_table_rls.out 2026-03-22 13:24:19.177623300 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/graph_table_rls.out 2026-03-22 13:30:15.069899800 +00...
@@ -446,6 +446,8 @@
ALTER TABLE document ATTACH PARTITION document_places FOR VALUES IN ('Places');
-- Enable RLS on partitioned table
ALTER TABLE document ENABLE ROW LEVEL SECURITY;
+NOTICE: ALTER action ENABLE ROW SECURITY on relation "document" does not affect present partitions
+HINT: Partitions may be modified individually, or specify ONLY to suppress this message.
-- create policies on partitioned table
CREATE POLICY p1 ON document AS PERMISSIVE
USING (dlevel <= (SELECT seclv FROM users WHERE pguser = current_user));
@@ -760,6 +762,8 @@
-- FORCE ROW LEVEL SECURITY applies RLS to owners too
ALTER TABLE document FORCE ROW LEVEL SECURITY;
+NOTICE: ALTER action FORCE ROW SECURITY on relation "document" does not affect present partitions
+HINT: Partitions may be modified individually, or specify ONLY to suppress this message.
EXECUTE graph_rls_query;
pguser | aid | dtitle | dlevel
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/graph_table_rls.out C:/cirrus/build/testrun/recovery/02...
--- C:/cirrus/src/test/regress/expected/graph_table_rls.out 2026-03-22 13:24:19.177623300 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/graph_table_rls.out 2026-03-22 13:34:11.726545500 +...
@@ -446,6 +446,8 @@
ALTER TABLE document ATTACH PARTITION document_places FOR VALUES IN ('Places');
-- Enable RLS on partitioned table
ALTER TABLE document ENABLE ROW LEVEL SECURITY;
+NOTICE: ALTER action ENABLE ROW SECURITY on relation "document" does not affect present partitions
+HINT: Partitions may be modified individually, or specify ONLY to suppress this message.
-- create policies on partitioned table
CREATE POLICY p1 ON document AS PERMISSIVE
USING (dlevel <= (SELECT seclv FROM users WHERE pguser = current_user));
@@ -760,6 +762,8 @@
-- FORCE ROW LEVEL SECURITY applies RLS to owners too
ALTER TABLE document FORCE ROW LEVEL SECURITY;
+NOTICE: ALTER action FORCE ROW SECURITY on relation "document" does not affect present partitions
+HINT: Partitions may be modified individually, or specify ONLY to suppress this message.
EXECUTE graph_rls_query;
pguser | aid | dtitle | dlevel
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/graph_table_rls.out C:/cirrus/build/testrun/regress/reg...
--- C:/cirrus/src/test/regress/expected/graph_table_rls.out 2026-03-22 13:24:19.177623300 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/graph_table_rls.out 2026-03-22 13:30:07.334067400 +0000
@@ -446,6 +446,8 @@
ALTER TABLE document ATTACH PARTITION document_places FOR VALUES IN ('Places');
-- Enable RLS on partitioned table
ALTER TABLE document ENABLE ROW LEVEL SECURITY;
+NOTICE: ALTER action ENABLE ROW SECURITY on relation "document" does not affect present partitions
+HINT: Partitions may be modified individually, or specify ONLY to suppress this message.
-- create policies on partitioned table
CREATE POLICY p1 ON document AS PERMISSIVE
USING (dlevel <= (SELECT seclv FROM users WHERE pguser = current_user));
@@ -760,6 +762,8 @@
-- FORCE ROW LEVEL SECURITY applies RLS to owners too
ALTER TABLE document FORCE ROW LEVEL SECURITY;
+NOTICE: ALTER action FORCE ROW SECURITY on relation "document" does not affect present partitions
+HINT: Partitions may be modified individually, or specify ONLY to suppress this message.
EXECUTE graph_rls_query;
pguser | aid | dtitle | dlevel
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/graph_table_rls.out C:/cirrus/build/testrun/test_plan_a...
--- C:/cirrus/src/test/regress/expected/graph_table_rls.out 2026-03-22 13:24:19.177623300 +0000
+++ C:/cirrus/build/testrun/test_plan_advice/001_replan_regress/data/results/graph_table_rls.out 2026-03-22 13:30:00.610...
@@ -446,6 +446,8 @@
ALTER TABLE document ATTACH PARTITION document_places FOR VALUES IN ('Places');
-- Enable RLS on partitioned table
ALTER TABLE document ENABLE ROW LEVEL SECURITY;
+NOTICE: ALTER action ENABLE ROW SECURITY on relation "document" does not affect present partitions
+HINT: Partitions may be modified individually, or specify ONLY to suppress this message.
-- create policies on partitioned table
CREATE POLICY p1 ON document AS PERMISSIVE
USING (dlevel <= (SELECT seclv FROM users WHERE pguser = current_user));
@@ -760,6 +762,8 @@
-- FORCE ROW LEVEL SECURITY applies RLS to owners too
ALTER TABLE document FORCE ROW LEVEL SECURITY;
+NOTICE: ALTER action FORCE ROW SECURITY on relation "document" does not affect present partitions
+HINT: Partitions may be modified individually, or specify ONLY to suppress this message.
EXECUTE graph_rls_query;
pguser | aid | dtitle | dlevel
... |
|
Linux - Debian Trixie - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/graph_table_rls.out /tmp/cirrus-ci-build/build/testrun/pg_upgrad...
--- /tmp/cirrus-ci-build/src/test/regress/expected/graph_table_rls.out 2026-03-22 13:24:26.654889625 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/graph_table_rls.out 2026-03-22 13:29:56.43...
@@ -446,6 +446,8 @@
ALTER TABLE document ATTACH PARTITION document_places FOR VALUES IN ('Places');
-- Enable RLS on partitioned table
ALTER TABLE document ENABLE ROW LEVEL SECURITY;
+NOTICE: ALTER action ENABLE ROW SECURITY on relation "document" does not affect present partitions
+HINT: Partitions may be modified individually, or specify ONLY to suppress this message.
-- create policies on partitioned table
CREATE POLICY p1 ON document AS PERMISSIVE
USING (dlevel <= (SELECT seclv FROM users WHERE pguser = current_user));
@@ -760,6 +762,8 @@
-- FORCE ROW LEVEL SECURITY applies RLS to owners too
ALTER TABLE document FORCE ROW LEVEL SECURITY;
+NOTICE: ALTER action FORCE ROW SECURITY on relation "document" does not affect present partitions
+HINT: Partitions may be modified individually, or specify ONLY to suppress this message.
EXECUTE graph_rls_query;
pguser | aid | dtitle | dlevel
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/graph_table_rls.out /tmp/cirrus-ci-build/build/testrun/recovery/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/graph_table_rls.out 2026-03-22 13:24:26.654889625 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/graph_table_rls.out 2026-03-22 13:31:32....
@@ -446,6 +446,8 @@
ALTER TABLE document ATTACH PARTITION document_places FOR VALUES IN ('Places');
-- Enable RLS on partitioned table
ALTER TABLE document ENABLE ROW LEVEL SECURITY;
+NOTICE: ALTER action ENABLE ROW SECURITY on relation "document" does not affect present partitions
+HINT: Partitions may be modified individually, or specify ONLY to suppress this message.
-- create policies on partitioned table
CREATE POLICY p1 ON document AS PERMISSIVE
USING (dlevel <= (SELECT seclv FROM users WHERE pguser = current_user));
@@ -760,6 +762,8 @@
-- FORCE ROW LEVEL SECURITY applies RLS to owners too
ALTER TABLE document FORCE ROW LEVEL SECURITY;
+NOTICE: ALTER action FORCE ROW SECURITY on relation "document" does not affect present partitions
+HINT: Partitions may be modified individually, or specify ONLY to suppress this message.
EXECUTE graph_rls_query;
pguser | aid | dtitle | dlevel
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/graph_table_rls.out /tmp/cirrus-ci-build/build/testrun/regress/r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/graph_table_rls.out 2026-03-22 13:24:26.654889625 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/graph_table_rls.out 2026-03-22 13:29:51.890439616 +0000
@@ -446,6 +446,8 @@
ALTER TABLE document ATTACH PARTITION document_places FOR VALUES IN ('Places');
-- Enable RLS on partitioned table
ALTER TABLE document ENABLE ROW LEVEL SECURITY;
+NOTICE: ALTER action ENABLE ROW SECURITY on relation "document" does not affect present partitions
+HINT: Partitions may be modified individually, or specify ONLY to suppress this message.
-- create policies on partitioned table
CREATE POLICY p1 ON document AS PERMISSIVE
USING (dlevel <= (SELECT seclv FROM users WHERE pguser = current_user));
@@ -760,6 +762,8 @@
-- FORCE ROW LEVEL SECURITY applies RLS to owners too
ALTER TABLE document FORCE ROW LEVEL SECURITY;
+NOTICE: ALTER action FORCE ROW SECURITY on relation "document" does not affect present partitions
+HINT: Partitions may be modified individually, or specify ONLY to suppress this message.
EXECUTE graph_rls_query;
pguser | aid | dtitle | dlevel
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/graph_table_rls.out /tmp/cirrus-ci-build/build/testrun/test_plan...
--- /tmp/cirrus-ci-build/src/test/regress/expected/graph_table_rls.out 2026-03-22 13:24:26.654889625 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/graph_table_rls.out 2026-03-22 1...
@@ -446,6 +446,8 @@
ALTER TABLE document ATTACH PARTITION document_places FOR VALUES IN ('Places');
-- Enable RLS on partitioned table
ALTER TABLE document ENABLE ROW LEVEL SECURITY;
+NOTICE: ALTER action ENABLE ROW SECURITY on relation "document" does not affect present partitions
+HINT: Partitions may be modified individually, or specify ONLY to suppress this message.
-- create policies on partitioned table
CREATE POLICY p1 ON document AS PERMISSIVE
USING (dlevel <= (SELECT seclv FROM users WHERE pguser = current_user));
@@ -760,6 +762,8 @@
-- FORCE ROW LEVEL SECURITY applies RLS to owners too
ALTER TABLE document FORCE ROW LEVEL SECURITY;
+NOTICE: ALTER action FORCE ROW SECURITY on relation "document" does not affect present partitions
+HINT: Partitions may be modified individually, or specify ONLY to suppress this message.
EXECUTE graph_rls_query;
pguser | aid | dtitle | dlevel
... |
|
Windows - Server 2022, MinGW64 - Meson |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/graph_table_rls.out C:/cirrus/build/testrun/pg_upgrade/...
--- C:/cirrus/src/test/regress/expected/graph_table_rls.out 2026-03-22 13:24:16.240736800 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/graph_table_rls.out 2026-03-22 13:30:21.254290000 +00...
@@ -446,6 +446,8 @@
ALTER TABLE document ATTACH PARTITION document_places FOR VALUES IN ('Places');
-- Enable RLS on partitioned table
ALTER TABLE document ENABLE ROW LEVEL SECURITY;
+NOTICE: ALTER action ENABLE ROW SECURITY on relation "document" does not affect present partitions
+HINT: Partitions may be modified individually, or specify ONLY to suppress this message.
-- create policies on partitioned table
CREATE POLICY p1 ON document AS PERMISSIVE
USING (dlevel <= (SELECT seclv FROM users WHERE pguser = current_user));
@@ -760,6 +762,8 @@
-- FORCE ROW LEVEL SECURITY applies RLS to owners too
ALTER TABLE document FORCE ROW LEVEL SECURITY;
+NOTICE: ALTER action FORCE ROW SECURITY on relation "document" does not affect present partitions
+HINT: Partitions may be modified individually, or specify ONLY to suppress this message.
EXECUTE graph_rls_query;
pguser | aid | dtitle | dlevel
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/graph_table_rls.out C:/cirrus/build/testrun/recovery/02...
--- C:/cirrus/src/test/regress/expected/graph_table_rls.out 2026-03-22 13:24:16.240736800 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/graph_table_rls.out 2026-03-22 13:33:52.744028300 +...
@@ -446,6 +446,8 @@
ALTER TABLE document ATTACH PARTITION document_places FOR VALUES IN ('Places');
-- Enable RLS on partitioned table
ALTER TABLE document ENABLE ROW LEVEL SECURITY;
+NOTICE: ALTER action ENABLE ROW SECURITY on relation "document" does not affect present partitions
+HINT: Partitions may be modified individually, or specify ONLY to suppress this message.
-- create policies on partitioned table
CREATE POLICY p1 ON document AS PERMISSIVE
USING (dlevel <= (SELECT seclv FROM users WHERE pguser = current_user));
@@ -760,6 +762,8 @@
-- FORCE ROW LEVEL SECURITY applies RLS to owners too
ALTER TABLE document FORCE ROW LEVEL SECURITY;
+NOTICE: ALTER action FORCE ROW SECURITY on relation "document" does not affect present partitions
+HINT: Partitions may be modified individually, or specify ONLY to suppress this message.
EXECUTE graph_rls_query;
pguser | aid | dtitle | dlevel
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/graph_table_rls.out C:/cirrus/build/testrun/regress/reg...
--- C:/cirrus/src/test/regress/expected/graph_table_rls.out 2026-03-22 13:24:16.240736800 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/graph_table_rls.out 2026-03-22 13:30:02.051682300 +0000
@@ -446,6 +446,8 @@
ALTER TABLE document ATTACH PARTITION document_places FOR VALUES IN ('Places');
-- Enable RLS on partitioned table
ALTER TABLE document ENABLE ROW LEVEL SECURITY;
+NOTICE: ALTER action ENABLE ROW SECURITY on relation "document" does not affect present partitions
+HINT: Partitions may be modified individually, or specify ONLY to suppress this message.
-- create policies on partitioned table
CREATE POLICY p1 ON document AS PERMISSIVE
USING (dlevel <= (SELECT seclv FROM users WHERE pguser = current_user));
@@ -760,6 +762,8 @@
-- FORCE ROW LEVEL SECURITY applies RLS to owners too
ALTER TABLE document FORCE ROW LEVEL SECURITY;
+NOTICE: ALTER action FORCE ROW SECURITY on relation "document" does not affect present partitions
+HINT: Partitions may be modified individually, or specify ONLY to suppress this message.
EXECUTE graph_rls_query;
pguser | aid | dtitle | dlevel
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/graph_table_rls.out C:/cirrus/build/testrun/test_plan_a...
--- C:/cirrus/src/test/regress/expected/graph_table_rls.out 2026-03-22 13:24:16.240736800 +0000
+++ C:/cirrus/build/testrun/test_plan_advice/001_replan_regress/data/results/graph_table_rls.out 2026-03-22 13:30:16.954...
@@ -446,6 +446,8 @@
ALTER TABLE document ATTACH PARTITION document_places FOR VALUES IN ('Places');
-- Enable RLS on partitioned table
ALTER TABLE document ENABLE ROW LEVEL SECURITY;
+NOTICE: ALTER action ENABLE ROW SECURITY on relation "document" does not affect present partitions
+HINT: Partitions may be modified individually, or specify ONLY to suppress this message.
-- create policies on partitioned table
CREATE POLICY p1 ON document AS PERMISSIVE
USING (dlevel <= (SELECT seclv FROM users WHERE pguser = current_user));
@@ -760,6 +762,8 @@
-- FORCE ROW LEVEL SECURITY applies RLS to owners too
ALTER TABLE document FORCE ROW LEVEL SECURITY;
+NOTICE: ALTER action FORCE ROW SECURITY on relation "document" does not affect present partitions
+HINT: Partitions may be modified individually, or specify ONLY to suppress this message.
EXECUTE graph_rls_query;
pguser | aid | dtitle | dlevel
... |
|
macOS - Sequoia - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/graph_table_rls.out /Users/admin/pgsql/build/testrun/pg_upgrade/00...
--- /Users/admin/pgsql/src/test/regress/expected/graph_table_rls.out 2026-03-22 13:24:21
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/graph_table_rls.out 2026-03-22 13:30:50
@@ -446,6 +446,8 @@
ALTER TABLE document ATTACH PARTITION document_places FOR VALUES IN ('Places');
-- Enable RLS on partitioned table
ALTER TABLE document ENABLE ROW LEVEL SECURITY;
+NOTICE: ALTER action ENABLE ROW SECURITY on relation "document" does not affect present partitions
+HINT: Partitions may be modified individually, or specify ONLY to suppress this message.
-- create policies on partitioned table
CREATE POLICY p1 ON document AS PERMISSIVE
USING (dlevel <= (SELECT seclv FROM users WHERE pguser = current_user));
@@ -760,6 +762,8 @@
-- FORCE ROW LEVEL SECURITY applies RLS to owners too
ALTER TABLE document FORCE ROW LEVEL SECURITY;
+NOTICE: ALTER action FORCE ROW SECURITY on relation "document" does not affect present partitions
+HINT: Partitions may be modified individually, or specify ONLY to suppress this message.
EXECUTE graph_rls_query;
pguser | aid | dtitle | dlevel
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/graph_table_rls.out /Users/admin/pgsql/build/testrun/recovery/027_...
--- /Users/admin/pgsql/src/test/regress/expected/graph_table_rls.out 2026-03-22 13:24:21
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/graph_table_rls.out 2026-03-22 13:32:51
@@ -446,6 +446,8 @@
ALTER TABLE document ATTACH PARTITION document_places FOR VALUES IN ('Places');
-- Enable RLS on partitioned table
ALTER TABLE document ENABLE ROW LEVEL SECURITY;
+NOTICE: ALTER action ENABLE ROW SECURITY on relation "document" does not affect present partitions
+HINT: Partitions may be modified individually, or specify ONLY to suppress this message.
-- create policies on partitioned table
CREATE POLICY p1 ON document AS PERMISSIVE
USING (dlevel <= (SELECT seclv FROM users WHERE pguser = current_user));
@@ -760,6 +762,8 @@
-- FORCE ROW LEVEL SECURITY applies RLS to owners too
ALTER TABLE document FORCE ROW LEVEL SECURITY;
+NOTICE: ALTER action FORCE ROW SECURITY on relation "document" does not affect present partitions
+HINT: Partitions may be modified individually, or specify ONLY to suppress this message.
EXECUTE graph_rls_query;
pguser | aid | dtitle | dlevel
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/graph_table_rls.out /Users/admin/pgsql/build/testrun/regress/regre...
--- /Users/admin/pgsql/src/test/regress/expected/graph_table_rls.out 2026-03-22 13:24:21
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/graph_table_rls.out 2026-03-22 13:30:48
@@ -446,6 +446,8 @@
ALTER TABLE document ATTACH PARTITION document_places FOR VALUES IN ('Places');
-- Enable RLS on partitioned table
ALTER TABLE document ENABLE ROW LEVEL SECURITY;
+NOTICE: ALTER action ENABLE ROW SECURITY on relation "document" does not affect present partitions
+HINT: Partitions may be modified individually, or specify ONLY to suppress this message.
-- create policies on partitioned table
CREATE POLICY p1 ON document AS PERMISSIVE
USING (dlevel <= (SELECT seclv FROM users WHERE pguser = current_user));
@@ -760,6 +762,8 @@
-- FORCE ROW LEVEL SECURITY applies RLS to owners too
ALTER TABLE document FORCE ROW LEVEL SECURITY;
+NOTICE: ALTER action FORCE ROW SECURITY on relation "document" does not affect present partitions
+HINT: Partitions may be modified individually, or specify ONLY to suppress this message.
EXECUTE graph_rls_query;
pguser | aid | dtitle | dlevel
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/graph_table_rls.out /Users/admin/pgsql/build/testrun/test_plan_adv...
--- /Users/admin/pgsql/src/test/regress/expected/graph_table_rls.out 2026-03-22 13:24:21
+++ /Users/admin/pgsql/build/testrun/test_plan_advice/001_replan_regress/data/results/graph_table_rls.out 2026-03-22 13:...
@@ -446,6 +446,8 @@
ALTER TABLE document ATTACH PARTITION document_places FOR VALUES IN ('Places');
-- Enable RLS on partitioned table
ALTER TABLE document ENABLE ROW LEVEL SECURITY;
+NOTICE: ALTER action ENABLE ROW SECURITY on relation "document" does not affect present partitions
+HINT: Partitions may be modified individually, or specify ONLY to suppress this message.
-- create policies on partitioned table
CREATE POLICY p1 ON document AS PERMISSIVE
USING (dlevel <= (SELECT seclv FROM users WHERE pguser = current_user));
@@ -760,6 +762,8 @@
-- FORCE ROW LEVEL SECURITY applies RLS to owners too
ALTER TABLE document FORCE ROW LEVEL SECURITY;
+NOTICE: ALTER action FORCE ROW SECURITY on relation "document" does not affect present partitions
+HINT: Partitions may be modified individually, or specify ONLY to suppress this message.
EXECUTE graph_rls_query;
pguser | aid | dtitle | dlevel
... |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/graph_table_rls.out /home/postgres/postgres/build/testrun/pg_...
--- /home/postgres/postgres/src/test/regress/expected/graph_table_rls.out 2026-03-22 13:24:32.991941250 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/graph_table_rls.out 2026-03-22 13:28:43...
@@ -446,6 +446,8 @@
ALTER TABLE document ATTACH PARTITION document_places FOR VALUES IN ('Places');
-- Enable RLS on partitioned table
ALTER TABLE document ENABLE ROW LEVEL SECURITY;
+NOTICE: ALTER action ENABLE ROW SECURITY on relation "document" does not affect present partitions
+HINT: Partitions may be modified individually, or specify ONLY to suppress this message.
-- create policies on partitioned table
CREATE POLICY p1 ON document AS PERMISSIVE
USING (dlevel <= (SELECT seclv FROM users WHERE pguser = current_user));
@@ -760,6 +762,8 @@
-- FORCE ROW LEVEL SECURITY applies RLS to owners too
ALTER TABLE document FORCE ROW LEVEL SECURITY;
+NOTICE: ALTER action FORCE ROW SECURITY on relation "document" does not affect present partitions
+HINT: Partitions may be modified individually, or specify ONLY to suppress this message.
EXECUTE graph_rls_query;
pguser | aid | dtitle | dlevel
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/graph_table_rls.out /home/postgres/postgres/build/testrun/rec...
--- /home/postgres/postgres/src/test/regress/expected/graph_table_rls.out 2026-03-22 13:24:32.991941250 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/graph_table_rls.out 2026-03-22 13:29:...
@@ -446,6 +446,8 @@
ALTER TABLE document ATTACH PARTITION document_places FOR VALUES IN ('Places');
-- Enable RLS on partitioned table
ALTER TABLE document ENABLE ROW LEVEL SECURITY;
+NOTICE: ALTER action ENABLE ROW SECURITY on relation "document" does not affect present partitions
+HINT: Partitions may be modified individually, or specify ONLY to suppress this message.
-- create policies on partitioned table
CREATE POLICY p1 ON document AS PERMISSIVE
USING (dlevel <= (SELECT seclv FROM users WHERE pguser = current_user));
@@ -760,6 +762,8 @@
-- FORCE ROW LEVEL SECURITY applies RLS to owners too
ALTER TABLE document FORCE ROW LEVEL SECURITY;
+NOTICE: ALTER action FORCE ROW SECURITY on relation "document" does not affect present partitions
+HINT: Partitions may be modified individually, or specify ONLY to suppress this message.
EXECUTE graph_rls_query;
pguser | aid | dtitle | dlevel
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/graph_table_rls.out /home/postgres/postgres/build/testrun/reg...
--- /home/postgres/postgres/src/test/regress/expected/graph_table_rls.out 2026-03-22 13:24:32.991941250 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/graph_table_rls.out 2026-03-22 13:28:32.253619786 +000...
@@ -446,6 +446,8 @@
ALTER TABLE document ATTACH PARTITION document_places FOR VALUES IN ('Places');
-- Enable RLS on partitioned table
ALTER TABLE document ENABLE ROW LEVEL SECURITY;
+NOTICE: ALTER action ENABLE ROW SECURITY on relation "document" does not affect present partitions
+HINT: Partitions may be modified individually, or specify ONLY to suppress this message.
-- create policies on partitioned table
CREATE POLICY p1 ON document AS PERMISSIVE
USING (dlevel <= (SELECT seclv FROM users WHERE pguser = current_user));
@@ -760,6 +762,8 @@
-- FORCE ROW LEVEL SECURITY applies RLS to owners too
ALTER TABLE document FORCE ROW LEVEL SECURITY;
+NOTICE: ALTER action FORCE ROW SECURITY on relation "document" does not affect present partitions
+HINT: Partitions may be modified individually, or specify ONLY to suppress this message.
EXECUTE graph_rls_query;
pguser | aid | dtitle | dlevel
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/graph_table_rls.out /home/postgres/postgres/build/testrun/tes...
--- /home/postgres/postgres/src/test/regress/expected/graph_table_rls.out 2026-03-22 13:24:32.991941250 +0000
+++ /home/postgres/postgres/build/testrun/test_plan_advice/001_replan_regress/data/results/graph_table_rls.out 2026-03-2...
@@ -446,6 +446,8 @@
ALTER TABLE document ATTACH PARTITION document_places FOR VALUES IN ('Places');
-- Enable RLS on partitioned table
ALTER TABLE document ENABLE ROW LEVEL SECURITY;
+NOTICE: ALTER action ENABLE ROW SECURITY on relation "document" does not affect present partitions
+HINT: Partitions may be modified individually, or specify ONLY to suppress this message.
-- create policies on partitioned table
CREATE POLICY p1 ON document AS PERMISSIVE
USING (dlevel <= (SELECT seclv FROM users WHERE pguser = current_user));
@@ -760,6 +762,8 @@
-- FORCE ROW LEVEL SECURITY applies RLS to owners too
ALTER TABLE document FORCE ROW LEVEL SECURITY;
+NOTICE: ALTER action FORCE ROW SECURITY on relation "document" does not affect present partitions
+HINT: Partitions may be modified individually, or specify ONLY to suppress this message.
EXECUTE graph_rls_query;
pguser | aid | dtitle | dlevel
... |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/graph_table_rls.out /tmp/cirrus-ci-build/build/testrun/pg_upgrad...
--- /tmp/cirrus-ci-build/src/test/regress/expected/graph_table_rls.out 2026-03-22 13:24:24.958735000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/graph_table_rls.out 2026-03-22 13:30:03.40...
@@ -446,6 +446,8 @@
ALTER TABLE document ATTACH PARTITION document_places FOR VALUES IN ('Places');
-- Enable RLS on partitioned table
ALTER TABLE document ENABLE ROW LEVEL SECURITY;
+NOTICE: ALTER action ENABLE ROW SECURITY on relation "document" does not affect present partitions
+HINT: Partitions may be modified individually, or specify ONLY to suppress this message.
-- create policies on partitioned table
CREATE POLICY p1 ON document AS PERMISSIVE
USING (dlevel <= (SELECT seclv FROM users WHERE pguser = current_user));
@@ -760,6 +762,8 @@
-- FORCE ROW LEVEL SECURITY applies RLS to owners too
ALTER TABLE document FORCE ROW LEVEL SECURITY;
+NOTICE: ALTER action FORCE ROW SECURITY on relation "document" does not affect present partitions
+HINT: Partitions may be modified individually, or specify ONLY to suppress this message.
EXECUTE graph_rls_query;
pguser | aid | dtitle | dlevel
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/graph_table_rls.out /tmp/cirrus-ci-build/build/testrun/recovery/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/graph_table_rls.out 2026-03-22 13:24:24.958735000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/graph_table_rls.out 2026-03-22 13:31:41....
@@ -446,6 +446,8 @@
ALTER TABLE document ATTACH PARTITION document_places FOR VALUES IN ('Places');
-- Enable RLS on partitioned table
ALTER TABLE document ENABLE ROW LEVEL SECURITY;
+NOTICE: ALTER action ENABLE ROW SECURITY on relation "document" does not affect present partitions
+HINT: Partitions may be modified individually, or specify ONLY to suppress this message.
-- create policies on partitioned table
CREATE POLICY p1 ON document AS PERMISSIVE
USING (dlevel <= (SELECT seclv FROM users WHERE pguser = current_user));
@@ -760,6 +762,8 @@
-- FORCE ROW LEVEL SECURITY applies RLS to owners too
ALTER TABLE document FORCE ROW LEVEL SECURITY;
+NOTICE: ALTER action FORCE ROW SECURITY on relation "document" does not affect present partitions
+HINT: Partitions may be modified individually, or specify ONLY to suppress this message.
EXECUTE graph_rls_query;
pguser | aid | dtitle | dlevel
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/graph_table_rls.out /tmp/cirrus-ci-build/build/testrun/regress/r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/graph_table_rls.out 2026-03-22 13:24:24.958735000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/graph_table_rls.out 2026-03-22 13:30:10.712941000 +0000
@@ -446,6 +446,8 @@
ALTER TABLE document ATTACH PARTITION document_places FOR VALUES IN ('Places');
-- Enable RLS on partitioned table
ALTER TABLE document ENABLE ROW LEVEL SECURITY;
+NOTICE: ALTER action ENABLE ROW SECURITY on relation "document" does not affect present partitions
+HINT: Partitions may be modified individually, or specify ONLY to suppress this message.
-- create policies on partitioned table
CREATE POLICY p1 ON document AS PERMISSIVE
USING (dlevel <= (SELECT seclv FROM users WHERE pguser = current_user));
@@ -760,6 +762,8 @@
-- FORCE ROW LEVEL SECURITY applies RLS to owners too
ALTER TABLE document FORCE ROW LEVEL SECURITY;
+NOTICE: ALTER action FORCE ROW SECURITY on relation "document" does not affect present partitions
+HINT: Partitions may be modified individually, or specify ONLY to suppress this message.
EXECUTE graph_rls_query;
pguser | aid | dtitle | dlevel
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/graph_table_rls.out /tmp/cirrus-ci-build/build/testrun/test_plan...
--- /tmp/cirrus-ci-build/src/test/regress/expected/graph_table_rls.out 2026-03-22 13:24:24.958735000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/graph_table_rls.out 2026-03-22 1...
@@ -446,6 +446,8 @@
ALTER TABLE document ATTACH PARTITION document_places FOR VALUES IN ('Places');
-- Enable RLS on partitioned table
ALTER TABLE document ENABLE ROW LEVEL SECURITY;
+NOTICE: ALTER action ENABLE ROW SECURITY on relation "document" does not affect present partitions
+HINT: Partitions may be modified individually, or specify ONLY to suppress this message.
-- create policies on partitioned table
CREATE POLICY p1 ON document AS PERMISSIVE
USING (dlevel <= (SELECT seclv FROM users WHERE pguser = current_user));
@@ -760,6 +762,8 @@
-- FORCE ROW LEVEL SECURITY applies RLS to owners too
ALTER TABLE document FORCE ROW LEVEL SECURITY;
+NOTICE: ALTER action FORCE ROW SECURITY on relation "document" does not affect present partitions
+HINT: Partitions may be modified individually, or specify ONLY to suppress this message.
EXECUTE graph_rls_query;
pguser | aid | dtitle | dlevel
... |
|
OpenBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/graph_table_rls.out /home/postgres/postgres/build/testrun/pg_...
--- /home/postgres/postgres/src/test/regress/expected/graph_table_rls.out Sun Mar 22 13:24:28 2026
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/graph_table_rls.out Sun Mar 22 13:29:22...
@@ -446,6 +446,8 @@
ALTER TABLE document ATTACH PARTITION document_places FOR VALUES IN ('Places');
-- Enable RLS on partitioned table
ALTER TABLE document ENABLE ROW LEVEL SECURITY;
+NOTICE: ALTER action ENABLE ROW SECURITY on relation "document" does not affect present partitions
+HINT: Partitions may be modified individually, or specify ONLY to suppress this message.
-- create policies on partitioned table
CREATE POLICY p1 ON document AS PERMISSIVE
USING (dlevel <= (SELECT seclv FROM users WHERE pguser = current_user));
@@ -760,6 +762,8 @@
-- FORCE ROW LEVEL SECURITY applies RLS to owners too
ALTER TABLE document FORCE ROW LEVEL SECURITY;
+NOTICE: ALTER action FORCE ROW SECURITY on relation "document" does not affect present partitions
+HINT: Partitions may be modified individually, or specify ONLY to suppress this message.
EXECUTE graph_rls_query;
pguser | aid | dtitle | dlevel
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/graph_table_rls.out /home/postgres/postgres/build/testrun/rec...
--- /home/postgres/postgres/src/test/regress/expected/graph_table_rls.out Sun Mar 22 13:24:28 2026
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/graph_table_rls.out Sun Mar 22 13:31:...
@@ -446,6 +446,8 @@
ALTER TABLE document ATTACH PARTITION document_places FOR VALUES IN ('Places');
-- Enable RLS on partitioned table
ALTER TABLE document ENABLE ROW LEVEL SECURITY;
+NOTICE: ALTER action ENABLE ROW SECURITY on relation "document" does not affect present partitions
+HINT: Partitions may be modified individually, or specify ONLY to suppress this message.
-- create policies on partitioned table
CREATE POLICY p1 ON document AS PERMISSIVE
USING (dlevel <= (SELECT seclv FROM users WHERE pguser = current_user));
@@ -760,6 +762,8 @@
-- FORCE ROW LEVEL SECURITY applies RLS to owners too
ALTER TABLE document FORCE ROW LEVEL SECURITY;
+NOTICE: ALTER action FORCE ROW SECURITY on relation "document" does not affect present partitions
+HINT: Partitions may be modified individually, or specify ONLY to suppress this message.
EXECUTE graph_rls_query;
pguser | aid | dtitle | dlevel
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/graph_table_rls.out /home/postgres/postgres/build/testrun/reg...
--- /home/postgres/postgres/src/test/regress/expected/graph_table_rls.out Sun Mar 22 13:24:28 2026
+++ /home/postgres/postgres/build/testrun/regress/regress/results/graph_table_rls.out Sun Mar 22 13:29:23 2026
@@ -446,6 +446,8 @@
ALTER TABLE document ATTACH PARTITION document_places FOR VALUES IN ('Places');
-- Enable RLS on partitioned table
ALTER TABLE document ENABLE ROW LEVEL SECURITY;
+NOTICE: ALTER action ENABLE ROW SECURITY on relation "document" does not affect present partitions
+HINT: Partitions may be modified individually, or specify ONLY to suppress this message.
-- create policies on partitioned table
CREATE POLICY p1 ON document AS PERMISSIVE
USING (dlevel <= (SELECT seclv FROM users WHERE pguser = current_user));
@@ -760,6 +762,8 @@
-- FORCE ROW LEVEL SECURITY applies RLS to owners too
ALTER TABLE document FORCE ROW LEVEL SECURITY;
+NOTICE: ALTER action FORCE ROW SECURITY on relation "document" does not affect present partitions
+HINT: Partitions may be modified individually, or specify ONLY to suppress this message.
EXECUTE graph_rls_query;
pguser | aid | dtitle | dlevel
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/graph_table_rls.out /home/postgres/postgres/build/testrun/tes...
--- /home/postgres/postgres/src/test/regress/expected/graph_table_rls.out Sun Mar 22 13:24:28 2026
+++ /home/postgres/postgres/build/testrun/test_plan_advice/001_replan_regress/data/results/graph_table_rls.out Sun Mar 2...
@@ -446,6 +446,8 @@
ALTER TABLE document ATTACH PARTITION document_places FOR VALUES IN ('Places');
-- Enable RLS on partitioned table
ALTER TABLE document ENABLE ROW LEVEL SECURITY;
+NOTICE: ALTER action ENABLE ROW SECURITY on relation "document" does not affect present partitions
+HINT: Partitions may be modified individually, or specify ONLY to suppress this message.
-- create policies on partitioned table
CREATE POLICY p1 ON document AS PERMISSIVE
USING (dlevel <= (SELECT seclv FROM users WHERE pguser = current_user));
@@ -760,6 +762,8 @@
-- FORCE ROW LEVEL SECURITY applies RLS to owners too
ALTER TABLE document FORCE ROW LEVEL SECURITY;
+NOTICE: ALTER action FORCE ROW SECURITY on relation "document" does not affect present partitions
+HINT: Partitions may be modified individually, or specify ONLY to suppress this message.
EXECUTE graph_rls_query;
pguser | aid | dtitle | dlevel
... |
|
Linux - Debian Trixie - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/graph_table_rls.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/graph_table_rls.out 2026-03-22 13:24:16.015265240 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/graph_table_rls.out 2026-03-22 13:34:36.845554608 +0000
@@ -446,6 +446,8 @@
ALTER TABLE document ATTACH PARTITION document_places FOR VALUES IN ('Places');
-- Enable RLS on partitioned table
ALTER TABLE document ENABLE ROW LEVEL SECURITY;
+NOTICE: ALTER action ENABLE ROW SECURITY on relation "document" does not affect present partitions
+HINT: Partitions may be modified individually, or specify ONLY to suppress this message.
-- create policies on partitioned table
CREATE POLICY p1 ON document AS PERMISSIVE
USING (dlevel <= (SELECT seclv FROM users WHERE pguser = current_user));
@@ -760,6 +762,8 @@
-- FORCE ROW LEVEL SECURITY applies RLS to owners too
ALTER TABLE document FORCE ROW LEVEL SECURITY;
+NOTICE: ALTER action FORCE ROW SECURITY on relation "document" does not affect present partitions
+HINT: Partitions may be modified individually, or specify ONLY to suppress this message.
EXECUTE graph_rls_query;
pguser | aid | dtitle | dlevel
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/graph_table_rls.out /tmp/cirrus-ci-build/src/test/modules/test_p...
--- /tmp/cirrus-ci-build/src/test/regress/expected/graph_table_rls.out 2026-03-22 13:24:16.015265240 +0000
+++ /tmp/cirrus-ci-build/src/test/modules/test_plan_advice/tmp_check/results/graph_table_rls.out 2026-03-22 13:34:11.521...
@@ -446,6 +446,8 @@
ALTER TABLE document ATTACH PARTITION document_places FOR VALUES IN ('Places');
-- Enable RLS on partitioned table
ALTER TABLE document ENABLE ROW LEVEL SECURITY;
+NOTICE: ALTER action ENABLE ROW SECURITY on relation "document" does not affect present partitions
+HINT: Partitions may be modified individually, or specify ONLY to suppress this message.
-- create policies on partitioned table
CREATE POLICY p1 ON document AS PERMISSIVE
USING (dlevel <= (SELECT seclv FROM users WHERE pguser = current_user));
@@ -760,6 +762,8 @@
-- FORCE ROW LEVEL SECURITY applies RLS to owners too
ALTER TABLE document FORCE ROW LEVEL SECURITY;
+NOTICE: ALTER action FORCE ROW SECURITY on relation "document" does not affect present partitions
+HINT: Partitions may be modified individually, or specify ONLY to suppress this message.
EXECUTE graph_rls_query;
pguser | aid | dtitle | dlevel
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/graph_table_rls.out /tmp/cirrus-ci-build/src/test/recovery/tmp_c...
--- /tmp/cirrus-ci-build/src/test/regress/expected/graph_table_rls.out 2026-03-22 13:24:16.015265240 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/graph_table_rls.out 2026-03-22 13:35:37.578223479 +0000
@@ -446,6 +446,8 @@
ALTER TABLE document ATTACH PARTITION document_places FOR VALUES IN ('Places');
-- Enable RLS on partitioned table
ALTER TABLE document ENABLE ROW LEVEL SECURITY;
+NOTICE: ALTER action ENABLE ROW SECURITY on relation "document" does not affect present partitions
+HINT: Partitions may be modified individually, or specify ONLY to suppress this message.
-- create policies on partitioned table
CREATE POLICY p1 ON document AS PERMISSIVE
USING (dlevel <= (SELECT seclv FROM users WHERE pguser = current_user));
@@ -760,6 +762,8 @@
-- FORCE ROW LEVEL SECURITY applies RLS to owners too
ALTER TABLE document FORCE ROW LEVEL SECURITY;
+NOTICE: ALTER action FORCE ROW SECURITY on relation "document" does not affect present partitions
+HINT: Partitions may be modified individually, or specify ONLY to suppress this message.
EXECUTE graph_rls_query;
pguser | aid | dtitle | dlevel
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/graph_table_rls.out /tmp/cirrus-ci-build/src/test/regress/result...
--- /tmp/cirrus-ci-build/src/test/regress/expected/graph_table_rls.out 2026-03-22 13:24:16.015265240 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/graph_table_rls.out 2026-03-22 13:30:45.735337225 +0000
@@ -446,6 +446,8 @@
ALTER TABLE document ATTACH PARTITION document_places FOR VALUES IN ('Places');
-- Enable RLS on partitioned table
ALTER TABLE document ENABLE ROW LEVEL SECURITY;
+NOTICE: ALTER action ENABLE ROW SECURITY on relation "document" does not affect present partitions
+HINT: Partitions may be modified individually, or specify ONLY to suppress this message.
-- create policies on partitioned table
CREATE POLICY p1 ON document AS PERMISSIVE
USING (dlevel <= (SELECT seclv FROM users WHERE pguser = current_user));
@@ -760,6 +762,8 @@
-- FORCE ROW LEVEL SECURITY applies RLS to owners too
ALTER TABLE document FORCE ROW LEVEL SECURITY;
+NOTICE: ALTER action FORCE ROW SECURITY on relation "document" does not affect present partitions
+HINT: Partitions may be modified individually, or specify ONLY to suppress this message.
EXECUTE graph_rls_query;
pguser | aid | dtitle | dlevel
... |
| 58/6356 |
Hash-based MCV matching for large IN-lists |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/updatable_views.out /tmp/cirrus-ci-build/build/testrun/test_plan...
--- /tmp/cirrus-ci-build/src/test/regress/expected/updatable_views.out 2026-03-22 08:37:31.734126000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/updatable_views.out 2026-03-22 0...
@@ -1149,6 +1149,9 @@
FROM information_schema.views
WHERE table_name LIKE 'rw_view%'
ORDER BY table_name;
+WARNING: supplied plan advice was not enforced
+DETAIL: advice SEQ_SCAN(pg_trigger@exists_5) feedback is "matched, failed"
+advice NO_GATHER(pg_trigger@exists_5) feedback is "matched, failed"
table_name | is_updatable | is_insertable_into | is_trigger_updatable | is_trigger_deletable | is_trigger_insertable_i...
------------+--------------+--------------------+----------------------+----------------------+------------------------...
rw_view1 | NO | NO | YES | YES | YES |
| 58/6516 |
Optional skipping of unchanged relations during ANALYZE? |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/analyze_missing_stats_only.out C:/cirrus/build/testrun/...
--- C:/cirrus/src/test/regress/expected/analyze_missing_stats_only.out 2026-03-22 02:37:46.214456600 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/analyze_missing_stats_only.out 2026-03-22 02:42:40.56...
@@ -33,65 +33,7 @@
SELECT count(*) AS stat_rows
FROM pg_statistic
WHERE starelid = 'ms1'::regclass;
- stat_rows
------------
- 1
-(1 row)
-
--- 4. Add new column → missing stats for column b
-ALTER TABLE ms1 ADD COLUMN b int;
--- Should analyze again
-ANALYZE (MISSING_STATS_ONLY) ms1;
--- Now both columns should have stats
-SELECT count(*) AS stat_rows
-FROM pg_statistic
-WHERE starelid = 'ms1'::regclass;
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/analyze_missing_stats_only.out C:/cirrus/build/testrun/...
--- C:/cirrus/src/test/regress/expected/analyze_missing_stats_only.out 2026-03-22 02:37:46.214456600 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/analyze_missing_stats_only.out 2026-03-22 02:46:11....
@@ -33,65 +33,7 @@
SELECT count(*) AS stat_rows
FROM pg_statistic
WHERE starelid = 'ms1'::regclass;
- stat_rows
------------
- 1
-(1 row)
-
--- 4. Add new column → missing stats for column b
-ALTER TABLE ms1 ADD COLUMN b int;
--- Should analyze again
-ANALYZE (MISSING_STATS_ONLY) ms1;
--- Now both columns should have stats
-SELECT count(*) AS stat_rows
-FROM pg_statistic
-WHERE starelid = 'ms1'::regclass;
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/analyze_missing_stats_only.out C:/cirrus/build/testrun/...
--- C:/cirrus/src/test/regress/expected/analyze_missing_stats_only.out 2026-03-22 02:37:46.214456600 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/analyze_missing_stats_only.out 2026-03-22 02:42:40.221577500 +0000
@@ -33,65 +33,7 @@
SELECT count(*) AS stat_rows
FROM pg_statistic
WHERE starelid = 'ms1'::regclass;
- stat_rows
------------
- 1
-(1 row)
-
--- 4. Add new column → missing stats for column b
-ALTER TABLE ms1 ADD COLUMN b int;
--- Should analyze again
-ANALYZE (MISSING_STATS_ONLY) ms1;
--- Now both columns should have stats
-SELECT count(*) AS stat_rows
-FROM pg_statistic
-WHERE starelid = 'ms1'::regclass;
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/analyze_missing_stats_only.out C:/cirrus/build/testrun/...
--- C:/cirrus/src/test/regress/expected/analyze_missing_stats_only.out 2026-03-22 02:37:46.214456600 +0000
+++ C:/cirrus/build/testrun/test_plan_advice/001_replan_regress/data/results/analyze_missing_stats_only.out 2026-03-22 0...
@@ -33,65 +33,7 @@
SELECT count(*) AS stat_rows
FROM pg_statistic
WHERE starelid = 'ms1'::regclass;
- stat_rows
------------
- 1
-(1 row)
-
--- 4. Add new column → missing stats for column b
-ALTER TABLE ms1 ADD COLUMN b int;
--- Should analyze again
-ANALYZE (MISSING_STATS_ONLY) ms1;
--- Now both columns should have stats
-SELECT count(*) AS stat_rows
-FROM pg_statistic
-WHERE starelid = 'ms1'::regclass;
... |
|
macOS - Sequoia - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/analyze_missing_stats_only.out /Users/admin/pgsql/build/testrun/pg...
--- /Users/admin/pgsql/src/test/regress/expected/analyze_missing_stats_only.out 2026-03-22 02:37:28
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/analyze_missing_stats_only.out 2026-03-22 02...
@@ -33,65 +33,7 @@
SELECT count(*) AS stat_rows
FROM pg_statistic
WHERE starelid = 'ms1'::regclass;
- stat_rows
------------
- 1
-(1 row)
-
--- 4. Add new column → missing stats for column b
-ALTER TABLE ms1 ADD COLUMN b int;
--- Should analyze again
-ANALYZE (MISSING_STATS_ONLY) ms1;
--- Now both columns should have stats
-SELECT count(*) AS stat_rows
-FROM pg_statistic
-WHERE starelid = 'ms1'::regclass;
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/analyze_missing_stats_only.out /Users/admin/pgsql/build/testrun/re...
--- /Users/admin/pgsql/src/test/regress/expected/analyze_missing_stats_only.out 2026-03-22 02:37:28
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/analyze_missing_stats_only.out 2026-03-22 ...
@@ -33,65 +33,7 @@
SELECT count(*) AS stat_rows
FROM pg_statistic
WHERE starelid = 'ms1'::regclass;
- stat_rows
------------
- 1
-(1 row)
-
--- 4. Add new column → missing stats for column b
-ALTER TABLE ms1 ADD COLUMN b int;
--- Should analyze again
-ANALYZE (MISSING_STATS_ONLY) ms1;
--- Now both columns should have stats
-SELECT count(*) AS stat_rows
-FROM pg_statistic
-WHERE starelid = 'ms1'::regclass;
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/analyze_missing_stats_only.out /Users/admin/pgsql/build/testrun/re...
--- /Users/admin/pgsql/src/test/regress/expected/analyze_missing_stats_only.out 2026-03-22 02:37:28
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/analyze_missing_stats_only.out 2026-03-22 02:43:09
@@ -33,65 +33,7 @@
SELECT count(*) AS stat_rows
FROM pg_statistic
WHERE starelid = 'ms1'::regclass;
- stat_rows
------------
- 1
-(1 row)
-
--- 4. Add new column → missing stats for column b
-ALTER TABLE ms1 ADD COLUMN b int;
--- Should analyze again
-ANALYZE (MISSING_STATS_ONLY) ms1;
--- Now both columns should have stats
-SELECT count(*) AS stat_rows
-FROM pg_statistic
-WHERE starelid = 'ms1'::regclass;
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/analyze_missing_stats_only.out /Users/admin/pgsql/build/testrun/te...
--- /Users/admin/pgsql/src/test/regress/expected/analyze_missing_stats_only.out 2026-03-22 02:37:28
+++ /Users/admin/pgsql/build/testrun/test_plan_advice/001_replan_regress/data/results/analyze_missing_stats_only.out 202...
@@ -33,65 +33,7 @@
SELECT count(*) AS stat_rows
FROM pg_statistic
WHERE starelid = 'ms1'::regclass;
- stat_rows
------------
- 1
-(1 row)
-
--- 4. Add new column → missing stats for column b
-ALTER TABLE ms1 ADD COLUMN b int;
--- Should analyze again
-ANALYZE (MISSING_STATS_ONLY) ms1;
--- Now both columns should have stats
-SELECT count(*) AS stat_rows
-FROM pg_statistic
-WHERE starelid = 'ms1'::regclass;
... |
|
Windows - Server 2022, MinGW64 - Meson |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/analyze_missing_stats_only.out C:/cirrus/build/testrun/...
--- C:/cirrus/src/test/regress/expected/analyze_missing_stats_only.out 2026-03-22 02:37:45.110867700 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/analyze_missing_stats_only.out 2026-03-22 02:42:01.86...
@@ -33,65 +33,7 @@
SELECT count(*) AS stat_rows
FROM pg_statistic
WHERE starelid = 'ms1'::regclass;
- stat_rows
------------
- 1
-(1 row)
-
--- 4. Add new column → missing stats for column b
-ALTER TABLE ms1 ADD COLUMN b int;
--- Should analyze again
-ANALYZE (MISSING_STATS_ONLY) ms1;
--- Now both columns should have stats
-SELECT count(*) AS stat_rows
-FROM pg_statistic
-WHERE starelid = 'ms1'::regclass;
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/analyze_missing_stats_only.out C:/cirrus/build/testrun/...
--- C:/cirrus/src/test/regress/expected/analyze_missing_stats_only.out 2026-03-22 02:37:45.110867700 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/analyze_missing_stats_only.out 2026-03-22 02:45:16....
@@ -33,65 +33,7 @@
SELECT count(*) AS stat_rows
FROM pg_statistic
WHERE starelid = 'ms1'::regclass;
- stat_rows
------------
- 1
-(1 row)
-
--- 4. Add new column → missing stats for column b
-ALTER TABLE ms1 ADD COLUMN b int;
--- Should analyze again
-ANALYZE (MISSING_STATS_ONLY) ms1;
--- Now both columns should have stats
-SELECT count(*) AS stat_rows
-FROM pg_statistic
-WHERE starelid = 'ms1'::regclass;
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/analyze_missing_stats_only.out C:/cirrus/build/testrun/...
--- C:/cirrus/src/test/regress/expected/analyze_missing_stats_only.out 2026-03-22 02:37:45.110867700 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/analyze_missing_stats_only.out 2026-03-22 02:42:01.114883900 +0000
@@ -33,65 +33,7 @@
SELECT count(*) AS stat_rows
FROM pg_statistic
WHERE starelid = 'ms1'::regclass;
- stat_rows
------------
- 1
-(1 row)
-
--- 4. Add new column → missing stats for column b
-ALTER TABLE ms1 ADD COLUMN b int;
--- Should analyze again
-ANALYZE (MISSING_STATS_ONLY) ms1;
--- Now both columns should have stats
-SELECT count(*) AS stat_rows
-FROM pg_statistic
-WHERE starelid = 'ms1'::regclass;
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/analyze_missing_stats_only.out C:/cirrus/build/testrun/...
--- C:/cirrus/src/test/regress/expected/analyze_missing_stats_only.out 2026-03-22 02:37:45.110867700 +0000
+++ C:/cirrus/build/testrun/test_plan_advice/001_replan_regress/data/results/analyze_missing_stats_only.out 2026-03-22 0...
@@ -33,65 +33,7 @@
SELECT count(*) AS stat_rows
FROM pg_statistic
WHERE starelid = 'ms1'::regclass;
- stat_rows
------------
- 1
-(1 row)
-
--- 4. Add new column → missing stats for column b
-ALTER TABLE ms1 ADD COLUMN b int;
--- Should analyze again
-ANALYZE (MISSING_STATS_ONLY) ms1;
--- Now both columns should have stats
-SELECT count(*) AS stat_rows
-FROM pg_statistic
-WHERE starelid = 'ms1'::regclass;
... |
|
Linux - Debian Trixie - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/analyze_missing_stats_only.out /tmp/cirrus-ci-build/build/testru...
--- /tmp/cirrus-ci-build/src/test/regress/expected/analyze_missing_stats_only.out 2026-03-22 02:37:58.290914455 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/analyze_missing_stats_only.out 2026-03-22 ...
@@ -33,65 +33,7 @@
SELECT count(*) AS stat_rows
FROM pg_statistic
WHERE starelid = 'ms1'::regclass;
- stat_rows
------------
- 1
-(1 row)
-
--- 4. Add new column → missing stats for column b
-ALTER TABLE ms1 ADD COLUMN b int;
--- Should analyze again
-ANALYZE (MISSING_STATS_ONLY) ms1;
--- Now both columns should have stats
-SELECT count(*) AS stat_rows
-FROM pg_statistic
-WHERE starelid = 'ms1'::regclass;
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/analyze_missing_stats_only.out /tmp/cirrus-ci-build/build/testru...
--- /tmp/cirrus-ci-build/src/test/regress/expected/analyze_missing_stats_only.out 2026-03-22 02:37:58.290914455 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/analyze_missing_stats_only.out 2026-03-2...
@@ -33,65 +33,7 @@
SELECT count(*) AS stat_rows
FROM pg_statistic
WHERE starelid = 'ms1'::regclass;
- stat_rows
------------
- 1
-(1 row)
-
--- 4. Add new column → missing stats for column b
-ALTER TABLE ms1 ADD COLUMN b int;
--- Should analyze again
-ANALYZE (MISSING_STATS_ONLY) ms1;
--- Now both columns should have stats
-SELECT count(*) AS stat_rows
-FROM pg_statistic
-WHERE starelid = 'ms1'::regclass;
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/analyze_missing_stats_only.out /tmp/cirrus-ci-build/build/testru...
--- /tmp/cirrus-ci-build/src/test/regress/expected/analyze_missing_stats_only.out 2026-03-22 02:37:58.290914455 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/analyze_missing_stats_only.out 2026-03-22 02:41:40.063183...
@@ -33,65 +33,7 @@
SELECT count(*) AS stat_rows
FROM pg_statistic
WHERE starelid = 'ms1'::regclass;
- stat_rows
------------
- 1
-(1 row)
-
--- 4. Add new column → missing stats for column b
-ALTER TABLE ms1 ADD COLUMN b int;
--- Should analyze again
-ANALYZE (MISSING_STATS_ONLY) ms1;
--- Now both columns should have stats
-SELECT count(*) AS stat_rows
-FROM pg_statistic
-WHERE starelid = 'ms1'::regclass;
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/analyze_missing_stats_only.out /tmp/cirrus-ci-build/build/testru...
--- /tmp/cirrus-ci-build/src/test/regress/expected/analyze_missing_stats_only.out 2026-03-22 02:37:58.290914455 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/analyze_missing_stats_only.out 2...
@@ -33,65 +33,7 @@
SELECT count(*) AS stat_rows
FROM pg_statistic
WHERE starelid = 'ms1'::regclass;
- stat_rows
------------
- 1
-(1 row)
-
--- 4. Add new column → missing stats for column b
-ALTER TABLE ms1 ADD COLUMN b int;
--- Should analyze again
-ANALYZE (MISSING_STATS_ONLY) ms1;
--- Now both columns should have stats
-SELECT count(*) AS stat_rows
-FROM pg_statistic
-WHERE starelid = 'ms1'::regclass;
... |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/analyze_missing_stats_only.out /home/postgres/postgres/build/...
--- /home/postgres/postgres/src/test/regress/expected/analyze_missing_stats_only.out 2026-03-22 02:37:59.462235725 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/analyze_missing_stats_only.out 2026-03-...
@@ -33,65 +33,7 @@
SELECT count(*) AS stat_rows
FROM pg_statistic
WHERE starelid = 'ms1'::regclass;
- stat_rows
------------
- 1
-(1 row)
-
--- 4. Add new column → missing stats for column b
-ALTER TABLE ms1 ADD COLUMN b int;
--- Should analyze again
-ANALYZE (MISSING_STATS_ONLY) ms1;
--- Now both columns should have stats
-SELECT count(*) AS stat_rows
-FROM pg_statistic
-WHERE starelid = 'ms1'::regclass;
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/analyze_missing_stats_only.out /home/postgres/postgres/build/...
--- /home/postgres/postgres/src/test/regress/expected/analyze_missing_stats_only.out 2026-03-22 02:37:59.462235725 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/analyze_missing_stats_only.out 2026-0...
@@ -33,65 +33,7 @@
SELECT count(*) AS stat_rows
FROM pg_statistic
WHERE starelid = 'ms1'::regclass;
- stat_rows
------------
- 1
-(1 row)
-
--- 4. Add new column → missing stats for column b
-ALTER TABLE ms1 ADD COLUMN b int;
--- Should analyze again
-ANALYZE (MISSING_STATS_ONLY) ms1;
--- Now both columns should have stats
-SELECT count(*) AS stat_rows
-FROM pg_statistic
-WHERE starelid = 'ms1'::regclass;
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/analyze_missing_stats_only.out /home/postgres/postgres/build/...
--- /home/postgres/postgres/src/test/regress/expected/analyze_missing_stats_only.out 2026-03-22 02:37:59.462235725 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/analyze_missing_stats_only.out 2026-03-22 02:40:35.684...
@@ -33,65 +33,7 @@
SELECT count(*) AS stat_rows
FROM pg_statistic
WHERE starelid = 'ms1'::regclass;
- stat_rows
------------
- 1
-(1 row)
-
--- 4. Add new column → missing stats for column b
-ALTER TABLE ms1 ADD COLUMN b int;
--- Should analyze again
-ANALYZE (MISSING_STATS_ONLY) ms1;
--- Now both columns should have stats
-SELECT count(*) AS stat_rows
-FROM pg_statistic
-WHERE starelid = 'ms1'::regclass;
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/analyze_missing_stats_only.out /home/postgres/postgres/build/...
--- /home/postgres/postgres/src/test/regress/expected/analyze_missing_stats_only.out 2026-03-22 02:37:59.462235725 +0000
+++ /home/postgres/postgres/build/testrun/test_plan_advice/001_replan_regress/data/results/analyze_missing_stats_only.ou...
@@ -33,65 +33,7 @@
SELECT count(*) AS stat_rows
FROM pg_statistic
WHERE starelid = 'ms1'::regclass;
- stat_rows
------------
- 1
-(1 row)
-
--- 4. Add new column → missing stats for column b
-ALTER TABLE ms1 ADD COLUMN b int;
--- Should analyze again
-ANALYZE (MISSING_STATS_ONLY) ms1;
--- Now both columns should have stats
-SELECT count(*) AS stat_rows
-FROM pg_statistic
-WHERE starelid = 'ms1'::regclass;
... |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/analyze_missing_stats_only.out /tmp/cirrus-ci-build/build/testru...
--- /tmp/cirrus-ci-build/src/test/regress/expected/analyze_missing_stats_only.out 2026-03-22 02:37:57.925148000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/analyze_missing_stats_only.out 2026-03-22 ...
@@ -33,65 +33,7 @@
SELECT count(*) AS stat_rows
FROM pg_statistic
WHERE starelid = 'ms1'::regclass;
- stat_rows
------------
- 1
-(1 row)
-
--- 4. Add new column → missing stats for column b
-ALTER TABLE ms1 ADD COLUMN b int;
--- Should analyze again
-ANALYZE (MISSING_STATS_ONLY) ms1;
--- Now both columns should have stats
-SELECT count(*) AS stat_rows
-FROM pg_statistic
-WHERE starelid = 'ms1'::regclass;
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/analyze_missing_stats_only.out /tmp/cirrus-ci-build/build/testru...
--- /tmp/cirrus-ci-build/src/test/regress/expected/analyze_missing_stats_only.out 2026-03-22 02:37:57.925148000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/analyze_missing_stats_only.out 2026-03-2...
@@ -33,65 +33,7 @@
SELECT count(*) AS stat_rows
FROM pg_statistic
WHERE starelid = 'ms1'::regclass;
- stat_rows
------------
- 1
-(1 row)
-
--- 4. Add new column → missing stats for column b
-ALTER TABLE ms1 ADD COLUMN b int;
--- Should analyze again
-ANALYZE (MISSING_STATS_ONLY) ms1;
--- Now both columns should have stats
-SELECT count(*) AS stat_rows
-FROM pg_statistic
-WHERE starelid = 'ms1'::regclass;
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/analyze_missing_stats_only.out /tmp/cirrus-ci-build/build/testru...
--- /tmp/cirrus-ci-build/src/test/regress/expected/analyze_missing_stats_only.out 2026-03-22 02:37:57.925148000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/analyze_missing_stats_only.out 2026-03-22 02:41:23.114481...
@@ -33,65 +33,7 @@
SELECT count(*) AS stat_rows
FROM pg_statistic
WHERE starelid = 'ms1'::regclass;
- stat_rows
------------
- 1
-(1 row)
-
--- 4. Add new column → missing stats for column b
-ALTER TABLE ms1 ADD COLUMN b int;
--- Should analyze again
-ANALYZE (MISSING_STATS_ONLY) ms1;
--- Now both columns should have stats
-SELECT count(*) AS stat_rows
-FROM pg_statistic
-WHERE starelid = 'ms1'::regclass;
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/analyze_missing_stats_only.out /tmp/cirrus-ci-build/build/testru...
--- /tmp/cirrus-ci-build/src/test/regress/expected/analyze_missing_stats_only.out 2026-03-22 02:37:57.925148000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/analyze_missing_stats_only.out 2...
@@ -33,65 +33,7 @@
SELECT count(*) AS stat_rows
FROM pg_statistic
WHERE starelid = 'ms1'::regclass;
- stat_rows
------------
- 1
-(1 row)
-
--- 4. Add new column → missing stats for column b
-ALTER TABLE ms1 ADD COLUMN b int;
--- Should analyze again
-ANALYZE (MISSING_STATS_ONLY) ms1;
--- Now both columns should have stats
-SELECT count(*) AS stat_rows
-FROM pg_statistic
-WHERE starelid = 'ms1'::regclass;
... |
|
Linux - Debian Trixie - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/analyze_missing_stats_only.out /tmp/cirrus-ci-build/src/bin/pg_u...
--- /tmp/cirrus-ci-build/src/test/regress/expected/analyze_missing_stats_only.out 2026-03-22 02:37:43.909185457 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/analyze_missing_stats_only.out 2026-03-22 02:45:17.9487060...
@@ -33,65 +33,7 @@
SELECT count(*) AS stat_rows
FROM pg_statistic
WHERE starelid = 'ms1'::regclass;
- stat_rows
------------
- 1
-(1 row)
-
--- 4. Add new column → missing stats for column b
-ALTER TABLE ms1 ADD COLUMN b int;
--- Should analyze again
-ANALYZE (MISSING_STATS_ONLY) ms1;
--- Now both columns should have stats
-SELECT count(*) AS stat_rows
-FROM pg_statistic
-WHERE starelid = 'ms1'::regclass;
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/analyze_missing_stats_only.out /tmp/cirrus-ci-build/src/test/mod...
--- /tmp/cirrus-ci-build/src/test/regress/expected/analyze_missing_stats_only.out 2026-03-22 02:37:43.909185457 +0000
+++ /tmp/cirrus-ci-build/src/test/modules/test_plan_advice/tmp_check/results/analyze_missing_stats_only.out 2026-03-22 0...
@@ -33,65 +33,7 @@
SELECT count(*) AS stat_rows
FROM pg_statistic
WHERE starelid = 'ms1'::regclass;
- stat_rows
------------
- 1
-(1 row)
-
--- 4. Add new column → missing stats for column b
-ALTER TABLE ms1 ADD COLUMN b int;
--- Should analyze again
-ANALYZE (MISSING_STATS_ONLY) ms1;
--- Now both columns should have stats
-SELECT count(*) AS stat_rows
-FROM pg_statistic
-WHERE starelid = 'ms1'::regclass;
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/analyze_missing_stats_only.out /tmp/cirrus-ci-build/src/test/rec...
--- /tmp/cirrus-ci-build/src/test/regress/expected/analyze_missing_stats_only.out 2026-03-22 02:37:43.909185457 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/analyze_missing_stats_only.out 2026-03-22 02:47:08.22870310...
@@ -33,65 +33,7 @@
SELECT count(*) AS stat_rows
FROM pg_statistic
WHERE starelid = 'ms1'::regclass;
- stat_rows
------------
- 1
-(1 row)
-
--- 4. Add new column → missing stats for column b
-ALTER TABLE ms1 ADD COLUMN b int;
--- Should analyze again
-ANALYZE (MISSING_STATS_ONLY) ms1;
--- Now both columns should have stats
-SELECT count(*) AS stat_rows
-FROM pg_statistic
-WHERE starelid = 'ms1'::regclass;
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/analyze_missing_stats_only.out /tmp/cirrus-ci-build/src/test/reg...
--- /tmp/cirrus-ci-build/src/test/regress/expected/analyze_missing_stats_only.out 2026-03-22 02:37:43.909185457 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/analyze_missing_stats_only.out 2026-03-22 02:43:19.436713444 +0000
@@ -33,65 +33,7 @@
SELECT count(*) AS stat_rows
FROM pg_statistic
WHERE starelid = 'ms1'::regclass;
- stat_rows
------------
- 1
-(1 row)
-
--- 4. Add new column → missing stats for column b
-ALTER TABLE ms1 ADD COLUMN b int;
--- Should analyze again
-ANALYZE (MISSING_STATS_ONLY) ms1;
--- Now both columns should have stats
-SELECT count(*) AS stat_rows
-FROM pg_statistic
-WHERE starelid = 'ms1'::regclass;
... |
| 58/6444 |
Set 1s WaitLatch timeout if standby limit has expired in ResolveRecoveryConflictWithBufferPin |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/updatable_views.out C:/cirrus/build/testrun/test_plan_a...
--- C:/cirrus/src/test/regress/expected/updatable_views.out 2026-03-21 21:20:43.535715800 +0000
+++ C:/cirrus/build/testrun/test_plan_advice/001_replan_regress/data/results/updatable_views.out 2026-03-21 21:23:51.775...
@@ -2700,6 +2700,9 @@
CREATE VIEW rw_view2 AS SELECT * FROM rw_view1 WHERE a > 0;
CREATE VIEW rw_view3 AS SELECT * FROM rw_view2 WITH CHECK OPTION;
SELECT * FROM information_schema.views WHERE table_name LIKE E'rw\\_view_' ORDER BY table_name;
+WARNING: supplied plan advice was not enforced
+DETAIL: advice SEQ_SCAN(pg_trigger@exists_1) feedback is "matched, failed"
+advice NO_GATHER(pg_trigger@exists_1) feedback is "matched, failed"
table_catalog | table_schema | table_name | view_definition | check_option | is_updatable | is_insertable_into | is_...
---------------+--------------+------------+-------------------+--------------+--------------+--------------------+----...
regression | public | rw_view1 | SELECT a +| CASCADED | YES | YES | NO ... |
| 58/6524 |
[PATCH] Add RetrieveInstrumentation hook for CustomScan providers so that Parallel CustomScan providers can currently aggregate worker instrumentation before DSM unlinking |
|
Windows - Server 2022, MinGW64 - Meson |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/updatable_views.out C:/cirrus/build/testrun/test_plan_a...
--- C:/cirrus/src/test/regress/expected/updatable_views.out 2026-03-21 20:00:59.610613500 +0000
+++ C:/cirrus/build/testrun/test_plan_advice/001_replan_regress/data/results/updatable_views.out 2026-03-21 20:04:27.241...
@@ -2519,6 +2519,9 @@
Options: check_option=local
SELECT * FROM information_schema.views WHERE table_name = 'rw_view1';
+WARNING: supplied plan advice was not enforced
+DETAIL: advice SEQ_SCAN(pg_trigger@exists_6) feedback is "matched, failed"
+advice NO_GATHER(pg_trigger@exists_6) feedback is "matched, failed"
table_catalog | table_schema | table_name | view_definition | check_option | is_updatable | is_insertable_into | is_t...
---------------+--------------+------------+------------------+--------------+--------------+--------------------+-----...
regression | public | rw_view1 | SELECT a, +| LOCAL | YES | YES | NO ... |
| 58/6224 |
Give Plugins control at the end of CHECKPOINT to store their state |
|
macOS - Sequoia - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/updatable_views.out /Users/admin/pgsql/build/testrun/test_plan_adv...
--- /Users/admin/pgsql/src/test/regress/expected/updatable_views.out 2026-03-20 04:14:33
+++ /Users/admin/pgsql/build/testrun/test_plan_advice/001_replan_regress/data/results/updatable_views.out 2026-03-20 04:...
@@ -1013,6 +1013,9 @@
FROM information_schema.views
WHERE table_name LIKE 'rw_view%'
ORDER BY table_name;
+WARNING: supplied plan advice was not enforced
+DETAIL: advice SEQ_SCAN(pg_trigger@exists_1) feedback is "matched, failed"
+advice NO_GATHER(pg_trigger@exists_1) feedback is "matched, failed"
table_name | is_updatable | is_insertable_into | is_trigger_updatable | is_trigger_deletable | is_trigger_insertable_i...
------------+--------------+--------------------+----------------------+----------------------+------------------------...
rw_view1 | NO | NO | NO | NO | NO |
| 58/6553 |
Decorrelate nested tuple hash tables |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/union.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_u...
--- /tmp/cirrus-ci-build/src/test/regress/expected/union.out 2026-03-19 21:43:20.144717000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/union.out 2026-03-19 21:45:14.508290000 +0...
@@ -550,9 +550,9 @@
select x from (values (array[1, 2]), (array[1, 3])) _(x) union select x from (values (array[1, 2]), (array[1, 4])) _(x)...
x
-------
+ {1,2}
{1,4}
{1,3}
- {1,2}
(3 rows)
explain (costs off) |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/union.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stream...
--- /tmp/cirrus-ci-build/src/test/regress/expected/union.out 2026-03-19 21:43:20.144717000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/union.out 2026-03-19 21:46:35.750607000 ...
@@ -550,9 +550,9 @@
select x from (values (array[1, 2]), (array[1, 3])) _(x) union select x from (values (array[1, 2]), (array[1, 4])) _(x)...
x
-------
+ {1,2}
{1,4}
{1,3}
- {1,2}
(3 rows)
explain (costs off) |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/union.out /tmp/cirrus-ci-build/build/testrun/test_plan_advice/00...
--- /tmp/cirrus-ci-build/src/test/regress/expected/union.out 2026-03-19 21:43:20.144717000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/union.out 2026-03-19 21:51:32.47...
@@ -550,9 +550,9 @@
select x from (values (array[1, 2]), (array[1, 3])) _(x) union select x from (values (array[1, 2]), (array[1, 4])) _(x)...
x
-------
+ {1,2}
{1,4}
{1,3}
- {1,2}
(3 rows)
explain (costs off) |
| 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/test_plan_advic...
--- C:/cirrus/src/test/regress/expected/publication.out 2026-03-19 21:10:23.423981100 +0000
+++ C:/cirrus/build/testrun/test_plan_advice/001_replan_regress/data/results/publication.out 2026-03-19 21:29:14.4767239...
@@ -753,6 +753,8 @@
-- 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: logical decoding must be enabled to publish logical changes
+HINT: Before creating subscriptions, ensure that "wal_level" is set to "replica" or higher.
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/test_plan_advice/...
--- /Users/admin/pgsql/src/test/regress/expected/publication.out 2026-03-19 21:10:27
+++ /Users/admin/pgsql/build/testrun/test_plan_advice/001_replan_regress/data/results/publication.out 2026-03-19 21:21:2...
@@ -753,6 +753,8 @@
-- 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: logical decoding must be enabled to publish logical changes
+HINT: Before creating subscriptions, ensure that "wal_level" is set to "replica" or higher.
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/test_plan_advic...
--- C:/cirrus/src/test/regress/expected/publication.out 2026-03-19 21:10:00.574561000 +0000
+++ C:/cirrus/build/testrun/test_plan_advice/001_replan_regress/data/results/publication.out 2026-03-19 21:26:52.8687028...
@@ -753,6 +753,8 @@
-- 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: logical decoding must be enabled to publish logical changes
+HINT: Before creating subscriptions, ensure that "wal_level" is set to "replica" or higher.
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/test_plan_adv...
--- /tmp/cirrus-ci-build/src/test/regress/expected/publication.out 2026-03-19 21:10:18.454308568 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/publication.out 2026-03-19 21:19...
@@ -753,6 +753,8 @@
-- 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: logical decoding must be enabled to publish logical changes
+HINT: Before creating subscriptions, ensure that "wal_level" is set to "replica" or higher.
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/test_pl...
--- /home/postgres/postgres/src/test/regress/expected/publication.out Thu Mar 19 21:10:27 2026
+++ /home/postgres/postgres/build/testrun/test_plan_advice/001_replan_regress/data/results/publication.out Thu Mar 19 21...
@@ -753,6 +753,8 @@
-- 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: logical decoding must be enabled to publish logical changes
+HINT: Before creating subscriptions, ensure that "wal_level" is set to "replica" or higher.
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/test_plan_adv...
--- /tmp/cirrus-ci-build/src/test/regress/expected/publication.out 2026-03-19 21:10:10.832084000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/publication.out 2026-03-19 21:18...
@@ -753,6 +753,8 @@
-- 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: logical decoding must be enabled to publish logical changes
+HINT: Before creating subscriptions, ensure that "wal_level" is set to "replica" or higher.
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/test/modules/test_plan_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/publication.out 2026-03-19 21:10:18.501967217 +0000
+++ /tmp/cirrus-ci-build/src/test/modules/test_plan_advice/tmp_check/results/publication.out 2026-03-19 21:18:51.2911476...
@@ -753,6 +753,8 @@
-- 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: logical decoding must be enabled to publish logical changes
+HINT: Before creating subscriptions, ensure that "wal_level" is set to "replica" or higher.
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/test_pl...
--- /home/postgres/postgres/src/test/regress/expected/publication.out 2026-03-19 21:10:40.422557022 +0000
+++ /home/postgres/postgres/build/testrun/test_plan_advice/001_replan_regress/data/results/publication.out 2026-03-19 21...
@@ -753,6 +753,8 @@
-- 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: logical decoding must be enabled to publish logical changes
+HINT: Before creating subscriptions, ensure that "wal_level" is set to "replica" or higher.
SET client_min_messages = 'ERROR';
-- fail
ALTER TABLE testpub_rf_tbl8 ALTER COLUMN x TYPE bigint; |
| 58/6212 |
pg_get_domain_ddl: DDL reconstruction function for CREATE DOMAIN statement |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/create_property_graph.out C:/cirrus/build/testrun/pg_up...
--- C:/cirrus/src/test/regress/expected/create_property_graph.out 2026-03-19 20:56:30.312647100 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/create_property_graph.out 2026-03-19 20:59:34.3921183...
@@ -57,13 +57,16 @@
ALTER PROPERTY GRAPH g3 ALTER VERTEX TABLE t3 DROP LABEL t3l3x; -- error
ERROR: property graph "g3" element "t3" has no label "t3l3x"
ALTER PROPERTY GRAPH g3 ALTER VERTEX TABLE t3 DROP LABEL t3l3;
+ERROR: unsupported object class: 8318
ALTER PROPERTY GRAPH g3 DROP VERTEX TABLES (t2); -- fail
ERROR: cannot drop vertex t2 of property graph g3 because other objects depend on it
DETAIL: edge e1 of property graph g3 depends on vertex t2 of property graph g3
HINT: Use DROP ... CASCADE to drop the dependent objects too.
ALTER PROPERTY GRAPH g3 DROP VERTEX TABLES (t2) CASCADE;
NOTICE: drop cascades to edge e1 of property graph g3
+ERROR: unsupported object class: 8318
ALTER PROPERTY GRAPH g3 DROP EDGE TABLES (e2);
+ERROR: unsupported object class: 8318
CREATE PROPERTY GRAPH g4
VERTEX TABLES (
t1 KEY (a) NO PROPERTIES,
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/create_property_graph.out C:/cirrus/build/testrun/recov...
--- C:/cirrus/src/test/regress/expected/create_property_graph.out 2026-03-19 20:56:30.312647100 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/create_property_graph.out 2026-03-19 21:02:58.95283...
@@ -57,13 +57,16 @@
ALTER PROPERTY GRAPH g3 ALTER VERTEX TABLE t3 DROP LABEL t3l3x; -- error
ERROR: property graph "g3" element "t3" has no label "t3l3x"
ALTER PROPERTY GRAPH g3 ALTER VERTEX TABLE t3 DROP LABEL t3l3;
+ERROR: unsupported object class: 8318
ALTER PROPERTY GRAPH g3 DROP VERTEX TABLES (t2); -- fail
ERROR: cannot drop vertex t2 of property graph g3 because other objects depend on it
DETAIL: edge e1 of property graph g3 depends on vertex t2 of property graph g3
HINT: Use DROP ... CASCADE to drop the dependent objects too.
ALTER PROPERTY GRAPH g3 DROP VERTEX TABLES (t2) CASCADE;
NOTICE: drop cascades to edge e1 of property graph g3
+ERROR: unsupported object class: 8318
ALTER PROPERTY GRAPH g3 DROP EDGE TABLES (e2);
+ERROR: unsupported object class: 8318
CREATE PROPERTY GRAPH g4
VERTEX TABLES (
t1 KEY (a) NO PROPERTIES,
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/create_property_graph.out C:/cirrus/build/testrun/regre...
--- C:/cirrus/src/test/regress/expected/create_property_graph.out 2026-03-19 20:56:30.312647100 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/create_property_graph.out 2026-03-19 20:59:27.184598200 +0000
@@ -57,13 +57,16 @@
ALTER PROPERTY GRAPH g3 ALTER VERTEX TABLE t3 DROP LABEL t3l3x; -- error
ERROR: property graph "g3" element "t3" has no label "t3l3x"
ALTER PROPERTY GRAPH g3 ALTER VERTEX TABLE t3 DROP LABEL t3l3;
+ERROR: unsupported object class: 8318
ALTER PROPERTY GRAPH g3 DROP VERTEX TABLES (t2); -- fail
ERROR: cannot drop vertex t2 of property graph g3 because other objects depend on it
DETAIL: edge e1 of property graph g3 depends on vertex t2 of property graph g3
HINT: Use DROP ... CASCADE to drop the dependent objects too.
ALTER PROPERTY GRAPH g3 DROP VERTEX TABLES (t2) CASCADE;
NOTICE: drop cascades to edge e1 of property graph g3
+ERROR: unsupported object class: 8318
ALTER PROPERTY GRAPH g3 DROP EDGE TABLES (e2);
+ERROR: unsupported object class: 8318
CREATE PROPERTY GRAPH g4
VERTEX TABLES (
t1 KEY (a) NO PROPERTIES,
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/create_property_graph.out C:/cirrus/build/testrun/test_...
--- C:/cirrus/src/test/regress/expected/create_property_graph.out 2026-03-19 20:56:30.312647100 +0000
+++ C:/cirrus/build/testrun/test_plan_advice/001_replan_regress/data/results/create_property_graph.out 2026-03-19 21:14:...
@@ -57,13 +57,16 @@
ALTER PROPERTY GRAPH g3 ALTER VERTEX TABLE t3 DROP LABEL t3l3x; -- error
ERROR: property graph "g3" element "t3" has no label "t3l3x"
ALTER PROPERTY GRAPH g3 ALTER VERTEX TABLE t3 DROP LABEL t3l3;
+ERROR: unsupported object class: 8318
ALTER PROPERTY GRAPH g3 DROP VERTEX TABLES (t2); -- fail
ERROR: cannot drop vertex t2 of property graph g3 because other objects depend on it
DETAIL: edge e1 of property graph g3 depends on vertex t2 of property graph g3
HINT: Use DROP ... CASCADE to drop the dependent objects too.
ALTER PROPERTY GRAPH g3 DROP VERTEX TABLES (t2) CASCADE;
NOTICE: drop cascades to edge e1 of property graph g3
+ERROR: unsupported object class: 8318
ALTER PROPERTY GRAPH g3 DROP EDGE TABLES (e2);
+ERROR: unsupported object class: 8318
CREATE PROPERTY GRAPH g4
VERTEX TABLES (
t1 KEY (a) NO PROPERTIES,
... |
|
Windows - Server 2022, MinGW64 - Meson |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/create_property_graph.out C:/cirrus/build/testrun/pg_up...
--- C:/cirrus/src/test/regress/expected/create_property_graph.out 2026-03-19 20:52:52.270076400 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/create_property_graph.out 2026-03-19 20:57:27.1701636...
@@ -57,13 +57,16 @@
ALTER PROPERTY GRAPH g3 ALTER VERTEX TABLE t3 DROP LABEL t3l3x; -- error
ERROR: property graph "g3" element "t3" has no label "t3l3x"
ALTER PROPERTY GRAPH g3 ALTER VERTEX TABLE t3 DROP LABEL t3l3;
+ERROR: unsupported object class: 8318
ALTER PROPERTY GRAPH g3 DROP VERTEX TABLES (t2); -- fail
ERROR: cannot drop vertex t2 of property graph g3 because other objects depend on it
DETAIL: edge e1 of property graph g3 depends on vertex t2 of property graph g3
HINT: Use DROP ... CASCADE to drop the dependent objects too.
ALTER PROPERTY GRAPH g3 DROP VERTEX TABLES (t2) CASCADE;
NOTICE: drop cascades to edge e1 of property graph g3
+ERROR: unsupported object class: 8318
ALTER PROPERTY GRAPH g3 DROP EDGE TABLES (e2);
+ERROR: unsupported object class: 8318
CREATE PROPERTY GRAPH g4
VERTEX TABLES (
t1 KEY (a) NO PROPERTIES,
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/create_property_graph.out C:/cirrus/build/testrun/recov...
--- C:/cirrus/src/test/regress/expected/create_property_graph.out 2026-03-19 20:52:52.270076400 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/create_property_graph.out 2026-03-19 21:01:13.23548...
@@ -57,13 +57,16 @@
ALTER PROPERTY GRAPH g3 ALTER VERTEX TABLE t3 DROP LABEL t3l3x; -- error
ERROR: property graph "g3" element "t3" has no label "t3l3x"
ALTER PROPERTY GRAPH g3 ALTER VERTEX TABLE t3 DROP LABEL t3l3;
+ERROR: unsupported object class: 8318
ALTER PROPERTY GRAPH g3 DROP VERTEX TABLES (t2); -- fail
ERROR: cannot drop vertex t2 of property graph g3 because other objects depend on it
DETAIL: edge e1 of property graph g3 depends on vertex t2 of property graph g3
HINT: Use DROP ... CASCADE to drop the dependent objects too.
ALTER PROPERTY GRAPH g3 DROP VERTEX TABLES (t2) CASCADE;
NOTICE: drop cascades to edge e1 of property graph g3
+ERROR: unsupported object class: 8318
ALTER PROPERTY GRAPH g3 DROP EDGE TABLES (e2);
+ERROR: unsupported object class: 8318
CREATE PROPERTY GRAPH g4
VERTEX TABLES (
t1 KEY (a) NO PROPERTIES,
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/create_property_graph.out C:/cirrus/build/testrun/regre...
--- C:/cirrus/src/test/regress/expected/create_property_graph.out 2026-03-19 20:52:52.270076400 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/create_property_graph.out 2026-03-19 20:57:19.601329200 +0000
@@ -57,13 +57,16 @@
ALTER PROPERTY GRAPH g3 ALTER VERTEX TABLE t3 DROP LABEL t3l3x; -- error
ERROR: property graph "g3" element "t3" has no label "t3l3x"
ALTER PROPERTY GRAPH g3 ALTER VERTEX TABLE t3 DROP LABEL t3l3;
+ERROR: unsupported object class: 8318
ALTER PROPERTY GRAPH g3 DROP VERTEX TABLES (t2); -- fail
ERROR: cannot drop vertex t2 of property graph g3 because other objects depend on it
DETAIL: edge e1 of property graph g3 depends on vertex t2 of property graph g3
HINT: Use DROP ... CASCADE to drop the dependent objects too.
ALTER PROPERTY GRAPH g3 DROP VERTEX TABLES (t2) CASCADE;
NOTICE: drop cascades to edge e1 of property graph g3
+ERROR: unsupported object class: 8318
ALTER PROPERTY GRAPH g3 DROP EDGE TABLES (e2);
+ERROR: unsupported object class: 8318
CREATE PROPERTY GRAPH g4
VERTEX TABLES (
t1 KEY (a) NO PROPERTIES,
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/create_property_graph.out C:/cirrus/build/testrun/test_...
--- C:/cirrus/src/test/regress/expected/create_property_graph.out 2026-03-19 20:52:52.270076400 +0000
+++ C:/cirrus/build/testrun/test_plan_advice/001_replan_regress/data/results/create_property_graph.out 2026-03-19 21:13:...
@@ -57,13 +57,16 @@
ALTER PROPERTY GRAPH g3 ALTER VERTEX TABLE t3 DROP LABEL t3l3x; -- error
ERROR: property graph "g3" element "t3" has no label "t3l3x"
ALTER PROPERTY GRAPH g3 ALTER VERTEX TABLE t3 DROP LABEL t3l3;
+ERROR: unsupported object class: 8318
ALTER PROPERTY GRAPH g3 DROP VERTEX TABLES (t2); -- fail
ERROR: cannot drop vertex t2 of property graph g3 because other objects depend on it
DETAIL: edge e1 of property graph g3 depends on vertex t2 of property graph g3
HINT: Use DROP ... CASCADE to drop the dependent objects too.
ALTER PROPERTY GRAPH g3 DROP VERTEX TABLES (t2) CASCADE;
NOTICE: drop cascades to edge e1 of property graph g3
+ERROR: unsupported object class: 8318
ALTER PROPERTY GRAPH g3 DROP EDGE TABLES (e2);
+ERROR: unsupported object class: 8318
CREATE PROPERTY GRAPH g4
VERTEX TABLES (
t1 KEY (a) NO PROPERTIES,
... |
|
Linux - Debian Trixie - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/create_property_graph.out /tmp/cirrus-ci-build/build/testrun/pg_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/create_property_graph.out 2026-03-19 20:52:57.254650240 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/create_property_graph.out 2026-03-19 20:56...
@@ -57,13 +57,16 @@
ALTER PROPERTY GRAPH g3 ALTER VERTEX TABLE t3 DROP LABEL t3l3x; -- error
ERROR: property graph "g3" element "t3" has no label "t3l3x"
ALTER PROPERTY GRAPH g3 ALTER VERTEX TABLE t3 DROP LABEL t3l3;
+ERROR: unsupported object class: 8318
ALTER PROPERTY GRAPH g3 DROP VERTEX TABLES (t2); -- fail
ERROR: cannot drop vertex t2 of property graph g3 because other objects depend on it
DETAIL: edge e1 of property graph g3 depends on vertex t2 of property graph g3
HINT: Use DROP ... CASCADE to drop the dependent objects too.
ALTER PROPERTY GRAPH g3 DROP VERTEX TABLES (t2) CASCADE;
NOTICE: drop cascades to edge e1 of property graph g3
+ERROR: unsupported object class: 8318
ALTER PROPERTY GRAPH g3 DROP EDGE TABLES (e2);
+ERROR: unsupported object class: 8318
CREATE PROPERTY GRAPH g4
VERTEX TABLES (
t1 KEY (a) NO PROPERTIES,
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/create_property_graph.out /tmp/cirrus-ci-build/build/testrun/rec...
--- /tmp/cirrus-ci-build/src/test/regress/expected/create_property_graph.out 2026-03-19 20:52:57.254650240 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/create_property_graph.out 2026-03-19 20:...
@@ -57,13 +57,16 @@
ALTER PROPERTY GRAPH g3 ALTER VERTEX TABLE t3 DROP LABEL t3l3x; -- error
ERROR: property graph "g3" element "t3" has no label "t3l3x"
ALTER PROPERTY GRAPH g3 ALTER VERTEX TABLE t3 DROP LABEL t3l3;
+ERROR: unsupported object class: 8318
ALTER PROPERTY GRAPH g3 DROP VERTEX TABLES (t2); -- fail
ERROR: cannot drop vertex t2 of property graph g3 because other objects depend on it
DETAIL: edge e1 of property graph g3 depends on vertex t2 of property graph g3
HINT: Use DROP ... CASCADE to drop the dependent objects too.
ALTER PROPERTY GRAPH g3 DROP VERTEX TABLES (t2) CASCADE;
NOTICE: drop cascades to edge e1 of property graph g3
+ERROR: unsupported object class: 8318
ALTER PROPERTY GRAPH g3 DROP EDGE TABLES (e2);
+ERROR: unsupported object class: 8318
CREATE PROPERTY GRAPH g4
VERTEX TABLES (
t1 KEY (a) NO PROPERTIES,
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/create_property_graph.out /tmp/cirrus-ci-build/build/testrun/reg...
--- /tmp/cirrus-ci-build/src/test/regress/expected/create_property_graph.out 2026-03-19 20:52:57.254650240 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/create_property_graph.out 2026-03-19 20:56:37.634771668 +...
@@ -57,13 +57,16 @@
ALTER PROPERTY GRAPH g3 ALTER VERTEX TABLE t3 DROP LABEL t3l3x; -- error
ERROR: property graph "g3" element "t3" has no label "t3l3x"
ALTER PROPERTY GRAPH g3 ALTER VERTEX TABLE t3 DROP LABEL t3l3;
+ERROR: unsupported object class: 8318
ALTER PROPERTY GRAPH g3 DROP VERTEX TABLES (t2); -- fail
ERROR: cannot drop vertex t2 of property graph g3 because other objects depend on it
DETAIL: edge e1 of property graph g3 depends on vertex t2 of property graph g3
HINT: Use DROP ... CASCADE to drop the dependent objects too.
ALTER PROPERTY GRAPH g3 DROP VERTEX TABLES (t2) CASCADE;
NOTICE: drop cascades to edge e1 of property graph g3
+ERROR: unsupported object class: 8318
ALTER PROPERTY GRAPH g3 DROP EDGE TABLES (e2);
+ERROR: unsupported object class: 8318
CREATE PROPERTY GRAPH g4
VERTEX TABLES (
t1 KEY (a) NO PROPERTIES,
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/create_property_graph.out /tmp/cirrus-ci-build/build/testrun/tes...
--- /tmp/cirrus-ci-build/src/test/regress/expected/create_property_graph.out 2026-03-19 20:52:57.254650240 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/create_property_graph.out 2026-0...
@@ -57,13 +57,16 @@
ALTER PROPERTY GRAPH g3 ALTER VERTEX TABLE t3 DROP LABEL t3l3x; -- error
ERROR: property graph "g3" element "t3" has no label "t3l3x"
ALTER PROPERTY GRAPH g3 ALTER VERTEX TABLE t3 DROP LABEL t3l3;
+ERROR: unsupported object class: 8318
ALTER PROPERTY GRAPH g3 DROP VERTEX TABLES (t2); -- fail
ERROR: cannot drop vertex t2 of property graph g3 because other objects depend on it
DETAIL: edge e1 of property graph g3 depends on vertex t2 of property graph g3
HINT: Use DROP ... CASCADE to drop the dependent objects too.
ALTER PROPERTY GRAPH g3 DROP VERTEX TABLES (t2) CASCADE;
NOTICE: drop cascades to edge e1 of property graph g3
+ERROR: unsupported object class: 8318
ALTER PROPERTY GRAPH g3 DROP EDGE TABLES (e2);
+ERROR: unsupported object class: 8318
CREATE PROPERTY GRAPH g4
VERTEX TABLES (
t1 KEY (a) NO PROPERTIES,
... |
|
macOS - Sequoia - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/create_property_graph.out /Users/admin/pgsql/build/testrun/pg_upgr...
--- /Users/admin/pgsql/src/test/regress/expected/create_property_graph.out 2026-03-19 20:51:00
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/create_property_graph.out 2026-03-19 20:53:3...
@@ -57,13 +57,16 @@
ALTER PROPERTY GRAPH g3 ALTER VERTEX TABLE t3 DROP LABEL t3l3x; -- error
ERROR: property graph "g3" element "t3" has no label "t3l3x"
ALTER PROPERTY GRAPH g3 ALTER VERTEX TABLE t3 DROP LABEL t3l3;
+ERROR: unsupported object class: 8318
ALTER PROPERTY GRAPH g3 DROP VERTEX TABLES (t2); -- fail
ERROR: cannot drop vertex t2 of property graph g3 because other objects depend on it
DETAIL: edge e1 of property graph g3 depends on vertex t2 of property graph g3
HINT: Use DROP ... CASCADE to drop the dependent objects too.
ALTER PROPERTY GRAPH g3 DROP VERTEX TABLES (t2) CASCADE;
NOTICE: drop cascades to edge e1 of property graph g3
+ERROR: unsupported object class: 8318
ALTER PROPERTY GRAPH g3 DROP EDGE TABLES (e2);
+ERROR: unsupported object class: 8318
CREATE PROPERTY GRAPH g4
VERTEX TABLES (
t1 KEY (a) NO PROPERTIES,
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/create_property_graph.out /Users/admin/pgsql/build/testrun/recover...
--- /Users/admin/pgsql/src/test/regress/expected/create_property_graph.out 2026-03-19 20:51:00
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/create_property_graph.out 2026-03-19 20:54...
@@ -57,13 +57,16 @@
ALTER PROPERTY GRAPH g3 ALTER VERTEX TABLE t3 DROP LABEL t3l3x; -- error
ERROR: property graph "g3" element "t3" has no label "t3l3x"
ALTER PROPERTY GRAPH g3 ALTER VERTEX TABLE t3 DROP LABEL t3l3;
+ERROR: unsupported object class: 8318
ALTER PROPERTY GRAPH g3 DROP VERTEX TABLES (t2); -- fail
ERROR: cannot drop vertex t2 of property graph g3 because other objects depend on it
DETAIL: edge e1 of property graph g3 depends on vertex t2 of property graph g3
HINT: Use DROP ... CASCADE to drop the dependent objects too.
ALTER PROPERTY GRAPH g3 DROP VERTEX TABLES (t2) CASCADE;
NOTICE: drop cascades to edge e1 of property graph g3
+ERROR: unsupported object class: 8318
ALTER PROPERTY GRAPH g3 DROP EDGE TABLES (e2);
+ERROR: unsupported object class: 8318
CREATE PROPERTY GRAPH g4
VERTEX TABLES (
t1 KEY (a) NO PROPERTIES,
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/create_property_graph.out /Users/admin/pgsql/build/testrun/regress...
--- /Users/admin/pgsql/src/test/regress/expected/create_property_graph.out 2026-03-19 20:51:00
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/create_property_graph.out 2026-03-19 20:53:31
@@ -57,13 +57,16 @@
ALTER PROPERTY GRAPH g3 ALTER VERTEX TABLE t3 DROP LABEL t3l3x; -- error
ERROR: property graph "g3" element "t3" has no label "t3l3x"
ALTER PROPERTY GRAPH g3 ALTER VERTEX TABLE t3 DROP LABEL t3l3;
+ERROR: unsupported object class: 8318
ALTER PROPERTY GRAPH g3 DROP VERTEX TABLES (t2); -- fail
ERROR: cannot drop vertex t2 of property graph g3 because other objects depend on it
DETAIL: edge e1 of property graph g3 depends on vertex t2 of property graph g3
HINT: Use DROP ... CASCADE to drop the dependent objects too.
ALTER PROPERTY GRAPH g3 DROP VERTEX TABLES (t2) CASCADE;
NOTICE: drop cascades to edge e1 of property graph g3
+ERROR: unsupported object class: 8318
ALTER PROPERTY GRAPH g3 DROP EDGE TABLES (e2);
+ERROR: unsupported object class: 8318
CREATE PROPERTY GRAPH g4
VERTEX TABLES (
t1 KEY (a) NO PROPERTIES,
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/create_property_graph.out /Users/admin/pgsql/build/testrun/test_pl...
--- /Users/admin/pgsql/src/test/regress/expected/create_property_graph.out 2026-03-19 20:51:00
+++ /Users/admin/pgsql/build/testrun/test_plan_advice/001_replan_regress/data/results/create_property_graph.out 2026-03-...
@@ -57,13 +57,16 @@
ALTER PROPERTY GRAPH g3 ALTER VERTEX TABLE t3 DROP LABEL t3l3x; -- error
ERROR: property graph "g3" element "t3" has no label "t3l3x"
ALTER PROPERTY GRAPH g3 ALTER VERTEX TABLE t3 DROP LABEL t3l3;
+ERROR: unsupported object class: 8318
ALTER PROPERTY GRAPH g3 DROP VERTEX TABLES (t2); -- fail
ERROR: cannot drop vertex t2 of property graph g3 because other objects depend on it
DETAIL: edge e1 of property graph g3 depends on vertex t2 of property graph g3
HINT: Use DROP ... CASCADE to drop the dependent objects too.
ALTER PROPERTY GRAPH g3 DROP VERTEX TABLES (t2) CASCADE;
NOTICE: drop cascades to edge e1 of property graph g3
+ERROR: unsupported object class: 8318
ALTER PROPERTY GRAPH g3 DROP EDGE TABLES (e2);
+ERROR: unsupported object class: 8318
CREATE PROPERTY GRAPH g4
VERTEX TABLES (
t1 KEY (a) NO PROPERTIES,
... |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/create_property_graph.out /home/postgres/postgres/build/testr...
--- /home/postgres/postgres/src/test/regress/expected/create_property_graph.out 2026-03-19 20:53:12.941931707 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/create_property_graph.out 2026-03-19 20...
@@ -57,13 +57,16 @@
ALTER PROPERTY GRAPH g3 ALTER VERTEX TABLE t3 DROP LABEL t3l3x; -- error
ERROR: property graph "g3" element "t3" has no label "t3l3x"
ALTER PROPERTY GRAPH g3 ALTER VERTEX TABLE t3 DROP LABEL t3l3;
+ERROR: unsupported object class: 8318
ALTER PROPERTY GRAPH g3 DROP VERTEX TABLES (t2); -- fail
ERROR: cannot drop vertex t2 of property graph g3 because other objects depend on it
DETAIL: edge e1 of property graph g3 depends on vertex t2 of property graph g3
HINT: Use DROP ... CASCADE to drop the dependent objects too.
ALTER PROPERTY GRAPH g3 DROP VERTEX TABLES (t2) CASCADE;
NOTICE: drop cascades to edge e1 of property graph g3
+ERROR: unsupported object class: 8318
ALTER PROPERTY GRAPH g3 DROP EDGE TABLES (e2);
+ERROR: unsupported object class: 8318
CREATE PROPERTY GRAPH g4
VERTEX TABLES (
t1 KEY (a) NO PROPERTIES,
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/create_property_graph.out /home/postgres/postgres/build/testr...
--- /home/postgres/postgres/src/test/regress/expected/create_property_graph.out 2026-03-19 20:53:12.941931707 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/create_property_graph.out 2026-03-19 ...
@@ -57,13 +57,16 @@
ALTER PROPERTY GRAPH g3 ALTER VERTEX TABLE t3 DROP LABEL t3l3x; -- error
ERROR: property graph "g3" element "t3" has no label "t3l3x"
ALTER PROPERTY GRAPH g3 ALTER VERTEX TABLE t3 DROP LABEL t3l3;
+ERROR: unsupported object class: 8318
ALTER PROPERTY GRAPH g3 DROP VERTEX TABLES (t2); -- fail
ERROR: cannot drop vertex t2 of property graph g3 because other objects depend on it
DETAIL: edge e1 of property graph g3 depends on vertex t2 of property graph g3
HINT: Use DROP ... CASCADE to drop the dependent objects too.
ALTER PROPERTY GRAPH g3 DROP VERTEX TABLES (t2) CASCADE;
NOTICE: drop cascades to edge e1 of property graph g3
+ERROR: unsupported object class: 8318
ALTER PROPERTY GRAPH g3 DROP EDGE TABLES (e2);
+ERROR: unsupported object class: 8318
CREATE PROPERTY GRAPH g4
VERTEX TABLES (
t1 KEY (a) NO PROPERTIES,
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/create_property_graph.out /home/postgres/postgres/build/testr...
--- /home/postgres/postgres/src/test/regress/expected/create_property_graph.out 2026-03-19 20:53:12.941931707 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/create_property_graph.out 2026-03-19 20:55:25.86934552...
@@ -57,13 +57,16 @@
ALTER PROPERTY GRAPH g3 ALTER VERTEX TABLE t3 DROP LABEL t3l3x; -- error
ERROR: property graph "g3" element "t3" has no label "t3l3x"
ALTER PROPERTY GRAPH g3 ALTER VERTEX TABLE t3 DROP LABEL t3l3;
+ERROR: unsupported object class: 8318
ALTER PROPERTY GRAPH g3 DROP VERTEX TABLES (t2); -- fail
ERROR: cannot drop vertex t2 of property graph g3 because other objects depend on it
DETAIL: edge e1 of property graph g3 depends on vertex t2 of property graph g3
HINT: Use DROP ... CASCADE to drop the dependent objects too.
ALTER PROPERTY GRAPH g3 DROP VERTEX TABLES (t2) CASCADE;
NOTICE: drop cascades to edge e1 of property graph g3
+ERROR: unsupported object class: 8318
ALTER PROPERTY GRAPH g3 DROP EDGE TABLES (e2);
+ERROR: unsupported object class: 8318
CREATE PROPERTY GRAPH g4
VERTEX TABLES (
t1 KEY (a) NO PROPERTIES,
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/create_property_graph.out /home/postgres/postgres/build/testr...
--- /home/postgres/postgres/src/test/regress/expected/create_property_graph.out 2026-03-19 20:53:12.941931707 +0000
+++ /home/postgres/postgres/build/testrun/test_plan_advice/001_replan_regress/data/results/create_property_graph.out 202...
@@ -57,13 +57,16 @@
ALTER PROPERTY GRAPH g3 ALTER VERTEX TABLE t3 DROP LABEL t3l3x; -- error
ERROR: property graph "g3" element "t3" has no label "t3l3x"
ALTER PROPERTY GRAPH g3 ALTER VERTEX TABLE t3 DROP LABEL t3l3;
+ERROR: unsupported object class: 8318
ALTER PROPERTY GRAPH g3 DROP VERTEX TABLES (t2); -- fail
ERROR: cannot drop vertex t2 of property graph g3 because other objects depend on it
DETAIL: edge e1 of property graph g3 depends on vertex t2 of property graph g3
HINT: Use DROP ... CASCADE to drop the dependent objects too.
ALTER PROPERTY GRAPH g3 DROP VERTEX TABLES (t2) CASCADE;
NOTICE: drop cascades to edge e1 of property graph g3
+ERROR: unsupported object class: 8318
ALTER PROPERTY GRAPH g3 DROP EDGE TABLES (e2);
+ERROR: unsupported object class: 8318
CREATE PROPERTY GRAPH g4
VERTEX TABLES (
t1 KEY (a) NO PROPERTIES,
... |
|
Linux - Debian Trixie - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/create_property_graph.out /tmp/cirrus-ci-build/src/bin/pg_upgrad...
--- /tmp/cirrus-ci-build/src/test/regress/expected/create_property_graph.out 2026-03-19 20:52:46.363806939 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/create_property_graph.out 2026-03-19 21:00:38.551435663 +0...
@@ -57,13 +57,16 @@
ALTER PROPERTY GRAPH g3 ALTER VERTEX TABLE t3 DROP LABEL t3l3x; -- error
ERROR: property graph "g3" element "t3" has no label "t3l3x"
ALTER PROPERTY GRAPH g3 ALTER VERTEX TABLE t3 DROP LABEL t3l3;
+ERROR: unsupported object class: 8318
ALTER PROPERTY GRAPH g3 DROP VERTEX TABLES (t2); -- fail
ERROR: cannot drop vertex t2 of property graph g3 because other objects depend on it
DETAIL: edge e1 of property graph g3 depends on vertex t2 of property graph g3
HINT: Use DROP ... CASCADE to drop the dependent objects too.
ALTER PROPERTY GRAPH g3 DROP VERTEX TABLES (t2) CASCADE;
NOTICE: drop cascades to edge e1 of property graph g3
+ERROR: unsupported object class: 8318
ALTER PROPERTY GRAPH g3 DROP EDGE TABLES (e2);
+ERROR: unsupported object class: 8318
CREATE PROPERTY GRAPH g4
VERTEX TABLES (
t1 KEY (a) NO PROPERTIES,
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/create_property_graph.out /tmp/cirrus-ci-build/src/test/modules/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/create_property_graph.out 2026-03-19 20:52:46.363806939 +0000
+++ /tmp/cirrus-ci-build/src/test/modules/test_plan_advice/tmp_check/results/create_property_graph.out 2026-03-19 21:00:...
@@ -57,13 +57,16 @@
ALTER PROPERTY GRAPH g3 ALTER VERTEX TABLE t3 DROP LABEL t3l3x; -- error
ERROR: property graph "g3" element "t3" has no label "t3l3x"
ALTER PROPERTY GRAPH g3 ALTER VERTEX TABLE t3 DROP LABEL t3l3;
+ERROR: unsupported object class: 8318
ALTER PROPERTY GRAPH g3 DROP VERTEX TABLES (t2); -- fail
ERROR: cannot drop vertex t2 of property graph g3 because other objects depend on it
DETAIL: edge e1 of property graph g3 depends on vertex t2 of property graph g3
HINT: Use DROP ... CASCADE to drop the dependent objects too.
ALTER PROPERTY GRAPH g3 DROP VERTEX TABLES (t2) CASCADE;
NOTICE: drop cascades to edge e1 of property graph g3
+ERROR: unsupported object class: 8318
ALTER PROPERTY GRAPH g3 DROP EDGE TABLES (e2);
+ERROR: unsupported object class: 8318
CREATE PROPERTY GRAPH g4
VERTEX TABLES (
t1 KEY (a) NO PROPERTIES,
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/create_property_graph.out /tmp/cirrus-ci-build/src/test/recovery...
--- /tmp/cirrus-ci-build/src/test/regress/expected/create_property_graph.out 2026-03-19 20:52:46.363806939 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/create_property_graph.out 2026-03-19 21:02:08.184013380 +00...
@@ -57,13 +57,16 @@
ALTER PROPERTY GRAPH g3 ALTER VERTEX TABLE t3 DROP LABEL t3l3x; -- error
ERROR: property graph "g3" element "t3" has no label "t3l3x"
ALTER PROPERTY GRAPH g3 ALTER VERTEX TABLE t3 DROP LABEL t3l3;
+ERROR: unsupported object class: 8318
ALTER PROPERTY GRAPH g3 DROP VERTEX TABLES (t2); -- fail
ERROR: cannot drop vertex t2 of property graph g3 because other objects depend on it
DETAIL: edge e1 of property graph g3 depends on vertex t2 of property graph g3
HINT: Use DROP ... CASCADE to drop the dependent objects too.
ALTER PROPERTY GRAPH g3 DROP VERTEX TABLES (t2) CASCADE;
NOTICE: drop cascades to edge e1 of property graph g3
+ERROR: unsupported object class: 8318
ALTER PROPERTY GRAPH g3 DROP EDGE TABLES (e2);
+ERROR: unsupported object class: 8318
CREATE PROPERTY GRAPH g4
VERTEX TABLES (
t1 KEY (a) NO PROPERTIES,
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/create_property_graph.out /tmp/cirrus-ci-build/src/test/regress/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/create_property_graph.out 2026-03-19 20:52:46.363806939 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/create_property_graph.out 2026-03-19 20:57:35.414619239 +0000
@@ -57,13 +57,16 @@
ALTER PROPERTY GRAPH g3 ALTER VERTEX TABLE t3 DROP LABEL t3l3x; -- error
ERROR: property graph "g3" element "t3" has no label "t3l3x"
ALTER PROPERTY GRAPH g3 ALTER VERTEX TABLE t3 DROP LABEL t3l3;
+ERROR: unsupported object class: 8318
ALTER PROPERTY GRAPH g3 DROP VERTEX TABLES (t2); -- fail
ERROR: cannot drop vertex t2 of property graph g3 because other objects depend on it
DETAIL: edge e1 of property graph g3 depends on vertex t2 of property graph g3
HINT: Use DROP ... CASCADE to drop the dependent objects too.
ALTER PROPERTY GRAPH g3 DROP VERTEX TABLES (t2) CASCADE;
NOTICE: drop cascades to edge e1 of property graph g3
+ERROR: unsupported object class: 8318
ALTER PROPERTY GRAPH g3 DROP EDGE TABLES (e2);
+ERROR: unsupported object class: 8318
CREATE PROPERTY GRAPH g4
VERTEX TABLES (
t1 KEY (a) NO PROPERTIES,
... |
|
OpenBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/create_property_graph.out /home/postgres/postgres/build/testr...
--- /home/postgres/postgres/src/test/regress/expected/create_property_graph.out Thu Mar 19 20:55:38 2026
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/create_property_graph.out Thu Mar 19 20...
@@ -57,13 +57,16 @@
ALTER PROPERTY GRAPH g3 ALTER VERTEX TABLE t3 DROP LABEL t3l3x; -- error
ERROR: property graph "g3" element "t3" has no label "t3l3x"
ALTER PROPERTY GRAPH g3 ALTER VERTEX TABLE t3 DROP LABEL t3l3;
+ERROR: unsupported object class: 8318
ALTER PROPERTY GRAPH g3 DROP VERTEX TABLES (t2); -- fail
ERROR: cannot drop vertex t2 of property graph g3 because other objects depend on it
DETAIL: edge e1 of property graph g3 depends on vertex t2 of property graph g3
HINT: Use DROP ... CASCADE to drop the dependent objects too.
ALTER PROPERTY GRAPH g3 DROP VERTEX TABLES (t2) CASCADE;
NOTICE: drop cascades to edge e1 of property graph g3
+ERROR: unsupported object class: 8318
ALTER PROPERTY GRAPH g3 DROP EDGE TABLES (e2);
+ERROR: unsupported object class: 8318
CREATE PROPERTY GRAPH g4
VERTEX TABLES (
t1 KEY (a) NO PROPERTIES,
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/create_property_graph.out /home/postgres/postgres/build/testr...
--- /home/postgres/postgres/src/test/regress/expected/create_property_graph.out Thu Mar 19 20:55:38 2026
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/create_property_graph.out Thu Mar 19 ...
@@ -57,13 +57,16 @@
ALTER PROPERTY GRAPH g3 ALTER VERTEX TABLE t3 DROP LABEL t3l3x; -- error
ERROR: property graph "g3" element "t3" has no label "t3l3x"
ALTER PROPERTY GRAPH g3 ALTER VERTEX TABLE t3 DROP LABEL t3l3;
+ERROR: unsupported object class: 8318
ALTER PROPERTY GRAPH g3 DROP VERTEX TABLES (t2); -- fail
ERROR: cannot drop vertex t2 of property graph g3 because other objects depend on it
DETAIL: edge e1 of property graph g3 depends on vertex t2 of property graph g3
HINT: Use DROP ... CASCADE to drop the dependent objects too.
ALTER PROPERTY GRAPH g3 DROP VERTEX TABLES (t2) CASCADE;
NOTICE: drop cascades to edge e1 of property graph g3
+ERROR: unsupported object class: 8318
ALTER PROPERTY GRAPH g3 DROP EDGE TABLES (e2);
+ERROR: unsupported object class: 8318
CREATE PROPERTY GRAPH g4
VERTEX TABLES (
t1 KEY (a) NO PROPERTIES,
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/create_property_graph.out /home/postgres/postgres/build/testr...
--- /home/postgres/postgres/src/test/regress/expected/create_property_graph.out Thu Mar 19 20:55:38 2026
+++ /home/postgres/postgres/build/testrun/regress/regress/results/create_property_graph.out Thu Mar 19 20:58:28 2026
@@ -57,13 +57,16 @@
ALTER PROPERTY GRAPH g3 ALTER VERTEX TABLE t3 DROP LABEL t3l3x; -- error
ERROR: property graph "g3" element "t3" has no label "t3l3x"
ALTER PROPERTY GRAPH g3 ALTER VERTEX TABLE t3 DROP LABEL t3l3;
+ERROR: unsupported object class: 8318
ALTER PROPERTY GRAPH g3 DROP VERTEX TABLES (t2); -- fail
ERROR: cannot drop vertex t2 of property graph g3 because other objects depend on it
DETAIL: edge e1 of property graph g3 depends on vertex t2 of property graph g3
HINT: Use DROP ... CASCADE to drop the dependent objects too.
ALTER PROPERTY GRAPH g3 DROP VERTEX TABLES (t2) CASCADE;
NOTICE: drop cascades to edge e1 of property graph g3
+ERROR: unsupported object class: 8318
ALTER PROPERTY GRAPH g3 DROP EDGE TABLES (e2);
+ERROR: unsupported object class: 8318
CREATE PROPERTY GRAPH g4
VERTEX TABLES (
t1 KEY (a) NO PROPERTIES,
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/create_property_graph.out /home/postgres/postgres/build/testr...
--- /home/postgres/postgres/src/test/regress/expected/create_property_graph.out Thu Mar 19 20:55:38 2026
+++ /home/postgres/postgres/build/testrun/test_plan_advice/001_replan_regress/data/results/create_property_graph.out Thu...
@@ -57,13 +57,16 @@
ALTER PROPERTY GRAPH g3 ALTER VERTEX TABLE t3 DROP LABEL t3l3x; -- error
ERROR: property graph "g3" element "t3" has no label "t3l3x"
ALTER PROPERTY GRAPH g3 ALTER VERTEX TABLE t3 DROP LABEL t3l3;
+ERROR: unsupported object class: 8318
ALTER PROPERTY GRAPH g3 DROP VERTEX TABLES (t2); -- fail
ERROR: cannot drop vertex t2 of property graph g3 because other objects depend on it
DETAIL: edge e1 of property graph g3 depends on vertex t2 of property graph g3
HINT: Use DROP ... CASCADE to drop the dependent objects too.
ALTER PROPERTY GRAPH g3 DROP VERTEX TABLES (t2) CASCADE;
NOTICE: drop cascades to edge e1 of property graph g3
+ERROR: unsupported object class: 8318
ALTER PROPERTY GRAPH g3 DROP EDGE TABLES (e2);
+ERROR: unsupported object class: 8318
CREATE PROPERTY GRAPH g4
VERTEX TABLES (
t1 KEY (a) NO PROPERTIES,
... |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/create_property_graph.out /tmp/cirrus-ci-build/build/testrun/pg_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/create_property_graph.out 2026-03-19 20:53:39.964875000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/create_property_graph.out 2026-03-19 20:55...
@@ -57,13 +57,16 @@
ALTER PROPERTY GRAPH g3 ALTER VERTEX TABLE t3 DROP LABEL t3l3x; -- error
ERROR: property graph "g3" element "t3" has no label "t3l3x"
ALTER PROPERTY GRAPH g3 ALTER VERTEX TABLE t3 DROP LABEL t3l3;
+ERROR: unsupported object class: 8318
ALTER PROPERTY GRAPH g3 DROP VERTEX TABLES (t2); -- fail
ERROR: cannot drop vertex t2 of property graph g3 because other objects depend on it
DETAIL: edge e1 of property graph g3 depends on vertex t2 of property graph g3
HINT: Use DROP ... CASCADE to drop the dependent objects too.
ALTER PROPERTY GRAPH g3 DROP VERTEX TABLES (t2) CASCADE;
NOTICE: drop cascades to edge e1 of property graph g3
+ERROR: unsupported object class: 8318
ALTER PROPERTY GRAPH g3 DROP EDGE TABLES (e2);
+ERROR: unsupported object class: 8318
CREATE PROPERTY GRAPH g4
VERTEX TABLES (
t1 KEY (a) NO PROPERTIES,
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/create_property_graph.out /tmp/cirrus-ci-build/build/testrun/rec...
--- /tmp/cirrus-ci-build/src/test/regress/expected/create_property_graph.out 2026-03-19 20:53:39.964875000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/create_property_graph.out 2026-03-19 20:...
@@ -57,13 +57,16 @@
ALTER PROPERTY GRAPH g3 ALTER VERTEX TABLE t3 DROP LABEL t3l3x; -- error
ERROR: property graph "g3" element "t3" has no label "t3l3x"
ALTER PROPERTY GRAPH g3 ALTER VERTEX TABLE t3 DROP LABEL t3l3;
+ERROR: unsupported object class: 8318
ALTER PROPERTY GRAPH g3 DROP VERTEX TABLES (t2); -- fail
ERROR: cannot drop vertex t2 of property graph g3 because other objects depend on it
DETAIL: edge e1 of property graph g3 depends on vertex t2 of property graph g3
HINT: Use DROP ... CASCADE to drop the dependent objects too.
ALTER PROPERTY GRAPH g3 DROP VERTEX TABLES (t2) CASCADE;
NOTICE: drop cascades to edge e1 of property graph g3
+ERROR: unsupported object class: 8318
ALTER PROPERTY GRAPH g3 DROP EDGE TABLES (e2);
+ERROR: unsupported object class: 8318
CREATE PROPERTY GRAPH g4
VERTEX TABLES (
t1 KEY (a) NO PROPERTIES,
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/create_property_graph.out /tmp/cirrus-ci-build/build/testrun/reg...
--- /tmp/cirrus-ci-build/src/test/regress/expected/create_property_graph.out 2026-03-19 20:53:39.964875000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/create_property_graph.out 2026-03-19 20:55:55.684412000 +...
@@ -57,13 +57,16 @@
ALTER PROPERTY GRAPH g3 ALTER VERTEX TABLE t3 DROP LABEL t3l3x; -- error
ERROR: property graph "g3" element "t3" has no label "t3l3x"
ALTER PROPERTY GRAPH g3 ALTER VERTEX TABLE t3 DROP LABEL t3l3;
+ERROR: unsupported object class: 8318
ALTER PROPERTY GRAPH g3 DROP VERTEX TABLES (t2); -- fail
ERROR: cannot drop vertex t2 of property graph g3 because other objects depend on it
DETAIL: edge e1 of property graph g3 depends on vertex t2 of property graph g3
HINT: Use DROP ... CASCADE to drop the dependent objects too.
ALTER PROPERTY GRAPH g3 DROP VERTEX TABLES (t2) CASCADE;
NOTICE: drop cascades to edge e1 of property graph g3
+ERROR: unsupported object class: 8318
ALTER PROPERTY GRAPH g3 DROP EDGE TABLES (e2);
+ERROR: unsupported object class: 8318
CREATE PROPERTY GRAPH g4
VERTEX TABLES (
t1 KEY (a) NO PROPERTIES,
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/create_property_graph.out /tmp/cirrus-ci-build/build/testrun/tes...
--- /tmp/cirrus-ci-build/src/test/regress/expected/create_property_graph.out 2026-03-19 20:53:39.964875000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/create_property_graph.out 2026-0...
@@ -57,13 +57,16 @@
ALTER PROPERTY GRAPH g3 ALTER VERTEX TABLE t3 DROP LABEL t3l3x; -- error
ERROR: property graph "g3" element "t3" has no label "t3l3x"
ALTER PROPERTY GRAPH g3 ALTER VERTEX TABLE t3 DROP LABEL t3l3;
+ERROR: unsupported object class: 8318
ALTER PROPERTY GRAPH g3 DROP VERTEX TABLES (t2); -- fail
ERROR: cannot drop vertex t2 of property graph g3 because other objects depend on it
DETAIL: edge e1 of property graph g3 depends on vertex t2 of property graph g3
HINT: Use DROP ... CASCADE to drop the dependent objects too.
ALTER PROPERTY GRAPH g3 DROP VERTEX TABLES (t2) CASCADE;
NOTICE: drop cascades to edge e1 of property graph g3
+ERROR: unsupported object class: 8318
ALTER PROPERTY GRAPH g3 DROP EDGE TABLES (e2);
+ERROR: unsupported object class: 8318
CREATE PROPERTY GRAPH g4
VERTEX TABLES (
t1 KEY (a) NO PROPERTIES,
... |
| 58/6029 |
NOT NULL NOT ENFORCED |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/constraints.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/00...
--- /tmp/cirrus-ci-build/src/test/regress/expected/constraints.out 2026-03-19 10:19:44.405358000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/constraints.out 2026-03-19 10:21:35.080036...
@@ -1127,8 +1127,10 @@
INSERT INTO ne_nn_tbl VALUES (NULL); -- ok
ALTER TABLE ne_nn_tbl ALTER CONSTRAINT nn ENFORCED; -- error
ERROR: cannot alter enforceability of constraint "nn" of relation "ne_nn_tbl"
+HINT: Only foreign key and check constraints can change enforceability.
ALTER TABLE ne_nn_tbl ALTER CONSTRAINT nn NOT ENFORCED; -- error
ERROR: cannot alter enforceability of constraint "nn" of relation "ne_nn_tbl"
+HINT: Only foreign key and check constraints can change enforceability.
ALTER TABLE ne_nn_tbl VALIDATE CONSTRAINT nn; -- error
ERROR: cannot validate NOT ENFORCED constraint
ALTER TABLE ne_nn_tbl ADD CONSTRAINT nn_enforced1 NOT NULL x NOT ENFORCED; -- error |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/constraints.out /tmp/cirrus-ci-build/build/testrun/recovery/027_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/constraints.out 2026-03-19 10:19:44.405358000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/constraints.out 2026-03-19 10:22:42.7746...
@@ -1127,8 +1127,10 @@
INSERT INTO ne_nn_tbl VALUES (NULL); -- ok
ALTER TABLE ne_nn_tbl ALTER CONSTRAINT nn ENFORCED; -- error
ERROR: cannot alter enforceability of constraint "nn" of relation "ne_nn_tbl"
+HINT: Only foreign key and check constraints can change enforceability.
ALTER TABLE ne_nn_tbl ALTER CONSTRAINT nn NOT ENFORCED; -- error
ERROR: cannot alter enforceability of constraint "nn" of relation "ne_nn_tbl"
+HINT: Only foreign key and check constraints can change enforceability.
ALTER TABLE ne_nn_tbl VALIDATE CONSTRAINT nn; -- error
ERROR: cannot validate NOT ENFORCED constraint
ALTER TABLE ne_nn_tbl ADD CONSTRAINT nn_enforced1 NOT NULL x NOT ENFORCED; -- error |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/constraints.out /tmp/cirrus-ci-build/build/testrun/regress/regre...
--- /tmp/cirrus-ci-build/src/test/regress/expected/constraints.out 2026-03-19 10:19:44.405358000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/constraints.out 2026-03-19 10:21:32.429394000 +0000
@@ -1127,8 +1127,10 @@
INSERT INTO ne_nn_tbl VALUES (NULL); -- ok
ALTER TABLE ne_nn_tbl ALTER CONSTRAINT nn ENFORCED; -- error
ERROR: cannot alter enforceability of constraint "nn" of relation "ne_nn_tbl"
+HINT: Only foreign key and check constraints can change enforceability.
ALTER TABLE ne_nn_tbl ALTER CONSTRAINT nn NOT ENFORCED; -- error
ERROR: cannot alter enforceability of constraint "nn" of relation "ne_nn_tbl"
+HINT: Only foreign key and check constraints can change enforceability.
ALTER TABLE ne_nn_tbl VALIDATE CONSTRAINT nn; -- error
ERROR: cannot validate NOT ENFORCED constraint
ALTER TABLE ne_nn_tbl ADD CONSTRAINT nn_enforced1 NOT NULL x NOT ENFORCED; -- error |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/constraints.out /tmp/cirrus-ci-build/build/testrun/test_plan_adv...
--- /tmp/cirrus-ci-build/src/test/regress/expected/constraints.out 2026-03-19 10:19:44.405358000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/constraints.out 2026-03-19 10:27...
@@ -1127,8 +1127,10 @@
INSERT INTO ne_nn_tbl VALUES (NULL); -- ok
ALTER TABLE ne_nn_tbl ALTER CONSTRAINT nn ENFORCED; -- error
ERROR: cannot alter enforceability of constraint "nn" of relation "ne_nn_tbl"
+HINT: Only foreign key and check constraints can change enforceability.
ALTER TABLE ne_nn_tbl ALTER CONSTRAINT nn NOT ENFORCED; -- error
ERROR: cannot alter enforceability of constraint "nn" of relation "ne_nn_tbl"
+HINT: Only foreign key and check constraints can change enforceability.
ALTER TABLE ne_nn_tbl VALIDATE CONSTRAINT nn; -- error
ERROR: cannot validate NOT ENFORCED constraint
ALTER TABLE ne_nn_tbl ADD CONSTRAINT nn_enforced1 NOT NULL x NOT ENFORCED; -- error |
|
Linux - Debian Trixie - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/constraints.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_chec...
--- /tmp/cirrus-ci-build/src/test/regress/expected/constraints.out 2026-03-19 10:19:49.812063463 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/constraints.out 2026-03-19 10:25:05.450308790 +0000
@@ -1127,8 +1127,10 @@
INSERT INTO ne_nn_tbl VALUES (NULL); -- ok
ALTER TABLE ne_nn_tbl ALTER CONSTRAINT nn ENFORCED; -- error
ERROR: cannot alter enforceability of constraint "nn" of relation "ne_nn_tbl"
+HINT: Only foreign key and check constraints can change enforceability.
ALTER TABLE ne_nn_tbl ALTER CONSTRAINT nn NOT ENFORCED; -- error
ERROR: cannot alter enforceability of constraint "nn" of relation "ne_nn_tbl"
+HINT: Only foreign key and check constraints can change enforceability.
ALTER TABLE ne_nn_tbl VALIDATE CONSTRAINT nn; -- error
ERROR: cannot validate NOT ENFORCED constraint
ALTER TABLE ne_nn_tbl ADD CONSTRAINT nn_enforced1 NOT NULL x NOT ENFORCED; -- error |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/constraints.out /tmp/cirrus-ci-build/src/test/modules/test_plan_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/constraints.out 2026-03-19 10:19:49.812063463 +0000
+++ /tmp/cirrus-ci-build/src/test/modules/test_plan_advice/tmp_check/results/constraints.out 2026-03-19 10:26:48.4472965...
@@ -1127,8 +1127,10 @@
INSERT INTO ne_nn_tbl VALUES (NULL); -- ok
ALTER TABLE ne_nn_tbl ALTER CONSTRAINT nn ENFORCED; -- error
ERROR: cannot alter enforceability of constraint "nn" of relation "ne_nn_tbl"
+HINT: Only foreign key and check constraints can change enforceability.
ALTER TABLE ne_nn_tbl ALTER CONSTRAINT nn NOT ENFORCED; -- error
ERROR: cannot alter enforceability of constraint "nn" of relation "ne_nn_tbl"
+HINT: Only foreign key and check constraints can change enforceability.
ALTER TABLE ne_nn_tbl VALIDATE CONSTRAINT nn; -- error
ERROR: cannot validate NOT ENFORCED constraint
ALTER TABLE ne_nn_tbl ADD CONSTRAINT nn_enforced1 NOT NULL x NOT ENFORCED; -- error |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/constraints.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check...
--- /tmp/cirrus-ci-build/src/test/regress/expected/constraints.out 2026-03-19 10:19:49.812063463 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/constraints.out 2026-03-19 10:28:17.187806819 +0000
@@ -1127,8 +1127,10 @@
INSERT INTO ne_nn_tbl VALUES (NULL); -- ok
ALTER TABLE ne_nn_tbl ALTER CONSTRAINT nn ENFORCED; -- error
ERROR: cannot alter enforceability of constraint "nn" of relation "ne_nn_tbl"
+HINT: Only foreign key and check constraints can change enforceability.
ALTER TABLE ne_nn_tbl ALTER CONSTRAINT nn NOT ENFORCED; -- error
ERROR: cannot alter enforceability of constraint "nn" of relation "ne_nn_tbl"
+HINT: Only foreign key and check constraints can change enforceability.
ALTER TABLE ne_nn_tbl VALIDATE CONSTRAINT nn; -- error
ERROR: cannot validate NOT ENFORCED constraint
ALTER TABLE ne_nn_tbl ADD CONSTRAINT nn_enforced1 NOT NULL x NOT ENFORCED; -- error |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/constraints.out /tmp/cirrus-ci-build/src/test/regress/results/co...
--- /tmp/cirrus-ci-build/src/test/regress/expected/constraints.out 2026-03-19 10:19:49.812063463 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/constraints.out 2026-03-19 10:23:43.068790242 +0000
@@ -1127,8 +1127,10 @@
INSERT INTO ne_nn_tbl VALUES (NULL); -- ok
ALTER TABLE ne_nn_tbl ALTER CONSTRAINT nn ENFORCED; -- error
ERROR: cannot alter enforceability of constraint "nn" of relation "ne_nn_tbl"
+HINT: Only foreign key and check constraints can change enforceability.
ALTER TABLE ne_nn_tbl ALTER CONSTRAINT nn NOT ENFORCED; -- error
ERROR: cannot alter enforceability of constraint "nn" of relation "ne_nn_tbl"
+HINT: Only foreign key and check constraints can change enforceability.
ALTER TABLE ne_nn_tbl VALIDATE CONSTRAINT nn; -- error
ERROR: cannot validate NOT ENFORCED constraint
ALTER TABLE ne_nn_tbl ADD CONSTRAINT nn_enforced1 NOT NULL x NOT ENFORCED; -- error |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/constraints.out /home/postgres/postgres/build/testrun/pg_upgr...
--- /home/postgres/postgres/src/test/regress/expected/constraints.out 2026-03-19 10:20:09.440231702 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/constraints.out 2026-03-19 10:21:55.148...
@@ -1127,8 +1127,10 @@
INSERT INTO ne_nn_tbl VALUES (NULL); -- ok
ALTER TABLE ne_nn_tbl ALTER CONSTRAINT nn ENFORCED; -- error
ERROR: cannot alter enforceability of constraint "nn" of relation "ne_nn_tbl"
+HINT: Only foreign key and check constraints can change enforceability.
ALTER TABLE ne_nn_tbl ALTER CONSTRAINT nn NOT ENFORCED; -- error
ERROR: cannot alter enforceability of constraint "nn" of relation "ne_nn_tbl"
+HINT: Only foreign key and check constraints can change enforceability.
ALTER TABLE ne_nn_tbl VALIDATE CONSTRAINT nn; -- error
ERROR: cannot validate NOT ENFORCED constraint
ALTER TABLE ne_nn_tbl ADD CONSTRAINT nn_enforced1 NOT NULL x NOT ENFORCED; -- error |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/constraints.out /home/postgres/postgres/build/testrun/recover...
--- /home/postgres/postgres/src/test/regress/expected/constraints.out 2026-03-19 10:20:09.440231702 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/constraints.out 2026-03-19 10:22:29.6...
@@ -1127,8 +1127,10 @@
INSERT INTO ne_nn_tbl VALUES (NULL); -- ok
ALTER TABLE ne_nn_tbl ALTER CONSTRAINT nn ENFORCED; -- error
ERROR: cannot alter enforceability of constraint "nn" of relation "ne_nn_tbl"
+HINT: Only foreign key and check constraints can change enforceability.
ALTER TABLE ne_nn_tbl ALTER CONSTRAINT nn NOT ENFORCED; -- error
ERROR: cannot alter enforceability of constraint "nn" of relation "ne_nn_tbl"
+HINT: Only foreign key and check constraints can change enforceability.
ALTER TABLE ne_nn_tbl VALIDATE CONSTRAINT nn; -- error
ERROR: cannot validate NOT ENFORCED constraint
ALTER TABLE ne_nn_tbl ADD CONSTRAINT nn_enforced1 NOT NULL x NOT ENFORCED; -- error |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/constraints.out /home/postgres/postgres/build/testrun/regress...
--- /home/postgres/postgres/src/test/regress/expected/constraints.out 2026-03-19 10:20:09.440231702 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/constraints.out 2026-03-19 10:21:53.272940610 +0000
@@ -1127,8 +1127,10 @@
INSERT INTO ne_nn_tbl VALUES (NULL); -- ok
ALTER TABLE ne_nn_tbl ALTER CONSTRAINT nn ENFORCED; -- error
ERROR: cannot alter enforceability of constraint "nn" of relation "ne_nn_tbl"
+HINT: Only foreign key and check constraints can change enforceability.
ALTER TABLE ne_nn_tbl ALTER CONSTRAINT nn NOT ENFORCED; -- error
ERROR: cannot alter enforceability of constraint "nn" of relation "ne_nn_tbl"
+HINT: Only foreign key and check constraints can change enforceability.
ALTER TABLE ne_nn_tbl VALIDATE CONSTRAINT nn; -- error
ERROR: cannot validate NOT ENFORCED constraint
ALTER TABLE ne_nn_tbl ADD CONSTRAINT nn_enforced1 NOT NULL x NOT ENFORCED; -- error |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/constraints.out /home/postgres/postgres/build/testrun/test_pl...
--- /home/postgres/postgres/src/test/regress/expected/constraints.out 2026-03-19 10:20:09.440231702 +0000
+++ /home/postgres/postgres/build/testrun/test_plan_advice/001_replan_regress/data/results/constraints.out 2026-03-19 10...
@@ -1127,8 +1127,10 @@
INSERT INTO ne_nn_tbl VALUES (NULL); -- ok
ALTER TABLE ne_nn_tbl ALTER CONSTRAINT nn ENFORCED; -- error
ERROR: cannot alter enforceability of constraint "nn" of relation "ne_nn_tbl"
+HINT: Only foreign key and check constraints can change enforceability.
ALTER TABLE ne_nn_tbl ALTER CONSTRAINT nn NOT ENFORCED; -- error
ERROR: cannot alter enforceability of constraint "nn" of relation "ne_nn_tbl"
+HINT: Only foreign key and check constraints can change enforceability.
ALTER TABLE ne_nn_tbl VALIDATE CONSTRAINT nn; -- error
ERROR: cannot validate NOT ENFORCED constraint
ALTER TABLE ne_nn_tbl ADD CONSTRAINT nn_enforced1 NOT NULL x NOT ENFORCED; -- error |
|
OpenBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/constraints.out /home/postgres/postgres/build/testrun/pg_upgr...
--- /home/postgres/postgres/src/test/regress/expected/constraints.out Thu Mar 19 10:20:13 2026
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/constraints.out Thu Mar 19 10:22:39 202...
@@ -1127,8 +1127,10 @@
INSERT INTO ne_nn_tbl VALUES (NULL); -- ok
ALTER TABLE ne_nn_tbl ALTER CONSTRAINT nn ENFORCED; -- error
ERROR: cannot alter enforceability of constraint "nn" of relation "ne_nn_tbl"
+HINT: Only foreign key and check constraints can change enforceability.
ALTER TABLE ne_nn_tbl ALTER CONSTRAINT nn NOT ENFORCED; -- error
ERROR: cannot alter enforceability of constraint "nn" of relation "ne_nn_tbl"
+HINT: Only foreign key and check constraints can change enforceability.
ALTER TABLE ne_nn_tbl VALIDATE CONSTRAINT nn; -- error
ERROR: cannot validate NOT ENFORCED constraint
ALTER TABLE ne_nn_tbl ADD CONSTRAINT nn_enforced1 NOT NULL x NOT ENFORCED; -- error |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/constraints.out /home/postgres/postgres/build/testrun/recover...
--- /home/postgres/postgres/src/test/regress/expected/constraints.out Thu Mar 19 10:20:13 2026
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/constraints.out Thu Mar 19 10:24:22 2...
@@ -1127,8 +1127,10 @@
INSERT INTO ne_nn_tbl VALUES (NULL); -- ok
ALTER TABLE ne_nn_tbl ALTER CONSTRAINT nn ENFORCED; -- error
ERROR: cannot alter enforceability of constraint "nn" of relation "ne_nn_tbl"
+HINT: Only foreign key and check constraints can change enforceability.
ALTER TABLE ne_nn_tbl ALTER CONSTRAINT nn NOT ENFORCED; -- error
ERROR: cannot alter enforceability of constraint "nn" of relation "ne_nn_tbl"
+HINT: Only foreign key and check constraints can change enforceability.
ALTER TABLE ne_nn_tbl VALIDATE CONSTRAINT nn; -- error
ERROR: cannot validate NOT ENFORCED constraint
ALTER TABLE ne_nn_tbl ADD CONSTRAINT nn_enforced1 NOT NULL x NOT ENFORCED; -- error |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/constraints.out /home/postgres/postgres/build/testrun/regress...
--- /home/postgres/postgres/src/test/regress/expected/constraints.out Thu Mar 19 10:20:13 2026
+++ /home/postgres/postgres/build/testrun/regress/regress/results/constraints.out Thu Mar 19 10:22:30 2026
@@ -1127,8 +1127,10 @@
INSERT INTO ne_nn_tbl VALUES (NULL); -- ok
ALTER TABLE ne_nn_tbl ALTER CONSTRAINT nn ENFORCED; -- error
ERROR: cannot alter enforceability of constraint "nn" of relation "ne_nn_tbl"
+HINT: Only foreign key and check constraints can change enforceability.
ALTER TABLE ne_nn_tbl ALTER CONSTRAINT nn NOT ENFORCED; -- error
ERROR: cannot alter enforceability of constraint "nn" of relation "ne_nn_tbl"
+HINT: Only foreign key and check constraints can change enforceability.
ALTER TABLE ne_nn_tbl VALIDATE CONSTRAINT nn; -- error
ERROR: cannot validate NOT ENFORCED constraint
ALTER TABLE ne_nn_tbl ADD CONSTRAINT nn_enforced1 NOT NULL x NOT ENFORCED; -- error |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/constraints.out /home/postgres/postgres/build/testrun/test_pl...
--- /home/postgres/postgres/src/test/regress/expected/constraints.out Thu Mar 19 10:20:13 2026
+++ /home/postgres/postgres/build/testrun/test_plan_advice/001_replan_regress/data/results/constraints.out Thu Mar 19 10...
@@ -1127,8 +1127,10 @@
INSERT INTO ne_nn_tbl VALUES (NULL); -- ok
ALTER TABLE ne_nn_tbl ALTER CONSTRAINT nn ENFORCED; -- error
ERROR: cannot alter enforceability of constraint "nn" of relation "ne_nn_tbl"
+HINT: Only foreign key and check constraints can change enforceability.
ALTER TABLE ne_nn_tbl ALTER CONSTRAINT nn NOT ENFORCED; -- error
ERROR: cannot alter enforceability of constraint "nn" of relation "ne_nn_tbl"
+HINT: Only foreign key and check constraints can change enforceability.
ALTER TABLE ne_nn_tbl VALIDATE CONSTRAINT nn; -- error
ERROR: cannot validate NOT ENFORCED constraint
ALTER TABLE ne_nn_tbl ADD CONSTRAINT nn_enforced1 NOT NULL x NOT ENFORCED; -- error |
|
macOS - Sequoia - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/constraints.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg...
--- /Users/admin/pgsql/src/test/regress/expected/constraints.out 2026-03-19 10:19:38
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/constraints.out 2026-03-19 10:22:24
@@ -1127,8 +1127,10 @@
INSERT INTO ne_nn_tbl VALUES (NULL); -- ok
ALTER TABLE ne_nn_tbl ALTER CONSTRAINT nn ENFORCED; -- error
ERROR: cannot alter enforceability of constraint "nn" of relation "ne_nn_tbl"
+HINT: Only foreign key and check constraints can change enforceability.
ALTER TABLE ne_nn_tbl ALTER CONSTRAINT nn NOT ENFORCED; -- error
ERROR: cannot alter enforceability of constraint "nn" of relation "ne_nn_tbl"
+HINT: Only foreign key and check constraints can change enforceability.
ALTER TABLE ne_nn_tbl VALIDATE CONSTRAINT nn; -- error
ERROR: cannot validate NOT ENFORCED constraint
ALTER TABLE ne_nn_tbl ADD CONSTRAINT nn_enforced1 NOT NULL x NOT ENFORCED; -- error |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/constraints.out /Users/admin/pgsql/build/testrun/recovery/027_stre...
--- /Users/admin/pgsql/src/test/regress/expected/constraints.out 2026-03-19 10:19:38
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/constraints.out 2026-03-19 10:24:28
@@ -1127,8 +1127,10 @@
INSERT INTO ne_nn_tbl VALUES (NULL); -- ok
ALTER TABLE ne_nn_tbl ALTER CONSTRAINT nn ENFORCED; -- error
ERROR: cannot alter enforceability of constraint "nn" of relation "ne_nn_tbl"
+HINT: Only foreign key and check constraints can change enforceability.
ALTER TABLE ne_nn_tbl ALTER CONSTRAINT nn NOT ENFORCED; -- error
ERROR: cannot alter enforceability of constraint "nn" of relation "ne_nn_tbl"
+HINT: Only foreign key and check constraints can change enforceability.
ALTER TABLE ne_nn_tbl VALIDATE CONSTRAINT nn; -- error
ERROR: cannot validate NOT ENFORCED constraint
ALTER TABLE ne_nn_tbl ADD CONSTRAINT nn_enforced1 NOT NULL x NOT ENFORCED; -- error |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/constraints.out /Users/admin/pgsql/build/testrun/regress/regress/r...
--- /Users/admin/pgsql/src/test/regress/expected/constraints.out 2026-03-19 10:19:38
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/constraints.out 2026-03-19 10:22:20
@@ -1127,8 +1127,10 @@
INSERT INTO ne_nn_tbl VALUES (NULL); -- ok
ALTER TABLE ne_nn_tbl ALTER CONSTRAINT nn ENFORCED; -- error
ERROR: cannot alter enforceability of constraint "nn" of relation "ne_nn_tbl"
+HINT: Only foreign key and check constraints can change enforceability.
ALTER TABLE ne_nn_tbl ALTER CONSTRAINT nn NOT ENFORCED; -- error
ERROR: cannot alter enforceability of constraint "nn" of relation "ne_nn_tbl"
+HINT: Only foreign key and check constraints can change enforceability.
ALTER TABLE ne_nn_tbl VALIDATE CONSTRAINT nn; -- error
ERROR: cannot validate NOT ENFORCED constraint
ALTER TABLE ne_nn_tbl ADD CONSTRAINT nn_enforced1 NOT NULL x NOT ENFORCED; -- error |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/constraints.out /Users/admin/pgsql/build/testrun/test_plan_advice/...
--- /Users/admin/pgsql/src/test/regress/expected/constraints.out 2026-03-19 10:19:38
+++ /Users/admin/pgsql/build/testrun/test_plan_advice/001_replan_regress/data/results/constraints.out 2026-03-19 10:31:4...
@@ -1127,8 +1127,10 @@
INSERT INTO ne_nn_tbl VALUES (NULL); -- ok
ALTER TABLE ne_nn_tbl ALTER CONSTRAINT nn ENFORCED; -- error
ERROR: cannot alter enforceability of constraint "nn" of relation "ne_nn_tbl"
+HINT: Only foreign key and check constraints can change enforceability.
ALTER TABLE ne_nn_tbl ALTER CONSTRAINT nn NOT ENFORCED; -- error
ERROR: cannot alter enforceability of constraint "nn" of relation "ne_nn_tbl"
+HINT: Only foreign key and check constraints can change enforceability.
ALTER TABLE ne_nn_tbl VALIDATE CONSTRAINT nn; -- error
ERROR: cannot validate NOT ENFORCED constraint
ALTER TABLE ne_nn_tbl ADD CONSTRAINT nn_enforced1 NOT NULL x NOT ENFORCED; -- error |
|
Windows - Server 2022, MinGW64 - Meson |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/constraints.out C:/cirrus/build/testrun/pg_upgrade/002_...
--- C:/cirrus/src/test/regress/expected/constraints.out 2026-03-19 10:19:53.820746200 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/constraints.out 2026-03-19 10:25:11.168388700 +0000
@@ -1127,8 +1127,10 @@
INSERT INTO ne_nn_tbl VALUES (NULL); -- ok
ALTER TABLE ne_nn_tbl ALTER CONSTRAINT nn ENFORCED; -- error
ERROR: cannot alter enforceability of constraint "nn" of relation "ne_nn_tbl"
+HINT: Only foreign key and check constraints can change enforceability.
ALTER TABLE ne_nn_tbl ALTER CONSTRAINT nn NOT ENFORCED; -- error
ERROR: cannot alter enforceability of constraint "nn" of relation "ne_nn_tbl"
+HINT: Only foreign key and check constraints can change enforceability.
ALTER TABLE ne_nn_tbl VALIDATE CONSTRAINT nn; -- error
ERROR: cannot validate NOT ENFORCED constraint
ALTER TABLE ne_nn_tbl ADD CONSTRAINT nn_enforced1 NOT NULL x NOT ENFORCED; -- error |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/constraints.out C:/cirrus/build/testrun/recovery/027_st...
--- C:/cirrus/src/test/regress/expected/constraints.out 2026-03-19 10:19:53.820746200 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/constraints.out 2026-03-19 10:28:40.424241400 +0000
@@ -1127,8 +1127,10 @@
INSERT INTO ne_nn_tbl VALUES (NULL); -- ok
ALTER TABLE ne_nn_tbl ALTER CONSTRAINT nn ENFORCED; -- error
ERROR: cannot alter enforceability of constraint "nn" of relation "ne_nn_tbl"
+HINT: Only foreign key and check constraints can change enforceability.
ALTER TABLE ne_nn_tbl ALTER CONSTRAINT nn NOT ENFORCED; -- error
ERROR: cannot alter enforceability of constraint "nn" of relation "ne_nn_tbl"
+HINT: Only foreign key and check constraints can change enforceability.
ALTER TABLE ne_nn_tbl VALIDATE CONSTRAINT nn; -- error
ERROR: cannot validate NOT ENFORCED constraint
ALTER TABLE ne_nn_tbl ADD CONSTRAINT nn_enforced1 NOT NULL x NOT ENFORCED; -- error |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/constraints.out C:/cirrus/build/testrun/regress/regress...
--- C:/cirrus/src/test/regress/expected/constraints.out 2026-03-19 10:19:53.820746200 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/constraints.out 2026-03-19 10:25:03.217222700 +0000
@@ -1127,8 +1127,10 @@
INSERT INTO ne_nn_tbl VALUES (NULL); -- ok
ALTER TABLE ne_nn_tbl ALTER CONSTRAINT nn ENFORCED; -- error
ERROR: cannot alter enforceability of constraint "nn" of relation "ne_nn_tbl"
+HINT: Only foreign key and check constraints can change enforceability.
ALTER TABLE ne_nn_tbl ALTER CONSTRAINT nn NOT ENFORCED; -- error
ERROR: cannot alter enforceability of constraint "nn" of relation "ne_nn_tbl"
+HINT: Only foreign key and check constraints can change enforceability.
ALTER TABLE ne_nn_tbl VALIDATE CONSTRAINT nn; -- error
ERROR: cannot validate NOT ENFORCED constraint
ALTER TABLE ne_nn_tbl ADD CONSTRAINT nn_enforced1 NOT NULL x NOT ENFORCED; -- error |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/constraints.out C:/cirrus/build/testrun/test_plan_advic...
--- C:/cirrus/src/test/regress/expected/constraints.out 2026-03-19 10:19:53.820746200 +0000
+++ C:/cirrus/build/testrun/test_plan_advice/001_replan_regress/data/results/constraints.out 2026-03-19 10:40:46.0726493...
@@ -1127,8 +1127,10 @@
INSERT INTO ne_nn_tbl VALUES (NULL); -- ok
ALTER TABLE ne_nn_tbl ALTER CONSTRAINT nn ENFORCED; -- error
ERROR: cannot alter enforceability of constraint "nn" of relation "ne_nn_tbl"
+HINT: Only foreign key and check constraints can change enforceability.
ALTER TABLE ne_nn_tbl ALTER CONSTRAINT nn NOT ENFORCED; -- error
ERROR: cannot alter enforceability of constraint "nn" of relation "ne_nn_tbl"
+HINT: Only foreign key and check constraints can change enforceability.
ALTER TABLE ne_nn_tbl VALIDATE CONSTRAINT nn; -- error
ERROR: cannot validate NOT ENFORCED constraint
ALTER TABLE ne_nn_tbl ADD CONSTRAINT nn_enforced1 NOT NULL x NOT ENFORCED; -- error |
|
Linux - Debian Trixie - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/constraints.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/00...
--- /tmp/cirrus-ci-build/src/test/regress/expected/constraints.out 2026-03-19 10:20:01.503163780 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/constraints.out 2026-03-19 10:22:29.468234...
@@ -1127,8 +1127,10 @@
INSERT INTO ne_nn_tbl VALUES (NULL); -- ok
ALTER TABLE ne_nn_tbl ALTER CONSTRAINT nn ENFORCED; -- error
ERROR: cannot alter enforceability of constraint "nn" of relation "ne_nn_tbl"
+HINT: Only foreign key and check constraints can change enforceability.
ALTER TABLE ne_nn_tbl ALTER CONSTRAINT nn NOT ENFORCED; -- error
ERROR: cannot alter enforceability of constraint "nn" of relation "ne_nn_tbl"
+HINT: Only foreign key and check constraints can change enforceability.
ALTER TABLE ne_nn_tbl VALIDATE CONSTRAINT nn; -- error
ERROR: cannot validate NOT ENFORCED constraint
ALTER TABLE ne_nn_tbl ADD CONSTRAINT nn_enforced1 NOT NULL x NOT ENFORCED; -- error |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/constraints.out /tmp/cirrus-ci-build/build/testrun/recovery/027_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/constraints.out 2026-03-19 10:20:01.503163780 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/constraints.out 2026-03-19 10:23:51.6184...
@@ -1127,8 +1127,10 @@
INSERT INTO ne_nn_tbl VALUES (NULL); -- ok
ALTER TABLE ne_nn_tbl ALTER CONSTRAINT nn ENFORCED; -- error
ERROR: cannot alter enforceability of constraint "nn" of relation "ne_nn_tbl"
+HINT: Only foreign key and check constraints can change enforceability.
ALTER TABLE ne_nn_tbl ALTER CONSTRAINT nn NOT ENFORCED; -- error
ERROR: cannot alter enforceability of constraint "nn" of relation "ne_nn_tbl"
+HINT: Only foreign key and check constraints can change enforceability.
ALTER TABLE ne_nn_tbl VALIDATE CONSTRAINT nn; -- error
ERROR: cannot validate NOT ENFORCED constraint
ALTER TABLE ne_nn_tbl ADD CONSTRAINT nn_enforced1 NOT NULL x NOT ENFORCED; -- error |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/constraints.out /tmp/cirrus-ci-build/build/testrun/regress/regre...
--- /tmp/cirrus-ci-build/src/test/regress/expected/constraints.out 2026-03-19 10:20:01.503163780 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/constraints.out 2026-03-19 10:22:28.168279290 +0000
@@ -1127,8 +1127,10 @@
INSERT INTO ne_nn_tbl VALUES (NULL); -- ok
ALTER TABLE ne_nn_tbl ALTER CONSTRAINT nn ENFORCED; -- error
ERROR: cannot alter enforceability of constraint "nn" of relation "ne_nn_tbl"
+HINT: Only foreign key and check constraints can change enforceability.
ALTER TABLE ne_nn_tbl ALTER CONSTRAINT nn NOT ENFORCED; -- error
ERROR: cannot alter enforceability of constraint "nn" of relation "ne_nn_tbl"
+HINT: Only foreign key and check constraints can change enforceability.
ALTER TABLE ne_nn_tbl VALIDATE CONSTRAINT nn; -- error
ERROR: cannot validate NOT ENFORCED constraint
ALTER TABLE ne_nn_tbl ADD CONSTRAINT nn_enforced1 NOT NULL x NOT ENFORCED; -- error |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/constraints.out /tmp/cirrus-ci-build/build/testrun/test_plan_adv...
--- /tmp/cirrus-ci-build/src/test/regress/expected/constraints.out 2026-03-19 10:20:01.503163780 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/constraints.out 2026-03-19 10:28...
@@ -1127,8 +1127,10 @@
INSERT INTO ne_nn_tbl VALUES (NULL); -- ok
ALTER TABLE ne_nn_tbl ALTER CONSTRAINT nn ENFORCED; -- error
ERROR: cannot alter enforceability of constraint "nn" of relation "ne_nn_tbl"
+HINT: Only foreign key and check constraints can change enforceability.
ALTER TABLE ne_nn_tbl ALTER CONSTRAINT nn NOT ENFORCED; -- error
ERROR: cannot alter enforceability of constraint "nn" of relation "ne_nn_tbl"
+HINT: Only foreign key and check constraints can change enforceability.
ALTER TABLE ne_nn_tbl VALIDATE CONSTRAINT nn; -- error
ERROR: cannot validate NOT ENFORCED constraint
ALTER TABLE ne_nn_tbl ADD CONSTRAINT nn_enforced1 NOT NULL x NOT ENFORCED; -- error |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/constraints.out C:/cirrus/build/testrun/pg_upgrade/002_...
--- C:/cirrus/src/test/regress/expected/constraints.out 2026-03-19 10:20:04.659322000 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/constraints.out 2026-03-19 10:22:59.631204000 +0000
@@ -1127,8 +1127,10 @@
INSERT INTO ne_nn_tbl VALUES (NULL); -- ok
ALTER TABLE ne_nn_tbl ALTER CONSTRAINT nn ENFORCED; -- error
ERROR: cannot alter enforceability of constraint "nn" of relation "ne_nn_tbl"
+HINT: Only foreign key and check constraints can change enforceability.
ALTER TABLE ne_nn_tbl ALTER CONSTRAINT nn NOT ENFORCED; -- error
ERROR: cannot alter enforceability of constraint "nn" of relation "ne_nn_tbl"
+HINT: Only foreign key and check constraints can change enforceability.
ALTER TABLE ne_nn_tbl VALIDATE CONSTRAINT nn; -- error
ERROR: cannot validate NOT ENFORCED constraint
ALTER TABLE ne_nn_tbl ADD CONSTRAINT nn_enforced1 NOT NULL x NOT ENFORCED; -- error |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/constraints.out C:/cirrus/build/testrun/recovery/027_st...
--- C:/cirrus/src/test/regress/expected/constraints.out 2026-03-19 10:20:04.659322000 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/constraints.out 2026-03-19 10:26:09.993585000 +0000
@@ -1127,8 +1127,10 @@
INSERT INTO ne_nn_tbl VALUES (NULL); -- ok
ALTER TABLE ne_nn_tbl ALTER CONSTRAINT nn ENFORCED; -- error
ERROR: cannot alter enforceability of constraint "nn" of relation "ne_nn_tbl"
+HINT: Only foreign key and check constraints can change enforceability.
ALTER TABLE ne_nn_tbl ALTER CONSTRAINT nn NOT ENFORCED; -- error
ERROR: cannot alter enforceability of constraint "nn" of relation "ne_nn_tbl"
+HINT: Only foreign key and check constraints can change enforceability.
ALTER TABLE ne_nn_tbl VALIDATE CONSTRAINT nn; -- error
ERROR: cannot validate NOT ENFORCED constraint
ALTER TABLE ne_nn_tbl ADD CONSTRAINT nn_enforced1 NOT NULL x NOT ENFORCED; -- error |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/constraints.out C:/cirrus/build/testrun/regress/regress...
--- C:/cirrus/src/test/regress/expected/constraints.out 2026-03-19 10:20:04.659322000 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/constraints.out 2026-03-19 10:22:54.185401200 +0000
@@ -1127,8 +1127,10 @@
INSERT INTO ne_nn_tbl VALUES (NULL); -- ok
ALTER TABLE ne_nn_tbl ALTER CONSTRAINT nn ENFORCED; -- error
ERROR: cannot alter enforceability of constraint "nn" of relation "ne_nn_tbl"
+HINT: Only foreign key and check constraints can change enforceability.
ALTER TABLE ne_nn_tbl ALTER CONSTRAINT nn NOT ENFORCED; -- error
ERROR: cannot alter enforceability of constraint "nn" of relation "ne_nn_tbl"
+HINT: Only foreign key and check constraints can change enforceability.
ALTER TABLE ne_nn_tbl VALIDATE CONSTRAINT nn; -- error
ERROR: cannot validate NOT ENFORCED constraint
ALTER TABLE ne_nn_tbl ADD CONSTRAINT nn_enforced1 NOT NULL x NOT ENFORCED; -- error |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/constraints.out C:/cirrus/build/testrun/test_plan_advic...
--- C:/cirrus/src/test/regress/expected/constraints.out 2026-03-19 10:20:04.659322000 +0000
+++ C:/cirrus/build/testrun/test_plan_advice/001_replan_regress/data/results/constraints.out 2026-03-19 10:37:03.0166738...
@@ -1127,8 +1127,10 @@
INSERT INTO ne_nn_tbl VALUES (NULL); -- ok
ALTER TABLE ne_nn_tbl ALTER CONSTRAINT nn ENFORCED; -- error
ERROR: cannot alter enforceability of constraint "nn" of relation "ne_nn_tbl"
+HINT: Only foreign key and check constraints can change enforceability.
ALTER TABLE ne_nn_tbl ALTER CONSTRAINT nn NOT ENFORCED; -- error
ERROR: cannot alter enforceability of constraint "nn" of relation "ne_nn_tbl"
+HINT: Only foreign key and check constraints can change enforceability.
ALTER TABLE ne_nn_tbl VALIDATE CONSTRAINT nn; -- error
ERROR: cannot validate NOT ENFORCED constraint
ALTER TABLE ne_nn_tbl ADD CONSTRAINT nn_enforced1 NOT NULL x NOT ENFORCED; -- error |
| 58/6436 |
Add `tsmatch` JSONPath operator for granular Full Text Search |
|
Linux - Debian Trixie - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/jsonb.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_u...
--- /tmp/cirrus-ci-build/src/test/regress/expected/jsonb.out 2026-03-19 06:34:47.948268145 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/jsonb.out 2026-03-19 06:37:22.505407241 +0...
@@ -3036,2919 +3036,10 @@
(1 row)
SELECT count(*) FROM testjsonb WHERE j @@ '$.wait == "CC" && true == $.public';
- count
--------
- 2
-(1 row)
-
-SELECT count(*) FROM testjsonb WHERE j @@ '$.age == 25';
- count
--------
- 2
-(1 row)
-
-SELECT count(*) FROM testjsonb WHERE j @@ '$.age == 25.0';
- count
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/json.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/json.out 2026-03-19 06:34:47.948268145 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/json.out 2026-03-19 06:38:42.913610753 +...
@@ -1946,823 +1946,7 @@
(2 rows)
select * from json_populate_recordset(row('def',99,null)::jpop,'[{"a":"blurfl","x":43.2},{"b":3,"c":"2012-01-20 10:42:5...
- a | b | c
---------+----+--------------------------
- blurfl | 99 |
- def | 3 | Fri Jan 20 10:42:53 2012
-(2 rows)
-
-select * from json_populate_recordset(row('def',99,null)::jpop,'[{"a":[100,200,300],"x":43.2},{"a":{"z":true},"b":3,"c"...
- a | b | c
----------------+----+--------------------------
- [100,200,300] | 99 |
- {"z":true} | 3 | Fri Jan 20 10:42:53 2012
-(2 rows)
-
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/jsonb.out /tmp/cirrus-ci-build/build/testrun/regress/regress/res...
--- /tmp/cirrus-ci-build/src/test/regress/expected/jsonb.out 2026-03-19 06:34:47.948268145 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/jsonb.out 2026-03-19 06:37:21.461400604 +0000
@@ -3509,2446 +3509,10 @@
--gin path opclass
DROP INDEX jidx;
CREATE INDEX CONCURRENTLY jidx ON testjsonb USING gin (j jsonb_path_ops);
-SET enable_seqscan = off;
-SELECT count(*) FROM testjsonb WHERE j @> '{"wait":null}';
- count
--------
- 1
-(1 row)
-
-SELECT count(*) FROM testjsonb WHERE j @> '{"wait":"CC"}';
- count
--------
- 15
-(1 row)
-
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/jsonb.out /tmp/cirrus-ci-build/build/testrun/test_plan_advice/00...
--- /tmp/cirrus-ci-build/src/test/regress/expected/jsonb.out 2026-03-19 06:34:47.948268145 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/jsonb.out 2026-03-19 06:42:38.43...
@@ -3490,2465 +3490,10 @@
RESET enable_hashagg;
RESET enable_sort;
DROP INDEX jidx;
-DROP INDEX jidx_array;
--- btree
-CREATE INDEX jidx ON testjsonb USING btree (j);
-SET enable_seqscan = off;
-SELECT count(*) FROM testjsonb WHERE j > '{"p":1}';
- count
--------
- 884
-(1 row)
-
-SELECT count(*) FROM testjsonb WHERE j = '{"pos":98, "line":371, "node":"CBA", "indexed":true}';
- count
--------
... |
| 58/6274 |
Add a greedy join search algorithm to handle large join problems |
|
macOS - Sequoia - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/goo.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade...
--- /Users/admin/pgsql/src/test/regress/expected/goo.out 2026-03-18 14:57:47
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/goo.out 2026-03-18 15:01:35
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/goo.out /Users/admin/pgsql/build/testrun/recovery/027_stream_regre...
--- /Users/admin/pgsql/src/test/regress/expected/goo.out 2026-03-18 14:57:47
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/goo.out 2026-03-18 15:03:28
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/goo.out /Users/admin/pgsql/build/testrun/regress/regress/results/g...
--- /Users/admin/pgsql/src/test/regress/expected/goo.out 2026-03-18 14:57:47
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/goo.out 2026-03-18 15:01:38
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/goo.out /Users/admin/pgsql/build/testrun/test_plan_advice/001_repl...
--- /Users/admin/pgsql/src/test/regress/expected/goo.out 2026-03-18 14:57:47
+++ /Users/admin/pgsql/build/testrun/test_plan_advice/001_replan_regress/data/results/goo.out 2026-03-18 15:08:05
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
|
Windows - Server 2022, MinGW64 - Meson |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/goo.out C:/cirrus/build/testrun/pg_upgrade/002_pg_upgra...
--- C:/cirrus/src/test/regress/expected/goo.out 2026-03-18 14:58:02.449336100 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/goo.out 2026-03-18 15:01:37.812018900 +0000
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/goo.out C:/cirrus/build/testrun/recovery/027_stream_reg...
--- C:/cirrus/src/test/regress/expected/goo.out 2026-03-18 14:58:02.449336100 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/goo.out 2026-03-18 15:05:00.214364900 +0000
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/goo.out C:/cirrus/build/testrun/regress/regress/results...
--- C:/cirrus/src/test/regress/expected/goo.out 2026-03-18 14:58:02.449336100 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/goo.out 2026-03-18 15:01:34.899418400 +0000
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/goo.out C:/cirrus/build/testrun/test_plan_advice/001_re...
--- C:/cirrus/src/test/regress/expected/goo.out 2026-03-18 14:58:02.449336100 +0000
+++ C:/cirrus/build/testrun/test_plan_advice/001_replan_regress/data/results/goo.out 2026-03-18 15:15:32.953575100 +0000
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
|
Linux - Debian Trixie - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/goo.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upg...
--- /tmp/cirrus-ci-build/src/test/regress/expected/goo.out 2026-03-18 14:57:47.983627273 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/goo.out 2026-03-18 14:59:59.890131286 +000...
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/goo.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/goo.out 2026-03-18 14:57:47.983627273 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/goo.out 2026-03-18 15:01:27.253723292 +0...
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/goo.out /tmp/cirrus-ci-build/build/testrun/regress/regress/resul...
--- /tmp/cirrus-ci-build/src/test/regress/expected/goo.out 2026-03-18 14:57:47.983627273 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/goo.out 2026-03-18 15:00:01.342121963 +0000
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/goo.out /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/goo.out 2026-03-18 14:57:47.983627273 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/goo.out 2026-03-18 15:05:49.7653...
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/goo.out C:/cirrus/build/testrun/pg_upgrade/002_pg_upgra...
--- C:/cirrus/src/test/regress/expected/goo.out 2026-03-18 14:57:50.862352900 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/goo.out 2026-03-18 15:01:36.719845800 +0000
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/goo.out C:/cirrus/build/testrun/recovery/027_stream_reg...
--- C:/cirrus/src/test/regress/expected/goo.out 2026-03-18 14:57:50.862352900 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/goo.out 2026-03-18 15:04:53.658228200 +0000
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/goo.out C:/cirrus/build/testrun/regress/regress/results...
--- C:/cirrus/src/test/regress/expected/goo.out 2026-03-18 14:57:50.862352900 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/goo.out 2026-03-18 15:01:37.032353200 +0000
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/goo.out C:/cirrus/build/testrun/test_plan_advice/001_re...
--- C:/cirrus/src/test/regress/expected/goo.out 2026-03-18 14:57:50.862352900 +0000
+++ C:/cirrus/build/testrun/test_plan_advice/001_replan_regress/data/results/goo.out 2026-03-18 15:15:35.460031700 +0000
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
|
OpenBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/goo.out /home/postgres/postgres/build/testrun/pg_upgrade/002_...
--- /home/postgres/postgres/src/test/regress/expected/goo.out Wed Mar 18 14:57:56 2026
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/goo.out Wed Mar 18 15:00:24 2026
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/goo.out /home/postgres/postgres/build/testrun/recovery/027_st...
--- /home/postgres/postgres/src/test/regress/expected/goo.out Wed Mar 18 14:57:56 2026
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/goo.out Wed Mar 18 15:02:21 2026
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/goo.out /home/postgres/postgres/build/testrun/regress/regress...
--- /home/postgres/postgres/src/test/regress/expected/goo.out Wed Mar 18 14:57:56 2026
+++ /home/postgres/postgres/build/testrun/regress/regress/results/goo.out Wed Mar 18 15:00:16 2026
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/goo.out /home/postgres/postgres/build/testrun/test_plan_advic...
--- /home/postgres/postgres/src/test/regress/expected/goo.out Wed Mar 18 14:57:56 2026
+++ /home/postgres/postgres/build/testrun/test_plan_advice/001_replan_regress/data/results/goo.out Wed Mar 18 15:07:19 2...
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/goo.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upg...
--- /tmp/cirrus-ci-build/src/test/regress/expected/goo.out 2026-03-18 14:57:46.378740000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/goo.out 2026-03-18 14:59:55.519160000 +000...
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/goo.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/goo.out 2026-03-18 14:57:46.378740000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/goo.out 2026-03-18 15:01:20.911138000 +0...
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/goo.out /tmp/cirrus-ci-build/build/testrun/regress/regress/resul...
--- /tmp/cirrus-ci-build/src/test/regress/expected/goo.out 2026-03-18 14:57:46.378740000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/goo.out 2026-03-18 14:59:55.434311000 +0000
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/goo.out /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/goo.out 2026-03-18 14:57:46.378740000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/goo.out 2026-03-18 15:05:35.4772...
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/goo.out /home/postgres/postgres/build/testrun/pg_upgrade/002_...
--- /home/postgres/postgres/src/test/regress/expected/goo.out 2026-03-18 14:58:18.184180372 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/goo.out 2026-03-18 14:59:59.941240780 +...
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/goo.out /home/postgres/postgres/build/testrun/recovery/027_st...
--- /home/postgres/postgres/src/test/regress/expected/goo.out 2026-03-18 14:58:18.184180372 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/goo.out 2026-03-18 15:00:51.538288580...
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/goo.out /home/postgres/postgres/build/testrun/regress/regress...
--- /home/postgres/postgres/src/test/regress/expected/goo.out 2026-03-18 14:58:18.184180372 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/goo.out 2026-03-18 15:00:01.624601271 +0000
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/goo.out /home/postgres/postgres/build/testrun/test_plan_advic...
--- /home/postgres/postgres/src/test/regress/expected/goo.out 2026-03-18 14:58:18.184180372 +0000
+++ /home/postgres/postgres/build/testrun/test_plan_advice/001_replan_regress/data/results/goo.out 2026-03-18 15:03:16.1...
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
|
Linux - Debian Trixie - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/goo.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/result...
--- /tmp/cirrus-ci-build/src/test/regress/expected/goo.out 2026-03-18 14:58:01.943863288 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/goo.out 2026-03-18 15:04:36.459244154 +0000
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/goo.out /tmp/cirrus-ci-build/src/test/modules/test_plan_advice/t...
--- /tmp/cirrus-ci-build/src/test/regress/expected/goo.out 2026-03-18 14:58:01.943863288 +0000
+++ /tmp/cirrus-ci-build/src/test/modules/test_plan_advice/tmp_check/results/goo.out 2026-03-18 15:04:16.851253407 +0000
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/goo.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results...
--- /tmp/cirrus-ci-build/src/test/regress/expected/goo.out 2026-03-18 14:58:01.943863288 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/goo.out 2026-03-18 15:06:09.455176228 +0000
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/goo.out /tmp/cirrus-ci-build/src/test/regress/results/goo.out
--- /tmp/cirrus-ci-build/src/test/regress/expected/goo.out 2026-03-18 14:58:01.943863288 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/goo.out 2026-03-18 15:01:39.319378606 +0000
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |