diff -w -U3 C:/cirrus/contrib/btree_gist/expected/without_overlaps.out C:/cirrus/build/testrun/btree_gist/regress/results/without_overlaps.out --- C:/cirrus/contrib/btree_gist/expected/without_overlaps.out 2024-05-04 13:19:11.948279300 +0000 +++ C:/cirrus/build/testrun/btree_gist/regress/results/without_overlaps.out 2024-05-04 13:24:54.012511700 +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)