Am 27.11.24 um 05:14 schrieb Sajjad Abid:
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 )
Most likely a locale
nce@lists.postgresql.org
Objet : Re: Reg. Postgres Unique contraint
Version of Postgres is 12.9
On Wed, Nov 27, 2024 at 9:49 AM Diomedes Dominguez
mailto:diomedes.doming...@gmail.com> > wrote:
Which version of Postgres are you using?
El mié, 27 de nov de 2024, 00:14, Sajjad Abid mailt
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 пише:
> hi,
>
> make sure that the values are really duplicated first..
>
> - check the collation of column.
> - c
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.burcinOn 27 Nov 2024, at 07:28, Sajjad Abid wrote:Version of Postgres is 12.9On Wed, Nov 27, 2024 at 9:49 AM Diomedes Do
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
> escribió:
>
>> A column is character varying(50), also on this column a unique
>> c
Which version of Postgres are you using?
El mié, 27 de nov de 2024, 00:14, Sajjad Abid
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)
>
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 & Regar
