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.
| 59/6751 |
[PATCH] Make NumericVar storage semantics explicit |
 |
Linux - Debian Trixie - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/numeric.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg...
--- /tmp/cirrus-ci-build/src/test/regress/expected/numeric.out 2026-05-16 05:09:02.107117714 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/numeric.out 2026-05-16 05:10:33.542235012 ...
@@ -894,3004 +894,7 @@
log10(x),
ln(x)
FROM v;
- x | log | log10 | ln
-----------+--------------------+--------------------+--------------------
- 1 | 0.0000000000000000 | 0.0000000000000000 | 0.0000000000000000
- 4.2 | 0.6232492903979005 | 0.6232492903979005 | 1.4350845252893226
- Infinity | Infinity | Infinity | Infinity
- NaN | NaN | NaN | NaN
-(4 rows)
-
-SELECT ln('0'::numeric);
-ERROR: cannot take logarithm of zero
-SELECT ln('-1'::numeric);
-ERROR: cannot take logarithm of a negative number
-SELECT ln('-inf'::numeric);
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/numeric.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stre...
--- /tmp/cirrus-ci-build/src/test/regress/expected/numeric.out 2026-05-16 05:09:02.107117714 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/numeric.out 2026-05-16 05:11:35.85033442...
@@ -894,3004 +894,7 @@
log10(x),
ln(x)
FROM v;
- x | log | log10 | ln
-----------+--------------------+--------------------+--------------------
- 1 | 0.0000000000000000 | 0.0000000000000000 | 0.0000000000000000
- 4.2 | 0.6232492903979005 | 0.6232492903979005 | 1.4350845252893226
- Infinity | Infinity | Infinity | Infinity
- NaN | NaN | NaN | NaN
-(4 rows)
-
-SELECT ln('0'::numeric);
-ERROR: cannot take logarithm of zero
-SELECT ln('-1'::numeric);
-ERROR: cannot take logarithm of a negative number
-SELECT ln('-inf'::numeric);
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/numeric.out /tmp/cirrus-ci-build/build/testrun/regress/regress/r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/numeric.out 2026-05-16 05:09:02.107117714 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/numeric.out 2026-05-16 05:10:32.010106905 +0000
@@ -894,3004 +894,7 @@
log10(x),
ln(x)
FROM v;
- x | log | log10 | ln
-----------+--------------------+--------------------+--------------------
- 1 | 0.0000000000000000 | 0.0000000000000000 | 0.0000000000000000
- 4.2 | 0.6232492903979005 | 0.6232492903979005 | 1.4350845252893226
- Infinity | Infinity | Infinity | Infinity
- NaN | NaN | NaN | NaN
-(4 rows)
-
-SELECT ln('0'::numeric);
-ERROR: cannot take logarithm of zero
-SELECT ln('-1'::numeric);
-ERROR: cannot take logarithm of a negative number
-SELECT ln('-inf'::numeric);
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/numeric.out /tmp/cirrus-ci-build/build/testrun/test_plan_advice/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/numeric.out 2026-05-16 05:09:02.107117714 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/numeric.out 2026-05-16 05:10:33....
@@ -894,3004 +894,7 @@
log10(x),
ln(x)
FROM v;
- x | log | log10 | ln
-----------+--------------------+--------------------+--------------------
- 1 | 0.0000000000000000 | 0.0000000000000000 | 0.0000000000000000
- 4.2 | 0.6232492903979005 | 0.6232492903979005 | 1.4350845252893226
- Infinity | Infinity | Infinity | Infinity
- NaN | NaN | NaN | NaN
-(4 rows)
-
-SELECT ln('0'::numeric);
-ERROR: cannot take logarithm of zero
-SELECT ln('-1'::numeric);
-ERROR: cannot take logarithm of a negative number
-SELECT ln('-inf'::numeric);
... |
| 59/6716 |
Fix cascading standby reconnect failure after archive fallback |
|
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-05-16 04:08:36.068240000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/postgres_fdw-running/regress/results/postgres_fdw.out 2026-05-16 04:17:43.7874540...
@@ -12983,8 +12983,7 @@
FROM postgres_fdw_get_connections(true);
server_name | closed | remote_backend_pid
-------------+--------+--------------------
- loopback | t | t
-(1 row)
+(0 rows)
-- Clean up
\set VERBOSITY default |
| 59/6763 |
Improve pg_stat_statements scalability |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/pg_stat_statements/expected/select.out C:/cirrus/build/testrun/pg_stat_st...
--- C:/cirrus/contrib/pg_stat_statements/expected/select.out 2026-05-16 01:56:37.299312800 +0000
+++ C:/cirrus/build/testrun/pg_stat_statements/regress/results/select.out 2026-05-16 02:07:07.619251900 +0000
@@ -206,686 +206,7 @@
DEALLOCATE pgss_test;
SELECT calls, rows, query FROM pg_stat_statements ORDER BY query COLLATE "C";
- calls | rows | query
--------+------+------------------------------------------------------------------------------
- 1 | 1 | PREPARE pgss_test (int) AS SELECT $1, $2 LIMIT $3
- 4 | 4 | SELECT $1 +
- | | -- but this one will appear +
- | | AS "text"
- 2 | 2 | SELECT $1 + $2
- 3 | 3 | SELECT $1 + $2 + $3 AS "add"
- 1 | 1 | SELECT $1 AS "float"
- 2 | 2 | SELECT $1 AS "int"
- 2 | 2 | SELECT $1 AS "int" LIMIT $2
- 2 | 0 | SELECT $1 AS "int" OFFSET $2
- 6 | 0 | SELECT $1 AS "int" OFFSET $2 LIMIT $3
... |
|
macOS - Sequoia - Meson |
| regress |
diff -U3 /Users/admin/pgsql/contrib/pg_stat_statements/expected/select.out /Users/admin/pgsql/build/testrun/pg_stat_stat...
--- /Users/admin/pgsql/contrib/pg_stat_statements/expected/select.out 2026-05-16 01:56:37
+++ /Users/admin/pgsql/build/testrun/pg_stat_statements/regress/results/select.out 2026-05-16 02:07:10
@@ -206,686 +206,7 @@
DEALLOCATE pgss_test;
SELECT calls, rows, query FROM pg_stat_statements ORDER BY query COLLATE "C";
- calls | rows | query
--------+------+------------------------------------------------------------------------------
- 1 | 1 | PREPARE pgss_test (int) AS SELECT $1, $2 LIMIT $3
- 4 | 4 | SELECT $1 +
- | | -- but this one will appear +
- | | AS "text"
- 2 | 2 | SELECT $1 + $2
- 3 | 3 | SELECT $1 + $2 + $3 AS "add"
- 1 | 1 | SELECT $1 AS "float"
- 2 | 2 | SELECT $1 AS "int"
- 2 | 2 | SELECT $1 AS "int" LIMIT $2
- 2 | 0 | SELECT $1 AS "int" OFFSET $2
- 6 | 0 | SELECT $1 AS "int" OFFSET $2 LIMIT $3
... |
|
Linux - Debian Trixie - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/pg_stat_statements/expected/select.out /tmp/cirrus-ci-build/build/testrun/pg_stat_...
--- /tmp/cirrus-ci-build/contrib/pg_stat_statements/expected/select.out 2026-05-16 01:56:35.704218398 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_stat_statements/regress/results/select.out 2026-05-16 02:04:04.775585043 +0000
@@ -206,686 +206,7 @@
DEALLOCATE pgss_test;
SELECT calls, rows, query FROM pg_stat_statements ORDER BY query COLLATE "C";
- calls | rows | query
--------+------+------------------------------------------------------------------------------
- 1 | 1 | PREPARE pgss_test (int) AS SELECT $1, $2 LIMIT $3
- 4 | 4 | SELECT $1 +
- | | -- but this one will appear +
- | | AS "text"
- 2 | 2 | SELECT $1 + $2
- 3 | 3 | SELECT $1 + $2 + $3 AS "add"
- 1 | 1 | SELECT $1 AS "float"
- 2 | 2 | SELECT $1 AS "int"
- 2 | 2 | SELECT $1 AS "int" LIMIT $2
- 2 | 0 | SELECT $1 AS "int" OFFSET $2
- 6 | 0 | SELECT $1 AS "int" OFFSET $2 LIMIT $3
... |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/pg_stat_statements/expected/select.out /tmp/cirrus-ci-build/build/testrun/pg_stat_...
--- /tmp/cirrus-ci-build/contrib/pg_stat_statements/expected/select.out 2026-05-16 01:56:42.706355000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_stat_statements/regress/results/select.out 2026-05-16 02:01:35.836226000 +0000
@@ -206,686 +206,10 @@
DEALLOCATE pgss_test;
SELECT calls, rows, query FROM pg_stat_statements ORDER BY query COLLATE "C";
- calls | rows | query
--------+------+------------------------------------------------------------------------------
- 1 | 1 | PREPARE pgss_test (int) AS SELECT $1, $2 LIMIT $3
- 4 | 4 | SELECT $1 +
- | | -- but this one will appear +
- | | AS "text"
- 2 | 2 | SELECT $1 + $2
- 3 | 3 | SELECT $1 + $2 + $3 AS "add"
- 1 | 1 | SELECT $1 AS "float"
- 2 | 2 | SELECT $1 AS "int"
- 2 | 2 | SELECT $1 AS "int" LIMIT $2
- 2 | 0 | SELECT $1 AS "int" OFFSET $2
- 6 | 0 | SELECT $1 AS "int" OFFSET $2 LIMIT $3
... |
|
Linux - Debian Trixie - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/pg_stat_statements/expected/select.out /tmp/cirrus-ci-build/contrib/pg_stat_statem...
--- /tmp/cirrus-ci-build/contrib/pg_stat_statements/expected/select.out 2026-05-16 01:56:38.827313650 +0000
+++ /tmp/cirrus-ci-build/contrib/pg_stat_statements/results/select.out 2026-05-16 02:03:22.114700841 +0000
@@ -206,686 +206,7 @@
DEALLOCATE pgss_test;
SELECT calls, rows, query FROM pg_stat_statements ORDER BY query COLLATE "C";
- calls | rows | query
--------+------+------------------------------------------------------------------------------
- 1 | 1 | PREPARE pgss_test (int) AS SELECT $1, $2 LIMIT $3
- 4 | 4 | SELECT $1 +
- | | -- but this one will appear +
- | | AS "text"
- 2 | 2 | SELECT $1 + $2
- 3 | 3 | SELECT $1 + $2 + $3 AS "add"
- 1 | 1 | SELECT $1 AS "float"
- 2 | 2 | SELECT $1 AS "int"
- 2 | 2 | SELECT $1 AS "int" LIMIT $2
- 2 | 0 | SELECT $1 AS "int" OFFSET $2
- 6 | 0 | SELECT $1 AS "int" OFFSET $2 LIMIT $3
... |
|
OpenBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/contrib/pg_stat_statements/expected/select.out /home/postgres/postgres/build/testrun/pg...
--- /home/postgres/postgres/contrib/pg_stat_statements/expected/select.out Sat May 16 01:56:41 2026
+++ /home/postgres/postgres/build/testrun/pg_stat_statements/regress/results/select.out Sat May 16 02:03:21 2026
@@ -206,686 +206,7 @@
DEALLOCATE pgss_test;
SELECT calls, rows, query FROM pg_stat_statements ORDER BY query COLLATE "C";
- calls | rows | query
--------+------+------------------------------------------------------------------------------
- 1 | 1 | PREPARE pgss_test (int) AS SELECT $1, $2 LIMIT $3
- 4 | 4 | SELECT $1 +
- | | -- but this one will appear +
- | | AS "text"
- 2 | 2 | SELECT $1 + $2
- 3 | 3 | SELECT $1 + $2 + $3 AS "add"
- 1 | 1 | SELECT $1 AS "float"
- 2 | 2 | SELECT $1 AS "int"
- 2 | 2 | SELECT $1 AS "int" LIMIT $2
- 2 | 0 | SELECT $1 AS "int" OFFSET $2
- 6 | 0 | SELECT $1 AS "int" OFFSET $2 LIMIT $3
... |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/contrib/pg_stat_statements/expected/select.out /home/postgres/postgres/build/testrun/pg...
--- /home/postgres/postgres/contrib/pg_stat_statements/expected/select.out 2026-05-16 01:56:43.441298145 +0000
+++ /home/postgres/postgres/build/testrun/pg_stat_statements/regress/results/select.out 2026-05-16 02:01:09.913088107 +0...
@@ -206,686 +206,7 @@
DEALLOCATE pgss_test;
SELECT calls, rows, query FROM pg_stat_statements ORDER BY query COLLATE "C";
- calls | rows | query
--------+------+------------------------------------------------------------------------------
- 1 | 1 | PREPARE pgss_test (int) AS SELECT $1, $2 LIMIT $3
- 4 | 4 | SELECT $1 +
- | | -- but this one will appear +
- | | AS "text"
- 2 | 2 | SELECT $1 + $2
- 3 | 3 | SELECT $1 + $2 + $3 AS "add"
- 1 | 1 | SELECT $1 AS "float"
- 2 | 2 | SELECT $1 AS "int"
- 2 | 2 | SELECT $1 AS "int" LIMIT $2
- 2 | 0 | SELECT $1 AS "int" OFFSET $2
- 6 | 0 | SELECT $1 AS "int" OFFSET $2 LIMIT $3
... |
| 59/6753 |
RFC: EXPLAIN ANALYZE wait event reporting |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/explain.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg...
--- /tmp/cirrus-ci-build/src/test/regress/expected/explain.out 2026-05-15 23:51:22.468422000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/explain.out 2026-05-15 23:56:48.016148000 ...
@@ -116,14 +116,18 @@
-- WAITS option
select explain_filter('explain (analyze, waits, costs off, summary off, timing off, buffers off) select pg_sleep(0.01)'...
- explain_filter
------------------------------------------
+ explain_filter
+--------------------------------------------
Result (actual rows=N.N loops=N)
Wait Events:
Timeout:PgSleep calls=N time=N.N ms
Statement Wait Events:
+ IPC:BgworkerShutdown calls=N time=N.N ms
+ IPC:ExecuteGather calls=N time=N.N ms
+ IPC:ParallelFinish calls=N time=N.N ms
Timeout:PgSleep calls=N time=N.N ms
-(5 rows)
... |
| 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-05-15 23:51:22.468422000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/explain.out 2026-05-15 23:58:07.31189900...
@@ -116,19 +116,23 @@
-- WAITS option
select explain_filter('explain (analyze, waits, costs off, summary off, timing off, buffers off) select pg_sleep(0.01)'...
- explain_filter
------------------------------------------
+ explain_filter
+--------------------------------------------
Result (actual rows=N.N loops=N)
Wait Events:
Timeout:PgSleep calls=N time=N.N ms
Statement Wait Events:
+ IPC:ExecuteGather calls=N time=N.N ms
+ IPC:BgworkerShutdown calls=N time=N.N ms
Timeout:PgSleep calls=N time=N.N ms
-(5 rows)
+ IPC:ParallelFinish calls=N time=N.N ms
... |
| 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-05-15 23:51:22.468422000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/explain.out 2026-05-15 23:56:42.698118000 +0000
@@ -123,7 +123,8 @@
Timeout:PgSleep calls=N time=N.N ms
Statement Wait Events:
Timeout:PgSleep calls=N time=N.N ms
-(5 rows)
+ IO:DsmAllocate calls=N time=N.N ms
+(6 rows)
select explain_filter_to_json('explain (analyze, waits, costs off, summary off, timing off, buffers off, format json) s...
?column?
@@ -254,7 +255,7 @@
from pgsleep_wait;
parallel rescan waits accumulated
-----------------------------------
- t
+
(1 row)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/explain.out /tmp/cirrus-ci-build/build/testrun/test_plan_advice/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/explain.out 2026-05-15 23:51:22.468422000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/explain.out 2026-05-15 23:56:49....
@@ -123,7 +123,8 @@
Timeout:PgSleep calls=N time=N.N ms
Statement Wait Events:
Timeout:PgSleep calls=N time=N.N ms
-(5 rows)
+ IO:DsmAllocate calls=N time=N.N ms
+(6 rows)
select explain_filter_to_json('explain (analyze, waits, costs off, summary off, timing off, buffers off, format json) s...
?column?
@@ -146,15 +147,15 @@
end;
$$;
select explain_filter_to_json('explain (analyze, waits, costs off, summary off, timing off, buffers off, format json) s...
- ?column?
-----------------------------------------------------------------------------------
- {"Time": 0.0, "Calls": 0, "Wait Event": "PgSleep", "Wait Event Type": "Timeout"}
... |
| 59/5679 |
Add comments about fire_triggers argument in ri_triggers.c |
|
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-05-15 23:38:36.507914000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/postgres_fdw-running/regress/results/postgres_fdw.out 2026-05-15 23:47:12.1165830...
@@ -12966,8 +12966,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
@@ -12983,8 +12982,7 @@
FROM postgres_fdw_get_connections(true);
server_name | closed | remote_backend_pid
-------------+--------+--------------------
- loopback | t | t
-(1 row)
+(0 rows)
... |
| 59/6547 |
Release postmaster working memory context in slotsync worker |
| 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-05-15 23:38:36.507914000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/postgres_fdw-running/regress/results/postgres_fdw.out 2026-05-15 23:47:12.1165830...
@@ -12966,8 +12966,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
@@ -12983,8 +12982,7 @@
FROM postgres_fdw_get_connections(true);
server_name | closed | remote_backend_pid
-------------+--------+--------------------
- loopback | t | t
-(1 row)
+(0 rows)
... |
| 59/6274 |
Add a greedy join search algorithm to handle large join problems |
| 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-05-15 23:38:36.507914000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/postgres_fdw-running/regress/results/postgres_fdw.out 2026-05-15 23:47:12.1165830...
@@ -12966,8 +12966,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
@@ -12983,8 +12982,7 @@
FROM postgres_fdw_get_connections(true);
server_name | closed | remote_backend_pid
-------------+--------+--------------------
- loopback | t | t
-(1 row)
+(0 rows)
... |
| 59/6397 |
extended statistic (examine_variable) ignored CollateExpr |
|
Linux - Debian Trixie - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out /tmp/cirrus-ci-build/build/testrun/pg_upgra...
--- /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out 2026-05-15 22:13:00.003948155 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/collate.icu.utf8.out 2026-05-15 22:16:20.8...
@@ -3321,15 +3321,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out /tmp/cirrus-ci-build/build/testrun/recovery...
--- /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out 2026-05-15 22:13:00.003948155 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/collate.icu.utf8.out 2026-05-15 22:17:55...
@@ -3321,15 +3321,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out /tmp/cirrus-ci-build/build/testrun/regress/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out 2026-05-15 22:13:00.003948155 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/collate.icu.utf8.out 2026-05-15 22:16:17.094675949 +0000
@@ -3321,15 +3321,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out /tmp/cirrus-ci-build/build/testrun/test_pla...
--- /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out 2026-05-15 22:13:00.003948155 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/collate.icu.utf8.out 2026-05-15 ...
@@ -3321,15 +3321,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
|
macOS - Sequoia - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/collate.icu.utf8.out /Users/admin/pgsql/build/testrun/pg_upgrade/0...
--- /Users/admin/pgsql/src/test/regress/expected/collate.icu.utf8.out 2026-05-15 22:13:01
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/collate.icu.utf8.out 2026-05-15 22:17:35
@@ -3321,15 +3321,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/collate.icu.utf8.out /Users/admin/pgsql/build/testrun/recovery/027...
--- /Users/admin/pgsql/src/test/regress/expected/collate.icu.utf8.out 2026-05-15 22:13:01
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/collate.icu.utf8.out 2026-05-15 22:20:49
@@ -3321,15 +3321,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/collate.icu.utf8.out /Users/admin/pgsql/build/testrun/regress/regr...
--- /Users/admin/pgsql/src/test/regress/expected/collate.icu.utf8.out 2026-05-15 22:13:01
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/collate.icu.utf8.out 2026-05-15 22:17:29
@@ -3321,15 +3321,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/collate.icu.utf8.out /Users/admin/pgsql/build/testrun/test_plan_ad...
--- /Users/admin/pgsql/src/test/regress/expected/collate.icu.utf8.out 2026-05-15 22:13:01
+++ /Users/admin/pgsql/build/testrun/test_plan_advice/001_replan_regress/data/results/collate.icu.utf8.out 2026-05-15 22...
@@ -3321,15 +3321,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/collate.icu.utf8.out /home/postgres/postgres/build/testrun/pg...
--- /home/postgres/postgres/src/test/regress/expected/collate.icu.utf8.out 2026-05-15 22:13:28.525096246 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/collate.icu.utf8.out 2026-05-15 22:16:1...
@@ -3321,15 +3321,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out /tmp/cirrus-ci-build/build/testrun/pg_upgra...
--- /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out 2026-05-15 22:13:16.985472000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/collate.icu.utf8.out 2026-05-15 22:16:28.9...
@@ -3321,15 +3321,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out /tmp/cirrus-ci-build/build/testrun/recovery...
--- /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out 2026-05-15 22:13:16.985472000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/collate.icu.utf8.out 2026-05-15 22:18:10...
@@ -3321,15 +3321,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out /tmp/cirrus-ci-build/build/testrun/regress/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out 2026-05-15 22:13:16.985472000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/collate.icu.utf8.out 2026-05-15 22:16:23.767570000 +0000
@@ -3321,15 +3321,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out /tmp/cirrus-ci-build/build/testrun/test_pla...
--- /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out 2026-05-15 22:13:16.985472000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/collate.icu.utf8.out 2026-05-15 ...
@@ -3321,15 +3321,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
|
Linux - Debian Trixie - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp...
--- /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out 2026-05-15 22:13:14.141404063 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/collate.icu.utf8.out 2026-05-15 22:20:41.984142334 +0000
@@ -3321,15 +3321,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out /tmp/cirrus-ci-build/src/test/modules/test_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out 2026-05-15 22:13:14.141404063 +0000
+++ /tmp/cirrus-ci-build/src/test/modules/test_plan_advice/tmp_check/results/collate.icu.utf8.out 2026-05-15 22:23:21.26...
@@ -3321,15 +3321,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out /tmp/cirrus-ci-build/src/test/recovery/tmp_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out 2026-05-15 22:13:14.141404063 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/collate.icu.utf8.out 2026-05-15 22:22:11.244103875 +0000
@@ -3321,15 +3321,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out /tmp/cirrus-ci-build/src/test/regress/resul...
--- /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out 2026-05-15 22:13:14.141404063 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/collate.icu.utf8.out 2026-05-15 22:18:02.308055377 +0000
@@ -3321,15 +3321,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
| 59/6728 |
md: measure just FileSync() for pgstat_io without FileClose() |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/isolation/expected/timeouts.out /home/postgres/postgres/build/testrun/isolatio...
--- /home/postgres/postgres/src/test/isolation/expected/timeouts.out 2026-05-15 18:20:58.795072892 +0000
+++ /home/postgres/postgres/build/testrun/isolation/isolation/results/timeouts.out 2026-05-15 18:24:02.247015390 +0000
@@ -78,4 +78,4 @@
step slto: SET lock_timeout = '10s'; SET statement_timeout = '10ms';
step update: DELETE FROM accounts WHERE accountid = 'checking'; <waiting ...>
step update: <... completed>
-ERROR: canceling statement due to statement timeout
+ERROR: canceling statement due to user request |
| 59/6706 |
DOCS: Describe some missing parameters on CREATE/ALTER PUBLICATION pages |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out /tmp/cirrus-ci-build/build/testrun/regress-runn...
--- /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out 2026-05-15 14:21:38.346257000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress-running/regress/results/create_index.out 2026-05-15 14:31:11.859703000 +0...
@@ -2056,7 +2056,7 @@
QUERY PLAN
----------------------------------------------------------------------------
Aggregate
- -> Index Only Scan using tenk1_thous_tenthous on tenk1 t1
+ -> Seq Scan on tenk1 t1
Filter: ((thousand = 42) OR (thousand = (SubPlan expr_1)))
SubPlan expr_1
-> Limit
@@ -2225,9 +2225,11 @@
Filter: ((thousand = 42) OR (thousand = 41) OR (tenthous = 2))
-> Bitmap Index Scan on tenk2_hundred
Index Cond: (hundred = 42)
- -> Index Only Scan using tenk1_hundred on tenk1
- Index Cond: (hundred = 42)
-(9 rows)
+ -> Bitmap Heap Scan on tenk1
... |
| 59/4942 |
Avoid orphaned objects dependencies, take 3 |
|
Linux - Debian Trixie - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/multirangetypes.out /tmp/cirrus-ci-build/build/testrun/pg_upgrad...
--- /tmp/cirrus-ci-build/src/test/regress/expected/multirangetypes.out 2026-05-15 08:18:27.295090186 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/multirangetypes.out 2026-05-15 08:22:20.48...
@@ -3273,261 +3273,7 @@
grant create on schema mr_sch to regress_mr;
set role regress_mr;
create type mytype as range (subtype=int4, multirange_type_name=mr_sch.mr_type);
-reset role;
-drop type mytype;
-drop schema mr_sch;
-drop role regress_mr;
---
--- Test polymorphic type system
---
-create function anyarray_anymultirange_func(a anyarray, r anymultirange)
- returns anyelement as 'select $1[1] + lower($2);' language sql;
-select anyarray_anymultirange_func(ARRAY[1,2], int4multirange(int4range(10,20)));
- anyarray_anymultirange_func
------------------------------
- 11
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/multirangetypes.out /tmp/cirrus-ci-build/build/testrun/recovery/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/multirangetypes.out 2026-05-15 08:18:27.295090186 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/multirangetypes.out 2026-05-15 08:23:23....
@@ -3273,261 +3273,7 @@
grant create on schema mr_sch to regress_mr;
set role regress_mr;
create type mytype as range (subtype=int4, multirange_type_name=mr_sch.mr_type);
-reset role;
-drop type mytype;
-drop schema mr_sch;
-drop role regress_mr;
---
--- Test polymorphic type system
---
-create function anyarray_anymultirange_func(a anyarray, r anymultirange)
- returns anyelement as 'select $1[1] + lower($2);' language sql;
-select anyarray_anymultirange_func(ARRAY[1,2], int4multirange(int4range(10,20)));
- anyarray_anymultirange_func
------------------------------
- 11
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/multirangetypes.out /tmp/cirrus-ci-build/build/testrun/regress/r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/multirangetypes.out 2026-05-15 08:18:27.295090186 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/multirangetypes.out 2026-05-15 08:22:18.682995699 +0000
@@ -3273,261 +3273,7 @@
grant create on schema mr_sch to regress_mr;
set role regress_mr;
create type mytype as range (subtype=int4, multirange_type_name=mr_sch.mr_type);
-reset role;
-drop type mytype;
-drop schema mr_sch;
-drop role regress_mr;
---
--- Test polymorphic type system
---
-create function anyarray_anymultirange_func(a anyarray, r anymultirange)
- returns anyelement as 'select $1[1] + lower($2);' language sql;
-select anyarray_anymultirange_func(ARRAY[1,2], int4multirange(int4range(10,20)));
- anyarray_anymultirange_func
------------------------------
- 11
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/multirangetypes.out /tmp/cirrus-ci-build/build/testrun/test_plan...
--- /tmp/cirrus-ci-build/src/test/regress/expected/multirangetypes.out 2026-05-15 08:18:27.295090186 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/multirangetypes.out 2026-05-15 0...
@@ -3273,261 +3273,7 @@
grant create on schema mr_sch to regress_mr;
set role regress_mr;
create type mytype as range (subtype=int4, multirange_type_name=mr_sch.mr_type);
-reset role;
-drop type mytype;
-drop schema mr_sch;
-drop role regress_mr;
---
--- Test polymorphic type system
---
-create function anyarray_anymultirange_func(a anyarray, r anymultirange)
- returns anyelement as 'select $1[1] + lower($2);' language sql;
-select anyarray_anymultirange_func(ARRAY[1,2], int4multirange(int4range(10,20)));
- anyarray_anymultirange_func
------------------------------
- 11
... |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/multirangetypes.out C:/cirrus/build/testrun/pg_upgrade/...
--- C:/cirrus/src/test/regress/expected/multirangetypes.out 2026-05-15 08:19:23.811383400 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/multirangetypes.out 2026-05-15 08:22:13.251172400 +00...
@@ -3273,261 +3273,7 @@
grant create on schema mr_sch to regress_mr;
set role regress_mr;
create type mytype as range (subtype=int4, multirange_type_name=mr_sch.mr_type);
-reset role;
-drop type mytype;
-drop schema mr_sch;
-drop role regress_mr;
---
--- Test polymorphic type system
---
-create function anyarray_anymultirange_func(a anyarray, r anymultirange)
- returns anyelement as 'select $1[1] + lower($2);' language sql;
-select anyarray_anymultirange_func(ARRAY[1,2], int4multirange(int4range(10,20)));
- anyarray_anymultirange_func
------------------------------
- 11
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/multirangetypes.out C:/cirrus/build/testrun/recovery/02...
--- C:/cirrus/src/test/regress/expected/multirangetypes.out 2026-05-15 08:19:23.811383400 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/multirangetypes.out 2026-05-15 08:25:00.676872300 +...
@@ -3273,261 +3273,7 @@
grant create on schema mr_sch to regress_mr;
set role regress_mr;
create type mytype as range (subtype=int4, multirange_type_name=mr_sch.mr_type);
-reset role;
-drop type mytype;
-drop schema mr_sch;
-drop role regress_mr;
---
--- Test polymorphic type system
---
-create function anyarray_anymultirange_func(a anyarray, r anymultirange)
- returns anyelement as 'select $1[1] + lower($2);' language sql;
-select anyarray_anymultirange_func(ARRAY[1,2], int4multirange(int4range(10,20)));
- anyarray_anymultirange_func
------------------------------
- 11
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/multirangetypes.out C:/cirrus/build/testrun/regress/reg...
--- C:/cirrus/src/test/regress/expected/multirangetypes.out 2026-05-15 08:19:23.811383400 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/multirangetypes.out 2026-05-15 08:22:11.702825800 +0000
@@ -3273,261 +3273,7 @@
grant create on schema mr_sch to regress_mr;
set role regress_mr;
create type mytype as range (subtype=int4, multirange_type_name=mr_sch.mr_type);
-reset role;
-drop type mytype;
-drop schema mr_sch;
-drop role regress_mr;
---
--- Test polymorphic type system
---
-create function anyarray_anymultirange_func(a anyarray, r anymultirange)
- returns anyelement as 'select $1[1] + lower($2);' language sql;
-select anyarray_anymultirange_func(ARRAY[1,2], int4multirange(int4range(10,20)));
- anyarray_anymultirange_func
------------------------------
- 11
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/multirangetypes.out C:/cirrus/build/testrun/test_plan_a...
--- C:/cirrus/src/test/regress/expected/multirangetypes.out 2026-05-15 08:19:23.811383400 +0000
+++ C:/cirrus/build/testrun/test_plan_advice/001_replan_regress/data/results/multirangetypes.out 2026-05-15 08:22:11.968...
@@ -3273,261 +3273,7 @@
grant create on schema mr_sch to regress_mr;
set role regress_mr;
create type mytype as range (subtype=int4, multirange_type_name=mr_sch.mr_type);
-reset role;
-drop type mytype;
-drop schema mr_sch;
-drop role regress_mr;
---
--- Test polymorphic type system
---
-create function anyarray_anymultirange_func(a anyarray, r anymultirange)
- returns anyelement as 'select $1[1] + lower($2);' language sql;
-select anyarray_anymultirange_func(ARRAY[1,2], int4multirange(int4range(10,20)));
- anyarray_anymultirange_func
------------------------------
- 11
... |
|
macOS - Sequoia - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/multirangetypes.out /Users/admin/pgsql/build/testrun/pg_upgrade/00...
--- /Users/admin/pgsql/src/test/regress/expected/multirangetypes.out 2026-05-15 08:18:13
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/multirangetypes.out 2026-05-15 08:22:43
@@ -3273,261 +3273,7 @@
grant create on schema mr_sch to regress_mr;
set role regress_mr;
create type mytype as range (subtype=int4, multirange_type_name=mr_sch.mr_type);
-reset role;
-drop type mytype;
-drop schema mr_sch;
-drop role regress_mr;
---
--- Test polymorphic type system
---
-create function anyarray_anymultirange_func(a anyarray, r anymultirange)
- returns anyelement as 'select $1[1] + lower($2);' language sql;
-select anyarray_anymultirange_func(ARRAY[1,2], int4multirange(int4range(10,20)));
- anyarray_anymultirange_func
------------------------------
- 11
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/multirangetypes.out /Users/admin/pgsql/build/testrun/recovery/027_...
--- /Users/admin/pgsql/src/test/regress/expected/multirangetypes.out 2026-05-15 08:18:13
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/multirangetypes.out 2026-05-15 08:25:27
@@ -3273,261 +3273,7 @@
grant create on schema mr_sch to regress_mr;
set role regress_mr;
create type mytype as range (subtype=int4, multirange_type_name=mr_sch.mr_type);
-reset role;
-drop type mytype;
-drop schema mr_sch;
-drop role regress_mr;
---
--- Test polymorphic type system
---
-create function anyarray_anymultirange_func(a anyarray, r anymultirange)
- returns anyelement as 'select $1[1] + lower($2);' language sql;
-select anyarray_anymultirange_func(ARRAY[1,2], int4multirange(int4range(10,20)));
- anyarray_anymultirange_func
------------------------------
- 11
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/multirangetypes.out /Users/admin/pgsql/build/testrun/regress/regre...
--- /Users/admin/pgsql/src/test/regress/expected/multirangetypes.out 2026-05-15 08:18:13
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/multirangetypes.out 2026-05-15 08:22:43
@@ -3273,261 +3273,7 @@
grant create on schema mr_sch to regress_mr;
set role regress_mr;
create type mytype as range (subtype=int4, multirange_type_name=mr_sch.mr_type);
-reset role;
-drop type mytype;
-drop schema mr_sch;
-drop role regress_mr;
---
--- Test polymorphic type system
---
-create function anyarray_anymultirange_func(a anyarray, r anymultirange)
- returns anyelement as 'select $1[1] + lower($2);' language sql;
-select anyarray_anymultirange_func(ARRAY[1,2], int4multirange(int4range(10,20)));
- anyarray_anymultirange_func
------------------------------
- 11
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/multirangetypes.out /Users/admin/pgsql/build/testrun/test_plan_adv...
--- /Users/admin/pgsql/src/test/regress/expected/multirangetypes.out 2026-05-15 08:18:13
+++ /Users/admin/pgsql/build/testrun/test_plan_advice/001_replan_regress/data/results/multirangetypes.out 2026-05-15 08:...
@@ -3273,261 +3273,7 @@
grant create on schema mr_sch to regress_mr;
set role regress_mr;
create type mytype as range (subtype=int4, multirange_type_name=mr_sch.mr_type);
-reset role;
-drop type mytype;
-drop schema mr_sch;
-drop role regress_mr;
---
--- Test polymorphic type system
---
-create function anyarray_anymultirange_func(a anyarray, r anymultirange)
- returns anyelement as 'select $1[1] + lower($2);' language sql;
-select anyarray_anymultirange_func(ARRAY[1,2], int4multirange(int4range(10,20)));
- anyarray_anymultirange_func
------------------------------
- 11
... |
|
Linux - Debian Trixie - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/multirangetypes.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/multirangetypes.out 2026-05-15 08:18:35.237868857 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/multirangetypes.out 2026-05-15 08:24:08.306138098 +0000
@@ -3273,261 +3273,7 @@
grant create on schema mr_sch to regress_mr;
set role regress_mr;
create type mytype as range (subtype=int4, multirange_type_name=mr_sch.mr_type);
-reset role;
-drop type mytype;
-drop schema mr_sch;
-drop role regress_mr;
---
--- Test polymorphic type system
---
-create function anyarray_anymultirange_func(a anyarray, r anymultirange)
- returns anyelement as 'select $1[1] + lower($2);' language sql;
-select anyarray_anymultirange_func(ARRAY[1,2], int4multirange(int4range(10,20)));
- anyarray_anymultirange_func
------------------------------
- 11
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/multirangetypes.out /tmp/cirrus-ci-build/src/test/modules/test_p...
--- /tmp/cirrus-ci-build/src/test/regress/expected/multirangetypes.out 2026-05-15 08:18:35.237868857 +0000
+++ /tmp/cirrus-ci-build/src/test/modules/test_plan_advice/tmp_check/results/multirangetypes.out 2026-05-15 08:25:36.238...
@@ -3273,261 +3273,7 @@
grant create on schema mr_sch to regress_mr;
set role regress_mr;
create type mytype as range (subtype=int4, multirange_type_name=mr_sch.mr_type);
-reset role;
-drop type mytype;
-drop schema mr_sch;
-drop role regress_mr;
---
--- Test polymorphic type system
---
-create function anyarray_anymultirange_func(a anyarray, r anymultirange)
- returns anyelement as 'select $1[1] + lower($2);' language sql;
-select anyarray_anymultirange_func(ARRAY[1,2], int4multirange(int4range(10,20)));
- anyarray_anymultirange_func
------------------------------
- 11
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/multirangetypes.out /tmp/cirrus-ci-build/src/test/recovery/tmp_c...
--- /tmp/cirrus-ci-build/src/test/regress/expected/multirangetypes.out 2026-05-15 08:18:35.237868857 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/multirangetypes.out 2026-05-15 08:26:12.298401885 +0000
@@ -3273,261 +3273,7 @@
grant create on schema mr_sch to regress_mr;
set role regress_mr;
create type mytype as range (subtype=int4, multirange_type_name=mr_sch.mr_type);
-reset role;
-drop type mytype;
-drop schema mr_sch;
-drop role regress_mr;
---
--- Test polymorphic type system
---
-create function anyarray_anymultirange_func(a anyarray, r anymultirange)
- returns anyelement as 'select $1[1] + lower($2);' language sql;
-select anyarray_anymultirange_func(ARRAY[1,2], int4multirange(int4range(10,20)));
- anyarray_anymultirange_func
------------------------------
- 11
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/multirangetypes.out /tmp/cirrus-ci-build/src/test/regress/result...
--- /tmp/cirrus-ci-build/src/test/regress/expected/multirangetypes.out 2026-05-15 08:18:35.237868857 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/multirangetypes.out 2026-05-15 08:23:12.538040636 +0000
@@ -3273,261 +3273,7 @@
grant create on schema mr_sch to regress_mr;
set role regress_mr;
create type mytype as range (subtype=int4, multirange_type_name=mr_sch.mr_type);
-reset role;
-drop type mytype;
-drop schema mr_sch;
-drop role regress_mr;
---
--- Test polymorphic type system
---
-create function anyarray_anymultirange_func(a anyarray, r anymultirange)
- returns anyelement as 'select $1[1] + lower($2);' language sql;
-select anyarray_anymultirange_func(ARRAY[1,2], int4multirange(int4range(10,20)));
- anyarray_anymultirange_func
------------------------------
- 11
... |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/multirangetypes.out /tmp/cirrus-ci-build/build/testrun/pg_upgrad...
--- /tmp/cirrus-ci-build/src/test/regress/expected/multirangetypes.out 2026-05-15 08:18:49.600790000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/multirangetypes.out 2026-05-15 08:20:50.16...
@@ -3273,261 +3273,7 @@
grant create on schema mr_sch to regress_mr;
set role regress_mr;
create type mytype as range (subtype=int4, multirange_type_name=mr_sch.mr_type);
-reset role;
-drop type mytype;
-drop schema mr_sch;
-drop role regress_mr;
---
--- Test polymorphic type system
---
-create function anyarray_anymultirange_func(a anyarray, r anymultirange)
- returns anyelement as 'select $1[1] + lower($2);' language sql;
-select anyarray_anymultirange_func(ARRAY[1,2], int4multirange(int4range(10,20)));
- anyarray_anymultirange_func
------------------------------
- 11
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/multirangetypes.out /tmp/cirrus-ci-build/build/testrun/recovery/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/multirangetypes.out 2026-05-15 08:18:49.600790000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/multirangetypes.out 2026-05-15 08:21:40....
@@ -3273,261 +3273,7 @@
grant create on schema mr_sch to regress_mr;
set role regress_mr;
create type mytype as range (subtype=int4, multirange_type_name=mr_sch.mr_type);
-reset role;
-drop type mytype;
-drop schema mr_sch;
-drop role regress_mr;
---
--- Test polymorphic type system
---
-create function anyarray_anymultirange_func(a anyarray, r anymultirange)
- returns anyelement as 'select $1[1] + lower($2);' language sql;
-select anyarray_anymultirange_func(ARRAY[1,2], int4multirange(int4range(10,20)));
- anyarray_anymultirange_func
------------------------------
- 11
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/multirangetypes.out /tmp/cirrus-ci-build/build/testrun/regress/r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/multirangetypes.out 2026-05-15 08:18:49.600790000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/multirangetypes.out 2026-05-15 08:20:50.725271000 +0000
@@ -3273,261 +3273,7 @@
grant create on schema mr_sch to regress_mr;
set role regress_mr;
create type mytype as range (subtype=int4, multirange_type_name=mr_sch.mr_type);
-reset role;
-drop type mytype;
-drop schema mr_sch;
-drop role regress_mr;
---
--- Test polymorphic type system
---
-create function anyarray_anymultirange_func(a anyarray, r anymultirange)
- returns anyelement as 'select $1[1] + lower($2);' language sql;
-select anyarray_anymultirange_func(ARRAY[1,2], int4multirange(int4range(10,20)));
- anyarray_anymultirange_func
------------------------------
- 11
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/multirangetypes.out /tmp/cirrus-ci-build/build/testrun/test_plan...
--- /tmp/cirrus-ci-build/src/test/regress/expected/multirangetypes.out 2026-05-15 08:18:49.600790000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/multirangetypes.out 2026-05-15 0...
@@ -3273,261 +3273,7 @@
grant create on schema mr_sch to regress_mr;
set role regress_mr;
create type mytype as range (subtype=int4, multirange_type_name=mr_sch.mr_type);
-reset role;
-drop type mytype;
-drop schema mr_sch;
-drop role regress_mr;
---
--- Test polymorphic type system
---
-create function anyarray_anymultirange_func(a anyarray, r anymultirange)
- returns anyelement as 'select $1[1] + lower($2);' language sql;
-select anyarray_anymultirange_func(ARRAY[1,2], int4multirange(int4range(10,20)));
- anyarray_anymultirange_func
------------------------------
- 11
... |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/multirangetypes.out /home/postgres/postgres/build/testrun/pg_...
--- /home/postgres/postgres/src/test/regress/expected/multirangetypes.out 2026-05-15 08:18:49.126759215 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/multirangetypes.out 2026-05-15 08:21:13...
@@ -3273,261 +3273,7 @@
grant create on schema mr_sch to regress_mr;
set role regress_mr;
create type mytype as range (subtype=int4, multirange_type_name=mr_sch.mr_type);
-reset role;
-drop type mytype;
-drop schema mr_sch;
-drop role regress_mr;
---
--- Test polymorphic type system
---
-create function anyarray_anymultirange_func(a anyarray, r anymultirange)
- returns anyelement as 'select $1[1] + lower($2);' language sql;
-select anyarray_anymultirange_func(ARRAY[1,2], int4multirange(int4range(10,20)));
- anyarray_anymultirange_func
------------------------------
- 11
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/polygon.out /home/postgres/postgres/build/testrun/recovery/02...
--- /home/postgres/postgres/src/test/regress/expected/polygon.out 2026-05-15 08:18:49.189042870 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/polygon.out 2026-05-15 08:21:44.28721...
@@ -295,40 +295,10 @@
CREATE TEMP TABLE quad_poly_tbl_ord_idx2 AS
SELECT rank() OVER (ORDER BY p <-> point '123,456') n, p <-> point '123,456' dist, id
FROM quad_poly_tbl WHERE p <@ polygon '((300,300),(400,600),(600,500),(700,200))';
-SELECT *
-FROM quad_poly_tbl_ord_seq2 seq FULL JOIN quad_poly_tbl_ord_idx2 idx
- ON seq.n = idx.n AND seq.id = idx.id AND
- (seq.dist = idx.dist OR seq.dist IS NULL AND idx.dist IS NULL)
-WHERE seq.id IS NULL OR idx.id IS NULL;
- n | dist | id | n | dist | id
----+------+----+---+------+----
-(0 rows)
-
-RESET enable_seqscan;
-RESET enable_indexscan;
-RESET enable_bitmapscan;
--- test non-error-throwing API for some core types
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/multirangetypes.out /home/postgres/postgres/build/testrun/reg...
--- /home/postgres/postgres/src/test/regress/expected/multirangetypes.out 2026-05-15 08:18:49.126759215 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/multirangetypes.out 2026-05-15 08:21:06.457120808 +000...
@@ -3273,261 +3273,7 @@
grant create on schema mr_sch to regress_mr;
set role regress_mr;
create type mytype as range (subtype=int4, multirange_type_name=mr_sch.mr_type);
-reset role;
-drop type mytype;
-drop schema mr_sch;
-drop role regress_mr;
---
--- Test polymorphic type system
---
-create function anyarray_anymultirange_func(a anyarray, r anymultirange)
- returns anyelement as 'select $1[1] + lower($2);' language sql;
-select anyarray_anymultirange_func(ARRAY[1,2], int4multirange(int4range(10,20)));
- anyarray_anymultirange_func
------------------------------
- 11
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/multirangetypes.out /home/postgres/postgres/build/testrun/tes...
--- /home/postgres/postgres/src/test/regress/expected/multirangetypes.out 2026-05-15 08:18:49.126759215 +0000
+++ /home/postgres/postgres/build/testrun/test_plan_advice/001_replan_regress/data/results/multirangetypes.out 2026-05-1...
@@ -3273,261 +3273,7 @@
grant create on schema mr_sch to regress_mr;
set role regress_mr;
create type mytype as range (subtype=int4, multirange_type_name=mr_sch.mr_type);
-reset role;
-drop type mytype;
-drop schema mr_sch;
-drop role regress_mr;
---
--- Test polymorphic type system
---
-create function anyarray_anymultirange_func(a anyarray, r anymultirange)
- returns anyelement as 'select $1[1] + lower($2);' language sql;
-select anyarray_anymultirange_func(ARRAY[1,2], int4multirange(int4range(10,20)));
- anyarray_anymultirange_func
------------------------------
- 11
... |
| 59/6736 |
COPY ON_CONFLICT TABLE; save duplicated record to another table. |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/copy.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_up...
--- /tmp/cirrus-ci-build/src/test/regress/expected/copy.out 2026-05-15 06:38:14.793771000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/copy.out 2026-05-15 06:40:56.622499000 +00...
@@ -433,189 +433,7 @@
create unique index tab_progress_reporting_idx1 on tab_progress_reporting(name);
create temp table conflict_tbl(copy_tbl oid, filename text, lineno bigint, line text);
copy tab_progress_reporting from stdin(on_conflict table, conflict_table 'conflict_tbl');
-INFO: progress: {"type": "PIPE", "command": "COPY FROM", "relname": "tab_progress_reporting", "tuples_skipped": 3, "ha...
-NOTICE: 3 rows were saved to conflict table "conflict_tbl" due to unique constraint violation
-drop index tab_progress_reporting_idx1;
-drop table conflict_tbl;
--- Generate COPY FROM report with PIPE, with some skipped tuples.
-copy tab_progress_reporting from stdin(on_error ignore);
-NOTICE: 2 rows were skipped due to data type incompatibility
-INFO: progress: {"type": "PIPE", "command": "COPY FROM", "relname": "tab_progress_reporting", "tuples_skipped": 2, "ha...
-drop trigger check_after_tab_progress_reporting on tab_progress_reporting;
-drop function notice_after_tab_progress_reporting();
-drop table tab_progress_reporting;
--- Test header matching feature
-create table header_copytest (
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/copy.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/copy.out 2026-05-15 06:38:14.793771000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/copy.out 2026-05-15 06:42:02.694142000 +...
@@ -433,189 +433,7 @@
create unique index tab_progress_reporting_idx1 on tab_progress_reporting(name);
create temp table conflict_tbl(copy_tbl oid, filename text, lineno bigint, line text);
copy tab_progress_reporting from stdin(on_conflict table, conflict_table 'conflict_tbl');
-INFO: progress: {"type": "PIPE", "command": "COPY FROM", "relname": "tab_progress_reporting", "tuples_skipped": 3, "ha...
-NOTICE: 3 rows were saved to conflict table "conflict_tbl" due to unique constraint violation
-drop index tab_progress_reporting_idx1;
-drop table conflict_tbl;
--- Generate COPY FROM report with PIPE, with some skipped tuples.
-copy tab_progress_reporting from stdin(on_error ignore);
-NOTICE: 2 rows were skipped due to data type incompatibility
-INFO: progress: {"type": "PIPE", "command": "COPY FROM", "relname": "tab_progress_reporting", "tuples_skipped": 2, "ha...
-drop trigger check_after_tab_progress_reporting on tab_progress_reporting;
-drop function notice_after_tab_progress_reporting();
-drop table tab_progress_reporting;
--- Test header matching feature
-create table header_copytest (
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/copy.out /tmp/cirrus-ci-build/build/testrun/regress/regress/resu...
--- /tmp/cirrus-ci-build/src/test/regress/expected/copy.out 2026-05-15 06:38:14.793771000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/copy.out 2026-05-15 06:40:53.309693000 +0000
@@ -433,189 +433,7 @@
create unique index tab_progress_reporting_idx1 on tab_progress_reporting(name);
create temp table conflict_tbl(copy_tbl oid, filename text, lineno bigint, line text);
copy tab_progress_reporting from stdin(on_conflict table, conflict_table 'conflict_tbl');
-INFO: progress: {"type": "PIPE", "command": "COPY FROM", "relname": "tab_progress_reporting", "tuples_skipped": 3, "ha...
-NOTICE: 3 rows were saved to conflict table "conflict_tbl" due to unique constraint violation
-drop index tab_progress_reporting_idx1;
-drop table conflict_tbl;
--- Generate COPY FROM report with PIPE, with some skipped tuples.
-copy tab_progress_reporting from stdin(on_error ignore);
-NOTICE: 2 rows were skipped due to data type incompatibility
-INFO: progress: {"type": "PIPE", "command": "COPY FROM", "relname": "tab_progress_reporting", "tuples_skipped": 2, "ha...
-drop trigger check_after_tab_progress_reporting on tab_progress_reporting;
-drop function notice_after_tab_progress_reporting();
-drop table tab_progress_reporting;
--- Test header matching feature
-create table header_copytest (
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/copy.out /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001...
--- /tmp/cirrus-ci-build/src/test/regress/expected/copy.out 2026-05-15 06:38:14.793771000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/copy.out 2026-05-15 06:40:54.791...
@@ -433,189 +433,7 @@
create unique index tab_progress_reporting_idx1 on tab_progress_reporting(name);
create temp table conflict_tbl(copy_tbl oid, filename text, lineno bigint, line text);
copy tab_progress_reporting from stdin(on_conflict table, conflict_table 'conflict_tbl');
-INFO: progress: {"type": "PIPE", "command": "COPY FROM", "relname": "tab_progress_reporting", "tuples_skipped": 3, "ha...
-NOTICE: 3 rows were saved to conflict table "conflict_tbl" due to unique constraint violation
-drop index tab_progress_reporting_idx1;
-drop table conflict_tbl;
--- Generate COPY FROM report with PIPE, with some skipped tuples.
-copy tab_progress_reporting from stdin(on_error ignore);
-NOTICE: 2 rows were skipped due to data type incompatibility
-INFO: progress: {"type": "PIPE", "command": "COPY FROM", "relname": "tab_progress_reporting", "tuples_skipped": 2, "ha...
-drop trigger check_after_tab_progress_reporting on tab_progress_reporting;
-drop function notice_after_tab_progress_reporting();
-drop table tab_progress_reporting;
--- Test header matching feature
-create table header_copytest (
... |
| 59/6543 |
synchronized_standby_slots behavior inconsistent with quorum-based synchronous replication |
|
Linux - Debian Trixie - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/modules/unsafe_tests/expected/guc_privs.out /tmp/cirrus-ci-build/build/testrun/un...
--- /tmp/cirrus-ci-build/src/test/modules/unsafe_tests/expected/guc_privs.out 2026-05-14 22:17:48.362604916 +0000
+++ /tmp/cirrus-ci-build/build/testrun/unsafe_tests/regress/results/guc_privs.out 2026-05-14 22:23:25.206712477 +0000
@@ -590,8 +590,7 @@
-- Cannot set synchronized_standby_slots to an invalid slot name
ALTER SYSTEM SET synchronized_standby_slots='invalid*';
ERROR: invalid value for parameter "synchronized_standby_slots": "invalid*"
-DETAIL: replication slot name "invalid*" contains invalid character
-HINT: Replication slot names may only contain lower case letters, numbers, and the underscore character.
+DETAIL: syntax error at or near "*"
-- Can set synchronized_standby_slots to a non-existent slot name
ALTER SYSTEM SET synchronized_standby_slots='missing';
-- Reset the GUC |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/modules/unsafe_tests/expected/guc_privs.out C:/cirrus/build/testrun/unsa...
--- C:/cirrus/src/test/modules/unsafe_tests/expected/guc_privs.out 2026-05-14 22:17:52.064471300 +0000
+++ C:/cirrus/build/testrun/unsafe_tests/regress/results/guc_privs.out 2026-05-14 22:27:54.474189700 +0000
@@ -590,8 +590,7 @@
-- Cannot set synchronized_standby_slots to an invalid slot name
ALTER SYSTEM SET synchronized_standby_slots='invalid*';
ERROR: invalid value for parameter "synchronized_standby_slots": "invalid*"
-DETAIL: replication slot name "invalid*" contains invalid character
-HINT: Replication slot names may only contain lower case letters, numbers, and the underscore character.
+DETAIL: syntax error at or near "*"
-- Can set synchronized_standby_slots to a non-existent slot name
ALTER SYSTEM SET synchronized_standby_slots='missing';
-- Reset the GUC |
|
macOS - Sequoia - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/modules/unsafe_tests/expected/guc_privs.out /Users/admin/pgsql/build/testrun/unsafe...
--- /Users/admin/pgsql/src/test/modules/unsafe_tests/expected/guc_privs.out 2026-05-14 22:17:48
+++ /Users/admin/pgsql/build/testrun/unsafe_tests/regress/results/guc_privs.out 2026-05-14 22:23:48
@@ -590,8 +590,7 @@
-- Cannot set synchronized_standby_slots to an invalid slot name
ALTER SYSTEM SET synchronized_standby_slots='invalid*';
ERROR: invalid value for parameter "synchronized_standby_slots": "invalid*"
-DETAIL: replication slot name "invalid*" contains invalid character
-HINT: Replication slot names may only contain lower case letters, numbers, and the underscore character.
+DETAIL: syntax error at or near "*"
-- Can set synchronized_standby_slots to a non-existent slot name
ALTER SYSTEM SET synchronized_standby_slots='missing';
-- Reset the GUC |
|
OpenBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/modules/unsafe_tests/expected/guc_privs.out /home/postgres/postgres/build/test...
--- /home/postgres/postgres/src/test/modules/unsafe_tests/expected/guc_privs.out Thu May 14 22:17:58 2026
+++ /home/postgres/postgres/build/testrun/unsafe_tests/regress/results/guc_privs.out Thu May 14 22:23:43 2026
@@ -590,8 +590,7 @@
-- Cannot set synchronized_standby_slots to an invalid slot name
ALTER SYSTEM SET synchronized_standby_slots='invalid*';
ERROR: invalid value for parameter "synchronized_standby_slots": "invalid*"
-DETAIL: replication slot name "invalid*" contains invalid character
-HINT: Replication slot names may only contain lower case letters, numbers, and the underscore character.
+DETAIL: syntax error at or near "*"
-- Can set synchronized_standby_slots to a non-existent slot name
ALTER SYSTEM SET synchronized_standby_slots='missing';
-- Reset the GUC |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/modules/unsafe_tests/expected/guc_privs.out /home/postgres/postgres/build/test...
--- /home/postgres/postgres/src/test/modules/unsafe_tests/expected/guc_privs.out 2026-05-14 22:18:15.672309464 +0000
+++ /home/postgres/postgres/build/testrun/unsafe_tests/regress/results/guc_privs.out 2026-05-14 22:21:41.094440996 +0000
@@ -590,8 +590,7 @@
-- Cannot set synchronized_standby_slots to an invalid slot name
ALTER SYSTEM SET synchronized_standby_slots='invalid*';
ERROR: invalid value for parameter "synchronized_standby_slots": "invalid*"
-DETAIL: replication slot name "invalid*" contains invalid character
-HINT: Replication slot names may only contain lower case letters, numbers, and the underscore character.
+DETAIL: syntax error at or near "*"
-- Can set synchronized_standby_slots to a non-existent slot name
ALTER SYSTEM SET synchronized_standby_slots='missing';
-- Reset the GUC |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/modules/unsafe_tests/expected/guc_privs.out /tmp/cirrus-ci-build/build/testrun/un...
--- /tmp/cirrus-ci-build/src/test/modules/unsafe_tests/expected/guc_privs.out 2026-05-14 22:17:49.105302000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/unsafe_tests/regress/results/guc_privs.out 2026-05-14 22:23:13.767972000 +0000
@@ -590,8 +590,7 @@
-- Cannot set synchronized_standby_slots to an invalid slot name
ALTER SYSTEM SET synchronized_standby_slots='invalid*';
ERROR: invalid value for parameter "synchronized_standby_slots": "invalid*"
-DETAIL: replication slot name "invalid*" contains invalid character
-HINT: Replication slot names may only contain lower case letters, numbers, and the underscore character.
+DETAIL: syntax error at or near "*"
-- Can set synchronized_standby_slots to a non-existent slot name
ALTER SYSTEM SET synchronized_standby_slots='missing';
-- Reset the GUC |
|
Linux - Debian Trixie - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/modules/unsafe_tests/expected/guc_privs.out /tmp/cirrus-ci-build/src/test/modules...
--- /tmp/cirrus-ci-build/src/test/modules/unsafe_tests/expected/guc_privs.out 2026-05-14 22:18:01.570099310 +0000
+++ /tmp/cirrus-ci-build/src/test/modules/unsafe_tests/results/guc_privs.out 2026-05-14 22:26:10.337148477 +0000
@@ -590,8 +590,7 @@
-- Cannot set synchronized_standby_slots to an invalid slot name
ALTER SYSTEM SET synchronized_standby_slots='invalid*';
ERROR: invalid value for parameter "synchronized_standby_slots": "invalid*"
-DETAIL: replication slot name "invalid*" contains invalid character
-HINT: Replication slot names may only contain lower case letters, numbers, and the underscore character.
+DETAIL: syntax error at or near "*"
-- Can set synchronized_standby_slots to a non-existent slot name
ALTER SYSTEM SET synchronized_standby_slots='missing';
-- Reset the GUC |