Re: Reg. Postgres Unique contraint

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