public inbox for [email protected]
help / color / mirror / Atom feedFrom: Vitalii Tymchyshyn <[email protected]>
To: Burcin Yazici <[email protected]>
Cc: Sajjad Abid <[email protected]>
Cc: Diomedes Dominguez <[email protected]>
Cc: [email protected]
Subject: Re: Reg. Postgres Unique contraint
Date: Wed, 27 Nov 2024 17:13:03 +1000
Message-ID: <CABWW-d2bpmz3o8y_bq+z0BeaU8Uu4XUY0BKXS94BgF=aP7yiWw@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <CANjRhAHar1rAAHtAZj3jkvAJc_HL5973O=zpgRWhcMfxp+rXLA@mail.gmail.com>
<[email protected]>
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 <[email protected]> пише:
> 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 <[email protected]> wrote:
>
>
>
> Version of Postgres is 12.9
>
> On Wed, Nov 27, 2024 at 9:49 AM Diomedes Dominguez <
> [email protected]> wrote:
>
>> Which version of Postgres are you using?
>>
>> El mié, 27 de nov de 2024, 00:14, Sajjad Abid <[email protected]>
>> 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*
>
>
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], [email protected]
Subject: Re: Reg. Postgres Unique contraint
In-Reply-To: <CABWW-d2bpmz3o8y_bq+z0BeaU8Uu4XUY0BKXS94BgF=aP7yiWw@mail.gmail.com>
* 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