Re: Reg. Postgres Unique contraint

[Vitalii Tymchyshyn <vit@xxxxxx>]

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@xxxxxxxxx> пише:

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@xxxxxxxxx> wrote:



Version of Postgres is 12.9

On Wed, Nov 27, 2024 at 9:49 AM Diomedes Dominguez <diomedes.dominguez@xxxxxxxxx> wrote:

Which version of Postgres are you using?

El mié, 27 de nov de 2024, 00:14, Sajjad Abid <abidsajjad@xxxxxxxxx> 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