Thread: Reg. Postgres Unique contraint
A column is character varying(50), also on this column a unique constraint is defined, but I found some duplicate values in this column for some records
user_name character varying(50)
CONSTRAINT user_name_unq UNIQUE ( user_name )
Kindly help me to resolve this issue.
Thanks & Regards,
Sajjad Abid
Sajjad Abid
Which version of Postgres are you using?
El mié, 27 de nov de 2024, 00:14, Sajjad Abid <abidsajjad@gmail.com> escribió:
A column is character varying(50), also on this column a unique constraint is defined, but I found some duplicate values in this column for some recordsuser_name character varying(50)CONSTRAINT user_name_unq UNIQUE ( user_name )Kindly help me to resolve this issue.--Thanks & Regards,
Sajjad Abid
Version of Postgres is 12.9
On Wed, Nov 27, 2024 at 9:49 AM Diomedes Dominguez <diomedes.dominguez@gmail.com> wrote:
Which version of Postgres are you using?
El mié, 27 de nov de 2024, 00:14, Sajjad Abid <abidsajjad@gmail.com> escribió:A column is character varying(50), also on this column a unique constraint is defined, but I found some duplicate values in this column for some recordsuser_name character varying(50)CONSTRAINT user_name_unq UNIQUE ( user_name )Kindly help me to resolve this issue.--Thanks & Regards,
Sajjad Abid
Thanks & Regards,
Sajjad Abid
Sajjad Abid
We saw it when OS image changed resulting in collation library change, so index lookups started to fail and reindex was needed to fix it.
ср, 27 лист. 2024 р. о 16:23 Burcin Yazici <burcinyazici@gmail.com> пише:
hi,make sure that the values are really duplicated first..- check the collation of column.- check accent chars exist.- check lowercase, uppercase- check white space, tabs etc.Version of Postgres is 12.9On Wed, Nov 27, 2024 at 9:49 AM Diomedes Dominguez <diomedes.dominguez@gmail.com> wrote:Which version of Postgres are you using?
El mié, 27 de nov de 2024, 00:14, Sajjad Abid <abidsajjad@gmail.com> escribió:A column is character varying(50), also on this column a unique constraint is defined, but I found some duplicate values in this column for some recordsuser_name character varying(50)CONSTRAINT user_name_unq UNIQUE ( user_name )Kindly help me to resolve this issue.--Thanks & Regards,
Sajjad Abid--Thanks & Regards,
Sajjad Abid