This works:

ALTER TABLE segment ADD CONSTRAINT name unique(textfield, reseller);

This doesn't:
ALTER TABLE segment ADD CONSTRAINT name unique(lower(textfield), reseller);



I had to create a unique index.


---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Reply via email to