pgsql: Add temporal PRIMARY KEY and UNIQUE constraints

2024-09-17 Thread Peter Eisentraut
Add temporal PRIMARY KEY and UNIQUE constraints Add WITHOUT OVERLAPS clause to PRIMARY KEY and UNIQUE constraints. These are backed by GiST indexes instead of B-tree indexes, since they are essentially exclusion constraints with = for the scalar parts of the key and && for the temporal part. (pre

pgsql: Add temporal PRIMARY KEY and UNIQUE constraints

2024-01-24 Thread Peter Eisentraut
Add temporal PRIMARY KEY and UNIQUE constraints Add WITHOUT OVERLAPS clause to PRIMARY KEY and UNIQUE constraints. These are backed by GiST indexes instead of B-tree indexes, since they are essentially exclusion constraints with = for the scalar parts of the key and && for the temporal part. Auth