PostgreSQL Patch Tester

Current commitfest | Next commitfest | FAQ | Statistics | Highlights

Highlight type: all assertion compiler core linker panic regress sanitizer tap test

Time range: current 7-day 30-day 90-day

This robot generates gigabytes of CI logs every week. Here is an attempt to search for "highlights", so it's easier to find actionable information quickly. New ideas for what patterns to search for are very welcome. "Current" shows only the most recent results from each submission. The wider time ranges also show information about historical versions, which may be useful for flapping tests, and also for hunting for bugs in master.

53/5708 don't generate fake alias names, only fake eref names
macOS - Sonoma - Meson
regress
diff -U3 /Users/admin/pgsql/src/test/regress/expected/memoize.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upg...
--- /Users/admin/pgsql/src/test/regress/expected/memoize.out	2025-07-06 17:54:12
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/memoize.out	2025-07-06 17:56:09
@@ -545,15 +545,15 @@
 SELECT * FROM tab_anti t1 WHERE t1.a IN
  (SELECT a FROM tab_anti t2 WHERE t2.b IN
   (SELECT t1.b FROM tab_anti t3 WHERE t2.a > 1 OFFSET 0));
-                   QUERY PLAN                    
--------------------------------------------------
+                    QUERY PLAN                     
+---------------------------------------------------
  Nested Loop Semi Join
    ->  Seq Scan on tab_anti t1
    ->  Nested Loop Semi Join
          Join Filter: (t1.a = t2.a)
          ->  Seq Scan on tab_anti t2
-         ->  Subquery Scan on "ANY_subquery"
-               Filter: (t2.b = "ANY_subquery".b)
+         ->  Subquery Scan on unnamed_subquery
+               Filter: (t2.b = unnamed_subquery.b)
...
regress
diff -U3 /Users/admin/pgsql/src/test/regress/expected/memoize.out /Users/admin/pgsql/build/testrun/recovery/027_stream_r...
--- /Users/admin/pgsql/src/test/regress/expected/memoize.out	2025-07-06 17:54:12
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/memoize.out	2025-07-06 17:57:25
@@ -545,15 +545,15 @@
 SELECT * FROM tab_anti t1 WHERE t1.a IN
  (SELECT a FROM tab_anti t2 WHERE t2.b IN
   (SELECT t1.b FROM tab_anti t3 WHERE t2.a > 1 OFFSET 0));
-                   QUERY PLAN                    
--------------------------------------------------
+                    QUERY PLAN                     
+---------------------------------------------------
  Nested Loop Semi Join
    ->  Seq Scan on tab_anti t1
    ->  Nested Loop Semi Join
          Join Filter: (t1.a = t2.a)
          ->  Seq Scan on tab_anti t2
-         ->  Subquery Scan on "ANY_subquery"
-               Filter: (t2.b = "ANY_subquery".b)
+         ->  Subquery Scan on unnamed_subquery
+               Filter: (t2.b = unnamed_subquery.b)
...
regress
diff -U3 /Users/admin/pgsql/src/test/regress/expected/memoize.out /Users/admin/pgsql/build/testrun/regress/regress/resul...
--- /Users/admin/pgsql/src/test/regress/expected/memoize.out	2025-07-06 17:54:12
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/memoize.out	2025-07-06 17:56:14
@@ -545,15 +545,15 @@
 SELECT * FROM tab_anti t1 WHERE t1.a IN
  (SELECT a FROM tab_anti t2 WHERE t2.b IN
   (SELECT t1.b FROM tab_anti t3 WHERE t2.a > 1 OFFSET 0));
-                   QUERY PLAN                    
--------------------------------------------------
+                    QUERY PLAN                     
+---------------------------------------------------
  Nested Loop Semi Join
    ->  Seq Scan on tab_anti t1
    ->  Nested Loop Semi Join
          Join Filter: (t1.a = t2.a)
          ->  Seq Scan on tab_anti t2
-         ->  Subquery Scan on "ANY_subquery"
-               Filter: (t2.b = "ANY_subquery".b)
+         ->  Subquery Scan on unnamed_subquery
+               Filter: (t2.b = unnamed_subquery.b)
...
Windows - Server 2019, VS 2019 - Meson & ninja
regress
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/memoize.out C:/cirrus/build/testrun/pg_upgrade/002_pg_u...
--- C:/cirrus/src/test/regress/expected/memoize.out	2025-07-06 17:54:21.093575500 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/memoize.out	2025-07-06 17:58:57.836167100 +0000
@@ -545,15 +545,15 @@
 SELECT * FROM tab_anti t1 WHERE t1.a IN
  (SELECT a FROM tab_anti t2 WHERE t2.b IN
   (SELECT t1.b FROM tab_anti t3 WHERE t2.a > 1 OFFSET 0));
-                   QUERY PLAN                    
--------------------------------------------------
+                    QUERY PLAN                     
+---------------------------------------------------
  Nested Loop Semi Join
    ->  Seq Scan on tab_anti t1
    ->  Nested Loop Semi Join
          Join Filter: (t1.a = t2.a)
          ->  Seq Scan on tab_anti t2
-         ->  Subquery Scan on "ANY_subquery"
-               Filter: (t2.b = "ANY_subquery".b)
+         ->  Subquery Scan on unnamed_subquery
+               Filter: (t2.b = unnamed_subquery.b)
...
regress
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/memoize.out C:/cirrus/build/testrun/recovery/027_stream...
--- C:/cirrus/src/test/regress/expected/memoize.out	2025-07-06 17:54:21.093575500 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/memoize.out	2025-07-06 18:01:46.883034900 +0000
@@ -545,15 +545,15 @@
 SELECT * FROM tab_anti t1 WHERE t1.a IN
  (SELECT a FROM tab_anti t2 WHERE t2.b IN
   (SELECT t1.b FROM tab_anti t3 WHERE t2.a > 1 OFFSET 0));
-                   QUERY PLAN                    
--------------------------------------------------
+                    QUERY PLAN                     
+---------------------------------------------------
  Nested Loop Semi Join
    ->  Seq Scan on tab_anti t1
    ->  Nested Loop Semi Join
          Join Filter: (t1.a = t2.a)
          ->  Seq Scan on tab_anti t2
-         ->  Subquery Scan on "ANY_subquery"
-               Filter: (t2.b = "ANY_subquery".b)
+         ->  Subquery Scan on unnamed_subquery
+               Filter: (t2.b = unnamed_subquery.b)
...
regress
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/memoize.out C:/cirrus/build/testrun/regress/regress/res...
--- C:/cirrus/src/test/regress/expected/memoize.out	2025-07-06 17:54:21.093575500 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/memoize.out	2025-07-06 17:58:51.254134200 +0000
@@ -545,15 +545,15 @@
 SELECT * FROM tab_anti t1 WHERE t1.a IN
  (SELECT a FROM tab_anti t2 WHERE t2.b IN
   (SELECT t1.b FROM tab_anti t3 WHERE t2.a > 1 OFFSET 0));
-                   QUERY PLAN                    
--------------------------------------------------
+                    QUERY PLAN                     
+---------------------------------------------------
  Nested Loop Semi Join
    ->  Seq Scan on tab_anti t1
    ->  Nested Loop Semi Join
          Join Filter: (t1.a = t2.a)
          ->  Seq Scan on tab_anti t2
-         ->  Subquery Scan on "ANY_subquery"
-               Filter: (t2.b = "ANY_subquery".b)
+         ->  Subquery Scan on unnamed_subquery
+               Filter: (t2.b = unnamed_subquery.b)
...
Linux - Debian Bookworm - Meson
regress
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/memoize.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg...
--- /tmp/cirrus-ci-build/src/test/regress/expected/memoize.out	2025-07-06 17:54:17.644328052 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/memoize.out	2025-07-06 17:57:11.662078495 ...
@@ -545,15 +545,15 @@
 SELECT * FROM tab_anti t1 WHERE t1.a IN
  (SELECT a FROM tab_anti t2 WHERE t2.b IN
   (SELECT t1.b FROM tab_anti t3 WHERE t2.a > 1 OFFSET 0));
-                   QUERY PLAN                    
--------------------------------------------------
+                    QUERY PLAN                     
+---------------------------------------------------
  Nested Loop Semi Join
    ->  Seq Scan on tab_anti t1
    ->  Nested Loop Semi Join
          Join Filter: (t1.a = t2.a)
          ->  Seq Scan on tab_anti t2
-         ->  Subquery Scan on "ANY_subquery"
-               Filter: (t2.b = "ANY_subquery".b)
+         ->  Subquery Scan on unnamed_subquery
+               Filter: (t2.b = unnamed_subquery.b)
...
regress
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/memoize.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stre...
--- /tmp/cirrus-ci-build/src/test/regress/expected/memoize.out	2025-07-06 17:54:17.644328052 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/memoize.out	2025-07-06 17:58:31.58602935...
@@ -545,15 +545,15 @@
 SELECT * FROM tab_anti t1 WHERE t1.a IN
  (SELECT a FROM tab_anti t2 WHERE t2.b IN
   (SELECT t1.b FROM tab_anti t3 WHERE t2.a > 1 OFFSET 0));
-                   QUERY PLAN                    
--------------------------------------------------
+                    QUERY PLAN                     
+---------------------------------------------------
  Nested Loop Semi Join
    ->  Seq Scan on tab_anti t1
    ->  Nested Loop Semi Join
          Join Filter: (t1.a = t2.a)
          ->  Seq Scan on tab_anti t2
-         ->  Subquery Scan on "ANY_subquery"
-               Filter: (t2.b = "ANY_subquery".b)
+         ->  Subquery Scan on unnamed_subquery
+               Filter: (t2.b = unnamed_subquery.b)
...
regress
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/memoize.out /tmp/cirrus-ci-build/build/testrun/regress/regress/r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/memoize.out	2025-07-06 17:54:17.644328052 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/memoize.out	2025-07-06 17:57:08.638084262 +0000
@@ -545,15 +545,15 @@
 SELECT * FROM tab_anti t1 WHERE t1.a IN
  (SELECT a FROM tab_anti t2 WHERE t2.b IN
   (SELECT t1.b FROM tab_anti t3 WHERE t2.a > 1 OFFSET 0));
-                   QUERY PLAN                    
--------------------------------------------------
+                    QUERY PLAN                     
+---------------------------------------------------
  Nested Loop Semi Join
    ->  Seq Scan on tab_anti t1
    ->  Nested Loop Semi Join
          Join Filter: (t1.a = t2.a)
          ->  Seq Scan on tab_anti t2
-         ->  Subquery Scan on "ANY_subquery"
-               Filter: (t2.b = "ANY_subquery".b)
+         ->  Subquery Scan on unnamed_subquery
+               Filter: (t2.b = unnamed_subquery.b)
...
Linux - Debian Bookworm - Autoconf
regress
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/memoize.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/re...
--- /tmp/cirrus-ci-build/src/test/regress/expected/memoize.out	2025-07-06 17:54:17.260049932 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/memoize.out	2025-07-06 18:00:52.729226676 +0000
@@ -545,15 +545,15 @@
 SELECT * FROM tab_anti t1 WHERE t1.a IN
  (SELECT a FROM tab_anti t2 WHERE t2.b IN
   (SELECT t1.b FROM tab_anti t3 WHERE t2.a > 1 OFFSET 0));
-                   QUERY PLAN                    
--------------------------------------------------
+                    QUERY PLAN                     
+---------------------------------------------------
  Nested Loop Semi Join
    ->  Seq Scan on tab_anti t1
    ->  Nested Loop Semi Join
          Join Filter: (t1.a = t2.a)
          ->  Seq Scan on tab_anti t2
-         ->  Subquery Scan on "ANY_subquery"
-               Filter: (t2.b = "ANY_subquery".b)
+         ->  Subquery Scan on unnamed_subquery
+               Filter: (t2.b = unnamed_subquery.b)
...
regress
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/memoize.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check/res...
--- /tmp/cirrus-ci-build/src/test/regress/expected/memoize.out	2025-07-06 17:54:17.260049932 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/memoize.out	2025-07-06 18:02:22.433157086 +0000
@@ -545,15 +545,15 @@
 SELECT * FROM tab_anti t1 WHERE t1.a IN
  (SELECT a FROM tab_anti t2 WHERE t2.b IN
   (SELECT t1.b FROM tab_anti t3 WHERE t2.a > 1 OFFSET 0));
-                   QUERY PLAN                    
--------------------------------------------------
+                    QUERY PLAN                     
+---------------------------------------------------
  Nested Loop Semi Join
    ->  Seq Scan on tab_anti t1
    ->  Nested Loop Semi Join
          Join Filter: (t1.a = t2.a)
          ->  Seq Scan on tab_anti t2
-         ->  Subquery Scan on "ANY_subquery"
-               Filter: (t2.b = "ANY_subquery".b)
+         ->  Subquery Scan on unnamed_subquery
+               Filter: (t2.b = unnamed_subquery.b)
...
regress
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/memoize.out /tmp/cirrus-ci-build/src/test/regress/results/memoiz...
--- /tmp/cirrus-ci-build/src/test/regress/expected/memoize.out	2025-07-06 17:54:17.260049932 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/memoize.out	2025-07-06 17:58:02.237423047 +0000
@@ -545,15 +545,15 @@
 SELECT * FROM tab_anti t1 WHERE t1.a IN
  (SELECT a FROM tab_anti t2 WHERE t2.b IN
   (SELECT t1.b FROM tab_anti t3 WHERE t2.a > 1 OFFSET 0));
-                   QUERY PLAN                    
--------------------------------------------------
+                    QUERY PLAN                     
+---------------------------------------------------
  Nested Loop Semi Join
    ->  Seq Scan on tab_anti t1
    ->  Nested Loop Semi Join
          Join Filter: (t1.a = t2.a)
          ->  Seq Scan on tab_anti t2
-         ->  Subquery Scan on "ANY_subquery"
-               Filter: (t2.b = "ANY_subquery".b)
+         ->  Subquery Scan on unnamed_subquery
+               Filter: (t2.b = unnamed_subquery.b)
...
FreeBSD - Meson
regress
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/memoize.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg...
--- /tmp/cirrus-ci-build/src/test/regress/expected/memoize.out	2025-07-06 17:54:17.501396000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/memoize.out	2025-07-06 17:58:20.555380000 ...
@@ -545,15 +545,15 @@
 SELECT * FROM tab_anti t1 WHERE t1.a IN
  (SELECT a FROM tab_anti t2 WHERE t2.b IN
   (SELECT t1.b FROM tab_anti t3 WHERE t2.a > 1 OFFSET 0));
-                   QUERY PLAN                    
--------------------------------------------------
+                    QUERY PLAN                     
+---------------------------------------------------
  Nested Loop Semi Join
    ->  Seq Scan on tab_anti t1
    ->  Nested Loop Semi Join
          Join Filter: (t1.a = t2.a)
          ->  Seq Scan on tab_anti t2
-         ->  Subquery Scan on "ANY_subquery"
-               Filter: (t2.b = "ANY_subquery".b)
+         ->  Subquery Scan on unnamed_subquery
+               Filter: (t2.b = unnamed_subquery.b)
...
regress
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/memoize.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stre...
--- /tmp/cirrus-ci-build/src/test/regress/expected/memoize.out	2025-07-06 17:54:17.501396000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/memoize.out	2025-07-06 17:59:46.67994200...
@@ -545,15 +545,15 @@
 SELECT * FROM tab_anti t1 WHERE t1.a IN
  (SELECT a FROM tab_anti t2 WHERE t2.b IN
   (SELECT t1.b FROM tab_anti t3 WHERE t2.a > 1 OFFSET 0));
-                   QUERY PLAN                    
--------------------------------------------------
+                    QUERY PLAN                     
+---------------------------------------------------
  Nested Loop Semi Join
    ->  Seq Scan on tab_anti t1
    ->  Nested Loop Semi Join
          Join Filter: (t1.a = t2.a)
          ->  Seq Scan on tab_anti t2
-         ->  Subquery Scan on "ANY_subquery"
-               Filter: (t2.b = "ANY_subquery".b)
+         ->  Subquery Scan on unnamed_subquery
+               Filter: (t2.b = unnamed_subquery.b)
...
regress
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/memoize.out /tmp/cirrus-ci-build/build/testrun/regress/regress/r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/memoize.out	2025-07-06 17:54:17.501396000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/memoize.out	2025-07-06 17:58:23.611417000 +0000
@@ -545,15 +545,15 @@
 SELECT * FROM tab_anti t1 WHERE t1.a IN
  (SELECT a FROM tab_anti t2 WHERE t2.b IN
   (SELECT t1.b FROM tab_anti t3 WHERE t2.a > 1 OFFSET 0));
-                   QUERY PLAN                    
--------------------------------------------------
+                    QUERY PLAN                     
+---------------------------------------------------
  Nested Loop Semi Join
    ->  Seq Scan on tab_anti t1
    ->  Nested Loop Semi Join
          Join Filter: (t1.a = t2.a)
          ->  Seq Scan on tab_anti t2
-         ->  Subquery Scan on "ANY_subquery"
-               Filter: (t2.b = "ANY_subquery".b)
+         ->  Subquery Scan on unnamed_subquery
+               Filter: (t2.b = unnamed_subquery.b)
...
53/4904 SQL Property Graph Queries (SQL/PGQ)
FreeBSD - Meson
regress
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/graph_table.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/00...
--- /tmp/cirrus-ci-build/src/test/regress/expected/graph_table.out	2025-07-06 16:39:11.166496000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/graph_table.out	2025-07-06 16:42:25.486032...
@@ -536,8 +536,8 @@
 SELECT * FROM GRAPH_TABLE (g1 MATCH (a)-[b]->(a)-[b]->(a) COLUMNS (a.vname AS self, b.ename AS loop_name)) ORDER BY loo...
  self | loop_name 
 ------+-----------
- v33  | e331
  v33  | E331
+ v33  | e331
 (2 rows)
 
 SELECT * FROM GRAPH_TABLE (g1 MATCH (a)-[b]->(a)-[b]->(a) COLUMNS (a.vname AS self, b.ename AS loop_name)) ORDER BY loo...
@@ -613,8 +613,8 @@
 SELECT * FROM GRAPH_TABLE (g2 MATCH (a)-[b]->(a)-[b]->(a) COLUMNS (a.elname AS self, b.elname COLLATE pg_catalog."defau...
   self  | loop_name 
 --------+-----------
- g2.v33 | g2.e331
  g2.v33 | g2.E331
+ g2.v33 | g2.e331
...
Linux - Debian Bookworm - Autoconf
regress
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/graph_table.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_chec...
--- /tmp/cirrus-ci-build/src/test/regress/expected/graph_table.out	2025-07-06 16:39:12.790303668 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/graph_table.out	2025-07-06 16:48:02.965631334 +0000
@@ -536,8 +536,8 @@
 SELECT * FROM GRAPH_TABLE (g1 MATCH (a)-[b]->(a)-[b]->(a) COLUMNS (a.vname AS self, b.ename AS loop_name)) ORDER BY loo...
  self | loop_name 
 ------+-----------
- v33  | e331
  v33  | E331
+ v33  | e331
 (2 rows)
 
 SELECT * FROM GRAPH_TABLE (g1 MATCH (a)-[b]->(a)-[b]->(a) COLUMNS (a.vname AS self, b.ename AS loop_name)) ORDER BY loo...
@@ -613,8 +613,8 @@
 SELECT * FROM GRAPH_TABLE (g2 MATCH (a)-[b]->(a)-[b]->(a) COLUMNS (a.elname AS self, b.elname COLLATE pg_catalog."defau...
   self  | loop_name 
 --------+-----------
- g2.v33 | g2.e331
  g2.v33 | g2.E331
+ g2.v33 | g2.e331
...
regress
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/graph_table.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check...
--- /tmp/cirrus-ci-build/src/test/regress/expected/graph_table.out	2025-07-06 16:39:12.790303668 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/graph_table.out	2025-07-06 16:49:44.577542520 +0000
@@ -536,8 +536,8 @@
 SELECT * FROM GRAPH_TABLE (g1 MATCH (a)-[b]->(a)-[b]->(a) COLUMNS (a.vname AS self, b.ename AS loop_name)) ORDER BY loo...
  self | loop_name 
 ------+-----------
- v33  | e331
  v33  | E331
+ v33  | e331
 (2 rows)
 
 SELECT * FROM GRAPH_TABLE (g1 MATCH (a)-[b]->(a)-[b]->(a) COLUMNS (a.vname AS self, b.ename AS loop_name)) ORDER BY loo...
@@ -613,8 +613,8 @@
 SELECT * FROM GRAPH_TABLE (g2 MATCH (a)-[b]->(a)-[b]->(a) COLUMNS (a.elname AS self, b.elname COLLATE pg_catalog."defau...
   self  | loop_name 
 --------+-----------
- g2.v33 | g2.e331
  g2.v33 | g2.E331
+ g2.v33 | g2.e331
...
regress
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/graph_table.out /tmp/cirrus-ci-build/src/test/regress/results/gr...
--- /tmp/cirrus-ci-build/src/test/regress/expected/graph_table.out	2025-07-06 16:39:12.790303668 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/graph_table.out	2025-07-06 16:44:44.681769869 +0000
@@ -536,8 +536,8 @@
 SELECT * FROM GRAPH_TABLE (g1 MATCH (a)-[b]->(a)-[b]->(a) COLUMNS (a.vname AS self, b.ename AS loop_name)) ORDER BY loo...
  self | loop_name 
 ------+-----------
- v33  | e331
  v33  | E331
+ v33  | e331
 (2 rows)
 
 SELECT * FROM GRAPH_TABLE (g1 MATCH (a)-[b]->(a)-[b]->(a) COLUMNS (a.vname AS self, b.ename AS loop_name)) ORDER BY loo...
@@ -613,8 +613,8 @@
 SELECT * FROM GRAPH_TABLE (g2 MATCH (a)-[b]->(a)-[b]->(a) COLUMNS (a.elname AS self, b.elname COLLATE pg_catalog."defau...
   self  | loop_name 
 --------+-----------
- g2.v33 | g2.e331
  g2.v33 | g2.E331
+ g2.v33 | g2.e331
...
Linux - Debian Bookworm - Meson
regress
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/graph_table.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/00...
--- /tmp/cirrus-ci-build/src/test/regress/expected/graph_table.out	2025-07-06 16:39:09.624542165 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/graph_table.out	2025-07-06 16:44:48.494098...
@@ -536,8 +536,8 @@
 SELECT * FROM GRAPH_TABLE (g1 MATCH (a)-[b]->(a)-[b]->(a) COLUMNS (a.vname AS self, b.ename AS loop_name)) ORDER BY loo...
  self | loop_name 
 ------+-----------
- v33  | e331
  v33  | E331
+ v33  | e331
 (2 rows)
 
 SELECT * FROM GRAPH_TABLE (g1 MATCH (a)-[b]->(a)-[b]->(a) COLUMNS (a.vname AS self, b.ename AS loop_name)) ORDER BY loo...
@@ -613,8 +613,8 @@
 SELECT * FROM GRAPH_TABLE (g2 MATCH (a)-[b]->(a)-[b]->(a) COLUMNS (a.elname AS self, b.elname COLLATE pg_catalog."defau...
   self  | loop_name 
 --------+-----------
- g2.v33 | g2.e331
  g2.v33 | g2.E331
+ g2.v33 | g2.e331
...
regress
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/graph_table.out /tmp/cirrus-ci-build/build/testrun/recovery/027_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/graph_table.out	2025-07-06 16:39:09.624542165 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/graph_table.out	2025-07-06 16:46:06.1663...
@@ -536,8 +536,8 @@
 SELECT * FROM GRAPH_TABLE (g1 MATCH (a)-[b]->(a)-[b]->(a) COLUMNS (a.vname AS self, b.ename AS loop_name)) ORDER BY loo...
  self | loop_name 
 ------+-----------
- v33  | e331
  v33  | E331
+ v33  | e331
 (2 rows)
 
 SELECT * FROM GRAPH_TABLE (g1 MATCH (a)-[b]->(a)-[b]->(a) COLUMNS (a.vname AS self, b.ename AS loop_name)) ORDER BY loo...
@@ -613,8 +613,8 @@
 SELECT * FROM GRAPH_TABLE (g2 MATCH (a)-[b]->(a)-[b]->(a) COLUMNS (a.elname AS self, b.elname COLLATE pg_catalog."defau...
   self  | loop_name 
 --------+-----------
- g2.v33 | g2.e331
  g2.v33 | g2.E331
+ g2.v33 | g2.e331
...
regress
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/graph_table.out /tmp/cirrus-ci-build/build/testrun/regress/regre...
--- /tmp/cirrus-ci-build/src/test/regress/expected/graph_table.out	2025-07-06 16:39:09.624542165 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/graph_table.out	2025-07-06 16:44:46.314093913 +0000
@@ -536,8 +536,8 @@
 SELECT * FROM GRAPH_TABLE (g1 MATCH (a)-[b]->(a)-[b]->(a) COLUMNS (a.vname AS self, b.ename AS loop_name)) ORDER BY loo...
  self | loop_name 
 ------+-----------
- v33  | e331
  v33  | E331
+ v33  | e331
 (2 rows)
 
 SELECT * FROM GRAPH_TABLE (g1 MATCH (a)-[b]->(a)-[b]->(a) COLUMNS (a.vname AS self, b.ename AS loop_name)) ORDER BY loo...
@@ -613,8 +613,8 @@
 SELECT * FROM GRAPH_TABLE (g2 MATCH (a)-[b]->(a)-[b]->(a) COLUMNS (a.elname AS self, b.elname COLLATE pg_catalog."defau...
   self  | loop_name 
 --------+-----------
- g2.v33 | g2.e331
  g2.v33 | g2.E331
+ g2.v33 | g2.e331
...
macOS - Sonoma - Meson
regress
diff -U3 /Users/admin/pgsql/src/test/regress/expected/graph_table.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg...
--- /Users/admin/pgsql/src/test/regress/expected/graph_table.out	2025-07-06 16:38:12
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/graph_table.out	2025-07-06 16:41:04
@@ -536,8 +536,8 @@
 SELECT * FROM GRAPH_TABLE (g1 MATCH (a)-[b]->(a)-[b]->(a) COLUMNS (a.vname AS self, b.ename AS loop_name)) ORDER BY loo...
  self | loop_name 
 ------+-----------
- v33  | e331
  v33  | E331
+ v33  | e331
 (2 rows)
 
 SELECT * FROM GRAPH_TABLE (g1 MATCH (a)-[b]->(a)-[b]->(a) COLUMNS (a.vname AS self, b.ename AS loop_name)) ORDER BY loo...
@@ -613,8 +613,8 @@
 SELECT * FROM GRAPH_TABLE (g2 MATCH (a)-[b]->(a)-[b]->(a) COLUMNS (a.elname AS self, b.elname COLLATE pg_catalog."defau...
   self  | loop_name 
 --------+-----------
- g2.v33 | g2.e331
  g2.v33 | g2.E331
+ g2.v33 | g2.e331
...
regress
diff -U3 /Users/admin/pgsql/src/test/regress/expected/graph_table.out /Users/admin/pgsql/build/testrun/recovery/027_stre...
--- /Users/admin/pgsql/src/test/regress/expected/graph_table.out	2025-07-06 16:38:12
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/graph_table.out	2025-07-06 16:41:58
@@ -536,8 +536,8 @@
 SELECT * FROM GRAPH_TABLE (g1 MATCH (a)-[b]->(a)-[b]->(a) COLUMNS (a.vname AS self, b.ename AS loop_name)) ORDER BY loo...
  self | loop_name 
 ------+-----------
- v33  | e331
  v33  | E331
+ v33  | e331
 (2 rows)
 
 SELECT * FROM GRAPH_TABLE (g1 MATCH (a)-[b]->(a)-[b]->(a) COLUMNS (a.vname AS self, b.ename AS loop_name)) ORDER BY loo...
@@ -613,8 +613,8 @@
 SELECT * FROM GRAPH_TABLE (g2 MATCH (a)-[b]->(a)-[b]->(a) COLUMNS (a.elname AS self, b.elname COLLATE pg_catalog."defau...
   self  | loop_name 
 --------+-----------
- g2.v33 | g2.e331
  g2.v33 | g2.E331
+ g2.v33 | g2.e331
...
regress
diff -U3 /Users/admin/pgsql/src/test/regress/expected/graph_table.out /Users/admin/pgsql/build/testrun/regress/regress/r...
--- /Users/admin/pgsql/src/test/regress/expected/graph_table.out	2025-07-06 16:38:12
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/graph_table.out	2025-07-06 16:41:00
@@ -536,8 +536,8 @@
 SELECT * FROM GRAPH_TABLE (g1 MATCH (a)-[b]->(a)-[b]->(a) COLUMNS (a.vname AS self, b.ename AS loop_name)) ORDER BY loo...
  self | loop_name 
 ------+-----------
- v33  | e331
  v33  | E331
+ v33  | e331
 (2 rows)
 
 SELECT * FROM GRAPH_TABLE (g1 MATCH (a)-[b]->(a)-[b]->(a) COLUMNS (a.vname AS self, b.ename AS loop_name)) ORDER BY loo...
@@ -613,8 +613,8 @@
 SELECT * FROM GRAPH_TABLE (g2 MATCH (a)-[b]->(a)-[b]->(a) COLUMNS (a.elname AS self, b.elname COLLATE pg_catalog."defau...
   self  | loop_name 
 --------+-----------
- g2.v33 | g2.e331
  g2.v33 | g2.E331
+ g2.v33 | g2.e331
...
Windows - Server 2019, VS 2019 - Meson & ninja
regress
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/graph_table.out C:/cirrus/build/testrun/pg_upgrade/002_...
--- C:/cirrus/src/test/regress/expected/graph_table.out	2025-07-06 16:39:15.682416100 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/graph_table.out	2025-07-06 16:42:47.774436000 +0000
@@ -536,8 +536,8 @@
 SELECT * FROM GRAPH_TABLE (g1 MATCH (a)-[b]->(a)-[b]->(a) COLUMNS (a.vname AS self, b.ename AS loop_name)) ORDER BY loo...
  self | loop_name 
 ------+-----------
- v33  | e331
  v33  | E331
+ v33  | e331
 (2 rows)
 
 SELECT * FROM GRAPH_TABLE (g1 MATCH (a)-[b]->(a)-[b]->(a) COLUMNS (a.vname AS self, b.ename AS loop_name)) ORDER BY loo...
@@ -613,8 +613,8 @@
 SELECT * FROM GRAPH_TABLE (g2 MATCH (a)-[b]->(a)-[b]->(a) COLUMNS (a.elname AS self, b.elname COLLATE pg_catalog."defau...
   self  | loop_name 
 --------+-----------
- g2.v33 | g2.e331
  g2.v33 | g2.E331
+ g2.v33 | g2.e331
...
53/5808 display current search_path in psql prompt
FreeBSD - Meson
regress
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out /tmp/cirrus-ci-build/build/testrun/regress-runn...
--- /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out	2025-07-06 09:31:12.542000000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress-running/regress/results/create_index.out	2025-07-06 09:38:32.651094000 +0...
@@ -2042,7 +2042,7 @@
                                  QUERY PLAN                                 
 ----------------------------------------------------------------------------
  Aggregate
-   ->  Index Only Scan using tenk1_thous_tenthous on tenk1 t1
+   ->  Seq Scan on tenk1 t1
          Filter: ((thousand = 42) OR (thousand = (SubPlan 1)))
          SubPlan 1
            ->  Limit
@@ -2211,9 +2211,11 @@
                Filter: ((thousand = 42) OR (thousand = 41) OR (tenthous = 2))
                ->  Bitmap Index Scan on tenk2_hundred
                      Index Cond: (hundred = 42)
-         ->  Index Only Scan using tenk1_hundred on tenk1
-               Index Cond: (hundred = 42)
-(9 rows)
+         ->  Bitmap Heap Scan on tenk1
...
53/5755 Parallel processing of indexes in autovacuum
macOS - Sonoma - Meson
regress
diff -U3 /Users/admin/pgsql/src/test/regress/expected/stats.out /Users/admin/pgsql/build/testrun/recovery/027_stream_reg...
--- /Users/admin/pgsql/src/test/regress/expected/stats.out	2025-07-06 08:34:12
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/stats.out	2025-07-06 08:37:59
@@ -1414,7 +1414,7 @@
 SELECT :io_sum_shared_after_writes > :io_sum_shared_before_writes;
  ?column? 
 ----------
- t
+ f
 (1 row)
 
 SELECT current_setting('fsync') = 'off'
53/5319 Changing shared_buffers without restart
Linux - Debian Bookworm - Autoconf
regress
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/numa.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/resul...
--- /tmp/cirrus-ci-build/src/test/regress/expected/numa.out	2025-07-05 20:14:03.629909115 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/numa.out	2025-07-05 20:22:18.215972452 +0000
@@ -6,8 +6,4 @@
 -- switch to superuser
 \c -
 SELECT COUNT(*) >= 0 AS ok FROM pg_shmem_allocations_numa;
- ok 
-----
- t
-(1 row)
-
+ERROR:  invalid memory alloc request size 864765899839712
regress
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/numa.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check/result...
--- /tmp/cirrus-ci-build/src/test/regress/expected/numa.out	2025-07-05 20:14:03.629909115 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/numa.out	2025-07-05 20:23:35.334876234 +0000
@@ -6,8 +6,4 @@
 -- switch to superuser
 \c -
 SELECT COUNT(*) >= 0 AS ok FROM pg_shmem_allocations_numa;
- ok 
-----
- t
-(1 row)
-
+ERROR:  invalid memory alloc request size 864765899624256
regress
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/numa.out /tmp/cirrus-ci-build/src/test/regress/results/numa.out
--- /tmp/cirrus-ci-build/src/test/regress/expected/numa.out	2025-07-05 20:14:03.629909115 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/numa.out	2025-07-05 20:20:03.782391099 +0000
@@ -6,8 +6,4 @@
 -- switch to superuser
 \c -
 SELECT COUNT(*) >= 0 AS ok FROM pg_shmem_allocations_numa;
- ok 
-----
- t
-(1 row)
-
+ERROR:  invalid memory alloc request size 864765899885808
55/5892 parallel safety of correlated subquery (was: parallel_safe)
Linux - Debian Bookworm - Meson
regress
diff -U3 /tmp/cirrus-ci-build/contrib/btree_gist/expected/without_overlaps.out /tmp/cirrus-ci-build/build/testrun/btree_...
--- /tmp/cirrus-ci-build/contrib/btree_gist/expected/without_overlaps.out	2025-07-05 19:38:59.168733227 +0000
+++ /tmp/cirrus-ci-build/build/testrun/btree_gist/regress/results/without_overlaps.out	2025-07-05 19:45:01.008431081 +00...
@@ -9,84 +9,7 @@
   CONSTRAINT temporal_rng_pk PRIMARY KEY (id, valid_at WITHOUT OVERLAPS)
 );
 \d temporal_rng
-              Table "public.temporal_rng"
-  Column  |   Type    | Collation | Nullable | Default 
-----------+-----------+-----------+----------+---------
- id       | integer   |           | not null | 
- valid_at | daterange |           | not null | 
-Indexes:
-    "temporal_rng_pk" PRIMARY KEY (id, valid_at WITHOUT OVERLAPS)
-
-SELECT pg_get_constraintdef(oid) FROM pg_constraint WHERE conname = 'temporal_rng_pk';
-            pg_get_constraintdef             
----------------------------------------------
- PRIMARY KEY (id, valid_at WITHOUT OVERLAPS)
-(1 row)
...
regress
diff -U3 /tmp/cirrus-ci-build/contrib/earthdistance/expected/earthdistance.out /tmp/cirrus-ci-build/build/testrun/earthd...
--- /tmp/cirrus-ci-build/contrib/earthdistance/expected/earthdistance.out	2025-07-05 19:38:59.188733226 +0000
+++ /tmp/cirrus-ci-build/build/testrun/earthdistance/regress/results/earthdistance.out	2025-07-05 19:45:03.012431043 +00...
@@ -1053,46 +1053,7 @@
 drop extension cube cascade;
 NOTICE:  drop cascades to column f1 of table foo
 \d foo
-                Table "public.foo"
- Column |  Type   | Collation | Nullable | Default 
---------+---------+-----------+----------+---------
- f2     | integer |           |          | 
-
--- list what's installed
-\dT public.*
-     List of data types
- Schema | Name | Description 
---------+------+-------------
-(0 rows)
-
-\df public.*
...
regress
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/bit.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upg...
--- /tmp/cirrus-ci-build/src/test/regress/expected/bit.out	2025-07-05 19:39:01.104733152 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/bit.out	2025-07-05 19:43:47.344434857 +000...
@@ -772,79 +772,7 @@
   b4 bit varying(5) DEFAULT B'0101'
 );
 \d bit_defaults
-                     Table "public.bit_defaults"
- Column |      Type      | Collation | Nullable |       Default       
---------+----------------+-----------+----------+---------------------
- b1     | bit(4)         |           |          | '1001'::"bit"
- b2     | bit(4)         |           |          | '0101'::"bit"
- b3     | bit varying(5) |           |          | '1001'::bit varying
- b4     | bit varying(5) |           |          | '0101'::"bit"
-
-INSERT INTO bit_defaults DEFAULT VALUES;
-TABLE bit_defaults;
-  b1  |  b2  |  b3  |  b4  
-------+------+------+------
- 1001 | 0101 | 1001 | 0101
...
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	2025-07-05 19:38:59.276733222 +0000
+++ /tmp/cirrus-ci-build/build/testrun/postgres_fdw/regress/results/postgres_fdw.out	2025-07-05 19:45:16.048430850 +0000
@@ -409,12184 +409,7 @@
 
 -- subquery
 SELECT * FROM ft1 t1 WHERE t1.c3 IN (SELECT c3 FROM ft2 t2 WHERE c1 <= 10) ORDER BY c1;
- c1 | c2 |  c3   |              c4              |            c5            | c6 |     c7     | c8  
-----+----+-------+------------------------------+--------------------------+----+------------+-----
-  1 |  1 | 00001 | Fri Jan 02 00:00:00 1970 PST | Fri Jan 02 00:00:00 1970 | 1  | 1          | foo
-  2 |  2 | 00002 | Sat Jan 03 00:00:00 1970 PST | Sat Jan 03 00:00:00 1970 | 2  | 2          | foo
-  3 |  3 | 00003 | Sun Jan 04 00:00:00 1970 PST | Sun Jan 04 00:00:00 1970 | 3  | 3          | foo
-  4 |  4 | 00004 | Mon Jan 05 00:00:00 1970 PST | Mon Jan 05 00:00:00 1970 | 4  | 4          | foo
-  5 |  5 | 00005 | Tue Jan 06 00:00:00 1970 PST | Tue Jan 06 00:00:00 1970 | 5  | 5          | foo
-  6 |  6 | 00006 | Wed Jan 07 00:00:00 1970 PST | Wed Jan 07 00:00:00 1970 | 6  | 6          | foo
-  7 |  7 | 00007 | Thu Jan 08 00:00:00 1970 PST | Thu Jan 08 00:00:00 1970 | 7  | 7          | foo
-  8 |  8 | 00008 | Fri Jan 09 00:00:00 1970 PST | Fri Jan 09 00:00:00 1970 | 8  | 8          | foo
-  9 |  9 | 00009 | Sat Jan 10 00:00:00 1970 PST | Sat Jan 10 00:00:00 1970 | 9  | 9          | foo
- 10 |  0 | 00010 | Sun Jan 11 00:00:00 1970 PST | Sun Jan 11 00:00:00 1970 | 0  | 0          | foo
-(10 rows)
...
regress
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/bit.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/bit.out	2025-07-05 19:39:01.104733152 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/bit.out	2025-07-05 19:44:27.328432117 +0...
@@ -772,79 +772,7 @@
   b4 bit varying(5) DEFAULT B'0101'
 );
 \d bit_defaults
-                     Table "public.bit_defaults"
- Column |      Type      | Collation | Nullable |       Default       
---------+----------------+-----------+----------+---------------------
- b1     | bit(4)         |           |          | '1001'::"bit"
- b2     | bit(4)         |           |          | '0101'::"bit"
- b3     | bit varying(5) |           |          | '1001'::bit varying
- b4     | bit varying(5) |           |          | '0101'::"bit"
-
-INSERT INTO bit_defaults DEFAULT VALUES;
-TABLE bit_defaults;
-  b1  |  b2  |  b3  |  b4  
-------+------+------+------
- 1001 | 0101 | 1001 | 0101
...
regress
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/bit.out /tmp/cirrus-ci-build/build/testrun/regress/regress/resul...
--- /tmp/cirrus-ci-build/src/test/regress/expected/bit.out	2025-07-05 19:39:01.104733152 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/bit.out	2025-07-05 19:43:46.544434937 +0000
@@ -772,79 +772,7 @@
   b4 bit varying(5) DEFAULT B'0101'
 );
 \d bit_defaults
-                     Table "public.bit_defaults"
- Column |      Type      | Collation | Nullable |       Default       
---------+----------------+-----------+----------+---------------------
- b1     | bit(4)         |           |          | '1001'::"bit"
- b2     | bit(4)         |           |          | '0101'::"bit"
- b3     | bit varying(5) |           |          | '1001'::bit varying
- b4     | bit varying(5) |           |          | '0101'::"bit"
-
-INSERT INTO bit_defaults DEFAULT VALUES;
-TABLE bit_defaults;
-  b1  |  b2  |  b3  |  b4  
-------+------+------+------
- 1001 | 0101 | 1001 | 0101
...
regress
diff -U3 /tmp/cirrus-ci-build/contrib/seg/expected/partition.out /tmp/cirrus-ci-build/build/testrun/seg/regress/results/...
--- /tmp/cirrus-ci-build/contrib/seg/expected/partition.out	2025-07-05 19:38:59.284733222 +0000
+++ /tmp/cirrus-ci-build/build/testrun/seg/regress/results/partition.out	2025-07-05 19:45:16.244430847 +0000
@@ -24,31 +24,7 @@
 create table pt34 partition of pt for values in (3,4);
 insert into pt values(4, '-1 .. 1'::seg, 'foo');
 \d+ pt
-                                Partitioned table "public.pt"
-  Column  |  Type   | Collation | Nullable | Default | Storage  | Stats target | Description 
-----------+---------+-----------+----------+---------+----------+--------------+-------------
- category | integer |           |          |         | plain    |              | 
- sdata    | seg     |           |          |         | plain    |              | 
- tdata    | text    |           |          |         | extended |              | 
-Partition key: LIST (category)
-Indexes:
-    "pti1" btree ((mydouble(category) + 1))
-    "pti2" btree (sdata)
-    "pti3" btree (tdata COLLATE mycollation)
-Partitions: pt12 FOR VALUES IN (1, 2),
-            pt34 FOR VALUES IN (3, 4)
...
regress
diff -U3 /tmp/cirrus-ci-build/contrib/test_decoding/expected/ddl.out /tmp/cirrus-ci-build/build/testrun/test_decoding/re...
--- /tmp/cirrus-ci-build/contrib/test_decoding/expected/ddl.out	2025-07-05 19:38:59.304733221 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_decoding/regress/results/ddl.out	2025-07-05 19:45:19.384430812 +0000
@@ -484,374 +484,7 @@
 WITH (user_catalog_table = true)
 ;
 \d+ replication_metadata
-                                                 Table "public.replication_metadata"
-  Column  |  Type   | Collation | Nullable |                     Default                      | Storage  | Stats target...
-----------+---------+-----------+----------+--------------------------------------------------+----------+-------------...
- id       | integer |           | not null | nextval('replication_metadata_id_seq'::regclass) | plain    |             ...
- relation | name    |           | not null |                                                  | plain    |             ...
- options  | text[]  |           |          |                                                  | extended |             ...
-Indexes:
-    "replication_metadata_pkey" PRIMARY KEY, btree (id)
-Not-null constraints:
-    "replication_metadata_id_not_null" NOT NULL "id"
-    "replication_metadata_relation_not_null" NOT NULL "relation"
-Options: user_catalog_table=true
-
...
53/5829 VCI (columnar store extension)
Linux - Debian Bookworm - Meson
regress
diff -U3 /tmp/cirrus-ci-build/contrib/vci/expected/vci.out /tmp/cirrus-ci-build/build/testrun/vci/regress/results/vci.ou...
--- /tmp/cirrus-ci-build/contrib/vci/expected/vci.out	2025-07-05 18:05:12.150435870 +0000
+++ /tmp/cirrus-ci-build/build/testrun/vci/regress/results/vci.out	2025-07-05 18:12:43.316883091 +0000
@@ -88,39 +88,7 @@
 INSERT INTO testtable (key, cond, c01a, c01b, c02, c03, c05, c06, c07, c08, c09, c10, c13, c15, c16, c17, c18, c19, c20...
 -- Create an index which uses VCI index access method
 CREATE INDEX testindex ON testtable USING vci (key, cond, c01a, c01b, c02, c03, c05, c06, c07, c08, c09, c10, c13, c15,...
--- We expect VCI plans are chosen here
-EXPLAIN (ANALYZE, TIMING OFF, COSTS OFF, SUMMARY OFF, BUFFERS OFF)
-SELECT key, count(*) AS count_star, count(c05) AS count_c05 FROM testtable WHERE NOT cond = 0 GROUP BY key ORDER BY key...
-                                           QUERY PLAN                                           
-------------------------------------------------------------------------------------------------
- Sort (actual rows=14.00 loops=1)
-   Sort Key: key
-   Sort Method: quicksort  Memory: 25kB
-   ->  Custom Scan (VCI HashAggregate) (actual rows=14.00 loops=1)
-         Group Key: key
-         ->  Custom Scan (VCI Scan) using testindex on testtable (actual rows=10221.00 loops=1)
-               Filter: (cond <> 0)
-               Rows Removed by Filter: 476
...
53/5270 jsonpath string methods: lower, upper, initcap, l/r/btrim, replace, split_part
Windows - Server 2019, VS 2019 - Meson & ninja
regress
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/jsonpath.out C:/cirrus/build/testrun/pg_upgrade/002_pg_...
--- C:/cirrus/src/test/regress/expected/jsonpath.out	2025-07-05 17:20:16.860132500 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/jsonpath.out	2025-07-05 17:24:39.761345200 +0000
@@ -436,998 +436,7 @@
 (1 row)
 
 select '$.replace("hello","bye")'::jsonpath;
-         jsonpath         
---------------------------
- $.replace("hello","bye")
-(1 row)
-
-select '$.lower()'::jsonpath;
- jsonpath  
------------
- $.lower()
-(1 row)
-
-select '$.upper()'::jsonpath;
- jsonpath  
...
regress
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/jsonpath.out C:/cirrus/build/testrun/recovery/027_strea...
--- C:/cirrus/src/test/regress/expected/jsonpath.out	2025-07-05 17:20:16.860132500 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/jsonpath.out	2025-07-05 17:27:25.417033200 +0000
@@ -436,998 +436,7 @@
 (1 row)
 
 select '$.replace("hello","bye")'::jsonpath;
-         jsonpath         
---------------------------
- $.replace("hello","bye")
-(1 row)
-
-select '$.lower()'::jsonpath;
- jsonpath  
------------
- $.lower()
-(1 row)
-
-select '$.upper()'::jsonpath;
- jsonpath  
...
regress
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/jsonpath.out C:/cirrus/build/testrun/regress/regress/re...
--- C:/cirrus/src/test/regress/expected/jsonpath.out	2025-07-05 17:20:16.860132500 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/jsonpath.out	2025-07-05 17:25:45.765670700 +0000
@@ -436,998 +436,7 @@
 (1 row)
 
 select '$.replace("hello","bye")'::jsonpath;
-         jsonpath         
---------------------------
- $.replace("hello","bye")
-(1 row)
-
-select '$.lower()'::jsonpath;
- jsonpath  
------------
- $.lower()
-(1 row)
-
-select '$.upper()'::jsonpath;
- jsonpath  
...
macOS - Sonoma - Meson
regress
diff -U3 /Users/admin/pgsql/src/test/regress/expected/json.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrad...
--- /Users/admin/pgsql/src/test/regress/expected/json.out	2025-07-05 17:19:12
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/json.out	2025-07-05 17:22:17
@@ -2245,524 +2245,10 @@
 SELECT json_build_object('{1,2,3}'::int[], 3);
 ERROR:  key value must be scalar, not array, composite, or json
 CREATE TEMP TABLE foo (serial_num int, name text, type text);
-INSERT INTO foo VALUES (847001,'t15','GE1043');
-INSERT INTO foo VALUES (847002,'t16','GE1043');
-INSERT INTO foo VALUES (847003,'sub-alpha','GESS90');
-SELECT json_build_object('turbines',json_object_agg(serial_num,json_build_object('name',name,'type',type)))
-FROM foo;
-                                                                            json_build_object                          ...
------------------------------------------------------------------------------------------------------------------------...
- {"turbines" : { "847001" : {"name" : "t15", "type" : "GE1043"}, "847002" : {"name" : "t16", "type" : "GE1043"}, "84700...
-(1 row)
-
-SELECT json_object_agg(name, type) FROM foo;
-                        json_object_agg                         
-----------------------------------------------------------------
...
regress
diff -U3 /Users/admin/pgsql/src/test/regress/expected/jsonb.out /Users/admin/pgsql/build/testrun/recovery/027_stream_reg...
--- /Users/admin/pgsql/src/test/regress/expected/jsonb.out	2025-07-05 17:19:12
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/jsonb.out	2025-07-05 17:24:39
@@ -3460,2374 +3460,11 @@
 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 
--------
-     1
-(1 row)
-
...
regress
diff -U3 /Users/admin/pgsql/src/test/regress/expected/jsonpath.out /Users/admin/pgsql/build/testrun/regress/regress/resu...
--- /Users/admin/pgsql/src/test/regress/expected/jsonpath.out	2025-07-05 17:19:12
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/jsonpath.out	2025-07-05 17:22:16
@@ -436,998 +436,7 @@
 (1 row)
 
 select '$.replace("hello","bye")'::jsonpath;
-         jsonpath         
---------------------------
- $.replace("hello","bye")
-(1 row)
-
-select '$.lower()'::jsonpath;
- jsonpath  
------------
- $.lower()
-(1 row)
-
-select '$.upper()'::jsonpath;
- jsonpath  
...
Linux - Debian Bookworm - Meson
regress
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/jsonpath.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_p...
--- /tmp/cirrus-ci-build/src/test/regress/expected/jsonpath.out	2025-07-05 17:20:12.599473762 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/jsonpath.out	2025-07-05 17:22:51.303345775...
@@ -436,998 +436,7 @@
 (1 row)
 
 select '$.replace("hello","bye")'::jsonpath;
-         jsonpath         
---------------------------
- $.replace("hello","bye")
-(1 row)
-
-select '$.lower()'::jsonpath;
- jsonpath  
------------
- $.lower()
-(1 row)
-
-select '$.upper()'::jsonpath;
- jsonpath  
...
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	2025-07-05 17:20:12.595495160 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/json.out	2025-07-05 17:24:04.955579984 +...
@@ -2175,594 +2175,7 @@
 (1 row)
 
 SELECT json_build_object(VARIADIC NULL::text[]); -- ok
- json_build_object 
--------------------
- 
-(1 row)
-
-SELECT json_build_object(VARIADIC '{}'::text[]); -- ok
- json_build_object 
--------------------
- {}
-(1 row)
-
-SELECT json_build_object(VARIADIC '{a,b,c}'::text[]); -- error
-ERROR:  argument list must have even number of elements
...
regress
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/jsonpath.out /tmp/cirrus-ci-build/build/testrun/regress/regress/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/jsonpath.out	2025-07-05 17:20:12.599473762 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/jsonpath.out	2025-07-05 17:22:51.023343078 +0000
@@ -436,998 +436,7 @@
 (1 row)
 
 select '$.replace("hello","bye")'::jsonpath;
-         jsonpath         
---------------------------
- $.replace("hello","bye")
-(1 row)
-
-select '$.lower()'::jsonpath;
- jsonpath  
------------
- $.lower()
-(1 row)
-
-select '$.upper()'::jsonpath;
- jsonpath  
...
Linux - Debian Bookworm - Autoconf
regress
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/jsonpath.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/jsonpath.out	2025-07-05 17:20:13.581354587 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/jsonpath.out	2025-07-05 17:25:44.198561635 +0000
@@ -436,998 +436,7 @@
 (1 row)
 
 select '$.replace("hello","bye")'::jsonpath;
-         jsonpath         
---------------------------
- $.replace("hello","bye")
-(1 row)
-
-select '$.lower()'::jsonpath;
- jsonpath  
------------
- $.lower()
-(1 row)
-
-select '$.upper()'::jsonpath;
- jsonpath  
...
regress
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/jsonpath.out /tmp/cirrus-ci-build/src/test/regress/results/jsonp...
--- /tmp/cirrus-ci-build/src/test/regress/expected/jsonpath.out	2025-07-05 17:20:13.581354587 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/jsonpath.out	2025-07-05 17:23:33.850465751 +0000
@@ -436,998 +436,7 @@
 (1 row)
 
 select '$.replace("hello","bye")'::jsonpath;
-         jsonpath         
---------------------------
- $.replace("hello","bye")
-(1 row)
-
-select '$.lower()'::jsonpath;
- jsonpath  
------------
- $.lower()
-(1 row)
-
-select '$.upper()'::jsonpath;
- jsonpath  
...
FreeBSD - Meson
regress
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/json.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_up...
--- /tmp/cirrus-ci-build/src/test/regress/expected/json.out	2025-07-05 17:20:12.881373000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/json.out	2025-07-05 17:23:21.159479000 +00...
@@ -1086,1683 +1086,10 @@
 (1 row)
 
 select json_extract_path_text('{"f2":{"f3":1},"f4":[0,1,2,null]}','f4','3') is null as expect_true;
- expect_true 
--------------
- t
-(1 row)
-
--- extract_path operators
-select '{"f2":{"f3":1},"f4":{"f5":99,"f6":"stringy"}}'::json#>array['f4','f6'];
- ?column?  
------------
- "stringy"
-(1 row)
-
-select '{"f2":{"f3":1},"f4":{"f5":99,"f6":"stringy"}}'::json#>array['f2'];
...
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	2025-07-05 17:20:12.881373000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/json.out	2025-07-05 17:24:21.228491000 +...
@@ -1074,1695 +1074,10 @@
 (1 row)
 
 select json_extract_path_text('{"f2":{"f3":1},"f4":{"f5":null,"f6":"stringy"}}','f4','f5') is null as expect_true;
- expect_true 
--------------
- t
-(1 row)
-
-select json_extract_path('{"f2":{"f3":1},"f4":[0,1,2,null]}','f4','3') is null as expect_false;
- expect_false 
---------------
- f
-(1 row)
-
-select json_extract_path_text('{"f2":{"f3":1},"f4":[0,1,2,null]}','f4','3') is null as expect_true;
- expect_true 
...
regress
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/json.out /tmp/cirrus-ci-build/build/testrun/regress/regress/resu...
--- /tmp/cirrus-ci-build/src/test/regress/expected/json.out	2025-07-05 17:20:12.881373000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/json.out	2025-07-05 17:23:23.058748000 +0000
@@ -1172,1597 +1172,10 @@
 (1 row)
 
 select '{"a": {"b":{"c": "foo"}}}'::json #> array['a'];
-      ?column?      
---------------------
- {"b":{"c": "foo"}}
-(1 row)
-
-select '{"a": {"b":{"c": "foo"}}}'::json #> array['a', null];
- ?column? 
-----------
- 
-(1 row)
-
-select '{"a": {"b":{"c": "foo"}}}'::json #> array['a', ''];
- ?column? 
...
53/5382 Adding compression of temporary files
macOS - Sonoma - Meson
regress
diff -U3 /Users/admin/pgsql/src/test/regress/expected/join_hash_pglz.out /Users/admin/pgsql/build/testrun/pg_upgrade/002...
--- /Users/admin/pgsql/src/test/regress/expected/join_hash_pglz.out	2025-07-05 17:09:12
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/join_hash_pglz.out	2025-07-05 17:11:48
@@ -252,915 +252,7 @@
 (9 rows)
 
 select count(*) from simple r join simple s using (id);
- count 
--------
- 20000
-(1 row)
-
-select original > 1 as initially_multibatch, final > original as increased_batches
-  from hash_join_batches(
-$$
-  select count(*) from simple r join simple s using (id);
-$$);
- initially_multibatch | increased_batches 
-----------------------+-------------------
- t                    | f
...
regress
diff -U3 /Users/admin/pgsql/src/test/regress/expected/join_hash_pglz.out /Users/admin/pgsql/build/testrun/regress/regres...
--- /Users/admin/pgsql/src/test/regress/expected/join_hash_pglz.out	2025-07-05 17:09:12
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/join_hash_pglz.out	2025-07-05 17:11:23
@@ -262,11 +262,9 @@
 $$
   select count(*) from simple r join simple s using (id);
 $$);
- initially_multibatch | increased_batches 
-----------------------+-------------------
- t                    | f
-(1 row)
-
+ERROR:  could not read from temporary file: read only 8176 of 14110 bytes
+CONTEXT:  parallel worker
+PL/pgSQL function hash_join_batches(text) line 6 at FOR over EXECUTE statement
 rollback to settings;
 -- parallel with parallel-aware hash join
 savepoint settings;
Linux - Debian Bookworm - Meson
regress
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/join_hash_pglz.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade...
--- /tmp/cirrus-ci-build/src/test/regress/expected/join_hash_pglz.out	2025-07-05 17:09:25.456236121 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/join_hash_pglz.out	2025-07-05 17:12:27.391...
@@ -262,11 +262,8 @@
 $$
   select count(*) from simple r join simple s using (id);
 $$);
- initially_multibatch | increased_batches 
-----------------------+-------------------
- t                    | f
-(1 row)
-
+ERROR:  could not read from temporary file: read only 8176 of 11860 bytes
+CONTEXT:  PL/pgSQL function hash_join_batches(text) line 6 at FOR over EXECUTE statement
 rollback to settings;
 -- parallel with parallel-aware hash join
 savepoint settings;
53/4681 Make COPY format extendable: Extract COPY TO format implementations
FreeBSD - Meson
regress
diff -U3 /tmp/cirrus-ci-build/src/test/modules/test_copy_format/expected/test_copy_format.out /tmp/cirrus-ci-build/build...
--- /tmp/cirrus-ci-build/src/test/modules/test_copy_format/expected/test_copy_format.out	2025-07-05 14:43:08.177300000 +...
+++ /tmp/cirrus-ci-build/build/testrun/test_copy_format-running/regress/results/test_copy_format.out	2025-07-05 14:50:30...
@@ -1,19 +1,13 @@
 CREATE TABLE copy_data (a smallint, b integer, c bigint);
 INSERT INTO copy_data VALUES (1, 2, 3), (12, 34, 56), (123, 456, 789);
 COPY copy_data FROM stdin WITH (FORMAT 'test_copy_format');
-NOTICE:  CopyFromInFunc: attribute: smallint
-NOTICE:  CopyFromInFunc: attribute: integer
-NOTICE:  CopyFromInFunc: attribute: bigint
-NOTICE:  CopyFromStart: the number of attributes: 3
-NOTICE:  CopyFromOneRow
-NOTICE:  CopyFromEnd
+ERROR:  COPY format "test_copy_format" not recognized
+LINE 1: COPY copy_data FROM stdin WITH (FORMAT 'test_copy_format');
+                                        ^
+\.
+invalid command \.
 COPY copy_data TO stdout WITH (FORMAT 'test_copy_format');
-NOTICE:  CopyToOutFunc: attribute: smallint
...
53/5681 Prevent internal error at concurrent CREATE OR REPLACE / ALTER FUNCTION
Windows - Server 2019, VS 2019 - Meson & ninja
regress
diff --strip-trailing-cr -U3 C:/cirrus/src/test/modules/injection_points/expected/syscache-update-pruned.out C:/cirrus/b...
--- C:/cirrus/src/test/modules/injection_points/expected/syscache-update-pruned.out	2025-07-05 07:08:17.052287600 +0000
+++ C:/cirrus/build/testrun/injection_points/isolation/results/syscache-update-pruned.out	2025-07-05 07:16:26.946532200 ...
@@ -46,7 +46,7 @@
 	SELECT FROM injection_points_wakeup('heap_update-before-pin');
  <waiting ...>
 step grant1: <... completed>
-ERROR:  duplicate key value violates unique constraint "pg_class_oid_index"
+ERROR:  could not create object because a conflicting object already exists
 step wakegrant4: <... completed>
 
 starting permutation: snap3 cachefill1 at2 mkrels4 r3 waitprunable4 vac4 grant1 wakeinval4 at4 wakegrant4 inspect4
regress
diff --strip-trailing-cr -U3 C:/cirrus/contrib/test_decoding/expected/replorigin.out C:/cirrus/build/testrun/test_decodi...
--- C:/cirrus/contrib/test_decoding/expected/replorigin.out	2025-07-05 07:08:13.067675000 +0000
+++ C:/cirrus/build/testrun/test_decoding/regress/results/replorigin.out	2025-07-05 07:16:24.539787200 +0000
@@ -39,8 +39,9 @@
 
 -- ensure duplicate creations fail
 SELECT pg_replication_origin_create('regress_test_decoding: regression_slot');
-ERROR:  duplicate key value violates unique constraint "pg_replication_origin_roname_index"
-DETAIL:  Key (roname)=(regress_test_decoding: regression_slot) already exists.
+ERROR:  could not create object because a conflicting object already exists
+DETAIL:  Key (roname)=(regress_test_decoding: regression_slot) conflicts with existing entry in unique index pg_replica...
+HINT:  Another session might have created an object with the same key concurrently.
 --ensure deletions work (once)
 SELECT pg_replication_origin_create('regress_test_decoding: temp');
  pg_replication_origin_create 
macOS - Sonoma - Meson
regress
diff -U3 /Users/admin/pgsql/src/test/modules/injection_points/expected/syscache-update-pruned.out /Users/admin/pgsql/bui...
--- /Users/admin/pgsql/src/test/modules/injection_points/expected/syscache-update-pruned.out	2025-07-05 07:07:11
+++ /Users/admin/pgsql/build/testrun/injection_points/isolation/results/syscache-update-pruned.out	2025-07-05 07:13:00
@@ -46,7 +46,7 @@
 	SELECT FROM injection_points_wakeup('heap_update-before-pin');
  <waiting ...>
 step grant1: <... completed>
-ERROR:  duplicate key value violates unique constraint "pg_class_oid_index"
+ERROR:  could not create object because a conflicting object already exists
 step wakegrant4: <... completed>
 
 starting permutation: snap3 cachefill1 at2 mkrels4 r3 waitprunable4 vac4 grant1 wakeinval4 at4 wakegrant4 inspect4
regress
diff -U3 /Users/admin/pgsql/contrib/test_decoding/expected/replorigin.out /Users/admin/pgsql/build/testrun/test_decoding...
--- /Users/admin/pgsql/contrib/test_decoding/expected/replorigin.out	2025-07-05 07:07:10
+++ /Users/admin/pgsql/build/testrun/test_decoding/regress/results/replorigin.out	2025-07-05 07:12:57
@@ -39,8 +39,9 @@
 
 -- ensure duplicate creations fail
 SELECT pg_replication_origin_create('regress_test_decoding: regression_slot');
-ERROR:  duplicate key value violates unique constraint "pg_replication_origin_roname_index"
-DETAIL:  Key (roname)=(regress_test_decoding: regression_slot) already exists.
+ERROR:  could not create object because a conflicting object already exists
+DETAIL:  Key (roname)=(regress_test_decoding: regression_slot) conflicts with existing entry in unique index pg_replica...
+HINT:  Another session might have created an object with the same key concurrently.
 --ensure deletions work (once)
 SELECT pg_replication_origin_create('regress_test_decoding: temp');
  pg_replication_origin_create 
Linux - Debian Bookworm - Meson
regress
diff -U3 /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/syscache-update-pruned.out /tmp/cirrus-ci-build...
--- /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/syscache-update-pruned.out	2025-07-05 07:08:09.06630...
+++ /tmp/cirrus-ci-build/build/testrun/injection_points/isolation/results/syscache-update-pruned.out	2025-07-05 07:13:59...
@@ -46,7 +46,7 @@
 	SELECT FROM injection_points_wakeup('heap_update-before-pin');
  <waiting ...>
 step grant1: <... completed>
-ERROR:  duplicate key value violates unique constraint "pg_class_oid_index"
+ERROR:  could not create object because a conflicting object already exists
 step wakegrant4: <... completed>
 
 starting permutation: snap3 cachefill1 at2 mkrels4 r3 waitprunable4 vac4 grant1 wakeinval4 at4 wakegrant4 inspect4
regress
diff -U3 /tmp/cirrus-ci-build/contrib/test_decoding/expected/replorigin.out /tmp/cirrus-ci-build/build/testrun/test_deco...
--- /tmp/cirrus-ci-build/contrib/test_decoding/expected/replorigin.out	2025-07-05 07:08:07.336459915 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_decoding/regress/results/replorigin.out	2025-07-05 07:13:53.244971742 +0000
@@ -39,8 +39,9 @@
 
 -- ensure duplicate creations fail
 SELECT pg_replication_origin_create('regress_test_decoding: regression_slot');
-ERROR:  duplicate key value violates unique constraint "pg_replication_origin_roname_index"
-DETAIL:  Key (roname)=(regress_test_decoding: regression_slot) already exists.
+ERROR:  could not create object because a conflicting object already exists
+DETAIL:  Key (roname)=(regress_test_decoding: regression_slot) conflicts with existing entry in unique index pg_replica...
+HINT:  Another session might have created an object with the same key concurrently.
 --ensure deletions work (once)
 SELECT pg_replication_origin_create('regress_test_decoding: temp');
  pg_replication_origin_create 
FreeBSD - Meson
regress
diff -U3 /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/syscache-update-pruned.out /tmp/cirrus-ci-build...
--- /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/syscache-update-pruned.out	2025-07-05 07:08:08.50368...
+++ /tmp/cirrus-ci-build/build/testrun/injection_points/isolation/results/syscache-update-pruned.out	2025-07-05 07:11:45...
@@ -46,7 +46,7 @@
 	SELECT FROM injection_points_wakeup('heap_update-before-pin');
  <waiting ...>
 step grant1: <... completed>
-ERROR:  duplicate key value violates unique constraint "pg_class_oid_index"
+ERROR:  could not create object because a conflicting object already exists
 step wakegrant4: <... completed>
 
 starting permutation: snap3 cachefill1 at2 mkrels4 r3 waitprunable4 vac4 grant1 wakeinval4 at4 wakegrant4 inspect4
regress
diff -U3 /tmp/cirrus-ci-build/contrib/test_decoding/expected/replorigin.out /tmp/cirrus-ci-build/build/testrun/test_deco...
--- /tmp/cirrus-ci-build/contrib/test_decoding/expected/replorigin.out	2025-07-05 07:08:07.133466000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_decoding/regress/results/replorigin.out	2025-07-05 07:11:39.037152000 +0000
@@ -39,8 +39,9 @@
 
 -- ensure duplicate creations fail
 SELECT pg_replication_origin_create('regress_test_decoding: regression_slot');
-ERROR:  duplicate key value violates unique constraint "pg_replication_origin_roname_index"
-DETAIL:  Key (roname)=(regress_test_decoding: regression_slot) already exists.
+ERROR:  could not create object because a conflicting object already exists
+DETAIL:  Key (roname)=(regress_test_decoding: regression_slot) conflicts with existing entry in unique index pg_replica...
+HINT:  Another session might have created an object with the same key concurrently.
 --ensure deletions work (once)
 SELECT pg_replication_origin_create('regress_test_decoding: temp');
  pg_replication_origin_create 
Linux - Debian Bookworm - Autoconf
regress
diff -U3 /tmp/cirrus-ci-build/contrib/test_decoding/expected/replorigin.out /tmp/cirrus-ci-build/contrib/test_decoding/r...
--- /tmp/cirrus-ci-build/contrib/test_decoding/expected/replorigin.out	2025-07-05 07:08:09.161085224 +0000
+++ /tmp/cirrus-ci-build/contrib/test_decoding/results/replorigin.out	2025-07-05 07:14:57.813044854 +0000
@@ -39,8 +39,9 @@
 
 -- ensure duplicate creations fail
 SELECT pg_replication_origin_create('regress_test_decoding: regression_slot');
-ERROR:  duplicate key value violates unique constraint "pg_replication_origin_roname_index"
-DETAIL:  Key (roname)=(regress_test_decoding: regression_slot) already exists.
+ERROR:  could not create object because a conflicting object already exists
+DETAIL:  Key (roname)=(regress_test_decoding: regression_slot) conflicts with existing entry in unique index pg_replica...
+HINT:  Another session might have created an object with the same key concurrently.
 --ensure deletions work (once)
 SELECT pg_replication_origin_create('regress_test_decoding: temp');
  pg_replication_origin_create 
regress
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/plpgsql.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/re...
--- /tmp/cirrus-ci-build/src/test/regress/expected/plpgsql.out	2025-07-05 07:08:11.067307760 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/plpgsql.out	2025-07-05 07:15:08.725021990 +0000
@@ -3549,2308 +3549,7 @@
   end loop;
 end;
 $$ language plpgsql;
-select forc01();
-NOTICE:  1, 1
-NOTICE:  2, 2
-NOTICE:  3, 3
-NOTICE:  4, 4
-NOTICE:  5, 5
-NOTICE:  6, 6
-NOTICE:  7, 7
-NOTICE:  8, 8
-NOTICE:  9, 9
-NOTICE:  10, 10
- forc01 
---------
...
regress
diff -U3 /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/syscache-update-pruned.out /tmp/cirrus-ci-build...
--- /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/syscache-update-pruned.out	2025-07-05 07:08:10.90744...
+++ /tmp/cirrus-ci-build/src/test/modules/injection_points/output_iso/results/syscache-update-pruned.out	2025-07-05 07:1...
@@ -46,7 +46,7 @@
 	SELECT FROM injection_points_wakeup('heap_update-before-pin');
  <waiting ...>
 step grant1: <... completed>
-ERROR:  duplicate key value violates unique constraint "pg_class_oid_index"
+ERROR:  could not create object because a conflicting object already exists
 step wakegrant4: <... completed>
 
 starting permutation: snap3 cachefill1 at2 mkrels4 r3 waitprunable4 vac4 grant1 wakeinval4 at4 wakegrant4 inspect4
regress
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/plpgsql.out /tmp/cirrus-ci-build/src/test/regress/results/plpgsq...
--- /tmp/cirrus-ci-build/src/test/regress/expected/plpgsql.out	2025-07-05 07:08:11.067307760 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/plpgsql.out	2025-07-05 07:12:51.089278096 +0000
@@ -3549,2308 +3549,7 @@
   end loop;
 end;
 $$ language plpgsql;
-select forc01();
-NOTICE:  1, 1
-NOTICE:  2, 2
-NOTICE:  3, 3
-NOTICE:  4, 4
-NOTICE:  5, 5
-NOTICE:  6, 6
-NOTICE:  7, 7
-NOTICE:  8, 8
-NOTICE:  9, 9
-NOTICE:  10, 10
- forc01 
---------
...
53/5814 Add enable_groupagg GUC parameter to control GroupAggregate usage
Windows - Server 2019, VS 2019 - Meson & ninja
regress
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/join_hash.out C:/cirrus/build/testrun/pg_upgrade/002_pg...
--- C:/cirrus/src/test/regress/expected/join_hash.out	2025-07-05 04:19:32.562621900 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/join_hash.out	2025-07-05 04:23:06.142365000 +0000
@@ -1137,18 +1137,21 @@
 int8_tbl i8,
 lateral (select t1.fivethous, i4.f1 from tenk1 t1 join int4_tbl i4
          on t1.fivethous = i4.f1+i8.q2 order by 1,2) ss;
-                        QUERY PLAN                         
------------------------------------------------------------
+                           QUERY PLAN                            
+-----------------------------------------------------------------
  Nested Loop
    ->  Seq Scan on int8_tbl i8
-   ->  Sort
-         Sort Key: t1.fivethous, i4.f1
-         ->  Hash Join
-               Hash Cond: (t1.fivethous = (i4.f1 + i8.q2))
-               ->  Seq Scan on tenk1 t1
-               ->  Hash
-                     ->  Seq Scan on int4_tbl i4
...
regress
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/join_hash.out C:/cirrus/build/testrun/recovery/027_stre...
--- C:/cirrus/src/test/regress/expected/join_hash.out	2025-07-05 04:19:32.562621900 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/join_hash.out	2025-07-05 04:25:54.078449700 +0000
@@ -1137,18 +1137,21 @@
 int8_tbl i8,
 lateral (select t1.fivethous, i4.f1 from tenk1 t1 join int4_tbl i4
          on t1.fivethous = i4.f1+i8.q2 order by 1,2) ss;
-                        QUERY PLAN                         
------------------------------------------------------------
+                           QUERY PLAN                            
+-----------------------------------------------------------------
  Nested Loop
    ->  Seq Scan on int8_tbl i8
-   ->  Sort
-         Sort Key: t1.fivethous, i4.f1
-         ->  Hash Join
-               Hash Cond: (t1.fivethous = (i4.f1 + i8.q2))
-               ->  Seq Scan on tenk1 t1
-               ->  Hash
-                     ->  Seq Scan on int4_tbl i4
...
regress
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/join_hash.out C:/cirrus/build/testrun/regress/regress/r...
--- C:/cirrus/src/test/regress/expected/join_hash.out	2025-07-05 04:19:32.562621900 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/join_hash.out	2025-07-05 04:23:01.428568600 +0000
@@ -1137,18 +1137,21 @@
 int8_tbl i8,
 lateral (select t1.fivethous, i4.f1 from tenk1 t1 join int4_tbl i4
          on t1.fivethous = i4.f1+i8.q2 order by 1,2) ss;
-                        QUERY PLAN                         
------------------------------------------------------------
+                           QUERY PLAN                            
+-----------------------------------------------------------------
  Nested Loop
    ->  Seq Scan on int8_tbl i8
-   ->  Sort
-         Sort Key: t1.fivethous, i4.f1
-         ->  Hash Join
-               Hash Cond: (t1.fivethous = (i4.f1 + i8.q2))
-               ->  Seq Scan on tenk1 t1
-               ->  Hash
-                     ->  Seq Scan on int4_tbl i4
...
macOS - Sonoma - Meson
regress
diff -U3 /Users/admin/pgsql/src/test/regress/expected/join_hash.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_u...
--- /Users/admin/pgsql/src/test/regress/expected/join_hash.out	2025-07-05 04:19:15
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/join_hash.out	2025-07-05 04:22:32
@@ -1137,18 +1137,21 @@
 int8_tbl i8,
 lateral (select t1.fivethous, i4.f1 from tenk1 t1 join int4_tbl i4
          on t1.fivethous = i4.f1+i8.q2 order by 1,2) ss;
-                        QUERY PLAN                         
------------------------------------------------------------
+                           QUERY PLAN                            
+-----------------------------------------------------------------
  Nested Loop
    ->  Seq Scan on int8_tbl i8
-   ->  Sort
-         Sort Key: t1.fivethous, i4.f1
-         ->  Hash Join
-               Hash Cond: (t1.fivethous = (i4.f1 + i8.q2))
-               ->  Seq Scan on tenk1 t1
-               ->  Hash
-                     ->  Seq Scan on int4_tbl i4
...
regress
diff -U3 /Users/admin/pgsql/src/test/regress/expected/join_hash.out /Users/admin/pgsql/build/testrun/recovery/027_stream...
--- /Users/admin/pgsql/src/test/regress/expected/join_hash.out	2025-07-05 04:19:15
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/join_hash.out	2025-07-05 04:24:09
@@ -1137,18 +1137,21 @@
 int8_tbl i8,
 lateral (select t1.fivethous, i4.f1 from tenk1 t1 join int4_tbl i4
          on t1.fivethous = i4.f1+i8.q2 order by 1,2) ss;
-                        QUERY PLAN                         
------------------------------------------------------------
+                           QUERY PLAN                            
+-----------------------------------------------------------------
  Nested Loop
    ->  Seq Scan on int8_tbl i8
-   ->  Sort
-         Sort Key: t1.fivethous, i4.f1
-         ->  Hash Join
-               Hash Cond: (t1.fivethous = (i4.f1 + i8.q2))
-               ->  Seq Scan on tenk1 t1
-               ->  Hash
-                     ->  Seq Scan on int4_tbl i4
...
regress
diff -U3 /Users/admin/pgsql/src/test/regress/expected/join_hash.out /Users/admin/pgsql/build/testrun/regress/regress/res...
--- /Users/admin/pgsql/src/test/regress/expected/join_hash.out	2025-07-05 04:19:15
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/join_hash.out	2025-07-05 04:22:31
@@ -1137,18 +1137,21 @@
 int8_tbl i8,
 lateral (select t1.fivethous, i4.f1 from tenk1 t1 join int4_tbl i4
          on t1.fivethous = i4.f1+i8.q2 order by 1,2) ss;
-                        QUERY PLAN                         
------------------------------------------------------------
+                           QUERY PLAN                            
+-----------------------------------------------------------------
  Nested Loop
    ->  Seq Scan on int8_tbl i8
-   ->  Sort
-         Sort Key: t1.fivethous, i4.f1
-         ->  Hash Join
-               Hash Cond: (t1.fivethous = (i4.f1 + i8.q2))
-               ->  Seq Scan on tenk1 t1
-               ->  Hash
-                     ->  Seq Scan on int4_tbl i4
...
Linux - Debian Bookworm - Meson
regress
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/join.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_up...
--- /tmp/cirrus-ci-build/src/test/regress/expected/join.out	2025-07-05 04:19:32.276460567 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/join.out	2025-07-05 04:21:43.786576126 +00...
@@ -8186,15 +8186,15 @@
   lateral (values(x.q1,y.q1,y.q2)) v(xq1,yq1,yq2);
         q1        |        q2         |        q1        |        q2         |       xq1        |       yq1        |   ...
 ------------------+-------------------+------------------+-------------------+------------------+------------------+---...
-              123 |               456 |                  |                   |              123 |                  |   ...
-              123 |  4567890123456789 | 4567890123456789 | -4567890123456789 |              123 | 4567890123456789 | -4...
-              123 |  4567890123456789 | 4567890123456789 |  4567890123456789 |              123 | 4567890123456789 |  4...
-              123 |  4567890123456789 | 4567890123456789 |               123 |              123 | 4567890123456789 |   ...
- 4567890123456789 |               123 |              123 |  4567890123456789 | 4567890123456789 |              123 |  4...
  4567890123456789 |               123 |              123 |               456 | 4567890123456789 |              123 |   ...
- 4567890123456789 |  4567890123456789 | 4567890123456789 | -4567890123456789 | 4567890123456789 | 4567890123456789 | -4...
- 4567890123456789 |  4567890123456789 | 4567890123456789 |  4567890123456789 | 4567890123456789 | 4567890123456789 |  4...
+ 4567890123456789 |               123 |              123 |  4567890123456789 | 4567890123456789 |              123 |  4...
  4567890123456789 |  4567890123456789 | 4567890123456789 |               123 | 4567890123456789 | 4567890123456789 |   ...
+              123 |  4567890123456789 | 4567890123456789 |               123 |              123 | 4567890123456789 |   ...
+ 4567890123456789 |  4567890123456789 | 4567890123456789 |  4567890123456789 | 4567890123456789 | 4567890123456789 |  4...
+              123 |  4567890123456789 | 4567890123456789 |  4567890123456789 |              123 | 4567890123456789 |  4...
...
regress
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/join_hash.out /tmp/cirrus-ci-build/build/testrun/recovery/027_st...
--- /tmp/cirrus-ci-build/src/test/regress/expected/join_hash.out	2025-07-05 04:19:32.276460567 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/join_hash.out	2025-07-05 04:23:08.323364...
@@ -1137,18 +1137,21 @@
 int8_tbl i8,
 lateral (select t1.fivethous, i4.f1 from tenk1 t1 join int4_tbl i4
          on t1.fivethous = i4.f1+i8.q2 order by 1,2) ss;
-                        QUERY PLAN                         
------------------------------------------------------------
+                           QUERY PLAN                            
+-----------------------------------------------------------------
  Nested Loop
    ->  Seq Scan on int8_tbl i8
-   ->  Sort
-         Sort Key: t1.fivethous, i4.f1
-         ->  Hash Join
-               Hash Cond: (t1.fivethous = (i4.f1 + i8.q2))
-               ->  Seq Scan on tenk1 t1
-               ->  Hash
-                     ->  Seq Scan on int4_tbl i4
...
regress
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/join_hash.out /tmp/cirrus-ci-build/build/testrun/regress/regress...
--- /tmp/cirrus-ci-build/src/test/regress/expected/join_hash.out	2025-07-05 04:19:32.276460567 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/join_hash.out	2025-07-05 04:21:55.294666000 +0000
@@ -1137,18 +1137,21 @@
 int8_tbl i8,
 lateral (select t1.fivethous, i4.f1 from tenk1 t1 join int4_tbl i4
          on t1.fivethous = i4.f1+i8.q2 order by 1,2) ss;
-                        QUERY PLAN                         
------------------------------------------------------------
+                           QUERY PLAN                            
+-----------------------------------------------------------------
  Nested Loop
    ->  Seq Scan on int8_tbl i8
-   ->  Sort
-         Sort Key: t1.fivethous, i4.f1
-         ->  Hash Join
-               Hash Cond: (t1.fivethous = (i4.f1 + i8.q2))
-               ->  Seq Scan on tenk1 t1
-               ->  Hash
-                     ->  Seq Scan on int4_tbl i4
...
Linux - Debian Bookworm - Autoconf
regress
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/join.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/resul...
--- /tmp/cirrus-ci-build/src/test/regress/expected/join.out	2025-07-05 04:19:29.807804914 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/join.out	2025-07-05 04:26:28.438594016 +0000
@@ -3683,12 +3683,12 @@
 -----------------------------------------------------------
  Sort
    Sort Key: t1.q1, t1.q2
-   ->  Hash Left Join
-         Hash Cond: (t1.q2 = t2.q1)
+   ->  Hash Right Join
+         Hash Cond: (t2.q1 = t1.q2)
          Filter: (1 = (SubPlan 1))
-         ->  Seq Scan on int8_tbl t1
+         ->  Seq Scan on int8_tbl t2
          ->  Hash
-               ->  Seq Scan on int8_tbl t2
+               ->  Seq Scan on int8_tbl t1
          SubPlan 1
            ->  Limit
                  ->  Result
...
regress
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/join.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check/result...
--- /tmp/cirrus-ci-build/src/test/regress/expected/join.out	2025-07-05 04:19:29.807804914 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/join.out	2025-07-05 04:28:08.166600747 +0000
@@ -8186,15 +8186,15 @@
   lateral (values(x.q1,y.q1,y.q2)) v(xq1,yq1,yq2);
         q1        |        q2         |        q1        |        q2         |       xq1        |       yq1        |   ...
 ------------------+-------------------+------------------+-------------------+------------------+------------------+---...
-              123 |               456 |                  |                   |              123 |                  |   ...
-              123 |  4567890123456789 | 4567890123456789 | -4567890123456789 |              123 | 4567890123456789 | -4...
-              123 |  4567890123456789 | 4567890123456789 |  4567890123456789 |              123 | 4567890123456789 |  4...
-              123 |  4567890123456789 | 4567890123456789 |               123 |              123 | 4567890123456789 |   ...
- 4567890123456789 |               123 |              123 |  4567890123456789 | 4567890123456789 |              123 |  4...
  4567890123456789 |               123 |              123 |               456 | 4567890123456789 |              123 |   ...
- 4567890123456789 |  4567890123456789 | 4567890123456789 | -4567890123456789 | 4567890123456789 | 4567890123456789 | -4...
- 4567890123456789 |  4567890123456789 | 4567890123456789 |  4567890123456789 | 4567890123456789 | 4567890123456789 |  4...
+ 4567890123456789 |               123 |              123 |  4567890123456789 | 4567890123456789 |              123 |  4...
  4567890123456789 |  4567890123456789 | 4567890123456789 |               123 | 4567890123456789 | 4567890123456789 |   ...
+              123 |  4567890123456789 | 4567890123456789 |               123 |              123 | 4567890123456789 |   ...
+ 4567890123456789 |  4567890123456789 | 4567890123456789 |  4567890123456789 | 4567890123456789 | 4567890123456789 |  4...
+              123 |  4567890123456789 | 4567890123456789 |  4567890123456789 |              123 | 4567890123456789 |  4...
...
regress
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/join.out /tmp/cirrus-ci-build/src/test/regress/results/join.out
--- /tmp/cirrus-ci-build/src/test/regress/expected/join.out	2025-07-05 04:19:29.807804914 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/join.out	2025-07-05 04:22:57.354696925 +0000
@@ -6012,22 +6012,26 @@
     on t1.q2 = t2.q2
   left join onek t4
     on t2.q2 < t3.unique2;
-                   QUERY PLAN                    
--------------------------------------------------
+                        QUERY PLAN                         
+-----------------------------------------------------------
  Nested Loop Left Join
    Join Filter: (t2.q2 < t3.unique2)
    ->  Nested Loop Left Join
-         Join Filter: (t2.q1 > t3.unique1)
          ->  Hash Left Join
                Hash Cond: (t1.q2 = t2.q2)
                ->  Seq Scan on int8_tbl t1
                ->  Hash
                      ->  Seq Scan on int8_tbl t2
...
FreeBSD - Meson
regress
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/aggregates.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002...
--- /tmp/cirrus-ci-build/src/test/regress/expected/aggregates.out	2025-07-05 04:19:29.267483000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/aggregates.out	2025-07-05 04:21:29.9744340...
@@ -3612,8 +3612,8 @@
 ) AS sub
 GROUP BY c1
 ORDER BY c1;
-                                 QUERY PLAN                                  
------------------------------------------------------------------------------
+                                                  QUERY PLAN                                                   
+---------------------------------------------------------------------------------------------------------------
  GroupAggregate
    Group Key: sub.c1
    ->  Sort
@@ -3622,7 +3622,7 @@
                ->  HashAggregate
                      Group Key: test_groupagg.c1, test_groupagg.c2
                      ->  Seq Scan on test_groupagg
- Settings: max_parallel_workers = '0', max_parallel_workers_per_gather = '0'
+ Settings: debug_parallel_query = 'regress', max_parallel_workers = '0', max_parallel_workers_per_gather = '0'
...
regress
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/aggregates.out /tmp/cirrus-ci-build/build/testrun/recovery/027_s...
--- /tmp/cirrus-ci-build/src/test/regress/expected/aggregates.out	2025-07-05 04:19:29.267483000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/aggregates.out	2025-07-05 04:22:22.82318...
@@ -3612,8 +3612,8 @@
 ) AS sub
 GROUP BY c1
 ORDER BY c1;
-                                 QUERY PLAN                                  
------------------------------------------------------------------------------
+                                                  QUERY PLAN                                                   
+---------------------------------------------------------------------------------------------------------------
  GroupAggregate
    Group Key: sub.c1
    ->  Sort
@@ -3622,7 +3622,7 @@
                ->  HashAggregate
                      Group Key: test_groupagg.c1, test_groupagg.c2
                      ->  Seq Scan on test_groupagg
- Settings: max_parallel_workers = '0', max_parallel_workers_per_gather = '0'
+ Settings: debug_parallel_query = 'regress', max_parallel_workers = '0', max_parallel_workers_per_gather = '0'
...
regress
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/aggregates.out /tmp/cirrus-ci-build/build/testrun/regress/regres...
--- /tmp/cirrus-ci-build/src/test/regress/expected/aggregates.out	2025-07-05 04:19:29.267483000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/aggregates.out	2025-07-05 04:21:18.419576000 +0000
@@ -3612,8 +3612,8 @@
 ) AS sub
 GROUP BY c1
 ORDER BY c1;
-                                 QUERY PLAN                                  
------------------------------------------------------------------------------
+                                                  QUERY PLAN                                                   
+---------------------------------------------------------------------------------------------------------------
  GroupAggregate
    Group Key: sub.c1
    ->  Sort
@@ -3622,7 +3622,7 @@
                ->  HashAggregate
                      Group Key: test_groupagg.c1, test_groupagg.c2
                      ->  Seq Scan on test_groupagg
- Settings: max_parallel_workers = '0', max_parallel_workers_per_gather = '0'
+ Settings: debug_parallel_query = 'regress', max_parallel_workers = '0', max_parallel_workers_per_gather = '0'
...
53/5881 array_random
Linux - Debian Bookworm - Meson
regress
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/arrays.out /tmp/cirrus-ci-build/build-32/testrun/pg_upgrade/002_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/arrays.out	2025-07-05 04:16:39.675196063 +0000
+++ /tmp/cirrus-ci-build/build-32/testrun/pg_upgrade/002_pg_upgrade/data/results/arrays.out	2025-07-05 04:27:31.14627024...
@@ -3004,11 +3004,12 @@
 
 --array_random error case
 SELECT array_random(1, 10, '{134217728}');
-ERROR:  array size exceeds the maximum allowed (134217727)
+ERROR:  out of memory
+DETAIL:  Failed on request of size 12 in memory context "printtup".
 SELECT array_random(2, 1, '{2}'::int[]);
 ERROR:  lower bound must be less than or equal to upper bound
 SELECT array_random(2, 1, '{-1}'::int[]);
-ERROR:  array size exceeds the maximum allowed (134217727)
+ERROR:  array size exceeds the maximum allowed (268435455)
 SELECT array_random(NULL, 1, NULL);
 ERROR:  dimension array cannot be null
 SELECT array_random(1, 2, '{NULL}'::int[]);
regress
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/arrays.out /tmp/cirrus-ci-build/build-32/testrun/recovery/027_st...
--- /tmp/cirrus-ci-build/src/test/regress/expected/arrays.out	2025-07-05 04:16:39.675196063 +0000
+++ /tmp/cirrus-ci-build/build-32/testrun/recovery/027_stream_regress/data/results/arrays.out	2025-07-05 04:28:58.626210...
@@ -3004,11 +3004,12 @@
 
 --array_random error case
 SELECT array_random(1, 10, '{134217728}');
-ERROR:  array size exceeds the maximum allowed (134217727)
+ERROR:  out of memory
+DETAIL:  Failed on request of size 12 in memory context "printtup".
 SELECT array_random(2, 1, '{2}'::int[]);
 ERROR:  lower bound must be less than or equal to upper bound
 SELECT array_random(2, 1, '{-1}'::int[]);
-ERROR:  array size exceeds the maximum allowed (134217727)
+ERROR:  array size exceeds the maximum allowed (268435455)
 SELECT array_random(NULL, 1, NULL);
 ERROR:  dimension array cannot be null
 SELECT array_random(1, 2, '{NULL}'::int[]);
regress
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/arrays.out /tmp/cirrus-ci-build/build-32/testrun/regress/regress...
--- /tmp/cirrus-ci-build/src/test/regress/expected/arrays.out	2025-07-05 04:16:39.675196063 +0000
+++ /tmp/cirrus-ci-build/build-32/testrun/regress/regress/results/arrays.out	2025-07-05 04:27:27.682272868 +0000
@@ -3004,11 +3004,12 @@
 
 --array_random error case
 SELECT array_random(1, 10, '{134217728}');
-ERROR:  array size exceeds the maximum allowed (134217727)
+ERROR:  out of memory
+DETAIL:  Failed on request of size 12 in memory context "printtup".
 SELECT array_random(2, 1, '{2}'::int[]);
 ERROR:  lower bound must be less than or equal to upper bound
 SELECT array_random(2, 1, '{-1}'::int[]);
-ERROR:  array size exceeds the maximum allowed (134217727)
+ERROR:  array size exceeds the maximum allowed (268435455)
 SELECT array_random(NULL, 1, NULL);
 ERROR:  dimension array cannot be null
 SELECT array_random(1, 2, '{NULL}'::int[]);
53/5751 Disable parallel query by default
Windows - Server 2019, VS 2019 - Meson & ninja
regress
diff --strip-trailing-cr -U3 C:/cirrus/src/test/isolation/expected/deadlock-parallel.out C:/cirrus/build/testrun/isolati...
--- C:/cirrus/src/test/isolation/expected/deadlock-parallel.out	2025-07-05 03:15:39.712786800 +0000
+++ C:/cirrus/build/testrun/isolation/isolation/results/deadlock-parallel.out	2025-07-05 03:18:33.833292600 +0000
@@ -46,6 +46,7 @@
         1
 (1 row)
 
+step e1c: COMMIT;
 step d2a1: <... completed>
   sum
 -----
@@ -57,7 +58,6 @@
          1
 (1 row)
 
-step e1c: COMMIT;
 step d2c: COMMIT;
 step e2l: <... completed>
 lock_excl
regress
diff --strip-trailing-cr -U3 C:/cirrus/contrib/pg_overexplain/expected/pg_overexplain.out C:/cirrus/build/testrun/pg_ove...
--- C:/cirrus/contrib/pg_overexplain/expected/pg_overexplain.out	2025-07-05 03:15:36.226166200 +0000
+++ C:/cirrus/build/testrun/pg_overexplain/regress/results/pg_overexplain.out	2025-07-05 03:23:04.615093900 +0000
@@ -91,26 +91,26 @@
  GroupAggregate
    Group Key: vegetables.genus
    Disabled Nodes: 0
-   Parallel Safe: true
+   Parallel Safe: false
    Plan Node ID: 0
    ->  Sort
          Sort Key: vegetables.genus, vegetables.name
          Disabled Nodes: 0
-         Parallel Safe: true
+         Parallel Safe: false
          Plan Node ID: 1
          ->  Append
                Disabled Nodes: 0
-               Parallel Safe: true
+               Parallel Safe: false
...
regress
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/select_parallel.out C:/cirrus/build/testrun/pg_upgrade/...
--- C:/cirrus/src/test/regress/expected/select_parallel.out	2025-07-05 03:15:40.350475400 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/select_parallel.out	2025-07-05 03:19:25.638475900 +00...
@@ -1390,7 +1390,6 @@
 select set_role_and_error(0);
 ERROR:  division by zero
 CONTEXT:  SQL function "set_role_and_error" statement 1
-parallel worker
 reset debug_parallel_query;
 drop function set_and_report_role();
 drop function set_role_and_error(int);
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/plpgsql.out C:/cirrus/build/testrun/pg_upgrade/002_pg_u...
--- C:/cirrus/src/test/regress/expected/plpgsql.out	2025-07-05 03:15:40.322816800 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/plpgsql.out	2025-07-05 03:19:44.212704800 +0000
@@ -4111,15 +4111,11 @@
 $$ language plpgsql parallel safe;
 set debug_parallel_query to on;
 explain (verbose, costs off) select error_trap_test();
-            QUERY PLAN             
------------------------------------
...
regress
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/select_parallel.out C:/cirrus/build/testrun/recovery/02...
--- C:/cirrus/src/test/regress/expected/select_parallel.out	2025-07-05 03:15:40.350475400 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/select_parallel.out	2025-07-05 03:22:03.500831200 +...
@@ -1390,7 +1390,6 @@
 select set_role_and_error(0);
 ERROR:  division by zero
 CONTEXT:  SQL function "set_role_and_error" statement 1
-parallel worker
 reset debug_parallel_query;
 drop function set_and_report_role();
 drop function set_role_and_error(int);
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/plpgsql.out C:/cirrus/build/testrun/recovery/027_stream...
--- C:/cirrus/src/test/regress/expected/plpgsql.out	2025-07-05 03:15:40.322816800 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/plpgsql.out	2025-07-05 03:22:22.126754500 +0000
@@ -4111,15 +4111,11 @@
 $$ language plpgsql parallel safe;
 set debug_parallel_query to on;
 explain (verbose, costs off) select error_trap_test();
-            QUERY PLAN             
------------------------------------
...
regress
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/select_parallel.out C:/cirrus/build/testrun/regress/reg...
--- C:/cirrus/src/test/regress/expected/select_parallel.out	2025-07-05 03:15:40.350475400 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/select_parallel.out	2025-07-05 03:19:23.488102300 +0000
@@ -1390,7 +1390,6 @@
 select set_role_and_error(0);
 ERROR:  division by zero
 CONTEXT:  SQL function "set_role_and_error" statement 1
-parallel worker
 reset debug_parallel_query;
 drop function set_and_report_role();
 drop function set_role_and_error(int);
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/plpgsql.out C:/cirrus/build/testrun/regress/regress/res...
--- C:/cirrus/src/test/regress/expected/plpgsql.out	2025-07-05 03:15:40.322816800 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/plpgsql.out	2025-07-05 03:19:41.399214100 +0000
@@ -4111,15 +4111,11 @@
 $$ language plpgsql parallel safe;
 set debug_parallel_query to on;
 explain (verbose, costs off) select error_trap_test();
-            QUERY PLAN             
------------------------------------
...
macOS - Sonoma - Meson
regress
diff -U3 /Users/admin/pgsql/src/test/isolation/expected/deadlock-parallel.out /Users/admin/pgsql/build/testrun/isolation...
--- /Users/admin/pgsql/src/test/isolation/expected/deadlock-parallel.out	2025-07-05 03:13:12
+++ /Users/admin/pgsql/build/testrun/isolation/isolation/results/deadlock-parallel.out	2025-07-05 03:14:45
@@ -46,6 +46,7 @@
         1
 (1 row)
 
+step e1c: COMMIT;
 step d2a1: <... completed>
   sum
 -----
@@ -57,7 +58,6 @@
          1
 (1 row)
 
-step e1c: COMMIT;
 step d2c: COMMIT;
 step e2l: <... completed>
 lock_excl
regress
diff -U3 /Users/admin/pgsql/contrib/pg_overexplain/expected/pg_overexplain.out /Users/admin/pgsql/build/testrun/pg_overe...
--- /Users/admin/pgsql/contrib/pg_overexplain/expected/pg_overexplain.out	2025-07-05 03:13:10
+++ /Users/admin/pgsql/build/testrun/pg_overexplain/regress/results/pg_overexplain.out	2025-07-05 03:17:45
@@ -91,26 +91,26 @@
  GroupAggregate
    Group Key: vegetables.genus
    Disabled Nodes: 0
-   Parallel Safe: true
+   Parallel Safe: false
    Plan Node ID: 0
    ->  Sort
          Sort Key: vegetables.genus, vegetables.name
          Disabled Nodes: 0
-         Parallel Safe: true
+         Parallel Safe: false
          Plan Node ID: 1
          ->  Append
                Disabled Nodes: 0
-               Parallel Safe: true
+               Parallel Safe: false
...
regress
diff -U3 /Users/admin/pgsql/src/test/regress/expected/select_parallel.out /Users/admin/pgsql/build/testrun/pg_upgrade/00...
--- /Users/admin/pgsql/src/test/regress/expected/select_parallel.out	2025-07-05 03:13:12
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/select_parallel.out	2025-07-05 03:15:15
@@ -1390,7 +1390,6 @@
 select set_role_and_error(0);
 ERROR:  division by zero
 CONTEXT:  SQL function "set_role_and_error" statement 1
-parallel worker
 reset debug_parallel_query;
 drop function set_and_report_role();
 drop function set_role_and_error(int);
diff -U3 /Users/admin/pgsql/src/test/regress/expected/plpgsql.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upg...
--- /Users/admin/pgsql/src/test/regress/expected/plpgsql.out	2025-07-05 03:13:12
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/plpgsql.out	2025-07-05 03:15:29
@@ -4111,15 +4111,11 @@
 $$ language plpgsql parallel safe;
 set debug_parallel_query to on;
 explain (verbose, costs off) select error_trap_test();
-            QUERY PLAN             
------------------------------------
...
regress
diff -U3 /Users/admin/pgsql/src/test/regress/expected/select_parallel.out /Users/admin/pgsql/build/testrun/recovery/027_...
--- /Users/admin/pgsql/src/test/regress/expected/select_parallel.out	2025-07-05 03:13:12
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/select_parallel.out	2025-07-05 03:17:27
@@ -1390,7 +1390,6 @@
 select set_role_and_error(0);
 ERROR:  division by zero
 CONTEXT:  SQL function "set_role_and_error" statement 1
-parallel worker
 reset debug_parallel_query;
 drop function set_and_report_role();
 drop function set_role_and_error(int);
diff -U3 /Users/admin/pgsql/src/test/regress/expected/plpgsql.out /Users/admin/pgsql/build/testrun/recovery/027_stream_r...
--- /Users/admin/pgsql/src/test/regress/expected/plpgsql.out	2025-07-05 03:13:12
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/plpgsql.out	2025-07-05 03:17:46
@@ -4111,15 +4111,11 @@
 $$ language plpgsql parallel safe;
 set debug_parallel_query to on;
 explain (verbose, costs off) select error_trap_test();
-            QUERY PLAN             
------------------------------------
...
regress
diff -U3 /Users/admin/pgsql/src/test/regress/expected/select_parallel.out /Users/admin/pgsql/build/testrun/regress/regre...
--- /Users/admin/pgsql/src/test/regress/expected/select_parallel.out	2025-07-05 03:13:12
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/select_parallel.out	2025-07-05 03:15:20
@@ -1390,7 +1390,6 @@
 select set_role_and_error(0);
 ERROR:  division by zero
 CONTEXT:  SQL function "set_role_and_error" statement 1
-parallel worker
 reset debug_parallel_query;
 drop function set_and_report_role();
 drop function set_role_and_error(int);
diff -U3 /Users/admin/pgsql/src/test/regress/expected/plpgsql.out /Users/admin/pgsql/build/testrun/regress/regress/resul...
--- /Users/admin/pgsql/src/test/regress/expected/plpgsql.out	2025-07-05 03:13:12
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/plpgsql.out	2025-07-05 03:15:35
@@ -4111,15 +4111,11 @@
 $$ language plpgsql parallel safe;
 set debug_parallel_query to on;
 explain (verbose, costs off) select error_trap_test();
-            QUERY PLAN             
------------------------------------
...
Linux - Debian Bookworm - Meson
regress
diff -U3 /tmp/cirrus-ci-build/src/test/isolation/expected/deadlock-parallel.out /tmp/cirrus-ci-build/build/testrun/isola...
--- /tmp/cirrus-ci-build/src/test/isolation/expected/deadlock-parallel.out	2025-07-05 03:15:40.542340600 +0000
+++ /tmp/cirrus-ci-build/build/testrun/isolation/isolation/results/deadlock-parallel.out	2025-07-05 03:17:23.425708478 +...
@@ -46,6 +46,7 @@
         1
 (1 row)
 
+step e1c: COMMIT;
 step d2a1: <... completed>
   sum
 -----
@@ -57,7 +58,6 @@
          1
 (1 row)
 
-step e1c: COMMIT;
 step d2c: COMMIT;
 step e2l: <... completed>
 lock_excl
regress
diff -U3 /tmp/cirrus-ci-build/contrib/pg_overexplain/expected/pg_overexplain.out /tmp/cirrus-ci-build/build/testrun/pg_o...
--- /tmp/cirrus-ci-build/contrib/pg_overexplain/expected/pg_overexplain.out	2025-07-05 03:15:38.802340563 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_overexplain/regress/results/pg_overexplain.out	2025-07-05 03:19:26.933629842 +...
@@ -91,26 +91,26 @@
  GroupAggregate
    Group Key: vegetables.genus
    Disabled Nodes: 0
-   Parallel Safe: true
+   Parallel Safe: false
    Plan Node ID: 0
    ->  Sort
          Sort Key: vegetables.genus, vegetables.name
          Disabled Nodes: 0
-         Parallel Safe: true
+         Parallel Safe: false
          Plan Node ID: 1
          ->  Append
                Disabled Nodes: 0
-               Parallel Safe: true
+               Parallel Safe: false
...
regress
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/select_parallel.out /tmp/cirrus-ci-build/build/testrun/pg_upgrad...
--- /tmp/cirrus-ci-build/src/test/regress/expected/select_parallel.out	2025-07-05 03:15:40.774340605 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/select_parallel.out	2025-07-05 03:17:53.87...
@@ -1390,7 +1390,6 @@
 select set_role_and_error(0);
 ERROR:  division by zero
 CONTEXT:  SQL function "set_role_and_error" statement 1
-parallel worker
 reset debug_parallel_query;
 drop function set_and_report_role();
 drop function set_role_and_error(int);
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/plpgsql.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg...
--- /tmp/cirrus-ci-build/src/test/regress/expected/plpgsql.out	2025-07-05 03:15:40.758340605 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/plpgsql.out	2025-07-05 03:18:07.921674328 ...
@@ -4111,15 +4111,11 @@
 $$ language plpgsql parallel safe;
 set debug_parallel_query to on;
 explain (verbose, costs off) select error_trap_test();
-            QUERY PLAN             
------------------------------------
...
regress
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/select_parallel.out /tmp/cirrus-ci-build/build/testrun/recovery/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/select_parallel.out	2025-07-05 03:15:40.774340605 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/select_parallel.out	2025-07-05 03:19:07....
@@ -1390,7 +1390,6 @@
 select set_role_and_error(0);
 ERROR:  division by zero
 CONTEXT:  SQL function "set_role_and_error" statement 1
-parallel worker
 reset debug_parallel_query;
 drop function set_and_report_role();
 drop function set_role_and_error(int);
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/plpgsql.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stre...
--- /tmp/cirrus-ci-build/src/test/regress/expected/plpgsql.out	2025-07-05 03:15:40.758340605 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/plpgsql.out	2025-07-05 03:19:20.92563764...
@@ -4111,15 +4111,11 @@
 $$ language plpgsql parallel safe;
 set debug_parallel_query to on;
 explain (verbose, costs off) select error_trap_test();
-            QUERY PLAN             
------------------------------------
...
regress
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/select_parallel.out /tmp/cirrus-ci-build/build/testrun/regress/r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/select_parallel.out	2025-07-05 03:15:40.774340605 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/select_parallel.out	2025-07-05 03:17:50.617683947 +0000
@@ -1390,7 +1390,6 @@
 select set_role_and_error(0);
 ERROR:  division by zero
 CONTEXT:  SQL function "set_role_and_error" statement 1
-parallel worker
 reset debug_parallel_query;
 drop function set_and_report_role();
 drop function set_role_and_error(int);
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/plpgsql.out /tmp/cirrus-ci-build/build/testrun/regress/regress/r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/plpgsql.out	2025-07-05 03:15:40.758340605 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/plpgsql.out	2025-07-05 03:18:04.965675766 +0000
@@ -4111,15 +4111,11 @@
 $$ language plpgsql parallel safe;
 set debug_parallel_query to on;
 explain (verbose, costs off) select error_trap_test();
-            QUERY PLAN             
------------------------------------
...
Linux - Debian Bookworm - Autoconf
regress
diff -U3 /tmp/cirrus-ci-build/contrib/pg_overexplain/expected/pg_overexplain.out /tmp/cirrus-ci-build/contrib/pg_overexp...
--- /tmp/cirrus-ci-build/contrib/pg_overexplain/expected/pg_overexplain.out	2025-07-05 03:15:38.857620279 +0000
+++ /tmp/cirrus-ci-build/contrib/pg_overexplain/results/pg_overexplain.out	2025-07-05 03:20:14.002622707 +0000
@@ -91,26 +91,26 @@
  GroupAggregate
    Group Key: vegetables.genus
    Disabled Nodes: 0
-   Parallel Safe: true
+   Parallel Safe: false
    Plan Node ID: 0
    ->  Sort
          Sort Key: vegetables.genus, vegetables.name
          Disabled Nodes: 0
-         Parallel Safe: true
+         Parallel Safe: false
          Plan Node ID: 1
          ->  Append
                Disabled Nodes: 0
-               Parallel Safe: true
+               Parallel Safe: false
...
regress
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/select_parallel.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/select_parallel.out	2025-07-05 03:15:40.773434735 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/select_parallel.out	2025-07-05 03:20:38.354599147 +0000
@@ -1390,7 +1390,6 @@
 select set_role_and_error(0);
 ERROR:  division by zero
 CONTEXT:  SQL function "set_role_and_error" statement 1
-parallel worker
 reset debug_parallel_query;
 drop function set_and_report_role();
 drop function set_role_and_error(int);
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/plpgsql.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/re...
--- /tmp/cirrus-ci-build/src/test/regress/expected/plpgsql.out	2025-07-05 03:15:40.757526860 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/plpgsql.out	2025-07-05 03:20:51.798587106 +0000
@@ -4111,15 +4111,11 @@
 $$ language plpgsql parallel safe;
 set debug_parallel_query to on;
 explain (verbose, costs off) select error_trap_test();
-            QUERY PLAN             
------------------------------------
...
regress
diff -U3 /tmp/cirrus-ci-build/src/test/isolation/expected/deadlock-parallel.out /tmp/cirrus-ci-build/src/test/isolation/...
--- /tmp/cirrus-ci-build/src/test/isolation/expected/deadlock-parallel.out	2025-07-05 03:15:40.538793580 +0000
+++ /tmp/cirrus-ci-build/src/test/isolation/output_iso/results/deadlock-parallel.out	2025-07-05 03:17:43.730731827 +0000
@@ -46,6 +46,7 @@
         1
 (1 row)
 
+step e1c: COMMIT;
 step d2a1: <... completed>
   sum
 -----
@@ -57,7 +58,6 @@
          1
 (1 row)
 
-step e1c: COMMIT;
 step d2c: COMMIT;
 step e2l: <... completed>
 lock_excl
regress
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/select_parallel.out /tmp/cirrus-ci-build/src/test/regress/result...
--- /tmp/cirrus-ci-build/src/test/regress/expected/select_parallel.out	2025-07-05 03:15:40.773434735 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/select_parallel.out	2025-07-05 03:18:30.050720555 +0000
@@ -1390,7 +1390,6 @@
 select set_role_and_error(0);
 ERROR:  division by zero
 CONTEXT:  SQL function "set_role_and_error" statement 1
-parallel worker
 reset debug_parallel_query;
 drop function set_and_report_role();
 drop function set_role_and_error(int);
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/plpgsql.out /tmp/cirrus-ci-build/src/test/regress/results/plpgsq...
--- /tmp/cirrus-ci-build/src/test/regress/expected/plpgsql.out	2025-07-05 03:15:40.757526860 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/plpgsql.out	2025-07-05 03:18:56.474707793 +0000
@@ -4111,15 +4111,11 @@
 $$ language plpgsql parallel safe;
 set debug_parallel_query to on;
 explain (verbose, costs off) select error_trap_test();
-            QUERY PLAN             
------------------------------------
...
FreeBSD - Meson
regress
diff -U3 /tmp/cirrus-ci-build/src/test/isolation/expected/deadlock-parallel.out /tmp/cirrus-ci-build/build/testrun/isola...
--- /tmp/cirrus-ci-build/src/test/isolation/expected/deadlock-parallel.out	2025-07-05 03:15:36.042028000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/isolation/isolation/results/deadlock-parallel.out	2025-07-05 03:16:39.608556000 +...
@@ -46,6 +46,7 @@
         1
 (1 row)
 
+step e1c: COMMIT;
 step d2a1: <... completed>
   sum
 -----
@@ -57,7 +58,6 @@
          1
 (1 row)
 
-step e1c: COMMIT;
 step d2c: COMMIT;
 step e2l: <... completed>
 lock_excl
regress
diff -U3 /tmp/cirrus-ci-build/contrib/pg_overexplain/expected/pg_overexplain.out /tmp/cirrus-ci-build/build/testrun/pg_o...
--- /tmp/cirrus-ci-build/contrib/pg_overexplain/expected/pg_overexplain.out	2025-07-05 03:15:34.623922000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_overexplain/regress/results/pg_overexplain.out	2025-07-05 03:18:01.553304000 +...
@@ -91,26 +91,26 @@
  GroupAggregate
    Group Key: vegetables.genus
    Disabled Nodes: 0
-   Parallel Safe: true
+   Parallel Safe: false
    Plan Node ID: 0
    ->  Sort
          Sort Key: vegetables.genus, vegetables.name
          Disabled Nodes: 0
-         Parallel Safe: true
+         Parallel Safe: false
          Plan Node ID: 1
          ->  Append
                Disabled Nodes: 0
-               Parallel Safe: true
+               Parallel Safe: false
...
regress
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/select_parallel.out /tmp/cirrus-ci-build/build/testrun/pg_upgrad...
--- /tmp/cirrus-ci-build/src/test/regress/expected/select_parallel.out	2025-07-05 03:15:36.219998000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/select_parallel.out	2025-07-05 03:16:59.20...
@@ -1390,7 +1390,6 @@
 select set_role_and_error(0);
 ERROR:  division by zero
 CONTEXT:  SQL function "set_role_and_error" statement 1
-parallel worker
 reset debug_parallel_query;
 drop function set_and_report_role();
 drop function set_role_and_error(int);
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/plpgsql.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg...
--- /tmp/cirrus-ci-build/src/test/regress/expected/plpgsql.out	2025-07-05 03:15:36.206602000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/plpgsql.out	2025-07-05 03:17:14.461556000 ...
@@ -4111,15 +4111,11 @@
 $$ language plpgsql parallel safe;
 set debug_parallel_query to on;
 explain (verbose, costs off) select error_trap_test();
-            QUERY PLAN             
------------------------------------
...
regress
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/select_parallel.out /tmp/cirrus-ci-build/build/testrun/recovery/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/select_parallel.out	2025-07-05 03:15:36.219998000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/select_parallel.out	2025-07-05 03:18:10....
@@ -1390,7 +1390,6 @@
 select set_role_and_error(0);
 ERROR:  division by zero
 CONTEXT:  SQL function "set_role_and_error" statement 1
-parallel worker
 reset debug_parallel_query;
 drop function set_and_report_role();
 drop function set_role_and_error(int);
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/plpgsql.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stre...
--- /tmp/cirrus-ci-build/src/test/regress/expected/plpgsql.out	2025-07-05 03:15:36.206602000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/plpgsql.out	2025-07-05 03:18:31.25237400...
@@ -4111,15 +4111,11 @@
 $$ language plpgsql parallel safe;
 set debug_parallel_query to on;
 explain (verbose, costs off) select error_trap_test();
-            QUERY PLAN             
------------------------------------
...
regress
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/select_parallel.out /tmp/cirrus-ci-build/build/testrun/regress/r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/select_parallel.out	2025-07-05 03:15:36.219998000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/select_parallel.out	2025-07-05 03:16:59.700097000 +0000
@@ -1390,7 +1390,6 @@
 select set_role_and_error(0);
 ERROR:  division by zero
 CONTEXT:  SQL function "set_role_and_error" statement 1
-parallel worker
 reset debug_parallel_query;
 drop function set_and_report_role();
 drop function set_role_and_error(int);
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/plpgsql.out /tmp/cirrus-ci-build/build/testrun/regress/regress/r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/plpgsql.out	2025-07-05 03:15:36.206602000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/plpgsql.out	2025-07-05 03:17:15.904237000 +0000
@@ -4111,15 +4111,11 @@
 $$ language plpgsql parallel safe;
 set debug_parallel_query to on;
 explain (verbose, costs off) select error_trap_test();
-            QUERY PLAN             
------------------------------------
...
53/5669 Use CLOCK_MONOTONIC_COARSE for instr_time for explain analyze
Linux - Debian Bookworm - Meson
regress
diff -U3 /tmp/cirrus-ci-build/contrib/pg_stat_statements/expected/entry_timestamp.out /tmp/cirrus-ci-build/build/testrun...
--- /tmp/cirrus-ci-build/contrib/pg_stat_statements/expected/entry_timestamp.out	2025-07-04 23:08:00.162496417 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_stat_statements/regress/results/entry_timestamp.out	2025-07-04 23:14:47.262344...
@@ -45,7 +45,7 @@
 WHERE query LIKE '%STMTTS%';
  total | minmax_plan_zero | minmax_exec_zero | minmax_stats_since_after_ref | stats_since_after_ref 
 -------+------------------+------------------+------------------------------+-----------------------
-     2 |                0 |                0 |                            0 |                     0
+     2 |                0 |                2 |                            0 |                     0
 (1 row)
 
 -- Perform single min/max reset
@@ -71,7 +71,7 @@
 WHERE query LIKE '%STMTTS%';
  total | minmax_plan_zero | minmax_exec_zero | minmax_stats_since_after_ref | stats_since_after_ref 
 -------+------------------+------------------+------------------------------+-----------------------
-     2 |                1 |                1 |                            1 |                     0
+     2 |                1 |                2 |                            1 |                     0
 (1 row)
 
...
Linux - Debian Bookworm - Autoconf
regress
diff -U3 /tmp/cirrus-ci-build/contrib/pg_stat_statements/expected/entry_timestamp.out /tmp/cirrus-ci-build/contrib/pg_st...
--- /tmp/cirrus-ci-build/contrib/pg_stat_statements/expected/entry_timestamp.out	2025-07-04 23:08:00.441678447 +0000
+++ /tmp/cirrus-ci-build/contrib/pg_stat_statements/results/entry_timestamp.out	2025-07-04 23:14:07.800829009 +0000
@@ -45,7 +45,7 @@
 WHERE query LIKE '%STMTTS%';
  total | minmax_plan_zero | minmax_exec_zero | minmax_stats_since_after_ref | stats_since_after_ref 
 -------+------------------+------------------+------------------------------+-----------------------
-     2 |                0 |                0 |                            0 |                     0
+     2 |                0 |                2 |                            0 |                     0
 (1 row)
 
 -- Perform single min/max reset
@@ -71,7 +71,7 @@
 WHERE query LIKE '%STMTTS%';
  total | minmax_plan_zero | minmax_exec_zero | minmax_stats_since_after_ref | stats_since_after_ref 
 -------+------------------+------------------+------------------------------+-----------------------
-     2 |                1 |                1 |                            1 |                     0
+     2 |                1 |                2 |                            1 |                     0
 (1 row)
 
...
FreeBSD - Meson
regress
diff -U3 /tmp/cirrus-ci-build/contrib/pg_stat_statements/expected/entry_timestamp.out /tmp/cirrus-ci-build/build/testrun...
--- /tmp/cirrus-ci-build/contrib/pg_stat_statements/expected/entry_timestamp.out	2025-07-04 23:08:02.374256000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_stat_statements/regress/results/entry_timestamp.out	2025-07-04 23:11:44.300389...
@@ -45,7 +45,7 @@
 WHERE query LIKE '%STMTTS%';
  total | minmax_plan_zero | minmax_exec_zero | minmax_stats_since_after_ref | stats_since_after_ref 
 -------+------------------+------------------+------------------------------+-----------------------
-     2 |                0 |                0 |                            0 |                     0
+     2 |                0 |                1 |                            0 |                     0
 (1 row)
 
 -- Perform single min/max reset
@@ -71,7 +71,7 @@
 WHERE query LIKE '%STMTTS%';
  total | minmax_plan_zero | minmax_exec_zero | minmax_stats_since_after_ref | stats_since_after_ref 
 -------+------------------+------------------+------------------------------+-----------------------
-     2 |                1 |                1 |                            1 |                     0
+     2 |                1 |                2 |                            1 |                     0
 (1 row)
 
...
53/5447 log_min_messages per backend type
Windows - Server 2019, VS 2019 - Meson & ninja
regress
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/guc.out C:/cirrus/build/testrun/pg_upgrade/002_pg_upgra...
--- C:/cirrus/src/test/regress/expected/guc.out	2025-07-04 22:53:55.760011400 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/guc.out	2025-07-04 22:57:52.889008000 +0000
@@ -929,35 +929,7 @@
 (1 row)
 
 SET log_min_messages TO 'checkpointer:debug2, autovacuum:debug1';  --fail
-ERROR:  invalid value for parameter "log_min_messages": "checkpointer:debug2, autovacuum:debug1"
-DETAIL:  Generic log level was not defined.
-SET log_min_messages TO 'debug1, backend:error, fatal';  -- fail
-ERROR:  invalid value for parameter "log_min_messages": "debug1, backend:error, fatal"
-DETAIL:  Generic log level was already assigned.
-SET log_min_messages TO 'backend:error, foo:fatal, archiver:debug1';  -- fail
-ERROR:  invalid value for parameter "log_min_messages": "backend:error, foo:fatal, archiver:debug1"
-DETAIL:  Unrecognized backend type: "foo".
-SET log_min_messages TO 'backend:error, checkpointer:bar, archiver:debug1';  -- fail
-ERROR:  invalid value for parameter "log_min_messages": "backend:error, checkpointer:bar, archiver:debug1"
-DETAIL:  Unrecognized log level: "bar".
-SET log_min_messages TO 'backend:error, checkpointer:debug3, fatal, archiver:debug2, autovacuum:debug1, walsender:debug...
-SHOW log_min_messages;
...
regress
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/foreign_key.out C:/cirrus/build/testrun/recovery/027_st...
--- C:/cirrus/src/test/regress/expected/foreign_key.out	2025-07-04 22:53:55.750468300 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/foreign_key.out	2025-07-04 23:00:18.556838000 +0000
@@ -2622,787 +2622,7 @@
 ALTER TABLE fk ADD FOREIGN KEY (a) REFERENCES pk;
 CREATE TABLE fk2 (b int, a int) ;
 ALTER TABLE fk2 DROP COLUMN b;
-ALTER TABLE fk ATTACH PARTITION fk2 FOR VALUES FROM (750) TO (3500);
-CREATE TABLE pk3 PARTITION OF pk FOR VALUES FROM (2000) TO (3000);
-CREATE TABLE pk4 (LIKE pk);
-ALTER TABLE pk ATTACH PARTITION pk4 FOR VALUES FROM (3000) TO (4000);
-CREATE TABLE pk5 (c int, b int, a int NOT NULL) PARTITION BY RANGE (a);
-ALTER TABLE pk5 DROP COLUMN b, DROP COLUMN c;
-CREATE TABLE pk51 PARTITION OF pk5 FOR VALUES FROM (4000) TO (4500);
-CREATE TABLE pk52 PARTITION OF pk5 FOR VALUES FROM (4500) TO (5000);
-ALTER TABLE pk ATTACH PARTITION pk5 FOR VALUES FROM (4000) TO (5000);
-CREATE TABLE fk3 PARTITION OF fk FOR VALUES FROM (3500) TO (5000);
--- these should fail: referenced value not present
-INSERT into fk VALUES (1);
-ERROR:  insert or update on table "fk1" violates foreign key constraint "fk_a_fkey"
...
regress
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/guc.out C:/cirrus/build/testrun/regress/regress/results...
--- C:/cirrus/src/test/regress/expected/guc.out	2025-07-04 22:53:55.760011400 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/guc.out	2025-07-04 22:57:53.015346500 +0000
@@ -929,35 +929,7 @@
 (1 row)
 
 SET log_min_messages TO 'checkpointer:debug2, autovacuum:debug1';  --fail
-ERROR:  invalid value for parameter "log_min_messages": "checkpointer:debug2, autovacuum:debug1"
-DETAIL:  Generic log level was not defined.
-SET log_min_messages TO 'debug1, backend:error, fatal';  -- fail
-ERROR:  invalid value for parameter "log_min_messages": "debug1, backend:error, fatal"
-DETAIL:  Generic log level was already assigned.
-SET log_min_messages TO 'backend:error, foo:fatal, archiver:debug1';  -- fail
-ERROR:  invalid value for parameter "log_min_messages": "backend:error, foo:fatal, archiver:debug1"
-DETAIL:  Unrecognized backend type: "foo".
-SET log_min_messages TO 'backend:error, checkpointer:bar, archiver:debug1';  -- fail
-ERROR:  invalid value for parameter "log_min_messages": "backend:error, checkpointer:bar, archiver:debug1"
-DETAIL:  Unrecognized log level: "bar".
-SET log_min_messages TO 'backend:error, checkpointer:debug3, fatal, archiver:debug2, autovacuum:debug1, walsender:debug...
-SHOW log_min_messages;
...
macOS - Sonoma - Meson
regress
diff -U3 /Users/admin/pgsql/src/test/regress/expected/guc.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade...
--- /Users/admin/pgsql/src/test/regress/expected/guc.out	2025-07-04 22:53:14
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/guc.out	2025-07-04 22:57:38
@@ -929,35 +929,7 @@
 (1 row)
 
 SET log_min_messages TO 'checkpointer:debug2, autovacuum:debug1';  --fail
-ERROR:  invalid value for parameter "log_min_messages": "checkpointer:debug2, autovacuum:debug1"
-DETAIL:  Generic log level was not defined.
-SET log_min_messages TO 'debug1, backend:error, fatal';  -- fail
-ERROR:  invalid value for parameter "log_min_messages": "debug1, backend:error, fatal"
-DETAIL:  Generic log level was already assigned.
-SET log_min_messages TO 'backend:error, foo:fatal, archiver:debug1';  -- fail
-ERROR:  invalid value for parameter "log_min_messages": "backend:error, foo:fatal, archiver:debug1"
-DETAIL:  Unrecognized backend type: "foo".
-SET log_min_messages TO 'backend:error, checkpointer:bar, archiver:debug1';  -- fail
-ERROR:  invalid value for parameter "log_min_messages": "backend:error, checkpointer:bar, archiver:debug1"
-DETAIL:  Unrecognized log level: "bar".
-SET log_min_messages TO 'backend:error, checkpointer:debug3, fatal, archiver:debug2, autovacuum:debug1, walsender:debug...
-SHOW log_min_messages;
...
regress
diff -U3 /Users/admin/pgsql/src/test/regress/expected/cluster.out /Users/admin/pgsql/build/testrun/recovery/027_stream_r...
--- /Users/admin/pgsql/src/test/regress/expected/cluster.out	2025-07-04 22:53:14
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/cluster.out	2025-07-04 22:59:07
@@ -435,241 +435,10 @@
 create temp table clstr_temp (col1 int primary key, col2 text);
 insert into clstr_temp values (2, 'two'), (1, 'one');
 cluster clstr_temp using clstr_temp_pkey;
-select * from clstr_temp;
- col1 | col2 
-------+------
-    1 | one
-    2 | two
-(2 rows)
-
-drop table clstr_temp;
-RESET SESSION AUTHORIZATION;
--- check clustering an empty table
-DROP TABLE clustertest;
-CREATE TABLE clustertest (f1 int PRIMARY KEY);
-CLUSTER clustertest USING clustertest_pkey;
...
regress
diff -U3 /Users/admin/pgsql/src/test/regress/expected/guc.out /Users/admin/pgsql/build/testrun/regress/regress/results/g...
--- /Users/admin/pgsql/src/test/regress/expected/guc.out	2025-07-04 22:53:14
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/guc.out	2025-07-04 22:57:38
@@ -929,35 +929,7 @@
 (1 row)
 
 SET log_min_messages TO 'checkpointer:debug2, autovacuum:debug1';  --fail
-ERROR:  invalid value for parameter "log_min_messages": "checkpointer:debug2, autovacuum:debug1"
-DETAIL:  Generic log level was not defined.
-SET log_min_messages TO 'debug1, backend:error, fatal';  -- fail
-ERROR:  invalid value for parameter "log_min_messages": "debug1, backend:error, fatal"
-DETAIL:  Generic log level was already assigned.
-SET log_min_messages TO 'backend:error, foo:fatal, archiver:debug1';  -- fail
-ERROR:  invalid value for parameter "log_min_messages": "backend:error, foo:fatal, archiver:debug1"
-DETAIL:  Unrecognized backend type: "foo".
-SET log_min_messages TO 'backend:error, checkpointer:bar, archiver:debug1';  -- fail
-ERROR:  invalid value for parameter "log_min_messages": "backend:error, checkpointer:bar, archiver:debug1"
-DETAIL:  Unrecognized log level: "bar".
-SET log_min_messages TO 'backend:error, checkpointer:debug3, fatal, archiver:debug2, autovacuum:debug1, walsender:debug...
-SHOW log_min_messages;
...
Linux - Debian Bookworm - Meson
regress
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/foreign_key.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/00...
--- /tmp/cirrus-ci-build/src/test/regress/expected/foreign_key.out	2025-07-04 22:53:51.301168673 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/foreign_key.out	2025-07-04 22:59:04.627635...
@@ -866,2543 +866,10 @@
 CREATE TABLE FKTABLE_FAIL1 ( ftest1 int, CONSTRAINT fkfail1 FOREIGN KEY (ftest2) REFERENCES PKTABLE);
 ERROR:  column "ftest2" referenced in foreign key constraint does not exist
 CREATE TABLE FKTABLE_FAIL2 ( ftest1 int, CONSTRAINT fkfail1 FOREIGN KEY (ftest1) REFERENCES PKTABLE(ptest2));
-ERROR:  column "ptest2" referenced in foreign key constraint does not exist
-CREATE TABLE FKTABLE_FAIL3 ( ftest1 int, CONSTRAINT fkfail1 FOREIGN KEY (tableoid) REFERENCES PKTABLE(someoid));
-ERROR:  system columns cannot be used in foreign keys
-CREATE TABLE FKTABLE_FAIL4 ( ftest1 oid, CONSTRAINT fkfail1 FOREIGN KEY (ftest1) REFERENCES PKTABLE(tableoid));
-ERROR:  system columns cannot be used in foreign keys
-DROP TABLE PKTABLE;
--- Test for referencing column number smaller than referenced constraint
-CREATE TABLE PKTABLE (ptest1 int, ptest2 int, UNIQUE(ptest1, ptest2));
-CREATE TABLE FKTABLE_FAIL1 (ftest1 int REFERENCES pktable(ptest1));
-ERROR:  there is no unique constraint matching given keys for referenced table "pktable"
-DROP TABLE FKTABLE_FAIL1;
-ERROR:  table "fktable_fail1" does not exist
-DROP TABLE PKTABLE;
...
regress
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/foreign_key.out /tmp/cirrus-ci-build/build/testrun/recovery/027_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/foreign_key.out	2025-07-04 22:53:51.301168673 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/foreign_key.out	2025-07-04 23:00:08.8162...
@@ -959,2450 +959,10 @@
 CREATE TABLE FKTABLE (ftest1 int, ftest2 inet, FOREIGN KEY(ftest1, ftest2) REFERENCES pktable(ptest1, ptest2));
 DROP TABLE FKTABLE;
 DROP TABLE PKTABLE;
--- Two columns, same table
--- Make sure this still works...
-CREATE TABLE PKTABLE (ptest1 int, ptest2 inet, ptest3 int, ptest4 inet, PRIMARY KEY(ptest1, ptest2), FOREIGN KEY(ptest3...
-ptest4) REFERENCES pktable(ptest1, ptest2));
-DROP TABLE PKTABLE;
--- And this,
-CREATE TABLE PKTABLE (ptest1 int, ptest2 inet, ptest3 int, ptest4 inet, PRIMARY KEY(ptest1, ptest2), FOREIGN KEY(ptest3...
-ptest4) REFERENCES pktable);
-DROP TABLE PKTABLE;
--- This shouldn't (mixed up columns)
-CREATE TABLE PKTABLE (ptest1 int, ptest2 inet, ptest3 int, ptest4 inet, PRIMARY KEY(ptest1, ptest2), FOREIGN KEY(ptest3...
-ptest4) REFERENCES pktable(ptest2, ptest1));
-ERROR:  foreign key constraint "pktable_ptest3_ptest4_fkey" cannot be implemented
...
regress
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/foreign_key.out /tmp/cirrus-ci-build/build/testrun/regress/regre...
--- /tmp/cirrus-ci-build/src/test/regress/expected/foreign_key.out	2025-07-04 22:53:51.301168673 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/foreign_key.out	2025-07-04 22:59:03.867631013 +0000
@@ -2182,1227 +2182,10 @@
 ALTER TABLE fk_partitioned_fk ALTER CONSTRAINT fk_partitioned_fk_a_b_fkey NOT ENFORCED;
 ALTER TABLE fk_partitioned_fk ATTACH PARTITION fk_partitioned_fk_2 FOR VALUES IN (1500,1502);
 \d fk_partitioned_fk_2
-        Table "public.fk_partitioned_fk_2"
- Column |  Type   | Collation | Nullable | Default 
---------+---------+-----------+----------+---------
- b      | integer |           |          | 
- a      | integer |           |          | 
-Partition of: fk_partitioned_fk FOR VALUES IN (1500, 1502)
-Foreign-key constraints:
-    TABLE "fk_partitioned_fk" CONSTRAINT "fk_partitioned_fk_a_b_fkey" FOREIGN KEY (a, b) REFERENCES fk_notpartitioned_p...
-
-ROLLBACK;
-DROP TABLE fk_partitioned_fk_2;
-CREATE TABLE fk_partitioned_fk_4 (a int, b int, FOREIGN KEY (a, b) REFERENCES fk_notpartitioned_pk(a, b) ON UPDATE CASC...
-CREATE TABLE fk_partitioned_fk_4_1 PARTITION OF fk_partitioned_fk_4 FOR VALUES FROM (1,1) TO (100,100);
...
Linux - Debian Bookworm - Autoconf
regress
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/foreign_key.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_chec...
--- /tmp/cirrus-ci-build/src/test/regress/expected/foreign_key.out	2025-07-04 22:53:51.993724183 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/foreign_key.out	2025-07-04 23:00:57.361146904 +0000
@@ -1510,1899 +1510,10 @@
 insert into pp values(12);
 insert into pp values(11);
 update pp set f1=f1+1;
-insert into cc values(13);
-update pp set f1=f1+1;
-update pp set f1=f1+1; -- fail
-ERROR:  update or delete on table "pp" violates foreign key constraint "cc_f1_fkey" on table "cc"
-DETAIL:  Key (f1)=(13) is still referenced from table "cc".
-delete from pp where f1 = 13; -- fail
-ERROR:  update or delete on table "pp" violates foreign key constraint "cc_f1_fkey" on table "cc"
-DETAIL:  Key (f1)=(13) is still referenced from table "cc".
-drop table pp, cc;
-create temp table pp (f1 int primary key);
-create temp table cc (f1 int references pp on update restrict on delete restrict);
-insert into pp values(12);
-insert into pp values(11);
...
regress
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/foreign_key.out /tmp/cirrus-ci-build/src/test/regress/results/fo...
--- /tmp/cirrus-ci-build/src/test/regress/expected/foreign_key.out	2025-07-04 22:53:51.993724183 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/foreign_key.out	2025-07-04 22:59:28.068238653 +0000
@@ -1625,1784 +1625,10 @@
 -- Test keys that "look" different but compare as equal
 --
 create table pktable2 (a float8, b float8, primary key (a, b));
-create table fktable2 (x float8, y float8, foreign key (x, y) references pktable2 (a, b) on update cascade);
-insert into pktable2 values ('-0', '-0');
-insert into fktable2 values ('-0', '-0');
-select * from pktable2;
- a  | b  
-----+----
- -0 | -0
-(1 row)
-
-select * from fktable2;
- x  | y  
-----+----
- -0 | -0
...
FreeBSD - Meson
regress
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/foreign_key.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/00...
--- /tmp/cirrus-ci-build/src/test/regress/expected/foreign_key.out	2025-07-04 22:53:52.773578000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/foreign_key.out	2025-07-04 22:57:25.963780...
@@ -841,2568 +841,10 @@
   FOREIGN KEY (tid, fk_id_del_set_default) REFERENCES PKTABLE ON DELETE SET DEFAULT (fk_id_del_set_default, fk_id_del_s...
 );
 SELECT pg_get_constraintdef(oid) FROM pg_constraint WHERE conrelid = 'fktable'::regclass::oid ORDER BY oid;
-                                                pg_get_constraintdef                                                
---------------------------------------------------------------------------------------------------------------------
- FOREIGN KEY (tid, fk_id_del_set_null) REFERENCES pktable(tid, id) ON DELETE SET NULL (fk_id_del_set_null)
- FOREIGN KEY (tid, fk_id_del_set_default) REFERENCES pktable(tid, id) ON DELETE SET DEFAULT (fk_id_del_set_default)
-(2 rows)
-
-INSERT INTO PKTABLE VALUES (1, 0), (1, 1), (1, 2);
-INSERT INTO FKTABLE VALUES
-  (1, 1, 1, NULL),
-  (1, 2, NULL, 2);
-DELETE FROM PKTABLE WHERE id = 1 OR id = 2;
-SELECT * FROM FKTABLE ORDER BY id;
- tid | id | fk_id_del_set_null | fk_id_del_set_default 
...
regress
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/foreign_key.out /tmp/cirrus-ci-build/build/testrun/recovery/027_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/foreign_key.out	2025-07-04 22:53:52.773578000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/foreign_key.out	2025-07-04 22:58:34.7827...
@@ -601,2808 +601,10 @@
 (4 rows)
 
 DROP TABLE FKTABLE;
-DROP TABLE PKTABLE;
--- set null update / set default delete
-CREATE TABLE PKTABLE ( ptest1 int, ptest2 int, ptest3 int, ptest4 text, PRIMARY KEY(ptest1, ptest2, ptest3) );
-CREATE TABLE FKTABLE ( ftest1 int DEFAULT 0, ftest2 int, ftest3 int, ftest4 int,  CONSTRAINT constrname3
-			FOREIGN KEY(ftest1, ftest2, ftest3) REFERENCES PKTABLE
-			ON DELETE SET DEFAULT ON UPDATE SET NULL);
--- Insert Primary Key values
-INSERT INTO PKTABLE VALUES (1, 2, 3, 'test1');
-INSERT INTO PKTABLE VALUES (1, 3, 3, 'test2');
-INSERT INTO PKTABLE VALUES (2, 3, 4, 'test3');
-INSERT INTO PKTABLE VALUES (2, 4, 5, 'test4');
--- Insert Foreign Key values
-INSERT INTO FKTABLE VALUES (1, 2, 3, 1);
...
regress
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/foreign_key.out /tmp/cirrus-ci-build/build/testrun/regress/regre...
--- /tmp/cirrus-ci-build/src/test/regress/expected/foreign_key.out	2025-07-04 22:53:52.773578000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/foreign_key.out	2025-07-04 22:57:40.435601000 +0000
@@ -1885,1524 +1885,10 @@
 -- All constraints are now valid.
 SELECT conname, convalidated, conrelid::regclass FROM pg_constraint
 WHERE conrelid::regclass::text like 'fk_partitioned_fk%' ORDER BY oid::regclass::text;
-            conname             | convalidated |       conrelid        
---------------------------------+--------------+-----------------------
- fk_partitioned_fk_a_b_fkey     | t            | fk_partitioned_fk
- fk_partitioned_fk_1_a_b_fkey   | t            | fk_partitioned_fk_1
- fk_partitioned_fk_2_a_b_fkey   | t            | fk_partitioned_fk_2
- fk_partitioned_fk_3_a_b_fkey   | t            | fk_partitioned_fk_3
- fk_partitioned_fk_3_1_a_b_fkey | t            | fk_partitioned_fk_3_1
-(5 rows)
-
-DROP TABLE fk_partitioned_fk, fk_notpartitioned_pk;
--- NOT VALID and NOT ENFORCED foreign key on a non-partitioned table
--- referencing a partitioned table
-CREATE TABLE fk_partitioned_pk (a int, b int, PRIMARY KEY (a, b)) PARTITION BY RANGE (a, b);
...