MIME-Version: 1.0
References: 
 <CANjRhAHar1rAAHtAZj3jkvAJc_HL5973O=zpgRWhcMfxp+rXLA@mail.gmail.com>
 <F795AEE1-D253-432C-B4A0-A13C83A63E33@gmail.com>
In-Reply-To: <F795AEE1-D253-432C-B4A0-A13C83A63E33@gmail.com>
From: Vitalii Tymchyshyn <vit@tym.im>
Date: Wed, 27 Nov 2024 17:13:03 +1000
Message-ID: 
 <CABWW-d2bpmz3o8y_bq+z0BeaU8Uu4XUY0BKXS94BgF=aP7yiWw@mail.gmail.com>
Subject: Re: Reg. Postgres Unique contraint
To: Burcin Yazici <burcinyazici@gmail.com>
Cc: Sajjad Abid <abidsajjad@gmail.com>,
 Diomedes Dominguez <diomedes.dominguez@gmail.com>,
	pgsql-performance@lists.postgresql.org
Content-Type: multipart/alternative; boundary="00000000000004e7c90627dfb319"
Archived-At: 
 <https://www.postgresql.org/message-id/CABWW-d2bpmz3o8y_bq%2Bz0BeaU8Uu4XUY0BKXS94BgF%3DaP7yiWw%40mail.gmail.com>
Precedence: bulk

--00000000000004e7c90627dfb319
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

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.

=D1=81=D1=80, 27 =D0=BB=D0=B8=D1=81=D1=82. 2024=E2=80=AF=D1=80. =D0=BE 16:2=
3 Burcin Yazici <burcinyazici@gmail.com> =D0=BF=D0=B8=D1=88=D0=B5:

> 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@gmail.com> wrote:
>
> =EF=BB=BF
>
> Version of Postgres is 12.9
>
> On Wed, Nov 27, 2024 at 9:49=E2=80=AFAM Diomedes Dominguez <
> diomedes.dominguez@gmail.com> wrote:
>
>> Which version of Postgres are you using?
>>
>> El mi=C3=A9, 27 de nov de 2024, 00:14, Sajjad Abid <abidsajjad@gmail.com=
>
>> escribi=C3=B3:
>>
>>> 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*
>
>

--00000000000004e7c90627dfb319
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"auto">We saw it when OS image changed resulting in collation li=
brary change, so index lookups started to fail and reindex was needed to fi=
x it.</div><div><br><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gm=
ail_attr">=D1=81=D1=80, 27 =D0=BB=D0=B8=D1=81=D1=82. 2024=E2=80=AF=D1=80. =
=D0=BE 16:23 Burcin Yazici &lt;<a href=3D"mailto:burcinyazici@gmail.com">bu=
rcinyazici@gmail.com</a>&gt; =D0=BF=D0=B8=D1=88=D0=B5:<br></div><blockquote=
 class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc soli=
d;padding-left:1ex"><div dir=3D"auto">hi,<div><br></div><div>make sure that=
 the values are really duplicated first..</div><div><br></div><div>- check =
=C2=A0the collation of column.=C2=A0</div><div>- check accent chars exist.<=
/div><div>- check lowercase, uppercase</div><div>- check white space, tabs =
etc.</div><div><br></div><div><div dir=3D"ltr">burcin</div><div dir=3D"ltr"=
><br><blockquote type=3D"cite">On 27 Nov 2024, at 07:28, Sajjad Abid &lt;<a=
 href=3D"mailto:abidsajjad@gmail.com" target=3D"_blank">abidsajjad@gmail.co=
m</a>&gt; wrote:<br><br></blockquote></div><blockquote type=3D"cite"><div d=
ir=3D"ltr">=EF=BB=BF</div></blockquote></div></div><div dir=3D"auto"><div><=
blockquote type=3D"cite"><div dir=3D"ltr"><div dir=3D"ltr">Version of Postg=
res is 12.9</div><br><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"g=
mail_attr">On Wed, Nov 27, 2024 at 9:49=E2=80=AFAM Diomedes Dominguez &lt;<=
a href=3D"mailto:diomedes.dominguez@gmail.com" target=3D"_blank">diomedes.d=
ominguez@gmail.com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote=
" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);=
padding-left:1ex"><p dir=3D"ltr">Which version of Postgres are you using? <=
/p>
<br><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">El mi=
=C3=A9, 27 de nov de 2024, 00:14, Sajjad Abid &lt;<a href=3D"mailto:abidsaj=
jad@gmail.com" target=3D"_blank">abidsajjad@gmail.com</a>&gt; escribi=C3=B3=
:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.=
8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"lt=
r"><div>A column is character varying(50), also on this column a unique con=
straint=C2=A0is defined, but I found some duplicate values in this column f=
or some records</div><div>=C2=A0 user_name character varying(50)=C2=A0<br><=
/div><div>=C2=A0 CONSTRAINT=C2=A0

user_name_unq=C2=A0 =C2=A0UNIQUE (

user_name )<br></div><div><br></div><div>Kindly help me to resolve this iss=
ue.</div><div><br></div><span class=3D"gmail_signature_prefix">-- </span><b=
r><div dir=3D"ltr" class=3D"gmail_signature"><font color=3D"#3366FF"><b>Tha=
nks &amp; Regards, <br><br>Sajjad Abid</b></font><br></div></div>
</blockquote></div>
</blockquote></div><div><br clear=3D"all"></div><div><br></div><span class=
=3D"gmail_signature_prefix">-- </span><br><div dir=3D"ltr" class=3D"gmail_s=
ignature"><font color=3D"#3366FF"><b>Thanks &amp; Regards, <br><br>Sajjad A=
bid</b></font><br></div>
</div></blockquote></div></div></blockquote></div></div>

--00000000000004e7c90627dfb319--