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
On Wed, 20 Nov 2024, 22:26 Tom Lane, wrote:
> [ please don't top-quote, it makes the conversation hard to follow ]
>
> David Mullineux writes:
> > On Wed, 20 Nov 2024, 15:46 Tom Lane, wrote:
> >> Yeah. Also, are you building with openssl, or not?
>
> > No, not at all!
>
> If you're not using o
