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