public inbox for [email protected]
help / color / mirror / Atom feedFrom: Burcin Yazici <[email protected]>
To: Sajjad Abid <[email protected]>
Cc: Diomedes Dominguez <[email protected]>
Cc: [email protected]
Subject: Re: Reg. Postgres Unique contraint
Date: Wed, 27 Nov 2024 09:22:36 +0300
Message-ID: <[email protected]> (raw)
In-Reply-To: <CANjRhAHar1rAAHtAZj3jkvAJc_HL5973O=zpgRWhcMfxp+rXLA@mail.gmail.com>
References: <CANjRhAHar1rAAHtAZj3jkvAJc_HL5973O=zpgRWhcMfxp+rXLA@mail.gmail.com>
--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 t=
he collation of column. </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 <abidsajjad@gm=
ail.com> 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 <<a href=3D"mailto:diomedes=
[email protected]">[email protected]</a>> 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 <<a href=3D"mailto:abidsajjad@=
gmail.com" target=3D"_blank">[email protected]</a>> 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> user_name character varying(50) <br></div><div>=
CONSTRAINT
user_name_unq 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=
& 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 & Regards, <br><br>Sajjad Abid</=
b></font><br></div>
</div></blockquote></div></body></html>=
--Apple-Mail-FB03E3E0-7514-4BFB-8EEB-E24DCDF134FD--
view thread (7+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected]
Subject: Re: Reg. Postgres Unique contraint
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox