Re: Reg. Postgres Unique contraint

[Burcin Yazici]

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. burcin On 27 Nov 2024, at 07:28, Sajjad Abid <abidsaj...@gmail.com> wrote:  Version of Postgres is 12.9 On Wed, Nov 27, 2024 at 9:49 AM Diomedes Dominguez <diomedes.doming...@gmail.com> wrote: Which version of Postgres are you using? El mié, 27 de nov de 2024, 00:14, Sajjad Abid <abidsaj...@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 records   user_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