I want to add an exclusion constraint to a table in pgmodeler.
Example table:
create table x (
lable varchar(2) not null,
timerange tstzrange not null,
primary key (lable, timerange))
);
And I want to add:
alter table x add constraint ex_x_overlap
exclude using gist(lable with =, timerange with &&);
What I tried in pgmodeler
- open table properties
- chose constraints
- add constraint
- choose a name
- chose type "EXCLUDE"
- add first exclude element, column "lable", but no operator available
My problem is that the operator field is mandatory, but not free text. I need to select an operator form one of the schemas. However "=" is not there (there are none in fact...).
I think I misunderstand something, any help appreciated!