PostgreSQL: implementing using EXCLUDE on a GiST index for composite types
I'm working with a peculiar scenario while trying to create a GiST index with an `EXCLUDE` constraint on a table with composite types in PostgreSQL 13. I need to ensure that there are no overlapping periods for events, but I keep running into syntax errors. Here’s the SQL I’ve been working with: ```sql CREATE TABLE events ( id SERIAL PRIMARY KEY, event_name VARCHAR(100), period TSRANGE ); CREATE EXTENSION btree_gist; CREATE INDEX events_excl_index ON events USING GIST (period) EXCLUDE USING GIST (period WITH &&); ``` The behavior I receive is: ``` behavior: operator does not exist: tsrange && tsrange ``` I tried switching to a `btree` index with the `EXCLUDE` constraint, but it seems like it only works with specific data types. I also validated that the `btree_gist` extension is installed. When I check the operator classes for the types involved, I see that `tsrange` does support the `&&` operator in other contexts. What am I doing wrong here? How can I correctly implement the `EXCLUDE` constraint with a GiST index on a `tsrange` column to prevent overlapping periods? Any insights or workarounds would be greatly appreciated!