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.
| 56/6087 |
CREATE TABLE LIKE INCLUDING TRIGGERS |
 |
macOS - Sonoma - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/triggers.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_up...
--- /Users/admin/pgsql/src/test/regress/expected/triggers.out 2025-10-20 00:10:12
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/triggers.out 2025-10-20 00:12:40
@@ -407,6 +407,7 @@
--create table like tests
COMMENT ON TRIGGER before_ins_stmt_trig ON main_table IS 'trigger before_ins_stmt_trig';
CREATE TABLE main_table1(c INT, LIKE main_table INCLUDING TRIGGERS INCLUDING COMMENTS);
+ERROR: trigger "after_ins_stmt_trig" for relation "main_table1" already exists
\d main_table
Table "public.main_table"
Column | Type | Collation | Nullable | Default
@@ -424,22 +425,6 @@
before_upd_a_stmt_trig BEFORE UPDATE OF a ON main_table FOR EACH STATEMENT EXECUTE FUNCTION trigger_func('before_up...
\d main_table1
- Table "public.main_table1"
- Column | Type | Collation | Nullable | Default
---------+---------+-----------+----------+---------
- c | integer | | |
- a | integer | | |
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/triggers.out /Users/admin/pgsql/build/testrun/recovery/027_stream_...
--- /Users/admin/pgsql/src/test/regress/expected/triggers.out 2025-10-20 00:10:12
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/triggers.out 2025-10-20 00:13:26
@@ -431,10 +431,10 @@
a | integer | | |
b | integer | | |
Triggers:
+ "" AFTER UPDATE OF b ON main_table1 FOR EACH STATEMENT EXECUTE FUNCTION trigger_func('after_upd_b_stmt')
after_ins_stmt_trig AFTER INSERT ON main_table1 FOR EACH STATEMENT EXECUTE FUNCTION trigger_func('after_ins_stmt')
after_upd_a_b_row_trig AFTER UPDATE OF a, b ON main_table1 FOR EACH ROW EXECUTE FUNCTION trigger_func('after_upd_a_...
after_upd_b_row_trig AFTER UPDATE OF b ON main_table1 FOR EACH ROW EXECUTE FUNCTION trigger_func('after_upd_b_row')
- after_upd_b_stmt_trig AFTER UPDATE OF b ON main_table1 FOR EACH STATEMENT EXECUTE FUNCTION trigger_func('after_upd_...
after_upd_stmt_trig AFTER UPDATE ON main_table1 FOR EACH STATEMENT EXECUTE FUNCTION trigger_func('after_upd_stmt')
before_ins_stmt_trig BEFORE INSERT ON main_table1 FOR EACH STATEMENT EXECUTE FUNCTION trigger_func('before_ins_stmt...
before_upd_a_row_trig BEFORE UPDATE OF a ON main_table1 FOR EACH ROW EXECUTE FUNCTION trigger_func('before_upd_a_ro... |
|
Windows - Server 2019, MinGW64 - Meson |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/triggers.out C:/cirrus/build/testrun/recovery/027_strea...
--- C:/cirrus/src/test/regress/expected/triggers.out 2025-10-20 00:11:19.336175400 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/triggers.out 2025-10-20 00:20:14.286004100 +0000
@@ -431,12 +431,12 @@
a | integer | | |
b | integer | | |
Triggers:
+ "" BEFORE INSERT ON main_table1 FOR EACH STATEMENT EXECUTE FUNCTION trigger_func('before_ins_stmt')
+ " :varnosyn 2 :varattnosyn -6 :location -1} {RELABELTYPE :arg {C" AFTER UPDATE ON main_table1 FOR EACH STATEMENT EX...
after_ins_stmt_trig AFTER INSERT ON main_table1 FOR EACH STATEMENT EXECUTE FUNCTION trigger_func('after_ins_stmt')
after_upd_a_b_row_trig AFTER UPDATE OF a, b ON main_table1 FOR EACH ROW EXECUTE FUNCTION trigger_func('after_upd_a_...
after_upd_b_row_trig AFTER UPDATE OF b ON main_table1 FOR EACH ROW EXECUTE FUNCTION trigger_func('after_upd_b_row')
after_upd_b_stmt_trig AFTER UPDATE OF b ON main_table1 FOR EACH STATEMENT EXECUTE FUNCTION trigger_func('after_upd_...
- after_upd_stmt_trig AFTER UPDATE ON main_table1 FOR EACH STATEMENT EXECUTE FUNCTION trigger_func('after_upd_stmt')
- before_ins_stmt_trig BEFORE INSERT ON main_table1 FOR EACH STATEMENT EXECUTE FUNCTION trigger_func('before_ins_stmt...
before_upd_a_row_trig BEFORE UPDATE OF a ON main_table1 FOR EACH ROW EXECUTE FUNCTION trigger_func('before_upd_a_ro...
before_upd_a_stmt_trig BEFORE UPDATE OF a ON main_table1 FOR EACH STATEMENT EXECUTE FUNCTION trigger_func('before_u...
|
|
Windows - Server 2019, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/triggers.out C:/cirrus/build/testrun/pg_upgrade/002_pg_...
--- C:/cirrus/src/test/regress/expected/triggers.out 2025-10-20 00:11:06.183476400 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/triggers.out 2025-10-20 00:13:59.528191500 +0000
@@ -407,6 +407,7 @@
--create table like tests
COMMENT ON TRIGGER before_ins_stmt_trig ON main_table IS 'trigger before_ins_stmt_trig';
CREATE TABLE main_table1(c INT, LIKE main_table INCLUDING TRIGGERS INCLUDING COMMENTS);
+ERROR: trigger "before_upd_a_row_trig" for relation "main_table1" already exists
\d main_table
Table "public.main_table"
Column | Type | Collation | Nullable | Default
@@ -424,22 +425,6 @@
before_upd_a_stmt_trig BEFORE UPDATE OF a ON main_table FOR EACH STATEMENT EXECUTE FUNCTION trigger_func('before_up...
\d main_table1
- Table "public.main_table1"
- Column | Type | Collation | Nullable | Default
---------+---------+-----------+----------+---------
- c | integer | | |
- a | integer | | |
... |
|
Linux - Debian Bookworm - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check/re...
--- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out 2025-10-20 00:11:16.735712693 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/triggers.out 2025-10-20 00:21:11.523163146 +0000
@@ -431,13 +431,13 @@
a | integer | | |
b | integer | | |
Triggers:
+ "" BEFORE UPDATE OF a ON main_table1 FOR EACH ROW EXECUTE FUNCTION trigger_func('before_upd_a_row')
after_ins_stmt_trig AFTER INSERT ON main_table1 FOR EACH STATEMENT EXECUTE FUNCTION trigger_func('after_ins_stmt')
after_upd_a_b_row_trig AFTER UPDATE OF a, b ON main_table1 FOR EACH ROW EXECUTE FUNCTION trigger_func('after_upd_a_...
after_upd_b_row_trig AFTER UPDATE OF b ON main_table1 FOR EACH ROW EXECUTE FUNCTION trigger_func('after_upd_b_row')
after_upd_b_stmt_trig AFTER UPDATE OF b ON main_table1 FOR EACH STATEMENT EXECUTE FUNCTION trigger_func('after_upd_...
after_upd_stmt_trig AFTER UPDATE ON main_table1 FOR EACH STATEMENT EXECUTE FUNCTION trigger_func('after_upd_stmt')
before_ins_stmt_trig BEFORE INSERT ON main_table1 FOR EACH STATEMENT EXECUTE FUNCTION trigger_func('before_ins_stmt...
- before_upd_a_row_trig BEFORE UPDATE OF a ON main_table1 FOR EACH ROW EXECUTE FUNCTION trigger_func('before_upd_a_ro...
before_upd_a_stmt_trig BEFORE UPDATE OF a ON main_table1 FOR EACH STATEMENT EXECUTE FUNCTION trigger_func('before_u...
\dd before_ins_stmt_trig |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_p...
--- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out 2025-10-20 00:11:02.370976000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/triggers.out 2025-10-20 00:13:28.412526000...
@@ -407,6 +407,7 @@
--create table like tests
COMMENT ON TRIGGER before_ins_stmt_trig ON main_table IS 'trigger before_ins_stmt_trig';
CREATE TABLE main_table1(c INT, LIKE main_table INCLUDING TRIGGERS INCLUDING COMMENTS);
+ERROR: trigger "after_ins_stmt_trig" for relation "main_table1" already exists
\d main_table
Table "public.main_table"
Column | Type | Collation | Nullable | Default
@@ -424,22 +425,6 @@
before_upd_a_stmt_trig BEFORE UPDATE OF a ON main_table FOR EACH STATEMENT EXECUTE FUNCTION trigger_func('before_up...
\d main_table1
- Table "public.main_table1"
- Column | Type | Collation | Nullable | Default
---------+---------+-----------+----------+---------
- c | integer | | |
- a | integer | | |
... |
| 56/6132 |
Issue with synced logical replication slot during switchover |
|
Windows - Server 2019, MinGW64 - Meson |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/rules.out C:/cirrus/build/testrun/pg_upgrade/002_pg_upg...
--- C:/cirrus/src/test/regress/expected/rules.out 2025-10-19 23:58:37.803422000 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/rules.out 2025-10-20 00:04:20.428370700 +0000
@@ -1507,8 +1507,9 @@
l.conflicting,
l.invalidation_reason,
l.failover,
- l.synced
- FROM (pg_get_replication_slots() l(slot_name, plugin, slot_type, datoid, temporary, active, active_pid, xmin, catalo...
+ l.synced,
+ l.allow_overwrite
+ FROM (pg_get_replication_slots() l(slot_name, plugin, slot_type, datoid, temporary, active, active_pid, xmin, catalo...
LEFT JOIN pg_database d ON ((l.datoid = d.oid)));
pg_roles| SELECT pg_authid.rolname,
pg_authid.rolsuper, |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/rules.out C:/cirrus/build/testrun/recovery/027_stream_r...
--- C:/cirrus/src/test/regress/expected/rules.out 2025-10-19 23:58:37.803422000 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/rules.out 2025-10-20 00:07:32.105784700 +0000
@@ -1507,8 +1507,9 @@
l.conflicting,
l.invalidation_reason,
l.failover,
- l.synced
- FROM (pg_get_replication_slots() l(slot_name, plugin, slot_type, datoid, temporary, active, active_pid, xmin, catalo...
+ l.synced,
+ l.allow_overwrite
+ FROM (pg_get_replication_slots() l(slot_name, plugin, slot_type, datoid, temporary, active, active_pid, xmin, catalo...
LEFT JOIN pg_database d ON ((l.datoid = d.oid)));
pg_roles| SELECT pg_authid.rolname,
pg_authid.rolsuper, |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/rules.out C:/cirrus/build/testrun/regress/regress/resul...
--- C:/cirrus/src/test/regress/expected/rules.out 2025-10-19 23:58:37.803422000 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/rules.out 2025-10-20 00:04:18.781404800 +0000
@@ -1507,8 +1507,9 @@
l.conflicting,
l.invalidation_reason,
l.failover,
- l.synced
- FROM (pg_get_replication_slots() l(slot_name, plugin, slot_type, datoid, temporary, active, active_pid, xmin, catalo...
+ l.synced,
+ l.allow_overwrite
+ FROM (pg_get_replication_slots() l(slot_name, plugin, slot_type, datoid, temporary, active, active_pid, xmin, catalo...
LEFT JOIN pg_database d ON ((l.datoid = d.oid)));
pg_roles| SELECT pg_authid.rolname,
pg_authid.rolsuper, |
|
Windows - Server 2019, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/rules.out C:/cirrus/build/testrun/pg_upgrade/002_pg_upg...
--- C:/cirrus/src/test/regress/expected/rules.out 2025-10-19 23:58:20.508046900 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/rules.out 2025-10-20 00:01:53.294408500 +0000
@@ -1507,8 +1507,9 @@
l.conflicting,
l.invalidation_reason,
l.failover,
- l.synced
- FROM (pg_get_replication_slots() l(slot_name, plugin, slot_type, datoid, temporary, active, active_pid, xmin, catalo...
+ l.synced,
+ l.allow_overwrite
+ FROM (pg_get_replication_slots() l(slot_name, plugin, slot_type, datoid, temporary, active, active_pid, xmin, catalo...
LEFT JOIN pg_database d ON ((l.datoid = d.oid)));
pg_roles| SELECT pg_authid.rolname,
pg_authid.rolsuper, |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/rules.out C:/cirrus/build/testrun/recovery/027_stream_r...
--- C:/cirrus/src/test/regress/expected/rules.out 2025-10-19 23:58:20.508046900 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/rules.out 2025-10-20 00:04:32.003921700 +0000
@@ -1507,8 +1507,9 @@
l.conflicting,
l.invalidation_reason,
l.failover,
- l.synced
- FROM (pg_get_replication_slots() l(slot_name, plugin, slot_type, datoid, temporary, active, active_pid, xmin, catalo...
+ l.synced,
+ l.allow_overwrite
+ FROM (pg_get_replication_slots() l(slot_name, plugin, slot_type, datoid, temporary, active, active_pid, xmin, catalo...
LEFT JOIN pg_database d ON ((l.datoid = d.oid)));
pg_roles| SELECT pg_authid.rolname,
pg_authid.rolsuper, |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/rules.out C:/cirrus/build/testrun/regress/regress/resul...
--- C:/cirrus/src/test/regress/expected/rules.out 2025-10-19 23:58:20.508046900 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/rules.out 2025-10-20 00:01:48.050775100 +0000
@@ -1507,8 +1507,9 @@
l.conflicting,
l.invalidation_reason,
l.failover,
- l.synced
- FROM (pg_get_replication_slots() l(slot_name, plugin, slot_type, datoid, temporary, active, active_pid, xmin, catalo...
+ l.synced,
+ l.allow_overwrite
+ FROM (pg_get_replication_slots() l(slot_name, plugin, slot_type, datoid, temporary, active, active_pid, xmin, catalo...
LEFT JOIN pg_database d ON ((l.datoid = d.oid)));
pg_roles| SELECT pg_authid.rolname,
pg_authid.rolsuper, |
|
macOS - Sonoma - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/rules.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgra...
--- /Users/admin/pgsql/src/test/regress/expected/rules.out 2025-10-19 23:58:09
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/rules.out 2025-10-20 00:00:53
@@ -1507,8 +1507,9 @@
l.conflicting,
l.invalidation_reason,
l.failover,
- l.synced
- FROM (pg_get_replication_slots() l(slot_name, plugin, slot_type, datoid, temporary, active, active_pid, xmin, catalo...
+ l.synced,
+ l.allow_overwrite
+ FROM (pg_get_replication_slots() l(slot_name, plugin, slot_type, datoid, temporary, active, active_pid, xmin, catalo...
LEFT JOIN pg_database d ON ((l.datoid = d.oid)));
pg_roles| SELECT pg_authid.rolname,
pg_authid.rolsuper, |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/rules.out /Users/admin/pgsql/build/testrun/recovery/027_stream_reg...
--- /Users/admin/pgsql/src/test/regress/expected/rules.out 2025-10-19 23:58:09
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/rules.out 2025-10-20 00:02:13
@@ -1507,8 +1507,9 @@
l.conflicting,
l.invalidation_reason,
l.failover,
- l.synced
- FROM (pg_get_replication_slots() l(slot_name, plugin, slot_type, datoid, temporary, active, active_pid, xmin, catalo...
+ l.synced,
+ l.allow_overwrite
+ FROM (pg_get_replication_slots() l(slot_name, plugin, slot_type, datoid, temporary, active, active_pid, xmin, catalo...
LEFT JOIN pg_database d ON ((l.datoid = d.oid)));
pg_roles| SELECT pg_authid.rolname,
pg_authid.rolsuper, |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/rules.out /Users/admin/pgsql/build/testrun/regress/regress/results...
--- /Users/admin/pgsql/src/test/regress/expected/rules.out 2025-10-19 23:58:09
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/rules.out 2025-10-20 00:00:48
@@ -1507,8 +1507,9 @@
l.conflicting,
l.invalidation_reason,
l.failover,
- l.synced
- FROM (pg_get_replication_slots() l(slot_name, plugin, slot_type, datoid, temporary, active, active_pid, xmin, catalo...
+ l.synced,
+ l.allow_overwrite
+ FROM (pg_get_replication_slots() l(slot_name, plugin, slot_type, datoid, temporary, active, active_pid, xmin, catalo...
LEFT JOIN pg_database d ON ((l.datoid = d.oid)));
pg_roles| SELECT pg_authid.rolname,
pg_authid.rolsuper, |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/rules.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_u...
--- /tmp/cirrus-ci-build/src/test/regress/expected/rules.out 2025-10-19 23:58:17.860259496 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/rules.out 2025-10-20 00:03:13.168537590 +0...
@@ -1507,8 +1507,9 @@
l.conflicting,
l.invalidation_reason,
l.failover,
- l.synced
- FROM (pg_get_replication_slots() l(slot_name, plugin, slot_type, datoid, temporary, active, active_pid, xmin, catalo...
+ l.synced,
+ l.allow_overwrite
+ FROM (pg_get_replication_slots() l(slot_name, plugin, slot_type, datoid, temporary, active, active_pid, xmin, catalo...
LEFT JOIN pg_database d ON ((l.datoid = d.oid)));
pg_roles| SELECT pg_authid.rolname,
pg_authid.rolsuper, |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/rules.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stream...
--- /tmp/cirrus-ci-build/src/test/regress/expected/rules.out 2025-10-19 23:58:17.860259496 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/rules.out 2025-10-20 00:04:33.748552330 ...
@@ -1507,8 +1507,9 @@
l.conflicting,
l.invalidation_reason,
l.failover,
- l.synced
- FROM (pg_get_replication_slots() l(slot_name, plugin, slot_type, datoid, temporary, active, active_pid, xmin, catalo...
+ l.synced,
+ l.allow_overwrite
+ FROM (pg_get_replication_slots() l(slot_name, plugin, slot_type, datoid, temporary, active, active_pid, xmin, catalo...
LEFT JOIN pg_database d ON ((l.datoid = d.oid)));
pg_roles| SELECT pg_authid.rolname,
pg_authid.rolsuper, |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/rules.out /tmp/cirrus-ci-build/build/testrun/regress/regress/res...
--- /tmp/cirrus-ci-build/src/test/regress/expected/rules.out 2025-10-19 23:58:17.860259496 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/rules.out 2025-10-20 00:03:11.888537390 +0000
@@ -1507,8 +1507,9 @@
l.conflicting,
l.invalidation_reason,
l.failover,
- l.synced
- FROM (pg_get_replication_slots() l(slot_name, plugin, slot_type, datoid, temporary, active, active_pid, xmin, catalo...
+ l.synced,
+ l.allow_overwrite
+ FROM (pg_get_replication_slots() l(slot_name, plugin, slot_type, datoid, temporary, active, active_pid, xmin, catalo...
LEFT JOIN pg_database d ON ((l.datoid = d.oid)));
pg_roles| SELECT pg_authid.rolname,
pg_authid.rolsuper, |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/rules.out /home/postgres/postgres/build/testrun/pg_upgrade/00...
--- /home/postgres/postgres/src/test/regress/expected/rules.out 2025-10-19 23:58:46.814625184 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/rules.out 2025-10-20 00:01:12.542778241...
@@ -1507,8 +1507,9 @@
l.conflicting,
l.invalidation_reason,
l.failover,
- l.synced
- FROM (pg_get_replication_slots() l(slot_name, plugin, slot_type, datoid, temporary, active, active_pid, xmin, catalo...
+ l.synced,
+ l.allow_overwrite
+ FROM (pg_get_replication_slots() l(slot_name, plugin, slot_type, datoid, temporary, active, active_pid, xmin, catalo...
LEFT JOIN pg_database d ON ((l.datoid = d.oid)));
pg_roles| SELECT pg_authid.rolname,
pg_authid.rolsuper, |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/rules.out /home/postgres/postgres/build/testrun/recovery/027_...
--- /home/postgres/postgres/src/test/regress/expected/rules.out 2025-10-19 23:58:46.814625184 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/rules.out 2025-10-20 00:01:51.0437435...
@@ -1507,8 +1507,9 @@
l.conflicting,
l.invalidation_reason,
l.failover,
- l.synced
- FROM (pg_get_replication_slots() l(slot_name, plugin, slot_type, datoid, temporary, active, active_pid, xmin, catalo...
+ l.synced,
+ l.allow_overwrite
+ FROM (pg_get_replication_slots() l(slot_name, plugin, slot_type, datoid, temporary, active, active_pid, xmin, catalo...
LEFT JOIN pg_database d ON ((l.datoid = d.oid)));
pg_roles| SELECT pg_authid.rolname,
pg_authid.rolsuper, |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/rules.out /home/postgres/postgres/build/testrun/regress/regre...
--- /home/postgres/postgres/src/test/regress/expected/rules.out 2025-10-19 23:58:46.814625184 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/rules.out 2025-10-20 00:01:06.967138671 +0000
@@ -1507,8 +1507,9 @@
l.conflicting,
l.invalidation_reason,
l.failover,
- l.synced
- FROM (pg_get_replication_slots() l(slot_name, plugin, slot_type, datoid, temporary, active, active_pid, xmin, catalo...
+ l.synced,
+ l.allow_overwrite
+ FROM (pg_get_replication_slots() l(slot_name, plugin, slot_type, datoid, temporary, active, active_pid, xmin, catalo...
LEFT JOIN pg_database d ON ((l.datoid = d.oid)));
pg_roles| SELECT pg_authid.rolname,
pg_authid.rolsuper, |
|
OpenBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/rules.out /home/postgres/postgres/build/testrun/pg_upgrade/00...
--- /home/postgres/postgres/src/test/regress/expected/rules.out Sun Oct 19 23:58:35 2025
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/rules.out Mon Oct 20 00:01:42 2025
@@ -1507,8 +1507,9 @@
l.conflicting,
l.invalidation_reason,
l.failover,
- l.synced
- FROM (pg_get_replication_slots() l(slot_name, plugin, slot_type, datoid, temporary, active, active_pid, xmin, catalo...
+ l.synced,
+ l.allow_overwrite
+ FROM (pg_get_replication_slots() l(slot_name, plugin, slot_type, datoid, temporary, active, active_pid, xmin, catalo...
LEFT JOIN pg_database d ON ((l.datoid = d.oid)));
pg_roles| SELECT pg_authid.rolname,
pg_authid.rolsuper, |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/rules.out /home/postgres/postgres/build/testrun/recovery/027_...
--- /home/postgres/postgres/src/test/regress/expected/rules.out Sun Oct 19 23:58:35 2025
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/rules.out Mon Oct 20 00:03:36 2025
@@ -1507,8 +1507,9 @@
l.conflicting,
l.invalidation_reason,
l.failover,
- l.synced
- FROM (pg_get_replication_slots() l(slot_name, plugin, slot_type, datoid, temporary, active, active_pid, xmin, catalo...
+ l.synced,
+ l.allow_overwrite
+ FROM (pg_get_replication_slots() l(slot_name, plugin, slot_type, datoid, temporary, active, active_pid, xmin, catalo...
LEFT JOIN pg_database d ON ((l.datoid = d.oid)));
pg_roles| SELECT pg_authid.rolname,
pg_authid.rolsuper, |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/rules.out /home/postgres/postgres/build/testrun/regress/regre...
--- /home/postgres/postgres/src/test/regress/expected/rules.out Sun Oct 19 23:58:35 2025
+++ /home/postgres/postgres/build/testrun/regress/regress/results/rules.out Mon Oct 20 00:01:31 2025
@@ -1507,8 +1507,9 @@
l.conflicting,
l.invalidation_reason,
l.failover,
- l.synced
- FROM (pg_get_replication_slots() l(slot_name, plugin, slot_type, datoid, temporary, active, active_pid, xmin, catalo...
+ l.synced,
+ l.allow_overwrite
+ FROM (pg_get_replication_slots() l(slot_name, plugin, slot_type, datoid, temporary, active, active_pid, xmin, catalo...
LEFT JOIN pg_database d ON ((l.datoid = d.oid)));
pg_roles| SELECT pg_authid.rolname,
pg_authid.rolsuper, |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/rules.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_u...
--- /tmp/cirrus-ci-build/src/test/regress/expected/rules.out 2025-10-19 23:58:16.573606000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/rules.out 2025-10-20 00:00:33.000430000 +0...
@@ -1507,8 +1507,9 @@
l.conflicting,
l.invalidation_reason,
l.failover,
- l.synced
- FROM (pg_get_replication_slots() l(slot_name, plugin, slot_type, datoid, temporary, active, active_pid, xmin, catalo...
+ l.synced,
+ l.allow_overwrite
+ FROM (pg_get_replication_slots() l(slot_name, plugin, slot_type, datoid, temporary, active, active_pid, xmin, catalo...
LEFT JOIN pg_database d ON ((l.datoid = d.oid)));
pg_roles| SELECT pg_authid.rolname,
pg_authid.rolsuper, |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/rules.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stream...
--- /tmp/cirrus-ci-build/src/test/regress/expected/rules.out 2025-10-19 23:58:16.573606000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/rules.out 2025-10-20 00:01:56.855573000 ...
@@ -1507,8 +1507,9 @@
l.conflicting,
l.invalidation_reason,
l.failover,
- l.synced
- FROM (pg_get_replication_slots() l(slot_name, plugin, slot_type, datoid, temporary, active, active_pid, xmin, catalo...
+ l.synced,
+ l.allow_overwrite
+ FROM (pg_get_replication_slots() l(slot_name, plugin, slot_type, datoid, temporary, active, active_pid, xmin, catalo...
LEFT JOIN pg_database d ON ((l.datoid = d.oid)));
pg_roles| SELECT pg_authid.rolname,
pg_authid.rolsuper, |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/rules.out /tmp/cirrus-ci-build/build/testrun/regress/regress/res...
--- /tmp/cirrus-ci-build/src/test/regress/expected/rules.out 2025-10-19 23:58:16.573606000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/rules.out 2025-10-20 00:00:33.393991000 +0000
@@ -1507,8 +1507,9 @@
l.conflicting,
l.invalidation_reason,
l.failover,
- l.synced
- FROM (pg_get_replication_slots() l(slot_name, plugin, slot_type, datoid, temporary, active, active_pid, xmin, catalo...
+ l.synced,
+ l.allow_overwrite
+ FROM (pg_get_replication_slots() l(slot_name, plugin, slot_type, datoid, temporary, active, active_pid, xmin, catalo...
LEFT JOIN pg_database d ON ((l.datoid = d.oid)));
pg_roles| SELECT pg_authid.rolname,
pg_authid.rolsuper, |
|
Linux - Debian Bookworm - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/rules.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/resu...
--- /tmp/cirrus-ci-build/src/test/regress/expected/rules.out 2025-10-19 23:58:27.560752543 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/rules.out 2025-10-20 00:07:25.045800020 +0000
@@ -1507,8 +1507,9 @@
l.conflicting,
l.invalidation_reason,
l.failover,
- l.synced
- FROM (pg_get_replication_slots() l(slot_name, plugin, slot_type, datoid, temporary, active, active_pid, xmin, catalo...
+ l.synced,
+ l.allow_overwrite
+ FROM (pg_get_replication_slots() l(slot_name, plugin, slot_type, datoid, temporary, active, active_pid, xmin, catalo...
LEFT JOIN pg_database d ON ((l.datoid = d.oid)));
pg_roles| SELECT pg_authid.rolname,
pg_authid.rolsuper, |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/rules.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check/resul...
--- /tmp/cirrus-ci-build/src/test/regress/expected/rules.out 2025-10-19 23:58:27.560752543 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/rules.out 2025-10-20 00:08:48.880032150 +0000
@@ -1507,8 +1507,9 @@
l.conflicting,
l.invalidation_reason,
l.failover,
- l.synced
- FROM (pg_get_replication_slots() l(slot_name, plugin, slot_type, datoid, temporary, active, active_pid, xmin, catalo...
+ l.synced,
+ l.allow_overwrite
+ FROM (pg_get_replication_slots() l(slot_name, plugin, slot_type, datoid, temporary, active, active_pid, xmin, catalo...
LEFT JOIN pg_database d ON ((l.datoid = d.oid)));
pg_roles| SELECT pg_authid.rolname,
pg_authid.rolsuper, |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/rules.out /tmp/cirrus-ci-build/src/test/regress/results/rules.ou...
--- /tmp/cirrus-ci-build/src/test/regress/expected/rules.out 2025-10-19 23:58:27.560752543 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/rules.out 2025-10-20 00:03:32.379621966 +0000
@@ -1507,8 +1507,9 @@
l.conflicting,
l.invalidation_reason,
l.failover,
- l.synced
- FROM (pg_get_replication_slots() l(slot_name, plugin, slot_type, datoid, temporary, active, active_pid, xmin, catalo...
+ l.synced,
+ l.allow_overwrite
+ FROM (pg_get_replication_slots() l(slot_name, plugin, slot_type, datoid, temporary, active, active_pid, xmin, catalo...
LEFT JOIN pg_database d ON ((l.datoid = d.oid)));
pg_roles| SELECT pg_authid.rolname,
pg_authid.rolsuper, |
| 56/5553 |
starjoin join order planning |
|
Windows - Server 2019, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/sysviews.out C:/cirrus/build/testrun/pg_upgrade/002_pg_...
--- C:/cirrus/src/test/regress/expected/sysviews.out 2025-10-19 12:56:54.342798900 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/sysviews.out 2025-10-19 13:00:31.498910500 +0000
@@ -172,8 +172,9 @@
enable_self_join_elimination | on
enable_seqscan | on
enable_sort | on
+ enable_starjoin_join_search | off
enable_tidscan | on
-(25 rows)
+(26 rows)
-- There are always wait event descriptions for various types. InjectionPoint
-- may be present or absent, depending on history since last postmaster start. |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/sysviews.out C:/cirrus/build/testrun/recovery/027_strea...
--- C:/cirrus/src/test/regress/expected/sysviews.out 2025-10-19 12:56:54.342798900 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/sysviews.out 2025-10-19 13:03:17.122554700 +0000
@@ -172,8 +172,9 @@
enable_self_join_elimination | on
enable_seqscan | on
enable_sort | on
+ enable_starjoin_join_search | off
enable_tidscan | on
-(25 rows)
+(26 rows)
-- There are always wait event descriptions for various types. InjectionPoint
-- may be present or absent, depending on history since last postmaster start. |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/sysviews.out C:/cirrus/build/testrun/regress/regress/re...
--- C:/cirrus/src/test/regress/expected/sysviews.out 2025-10-19 12:56:54.342798900 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/sysviews.out 2025-10-19 13:00:22.843145600 +0000
@@ -172,8 +172,9 @@
enable_self_join_elimination | on
enable_seqscan | on
enable_sort | on
+ enable_starjoin_join_search | off
enable_tidscan | on
-(25 rows)
+(26 rows)
-- There are always wait event descriptions for various types. InjectionPoint
-- may be present or absent, depending on history since last postmaster start. |
|
Windows - Server 2019, MinGW64 - Meson |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/sysviews.out C:/cirrus/build/testrun/pg_upgrade/002_pg_...
--- C:/cirrus/src/test/regress/expected/sysviews.out 2025-10-19 12:56:58.158299100 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/sysviews.out 2025-10-19 13:00:21.774520600 +0000
@@ -172,8 +172,9 @@
enable_self_join_elimination | on
enable_seqscan | on
enable_sort | on
+ enable_starjoin_join_search | off
enable_tidscan | on
-(25 rows)
+(26 rows)
-- There are always wait event descriptions for various types. InjectionPoint
-- may be present or absent, depending on history since last postmaster start. |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/sysviews.out C:/cirrus/build/testrun/recovery/027_strea...
--- C:/cirrus/src/test/regress/expected/sysviews.out 2025-10-19 12:56:58.158299100 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/sysviews.out 2025-10-19 13:03:17.160773100 +0000
@@ -172,8 +172,9 @@
enable_self_join_elimination | on
enable_seqscan | on
enable_sort | on
+ enable_starjoin_join_search | off
enable_tidscan | on
-(25 rows)
+(26 rows)
-- There are always wait event descriptions for various types. InjectionPoint
-- may be present or absent, depending on history since last postmaster start. |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/sysviews.out C:/cirrus/build/testrun/regress/regress/re...
--- C:/cirrus/src/test/regress/expected/sysviews.out 2025-10-19 12:56:58.158299100 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/sysviews.out 2025-10-19 13:00:17.444447000 +0000
@@ -172,8 +172,9 @@
enable_self_join_elimination | on
enable_seqscan | on
enable_sort | on
+ enable_starjoin_join_search | off
enable_tidscan | on
-(25 rows)
+(26 rows)
-- There are always wait event descriptions for various types. InjectionPoint
-- may be present or absent, depending on history since last postmaster start. |
|
macOS - Sonoma - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/sysviews.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_up...
--- /Users/admin/pgsql/src/test/regress/expected/sysviews.out 2025-10-19 12:56:11
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/sysviews.out 2025-10-19 12:57:49
@@ -172,8 +172,9 @@
enable_self_join_elimination | on
enable_seqscan | on
enable_sort | on
+ enable_starjoin_join_search | off
enable_tidscan | on
-(25 rows)
+(26 rows)
-- There are always wait event descriptions for various types. InjectionPoint
-- may be present or absent, depending on history since last postmaster start. |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/sysviews.out /Users/admin/pgsql/build/testrun/recovery/027_stream_...
--- /Users/admin/pgsql/src/test/regress/expected/sysviews.out 2025-10-19 12:56:11
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/sysviews.out 2025-10-19 12:58:38
@@ -172,8 +172,9 @@
enable_self_join_elimination | on
enable_seqscan | on
enable_sort | on
+ enable_starjoin_join_search | off
enable_tidscan | on
-(25 rows)
+(26 rows)
-- There are always wait event descriptions for various types. InjectionPoint
-- may be present or absent, depending on history since last postmaster start. |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/sysviews.out /Users/admin/pgsql/build/testrun/regress/regress/resu...
--- /Users/admin/pgsql/src/test/regress/expected/sysviews.out 2025-10-19 12:56:11
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/sysviews.out 2025-10-19 12:57:49
@@ -172,8 +172,9 @@
enable_self_join_elimination | on
enable_seqscan | on
enable_sort | on
+ enable_starjoin_join_search | off
enable_tidscan | on
-(25 rows)
+(26 rows)
-- There are always wait event descriptions for various types. InjectionPoint
-- may be present or absent, depending on history since last postmaster start. |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_p...
--- /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out 2025-10-19 12:56:51.096494903 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/sysviews.out 2025-10-19 12:59:11.280902597...
@@ -172,8 +172,9 @@
enable_self_join_elimination | on
enable_seqscan | on
enable_sort | on
+ enable_starjoin_join_search | off
enable_tidscan | on
-(25 rows)
+(26 rows)
-- There are always wait event descriptions for various types. InjectionPoint
-- may be present or absent, depending on history since last postmaster start. |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out /tmp/cirrus-ci-build/build/testrun/recovery/027_str...
--- /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out 2025-10-19 12:56:51.096494903 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/sysviews.out 2025-10-19 13:00:26.4523369...
@@ -172,8 +172,9 @@
enable_self_join_elimination | on
enable_seqscan | on
enable_sort | on
+ enable_starjoin_join_search | off
enable_tidscan | on
-(25 rows)
+(26 rows)
-- There are always wait event descriptions for various types. InjectionPoint
-- may be present or absent, depending on history since last postmaster start. |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out /tmp/cirrus-ci-build/build/testrun/regress/regress/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out 2025-10-19 12:56:51.096494903 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/sysviews.out 2025-10-19 12:59:11.444900577 +0000
@@ -172,8 +172,9 @@
enable_self_join_elimination | on
enable_seqscan | on
enable_sort | on
+ enable_starjoin_join_search | off
enable_tidscan | on
-(25 rows)
+(26 rows)
-- There are always wait event descriptions for various types. InjectionPoint
-- may be present or absent, depending on history since last postmaster start. |
|
Linux - Debian Bookworm - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out 2025-10-19 12:56:59.304358139 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/sysviews.out 2025-10-19 13:02:29.040060724 +0000
@@ -172,8 +172,9 @@
enable_self_join_elimination | on
enable_seqscan | on
enable_sort | on
+ enable_starjoin_join_search | off
enable_tidscan | on
-(25 rows)
+(26 rows)
-- There are always wait event descriptions for various types. InjectionPoint
-- may be present or absent, depending on history since last postmaster start. |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check/re...
--- /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out 2025-10-19 12:56:59.304358139 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/sysviews.out 2025-10-19 13:04:35.967876581 +0000
@@ -172,8 +172,9 @@
enable_self_join_elimination | on
enable_seqscan | on
enable_sort | on
+ enable_starjoin_join_search | off
enable_tidscan | on
-(25 rows)
+(26 rows)
-- There are always wait event descriptions for various types. InjectionPoint
-- may be present or absent, depending on history since last postmaster start. |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out /tmp/cirrus-ci-build/src/test/regress/results/sysvi...
--- /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out 2025-10-19 12:56:59.304358139 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/sysviews.out 2025-10-19 12:59:46.684533527 +0000
@@ -172,8 +172,9 @@
enable_self_join_elimination | on
enable_seqscan | on
enable_sort | on
+ enable_starjoin_join_search | off
enable_tidscan | on
-(25 rows)
+(26 rows)
-- There are always wait event descriptions for various types. InjectionPoint
-- may be present or absent, depending on history since last postmaster start. |
|
OpenBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/sysviews.out /home/postgres/postgres/build/testrun/pg_upgrade...
--- /home/postgres/postgres/src/test/regress/expected/sysviews.out Sun Oct 19 12:57:11 2025
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/sysviews.out Sun Oct 19 12:59:47 2025
@@ -172,8 +172,9 @@
enable_self_join_elimination | on
enable_seqscan | on
enable_sort | on
+ enable_starjoin_join_search | off
enable_tidscan | on
-(25 rows)
+(26 rows)
-- There are always wait event descriptions for various types. InjectionPoint
-- may be present or absent, depending on history since last postmaster start. |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/sysviews.out /home/postgres/postgres/build/testrun/recovery/0...
--- /home/postgres/postgres/src/test/regress/expected/sysviews.out Sun Oct 19 12:57:11 2025
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/sysviews.out Sun Oct 19 13:01:33 2025
@@ -172,8 +172,9 @@
enable_self_join_elimination | on
enable_seqscan | on
enable_sort | on
+ enable_starjoin_join_search | off
enable_tidscan | on
-(25 rows)
+(26 rows)
-- There are always wait event descriptions for various types. InjectionPoint
-- may be present or absent, depending on history since last postmaster start. |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/sysviews.out /home/postgres/postgres/build/testrun/regress/re...
--- /home/postgres/postgres/src/test/regress/expected/sysviews.out Sun Oct 19 12:57:11 2025
+++ /home/postgres/postgres/build/testrun/regress/regress/results/sysviews.out Sun Oct 19 12:59:30 2025
@@ -172,8 +172,9 @@
enable_self_join_elimination | on
enable_seqscan | on
enable_sort | on
+ enable_starjoin_join_search | off
enable_tidscan | on
-(25 rows)
+(26 rows)
-- There are always wait event descriptions for various types. InjectionPoint
-- may be present or absent, depending on history since last postmaster start. |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_p...
--- /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out 2025-10-19 12:56:50.457259000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/sysviews.out 2025-10-19 12:58:56.404452000...
@@ -172,8 +172,9 @@
enable_self_join_elimination | on
enable_seqscan | on
enable_sort | on
+ enable_starjoin_join_search | off
enable_tidscan | on
-(25 rows)
+(26 rows)
-- There are always wait event descriptions for various types. InjectionPoint
-- may be present or absent, depending on history since last postmaster start. |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out /tmp/cirrus-ci-build/build/testrun/recovery/027_str...
--- /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out 2025-10-19 12:56:50.457259000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/sysviews.out 2025-10-19 13:00:12.7516700...
@@ -172,8 +172,9 @@
enable_self_join_elimination | on
enable_seqscan | on
enable_sort | on
+ enable_starjoin_join_search | off
enable_tidscan | on
-(25 rows)
+(26 rows)
-- There are always wait event descriptions for various types. InjectionPoint
-- may be present or absent, depending on history since last postmaster start. |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out /tmp/cirrus-ci-build/build/testrun/regress/regress/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out 2025-10-19 12:56:50.457259000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/sysviews.out 2025-10-19 12:59:05.434630000 +0000
@@ -172,8 +172,9 @@
enable_self_join_elimination | on
enable_seqscan | on
enable_sort | on
+ enable_starjoin_join_search | off
enable_tidscan | on
-(25 rows)
+(26 rows)
-- There are always wait event descriptions for various types. InjectionPoint
-- may be present or absent, depending on history since last postmaster start. |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/sysviews.out /home/postgres/postgres/build/testrun/pg_upgrade...
--- /home/postgres/postgres/src/test/regress/expected/sysviews.out 2025-10-19 12:57:24.615776719 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/sysviews.out 2025-10-19 12:58:58.838647...
@@ -172,8 +172,9 @@
enable_self_join_elimination | on
enable_seqscan | on
enable_sort | on
+ enable_starjoin_join_search | off
enable_tidscan | on
-(25 rows)
+(26 rows)
-- There are always wait event descriptions for various types. InjectionPoint
-- may be present or absent, depending on history since last postmaster start. |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/sysviews.out /home/postgres/postgres/build/testrun/recovery/0...
--- /home/postgres/postgres/src/test/regress/expected/sysviews.out 2025-10-19 12:57:24.615776719 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/sysviews.out 2025-10-19 12:59:39.6361...
@@ -172,8 +172,9 @@
enable_self_join_elimination | on
enable_seqscan | on
enable_sort | on
+ enable_starjoin_join_search | off
enable_tidscan | on
-(25 rows)
+(26 rows)
-- There are always wait event descriptions for various types. InjectionPoint
-- may be present or absent, depending on history since last postmaster start. |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/sysviews.out /home/postgres/postgres/build/testrun/regress/re...
--- /home/postgres/postgres/src/test/regress/expected/sysviews.out 2025-10-19 12:57:24.615776719 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/sysviews.out 2025-10-19 12:58:57.385138864 +0000
@@ -172,8 +172,9 @@
enable_self_join_elimination | on
enable_seqscan | on
enable_sort | on
+ enable_starjoin_join_search | off
enable_tidscan | on
-(25 rows)
+(26 rows)
-- There are always wait event descriptions for various types. InjectionPoint
-- may be present or absent, depending on history since last postmaster start. |
| 56/5699 |
Adding error messages to a few slash commands |
|
Windows - Server 2019, MinGW64 - Meson |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/matview.out C:/cirrus/build/testrun/pg_upgrade/002_pg_u...
--- C:/cirrus/src/test/regress/expected/matview.out 2025-10-18 23:27:24.006563400 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/matview.out 2025-10-18 23:31:59.078504700 +0000
@@ -141,6 +141,11 @@
CREATE SCHEMA mvtest_mvschema;
ALTER MATERIALIZED VIEW mvtest_tvm SET SCHEMA mvtest_mvschema;
\d+ mvtest_tvm
+ List of relations
+ Schema | Name | Type | Owner | Persistence | Size | Description
+--------+------+------+-------+-------------+------+-------------
+(0 rows)
+
\d+ mvtest_tvmm
Materialized view "public.mvtest_tvmm"
Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/identity.out C:/cirrus/build/testrun/pg_upgrade/002_pg_...
--- C:/cirrus/src/test/regress/expected/identity.out 2025-10-18 23:27:23.977785300 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/identity.out 2025-10-18 23:31:59.014540600 +0000
@@ -607,6 +607,11 @@
Sequence for identity column: public.itest8.f4
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/matview.out C:/cirrus/build/testrun/recovery/027_stream...
--- C:/cirrus/src/test/regress/expected/matview.out 2025-10-18 23:27:24.006563400 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/matview.out 2025-10-18 23:34:56.423737400 +0000
@@ -141,6 +141,11 @@
CREATE SCHEMA mvtest_mvschema;
ALTER MATERIALIZED VIEW mvtest_tvm SET SCHEMA mvtest_mvschema;
\d+ mvtest_tvm
+ List of relations
+ Schema | Name | Type | Owner | Persistence | Size | Description
+--------+------+------+-------+-------------+------+-------------
+(0 rows)
+
\d+ mvtest_tvmm
Materialized view "public.mvtest_tvmm"
Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/identity.out C:/cirrus/build/testrun/recovery/027_strea...
--- C:/cirrus/src/test/regress/expected/identity.out 2025-10-18 23:27:23.977785300 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/identity.out 2025-10-18 23:34:56.535524700 +0000
@@ -607,6 +607,11 @@
Sequence for identity column: public.itest8.f4
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/matview.out C:/cirrus/build/testrun/regress/regress/res...
--- C:/cirrus/src/test/regress/expected/matview.out 2025-10-18 23:27:24.006563400 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/matview.out 2025-10-18 23:31:52.385130400 +0000
@@ -141,6 +141,11 @@
CREATE SCHEMA mvtest_mvschema;
ALTER MATERIALIZED VIEW mvtest_tvm SET SCHEMA mvtest_mvschema;
\d+ mvtest_tvm
+ List of relations
+ Schema | Name | Type | Owner | Persistence | Size | Description
+--------+------+------+-------+-------------+------+-------------
+(0 rows)
+
\d+ mvtest_tvmm
Materialized view "public.mvtest_tvmm"
Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/identity.out C:/cirrus/build/testrun/regress/regress/re...
--- C:/cirrus/src/test/regress/expected/identity.out 2025-10-18 23:27:23.977785300 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/identity.out 2025-10-18 23:31:52.441771400 +0000
@@ -607,6 +607,11 @@
Sequence for identity column: public.itest8.f4
... |
|
Windows - Server 2019, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/matview.out C:/cirrus/build/testrun/pg_upgrade/002_pg_u...
--- C:/cirrus/src/test/regress/expected/matview.out 2025-10-18 23:27:16.078592800 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/matview.out 2025-10-18 23:30:34.770353600 +0000
@@ -141,6 +141,11 @@
CREATE SCHEMA mvtest_mvschema;
ALTER MATERIALIZED VIEW mvtest_tvm SET SCHEMA mvtest_mvschema;
\d+ mvtest_tvm
+ List of relations
+ Schema | Name | Type | Owner | Persistence | Size | Description
+--------+------+------+-------+-------------+------+-------------
+(0 rows)
+
\d+ mvtest_tvmm
Materialized view "public.mvtest_tvmm"
Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/identity.out C:/cirrus/build/testrun/pg_upgrade/002_pg_...
--- C:/cirrus/src/test/regress/expected/identity.out 2025-10-18 23:27:16.047263200 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/identity.out 2025-10-18 23:30:35.336288800 +0000
@@ -607,6 +607,11 @@
Sequence for identity column: public.itest8.f4
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/matview.out C:/cirrus/build/testrun/recovery/027_stream...
--- C:/cirrus/src/test/regress/expected/matview.out 2025-10-18 23:27:16.078592800 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/matview.out 2025-10-18 23:33:34.424889300 +0000
@@ -141,6 +141,11 @@
CREATE SCHEMA mvtest_mvschema;
ALTER MATERIALIZED VIEW mvtest_tvm SET SCHEMA mvtest_mvschema;
\d+ mvtest_tvm
+ List of relations
+ Schema | Name | Type | Owner | Persistence | Size | Description
+--------+------+------+-------+-------------+------+-------------
+(0 rows)
+
\d+ mvtest_tvmm
Materialized view "public.mvtest_tvmm"
Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/identity.out C:/cirrus/build/testrun/recovery/027_strea...
--- C:/cirrus/src/test/regress/expected/identity.out 2025-10-18 23:27:16.047263200 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/identity.out 2025-10-18 23:33:36.653389300 +0000
@@ -607,6 +607,11 @@
Sequence for identity column: public.itest8.f4
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/matview.out C:/cirrus/build/testrun/regress/regress/res...
--- C:/cirrus/src/test/regress/expected/matview.out 2025-10-18 23:27:16.078592800 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/matview.out 2025-10-18 23:30:26.209802000 +0000
@@ -141,6 +141,11 @@
CREATE SCHEMA mvtest_mvschema;
ALTER MATERIALIZED VIEW mvtest_tvm SET SCHEMA mvtest_mvschema;
\d+ mvtest_tvm
+ List of relations
+ Schema | Name | Type | Owner | Persistence | Size | Description
+--------+------+------+-------+-------------+------+-------------
+(0 rows)
+
\d+ mvtest_tvmm
Materialized view "public.mvtest_tvmm"
Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/identity.out C:/cirrus/build/testrun/regress/regress/re...
--- C:/cirrus/src/test/regress/expected/identity.out 2025-10-18 23:27:16.047263200 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/identity.out 2025-10-18 23:30:28.695646000 +0000
@@ -607,6 +607,11 @@
Sequence for identity column: public.itest8.f4
... |
|
macOS - Sonoma - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/matview.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upg...
--- /Users/admin/pgsql/src/test/regress/expected/matview.out 2025-10-18 23:27:10
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/matview.out 2025-10-18 23:29:41
@@ -141,6 +141,11 @@
CREATE SCHEMA mvtest_mvschema;
ALTER MATERIALIZED VIEW mvtest_tvm SET SCHEMA mvtest_mvschema;
\d+ mvtest_tvm
+ List of relations
+ Schema | Name | Type | Owner | Persistence | Size | Description
+--------+------+------+-------+-------------+------+-------------
+(0 rows)
+
\d+ mvtest_tvmm
Materialized view "public.mvtest_tvmm"
Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
diff -U3 /Users/admin/pgsql/src/test/regress/expected/identity.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_up...
--- /Users/admin/pgsql/src/test/regress/expected/identity.out 2025-10-18 23:27:10
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/identity.out 2025-10-18 23:29:41
@@ -607,6 +607,11 @@
Sequence for identity column: public.itest8.f4
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/matview.out /Users/admin/pgsql/build/testrun/recovery/027_stream_r...
--- /Users/admin/pgsql/src/test/regress/expected/matview.out 2025-10-18 23:27:10
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/matview.out 2025-10-18 23:31:13
@@ -141,6 +141,11 @@
CREATE SCHEMA mvtest_mvschema;
ALTER MATERIALIZED VIEW mvtest_tvm SET SCHEMA mvtest_mvschema;
\d+ mvtest_tvm
+ List of relations
+ Schema | Name | Type | Owner | Persistence | Size | Description
+--------+------+------+-------+-------------+------+-------------
+(0 rows)
+
\d+ mvtest_tvmm
Materialized view "public.mvtest_tvmm"
Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
diff -U3 /Users/admin/pgsql/src/test/regress/expected/identity.out /Users/admin/pgsql/build/testrun/recovery/027_stream_...
--- /Users/admin/pgsql/src/test/regress/expected/identity.out 2025-10-18 23:27:10
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/identity.out 2025-10-18 23:31:14
@@ -607,6 +607,11 @@
Sequence for identity column: public.itest8.f4
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/matview.out /Users/admin/pgsql/build/testrun/regress/regress/resul...
--- /Users/admin/pgsql/src/test/regress/expected/matview.out 2025-10-18 23:27:10
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/matview.out 2025-10-18 23:29:40
@@ -141,6 +141,11 @@
CREATE SCHEMA mvtest_mvschema;
ALTER MATERIALIZED VIEW mvtest_tvm SET SCHEMA mvtest_mvschema;
\d+ mvtest_tvm
+ List of relations
+ Schema | Name | Type | Owner | Persistence | Size | Description
+--------+------+------+-------+-------------+------+-------------
+(0 rows)
+
\d+ mvtest_tvmm
Materialized view "public.mvtest_tvmm"
Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
diff -U3 /Users/admin/pgsql/src/test/regress/expected/identity.out /Users/admin/pgsql/build/testrun/regress/regress/resu...
--- /Users/admin/pgsql/src/test/regress/expected/identity.out 2025-10-18 23:27:10
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/identity.out 2025-10-18 23:29:41
@@ -607,6 +607,11 @@
Sequence for identity column: public.itest8.f4
... |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/matview.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg...
--- /tmp/cirrus-ci-build/src/test/regress/expected/matview.out 2025-10-18 23:27:11.041797212 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/matview.out 2025-10-18 23:31:19.120698210 ...
@@ -141,6 +141,11 @@
CREATE SCHEMA mvtest_mvschema;
ALTER MATERIALIZED VIEW mvtest_tvm SET SCHEMA mvtest_mvschema;
\d+ mvtest_tvm
+ List of relations
+ Schema | Name | Type | Owner | Persistence | Size | Description
+--------+------+------+-------+-------------+------+-------------
+(0 rows)
+
\d+ mvtest_tvmm
Materialized view "public.mvtest_tvmm"
Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/identity.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_p...
--- /tmp/cirrus-ci-build/src/test/regress/expected/identity.out 2025-10-18 23:27:11.021797211 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/identity.out 2025-10-18 23:31:19.084698268...
@@ -607,6 +607,11 @@
Sequence for identity column: public.itest8.f4
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/matview.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stre...
--- /tmp/cirrus-ci-build/src/test/regress/expected/matview.out 2025-10-18 23:27:11.041797212 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/matview.out 2025-10-18 23:32:38.51260886...
@@ -141,6 +141,11 @@
CREATE SCHEMA mvtest_mvschema;
ALTER MATERIALIZED VIEW mvtest_tvm SET SCHEMA mvtest_mvschema;
\d+ mvtest_tvm
+ List of relations
+ Schema | Name | Type | Owner | Persistence | Size | Description
+--------+------+------+-------+-------------+------+-------------
+(0 rows)
+
\d+ mvtest_tvmm
Materialized view "public.mvtest_tvmm"
Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/identity.out /tmp/cirrus-ci-build/build/testrun/recovery/027_str...
--- /tmp/cirrus-ci-build/src/test/regress/expected/identity.out 2025-10-18 23:27:11.021797211 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/identity.out 2025-10-18 23:32:38.6366087...
@@ -607,6 +607,11 @@
Sequence for identity column: public.itest8.f4
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/matview.out /tmp/cirrus-ci-build/build/testrun/regress/regress/r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/matview.out 2025-10-18 23:27:11.041797212 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/matview.out 2025-10-18 23:31:15.168704711 +0000
@@ -141,6 +141,11 @@
CREATE SCHEMA mvtest_mvschema;
ALTER MATERIALIZED VIEW mvtest_tvm SET SCHEMA mvtest_mvschema;
\d+ mvtest_tvm
+ List of relations
+ Schema | Name | Type | Owner | Persistence | Size | Description
+--------+------+------+-------+-------------+------+-------------
+(0 rows)
+
\d+ mvtest_tvmm
Materialized view "public.mvtest_tvmm"
Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/identity.out /tmp/cirrus-ci-build/build/testrun/regress/regress/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/identity.out 2025-10-18 23:27:11.021797211 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/identity.out 2025-10-18 23:31:15.516704128 +0000
@@ -607,6 +607,11 @@
Sequence for identity column: public.itest8.f4
... |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/matview.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg...
--- /tmp/cirrus-ci-build/src/test/regress/expected/matview.out 2025-10-18 23:27:12.801425000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/matview.out 2025-10-18 23:28:58.205899000 ...
@@ -141,6 +141,11 @@
CREATE SCHEMA mvtest_mvschema;
ALTER MATERIALIZED VIEW mvtest_tvm SET SCHEMA mvtest_mvschema;
\d+ mvtest_tvm
+ List of relations
+ Schema | Name | Type | Owner | Persistence | Size | Description
+--------+------+------+-------+-------------+------+-------------
+(0 rows)
+
\d+ mvtest_tvmm
Materialized view "public.mvtest_tvmm"
Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/identity.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_p...
--- /tmp/cirrus-ci-build/src/test/regress/expected/identity.out 2025-10-18 23:27:12.788398000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/identity.out 2025-10-18 23:28:57.206777000...
@@ -607,6 +607,11 @@
Sequence for identity column: public.itest8.f4
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/matview.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stre...
--- /tmp/cirrus-ci-build/src/test/regress/expected/matview.out 2025-10-18 23:27:12.801425000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/matview.out 2025-10-18 23:30:01.10790700...
@@ -141,6 +141,11 @@
CREATE SCHEMA mvtest_mvschema;
ALTER MATERIALIZED VIEW mvtest_tvm SET SCHEMA mvtest_mvschema;
\d+ mvtest_tvm
+ List of relations
+ Schema | Name | Type | Owner | Persistence | Size | Description
+--------+------+------+-------+-------------+------+-------------
+(0 rows)
+
\d+ mvtest_tvmm
Materialized view "public.mvtest_tvmm"
Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/identity.out /tmp/cirrus-ci-build/build/testrun/recovery/027_str...
--- /tmp/cirrus-ci-build/src/test/regress/expected/identity.out 2025-10-18 23:27:12.788398000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/identity.out 2025-10-18 23:29:58.7994900...
@@ -607,6 +607,11 @@
Sequence for identity column: public.itest8.f4
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/matview.out /tmp/cirrus-ci-build/build/testrun/regress/regress/r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/matview.out 2025-10-18 23:27:12.801425000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/matview.out 2025-10-18 23:28:55.920681000 +0000
@@ -141,6 +141,11 @@
CREATE SCHEMA mvtest_mvschema;
ALTER MATERIALIZED VIEW mvtest_tvm SET SCHEMA mvtest_mvschema;
\d+ mvtest_tvm
+ List of relations
+ Schema | Name | Type | Owner | Persistence | Size | Description
+--------+------+------+-------+-------------+------+-------------
+(0 rows)
+
\d+ mvtest_tvmm
Materialized view "public.mvtest_tvmm"
Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/identity.out /tmp/cirrus-ci-build/build/testrun/regress/regress/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/identity.out 2025-10-18 23:27:12.788398000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/identity.out 2025-10-18 23:28:55.992659000 +0000
@@ -607,6 +607,11 @@
Sequence for identity column: public.itest8.f4
... |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/matview.out /home/postgres/postgres/build/testrun/pg_upgrade/...
--- /home/postgres/postgres/src/test/regress/expected/matview.out 2025-10-18 23:27:41.175263367 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/matview.out 2025-10-18 23:29:04.0337189...
@@ -141,6 +141,11 @@
CREATE SCHEMA mvtest_mvschema;
ALTER MATERIALIZED VIEW mvtest_tvm SET SCHEMA mvtest_mvschema;
\d+ mvtest_tvm
+ List of relations
+ Schema | Name | Type | Owner | Persistence | Size | Description
+--------+------+------+-------+-------------+------+-------------
+(0 rows)
+
\d+ mvtest_tvmm
Materialized view "public.mvtest_tvmm"
Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
diff -U3 /home/postgres/postgres/src/test/regress/expected/identity.out /home/postgres/postgres/build/testrun/pg_upgrade...
--- /home/postgres/postgres/src/test/regress/expected/identity.out 2025-10-18 23:27:41.133503967 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/identity.out 2025-10-18 23:29:05.098467...
@@ -607,6 +607,11 @@
Sequence for identity column: public.itest8.f4
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/matview.out /home/postgres/postgres/build/testrun/recovery/02...
--- /home/postgres/postgres/src/test/regress/expected/matview.out 2025-10-18 23:27:41.175263367 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/matview.out 2025-10-18 23:29:34.94801...
@@ -141,6 +141,11 @@
CREATE SCHEMA mvtest_mvschema;
ALTER MATERIALIZED VIEW mvtest_tvm SET SCHEMA mvtest_mvschema;
\d+ mvtest_tvm
+ List of relations
+ Schema | Name | Type | Owner | Persistence | Size | Description
+--------+------+------+-------+-------------+------+-------------
+(0 rows)
+
\d+ mvtest_tvmm
Materialized view "public.mvtest_tvmm"
Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
diff -U3 /home/postgres/postgres/src/test/regress/expected/identity.out /home/postgres/postgres/build/testrun/recovery/0...
--- /home/postgres/postgres/src/test/regress/expected/identity.out 2025-10-18 23:27:41.133503967 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/identity.out 2025-10-18 23:29:37.1977...
@@ -607,6 +607,11 @@
Sequence for identity column: public.itest8.f4
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/matview.out /home/postgres/postgres/build/testrun/regress/reg...
--- /home/postgres/postgres/src/test/regress/expected/matview.out 2025-10-18 23:27:41.175263367 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/matview.out 2025-10-18 23:28:57.262173682 +0000
@@ -141,6 +141,11 @@
CREATE SCHEMA mvtest_mvschema;
ALTER MATERIALIZED VIEW mvtest_tvm SET SCHEMA mvtest_mvschema;
\d+ mvtest_tvm
+ List of relations
+ Schema | Name | Type | Owner | Persistence | Size | Description
+--------+------+------+-------+-------------+------+-------------
+(0 rows)
+
\d+ mvtest_tvmm
Materialized view "public.mvtest_tvmm"
Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
diff -U3 /home/postgres/postgres/src/test/regress/expected/identity.out /home/postgres/postgres/build/testrun/regress/re...
--- /home/postgres/postgres/src/test/regress/expected/identity.out 2025-10-18 23:27:41.133503967 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/identity.out 2025-10-18 23:28:58.664967350 +0000
@@ -607,6 +607,11 @@
Sequence for identity column: public.itest8.f4
... |
|
Linux - Debian Bookworm - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/matview.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/re...
--- /tmp/cirrus-ci-build/src/test/regress/expected/matview.out 2025-10-18 23:27:17.647891955 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/matview.out 2025-10-18 23:34:48.127718599 +0000
@@ -141,6 +141,11 @@
CREATE SCHEMA mvtest_mvschema;
ALTER MATERIALIZED VIEW mvtest_tvm SET SCHEMA mvtest_mvschema;
\d+ mvtest_tvm
+ List of relations
+ Schema | Name | Type | Owner | Persistence | Size | Description
+--------+------+------+-------+-------------+------+-------------
+(0 rows)
+
\d+ mvtest_tvmm
Materialized view "public.mvtest_tvmm"
Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/identity.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/identity.out 2025-10-18 23:27:17.627744579 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/identity.out 2025-10-18 23:34:47.807713250 +0000
@@ -607,6 +607,11 @@
Sequence for identity column: public.itest8.f4
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/matview.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check/res...
--- /tmp/cirrus-ci-build/src/test/regress/expected/matview.out 2025-10-18 23:27:17.647891955 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/matview.out 2025-10-18 23:36:38.526791953 +0000
@@ -141,6 +141,11 @@
CREATE SCHEMA mvtest_mvschema;
ALTER MATERIALIZED VIEW mvtest_tvm SET SCHEMA mvtest_mvschema;
\d+ mvtest_tvm
+ List of relations
+ Schema | Name | Type | Owner | Persistence | Size | Description
+--------+------+------+-------+-------------+------+-------------
+(0 rows)
+
\d+ mvtest_tvmm
Materialized view "public.mvtest_tvmm"
Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/identity.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check/re...
--- /tmp/cirrus-ci-build/src/test/regress/expected/identity.out 2025-10-18 23:27:17.627744579 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/identity.out 2025-10-18 23:36:38.634791333 +0000
@@ -607,6 +607,11 @@
Sequence for identity column: public.itest8.f4
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/matview.out /tmp/cirrus-ci-build/src/test/regress/results/matvie...
--- /tmp/cirrus-ci-build/src/test/regress/expected/matview.out 2025-10-18 23:27:17.647891955 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/matview.out 2025-10-18 23:31:25.017978806 +0000
@@ -141,6 +141,11 @@
CREATE SCHEMA mvtest_mvschema;
ALTER MATERIALIZED VIEW mvtest_tvm SET SCHEMA mvtest_mvschema;
\d+ mvtest_tvm
+ List of relations
+ Schema | Name | Type | Owner | Persistence | Size | Description
+--------+------+------+-------+-------------+------+-------------
+(0 rows)
+
\d+ mvtest_tvmm
Materialized view "public.mvtest_tvmm"
Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/identity.out /tmp/cirrus-ci-build/src/test/regress/results/ident...
--- /tmp/cirrus-ci-build/src/test/regress/expected/identity.out 2025-10-18 23:27:17.627744579 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/identity.out 2025-10-18 23:31:25.033978594 +0000
@@ -607,6 +607,11 @@
Sequence for identity column: public.itest8.f4
... |
|
OpenBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/matview.out /home/postgres/postgres/build/testrun/pg_upgrade/...
--- /home/postgres/postgres/src/test/regress/expected/matview.out Sat Oct 18 23:27:29 2025
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/matview.out Sat Oct 18 23:30:03 2025
@@ -141,6 +141,11 @@
CREATE SCHEMA mvtest_mvschema;
ALTER MATERIALIZED VIEW mvtest_tvm SET SCHEMA mvtest_mvschema;
\d+ mvtest_tvm
+ List of relations
+ Schema | Name | Type | Owner | Persistence | Size | Description
+--------+------+------+-------+-------------+------+-------------
+(0 rows)
+
\d+ mvtest_tvmm
Materialized view "public.mvtest_tvmm"
Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
diff -U3 /home/postgres/postgres/src/test/regress/expected/identity.out /home/postgres/postgres/build/testrun/pg_upgrade...
--- /home/postgres/postgres/src/test/regress/expected/identity.out Sat Oct 18 23:27:29 2025
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/identity.out Sat Oct 18 23:30:03 2025
@@ -607,6 +607,11 @@
Sequence for identity column: public.itest8.f4
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/matview.out /home/postgres/postgres/build/testrun/recovery/02...
--- /home/postgres/postgres/src/test/regress/expected/matview.out Sat Oct 18 23:27:29 2025
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/matview.out Sat Oct 18 23:31:48 2025
@@ -141,6 +141,11 @@
CREATE SCHEMA mvtest_mvschema;
ALTER MATERIALIZED VIEW mvtest_tvm SET SCHEMA mvtest_mvschema;
\d+ mvtest_tvm
+ List of relations
+ Schema | Name | Type | Owner | Persistence | Size | Description
+--------+------+------+-------+-------------+------+-------------
+(0 rows)
+
\d+ mvtest_tvmm
Materialized view "public.mvtest_tvmm"
Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
diff -U3 /home/postgres/postgres/src/test/regress/expected/identity.out /home/postgres/postgres/build/testrun/recovery/0...
--- /home/postgres/postgres/src/test/regress/expected/identity.out Sat Oct 18 23:27:29 2025
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/identity.out Sat Oct 18 23:31:51 2025
@@ -607,6 +607,11 @@
Sequence for identity column: public.itest8.f4
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/matview.out /home/postgres/postgres/build/testrun/regress/reg...
--- /home/postgres/postgres/src/test/regress/expected/matview.out Sat Oct 18 23:27:29 2025
+++ /home/postgres/postgres/build/testrun/regress/regress/results/matview.out Sat Oct 18 23:29:55 2025
@@ -141,6 +141,11 @@
CREATE SCHEMA mvtest_mvschema;
ALTER MATERIALIZED VIEW mvtest_tvm SET SCHEMA mvtest_mvschema;
\d+ mvtest_tvm
+ List of relations
+ Schema | Name | Type | Owner | Persistence | Size | Description
+--------+------+------+-------+-------------+------+-------------
+(0 rows)
+
\d+ mvtest_tvmm
Materialized view "public.mvtest_tvmm"
Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
diff -U3 /home/postgres/postgres/src/test/regress/expected/identity.out /home/postgres/postgres/build/testrun/regress/re...
--- /home/postgres/postgres/src/test/regress/expected/identity.out Sat Oct 18 23:27:29 2025
+++ /home/postgres/postgres/build/testrun/regress/regress/results/identity.out Sat Oct 18 23:29:54 2025
@@ -607,6 +607,11 @@
Sequence for identity column: public.itest8.f4
... |
| 56/6128 |
GIN pageinspect support for entry tree and non-leaf posting tree |
|
Windows - Server 2019, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/modules/brin/expected/summarization-and-inprogress-insertion.out C:/cirr...
--- C:/cirrus/src/test/modules/brin/expected/summarization-and-inprogress-insertion.out 2025-10-17 11:49:20.311857700 +0...
+++ C:/cirrus/build/testrun/brin/isolation/results/summarization-and-inprogress-insertion.out 2025-10-17 11:57:32.360661...
@@ -1,51 +1,4 @@
Parsed test spec with 2 sessions
starting permutation: s2check s1b s2b s1i s2summ s1c s2c s2check
-step s2check: SELECT * FROM brin_page_items(get_raw_page('brinidx', 2), 'brinidx'::regclass);
-itemoffset|blknum|attnum|allnulls|hasnulls|placeholder|empty|value
-----------+------+------+--------+--------+-----------+-----+--------
- 1| 0| 1|f |t |f |f |{1 .. 1}
-(1 row)
-
-step s1b: BEGIN ISOLATION LEVEL REPEATABLE READ;
-step s2b: BEGIN ISOLATION LEVEL REPEATABLE READ; SELECT 1;
-?column?
---------
- 1
-(1 row)
-
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/pageinspect/expected/page.out C:/cirrus/build/testrun/pageinspect/regress...
--- C:/cirrus/contrib/pageinspect/expected/page.out 2025-10-17 11:49:16.298912100 +0000
+++ C:/cirrus/build/testrun/pageinspect/regress/results/page.out 2025-10-17 11:57:10.931469900 +0000
@@ -1,4 +1,5 @@
CREATE EXTENSION pageinspect;
+ERROR: extension "pageinspect" has no installation script nor update path for version "1.14"
-- Use a temp table so that effects of VACUUM are predictable
CREATE TEMP TABLE test1 (a int, b int);
INSERT INTO test1 VALUES (16777217, 131584);
@@ -6,207 +7,177 @@
-- The page contents can vary, so just test that it can be read
-- successfully, but don't keep the output.
SELECT octet_length(get_raw_page('test1', 'main', 0)) AS main_0;
- main_0
---------
- 8192
-(1 row)
-
+ERROR: function get_raw_page(unknown, unknown, integer) does not exist
+LINE 1: SELECT octet_length(get_raw_page('test1', 'main', 0)) AS mai...
... |
|
Windows - Server 2019, MinGW64 - Meson |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/modules/brin/expected/summarization-and-inprogress-insertion.out C:/cirr...
--- C:/cirrus/src/test/modules/brin/expected/summarization-and-inprogress-insertion.out 2025-10-17 11:49:24.907042600 +0...
+++ C:/cirrus/build/testrun/brin/isolation/results/summarization-and-inprogress-insertion.out 2025-10-17 11:58:15.937532...
@@ -1,51 +1,4 @@
Parsed test spec with 2 sessions
starting permutation: s2check s1b s2b s1i s2summ s1c s2c s2check
-step s2check: SELECT * FROM brin_page_items(get_raw_page('brinidx', 2), 'brinidx'::regclass);
-itemoffset|blknum|attnum|allnulls|hasnulls|placeholder|empty|value
-----------+------+------+--------+--------+-----------+-----+--------
- 1| 0| 1|f |t |f |f |{1 .. 1}
-(1 row)
-
-step s1b: BEGIN ISOLATION LEVEL REPEATABLE READ;
-step s2b: BEGIN ISOLATION LEVEL REPEATABLE READ; SELECT 1;
-?column?
---------
- 1
-(1 row)
-
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/pageinspect/expected/page.out C:/cirrus/build/testrun/pageinspect/regress...
--- C:/cirrus/contrib/pageinspect/expected/page.out 2025-10-17 11:49:20.979575300 +0000
+++ C:/cirrus/build/testrun/pageinspect/regress/results/page.out 2025-10-17 11:57:55.028328900 +0000
@@ -1,4 +1,5 @@
CREATE EXTENSION pageinspect;
+ERROR: extension "pageinspect" has no installation script nor update path for version "1.14"
-- Use a temp table so that effects of VACUUM are predictable
CREATE TEMP TABLE test1 (a int, b int);
INSERT INTO test1 VALUES (16777217, 131584);
@@ -6,207 +7,177 @@
-- The page contents can vary, so just test that it can be read
-- successfully, but don't keep the output.
SELECT octet_length(get_raw_page('test1', 'main', 0)) AS main_0;
- main_0
---------
- 8192
-(1 row)
-
+ERROR: function get_raw_page(unknown, unknown, integer) does not exist
+LINE 1: SELECT octet_length(get_raw_page('test1', 'main', 0)) AS mai...
... |
|
macOS - Sonoma - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/modules/brin/expected/summarization-and-inprogress-insertion.out /Users/admin/pgsql...
--- /Users/admin/pgsql/src/test/modules/brin/expected/summarization-and-inprogress-insertion.out 2025-10-17 11:48:12
+++ /Users/admin/pgsql/build/testrun/brin/isolation/results/summarization-and-inprogress-insertion.out 2025-10-17 11:51:...
@@ -1,51 +1,4 @@
Parsed test spec with 2 sessions
starting permutation: s2check s1b s2b s1i s2summ s1c s2c s2check
-step s2check: SELECT * FROM brin_page_items(get_raw_page('brinidx', 2), 'brinidx'::regclass);
-itemoffset|blknum|attnum|allnulls|hasnulls|placeholder|empty|value
-----------+------+------+--------+--------+-----------+-----+--------
- 1| 0| 1|f |t |f |f |{1 .. 1}
-(1 row)
-
-step s1b: BEGIN ISOLATION LEVEL REPEATABLE READ;
-step s2b: BEGIN ISOLATION LEVEL REPEATABLE READ; SELECT 1;
-?column?
---------
- 1
-(1 row)
-
... |
| regress |
diff -U3 /Users/admin/pgsql/contrib/pageinspect/expected/page.out /Users/admin/pgsql/build/testrun/pageinspect/regress/r...
--- /Users/admin/pgsql/contrib/pageinspect/expected/page.out 2025-10-17 11:48:10
+++ /Users/admin/pgsql/build/testrun/pageinspect/regress/results/page.out 2025-10-17 11:51:46
@@ -1,4 +1,5 @@
CREATE EXTENSION pageinspect;
+ERROR: extension "pageinspect" has no installation script nor update path for version "1.14"
-- Use a temp table so that effects of VACUUM are predictable
CREATE TEMP TABLE test1 (a int, b int);
INSERT INTO test1 VALUES (16777217, 131584);
@@ -6,207 +7,177 @@
-- The page contents can vary, so just test that it can be read
-- successfully, but don't keep the output.
SELECT octet_length(get_raw_page('test1', 'main', 0)) AS main_0;
- main_0
---------
- 8192
-(1 row)
-
+ERROR: function get_raw_page(unknown, unknown, integer) does not exist
+LINE 1: SELECT octet_length(get_raw_page('test1', 'main', 0)) AS mai...
... |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/modules/brin/expected/summarization-and-inprogress-insertion.out /tmp/cirrus-ci-b...
--- /tmp/cirrus-ci-build/src/test/modules/brin/expected/summarization-and-inprogress-insertion.out 2025-10-17 11:49:10.3...
+++ /tmp/cirrus-ci-build/build/testrun/brin/isolation/results/summarization-and-inprogress-insertion.out 2025-10-17 11:5...
@@ -1,51 +1,4 @@
Parsed test spec with 2 sessions
starting permutation: s2check s1b s2b s1i s2summ s1c s2c s2check
-step s2check: SELECT * FROM brin_page_items(get_raw_page('brinidx', 2), 'brinidx'::regclass);
-itemoffset|blknum|attnum|allnulls|hasnulls|placeholder|empty|value
-----------+------+------+--------+--------+-----------+-----+--------
- 1| 0| 1|f |t |f |f |{1 .. 1}
-(1 row)
-
-step s1b: BEGIN ISOLATION LEVEL REPEATABLE READ;
-step s2b: BEGIN ISOLATION LEVEL REPEATABLE READ; SELECT 1;
-?column?
---------
- 1
-(1 row)
-
... |
| 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 2025-10-17 11:49:08.586358555 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pageinspect/regress/results/page.out 2025-10-17 11:53:01.009827729 +0000
@@ -1,4 +1,5 @@
CREATE EXTENSION pageinspect;
+ERROR: extension "pageinspect" has no installation script nor update path for version "1.14"
-- Use a temp table so that effects of VACUUM are predictable
CREATE TEMP TABLE test1 (a int, b int);
INSERT INTO test1 VALUES (16777217, 131584);
@@ -6,207 +7,177 @@
-- The page contents can vary, so just test that it can be read
-- successfully, but don't keep the output.
SELECT octet_length(get_raw_page('test1', 'main', 0)) AS main_0;
- main_0
---------
- 8192
-(1 row)
-
+ERROR: function get_raw_page(unknown, unknown, integer) does not exist
+LINE 1: SELECT octet_length(get_raw_page('test1', 'main', 0)) AS mai...
... |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/modules/brin/expected/summarization-and-inprogress-insertion.out /tmp/cirrus-ci-b...
--- /tmp/cirrus-ci-build/src/test/modules/brin/expected/summarization-and-inprogress-insertion.out 2025-10-17 11:49:08.9...
+++ /tmp/cirrus-ci-build/build/testrun/brin/isolation/results/summarization-and-inprogress-insertion.out 2025-10-17 11:5...
@@ -1,51 +1,4 @@
Parsed test spec with 2 sessions
starting permutation: s2check s1b s2b s1i s2summ s1c s2c s2check
-step s2check: SELECT * FROM brin_page_items(get_raw_page('brinidx', 2), 'brinidx'::regclass);
-itemoffset|blknum|attnum|allnulls|hasnulls|placeholder|empty|value
-----------+------+------+--------+--------+-----------+-----+--------
- 1| 0| 1|f |t |f |f |{1 .. 1}
-(1 row)
-
-step s1b: BEGIN ISOLATION LEVEL REPEATABLE READ;
-step s2b: BEGIN ISOLATION LEVEL REPEATABLE READ; SELECT 1;
-?column?
---------
- 1
-(1 row)
-
... |
| 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 2025-10-17 11:49:07.556567000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pageinspect/regress/results/page.out 2025-10-17 11:51:41.689807000 +0000
@@ -1,4 +1,5 @@
CREATE EXTENSION pageinspect;
+ERROR: extension "pageinspect" has no installation script nor update path for version "1.14"
-- Use a temp table so that effects of VACUUM are predictable
CREATE TEMP TABLE test1 (a int, b int);
INSERT INTO test1 VALUES (16777217, 131584);
@@ -6,207 +7,177 @@
-- The page contents can vary, so just test that it can be read
-- successfully, but don't keep the output.
SELECT octet_length(get_raw_page('test1', 'main', 0)) AS main_0;
- main_0
---------
- 8192
-(1 row)
-
+ERROR: function get_raw_page(unknown, unknown, integer) does not exist
+LINE 1: SELECT octet_length(get_raw_page('test1', 'main', 0)) AS mai...
... |
|
OpenBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/modules/brin/expected/summarization-and-inprogress-insertion.out /home/postgre...
--- /home/postgres/postgres/src/test/modules/brin/expected/summarization-and-inprogress-insertion.out Fri Oct 17 11:49:2...
+++ /home/postgres/postgres/build/testrun/brin/isolation/results/summarization-and-inprogress-insertion.out Fri Oct 17 1...
@@ -1,51 +1,4 @@
Parsed test spec with 2 sessions
starting permutation: s2check s1b s2b s1i s2summ s1c s2c s2check
-step s2check: SELECT * FROM brin_page_items(get_raw_page('brinidx', 2), 'brinidx'::regclass);
-itemoffset|blknum|attnum|allnulls|hasnulls|placeholder|empty|value
-----------+------+------+--------+--------+-----------+-----+--------
- 1| 0| 1|f |t |f |f |{1 .. 1}
-(1 row)
-
-step s1b: BEGIN ISOLATION LEVEL REPEATABLE READ;
-step s2b: BEGIN ISOLATION LEVEL REPEATABLE READ; SELECT 1;
-?column?
---------
- 1
-(1 row)
-
... |
| regress |
diff -U3 /home/postgres/postgres/contrib/pageinspect/expected/page.out /home/postgres/postgres/build/testrun/pageinspect...
--- /home/postgres/postgres/contrib/pageinspect/expected/page.out Fri Oct 17 11:49:14 2025
+++ /home/postgres/postgres/build/testrun/pageinspect/regress/results/page.out Fri Oct 17 11:53:34 2025
@@ -1,4 +1,5 @@
CREATE EXTENSION pageinspect;
+ERROR: extension "pageinspect" has no installation script nor update path for version "1.14"
-- Use a temp table so that effects of VACUUM are predictable
CREATE TEMP TABLE test1 (a int, b int);
INSERT INTO test1 VALUES (16777217, 131584);
@@ -6,207 +7,177 @@
-- The page contents can vary, so just test that it can be read
-- successfully, but don't keep the output.
SELECT octet_length(get_raw_page('test1', 'main', 0)) AS main_0;
- main_0
---------
- 8192
-(1 row)
-
+ERROR: function get_raw_page(unknown, unknown, integer) does not exist
+LINE 1: SELECT octet_length(get_raw_page('test1', 'main', 0)) AS mai...
... |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/modules/brin/expected/summarization-and-inprogress-insertion.out /home/postgre...
--- /home/postgres/postgres/src/test/modules/brin/expected/summarization-and-inprogress-insertion.out 2025-10-17 11:49:3...
+++ /home/postgres/postgres/build/testrun/brin/isolation/results/summarization-and-inprogress-insertion.out 2025-10-17 1...
@@ -1,51 +1,4 @@
Parsed test spec with 2 sessions
starting permutation: s2check s1b s2b s1i s2summ s1c s2c s2check
-step s2check: SELECT * FROM brin_page_items(get_raw_page('brinidx', 2), 'brinidx'::regclass);
-itemoffset|blknum|attnum|allnulls|hasnulls|placeholder|empty|value
-----------+------+------+--------+--------+-----------+-----+--------
- 1| 0| 1|f |t |f |f |{1 .. 1}
-(1 row)
-
-step s1b: BEGIN ISOLATION LEVEL REPEATABLE READ;
-step s2b: BEGIN ISOLATION LEVEL REPEATABLE READ; SELECT 1;
-?column?
---------
- 1
-(1 row)
-
... |
| regress |
diff -U3 /home/postgres/postgres/contrib/pageinspect/expected/page.out /home/postgres/postgres/build/testrun/pageinspect...
--- /home/postgres/postgres/contrib/pageinspect/expected/page.out 2025-10-17 11:49:25.395172813 +0000
+++ /home/postgres/postgres/build/testrun/pageinspect/regress/results/page.out 2025-10-17 11:51:34.413207129 +0000
@@ -1,4 +1,5 @@
CREATE EXTENSION pageinspect;
+ERROR: extension "pageinspect" has no installation script nor update path for version "1.14"
-- Use a temp table so that effects of VACUUM are predictable
CREATE TEMP TABLE test1 (a int, b int);
INSERT INTO test1 VALUES (16777217, 131584);
@@ -6,207 +7,177 @@
-- The page contents can vary, so just test that it can be read
-- successfully, but don't keep the output.
SELECT octet_length(get_raw_page('test1', 'main', 0)) AS main_0;
- main_0
---------
- 8192
-(1 row)
-
+ERROR: function get_raw_page(unknown, unknown, integer) does not exist
+LINE 1: SELECT octet_length(get_raw_page('test1', 'main', 0)) AS mai...
... |
| 56/6029 |
NOT NULL NOT ENFORCED |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/constraints.out /home/postgres/postgres/build/testrun/recover...
--- /home/postgres/postgres/src/test/regress/expected/constraints.out 2025-10-16 07:03:19.662795336 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/constraints.out 2025-10-16 07:05:41.5...
@@ -1034,7 +1034,9 @@
pg_get_constraintdef
-------------------------
NOT NULL x NOT ENFORCED
-(1 row)
+ NOT NULL a2
+ NOT NULL a2
+(3 rows)
INSERT INTO ne_nn_tbl VALUES (NULL); --ok
ALTER TABLE ne_nn_tbl ALTER CONSTRAINT nn ENFORCED; --error |
| 56/6133 |
Extend documentation for pg_stat_replication.backend_xmin |
|
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 2025-10-16 06:33:40.644031000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/postgres_fdw-running/regress/results/postgres_fdw.out 2025-10-16 06:40:47.4528710...
@@ -12691,8 +12691,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
@@ -12708,8 +12707,7 @@
FROM postgres_fdw_get_connections(true);
server_name | closed | remote_backend_pid
-------------+--------+--------------------
- loopback | t | t
-(1 row)
+(0 rows)
... |