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.
| 57/6274 |
Add a greedy join search algorithm to handle large join problems |
 |
Windows - Server 2022, MinGW64 - Meson |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/goo.out C:/cirrus/build/testrun/pg_upgrade/002_pg_upgra...
--- C:/cirrus/src/test/regress/expected/goo.out 2026-01-09 06:00:53.812525600 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/goo.out 2026-01-09 06:06:31.943236600 +0000
@@ -177,66 +177,66 @@
JOIN t13 ON t11.l = t13.l
JOIN t14 ON t12.m = t14.m
JOIN t15 ON t13.n = t15.n;
- QUERY PLAN
-----------------------------------------------------------------
+ QUERY PLAN
+----------------------------------------------------------------------------
Aggregate
-> Hash Join
- Hash Cond: (t7.h = t9.h)
+ Hash Cond: (t11.l = t13.l)
-> Hash Join
- Hash Cond: (t8.i = t10.i)
+ Hash Cond: (t9.j = t11.j)
-> Hash Join
- Hash Cond: (t2.c = t4.c)
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/goo.out C:/cirrus/build/testrun/recovery/027_stream_reg...
--- C:/cirrus/src/test/regress/expected/goo.out 2026-01-09 06:00:53.812525600 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/goo.out 2026-01-09 06:09:39.160020900 +0000
@@ -177,66 +177,66 @@
JOIN t13 ON t11.l = t13.l
JOIN t14 ON t12.m = t14.m
JOIN t15 ON t13.n = t15.n;
- QUERY PLAN
-----------------------------------------------------------------
+ QUERY PLAN
+----------------------------------------------------------------------------
Aggregate
-> Hash Join
- Hash Cond: (t7.h = t9.h)
+ Hash Cond: (t11.l = t13.l)
-> Hash Join
- Hash Cond: (t8.i = t10.i)
+ Hash Cond: (t9.j = t11.j)
-> Hash Join
- Hash Cond: (t2.c = t4.c)
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/goo.out C:/cirrus/build/testrun/regress/regress/results...
--- C:/cirrus/src/test/regress/expected/goo.out 2026-01-09 06:00:53.812525600 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/goo.out 2026-01-09 06:06:30.581423900 +0000
@@ -177,66 +177,66 @@
JOIN t13 ON t11.l = t13.l
JOIN t14 ON t12.m = t14.m
JOIN t15 ON t13.n = t15.n;
- QUERY PLAN
-----------------------------------------------------------------
+ QUERY PLAN
+----------------------------------------------------------------------------
Aggregate
-> Hash Join
- Hash Cond: (t7.h = t9.h)
+ Hash Cond: (t11.l = t13.l)
-> Hash Join
- Hash Cond: (t8.i = t10.i)
+ Hash Cond: (t9.j = t11.j)
-> Hash Join
- Hash Cond: (t2.c = t4.c)
... |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/goo.out C:/cirrus/build/testrun/pg_upgrade/002_pg_upgra...
--- C:/cirrus/src/test/regress/expected/goo.out 2026-01-09 06:00:50.607698400 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/goo.out 2026-01-09 06:04:31.149735900 +0000
@@ -177,66 +177,66 @@
JOIN t13 ON t11.l = t13.l
JOIN t14 ON t12.m = t14.m
JOIN t15 ON t13.n = t15.n;
- QUERY PLAN
-----------------------------------------------------------------
+ QUERY PLAN
+----------------------------------------------------------------------------
Aggregate
-> Hash Join
- Hash Cond: (t7.h = t9.h)
+ Hash Cond: (t11.l = t13.l)
-> Hash Join
- Hash Cond: (t8.i = t10.i)
+ Hash Cond: (t9.j = t11.j)
-> Hash Join
- Hash Cond: (t2.c = t4.c)
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/goo.out C:/cirrus/build/testrun/recovery/027_stream_reg...
--- C:/cirrus/src/test/regress/expected/goo.out 2026-01-09 06:00:50.607698400 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/goo.out 2026-01-09 06:07:35.214586800 +0000
@@ -177,66 +177,66 @@
JOIN t13 ON t11.l = t13.l
JOIN t14 ON t12.m = t14.m
JOIN t15 ON t13.n = t15.n;
- QUERY PLAN
-----------------------------------------------------------------
+ QUERY PLAN
+----------------------------------------------------------------------------
Aggregate
-> Hash Join
- Hash Cond: (t7.h = t9.h)
+ Hash Cond: (t11.l = t13.l)
-> Hash Join
- Hash Cond: (t8.i = t10.i)
+ Hash Cond: (t9.j = t11.j)
-> Hash Join
- Hash Cond: (t2.c = t4.c)
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/goo.out C:/cirrus/build/testrun/regress/regress/results...
--- C:/cirrus/src/test/regress/expected/goo.out 2026-01-09 06:00:50.607698400 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/goo.out 2026-01-09 06:04:31.509103100 +0000
@@ -177,66 +177,66 @@
JOIN t13 ON t11.l = t13.l
JOIN t14 ON t12.m = t14.m
JOIN t15 ON t13.n = t15.n;
- QUERY PLAN
-----------------------------------------------------------------
+ QUERY PLAN
+----------------------------------------------------------------------------
Aggregate
-> Hash Join
- Hash Cond: (t7.h = t9.h)
+ Hash Cond: (t11.l = t13.l)
-> Hash Join
- Hash Cond: (t8.i = t10.i)
+ Hash Cond: (t9.j = t11.j)
-> Hash Join
- Hash Cond: (t2.c = t4.c)
... |
|
macOS - Sequoia - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/goo.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade...
--- /Users/admin/pgsql/src/test/regress/expected/goo.out 2026-01-09 06:00:39
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/goo.out 2026-01-09 06:02:58
@@ -177,66 +177,66 @@
JOIN t13 ON t11.l = t13.l
JOIN t14 ON t12.m = t14.m
JOIN t15 ON t13.n = t15.n;
- QUERY PLAN
-----------------------------------------------------------------
+ QUERY PLAN
+----------------------------------------------------------------------------
Aggregate
-> Hash Join
- Hash Cond: (t7.h = t9.h)
+ Hash Cond: (t11.l = t13.l)
-> Hash Join
- Hash Cond: (t8.i = t10.i)
+ Hash Cond: (t9.j = t11.j)
-> Hash Join
- Hash Cond: (t2.c = t4.c)
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/goo.out /Users/admin/pgsql/build/testrun/recovery/027_stream_regre...
--- /Users/admin/pgsql/src/test/regress/expected/goo.out 2026-01-09 06:00:39
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/goo.out 2026-01-09 06:03:57
@@ -177,66 +177,66 @@
JOIN t13 ON t11.l = t13.l
JOIN t14 ON t12.m = t14.m
JOIN t15 ON t13.n = t15.n;
- QUERY PLAN
-----------------------------------------------------------------
+ QUERY PLAN
+----------------------------------------------------------------------------
Aggregate
-> Hash Join
- Hash Cond: (t7.h = t9.h)
+ Hash Cond: (t11.l = t13.l)
-> Hash Join
- Hash Cond: (t8.i = t10.i)
+ Hash Cond: (t9.j = t11.j)
-> Hash Join
- Hash Cond: (t2.c = t4.c)
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/goo.out /Users/admin/pgsql/build/testrun/regress/regress/results/g...
--- /Users/admin/pgsql/src/test/regress/expected/goo.out 2026-01-09 06:00:39
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/goo.out 2026-01-09 06:03:02
@@ -177,66 +177,66 @@
JOIN t13 ON t11.l = t13.l
JOIN t14 ON t12.m = t14.m
JOIN t15 ON t13.n = t15.n;
- QUERY PLAN
-----------------------------------------------------------------
+ QUERY PLAN
+----------------------------------------------------------------------------
Aggregate
-> Hash Join
- Hash Cond: (t7.h = t9.h)
+ Hash Cond: (t11.l = t13.l)
-> Hash Join
- Hash Cond: (t8.i = t10.i)
+ Hash Cond: (t9.j = t11.j)
-> Hash Join
- Hash Cond: (t2.c = t4.c)
... |
|
Linux - Debian Trixie - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/goo.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upg...
--- /tmp/cirrus-ci-build/src/test/regress/expected/goo.out 2026-01-09 06:00:48.410210984 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/goo.out 2026-01-09 06:04:32.241788562 +000...
@@ -177,66 +177,66 @@
JOIN t13 ON t11.l = t13.l
JOIN t14 ON t12.m = t14.m
JOIN t15 ON t13.n = t15.n;
- QUERY PLAN
-----------------------------------------------------------------
+ QUERY PLAN
+----------------------------------------------------------------------------
Aggregate
-> Hash Join
- Hash Cond: (t7.h = t9.h)
+ Hash Cond: (t11.l = t13.l)
-> Hash Join
- Hash Cond: (t8.i = t10.i)
+ Hash Cond: (t9.j = t11.j)
-> Hash Join
- Hash Cond: (t2.c = t4.c)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/goo.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/goo.out 2026-01-09 06:00:48.410210984 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/goo.out 2026-01-09 06:05:57.993643579 +0...
@@ -177,66 +177,66 @@
JOIN t13 ON t11.l = t13.l
JOIN t14 ON t12.m = t14.m
JOIN t15 ON t13.n = t15.n;
- QUERY PLAN
-----------------------------------------------------------------
+ QUERY PLAN
+----------------------------------------------------------------------------
Aggregate
-> Hash Join
- Hash Cond: (t7.h = t9.h)
+ Hash Cond: (t11.l = t13.l)
-> Hash Join
- Hash Cond: (t8.i = t10.i)
+ Hash Cond: (t9.j = t11.j)
-> Hash Join
- Hash Cond: (t2.c = t4.c)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/goo.out /tmp/cirrus-ci-build/build/testrun/regress/regress/resul...
--- /tmp/cirrus-ci-build/src/test/regress/expected/goo.out 2026-01-09 06:00:48.410210984 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/goo.out 2026-01-09 06:04:32.141789290 +0000
@@ -177,66 +177,66 @@
JOIN t13 ON t11.l = t13.l
JOIN t14 ON t12.m = t14.m
JOIN t15 ON t13.n = t15.n;
- QUERY PLAN
-----------------------------------------------------------------
+ QUERY PLAN
+----------------------------------------------------------------------------
Aggregate
-> Hash Join
- Hash Cond: (t7.h = t9.h)
+ Hash Cond: (t11.l = t13.l)
-> Hash Join
- Hash Cond: (t8.i = t10.i)
+ Hash Cond: (t9.j = t11.j)
-> Hash Join
- Hash Cond: (t2.c = t4.c)
... |
|
Linux - Debian Trixie - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/goo.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/result...
--- /tmp/cirrus-ci-build/src/test/regress/expected/goo.out 2026-01-09 06:00:52.233677126 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/goo.out 2026-01-09 06:08:06.911367623 +0000
@@ -177,66 +177,66 @@
JOIN t13 ON t11.l = t13.l
JOIN t14 ON t12.m = t14.m
JOIN t15 ON t13.n = t15.n;
- QUERY PLAN
-----------------------------------------------------------------
+ QUERY PLAN
+----------------------------------------------------------------------------
Aggregate
-> Hash Join
- Hash Cond: (t7.h = t9.h)
+ Hash Cond: (t11.l = t13.l)
-> Hash Join
- Hash Cond: (t8.i = t10.i)
+ Hash Cond: (t9.j = t11.j)
-> Hash Join
- Hash Cond: (t2.c = t4.c)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/goo.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results...
--- /tmp/cirrus-ci-build/src/test/regress/expected/goo.out 2026-01-09 06:00:52.233677126 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/goo.out 2026-01-09 06:09:19.823033271 +0000
@@ -177,66 +177,66 @@
JOIN t13 ON t11.l = t13.l
JOIN t14 ON t12.m = t14.m
JOIN t15 ON t13.n = t15.n;
- QUERY PLAN
-----------------------------------------------------------------
+ QUERY PLAN
+----------------------------------------------------------------------------
Aggregate
-> Hash Join
- Hash Cond: (t7.h = t9.h)
+ Hash Cond: (t11.l = t13.l)
-> Hash Join
- Hash Cond: (t8.i = t10.i)
+ Hash Cond: (t9.j = t11.j)
-> Hash Join
- Hash Cond: (t2.c = t4.c)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/goo.out /tmp/cirrus-ci-build/src/test/regress/results/goo.out
--- /tmp/cirrus-ci-build/src/test/regress/expected/goo.out 2026-01-09 06:00:52.233677126 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/goo.out 2026-01-09 06:05:48.900504584 +0000
@@ -177,66 +177,66 @@
JOIN t13 ON t11.l = t13.l
JOIN t14 ON t12.m = t14.m
JOIN t15 ON t13.n = t15.n;
- QUERY PLAN
-----------------------------------------------------------------
+ QUERY PLAN
+----------------------------------------------------------------------------
Aggregate
-> Hash Join
- Hash Cond: (t7.h = t9.h)
+ Hash Cond: (t11.l = t13.l)
-> Hash Join
- Hash Cond: (t8.i = t10.i)
+ Hash Cond: (t9.j = t11.j)
-> Hash Join
- Hash Cond: (t2.c = t4.c)
... |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/goo.out /home/postgres/postgres/build/testrun/pg_upgrade/002_...
--- /home/postgres/postgres/src/test/regress/expected/goo.out 2026-01-09 06:01:11.127453323 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/goo.out 2026-01-09 06:03:47.319446352 +...
@@ -177,66 +177,66 @@
JOIN t13 ON t11.l = t13.l
JOIN t14 ON t12.m = t14.m
JOIN t15 ON t13.n = t15.n;
- QUERY PLAN
-----------------------------------------------------------------
+ QUERY PLAN
+----------------------------------------------------------------------------
Aggregate
-> Hash Join
- Hash Cond: (t7.h = t9.h)
+ Hash Cond: (t11.l = t13.l)
-> Hash Join
- Hash Cond: (t8.i = t10.i)
+ Hash Cond: (t9.j = t11.j)
-> Hash Join
- Hash Cond: (t2.c = t4.c)
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/goo.out /home/postgres/postgres/build/testrun/recovery/027_st...
--- /home/postgres/postgres/src/test/regress/expected/goo.out 2026-01-09 06:01:11.127453323 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/goo.out 2026-01-09 06:04:28.946084250...
@@ -177,66 +177,66 @@
JOIN t13 ON t11.l = t13.l
JOIN t14 ON t12.m = t14.m
JOIN t15 ON t13.n = t15.n;
- QUERY PLAN
-----------------------------------------------------------------
+ QUERY PLAN
+----------------------------------------------------------------------------
Aggregate
-> Hash Join
- Hash Cond: (t7.h = t9.h)
+ Hash Cond: (t11.l = t13.l)
-> Hash Join
- Hash Cond: (t8.i = t10.i)
+ Hash Cond: (t9.j = t11.j)
-> Hash Join
- Hash Cond: (t2.c = t4.c)
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/goo.out /home/postgres/postgres/build/testrun/regress/regress...
--- /home/postgres/postgres/src/test/regress/expected/goo.out 2026-01-09 06:01:11.127453323 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/goo.out 2026-01-09 06:03:40.191475339 +0000
@@ -177,66 +177,66 @@
JOIN t13 ON t11.l = t13.l
JOIN t14 ON t12.m = t14.m
JOIN t15 ON t13.n = t15.n;
- QUERY PLAN
-----------------------------------------------------------------
+ QUERY PLAN
+----------------------------------------------------------------------------
Aggregate
-> Hash Join
- Hash Cond: (t7.h = t9.h)
+ Hash Cond: (t11.l = t13.l)
-> Hash Join
- Hash Cond: (t8.i = t10.i)
+ Hash Cond: (t9.j = t11.j)
-> Hash Join
- Hash Cond: (t2.c = t4.c)
... |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/goo.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upg...
--- /tmp/cirrus-ci-build/src/test/regress/expected/goo.out 2026-01-09 06:00:45.030114000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/goo.out 2026-01-09 06:03:28.845263000 +000...
@@ -177,66 +177,66 @@
JOIN t13 ON t11.l = t13.l
JOIN t14 ON t12.m = t14.m
JOIN t15 ON t13.n = t15.n;
- QUERY PLAN
-----------------------------------------------------------------
+ QUERY PLAN
+----------------------------------------------------------------------------
Aggregate
-> Hash Join
- Hash Cond: (t7.h = t9.h)
+ Hash Cond: (t11.l = t13.l)
-> Hash Join
- Hash Cond: (t8.i = t10.i)
+ Hash Cond: (t9.j = t11.j)
-> Hash Join
- Hash Cond: (t2.c = t4.c)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/goo.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/goo.out 2026-01-09 06:00:45.030114000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/goo.out 2026-01-09 06:05:04.923747000 +0...
@@ -177,66 +177,66 @@
JOIN t13 ON t11.l = t13.l
JOIN t14 ON t12.m = t14.m
JOIN t15 ON t13.n = t15.n;
- QUERY PLAN
-----------------------------------------------------------------
+ QUERY PLAN
+----------------------------------------------------------------------------
Aggregate
-> Hash Join
- Hash Cond: (t7.h = t9.h)
+ Hash Cond: (t11.l = t13.l)
-> Hash Join
- Hash Cond: (t8.i = t10.i)
+ Hash Cond: (t9.j = t11.j)
-> Hash Join
- Hash Cond: (t2.c = t4.c)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/goo.out /tmp/cirrus-ci-build/build/testrun/regress/regress/resul...
--- /tmp/cirrus-ci-build/src/test/regress/expected/goo.out 2026-01-09 06:00:45.030114000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/goo.out 2026-01-09 06:03:30.162097000 +0000
@@ -177,66 +177,66 @@
JOIN t13 ON t11.l = t13.l
JOIN t14 ON t12.m = t14.m
JOIN t15 ON t13.n = t15.n;
- QUERY PLAN
-----------------------------------------------------------------
+ QUERY PLAN
+----------------------------------------------------------------------------
Aggregate
-> Hash Join
- Hash Cond: (t7.h = t9.h)
+ Hash Cond: (t11.l = t13.l)
-> Hash Join
- Hash Cond: (t8.i = t10.i)
+ Hash Cond: (t9.j = t11.j)
-> Hash Join
- Hash Cond: (t2.c = t4.c)
... |
|
OpenBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/goo.out /home/postgres/postgres/build/testrun/pg_upgrade/002_...
--- /home/postgres/postgres/src/test/regress/expected/goo.out Fri Jan 9 06:00:58 2026
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/goo.out Fri Jan 9 06:04:21 2026
@@ -177,66 +177,66 @@
JOIN t13 ON t11.l = t13.l
JOIN t14 ON t12.m = t14.m
JOIN t15 ON t13.n = t15.n;
- QUERY PLAN
-----------------------------------------------------------------
+ QUERY PLAN
+----------------------------------------------------------------------------
Aggregate
-> Hash Join
- Hash Cond: (t7.h = t9.h)
+ Hash Cond: (t11.l = t13.l)
-> Hash Join
- Hash Cond: (t8.i = t10.i)
+ Hash Cond: (t9.j = t11.j)
-> Hash Join
- Hash Cond: (t2.c = t4.c)
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/goo.out /home/postgres/postgres/build/testrun/recovery/027_st...
--- /home/postgres/postgres/src/test/regress/expected/goo.out Fri Jan 9 06:00:58 2026
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/goo.out Fri Jan 9 06:06:30 2026
@@ -177,66 +177,66 @@
JOIN t13 ON t11.l = t13.l
JOIN t14 ON t12.m = t14.m
JOIN t15 ON t13.n = t15.n;
- QUERY PLAN
-----------------------------------------------------------------
+ QUERY PLAN
+----------------------------------------------------------------------------
Aggregate
-> Hash Join
- Hash Cond: (t7.h = t9.h)
+ Hash Cond: (t11.l = t13.l)
-> Hash Join
- Hash Cond: (t8.i = t10.i)
+ Hash Cond: (t9.j = t11.j)
-> Hash Join
- Hash Cond: (t2.c = t4.c)
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/goo.out /home/postgres/postgres/build/testrun/regress/regress...
--- /home/postgres/postgres/src/test/regress/expected/goo.out Fri Jan 9 06:00:58 2026
+++ /home/postgres/postgres/build/testrun/regress/regress/results/goo.out Fri Jan 9 06:04:18 2026
@@ -177,66 +177,66 @@
JOIN t13 ON t11.l = t13.l
JOIN t14 ON t12.m = t14.m
JOIN t15 ON t13.n = t15.n;
- QUERY PLAN
-----------------------------------------------------------------
+ QUERY PLAN
+----------------------------------------------------------------------------
Aggregate
-> Hash Join
- Hash Cond: (t7.h = t9.h)
+ Hash Cond: (t11.l = t13.l)
-> Hash Join
- Hash Cond: (t8.i = t10.i)
+ Hash Cond: (t9.j = t11.j)
-> Hash Join
- Hash Cond: (t2.c = t4.c)
... |
| 57/6299 |
New grouping strategy - Index Aggregate |
|
Linux - Debian Trixie - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/partition_aggregate.out /tmp/cirrus-ci-build/build-32/testrun/pg...
--- /tmp/cirrus-ci-build/src/test/regress/expected/partition_aggregate.out 2026-01-09 05:34:08.297873425 +0000
+++ /tmp/cirrus-ci-build/build-32/testrun/pg_upgrade/002_pg_upgrade/data/results/partition_aggregate.out 2026-01-09 05:4...
@@ -1010,7 +1010,7 @@
--------------------------------------------------------------------
Sort
Sort Key: pagg_tab_m.a, (sum(pagg_tab_m.b)), (avg(pagg_tab_m.c))
- -> Finalize IndexAggregate
+ -> Finalize HashAggregate
Group Key: pagg_tab_m.a
Filter: (avg(pagg_tab_m.c) < '22'::numeric)
-> Append |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/partition_aggregate.out /tmp/cirrus-ci-build/build-32/testrun/re...
--- /tmp/cirrus-ci-build/src/test/regress/expected/partition_aggregate.out 2026-01-09 05:34:08.297873425 +0000
+++ /tmp/cirrus-ci-build/build-32/testrun/recovery/027_stream_regress/data/results/partition_aggregate.out 2026-01-09 05...
@@ -1010,7 +1010,7 @@
--------------------------------------------------------------------
Sort
Sort Key: pagg_tab_m.a, (sum(pagg_tab_m.b)), (avg(pagg_tab_m.c))
- -> Finalize IndexAggregate
+ -> Finalize HashAggregate
Group Key: pagg_tab_m.a
Filter: (avg(pagg_tab_m.c) < '22'::numeric)
-> Append |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/partition_aggregate.out /tmp/cirrus-ci-build/build-32/testrun/re...
--- /tmp/cirrus-ci-build/src/test/regress/expected/partition_aggregate.out 2026-01-09 05:34:08.297873425 +0000
+++ /tmp/cirrus-ci-build/build-32/testrun/regress/regress/results/partition_aggregate.out 2026-01-09 05:45:39.566959863 ...
@@ -1010,7 +1010,7 @@
--------------------------------------------------------------------
Sort
Sort Key: pagg_tab_m.a, (sum(pagg_tab_m.b)), (avg(pagg_tab_m.c))
- -> Finalize IndexAggregate
+ -> Finalize HashAggregate
Group Key: pagg_tab_m.a
Filter: (avg(pagg_tab_m.c) < '22'::numeric)
-> Append |
|
OpenBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/brin.out /home/postgres/postgres/build/testrun/pg_upgrade/002...
--- /home/postgres/postgres/src/test/regress/expected/brin.out Fri Jan 9 05:34:20 2026
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/brin.out Fri Jan 9 05:38:36 2026
@@ -588,4 +588,10 @@
CREATE INDEX brin_insert_optimization_idx ON brin_insert_optimization USING brin (a);
UPDATE brin_insert_optimization SET a = a;
REINDEX INDEX CONCURRENTLY brin_insert_optimization_idx;
-DROP TABLE brin_insert_optimization;
+WARNING: terminating connection because of crash of another server process
+DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because anothe...
+HINT: In a moment you should be able to reconnect to the database and repeat your command.
+server closed the connection unexpectedly
+ This probably means the server terminated abnormally
+ before or while processing the request.
+connection to server was lost
diff -U3 /home/postgres/postgres/src/test/regress/expected/privileges.out /home/postgres/postgres/build/testrun/pg_upgra...
--- /home/postgres/postgres/src/test/regress/expected/privileges.out Fri Jan 9 05:34:21 2026
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/privileges.out Fri Jan 9 05:38:36 2026
@@ -1860,1600 +1860,10 @@
REINDEX TABLE sro_tab;
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/brin.out /home/postgres/postgres/build/testrun/recovery/027_s...
--- /home/postgres/postgres/src/test/regress/expected/brin.out Fri Jan 9 05:34:20 2026
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/brin.out Fri Jan 9 05:40:30 2026
@@ -363,229 +363,10 @@
END LOOP;
END;
$x$;
-RESET enable_seqscan;
-RESET enable_bitmapscan;
-INSERT INTO brintest SELECT
- repeat(stringu1, 42)::bytea,
- substr(stringu1, 1, 1)::"char",
- stringu1::name, 142857 * tenthous,
- thousand,
- twothousand,
- repeat(stringu1, 42),
- unique1::oid,
- format('(%s,%s)', tenthous, twenty)::tid,
- (four + 1.0)/(hundred+1),
- odd::float8 / (tenthous + 1),
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/brin.out /home/postgres/postgres/build/testrun/regress/regres...
--- /home/postgres/postgres/src/test/regress/expected/brin.out Fri Jan 9 05:34:20 2026
+++ /home/postgres/postgres/build/testrun/regress/regress/results/brin.out Fri Jan 9 05:38:25 2026
@@ -539,53 +539,10 @@
-- vacuum actually removes the TOAST rows. Creating an index concurrently
-- is a one way to achieve that, because it does exactly such wait.
CREATE INDEX CONCURRENTLY brin_test_temp_idx ON brintest_3(a);
-DROP INDEX brin_test_temp_idx;
--- vacuum the table, to discard TOAST data
-VACUUM brintest_3;
--- retry insert with a different random-looking (but deterministic) value
--- the value is different, and so should replace either min or max in the
--- brin summary
-WITH rand_value AS (SELECT string_agg(fipshash((-i)::text),'') AS val FROM generate_series(1,60) s(i))
-INSERT INTO brintest_3
-SELECT val, val, val, val FROM rand_value;
--- now try some queries, accessing the brin index
-SET enable_seqscan = off;
-EXPLAIN (COSTS OFF)
-SELECT * FROM brintest_3 WHERE b < '0';
... |
| 57/5456 |
Add XMLNamespaces option to XMLElement |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out /tmp/cirrus-ci-build/build/testrun/postgres...
--- /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out 2026-01-09 00:54:07.300067000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/postgres_fdw-running/regress/results/postgres_fdw.out 2026-01-09 01:02:47.0340800...
@@ -12696,8 +12696,7 @@
FROM postgres_fdw_get_connections(true);
server_name | closed | remote_backend_pid
-------------+--------+--------------------
- loopback | f | t
-(1 row)
+(0 rows)
-- After terminating the remote backend, since the connection is closed,
-- "closed" should be TRUE, or NULL if the connection status check
@@ -12713,8 +12712,7 @@
FROM postgres_fdw_get_connections(true);
server_name | closed | remote_backend_pid
-------------+--------+--------------------
- loopback | t | t
-(1 row)
+(0 rows)
... |
| 57/6334 |
Remove header lock BufferGetLSNAtomic() on architectures with 64 bit atomic operations |
|
Linux - Debian Trixie - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/pageinspect/expected/page.out /tmp/cirrus-ci-build/build/testrun/pageinspect/regre...
--- /tmp/cirrus-ci-build/contrib/pageinspect/expected/page.out 2026-01-08 19:08:41.651119424 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pageinspect/regress/results/page.out 2026-01-08 19:15:27.732737169 +0000
@@ -62,227 +62,7 @@
ERROR: invalid block number
SELECT tuple_data_split('test1'::regclass, t_data, t_infomask, t_infomask2, t_bits)
FROM heap_page_items(get_raw_page('test1', 0));
- tuple_data_split
--------------------------------
- {"\\x01000001","\\x00020200"}
-(1 row)
-
-SELECT * FROM fsm_page_contents(get_raw_page('test1', 'fsm', 0));
- fsm_page_contents
--------------------
- 0: 254 +
- 1: 254 +
- 3: 254 +
- 7: 254 +
- 15: 254 +
... |
| 57/6235 |
Implement pg_add_size_overflow() and friends |
|
OpenBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/isolation/expected/timeouts.out /home/postgres/postgres/build/testrun/isolatio...
--- /home/postgres/postgres/src/test/isolation/expected/timeouts.out Thu Jan 8 17:34:22 2026
+++ /home/postgres/postgres/build/testrun/isolation/isolation/results/timeouts.out Thu Jan 8 17:39:05 2026
@@ -11,7 +11,7 @@
step sto: SET statement_timeout = '10ms';
step locktbl: LOCK TABLE accounts; <waiting ...>
step locktbl: <... completed>
-ERROR: canceling statement due to statement timeout
+ERROR: canceling statement due to user request
starting permutation: rdtbl lto locktbl
step rdtbl: SELECT * FROM accounts; |
| 57/6357 |
Wrong comment for ReplicationSlotCreate |
| regress |
diff -U3 /home/postgres/postgres/src/test/isolation/expected/timeouts.out /home/postgres/postgres/build/testrun/isolatio...
--- /home/postgres/postgres/src/test/isolation/expected/timeouts.out Thu Jan 8 17:34:22 2026
+++ /home/postgres/postgres/build/testrun/isolation/isolation/results/timeouts.out Thu Jan 8 17:39:05 2026
@@ -11,7 +11,7 @@
step sto: SET statement_timeout = '10ms';
step locktbl: LOCK TABLE accounts; <waiting ...>
step locktbl: <... completed>
-ERROR: canceling statement due to statement timeout
+ERROR: canceling statement due to user request
starting permutation: rdtbl lto locktbl
step rdtbl: SELECT * FROM accounts; |
| 58/6372 |
XSD schema validation |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/xml_1.out C:/cirrus/build/testrun/pg_upgrade/002_pg_upg...
--- C:/cirrus/src/test/regress/expected/xml_1.out 2026-01-08 16:56:13.544057400 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/xml.out 2026-01-08 17:00:06.599245800 +0000
@@ -1496,3 +1496,278 @@
LINE 1: SELECT xmltext('x'|| '<P>73</P>'::xml || .42 || true || 'j':...
^
DETAIL: This functionality requires the server to be built with libxml support.
+SELECT xmlvalidate(DOCUMENT '<person><name>John</name><age>30</age></person>'
+ ACCORDING TO XMLSCHEMA '<?xml version="1.0"?>
+<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema">
+ <xs:element name="person">
+ <xs:complexType>
+ <xs:sequence>
+ <xs:element name="name" type="xs:string"/>
+ <xs:element name="age" type="xs:integer"/>
+ </xs:sequence>
+ </xs:complexType>
+ </xs:element>
+</xs:schema>');
+ERROR: unsupported XML feature
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/xml_1.out C:/cirrus/build/testrun/recovery/027_stream_r...
--- C:/cirrus/src/test/regress/expected/xml_1.out 2026-01-08 16:56:13.544057400 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/xml.out 2026-01-08 17:02:55.097282200 +0000
@@ -1496,3 +1496,278 @@
LINE 1: SELECT xmltext('x'|| '<P>73</P>'::xml || .42 || true || 'j':...
^
DETAIL: This functionality requires the server to be built with libxml support.
+SELECT xmlvalidate(DOCUMENT '<person><name>John</name><age>30</age></person>'
+ ACCORDING TO XMLSCHEMA '<?xml version="1.0"?>
+<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema">
+ <xs:element name="person">
+ <xs:complexType>
+ <xs:sequence>
+ <xs:element name="name" type="xs:string"/>
+ <xs:element name="age" type="xs:integer"/>
+ </xs:sequence>
+ </xs:complexType>
+ </xs:element>
+</xs:schema>');
+ERROR: unsupported XML feature
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/xml_1.out C:/cirrus/build/testrun/regress/regress/resul...
--- C:/cirrus/src/test/regress/expected/xml_1.out 2026-01-08 16:56:13.544057400 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/xml.out 2026-01-08 17:00:09.385373100 +0000
@@ -1496,3 +1496,278 @@
LINE 1: SELECT xmltext('x'|| '<P>73</P>'::xml || .42 || true || 'j':...
^
DETAIL: This functionality requires the server to be built with libxml support.
+SELECT xmlvalidate(DOCUMENT '<person><name>John</name><age>30</age></person>'
+ ACCORDING TO XMLSCHEMA '<?xml version="1.0"?>
+<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema">
+ <xs:element name="person">
+ <xs:complexType>
+ <xs:sequence>
+ <xs:element name="name" type="xs:string"/>
+ <xs:element name="age" type="xs:integer"/>
+ </xs:sequence>
+ </xs:complexType>
+ </xs:element>
+</xs:schema>');
+ERROR: unsupported XML feature
... |
| 58/6371 |
Allowing ALTER COLUMN TYPE for columns in publication column lists |
|
Windows - Server 2022, MinGW64 - Meson |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/publication.out C:/cirrus/build/testrun/pg_upgrade/002_...
--- C:/cirrus/src/test/regress/expected/publication.out 2026-01-08 16:10:35.251961000 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/publication.out 2026-01-08 16:17:59.257745900 +0000
@@ -629,8 +629,6 @@
-- test that ALTER COLUMN ALTER [ SET DATA ] TYPE is rejected when the column is in a row filter
CREATE TABLE testpub_rf_tbl8 (id int PRIMARY KEY, x int, y int, z int);
CREATE PUBLICATION testpub9 FOR TABLE testpub_rf_tbl8 WHERE (x > 100 AND y < 200);
-WARNING: "wal_level" is insufficient to publish logical changes
-HINT: Set "wal_level" to "logical" before creating subscriptions.
SET client_min_messages = 'ERROR';
-- fail
ALTER TABLE testpub_rf_tbl8 ALTER COLUMN x TYPE bigint; |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/publication.out C:/cirrus/build/testrun/recovery/027_st...
--- C:/cirrus/src/test/regress/expected/publication.out 2026-01-08 16:10:35.251961000 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/publication.out 2026-01-08 16:20:57.934493900 +0000
@@ -629,8 +629,6 @@
-- test that ALTER COLUMN ALTER [ SET DATA ] TYPE is rejected when the column is in a row filter
CREATE TABLE testpub_rf_tbl8 (id int PRIMARY KEY, x int, y int, z int);
CREATE PUBLICATION testpub9 FOR TABLE testpub_rf_tbl8 WHERE (x > 100 AND y < 200);
-WARNING: "wal_level" is insufficient to publish logical changes
-HINT: Set "wal_level" to "logical" before creating subscriptions.
SET client_min_messages = 'ERROR';
-- fail
ALTER TABLE testpub_rf_tbl8 ALTER COLUMN x TYPE bigint; |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/publication.out C:/cirrus/build/testrun/regress/regress...
--- C:/cirrus/src/test/regress/expected/publication.out 2026-01-08 16:10:35.251961000 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/publication.out 2026-01-08 16:17:55.184507500 +0000
@@ -629,8 +629,6 @@
-- test that ALTER COLUMN ALTER [ SET DATA ] TYPE is rejected when the column is in a row filter
CREATE TABLE testpub_rf_tbl8 (id int PRIMARY KEY, x int, y int, z int);
CREATE PUBLICATION testpub9 FOR TABLE testpub_rf_tbl8 WHERE (x > 100 AND y < 200);
-WARNING: "wal_level" is insufficient to publish logical changes
-HINT: Set "wal_level" to "logical" before creating subscriptions.
SET client_min_messages = 'ERROR';
-- fail
ALTER TABLE testpub_rf_tbl8 ALTER COLUMN x TYPE bigint; |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/publication.out C:/cirrus/build/testrun/pg_upgrade/002_...
--- C:/cirrus/src/test/regress/expected/publication.out 2026-01-08 16:10:26.979906600 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/publication.out 2026-01-08 16:14:43.109737100 +0000
@@ -629,8 +629,6 @@
-- test that ALTER COLUMN ALTER [ SET DATA ] TYPE is rejected when the column is in a row filter
CREATE TABLE testpub_rf_tbl8 (id int PRIMARY KEY, x int, y int, z int);
CREATE PUBLICATION testpub9 FOR TABLE testpub_rf_tbl8 WHERE (x > 100 AND y < 200);
-WARNING: "wal_level" is insufficient to publish logical changes
-HINT: Set "wal_level" to "logical" before creating subscriptions.
SET client_min_messages = 'ERROR';
-- fail
ALTER TABLE testpub_rf_tbl8 ALTER COLUMN x TYPE bigint; |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/publication.out C:/cirrus/build/testrun/recovery/027_st...
--- C:/cirrus/src/test/regress/expected/publication.out 2026-01-08 16:10:26.979906600 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/publication.out 2026-01-08 16:17:46.561404900 +0000
@@ -629,8 +629,6 @@
-- test that ALTER COLUMN ALTER [ SET DATA ] TYPE is rejected when the column is in a row filter
CREATE TABLE testpub_rf_tbl8 (id int PRIMARY KEY, x int, y int, z int);
CREATE PUBLICATION testpub9 FOR TABLE testpub_rf_tbl8 WHERE (x > 100 AND y < 200);
-WARNING: "wal_level" is insufficient to publish logical changes
-HINT: Set "wal_level" to "logical" before creating subscriptions.
SET client_min_messages = 'ERROR';
-- fail
ALTER TABLE testpub_rf_tbl8 ALTER COLUMN x TYPE bigint; |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/publication.out C:/cirrus/build/testrun/regress/regress...
--- C:/cirrus/src/test/regress/expected/publication.out 2026-01-08 16:10:26.979906600 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/publication.out 2026-01-08 16:14:37.173700700 +0000
@@ -629,8 +629,6 @@
-- test that ALTER COLUMN ALTER [ SET DATA ] TYPE is rejected when the column is in a row filter
CREATE TABLE testpub_rf_tbl8 (id int PRIMARY KEY, x int, y int, z int);
CREATE PUBLICATION testpub9 FOR TABLE testpub_rf_tbl8 WHERE (x > 100 AND y < 200);
-WARNING: "wal_level" is insufficient to publish logical changes
-HINT: Set "wal_level" to "logical" before creating subscriptions.
SET client_min_messages = 'ERROR';
-- fail
ALTER TABLE testpub_rf_tbl8 ALTER COLUMN x TYPE bigint; |
|
macOS - Sequoia - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/publication.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg...
--- /Users/admin/pgsql/src/test/regress/expected/publication.out 2026-01-08 16:10:35
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/publication.out 2026-01-08 16:14:03
@@ -629,8 +629,6 @@
-- test that ALTER COLUMN ALTER [ SET DATA ] TYPE is rejected when the column is in a row filter
CREATE TABLE testpub_rf_tbl8 (id int PRIMARY KEY, x int, y int, z int);
CREATE PUBLICATION testpub9 FOR TABLE testpub_rf_tbl8 WHERE (x > 100 AND y < 200);
-WARNING: "wal_level" is insufficient to publish logical changes
-HINT: Set "wal_level" to "logical" before creating subscriptions.
SET client_min_messages = 'ERROR';
-- fail
ALTER TABLE testpub_rf_tbl8 ALTER COLUMN x TYPE bigint; |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/publication.out /Users/admin/pgsql/build/testrun/recovery/027_stre...
--- /Users/admin/pgsql/src/test/regress/expected/publication.out 2026-01-08 16:10:35
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/publication.out 2026-01-08 16:16:02
@@ -629,8 +629,6 @@
-- test that ALTER COLUMN ALTER [ SET DATA ] TYPE is rejected when the column is in a row filter
CREATE TABLE testpub_rf_tbl8 (id int PRIMARY KEY, x int, y int, z int);
CREATE PUBLICATION testpub9 FOR TABLE testpub_rf_tbl8 WHERE (x > 100 AND y < 200);
-WARNING: "wal_level" is insufficient to publish logical changes
-HINT: Set "wal_level" to "logical" before creating subscriptions.
SET client_min_messages = 'ERROR';
-- fail
ALTER TABLE testpub_rf_tbl8 ALTER COLUMN x TYPE bigint; |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/publication.out /Users/admin/pgsql/build/testrun/regress/regress/r...
--- /Users/admin/pgsql/src/test/regress/expected/publication.out 2026-01-08 16:10:35
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/publication.out 2026-01-08 16:14:05
@@ -629,8 +629,6 @@
-- test that ALTER COLUMN ALTER [ SET DATA ] TYPE is rejected when the column is in a row filter
CREATE TABLE testpub_rf_tbl8 (id int PRIMARY KEY, x int, y int, z int);
CREATE PUBLICATION testpub9 FOR TABLE testpub_rf_tbl8 WHERE (x > 100 AND y < 200);
-WARNING: "wal_level" is insufficient to publish logical changes
-HINT: Set "wal_level" to "logical" before creating subscriptions.
SET client_min_messages = 'ERROR';
-- fail
ALTER TABLE testpub_rf_tbl8 ALTER COLUMN x TYPE bigint; |
|
Linux - Debian Trixie - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/publication.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/00...
--- /tmp/cirrus-ci-build/src/test/regress/expected/publication.out 2026-01-08 16:10:27.803051912 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/publication.out 2026-01-08 16:14:47.513809...
@@ -629,8 +629,6 @@
-- test that ALTER COLUMN ALTER [ SET DATA ] TYPE is rejected when the column is in a row filter
CREATE TABLE testpub_rf_tbl8 (id int PRIMARY KEY, x int, y int, z int);
CREATE PUBLICATION testpub9 FOR TABLE testpub_rf_tbl8 WHERE (x > 100 AND y < 200);
-WARNING: "wal_level" is insufficient to publish logical changes
-HINT: Set "wal_level" to "logical" before creating subscriptions.
SET client_min_messages = 'ERROR';
-- fail
ALTER TABLE testpub_rf_tbl8 ALTER COLUMN x TYPE bigint; |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/publication.out /tmp/cirrus-ci-build/build/testrun/recovery/027_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/publication.out 2026-01-08 16:10:27.803051912 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/publication.out 2026-01-08 16:16:10.5740...
@@ -629,8 +629,6 @@
-- test that ALTER COLUMN ALTER [ SET DATA ] TYPE is rejected when the column is in a row filter
CREATE TABLE testpub_rf_tbl8 (id int PRIMARY KEY, x int, y int, z int);
CREATE PUBLICATION testpub9 FOR TABLE testpub_rf_tbl8 WHERE (x > 100 AND y < 200);
-WARNING: "wal_level" is insufficient to publish logical changes
-HINT: Set "wal_level" to "logical" before creating subscriptions.
SET client_min_messages = 'ERROR';
-- fail
ALTER TABLE testpub_rf_tbl8 ALTER COLUMN x TYPE bigint; |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/publication.out /tmp/cirrus-ci-build/build/testrun/regress/regre...
--- /tmp/cirrus-ci-build/src/test/regress/expected/publication.out 2026-01-08 16:10:27.803051912 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/publication.out 2026-01-08 16:14:46.005804102 +0000
@@ -629,8 +629,6 @@
-- test that ALTER COLUMN ALTER [ SET DATA ] TYPE is rejected when the column is in a row filter
CREATE TABLE testpub_rf_tbl8 (id int PRIMARY KEY, x int, y int, z int);
CREATE PUBLICATION testpub9 FOR TABLE testpub_rf_tbl8 WHERE (x > 100 AND y < 200);
-WARNING: "wal_level" is insufficient to publish logical changes
-HINT: Set "wal_level" to "logical" before creating subscriptions.
SET client_min_messages = 'ERROR';
-- fail
ALTER TABLE testpub_rf_tbl8 ALTER COLUMN x TYPE bigint; |
|
Linux - Debian Trixie - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/publication.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_chec...
--- /tmp/cirrus-ci-build/src/test/regress/expected/publication.out 2026-01-08 16:10:39.310219575 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/publication.out 2026-01-08 16:17:26.383115362 +0000
@@ -629,8 +629,6 @@
-- test that ALTER COLUMN ALTER [ SET DATA ] TYPE is rejected when the column is in a row filter
CREATE TABLE testpub_rf_tbl8 (id int PRIMARY KEY, x int, y int, z int);
CREATE PUBLICATION testpub9 FOR TABLE testpub_rf_tbl8 WHERE (x > 100 AND y < 200);
-WARNING: "wal_level" is insufficient to publish logical changes
-HINT: Set "wal_level" to "logical" before creating subscriptions.
SET client_min_messages = 'ERROR';
-- fail
ALTER TABLE testpub_rf_tbl8 ALTER COLUMN x TYPE bigint; |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/publication.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check...
--- /tmp/cirrus-ci-build/src/test/regress/expected/publication.out 2026-01-08 16:10:39.310219575 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/publication.out 2026-01-08 16:18:22.415415512 +0000
@@ -629,8 +629,6 @@
-- test that ALTER COLUMN ALTER [ SET DATA ] TYPE is rejected when the column is in a row filter
CREATE TABLE testpub_rf_tbl8 (id int PRIMARY KEY, x int, y int, z int);
CREATE PUBLICATION testpub9 FOR TABLE testpub_rf_tbl8 WHERE (x > 100 AND y < 200);
-WARNING: "wal_level" is insufficient to publish logical changes
-HINT: Set "wal_level" to "logical" before creating subscriptions.
SET client_min_messages = 'ERROR';
-- fail
ALTER TABLE testpub_rf_tbl8 ALTER COLUMN x TYPE bigint; |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/publication.out /tmp/cirrus-ci-build/src/test/regress/results/pu...
--- /tmp/cirrus-ci-build/src/test/regress/expected/publication.out 2026-01-08 16:10:39.310219575 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/publication.out 2026-01-08 16:14:39.814750934 +0000
@@ -629,8 +629,6 @@
-- test that ALTER COLUMN ALTER [ SET DATA ] TYPE is rejected when the column is in a row filter
CREATE TABLE testpub_rf_tbl8 (id int PRIMARY KEY, x int, y int, z int);
CREATE PUBLICATION testpub9 FOR TABLE testpub_rf_tbl8 WHERE (x > 100 AND y < 200);
-WARNING: "wal_level" is insufficient to publish logical changes
-HINT: Set "wal_level" to "logical" before creating subscriptions.
SET client_min_messages = 'ERROR';
-- fail
ALTER TABLE testpub_rf_tbl8 ALTER COLUMN x TYPE bigint; |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/publication.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/00...
--- /tmp/cirrus-ci-build/src/test/regress/expected/publication.out 2026-01-08 16:10:23.731539000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/publication.out 2026-01-08 16:13:09.980992...
@@ -629,8 +629,6 @@
-- test that ALTER COLUMN ALTER [ SET DATA ] TYPE is rejected when the column is in a row filter
CREATE TABLE testpub_rf_tbl8 (id int PRIMARY KEY, x int, y int, z int);
CREATE PUBLICATION testpub9 FOR TABLE testpub_rf_tbl8 WHERE (x > 100 AND y < 200);
-WARNING: "wal_level" is insufficient to publish logical changes
-HINT: Set "wal_level" to "logical" before creating subscriptions.
SET client_min_messages = 'ERROR';
-- fail
ALTER TABLE testpub_rf_tbl8 ALTER COLUMN x TYPE bigint; |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/publication.out /tmp/cirrus-ci-build/build/testrun/recovery/027_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/publication.out 2026-01-08 16:10:23.731539000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/publication.out 2026-01-08 16:14:44.2693...
@@ -629,8 +629,6 @@
-- test that ALTER COLUMN ALTER [ SET DATA ] TYPE is rejected when the column is in a row filter
CREATE TABLE testpub_rf_tbl8 (id int PRIMARY KEY, x int, y int, z int);
CREATE PUBLICATION testpub9 FOR TABLE testpub_rf_tbl8 WHERE (x > 100 AND y < 200);
-WARNING: "wal_level" is insufficient to publish logical changes
-HINT: Set "wal_level" to "logical" before creating subscriptions.
SET client_min_messages = 'ERROR';
-- fail
ALTER TABLE testpub_rf_tbl8 ALTER COLUMN x TYPE bigint; |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/publication.out /tmp/cirrus-ci-build/build/testrun/regress/regre...
--- /tmp/cirrus-ci-build/src/test/regress/expected/publication.out 2026-01-08 16:10:23.731539000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/publication.out 2026-01-08 16:13:05.781541000 +0000
@@ -629,8 +629,6 @@
-- test that ALTER COLUMN ALTER [ SET DATA ] TYPE is rejected when the column is in a row filter
CREATE TABLE testpub_rf_tbl8 (id int PRIMARY KEY, x int, y int, z int);
CREATE PUBLICATION testpub9 FOR TABLE testpub_rf_tbl8 WHERE (x > 100 AND y < 200);
-WARNING: "wal_level" is insufficient to publish logical changes
-HINT: Set "wal_level" to "logical" before creating subscriptions.
SET client_min_messages = 'ERROR';
-- fail
ALTER TABLE testpub_rf_tbl8 ALTER COLUMN x TYPE bigint; |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/publication.out /home/postgres/postgres/build/testrun/pg_upgr...
--- /home/postgres/postgres/src/test/regress/expected/publication.out 2026-01-08 16:10:49.443587651 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/publication.out 2026-01-08 16:12:45.095...
@@ -629,8 +629,6 @@
-- test that ALTER COLUMN ALTER [ SET DATA ] TYPE is rejected when the column is in a row filter
CREATE TABLE testpub_rf_tbl8 (id int PRIMARY KEY, x int, y int, z int);
CREATE PUBLICATION testpub9 FOR TABLE testpub_rf_tbl8 WHERE (x > 100 AND y < 200);
-WARNING: "wal_level" is insufficient to publish logical changes
-HINT: Set "wal_level" to "logical" before creating subscriptions.
SET client_min_messages = 'ERROR';
-- fail
ALTER TABLE testpub_rf_tbl8 ALTER COLUMN x TYPE bigint; |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/publication.out /home/postgres/postgres/build/testrun/recover...
--- /home/postgres/postgres/src/test/regress/expected/publication.out 2026-01-08 16:10:49.443587651 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/publication.out 2026-01-08 16:13:27.7...
@@ -629,8 +629,6 @@
-- test that ALTER COLUMN ALTER [ SET DATA ] TYPE is rejected when the column is in a row filter
CREATE TABLE testpub_rf_tbl8 (id int PRIMARY KEY, x int, y int, z int);
CREATE PUBLICATION testpub9 FOR TABLE testpub_rf_tbl8 WHERE (x > 100 AND y < 200);
-WARNING: "wal_level" is insufficient to publish logical changes
-HINT: Set "wal_level" to "logical" before creating subscriptions.
SET client_min_messages = 'ERROR';
-- fail
ALTER TABLE testpub_rf_tbl8 ALTER COLUMN x TYPE bigint; |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/publication.out /home/postgres/postgres/build/testrun/regress...
--- /home/postgres/postgres/src/test/regress/expected/publication.out 2026-01-08 16:10:49.443587651 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/publication.out 2026-01-08 16:12:37.862777760 +0000
@@ -629,8 +629,6 @@
-- test that ALTER COLUMN ALTER [ SET DATA ] TYPE is rejected when the column is in a row filter
CREATE TABLE testpub_rf_tbl8 (id int PRIMARY KEY, x int, y int, z int);
CREATE PUBLICATION testpub9 FOR TABLE testpub_rf_tbl8 WHERE (x > 100 AND y < 200);
-WARNING: "wal_level" is insufficient to publish logical changes
-HINT: Set "wal_level" to "logical" before creating subscriptions.
SET client_min_messages = 'ERROR';
-- fail
ALTER TABLE testpub_rf_tbl8 ALTER COLUMN x TYPE bigint; |
|
OpenBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/publication.out /home/postgres/postgres/build/testrun/pg_upgr...
--- /home/postgres/postgres/src/test/regress/expected/publication.out Thu Jan 8 16:10:48 2026
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/publication.out Thu Jan 8 16:13:28 202...
@@ -629,8 +629,6 @@
-- test that ALTER COLUMN ALTER [ SET DATA ] TYPE is rejected when the column is in a row filter
CREATE TABLE testpub_rf_tbl8 (id int PRIMARY KEY, x int, y int, z int);
CREATE PUBLICATION testpub9 FOR TABLE testpub_rf_tbl8 WHERE (x > 100 AND y < 200);
-WARNING: "wal_level" is insufficient to publish logical changes
-HINT: Set "wal_level" to "logical" before creating subscriptions.
SET client_min_messages = 'ERROR';
-- fail
ALTER TABLE testpub_rf_tbl8 ALTER COLUMN x TYPE bigint; |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/publication.out /home/postgres/postgres/build/testrun/recover...
--- /home/postgres/postgres/src/test/regress/expected/publication.out Thu Jan 8 16:10:48 2026
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/publication.out Thu Jan 8 16:15:42 2...
@@ -629,8 +629,6 @@
-- test that ALTER COLUMN ALTER [ SET DATA ] TYPE is rejected when the column is in a row filter
CREATE TABLE testpub_rf_tbl8 (id int PRIMARY KEY, x int, y int, z int);
CREATE PUBLICATION testpub9 FOR TABLE testpub_rf_tbl8 WHERE (x > 100 AND y < 200);
-WARNING: "wal_level" is insufficient to publish logical changes
-HINT: Set "wal_level" to "logical" before creating subscriptions.
SET client_min_messages = 'ERROR';
-- fail
ALTER TABLE testpub_rf_tbl8 ALTER COLUMN x TYPE bigint; |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/publication.out /home/postgres/postgres/build/testrun/regress...
--- /home/postgres/postgres/src/test/regress/expected/publication.out Thu Jan 8 16:10:48 2026
+++ /home/postgres/postgres/build/testrun/regress/regress/results/publication.out Thu Jan 8 16:13:22 2026
@@ -629,8 +629,6 @@
-- test that ALTER COLUMN ALTER [ SET DATA ] TYPE is rejected when the column is in a row filter
CREATE TABLE testpub_rf_tbl8 (id int PRIMARY KEY, x int, y int, z int);
CREATE PUBLICATION testpub9 FOR TABLE testpub_rf_tbl8 WHERE (x > 100 AND y < 200);
-WARNING: "wal_level" is insufficient to publish logical changes
-HINT: Set "wal_level" to "logical" before creating subscriptions.
SET client_min_messages = 'ERROR';
-- fail
ALTER TABLE testpub_rf_tbl8 ALTER COLUMN x TYPE bigint; |
| 57/6176 |
Batching in executor, part 1: add batch variant of table AM scan API |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/explain.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stre...
--- /tmp/cirrus-ci-build/src/test/regress/expected/explain.out 2026-01-08 15:42:58.889435000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/explain.out 2026-01-08 15:49:28.42903900...
@@ -832,10 +832,9 @@
explain_filter
----------------------------------------------------------------
Seq Scan on batch_test (actual time=N.N..N.N rows=N.N loops=N)
- Batches: N Avg Rows: N.N Max: N Min: N
Planning Time: N.N ms
Execution Time: N.N ms
-(4 rows)
+(3 rows)
-- With filter
select explain_filter('explain (analyze, batches, buffers off, costs off) select * from batch_test where a > 5000');
@@ -844,10 +843,9 @@
Seq Scan on batch_test (actual time=N.N..N.N rows=N.N loops=N)
Filter: (a > N)
Rows Removed by Filter: N
- Batches: N Avg Rows: N.N Max: N Min: N
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/explain.out /tmp/cirrus-ci-build/build/testrun/regress/regress/r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/explain.out 2026-01-08 15:42:58.889435000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/explain.out 2026-01-08 15:47:59.491532000 +0000
@@ -844,10 +844,9 @@
Seq Scan on batch_test (actual time=N.N..N.N rows=N.N loops=N)
Filter: (a > N)
Rows Removed by Filter: N
- Batches: N Avg Rows: N.N Max: N Min: N
Planning Time: N.N ms
Execution Time: N.N ms
-(6 rows)
+(5 rows)
-- With LIMIT - partial scan shows fewer batches
select explain_filter('explain (analyze, batches, buffers off, costs off) select * from batch_test limit 100');
@@ -855,10 +854,9 @@
----------------------------------------------------------------------
Limit (actual time=N.N..N.N rows=N.N loops=N)
-> Seq Scan on batch_test (actual time=N.N..N.N rows=N.N loops=N)
- Batches: N Avg Rows: N.N Max: N Min: N
... |
| 57/6198 |
Change initdb default to the builtin collation provider |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/contrib/citext/expected/citext_utf8.out /home/postgres/postgres/build/testrun/citext/re...
--- /home/postgres/postgres/contrib/citext/expected/citext_utf8.out 2026-01-08 13:02:38.406319897 +0000
+++ /home/postgres/postgres/build/testrun/citext/regress/results/citext_utf8.out 2026-01-08 13:04:54.553006846 +0000
@@ -30,7 +30,7 @@
SELECT 'À'::citext = 'à '::citext AS t;
t
---
- t
+ f
(1 row)
SELECT 'À'::text = 'à '::text AS f; -- text wins.
@@ -64,7 +64,7 @@
SELECT 'i'::citext = 'Ä°'::citext AS t;
t
---
- t
+ f
(1 row)
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/modules/test_regex/expected/test_regex_utf8.out /home/postgres/postgres/build/...
--- /home/postgres/postgres/src/test/modules/test_regex/expected/test_regex_utf8.out 2026-01-08 13:02:46.231678288 +0000
+++ /home/postgres/postgres/build/testrun/test_regex/regress/results/test_regex_utf8.out 2026-01-08 13:05:15.818380097 +...
@@ -152,7 +152,7 @@
test_regex
-----------------
{0,REG_ULOCALE}
- {xᔀሷ}
+ {x}
(2 rows)
select * from test_regex('[[:lower:]]+', E'x\u1500\u1237', 'L');
@@ -166,7 +166,7 @@
test_regex
-----------------
{0,REG_ULOCALE}
- {xᔀሷ}
+ {x}
(2 rows)
... |
| 57/6178 |
COPY FROM with RLS |
|
OpenBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/isolation/expected/timeouts.out /home/postgres/postgres/build/testrun/isolatio...
--- /home/postgres/postgres/src/test/isolation/expected/timeouts.out Thu Jan 8 04:00:27 2026
+++ /home/postgres/postgres/build/testrun/isolation/isolation/results/timeouts.out Thu Jan 8 04:03:22 2026
@@ -11,7 +11,7 @@
step sto: SET statement_timeout = '10ms';
step locktbl: LOCK TABLE accounts; <waiting ...>
step locktbl: <... completed>
-ERROR: canceling statement due to statement timeout
+ERROR: canceling statement due to user request
starting permutation: rdtbl lto locktbl
step rdtbl: SELECT * FROM accounts; |
| 57/5957 |
implement CAST(expr AS type FORMAT 'template') |
|
Windows - Server 2022, MinGW64 - Meson |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/misc.out C:/cirrus/build/testrun/pg_upgrade/002_pg_upgr...
--- C:/cirrus/src/test/regress/expected/misc.out 2026-01-08 03:20:03.893222400 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/misc.out 2026-01-08 03:26:51.986574200 +0000
@@ -510,8 +510,12 @@
create index s1 on tcast(cast(col1 as date format 'YYYY-MM-DD')); --error
ERROR: functions in index expression must be marked IMMUTABLE
+LINE 1: create index s1 on tcast(cast(col1 as date format 'YYYY-MM-D...
+ ^
create index s1 on tcast(cast(col1 as date format stable_const())); --error
ERROR: functions in index expression must be marked IMMUTABLE
+LINE 1: create index s1 on tcast(cast(col1 as date format stable_con...
+ ^
create view tcast_v1 as select cast(col1 as date format 'YYYY-MM-DD') from tcast;
select pg_get_viewdef('tcast_v1', false);
pg_get_viewdef |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/misc.out C:/cirrus/build/testrun/recovery/027_stream_re...
--- C:/cirrus/src/test/regress/expected/misc.out 2026-01-08 03:20:03.893222400 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/misc.out 2026-01-08 03:29:54.635028400 +0000
@@ -510,8 +510,12 @@
create index s1 on tcast(cast(col1 as date format 'YYYY-MM-DD')); --error
ERROR: functions in index expression must be marked IMMUTABLE
+LINE 1: create index s1 on tcast(cast(col1 as date format 'YYYY-MM-D...
+ ^
create index s1 on tcast(cast(col1 as date format stable_const())); --error
ERROR: functions in index expression must be marked IMMUTABLE
+LINE 1: create index s1 on tcast(cast(col1 as date format stable_con...
+ ^
create view tcast_v1 as select cast(col1 as date format 'YYYY-MM-DD') from tcast;
select pg_get_viewdef('tcast_v1', false);
pg_get_viewdef |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/misc.out C:/cirrus/build/testrun/regress/regress/result...
--- C:/cirrus/src/test/regress/expected/misc.out 2026-01-08 03:20:03.893222400 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/misc.out 2026-01-08 03:26:48.082762900 +0000
@@ -510,8 +510,12 @@
create index s1 on tcast(cast(col1 as date format 'YYYY-MM-DD')); --error
ERROR: functions in index expression must be marked IMMUTABLE
+LINE 1: create index s1 on tcast(cast(col1 as date format 'YYYY-MM-D...
+ ^
create index s1 on tcast(cast(col1 as date format stable_const())); --error
ERROR: functions in index expression must be marked IMMUTABLE
+LINE 1: create index s1 on tcast(cast(col1 as date format stable_con...
+ ^
create view tcast_v1 as select cast(col1 as date format 'YYYY-MM-DD') from tcast;
select pg_get_viewdef('tcast_v1', false);
pg_get_viewdef |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/misc.out C:/cirrus/build/testrun/pg_upgrade/002_pg_upgr...
--- C:/cirrus/src/test/regress/expected/misc.out 2026-01-08 03:19:59.286637300 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/misc.out 2026-01-08 03:23:34.587094600 +0000
@@ -510,8 +510,12 @@
create index s1 on tcast(cast(col1 as date format 'YYYY-MM-DD')); --error
ERROR: functions in index expression must be marked IMMUTABLE
+LINE 1: create index s1 on tcast(cast(col1 as date format 'YYYY-MM-D...
+ ^
create index s1 on tcast(cast(col1 as date format stable_const())); --error
ERROR: functions in index expression must be marked IMMUTABLE
+LINE 1: create index s1 on tcast(cast(col1 as date format stable_con...
+ ^
create view tcast_v1 as select cast(col1 as date format 'YYYY-MM-DD') from tcast;
select pg_get_viewdef('tcast_v1', false);
pg_get_viewdef |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/misc.out C:/cirrus/build/testrun/recovery/027_stream_re...
--- C:/cirrus/src/test/regress/expected/misc.out 2026-01-08 03:19:59.286637300 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/misc.out 2026-01-08 03:26:35.236896700 +0000
@@ -510,8 +510,12 @@
create index s1 on tcast(cast(col1 as date format 'YYYY-MM-DD')); --error
ERROR: functions in index expression must be marked IMMUTABLE
+LINE 1: create index s1 on tcast(cast(col1 as date format 'YYYY-MM-D...
+ ^
create index s1 on tcast(cast(col1 as date format stable_const())); --error
ERROR: functions in index expression must be marked IMMUTABLE
+LINE 1: create index s1 on tcast(cast(col1 as date format stable_con...
+ ^
create view tcast_v1 as select cast(col1 as date format 'YYYY-MM-DD') from tcast;
select pg_get_viewdef('tcast_v1', false);
pg_get_viewdef |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/misc.out C:/cirrus/build/testrun/regress/regress/result...
--- C:/cirrus/src/test/regress/expected/misc.out 2026-01-08 03:19:59.286637300 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/misc.out 2026-01-08 03:23:31.318043300 +0000
@@ -510,8 +510,12 @@
create index s1 on tcast(cast(col1 as date format 'YYYY-MM-DD')); --error
ERROR: functions in index expression must be marked IMMUTABLE
+LINE 1: create index s1 on tcast(cast(col1 as date format 'YYYY-MM-D...
+ ^
create index s1 on tcast(cast(col1 as date format stable_const())); --error
ERROR: functions in index expression must be marked IMMUTABLE
+LINE 1: create index s1 on tcast(cast(col1 as date format stable_con...
+ ^
create view tcast_v1 as select cast(col1 as date format 'YYYY-MM-DD') from tcast;
select pg_get_viewdef('tcast_v1', false);
pg_get_viewdef |
|
Linux - Debian Trixie - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/misc.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_up...
--- /tmp/cirrus-ci-build/src/test/regress/expected/misc.out 2026-01-08 03:19:55.238733017 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/misc.out 2026-01-08 03:24:23.012261822 +00...
@@ -510,8 +510,12 @@
create index s1 on tcast(cast(col1 as date format 'YYYY-MM-DD')); --error
ERROR: functions in index expression must be marked IMMUTABLE
+LINE 1: create index s1 on tcast(cast(col1 as date format 'YYYY-MM-D...
+ ^
create index s1 on tcast(cast(col1 as date format stable_const())); --error
ERROR: functions in index expression must be marked IMMUTABLE
+LINE 1: create index s1 on tcast(cast(col1 as date format stable_con...
+ ^
create view tcast_v1 as select cast(col1 as date format 'YYYY-MM-DD') from tcast;
select pg_get_viewdef('tcast_v1', false);
pg_get_viewdef |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/misc.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/misc.out 2026-01-08 03:19:55.238733017 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/misc.out 2026-01-08 03:25:39.895480156 +...
@@ -510,8 +510,12 @@
create index s1 on tcast(cast(col1 as date format 'YYYY-MM-DD')); --error
ERROR: functions in index expression must be marked IMMUTABLE
+LINE 1: create index s1 on tcast(cast(col1 as date format 'YYYY-MM-D...
+ ^
create index s1 on tcast(cast(col1 as date format stable_const())); --error
ERROR: functions in index expression must be marked IMMUTABLE
+LINE 1: create index s1 on tcast(cast(col1 as date format stable_con...
+ ^
create view tcast_v1 as select cast(col1 as date format 'YYYY-MM-DD') from tcast;
select pg_get_viewdef('tcast_v1', false);
pg_get_viewdef |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/misc.out /tmp/cirrus-ci-build/build/testrun/regress/regress/resu...
--- /tmp/cirrus-ci-build/src/test/regress/expected/misc.out 2026-01-08 03:19:55.238733017 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/misc.out 2026-01-08 03:24:20.860289928 +0000
@@ -510,8 +510,12 @@
create index s1 on tcast(cast(col1 as date format 'YYYY-MM-DD')); --error
ERROR: functions in index expression must be marked IMMUTABLE
+LINE 1: create index s1 on tcast(cast(col1 as date format 'YYYY-MM-D...
+ ^
create index s1 on tcast(cast(col1 as date format stable_const())); --error
ERROR: functions in index expression must be marked IMMUTABLE
+LINE 1: create index s1 on tcast(cast(col1 as date format stable_con...
+ ^
create view tcast_v1 as select cast(col1 as date format 'YYYY-MM-DD') from tcast;
select pg_get_viewdef('tcast_v1', false);
pg_get_viewdef |
|
macOS - Sequoia - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/misc.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrad...
--- /Users/admin/pgsql/src/test/regress/expected/misc.out 2026-01-08 03:24:12
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/misc.out 2026-01-08 03:27:16
@@ -510,8 +510,12 @@
create index s1 on tcast(cast(col1 as date format 'YYYY-MM-DD')); --error
ERROR: functions in index expression must be marked IMMUTABLE
+LINE 1: create index s1 on tcast(cast(col1 as date format 'YYYY-MM-D...
+ ^
create index s1 on tcast(cast(col1 as date format stable_const())); --error
ERROR: functions in index expression must be marked IMMUTABLE
+LINE 1: create index s1 on tcast(cast(col1 as date format stable_con...
+ ^
create view tcast_v1 as select cast(col1 as date format 'YYYY-MM-DD') from tcast;
select pg_get_viewdef('tcast_v1', false);
pg_get_viewdef |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/misc.out /Users/admin/pgsql/build/testrun/recovery/027_stream_regr...
--- /Users/admin/pgsql/src/test/regress/expected/misc.out 2026-01-08 03:24:12
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/misc.out 2026-01-08 03:28:12
@@ -510,8 +510,12 @@
create index s1 on tcast(cast(col1 as date format 'YYYY-MM-DD')); --error
ERROR: functions in index expression must be marked IMMUTABLE
+LINE 1: create index s1 on tcast(cast(col1 as date format 'YYYY-MM-D...
+ ^
create index s1 on tcast(cast(col1 as date format stable_const())); --error
ERROR: functions in index expression must be marked IMMUTABLE
+LINE 1: create index s1 on tcast(cast(col1 as date format stable_con...
+ ^
create view tcast_v1 as select cast(col1 as date format 'YYYY-MM-DD') from tcast;
select pg_get_viewdef('tcast_v1', false);
pg_get_viewdef |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/misc.out /Users/admin/pgsql/build/testrun/regress/regress/results/...
--- /Users/admin/pgsql/src/test/regress/expected/misc.out 2026-01-08 03:24:12
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/misc.out 2026-01-08 03:27:16
@@ -510,8 +510,12 @@
create index s1 on tcast(cast(col1 as date format 'YYYY-MM-DD')); --error
ERROR: functions in index expression must be marked IMMUTABLE
+LINE 1: create index s1 on tcast(cast(col1 as date format 'YYYY-MM-D...
+ ^
create index s1 on tcast(cast(col1 as date format stable_const())); --error
ERROR: functions in index expression must be marked IMMUTABLE
+LINE 1: create index s1 on tcast(cast(col1 as date format stable_con...
+ ^
create view tcast_v1 as select cast(col1 as date format 'YYYY-MM-DD') from tcast;
select pg_get_viewdef('tcast_v1', false);
pg_get_viewdef |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/misc.out /home/postgres/postgres/build/testrun/pg_upgrade/002...
--- /home/postgres/postgres/src/test/regress/expected/misc.out 2026-01-08 03:20:18.920800327 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/misc.out 2026-01-08 03:23:11.359176698 ...
@@ -510,8 +510,12 @@
create index s1 on tcast(cast(col1 as date format 'YYYY-MM-DD')); --error
ERROR: functions in index expression must be marked IMMUTABLE
+LINE 1: create index s1 on tcast(cast(col1 as date format 'YYYY-MM-D...
+ ^
create index s1 on tcast(cast(col1 as date format stable_const())); --error
ERROR: functions in index expression must be marked IMMUTABLE
+LINE 1: create index s1 on tcast(cast(col1 as date format stable_con...
+ ^
create view tcast_v1 as select cast(col1 as date format 'YYYY-MM-DD') from tcast;
select pg_get_viewdef('tcast_v1', false);
pg_get_viewdef |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/misc.out /home/postgres/postgres/build/testrun/recovery/027_s...
--- /home/postgres/postgres/src/test/regress/expected/misc.out 2026-01-08 03:20:18.920800327 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/misc.out 2026-01-08 03:23:56.47310978...
@@ -510,8 +510,12 @@
create index s1 on tcast(cast(col1 as date format 'YYYY-MM-DD')); --error
ERROR: functions in index expression must be marked IMMUTABLE
+LINE 1: create index s1 on tcast(cast(col1 as date format 'YYYY-MM-D...
+ ^
create index s1 on tcast(cast(col1 as date format stable_const())); --error
ERROR: functions in index expression must be marked IMMUTABLE
+LINE 1: create index s1 on tcast(cast(col1 as date format stable_con...
+ ^
create view tcast_v1 as select cast(col1 as date format 'YYYY-MM-DD') from tcast;
select pg_get_viewdef('tcast_v1', false);
pg_get_viewdef |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/misc.out /home/postgres/postgres/build/testrun/regress/regres...
--- /home/postgres/postgres/src/test/regress/expected/misc.out 2026-01-08 03:20:18.920800327 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/misc.out 2026-01-08 03:23:06.250666901 +0000
@@ -510,8 +510,12 @@
create index s1 on tcast(cast(col1 as date format 'YYYY-MM-DD')); --error
ERROR: functions in index expression must be marked IMMUTABLE
+LINE 1: create index s1 on tcast(cast(col1 as date format 'YYYY-MM-D...
+ ^
create index s1 on tcast(cast(col1 as date format stable_const())); --error
ERROR: functions in index expression must be marked IMMUTABLE
+LINE 1: create index s1 on tcast(cast(col1 as date format stable_con...
+ ^
create view tcast_v1 as select cast(col1 as date format 'YYYY-MM-DD') from tcast;
select pg_get_viewdef('tcast_v1', false);
pg_get_viewdef |
|
OpenBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/misc.out /home/postgres/postgres/build/testrun/pg_upgrade/002...
--- /home/postgres/postgres/src/test/regress/expected/misc.out Thu Jan 8 03:20:07 2026
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/misc.out Thu Jan 8 03:24:15 2026
@@ -510,8 +510,12 @@
create index s1 on tcast(cast(col1 as date format 'YYYY-MM-DD')); --error
ERROR: functions in index expression must be marked IMMUTABLE
+LINE 1: create index s1 on tcast(cast(col1 as date format 'YYYY-MM-D...
+ ^
create index s1 on tcast(cast(col1 as date format stable_const())); --error
ERROR: functions in index expression must be marked IMMUTABLE
+LINE 1: create index s1 on tcast(cast(col1 as date format stable_con...
+ ^
create view tcast_v1 as select cast(col1 as date format 'YYYY-MM-DD') from tcast;
select pg_get_viewdef('tcast_v1', false);
pg_get_viewdef |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/misc.out /home/postgres/postgres/build/testrun/recovery/027_s...
--- /home/postgres/postgres/src/test/regress/expected/misc.out Thu Jan 8 03:20:07 2026
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/misc.out Thu Jan 8 03:26:15 2026
@@ -510,8 +510,12 @@
create index s1 on tcast(cast(col1 as date format 'YYYY-MM-DD')); --error
ERROR: functions in index expression must be marked IMMUTABLE
+LINE 1: create index s1 on tcast(cast(col1 as date format 'YYYY-MM-D...
+ ^
create index s1 on tcast(cast(col1 as date format stable_const())); --error
ERROR: functions in index expression must be marked IMMUTABLE
+LINE 1: create index s1 on tcast(cast(col1 as date format stable_con...
+ ^
create view tcast_v1 as select cast(col1 as date format 'YYYY-MM-DD') from tcast;
select pg_get_viewdef('tcast_v1', false);
pg_get_viewdef |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/misc.out /home/postgres/postgres/build/testrun/regress/regres...
--- /home/postgres/postgres/src/test/regress/expected/misc.out Thu Jan 8 03:20:07 2026
+++ /home/postgres/postgres/build/testrun/regress/regress/results/misc.out Thu Jan 8 03:24:08 2026
@@ -510,8 +510,12 @@
create index s1 on tcast(cast(col1 as date format 'YYYY-MM-DD')); --error
ERROR: functions in index expression must be marked IMMUTABLE
+LINE 1: create index s1 on tcast(cast(col1 as date format 'YYYY-MM-D...
+ ^
create index s1 on tcast(cast(col1 as date format stable_const())); --error
ERROR: functions in index expression must be marked IMMUTABLE
+LINE 1: create index s1 on tcast(cast(col1 as date format stable_con...
+ ^
create view tcast_v1 as select cast(col1 as date format 'YYYY-MM-DD') from tcast;
select pg_get_viewdef('tcast_v1', false);
pg_get_viewdef |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/misc.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_up...
--- /tmp/cirrus-ci-build/src/test/regress/expected/misc.out 2026-01-08 03:19:54.507506000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/misc.out 2026-01-08 03:23:03.928974000 +00...
@@ -510,8 +510,12 @@
create index s1 on tcast(cast(col1 as date format 'YYYY-MM-DD')); --error
ERROR: functions in index expression must be marked IMMUTABLE
+LINE 1: create index s1 on tcast(cast(col1 as date format 'YYYY-MM-D...
+ ^
create index s1 on tcast(cast(col1 as date format stable_const())); --error
ERROR: functions in index expression must be marked IMMUTABLE
+LINE 1: create index s1 on tcast(cast(col1 as date format stable_con...
+ ^
create view tcast_v1 as select cast(col1 as date format 'YYYY-MM-DD') from tcast;
select pg_get_viewdef('tcast_v1', false);
pg_get_viewdef |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/misc.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/misc.out 2026-01-08 03:19:54.507506000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/misc.out 2026-01-08 03:24:27.883225000 +...
@@ -510,8 +510,12 @@
create index s1 on tcast(cast(col1 as date format 'YYYY-MM-DD')); --error
ERROR: functions in index expression must be marked IMMUTABLE
+LINE 1: create index s1 on tcast(cast(col1 as date format 'YYYY-MM-D...
+ ^
create index s1 on tcast(cast(col1 as date format stable_const())); --error
ERROR: functions in index expression must be marked IMMUTABLE
+LINE 1: create index s1 on tcast(cast(col1 as date format stable_con...
+ ^
create view tcast_v1 as select cast(col1 as date format 'YYYY-MM-DD') from tcast;
select pg_get_viewdef('tcast_v1', false);
pg_get_viewdef |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/misc.out /tmp/cirrus-ci-build/build/testrun/regress/regress/resu...
--- /tmp/cirrus-ci-build/src/test/regress/expected/misc.out 2026-01-08 03:19:54.507506000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/misc.out 2026-01-08 03:22:53.663531000 +0000
@@ -510,8 +510,12 @@
create index s1 on tcast(cast(col1 as date format 'YYYY-MM-DD')); --error
ERROR: functions in index expression must be marked IMMUTABLE
+LINE 1: create index s1 on tcast(cast(col1 as date format 'YYYY-MM-D...
+ ^
create index s1 on tcast(cast(col1 as date format stable_const())); --error
ERROR: functions in index expression must be marked IMMUTABLE
+LINE 1: create index s1 on tcast(cast(col1 as date format stable_con...
+ ^
create view tcast_v1 as select cast(col1 as date format 'YYYY-MM-DD') from tcast;
select pg_get_viewdef('tcast_v1', false);
pg_get_viewdef |
|
Linux - Debian Trixie - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/misc.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/resul...
--- /tmp/cirrus-ci-build/src/test/regress/expected/misc.out 2026-01-08 03:20:01.674553900 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/misc.out 2026-01-08 03:27:38.440661248 +0000
@@ -510,8 +510,12 @@
create index s1 on tcast(cast(col1 as date format 'YYYY-MM-DD')); --error
ERROR: functions in index expression must be marked IMMUTABLE
+LINE 1: create index s1 on tcast(cast(col1 as date format 'YYYY-MM-D...
+ ^
create index s1 on tcast(cast(col1 as date format stable_const())); --error
ERROR: functions in index expression must be marked IMMUTABLE
+LINE 1: create index s1 on tcast(cast(col1 as date format stable_con...
+ ^
create view tcast_v1 as select cast(col1 as date format 'YYYY-MM-DD') from tcast;
select pg_get_viewdef('tcast_v1', false);
pg_get_viewdef |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/misc.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check/result...
--- /tmp/cirrus-ci-build/src/test/regress/expected/misc.out 2026-01-08 03:20:01.674553900 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/misc.out 2026-01-08 03:29:18.359595980 +0000
@@ -510,8 +510,12 @@
create index s1 on tcast(cast(col1 as date format 'YYYY-MM-DD')); --error
ERROR: functions in index expression must be marked IMMUTABLE
+LINE 1: create index s1 on tcast(cast(col1 as date format 'YYYY-MM-D...
+ ^
create index s1 on tcast(cast(col1 as date format stable_const())); --error
ERROR: functions in index expression must be marked IMMUTABLE
+LINE 1: create index s1 on tcast(cast(col1 as date format stable_con...
+ ^
create view tcast_v1 as select cast(col1 as date format 'YYYY-MM-DD') from tcast;
select pg_get_viewdef('tcast_v1', false);
pg_get_viewdef |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/misc.out /tmp/cirrus-ci-build/src/test/regress/results/misc.out
--- /tmp/cirrus-ci-build/src/test/regress/expected/misc.out 2026-01-08 03:20:01.674553900 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/misc.out 2026-01-08 03:25:38.091489722 +0000
@@ -510,8 +510,12 @@
create index s1 on tcast(cast(col1 as date format 'YYYY-MM-DD')); --error
ERROR: functions in index expression must be marked IMMUTABLE
+LINE 1: create index s1 on tcast(cast(col1 as date format 'YYYY-MM-D...
+ ^
create index s1 on tcast(cast(col1 as date format stable_const())); --error
ERROR: functions in index expression must be marked IMMUTABLE
+LINE 1: create index s1 on tcast(cast(col1 as date format stable_con...
+ ^
create view tcast_v1 as select cast(col1 as date format 'YYYY-MM-DD') from tcast;
select pg_get_viewdef('tcast_v1', false);
pg_get_viewdef |
| 57/5992 |
Fix ALTER TABLE DROP EXPRESSION with ONLY option |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/generated_stored.out C:/cirrus/build/testrun/pg_upgrade...
--- C:/cirrus/src/test/regress/expected/generated_stored.out 2026-01-07 01:30:21.591377200 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_stored.out 2026-01-07 01:33:37.431308000 +0...
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/generated_virtual.out C:/cirrus/build/testrun/pg_upgrad...
--- C:/cirrus/src/test/regress/expected/generated_virtual.out 2026-01-07 01:30:21.592355800 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out 2026-01-07 01:33:54.328777800 +...
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/generated_stored.out C:/cirrus/build/testrun/recovery/0...
--- C:/cirrus/src/test/regress/expected/generated_stored.out 2026-01-07 01:30:21.591377200 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/generated_stored.out 2026-01-07 01:36:34.997589900 ...
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/generated_virtual.out C:/cirrus/build/testrun/recovery/...
--- C:/cirrus/src/test/regress/expected/generated_virtual.out 2026-01-07 01:30:21.592355800 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out 2026-01-07 01:36:50.533220500...
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/generated_stored.out C:/cirrus/build/testrun/regress/re...
--- C:/cirrus/src/test/regress/expected/generated_stored.out 2026-01-07 01:30:21.591377200 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/generated_stored.out 2026-01-07 01:33:30.529968100 +0000
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/generated_virtual.out C:/cirrus/build/testrun/regress/r...
--- C:/cirrus/src/test/regress/expected/generated_virtual.out 2026-01-07 01:30:21.592355800 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/generated_virtual.out 2026-01-07 01:33:50.027026700 +0000
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
|
macOS - Sequoia - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/generated_stored.out /Users/admin/pgsql/build/testrun/pg_upgrade/0...
--- /Users/admin/pgsql/src/test/regress/expected/generated_stored.out 2026-01-07 01:30:37
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_stored.out 2026-01-07 01:32:32
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff -U3 /Users/admin/pgsql/src/test/regress/expected/generated_virtual.out /Users/admin/pgsql/build/testrun/pg_upgrade/...
--- /Users/admin/pgsql/src/test/regress/expected/generated_virtual.out 2026-01-07 01:30:37
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out 2026-01-07 01:32:35
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/generated_stored.out /Users/admin/pgsql/build/testrun/recovery/027...
--- /Users/admin/pgsql/src/test/regress/expected/generated_stored.out 2026-01-07 01:30:37
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/generated_stored.out 2026-01-07 01:33:25
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff -U3 /Users/admin/pgsql/src/test/regress/expected/generated_virtual.out /Users/admin/pgsql/build/testrun/recovery/02...
--- /Users/admin/pgsql/src/test/regress/expected/generated_virtual.out 2026-01-07 01:30:37
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out 2026-01-07 01:33:29
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/generated_stored.out /Users/admin/pgsql/build/testrun/regress/regr...
--- /Users/admin/pgsql/src/test/regress/expected/generated_stored.out 2026-01-07 01:30:37
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/generated_stored.out 2026-01-07 01:32:32
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff -U3 /Users/admin/pgsql/src/test/regress/expected/generated_virtual.out /Users/admin/pgsql/build/testrun/regress/reg...
--- /Users/admin/pgsql/src/test/regress/expected/generated_virtual.out 2026-01-07 01:30:37
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/generated_virtual.out 2026-01-07 01:32:36
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
|
Windows - Server 2022, MinGW64 - Meson |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/generated_stored.out C:/cirrus/build/testrun/pg_upgrade...
--- C:/cirrus/src/test/regress/expected/generated_stored.out 2026-01-07 01:30:36.926499800 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_stored.out 2026-01-07 01:33:34.274230200 +0...
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/generated_virtual.out C:/cirrus/build/testrun/pg_upgrad...
--- C:/cirrus/src/test/regress/expected/generated_virtual.out 2026-01-07 01:30:36.926499800 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out 2026-01-07 01:33:44.004706500 +...
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/generated_stored.out C:/cirrus/build/testrun/recovery/0...
--- C:/cirrus/src/test/regress/expected/generated_stored.out 2026-01-07 01:30:36.926499800 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/generated_stored.out 2026-01-07 01:36:43.754717300 ...
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/generated_virtual.out C:/cirrus/build/testrun/recovery/...
--- C:/cirrus/src/test/regress/expected/generated_virtual.out 2026-01-07 01:30:36.926499800 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out 2026-01-07 01:36:53.940246800...
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/generated_stored.out C:/cirrus/build/testrun/regress/re...
--- C:/cirrus/src/test/regress/expected/generated_stored.out 2026-01-07 01:30:36.926499800 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/generated_stored.out 2026-01-07 01:33:27.468558200 +0000
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/generated_virtual.out C:/cirrus/build/testrun/regress/r...
--- C:/cirrus/src/test/regress/expected/generated_virtual.out 2026-01-07 01:30:36.926499800 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/generated_virtual.out 2026-01-07 01:33:38.606756800 +0000
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
|
Linux - Debian Trixie - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_stored.out /tmp/cirrus-ci-build/build/testrun/pg_upgra...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_stored.out 2026-01-07 01:30:20.069396779 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_stored.out 2026-01-07 01:32:16.6...
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out /tmp/cirrus-ci-build/build/testrun/pg_upgr...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out 2026-01-07 01:30:20.069396779 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out 2026-01-07 01:32:24....
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_stored.out /tmp/cirrus-ci-build/build/testrun/recovery...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_stored.out 2026-01-07 01:30:20.069396779 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/generated_stored.out 2026-01-07 01:33:35...
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out /tmp/cirrus-ci-build/build/testrun/recover...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out 2026-01-07 01:30:20.069396779 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out 2026-01-07 01:33:4...
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_stored.out /tmp/cirrus-ci-build/build/testrun/regress/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_stored.out 2026-01-07 01:30:20.069396779 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/generated_stored.out 2026-01-07 01:32:12.643718419 +0000
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out /tmp/cirrus-ci-build/build/testrun/regress...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out 2026-01-07 01:30:20.069396779 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/generated_virtual.out 2026-01-07 01:32:20.832181937 +0000
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
|
Linux - Debian Trixie - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_stored.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_stored.out 2026-01-07 01:30:32.488991720 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/generated_stored.out 2026-01-07 01:35:33.129760697 +0000
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tm...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out 2026-01-07 01:30:32.488991720 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/generated_virtual.out 2026-01-07 01:35:46.145861077 +0000
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_stored.out /tmp/cirrus-ci-build/src/test/recovery/tmp_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_stored.out 2026-01-07 01:30:32.488991720 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/generated_stored.out 2026-01-07 01:37:30.573887031 +0000
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out /tmp/cirrus-ci-build/src/test/recovery/tmp...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out 2026-01-07 01:30:32.488991720 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/generated_virtual.out 2026-01-07 01:37:38.917851191 +0000
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_stored.out /tmp/cirrus-ci-build/src/test/regress/resul...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_stored.out 2026-01-07 01:30:32.488991720 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/generated_stored.out 2026-01-07 01:33:47.000536586 +0000
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out /tmp/cirrus-ci-build/src/test/regress/resu...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out 2026-01-07 01:30:32.488991720 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/generated_virtual.out 2026-01-07 01:34:00.656762485 +0000
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
|
OpenBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/generated_stored.out /home/postgres/postgres/build/testrun/pg...
--- /home/postgres/postgres/src/test/regress/expected/generated_stored.out Wed Jan 7 01:30:40 2026
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_stored.out Wed Jan 7 01:32:4...
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff -U3 /home/postgres/postgres/src/test/regress/expected/generated_virtual.out /home/postgres/postgres/build/testrun/p...
--- /home/postgres/postgres/src/test/regress/expected/generated_virtual.out Wed Jan 7 01:30:40 2026
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out Wed Jan 7 01:32:...
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/generated_stored.out /home/postgres/postgres/build/testrun/re...
--- /home/postgres/postgres/src/test/regress/expected/generated_stored.out Wed Jan 7 01:30:40 2026
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/generated_stored.out Wed Jan 7 01:34...
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff -U3 /home/postgres/postgres/src/test/regress/expected/generated_virtual.out /home/postgres/postgres/build/testrun/r...
--- /home/postgres/postgres/src/test/regress/expected/generated_virtual.out Wed Jan 7 01:30:40 2026
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out Wed Jan 7 01:3...
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/generated_stored.out /home/postgres/postgres/build/testrun/re...
--- /home/postgres/postgres/src/test/regress/expected/generated_stored.out Wed Jan 7 01:30:40 2026
+++ /home/postgres/postgres/build/testrun/regress/regress/results/generated_stored.out Wed Jan 7 01:32:40 2026
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff -U3 /home/postgres/postgres/src/test/regress/expected/generated_virtual.out /home/postgres/postgres/build/testrun/r...
--- /home/postgres/postgres/src/test/regress/expected/generated_virtual.out Wed Jan 7 01:30:40 2026
+++ /home/postgres/postgres/build/testrun/regress/regress/results/generated_virtual.out Wed Jan 7 01:32:53 2026
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_stored.out /tmp/cirrus-ci-build/build/testrun/pg_upgra...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_stored.out 2026-01-07 01:30:17.660995000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_stored.out 2026-01-07 01:32:10.6...
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out /tmp/cirrus-ci-build/build/testrun/pg_upgr...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out 2026-01-07 01:30:17.661037000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out 2026-01-07 01:32:25....
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_stored.out /tmp/cirrus-ci-build/build/testrun/recovery...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_stored.out 2026-01-07 01:30:17.660995000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/generated_stored.out 2026-01-07 01:33:16...
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out /tmp/cirrus-ci-build/build/testrun/recover...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out 2026-01-07 01:30:17.661037000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out 2026-01-07 01:33:4...
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_stored.out /tmp/cirrus-ci-build/build/testrun/regress/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_stored.out 2026-01-07 01:30:17.660995000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/generated_stored.out 2026-01-07 01:32:11.924976000 +0000
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out /tmp/cirrus-ci-build/build/testrun/regress...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out 2026-01-07 01:30:17.661037000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/generated_virtual.out 2026-01-07 01:32:27.560122000 +0000
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/generated_stored.out /home/postgres/postgres/build/testrun/pg...
--- /home/postgres/postgres/src/test/regress/expected/generated_stored.out 2026-01-07 01:30:45.938386032 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_stored.out 2026-01-07 01:32:0...
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff -U3 /home/postgres/postgres/src/test/regress/expected/generated_virtual.out /home/postgres/postgres/build/testrun/p...
--- /home/postgres/postgres/src/test/regress/expected/generated_virtual.out 2026-01-07 01:30:45.939124576 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out 2026-01-07 01:32:...
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/generated_stored.out /home/postgres/postgres/build/testrun/re...
--- /home/postgres/postgres/src/test/regress/expected/generated_stored.out 2026-01-07 01:30:45.938386032 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/generated_stored.out 2026-01-07 01:32...
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff -U3 /home/postgres/postgres/src/test/regress/expected/generated_virtual.out /home/postgres/postgres/build/testrun/r...
--- /home/postgres/postgres/src/test/regress/expected/generated_virtual.out 2026-01-07 01:30:45.939124576 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out 2026-01-07 01:3...
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/generated_stored.out /home/postgres/postgres/build/testrun/re...
--- /home/postgres/postgres/src/test/regress/expected/generated_stored.out 2026-01-07 01:30:45.938386032 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/generated_stored.out 2026-01-07 01:32:06.169511684 +00...
@@ -1311,6 +1311,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
Table "generated_stored_tests.gtest30"
Column | Type | Collation | Nullable | Default
diff -U3 /home/postgres/postgres/src/test/regress/expected/generated_virtual.out /home/postgres/postgres/build/testrun/r...
--- /home/postgres/postgres/src/test/regress/expected/generated_virtual.out 2026-01-07 01:30:45.939124576 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/generated_virtual.out 2026-01-07 01:32:17.118877289 +0...
@@ -1281,6 +1281,7 @@
CREATE TABLE gtest30_1 () INHERITS (gtest30);
ALTER TABLE ONLY gtest30 ALTER COLUMN b DROP EXPRESSION; -- error
ERROR: ALTER TABLE / DROP EXPRESSION must be applied to child tables too
+HINT: Do not specify the ONLY keyword.
\d gtest30
... |
| 54/5829 |
VCI (columnar store extension) |
|
Linux - Debian Trixie - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/vci/expected/vci.out /tmp/cirrus-ci-build/build/testrun/vci/regress/results/vci.ou...
--- /tmp/cirrus-ci-build/contrib/vci/expected/vci.out 2026-01-06 03:10:18.851087114 +0000
+++ /tmp/cirrus-ci-build/build/testrun/vci/regress/results/vci.out 2026-01-06 03:17:20.050547797 +0000
@@ -88,41 +88,7 @@
INSERT INTO testtable (key, cond, c01a, c01b, c02, c03, c05, c06, c07, c08, c09, c10, c13, c15, c16, c17, c18, c19, c20...
-- Create an index which uses VCI index access method
CREATE INDEX testindex ON testtable USING vci (key, cond, c01a, c01b, c02, c03, c05, c06, c07, c08, c09, c10, c13, c15,...
--- We expect VCI plans are chosen here
-EXPLAIN (ANALYZE, TIMING OFF, COSTS OFF, SUMMARY OFF, BUFFERS OFF)
-SELECT key, count(*) AS count_star, count(c05) AS count_c05 FROM testtable WHERE NOT cond = 0 GROUP BY key ORDER BY key...
- QUERY PLAN
-------------------------------------------------------------------------------------------------
- Sort (actual rows=14.00 loops=1)
- Sort Key: key
- Sort Method: quicksort Memory: 25kB
- -> Custom Scan (VCI HashAggregate) (actual rows=14.00 loops=1)
- Group Key: key
- -> Custom Scan (VCI Scan) using testindex on testtable (actual rows=10221.00 loops=1)
- Filter: (cond <> 0)
- Rows Removed by Filter: 476
... |
| 57/5958 |
Per backend relation statistics tracking |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/stats.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_u...
--- /tmp/cirrus-ci-build/src/test/regress/expected/stats.out 2026-01-03 01:39:48.036710000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/stats.out 2026-01-03 01:44:39.189276000 +0...
@@ -243,7 +243,7 @@
SELECT :seq_scan_after > :seq_scan_before;
?column?
----------
- t
+ f
(1 row)
---- |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/stats.out /tmp/cirrus-ci-build/build/testrun/regress/regress/res...
--- /tmp/cirrus-ci-build/src/test/regress/expected/stats.out 2026-01-03 01:39:48.036710000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/stats.out 2026-01-03 01:44:36.523735000 +0000
@@ -243,7 +243,7 @@
SELECT :seq_scan_after > :seq_scan_before;
?column?
----------
- t
+ f
(1 row)
---- |
| 57/6327 |
Fix outdated comments in catcache.h |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/temp.out /home/postgres/postgres/build/testrun/regress/regres...
--- /home/postgres/postgres/src/test/regress/expected/temp.out 2026-01-02 14:00:24.033007911 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/temp.out 2026-01-02 14:02:28.836788807 +0000
@@ -1,568 +1 @@
---
--- TEMP
--- Test temp relations and indexes
---
--- test temp table/index masking
-CREATE TABLE temptest(col int);
-CREATE INDEX i_temptest ON temptest(col);
-CREATE TEMP TABLE temptest(tcol int);
-CREATE INDEX i_temptest ON temptest(tcol);
-SELECT * FROM temptest;
- tcol
-------
-(0 rows)
-
-DROP INDEX i_temptest;
-DROP TABLE temptest;
... |
| 57/6343 |
Reuse data from readRecordBuf in XLogDecodeNextRecord |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/test_decoding/expected/rewrite.out /tmp/cirrus-ci-build/build/testrun/test_decodin...
--- /tmp/cirrus-ci-build/contrib/test_decoding/expected/rewrite.out 2026-01-01 15:09:55.832122000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_decoding/regress/results/rewrite.out 2026-01-01 15:16:47.899698000 +0000
@@ -116,49 +116,7 @@
-- make old files go away
CHECKPOINT;
SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1...
- data ...
------------------------------------------------------------------------------------------------------------------------...
- BEGIN
- table public.replication_example: INSERT: id[integer]:2 somedata[integer]:2 text[character varying]:null
- table public.replication_example: INSERT: id[integer]:3 somedata[integer]:3 text[character varying]:null testcolumn1[i...
- COMMIT
- BEGIN
- table public.replication_example: INSERT: id[integer]:4 somedata[integer]:3 text[character varying]:null testcolumn1[i...
- table public.replication_example: INSERT: id[integer]:5 somedata[integer]:4 text[character varying]:null testcolumn1[i...
- COMMIT
- BEGIN
- table public.replication_example: INSERT: id[integer]:6 somedata[integer]:5 text[character varying]:null testcolumn1[i...
- COMMIT
... |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/contrib/test_decoding/expected/rewrite.out /home/postgres/postgres/build/testrun/test_d...
--- /home/postgres/postgres/contrib/test_decoding/expected/rewrite.out 2026-01-01 15:09:59.033615189 +0000
+++ /home/postgres/postgres/build/testrun/test_decoding/regress/results/rewrite.out 2026-01-01 15:16:29.701247607 +0000
@@ -116,49 +116,7 @@
-- make old files go away
CHECKPOINT;
SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1...
- data ...
------------------------------------------------------------------------------------------------------------------------...
- BEGIN
- table public.replication_example: INSERT: id[integer]:2 somedata[integer]:2 text[character varying]:null
- table public.replication_example: INSERT: id[integer]:3 somedata[integer]:3 text[character varying]:null testcolumn1[i...
- COMMIT
- BEGIN
- table public.replication_example: INSERT: id[integer]:4 somedata[integer]:3 text[character varying]:null testcolumn1[i...
- table public.replication_example: INSERT: id[integer]:5 somedata[integer]:4 text[character varying]:null testcolumn1[i...
- COMMIT
- BEGIN
- table public.replication_example: INSERT: id[integer]:6 somedata[integer]:5 text[character varying]:null testcolumn1[i...
- COMMIT
... |
|
Linux - Debian Trixie - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/test_decoding/expected/rewrite.out /tmp/cirrus-ci-build/contrib/test_decoding/resu...
--- /tmp/cirrus-ci-build/contrib/test_decoding/expected/rewrite.out 2026-01-01 15:09:50.675334842 +0000
+++ /tmp/cirrus-ci-build/contrib/test_decoding/results/rewrite.out 2026-01-01 15:15:49.811837660 +0000
@@ -116,49 +116,7 @@
-- make old files go away
CHECKPOINT;
SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1...
- data ...
------------------------------------------------------------------------------------------------------------------------...
- BEGIN
- table public.replication_example: INSERT: id[integer]:2 somedata[integer]:2 text[character varying]:null
- table public.replication_example: INSERT: id[integer]:3 somedata[integer]:3 text[character varying]:null testcolumn1[i...
- COMMIT
- BEGIN
- table public.replication_example: INSERT: id[integer]:4 somedata[integer]:3 text[character varying]:null testcolumn1[i...
- table public.replication_example: INSERT: id[integer]:5 somedata[integer]:4 text[character varying]:null testcolumn1[i...
- COMMIT
- BEGIN
- table public.replication_example: INSERT: id[integer]:6 somedata[integer]:5 text[character varying]:null testcolumn1[i...
- COMMIT
... |
| 57/5975 |
When deleting the plpgsql function, release the CachedPlan of the function |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/isolation/expected/insert-conflict-specconflict.out /tmp/cirrus-ci-build/build/te...
--- /tmp/cirrus-ci-build/src/test/isolation/expected/insert-conflict-specconflict.out 2025-12-31 02:43:34.948310000 +000...
+++ /tmp/cirrus-ci-build/build/testrun/isolation-running/isolation/results/insert-conflict-specconflict.out 2025-12-31 0...
@@ -230,324 +230,7 @@
t
(1 row)
-s1: NOTICE: blurt_and_lock_123() called for k2 in session 1
-s1: NOTICE: acquiring advisory lock on 2
-step controller_unlock_2_3: SELECT pg_advisory_unlock(2, 3);
-pg_advisory_unlock
-------------------
-t
-(1 row)
-
-s2: NOTICE: blurt_and_lock_123() called for k2 in session 2
-s2: NOTICE: acquiring advisory lock on 2
-step controller_show: SELECT * FROM upserttest;
-key|data
----+----
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/tablespace.out /tmp/cirrus-ci-build/build/testrun/regress-runnin...
--- /tmp/cirrus-ci-build/src/test/regress/expected/tablespace.out 2025-12-31 02:43:35.143110000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress-running/regress/results/tablespace.out 2025-12-31 02:51:36.206141000 +000...
@@ -123,851 +123,10 @@
SELECT c.relname FROM pg_class c, pg_tablespace s
WHERE c.reltablespace = s.oid AND s.spcname = 'regress_tblspace'
ORDER BY c.relname;
- relname
----------
-(0 rows)
-
-REINDEX (TABLESPACE regress_tblspace, CONCURRENTLY) TABLE regress_tblspace_test_tbl;
-SELECT c.relname FROM pg_class c, pg_tablespace s
- WHERE c.reltablespace = s.oid AND s.spcname = 'regress_tblspace'
- ORDER BY c.relname;
- relname
--------------------------------
- regress_tblspace_test_tbl_idx
-(1 row)
-
... |
| 57/6054 |
let ALTER COLUMN SET DATA TYPE cope with POLICY dependency |
|
Windows - Server 2022, MinGW64 - Meson |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/rowsecurity.out C:/cirrus/build/testrun/recovery/027_st...
--- C:/cirrus/src/test/regress/expected/rowsecurity.out 2025-12-27 19:41:00.174756900 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/rowsecurity.out 2025-12-27 19:51:14.513953900 +0000
@@ -378,15 +378,15 @@
--------------------+----------+-------+----------------------------------------------+-------------------+------------...
regress_rls_schema | category | table | regress_rls_alice=arwdDxtm/regress_rls_alice+| |
| | | =arwdDxtm/regress_rls_alice | |
- regress_rls_schema | document | table | regress_rls_alice=arwdDxtm/regress_rls_alice+| | p1: ...
- | | | =arwdDxtm/regress_rls_alice | | (u): (dle...
+ regress_rls_schema | document | table | regress_rls_alice=arwdDxtm/regress_rls_alice+| | p1r (RESTRI...
+ | | | =arwdDxtm/regress_rls_alice | | (u): (cid...
+ | | | | | to: regre...
+ | | | | | p1: ...
+ | | | | | (u): (dle...
| | | | | FROM uac...
| | | | | WHERE (ua...
| | | | | p2r (RESTRI...
| | | | | (u): ((ci...
- | | | | | to: regre...
- | | | | | p1r (RESTRI...
... |
|
macOS - Sequoia - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/rowsecurity.out /Users/admin/pgsql/build/testrun/regress/regress/r...
--- /Users/admin/pgsql/src/test/regress/expected/rowsecurity.out 2025-12-27 19:41:03
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/rowsecurity.out 2025-12-27 19:44:20
@@ -378,15 +378,15 @@
--------------------+----------+-------+----------------------------------------------+-------------------+------------...
regress_rls_schema | category | table | regress_rls_alice=arwdDxtm/regress_rls_alice+| |
| | | =arwdDxtm/regress_rls_alice | |
- regress_rls_schema | document | table | regress_rls_alice=arwdDxtm/regress_rls_alice+| | p1: ...
- | | | =arwdDxtm/regress_rls_alice | | (u): (dle...
+ regress_rls_schema | document | table | regress_rls_alice=arwdDxtm/regress_rls_alice+| | p1r (RESTRI...
+ | | | =arwdDxtm/regress_rls_alice | | (u): (cid...
+ | | | | | to: regre...
+ | | | | | p1: ...
+ | | | | | (u): (dle...
| | | | | FROM uac...
| | | | | WHERE (ua...
| | | | | p2r (RESTRI...
| | | | | (u): ((ci...
- | | | | | to: regre...
- | | | | | p1r (RESTRI...
... |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/rowsecurity.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/00...
--- /tmp/cirrus-ci-build/src/test/regress/expected/rowsecurity.out 2025-12-27 19:41:00.686965000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/rowsecurity.out 2025-12-27 19:43:58.791472...
@@ -378,15 +378,15 @@
--------------------+----------+-------+----------------------------------------------+-------------------+------------...
regress_rls_schema | category | table | regress_rls_alice=arwdDxtm/regress_rls_alice+| |
| | | =arwdDxtm/regress_rls_alice | |
- regress_rls_schema | document | table | regress_rls_alice=arwdDxtm/regress_rls_alice+| | p1: ...
- | | | =arwdDxtm/regress_rls_alice | | (u): (dle...
+ regress_rls_schema | document | table | regress_rls_alice=arwdDxtm/regress_rls_alice+| | p1r (RESTRI...
+ | | | =arwdDxtm/regress_rls_alice | | (u): (cid...
+ | | | | | to: regre...
+ | | | | | p1: ...
+ | | | | | (u): (dle...
| | | | | FROM uac...
| | | | | WHERE (ua...
| | | | | p2r (RESTRI...
| | | | | (u): ((ci...
- | | | | | to: regre...
- | | | | | p1r (RESTRI...
... |
| 57/6303 |
refactor handling optional argument in system functions |
|
Linux - Debian Trixie - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out 2025-12-25 13:16:53.463167932 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/triggers.out 2025-12-25 13:22:22.420391344 +0000
@@ -2680,952 +2680,10 @@
alter table parent attach partition child2 for values in ('BBB');
-- a child with a different column order
create table child3 (b int, a text);
-alter table parent attach partition child3 for values in ('CCC');
-create trigger parent_insert_trig
- after insert on parent referencing new table as new_table
- for each statement execute procedure dump_insert();
-create trigger parent_update_trig
- after update on parent referencing old table as old_table new table as new_table
- for each statement execute procedure dump_update();
-create trigger parent_delete_trig
- after delete on parent referencing old table as old_table
- for each statement execute procedure dump_delete();
-create trigger child1_insert_trig
- after insert on child1 referencing new table as new_table
- for each statement execute procedure dump_insert();
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/src/test/regress/results/trigg...
--- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out 2025-12-25 13:16:53.463167932 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/triggers.out 2025-12-25 13:20:54.956452716 +0000
@@ -2541,1091 +2541,10 @@
create table parent (a int primary key, f int references parent)
partition by list (a);
create table child1 partition of parent for values in (1);
-select tgrelid::regclass, rtrim(tgname, '0123456789') as tgname,
- tgfoid::regproc, tgenabled
- from pg_trigger where tgrelid in ('parent'::regclass, 'child1'::regclass)
- order by tgrelid::regclass::text, tgfoid;
- tgrelid | tgname | tgfoid | tgenabled
----------+-------------------------+------------------------+-----------
- child1 | RI_ConstraintTrigger_c_ | "RI_FKey_check_ins" | O
- child1 | RI_ConstraintTrigger_c_ | "RI_FKey_check_upd" | O
- child1 | RI_ConstraintTrigger_a_ | "RI_FKey_noaction_del" | O
- child1 | RI_ConstraintTrigger_a_ | "RI_FKey_noaction_upd" | O
- parent | RI_ConstraintTrigger_c_ | "RI_FKey_check_ins" | O
- parent | RI_ConstraintTrigger_c_ | "RI_FKey_check_upd" | O
- parent | RI_ConstraintTrigger_a_ | "RI_FKey_noaction_del" | O
... |
| 57/6228 |
Adding callback support for custom statistics kinds |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/modules/injection_points/expected/reindex-concurrently-upsert-on-constraint.ou...
--- /home/postgres/postgres/src/test/modules/injection_points/expected/reindex-concurrently-upsert-on-constraint.out 202...
+++ /home/postgres/postgres/build/testrun/injection_points/isolation/results/reindex-concurrently-upsert-on-constraint.o...
@@ -34,16 +34,7 @@
SELECT injection_points_detach('reindex-relation-concurrently-before-set-dead');
SELECT injection_points_wakeup('reindex-relation-concurrently-before-set-dead');
-injection_points_detach
------------------------
-
-(1 row)
-
-injection_points_wakeup
------------------------
-
-(1 row)
-
+ERROR: could not detach injection point "reindex-relation-concurrently-before-set-dead"
step s2_start_upsert:
INSERT INTO test.tbl VALUES (13, now()) ON CONFLICT ON CONSTRAINT tbl_pkey DO UPDATE SET updated_at = now();
... |