PostgreSQL Patch Tester

Current commitfest | Next commitfest | FAQ | Statistics | Highlights

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

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

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

48/4538 Statistics Import and Export
%s Linux - Debian Bullseye - Autoconf
regress 
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/stats_export_import.out /tmp/cirrus-ci-build/src/test/recovery/t...
--- /tmp/cirrus-ci-build/src/test/regress/expected/stats_export_import.out	2024-05-16 08:31:15.784892929 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/stats_export_import.out	2024-05-16 08:37:56.388639331 +0000
@@ -366,7 +366,7 @@
  stats_export_import | test      | id      | f         |       0.5 |         2 |       -0.1 |                  |       ...
 (1 row)
 
--- warn: scalars can't have mcelem 
+-- warn: scalars can't have mcelem
 SELECT pg_catalog.pg_set_attribute_stats(
     'stats_export_import.test'::regclass,
     'id'::name,
@@ -419,7 +419,7 @@
  t
 (1 row)
 
--- ok: mcelem 
+-- ok: mcelem
 SELECT pg_catalog.pg_set_attribute_stats(
     'stats_export_import.test'::regclass,
...
regress 
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/stats_export_import.out /tmp/cirrus-ci-build/src/test/regress/re...
--- /tmp/cirrus-ci-build/src/test/regress/expected/stats_export_import.out	2024-05-16 08:31:15.784892929 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/stats_export_import.out	2024-05-16 08:34:36.576803854 +0000
@@ -366,7 +366,7 @@
  stats_export_import | test      | id      | f         |       0.5 |         2 |       -0.1 |                  |       ...
 (1 row)
 
--- warn: scalars can't have mcelem 
+-- warn: scalars can't have mcelem
 SELECT pg_catalog.pg_set_attribute_stats(
     'stats_export_import.test'::regclass,
     'id'::name,
@@ -419,7 +419,7 @@
  t
 (1 row)
 
--- ok: mcelem 
+-- ok: mcelem
 SELECT pg_catalog.pg_set_attribute_stats(
     'stats_export_import.test'::regclass,
...
48/4617 Allow INSTEAD OF DELETE triggers to modify the tuple for RETURNING
%s Linux - Debian Bullseye - Autoconf
regress 
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out	2024-05-16 06:22:38.965379673 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/triggers.out	2024-05-16 06:25:53.353122971 +0000
@@ -2624,1123 +2624,10 @@
 NOTICE:  trigger parted_trig on parted1_constr AFTER INSERT for ROW: (a,b)=(3,aasvogel)
 NOTICE:  trigger parted_trig_two on parted1_constr AFTER INSERT for ROW: (a,b)=(3,aasvogel)
 drop table parted_constr_ancestor;
-drop function bark(text);
--- Test that the WHEN clause is set properly to partitions
-create table parted_trigger (a int, b text) partition by range (a);
-create table parted_trigger_1 partition of parted_trigger for values from (0) to (1000);
-create table parted_trigger_2 (drp int, a int, b text);
-alter table parted_trigger_2 drop column drp;
-alter table parted_trigger attach partition parted_trigger_2 for values from (1000) to (2000);
-create trigger parted_trigger after update on parted_trigger
-  for each row when (new.a % 2 = 1 and length(old.b) >= 2) execute procedure trigger_notice_ab();
-create table parted_trigger_3 (b text, a int) partition by range (length(b));
-create table parted_trigger_3_1 partition of parted_trigger_3 for values from (1) to (3);
-create table parted_trigger_3_2 partition of parted_trigger_3 for values from (3) to (5);
-alter table parted_trigger attach partition parted_trigger_3 for values from (2000) to (3000);
...
regress 
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/src/test/regress/results/trigg...
--- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out	2024-05-16 06:22:38.965379673 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/triggers.out	2024-05-16 06:24:53.941186996 +0000
@@ -2657,1090 +2657,10 @@
 create constraint trigger parted_trigger after update on parted_trigger
   from parted_referenced
   for each row execute procedure trigger_notice_ab();
-create constraint trigger parted_trigger after update on unparted_trigger
-  from parted_referenced
-  for each row execute procedure trigger_notice_ab();
-create table parted_trigger_3 (b text, a int) partition by range (length(b));
-create table parted_trigger_3_1 partition of parted_trigger_3 for values from (1) to (3);
-create table parted_trigger_3_2 partition of parted_trigger_3 for values from (3) to (5);
-alter table parted_trigger attach partition parted_trigger_3 for values from (2000) to (3000);
-select tgname, conname, t.tgrelid::regclass, t.tgconstrrelid::regclass,
-  c.conrelid::regclass, c.confrelid::regclass
-  from pg_trigger t join pg_constraint c on (t.tgconstraint = c.oid)
-  where tgname = 'parted_trigger'
-  order by t.tgrelid::regclass::text;
-     tgname     |    conname     |      tgrelid       |   tgconstrrelid   |      conrelid      | confrelid 
...
%s Windows - Server 2019, VS 2019 - Meson & ninja
regress 
diff -w -U3 C:/cirrus/src/test/regress/expected/updatable_views.out C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/da...
--- C:/cirrus/src/test/regress/expected/updatable_views.out	2024-05-16 06:23:48.178175900 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/updatable_views.out	2024-05-16 06:26:13.817521900 +00...
@@ -1155,2847 +1155,7 @@
   WHEN MATCHED THEN UPDATE SET b = s.b
   WHEN NOT MATCHED AND s.a > 0 THEN INSERT VALUES (s.a, s.b)
   RETURNING merge_action(), s.*, t.*;
- merge_action | a | b  | a |   b   
---------------+---+----+---+-------
- DELETE       | 1 | R1 | 1 | Row 1
- UPDATE       | 2 | R2 | 2 | R2
- INSERT       | 3 | R3 | 3 | R3
-(3 rows)
-
-SELECT * FROM base_tbl ORDER BY a;
- a  |   b    
-----+--------
- -2 | Row -2
- -1 | Row -1
-  0 | Row 0
...
regress 
diff -w -U3 C:/cirrus/src/test/regress/expected/updatable_views.out C:/cirrus/build/testrun/recovery/027_stream_regress/...
--- C:/cirrus/src/test/regress/expected/updatable_views.out	2024-05-16 06:23:48.178175900 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/updatable_views.out	2024-05-16 06:27:59.155295100 +...
@@ -1155,2847 +1155,7 @@
   WHEN MATCHED THEN UPDATE SET b = s.b
   WHEN NOT MATCHED AND s.a > 0 THEN INSERT VALUES (s.a, s.b)
   RETURNING merge_action(), s.*, t.*;
- merge_action | a | b  | a |   b   
---------------+---+----+---+-------
- DELETE       | 1 | R1 | 1 | Row 1
- UPDATE       | 2 | R2 | 2 | R2
- INSERT       | 3 | R3 | 3 | R3
-(3 rows)
-
-SELECT * FROM base_tbl ORDER BY a;
- a  |   b    
-----+--------
- -2 | Row -2
- -1 | Row -1
-  0 | Row 0
...
regress 
diff -w -U3 C:/cirrus/src/test/regress/expected/updatable_views.out C:/cirrus/build/testrun/regress/regress/results/upda...
--- C:/cirrus/src/test/regress/expected/updatable_views.out	2024-05-16 06:23:48.178175900 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/updatable_views.out	2024-05-16 06:26:13.269674300 +0000
@@ -1155,2847 +1155,7 @@
   WHEN MATCHED THEN UPDATE SET b = s.b
   WHEN NOT MATCHED AND s.a > 0 THEN INSERT VALUES (s.a, s.b)
   RETURNING merge_action(), s.*, t.*;
- merge_action | a | b  | a |   b   
---------------+---+----+---+-------
- DELETE       | 1 | R1 | 1 | Row 1
- UPDATE       | 2 | R2 | 2 | R2
- INSERT       | 3 | R3 | 3 | R3
-(3 rows)
-
-SELECT * FROM base_tbl ORDER BY a;
- a  |   b    
-----+--------
- -2 | Row -2
- -1 | Row -1
-  0 | Row 0
...
%s macOS - Ventura - Meson
regress 
diff -U3 /Users/admin/pgsql/src/test/regress/expected/updatable_views.out /Users/admin/pgsql/build/testrun/pg_upgrade/00...
--- /Users/admin/pgsql/src/test/regress/expected/updatable_views.out	2024-05-16 06:22:37
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/updatable_views.out	2024-05-16 06:25:23
@@ -1152,2850 +1152,10 @@
 MERGE INTO rw_view2 t
   USING (SELECT x, 'R'||x FROM generate_series(0,3) x) AS s(a,b) ON t.a = s.a
   WHEN MATCHED AND t.a <= 1 THEN DELETE
-  WHEN MATCHED THEN UPDATE SET b = s.b
-  WHEN NOT MATCHED AND s.a > 0 THEN INSERT VALUES (s.a, s.b)
-  RETURNING merge_action(), s.*, t.*;
- merge_action | a | b  | a |   b   
---------------+---+----+---+-------
- DELETE       | 1 | R1 | 1 | Row 1
- UPDATE       | 2 | R2 | 2 | R2
- INSERT       | 3 | R3 | 3 | R3
-(3 rows)
-
-SELECT * FROM base_tbl ORDER BY a;
- a  |   b    
-----+--------
...
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	2024-05-16 06:22:37
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/triggers.out	2024-05-16 06:25:46
@@ -993,2754 +993,10 @@
 (1 row)
 
 DROP TABLE serializable_update_tab;
--- minimal update trigger
-CREATE TABLE min_updates_test (
-	f1	text,
-	f2 int,
-	f3 int);
-INSERT INTO min_updates_test VALUES ('a',1,2),('b','2',null);
-CREATE TRIGGER z_min_update
-BEFORE UPDATE ON min_updates_test
-FOR EACH ROW EXECUTE PROCEDURE suppress_redundant_updates_trigger();
-\set QUIET false
-UPDATE min_updates_test SET f1 = f1;
-UPDATE 0
-UPDATE min_updates_test SET f2 = f2 + 1;
...
regress 
diff -U3 /Users/admin/pgsql/src/test/regress/expected/updatable_views.out /Users/admin/pgsql/build/testrun/regress/regre...
--- /Users/admin/pgsql/src/test/regress/expected/updatable_views.out	2024-05-16 06:22:37
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/updatable_views.out	2024-05-16 06:25:22
@@ -1152,2850 +1152,10 @@
 MERGE INTO rw_view2 t
   USING (SELECT x, 'R'||x FROM generate_series(0,3) x) AS s(a,b) ON t.a = s.a
   WHEN MATCHED AND t.a <= 1 THEN DELETE
-  WHEN MATCHED THEN UPDATE SET b = s.b
-  WHEN NOT MATCHED AND s.a > 0 THEN INSERT VALUES (s.a, s.b)
-  RETURNING merge_action(), s.*, t.*;
- merge_action | a | b  | a |   b   
---------------+---+----+---+-------
- DELETE       | 1 | R1 | 1 | Row 1
- UPDATE       | 2 | R2 | 2 | R2
- INSERT       | 3 | R3 | 3 | R3
-(3 rows)
-
-SELECT * FROM base_tbl ORDER BY a;
- a  |   b    
-----+--------
...
48/4456 pg_tracing
%s Linux - Debian Bullseye - Autoconf
regress 
diff -U3 /tmp/cirrus-ci-build/contrib/pg_tracing/expected/insert.out /tmp/cirrus-ci-build/contrib/pg_tracing/results/ins...
--- /tmp/cirrus-ci-build/contrib/pg_tracing/expected/insert.out	2024-05-15 17:35:12.555829565 +0000
+++ /tmp/cirrus-ci-build/contrib/pg_tracing/results/insert.out	2024-05-15 17:37:41.107734498 +0000
@@ -9,9 +9,7 @@
  ProcessUtility | ProcessUtility                                                                                       ...
  Utility query  | CREATE TABLE IF NOT EXISTS pg_tracing_test_table_with_constraint (a int, b char(20), CONSTRAINT PK_tr...
  ProcessUtility | ProcessUtility                                                                                       ...
- Utility query  | CREATE TABLE IF NOT EXISTS pg_tracing_test_table_with_constraint (a int, b char(20), CONSTRAINT PK_tr...
- ProcessUtility | ProcessUtility                                                                                       ...
-(6 rows)
+(4 rows)
 
 -- Simple insertion
 /*dddbs='postgres.db',traceparent='00-00000000000000000000000000000002-0000000000000002-01'*/ INSERT INTO pg_tracing_te...
%s Windows - Server 2019, VS 2019 - Meson & ninja
regress 
diff -w -U3 C:/cirrus/contrib/pg_tracing/expected/insert.out C:/cirrus/build/testrun/pg_tracing/regress/results/insert.o...
--- C:/cirrus/contrib/pg_tracing/expected/insert.out	2024-05-15 17:35:29.285417900 +0000
+++ C:/cirrus/build/testrun/pg_tracing/regress/results/insert.out	2024-05-15 17:41:40.798093100 +0000
@@ -9,9 +9,7 @@
  ProcessUtility | ProcessUtility                                                                                       ...
  Utility query  | CREATE TABLE IF NOT EXISTS pg_tracing_test_table_with_constraint (a int, b char(20), CONSTRAINT PK_tr...
  ProcessUtility | ProcessUtility                                                                                       ...
- Utility query  | CREATE TABLE IF NOT EXISTS pg_tracing_test_table_with_constraint (a int, b char(20), CONSTRAINT PK_tr...
- ProcessUtility | ProcessUtility                                                                                       ...
-(6 rows)
+(4 rows)
 
 -- Simple insertion
 /*dddbs='postgres.db',traceparent='00-00000000000000000000000000000002-0000000000000002-01'*/ INSERT INTO pg_tracing_te...
%s macOS - Ventura - Meson
regress 
diff -U3 /Users/admin/pgsql/contrib/pg_tracing/expected/insert.out /Users/admin/pgsql/build/testrun/pg_tracing/regress/r...
--- /Users/admin/pgsql/contrib/pg_tracing/expected/insert.out	2024-05-15 17:35:14
+++ /Users/admin/pgsql/build/testrun/pg_tracing/regress/results/insert.out	2024-05-15 17:39:03
@@ -9,9 +9,7 @@
  ProcessUtility | ProcessUtility                                                                                       ...
  Utility query  | CREATE TABLE IF NOT EXISTS pg_tracing_test_table_with_constraint (a int, b char(20), CONSTRAINT PK_tr...
  ProcessUtility | ProcessUtility                                                                                       ...
- Utility query  | CREATE TABLE IF NOT EXISTS pg_tracing_test_table_with_constraint (a int, b char(20), CONSTRAINT PK_tr...
- ProcessUtility | ProcessUtility                                                                                       ...
-(6 rows)
+(4 rows)
 
 -- Simple insertion
 /*dddbs='postgres.db',traceparent='00-00000000000000000000000000000002-0000000000000002-01'*/ INSERT INTO pg_tracing_te...
48/4759 shared detoast datum
%s Linux - Debian Bullseye - 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	2024-05-15 17:00:00.833543480 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/sysviews.out	2024-05-15 17:04:07.793118642 +0000
@@ -156,7 +156,8 @@
  enable_seqscan                 | on
  enable_sort                    | on
  enable_tidscan                 | on
-(22 rows)
+ enable_toast_cache             | off
+(23 rows)
 
 -- There are always wait event descriptions for various types.
 select type, count(*) > 0 as ok FROM pg_wait_events
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	2024-05-15 17:00:00.833543480 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/sysviews.out	2024-05-15 17:05:33.208998536 +0000
@@ -156,7 +156,8 @@
  enable_seqscan                 | on
  enable_sort                    | on
  enable_tidscan                 | on
-(22 rows)
+ enable_toast_cache             | off
+(23 rows)
 
 -- There are always wait event descriptions for various types.
 select type, count(*) > 0 as ok FROM pg_wait_events
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	2024-05-15 17:00:00.833543480 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/sysviews.out	2024-05-15 17:02:07.405402081 +0000
@@ -156,7 +156,8 @@
  enable_seqscan                 | on
  enable_sort                    | on
  enable_tidscan                 | on
-(22 rows)
+ enable_toast_cache             | off
+(23 rows)
 
 -- There are always wait event descriptions for various types.
 select type, count(*) > 0 as ok FROM pg_wait_events
%s Windows - Server 2019, VS 2019 - Meson & ninja
regress 
diff -w -U3 C:/cirrus/src/test/regress/expected/sysviews.out C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/resu...
--- C:/cirrus/src/test/regress/expected/sysviews.out	2024-05-15 17:00:20.587020500 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/sysviews.out	2024-05-15 17:03:22.188764500 +0000
@@ -156,7 +156,8 @@
  enable_seqscan                 | on
  enable_sort                    | on
  enable_tidscan                 | on
-(22 rows)
+ enable_toast_cache             | off
+(23 rows)
 
 -- There are always wait event descriptions for various types.
 select type, count(*) > 0 as ok FROM pg_wait_events
regress 
diff -w -U3 C:/cirrus/src/test/regress/expected/sysviews.out C:/cirrus/build/testrun/recovery/027_stream_regress/data/re...
--- C:/cirrus/src/test/regress/expected/sysviews.out	2024-05-15 17:00:20.587020500 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/sysviews.out	2024-05-15 17:05:42.551027200 +0000
@@ -156,7 +156,8 @@
  enable_seqscan                 | on
  enable_sort                    | on
  enable_tidscan                 | on
-(22 rows)
+ enable_toast_cache             | off
+(23 rows)
 
 -- There are always wait event descriptions for various types.
 select type, count(*) > 0 as ok FROM pg_wait_events
regress 
diff -w -U3 C:/cirrus/src/test/regress/expected/sysviews.out C:/cirrus/build/testrun/regress/regress/results/sysviews.ou...
--- C:/cirrus/src/test/regress/expected/sysviews.out	2024-05-15 17:00:20.587020500 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/sysviews.out	2024-05-15 17:03:17.637979000 +0000
@@ -156,7 +156,8 @@
  enable_seqscan                 | on
  enable_sort                    | on
  enable_tidscan                 | on
-(22 rows)
+ enable_toast_cache             | off
+(23 rows)
 
 -- There are always wait event descriptions for various types.
 select type, count(*) > 0 as ok FROM pg_wait_events
%s macOS - Ventura - 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	2024-05-15 16:59:58
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/sysviews.out	2024-05-15 17:04:11
@@ -156,7 +156,8 @@
  enable_seqscan                 | on
  enable_sort                    | on
  enable_tidscan                 | on
-(22 rows)
+ enable_toast_cache             | off
+(23 rows)
 
 -- There are always wait event descriptions for various types.
 select type, count(*) > 0 as ok FROM pg_wait_events
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	2024-05-15 16:59:58
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/sysviews.out	2024-05-15 17:05:58
@@ -156,7 +156,8 @@
  enable_seqscan                 | on
  enable_sort                    | on
  enable_tidscan                 | on
-(22 rows)
+ enable_toast_cache             | off
+(23 rows)
 
 -- There are always wait event descriptions for various types.
 select type, count(*) > 0 as ok FROM pg_wait_events
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	2024-05-15 16:59:58
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/sysviews.out	2024-05-15 17:04:11
@@ -156,7 +156,8 @@
  enable_seqscan                 | on
  enable_sort                    | on
  enable_tidscan                 | on
-(22 rows)
+ enable_toast_cache             | off
+(23 rows)
 
 -- There are always wait event descriptions for various types.
 select type, count(*) > 0 as ok FROM pg_wait_events
48/4450 Replace a large number of OR clauses with ANY expression
%s Linux - Debian Bullseye - Autoconf
regress 
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_che...
--- /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out	2024-05-15 12:07:09.297736936 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/create_index.out	2024-05-15 12:10:42.717436427 +0000
@@ -2135,11 +2135,19 @@
 --
 explain (costs off)
 SELECT unique1 FROM tenk1 WHERE unique1 IN (1, 42, 7) and unique1 = ANY('{7, 8, 9}');
-                                             QUERY PLAN                                             
-----------------------------------------------------------------------------------------------------
- Index Only Scan using tenk1_unique1 on tenk1
-   Index Cond: ((unique1 = ANY ('{1,42,7}'::integer[])) AND (unique1 = ANY ('{7,8,9}'::integer[])))
-(2 rows)
+                            QUERY PLAN                             
+-------------------------------------------------------------------
+ Bitmap Heap Scan on tenk1
+   Recheck Cond: ((unique1 = 7) OR (unique1 = 8) OR (unique1 = 9))
+   Filter: (unique1 = ANY ('{1,42,7}'::integer[]))
+   ->  BitmapOr
+         ->  Bitmap Index Scan on tenk1_unique1
+               Index Cond: (unique1 = 7)
...
regress 
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out /tmp/cirrus-ci-build/src/test/recovery/tmp_chec...
--- /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out	2024-05-15 12:07:09.297736936 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/create_index.out	2024-05-15 12:12:42.117226123 +0000
@@ -2135,11 +2135,19 @@
 --
 explain (costs off)
 SELECT unique1 FROM tenk1 WHERE unique1 IN (1, 42, 7) and unique1 = ANY('{7, 8, 9}');
-                                             QUERY PLAN                                             
-----------------------------------------------------------------------------------------------------
- Index Only Scan using tenk1_unique1 on tenk1
-   Index Cond: ((unique1 = ANY ('{1,42,7}'::integer[])) AND (unique1 = ANY ('{7,8,9}'::integer[])))
-(2 rows)
+                            QUERY PLAN                             
+-------------------------------------------------------------------
+ Bitmap Heap Scan on tenk1
+   Recheck Cond: ((unique1 = 7) OR (unique1 = 8) OR (unique1 = 9))
+   Filter: (unique1 = ANY ('{1,42,7}'::integer[]))
+   ->  BitmapOr
+         ->  Bitmap Index Scan on tenk1_unique1
+               Index Cond: (unique1 = 7)
...
regress 
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out /tmp/cirrus-ci-build/src/test/regress/results/c...
--- /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out	2024-05-15 12:07:09.297736936 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/create_index.out	2024-05-15 12:09:06.029598812 +0000
@@ -2135,11 +2135,19 @@
 --
 explain (costs off)
 SELECT unique1 FROM tenk1 WHERE unique1 IN (1, 42, 7) and unique1 = ANY('{7, 8, 9}');
-                                             QUERY PLAN                                             
-----------------------------------------------------------------------------------------------------
- Index Only Scan using tenk1_unique1 on tenk1
-   Index Cond: ((unique1 = ANY ('{1,42,7}'::integer[])) AND (unique1 = ANY ('{7,8,9}'::integer[])))
-(2 rows)
+                            QUERY PLAN                             
+-------------------------------------------------------------------
+ Bitmap Heap Scan on tenk1
+   Recheck Cond: ((unique1 = 7) OR (unique1 = 8) OR (unique1 = 9))
+   Filter: (unique1 = ANY ('{1,42,7}'::integer[]))
+   ->  BitmapOr
+         ->  Bitmap Index Scan on tenk1_unique1
+               Index Cond: (unique1 = 7)
...
%s Windows - Server 2019, VS 2019 - Meson & ninja
regress 
diff -w -U3 C:/cirrus/src/test/regress/expected/create_index.out C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/...
--- C:/cirrus/src/test/regress/expected/create_index.out	2024-05-15 12:07:29.228750300 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/create_index.out	2024-05-15 12:09:50.977207300 +0000
@@ -2136,10 +2136,18 @@
 explain (costs off)
 SELECT unique1 FROM tenk1 WHERE unique1 IN (1, 42, 7) and unique1 = ANY('{7, 8, 9}');
                                              QUERY PLAN                                             
-----------------------------------------------------------------------------------------------------
- Index Only Scan using tenk1_unique1 on tenk1
-   Index Cond: ((unique1 = ANY ('{1,42,7}'::integer[])) AND (unique1 = ANY ('{7,8,9}'::integer[])))
-(2 rows)
+-------------------------------------------------------------------
+ Bitmap Heap Scan on tenk1
+   Recheck Cond: ((unique1 = 7) OR (unique1 = 8) OR (unique1 = 9))
+   Filter: (unique1 = ANY ('{1,42,7}'::integer[]))
+   ->  BitmapOr
+         ->  Bitmap Index Scan on tenk1_unique1
+               Index Cond: (unique1 = 7)
+         ->  Bitmap Index Scan on tenk1_unique1
+               Index Cond: (unique1 = 8)
...
regress 
diff -w -U3 C:/cirrus/src/test/regress/expected/create_index.out C:/cirrus/build/testrun/recovery/027_stream_regress/dat...
--- C:/cirrus/src/test/regress/expected/create_index.out	2024-05-15 12:07:29.228750300 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/create_index.out	2024-05-15 12:12:23.385890400 +000...
@@ -2136,10 +2136,18 @@
 explain (costs off)
 SELECT unique1 FROM tenk1 WHERE unique1 IN (1, 42, 7) and unique1 = ANY('{7, 8, 9}');
                                              QUERY PLAN                                             
-----------------------------------------------------------------------------------------------------
- Index Only Scan using tenk1_unique1 on tenk1
-   Index Cond: ((unique1 = ANY ('{1,42,7}'::integer[])) AND (unique1 = ANY ('{7,8,9}'::integer[])))
-(2 rows)
+-------------------------------------------------------------------
+ Bitmap Heap Scan on tenk1
+   Recheck Cond: ((unique1 = 7) OR (unique1 = 8) OR (unique1 = 9))
+   Filter: (unique1 = ANY ('{1,42,7}'::integer[]))
+   ->  BitmapOr
+         ->  Bitmap Index Scan on tenk1_unique1
+               Index Cond: (unique1 = 7)
+         ->  Bitmap Index Scan on tenk1_unique1
+               Index Cond: (unique1 = 8)
...
regress 
diff -w -U3 C:/cirrus/src/test/regress/expected/create_index.out C:/cirrus/build/testrun/regress/regress/results/create_...
--- C:/cirrus/src/test/regress/expected/create_index.out	2024-05-15 12:07:29.228750300 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/create_index.out	2024-05-15 12:09:43.355682100 +0000
@@ -2136,10 +2136,18 @@
 explain (costs off)
 SELECT unique1 FROM tenk1 WHERE unique1 IN (1, 42, 7) and unique1 = ANY('{7, 8, 9}');
                                              QUERY PLAN                                             
-----------------------------------------------------------------------------------------------------
- Index Only Scan using tenk1_unique1 on tenk1
-   Index Cond: ((unique1 = ANY ('{1,42,7}'::integer[])) AND (unique1 = ANY ('{7,8,9}'::integer[])))
-(2 rows)
+-------------------------------------------------------------------
+ Bitmap Heap Scan on tenk1
+   Recheck Cond: ((unique1 = 7) OR (unique1 = 8) OR (unique1 = 9))
+   Filter: (unique1 = ANY ('{1,42,7}'::integer[]))
+   ->  BitmapOr
+         ->  Bitmap Index Scan on tenk1_unique1
+               Index Cond: (unique1 = 7)
+         ->  Bitmap Index Scan on tenk1_unique1
+               Index Cond: (unique1 = 8)
...
%s macOS - Ventura - Meson
regress 
diff -U3 /Users/admin/pgsql/src/test/regress/expected/create_index.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_p...
--- /Users/admin/pgsql/src/test/regress/expected/create_index.out	2024-05-15 12:07:15
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/create_index.out	2024-05-15 12:09:35
@@ -2135,11 +2135,19 @@
 --
 explain (costs off)
 SELECT unique1 FROM tenk1 WHERE unique1 IN (1, 42, 7) and unique1 = ANY('{7, 8, 9}');
-                                             QUERY PLAN                                             
-----------------------------------------------------------------------------------------------------
- Index Only Scan using tenk1_unique1 on tenk1
-   Index Cond: ((unique1 = ANY ('{1,42,7}'::integer[])) AND (unique1 = ANY ('{7,8,9}'::integer[])))
-(2 rows)
+                            QUERY PLAN                             
+-------------------------------------------------------------------
+ Bitmap Heap Scan on tenk1
+   Recheck Cond: ((unique1 = 7) OR (unique1 = 8) OR (unique1 = 9))
+   Filter: (unique1 = ANY ('{1,42,7}'::integer[]))
+   ->  BitmapOr
+         ->  Bitmap Index Scan on tenk1_unique1
+               Index Cond: (unique1 = 7)
...
regress 
diff -U3 /Users/admin/pgsql/src/test/regress/expected/create_index.out /Users/admin/pgsql/build/testrun/recovery/027_str...
--- /Users/admin/pgsql/src/test/regress/expected/create_index.out	2024-05-15 12:07:15
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/create_index.out	2024-05-15 12:10:44
@@ -2135,11 +2135,19 @@
 --
 explain (costs off)
 SELECT unique1 FROM tenk1 WHERE unique1 IN (1, 42, 7) and unique1 = ANY('{7, 8, 9}');
-                                             QUERY PLAN                                             
-----------------------------------------------------------------------------------------------------
- Index Only Scan using tenk1_unique1 on tenk1
-   Index Cond: ((unique1 = ANY ('{1,42,7}'::integer[])) AND (unique1 = ANY ('{7,8,9}'::integer[])))
-(2 rows)
+                            QUERY PLAN                             
+-------------------------------------------------------------------
+ Bitmap Heap Scan on tenk1
+   Recheck Cond: ((unique1 = 7) OR (unique1 = 8) OR (unique1 = 9))
+   Filter: (unique1 = ANY ('{1,42,7}'::integer[]))
+   ->  BitmapOr
+         ->  Bitmap Index Scan on tenk1_unique1
+               Index Cond: (unique1 = 7)
...
regress 
diff -U3 /Users/admin/pgsql/src/test/regress/expected/create_index.out /Users/admin/pgsql/build/testrun/regress/regress/...
--- /Users/admin/pgsql/src/test/regress/expected/create_index.out	2024-05-15 12:07:15
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/create_index.out	2024-05-15 12:09:33
@@ -2135,11 +2135,19 @@
 --
 explain (costs off)
 SELECT unique1 FROM tenk1 WHERE unique1 IN (1, 42, 7) and unique1 = ANY('{7, 8, 9}');
-                                             QUERY PLAN                                             
-----------------------------------------------------------------------------------------------------
- Index Only Scan using tenk1_unique1 on tenk1
-   Index Cond: ((unique1 = ANY ('{1,42,7}'::integer[])) AND (unique1 = ANY ('{7,8,9}'::integer[])))
-(2 rows)
+                            QUERY PLAN                             
+-------------------------------------------------------------------
+ Bitmap Heap Scan on tenk1
+   Recheck Cond: ((unique1 = 7) OR (unique1 = 8) OR (unique1 = 9))
+   Filter: (unique1 = ANY ('{1,42,7}'::integer[]))
+   ->  BitmapOr
+         ->  Bitmap Index Scan on tenk1_unique1
+               Index Cond: (unique1 = 7)
...
48/4882 Add a pg_truncate_freespace_map function
%s Windows - Server 2019, VS 2019 - Meson & ninja
regress 
diff -w -U3 C:/cirrus/contrib/pg_freespacemap/expected/pg_freespacemap.out C:/cirrus/build/testrun/pg_freespacemap/regre...
--- C:/cirrus/contrib/pg_freespacemap/expected/pg_freespacemap.out	2024-05-15 12:05:06.904493600 +0000
+++ C:/cirrus/build/testrun/pg_freespacemap/regress/results/pg_freespacemap.out	2024-05-15 12:11:16.129730900 +0000
@@ -1,4 +1,5 @@
 CREATE EXTENSION pg_freespacemap;
+ERROR:  extension "pg_freespacemap" has no installation script nor update path for version "1.3"
 CREATE TABLE freespace_tab (c1 int) WITH (autovacuum_enabled = off);
 CREATE INDEX freespace_brin ON freespace_tab USING brin (c1);
 CREATE INDEX freespace_btree ON freespace_tab USING btree (c1);
@@ -8,78 +9,39 @@
   SELECT rel.id, fsm.blkno, (fsm.avail > 0) AS is_avail
     FROM rel, LATERAL pg_freespace(rel.id) AS fsm
     ORDER BY 1, 2;
-       id        | blkno | is_avail 
------------------+-------+----------
- freespace_brin  |     0 | f
- freespace_brin  |     1 | f
- freespace_brin  |     2 | t
- freespace_btree |     0 | f
- freespace_hash  |     0 | f
...
%s macOS - Ventura - Meson
regress 
diff -U3 /Users/admin/pgsql/contrib/pg_freespacemap/expected/pg_freespacemap.out /Users/admin/pgsql/build/testrun/pg_fre...
--- /Users/admin/pgsql/contrib/pg_freespacemap/expected/pg_freespacemap.out	2024-05-15 12:04:55
+++ /Users/admin/pgsql/build/testrun/pg_freespacemap/regress/results/pg_freespacemap.out	2024-05-15 12:08:48
@@ -1,4 +1,5 @@
 CREATE EXTENSION pg_freespacemap;
+ERROR:  extension "pg_freespacemap" has no installation script nor update path for version "1.3"
 CREATE TABLE freespace_tab (c1 int) WITH (autovacuum_enabled = off);
 CREATE INDEX freespace_brin ON freespace_tab USING brin (c1);
 CREATE INDEX freespace_btree ON freespace_tab USING btree (c1);
@@ -8,78 +9,39 @@
   SELECT rel.id, fsm.blkno, (fsm.avail > 0) AS is_avail
     FROM rel, LATERAL pg_freespace(rel.id) AS fsm
     ORDER BY 1, 2;
-       id        | blkno | is_avail 
------------------+-------+----------
- freespace_brin  |     0 | f
- freespace_brin  |     1 | f
- freespace_brin  |     2 | t
- freespace_btree |     0 | f
- freespace_hash  |     0 | f
...
48/4873 unaccent: understand ancient Greek "oxia" and other codepoints merged by Unicode
%s Linux - Debian Bullseye - Autoconf
regress 
diff -U3 /tmp/cirrus-ci-build/contrib/unaccent/expected/unaccent.out /tmp/cirrus-ci-build/contrib/unaccent/results/unacc...
--- /tmp/cirrus-ci-build/contrib/unaccent/expected/unaccent.out	2024-05-15 06:56:56.699153952 +0000
+++ /tmp/cirrus-ci-build/contrib/unaccent/results/unaccent.out	2024-05-15 07:00:57.594956827 +0000
@@ -8,8 +8,10 @@
 \quit
 \endif
 CREATE EXTENSION unaccent;
+WARNING:  duplicate source strings, first one will be used
 SET client_encoding TO 'UTF8';
 SELECT unaccent('foobar');
+WARNING:  duplicate source strings, first one will be used
  unaccent 
 ----------
  foobar
%s macOS - Ventura - Meson
regress 
diff -U3 /Users/admin/pgsql/contrib/unaccent/expected/unaccent.out /Users/admin/pgsql/build/testrun/unaccent/regress/res...
--- /Users/admin/pgsql/contrib/unaccent/expected/unaccent.out	2024-05-15 06:56:51
+++ /Users/admin/pgsql/build/testrun/unaccent/regress/results/unaccent.out	2024-05-15 06:59:27
@@ -8,8 +8,10 @@
 \quit
 \endif
 CREATE EXTENSION unaccent;
+WARNING:  duplicate source strings, first one will be used
 SET client_encoding TO 'UTF8';
 SELECT unaccent('foobar');
+WARNING:  duplicate source strings, first one will be used
  unaccent 
 ----------
  foobar
48/4933 Use macro to define the number of enum values (was: Replace magic constant ...)
%s Windows - Server 2019, VS 2019 - Meson & ninja
regress 
diff -w -U3 C:/cirrus/src/test/regress/expected/partition_merge.out C:/cirrus/build/testrun/recovery/027_stream_regress/...
--- C:/cirrus/src/test/regress/expected/partition_merge.out	2024-05-13 10:34:53.585107900 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/partition_merge.out	2024-05-13 10:41:12.935063000 +...
@@ -897,17 +897,24 @@
 ERROR:  must be owner of table tp_0_1
 RESET SESSION AUTHORIZATION;
 ALTER TABLE tp_0_1 OWNER TO regress_partition_merge_bob;
+ERROR:  relation "tp_0_1" does not exist
 SET SESSION AUTHORIZATION regress_partition_merge_bob;
 ALTER TABLE t MERGE PARTITIONS (tp_0_1, tp_1_2) INTO tp_0_2;
-ERROR:  must be owner of table tp_1_2
+ERROR:  relation "t" does not exist
 RESET SESSION AUTHORIZATION;
 ALTER TABLE tp_1_2 OWNER TO regress_partition_merge_bob;
+ERROR:  relation "tp_1_2" does not exist
 SET SESSION AUTHORIZATION regress_partition_merge_bob;
+ERROR:  role "regress_partition_merge_bob" does not exist
 ALTER TABLE t MERGE PARTITIONS (tp_0_1, tp_1_2) INTO tp_0_2;
+ERROR:  relation "t" does not exist
 RESET SESSION AUTHORIZATION;
...
48/4961 Fix bug when calling strncmp in check_authmethod_valid
%s FreeBSD - 13 - 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	2024-05-13 06:39:03.971405000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/postgres_fdw-running/regress/results/postgres_fdw.out	2024-05-13 06:44:17.5065390...
@@ -2754,6 +2754,7 @@
 SET LOCAL statement_timeout = '10ms';
 select count(*) from ft1 CROSS JOIN ft2 CROSS JOIN ft4 CROSS JOIN ft5; -- this takes very long
 ERROR:  canceling statement due to statement timeout
+WARNING:  could not get result of cancel request due to timeout
 COMMIT;
 -- ====================================================================
 -- Check that userid to use when querying the remote table is correctly
48/4308 SQL:2011 application time
%s FreeBSD - 13 - Meson
regress 
diff -U3 /tmp/cirrus-ci-build/contrib/btree_gist/expected/without_overlaps.out /tmp/cirrus-ci-build/build/testrun/btree_...
--- /tmp/cirrus-ci-build/contrib/btree_gist/expected/without_overlaps.out	2024-05-13 01:05:51.446919000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/btree_gist/regress/results/without_overlaps.out	2024-05-13 01:08:30.231911000 +00...
@@ -16,6 +16,8 @@
  valid_at | daterange |           | not null | 
 Indexes:
     "temporal_rng_pk" PRIMARY KEY (id, valid_at WITHOUT OVERLAPS)
+Check constraints:
+    "valid_at_not_empty" CHECK (NOT isempty(valid_at))
 
 SELECT pg_get_constraintdef(oid) FROM pg_constraint WHERE conname = 'temporal_rng_pk';
             pg_get_constraintdef             
@@ -60,6 +62,8 @@
  parent_id | integer   |           |          | 
 Indexes:
     "temporal_fk_rng2rng_pk" PRIMARY KEY (id, valid_at WITHOUT OVERLAPS)
+Check constraints:
+    "valid_at_not_empty" CHECK (NOT isempty(valid_at))
 Foreign-key constraints:
     "temporal_fk_rng2rng_fk" FOREIGN KEY (parent_id, PERIOD valid_at) REFERENCES temporal_rng(id, PERIOD valid_at)
...
%s Linux - Debian Bullseye - Autoconf
regress 
diff -U3 /tmp/cirrus-ci-build/contrib/btree_gist/expected/without_overlaps.out /tmp/cirrus-ci-build/contrib/btree_gist/r...
--- /tmp/cirrus-ci-build/contrib/btree_gist/expected/without_overlaps.out	2024-05-13 01:04:45.534336644 +0000
+++ /tmp/cirrus-ci-build/contrib/btree_gist/results/without_overlaps.out	2024-05-13 01:08:53.750389446 +0000
@@ -16,6 +16,8 @@
  valid_at | daterange |           | not null | 
 Indexes:
     "temporal_rng_pk" PRIMARY KEY (id, valid_at WITHOUT OVERLAPS)
+Check constraints:
+    "valid_at_not_empty" CHECK (NOT isempty(valid_at))
 
 SELECT pg_get_constraintdef(oid) FROM pg_constraint WHERE conname = 'temporal_rng_pk';
             pg_get_constraintdef             
@@ -60,6 +62,8 @@
  parent_id | integer   |           |          | 
 Indexes:
     "temporal_fk_rng2rng_pk" PRIMARY KEY (id, valid_at WITHOUT OVERLAPS)
+Check constraints:
+    "valid_at_not_empty" CHECK (NOT isempty(valid_at))
 Foreign-key constraints:
     "temporal_fk_rng2rng_fk" FOREIGN KEY (parent_id, PERIOD valid_at) REFERENCES temporal_rng(id, PERIOD valid_at)
...
%s Linux - Debian Bullseye - Meson
regress 
diff -U3 /tmp/cirrus-ci-build/contrib/btree_gist/expected/without_overlaps.out /tmp/cirrus-ci-build/build/testrun/btree_...
--- /tmp/cirrus-ci-build/contrib/btree_gist/expected/without_overlaps.out	2024-05-13 01:04:45.534992707 +0000
+++ /tmp/cirrus-ci-build/build/testrun/btree_gist/regress/results/without_overlaps.out	2024-05-13 01:10:20.830764959 +00...
@@ -16,6 +16,8 @@
  valid_at | daterange |           | not null | 
 Indexes:
     "temporal_rng_pk" PRIMARY KEY (id, valid_at WITHOUT OVERLAPS)
+Check constraints:
+    "valid_at_not_empty" CHECK (NOT isempty(valid_at))
 
 SELECT pg_get_constraintdef(oid) FROM pg_constraint WHERE conname = 'temporal_rng_pk';
             pg_get_constraintdef             
@@ -60,6 +62,8 @@
  parent_id | integer   |           |          | 
 Indexes:
     "temporal_fk_rng2rng_pk" PRIMARY KEY (id, valid_at WITHOUT OVERLAPS)
+Check constraints:
+    "valid_at_not_empty" CHECK (NOT isempty(valid_at))
 Foreign-key constraints:
     "temporal_fk_rng2rng_fk" FOREIGN KEY (parent_id, PERIOD valid_at) REFERENCES temporal_rng(id, PERIOD valid_at)
...
%s Windows - Server 2019, VS 2019 - Meson & ninja
regress 
diff -w -U3 C:/cirrus/contrib/btree_gist/expected/without_overlaps.out C:/cirrus/build/testrun/btree_gist/regress/result...
--- C:/cirrus/contrib/btree_gist/expected/without_overlaps.out	2024-05-13 01:05:40.087528700 +0000
+++ C:/cirrus/build/testrun/btree_gist/regress/results/without_overlaps.out	2024-05-13 01:11:37.148898200 +0000
@@ -16,6 +16,8 @@
  valid_at | daterange |           | not null | 
 Indexes:
     "temporal_rng_pk" PRIMARY KEY (id, valid_at WITHOUT OVERLAPS)
+Check constraints:
+    "valid_at_not_empty" CHECK (NOT isempty(valid_at))
 
 SELECT pg_get_constraintdef(oid) FROM pg_constraint WHERE conname = 'temporal_rng_pk';
             pg_get_constraintdef             
@@ -60,6 +62,8 @@
  parent_id | integer   |           |          | 
 Indexes:
     "temporal_fk_rng2rng_pk" PRIMARY KEY (id, valid_at WITHOUT OVERLAPS)
+Check constraints:
+    "valid_at_not_empty" CHECK (NOT isempty(valid_at))
 Foreign-key constraints:
     "temporal_fk_rng2rng_fk" FOREIGN KEY (parent_id, PERIOD valid_at) REFERENCES temporal_rng(id, PERIOD valid_at)
...
%s macOS - Ventura - Meson
regress 
diff -U3 /Users/admin/pgsql/contrib/btree_gist/expected/without_overlaps.out /Users/admin/pgsql/build/testrun/btree_gist...
--- /Users/admin/pgsql/contrib/btree_gist/expected/without_overlaps.out	2024-05-13 01:04:43
+++ /Users/admin/pgsql/build/testrun/btree_gist/regress/results/without_overlaps.out	2024-05-13 01:07:57
@@ -16,6 +16,8 @@
  valid_at | daterange |           | not null | 
 Indexes:
     "temporal_rng_pk" PRIMARY KEY (id, valid_at WITHOUT OVERLAPS)
+Check constraints:
+    "valid_at_not_empty" CHECK (NOT isempty(valid_at))
 
 SELECT pg_get_constraintdef(oid) FROM pg_constraint WHERE conname = 'temporal_rng_pk';
             pg_get_constraintdef             
@@ -60,6 +62,8 @@
  parent_id | integer   |           |          | 
 Indexes:
     "temporal_fk_rng2rng_pk" PRIMARY KEY (id, valid_at WITHOUT OVERLAPS)
+Check constraints:
+    "valid_at_not_empty" CHECK (NOT isempty(valid_at))
 Foreign-key constraints:
     "temporal_fk_rng2rng_fk" FOREIGN KEY (parent_id, PERIOD valid_at) REFERENCES temporal_rng(id, PERIOD valid_at)
...