All Questions
Tagged with citext case-sensitive
1 question
1
vote
0
answers
586
views
Postgresql citext datatype unique constraint fail
I need to create a unique constraint on citext column, but it fails.
Here is the example:
create table test (name citext);
ALTER TABLE ONLY test
ADD CONSTRAINT test_name_uq UNIQUE (name);
...