Content-Type: multipart/alternative;
 boundary=Apple-Mail-FB03E3E0-7514-4BFB-8EEB-E24DCDF134FD
Content-Transfer-Encoding: 7bit
From: Burcin Yazici <burcinyazici@gmail.com>
Mime-Version: 1.0 (1.0)
Subject: Re: Reg. Postgres Unique contraint
Date: Wed, 27 Nov 2024 09:22:36 +0300
Message-Id: <F795AEE1-D253-432C-B4A0-A13C83A63E33@gmail.com>
References: 
 <CANjRhAHar1rAAHtAZj3jkvAJc_HL5973O=zpgRWhcMfxp+rXLA@mail.gmail.com>
Cc: Diomedes Dominguez <diomedes.dominguez@gmail.com>,
 pgsql-performance@lists.postgresql.org
In-Reply-To: 
 <CANjRhAHar1rAAHtAZj3jkvAJc_HL5973O=zpgRWhcMfxp+rXLA@mail.gmail.com>
To: Sajjad Abid <abidsajjad@gmail.com>
Archived-At: 
 <https://www.postgresql.org/message-id/F795AEE1-D253-432C-B4A0-A13C83A63E33%40gmail.com>
Precedence: bulk


--Apple-Mail-FB03E3E0-7514-4BFB-8EEB-E24DCDF134FD
Content-Type: text/html;
	charset=utf-8
Content-Transfer-Encoding: quoted-printable

<html><head><meta http-equiv=3D"content-type" content=3D"text/html; charset=3D=
utf-8"></head><body dir=3D"auto">hi,<div><br></div><div>make sure that the v=
alues are really duplicated first..</div><div><br></div><div>- check &nbsp;t=
he collation of column.&nbsp;</div><div>- check accent chars exist.</div><di=
v>- 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><bloc=
kquote type=3D"cite">On 27 Nov 2024, at 07:28, Sajjad Abid &lt;abidsajjad@gm=
ail.com&gt; wrote:<br><br></blockquote></div><blockquote type=3D"cite"><div d=
ir=3D"ltr">=EF=BB=BF<div dir=3D"ltr">Version of Postgres is 12.9</div><br><d=
iv class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Wed, Nov 2=
7, 2024 at 9:49=E2=80=AFAM Diomedes Dominguez &lt;<a href=3D"mailto:diomedes=
.dominguez@gmail.com">diomedes.dominguez@gmail.com</a>&gt; wrote:<br></div><=
blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-le=
ft: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:abidsajjad@=
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;bo=
rder-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr"><div=
>A column is character varying(50), also on this column a unique constraint&=
nbsp;is defined, but I found some duplicate values in this column for some r=
ecords</div><div>&nbsp; user_name character varying(50)&nbsp;<br></div><div>=
&nbsp; CONSTRAINT&nbsp;

user_name_unq&nbsp; &nbsp;UNIQUE (

user_name )<br></div><div><br></div><div>Kindly help me to resolve this issu=
e.</div><div><br></div><span class=3D"gmail_signature_prefix">-- </span><br>=
<div dir=3D"ltr" class=3D"gmail_signature"><font color=3D"#3366FF"><b>Thanks=
 &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_signa=
ture"><font color=3D"#3366FF"><b>Thanks &amp; Regards, <br><br>Sajjad Abid</=
b></font><br></div>
</div></blockquote></div></body></html>=

--Apple-Mail-FB03E3E0-7514-4BFB-8EEB-E24DCDF134FD--