Following in the style of this, I'm trying to create an exclusion constraint over an ENUM,
CREATE TYPE dow AS ENUM (
'Monday', 'Tuesday', 'Wednesday', 'Thursday',
'Friday', 'Saturday', 'Sunday'
);
CREATE TABLE available (
dow dow,
tsrange tsrange,
EXCLUDE USING gist (tsrange WITH =, dow WITH &&)
);
Returns
ERROR: data type dow has no default operator class for access method "gist"
HINT: You must specify an operator class for the index or define a default operator class for the data type.