diff -U3 /tmp/cirrus-ci-build/contrib/btree_gist/expected/without_overlaps.out /tmp/cirrus-ci-build/contrib/btree_gist/results/without_overlaps.out --- /tmp/cirrus-ci-build/contrib/btree_gist/expected/without_overlaps.out 2024-05-02 14:50:47.072341588 +0000 +++ /tmp/cirrus-ci-build/contrib/btree_gist/results/without_overlaps.out 2024-05-02 14:54:15.696169329 +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)