blob: d8a0bfdd686e5b6f07fb39a3bb25ddefbd907ade [file] [log] [blame]
-- Given a create table specifying a constraint
create table exclusion_constraints_t1(a int, b int, EXCLUDE (a WITH =));
-- Then we errored out
-- Given a create partition table table specifying a constraint
create table exclusion_constraints_pt1(a int, b int, EXCLUDE (b WITH =)) partition by range(a) (start(1) end(4) every(1));
-- Then we errored out
-- Given a table without constraints
create table exclusion_constraints_t2(a int, b int);
-- And we alter table to add constraints
ALTER TABLE exclusion_constraints_t2 ADD CONSTRAINT constraint_on_t2 EXCLUDE USING btree (b WITH =);
-- Then we errored out