Postgres Pro
Downloads
Home   >   mailing lists

Re: Reg. Postgres Unique contraint - Mailing list pgsql-performance

From shammat@gmx.net
Subject Re: Reg. Postgres Unique contraint
Date
Msg-id f289bb30-f163-41b2-a76e-b364ef9fdc5a@gmx.net
Whole thread Raw
In response to Reg. Postgres Unique contraint  (Sajjad Abid <abidsajjad@gmail.com>)
List pgsql-performance
Tree view 
Am 27.11.24 um 05:14 schrieb Sajjad Abid:
> 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 )

Most likely a locale/encoding problem.

See: https://wiki.postgresql.org/wiki/Locale_data_changes

pgsql-performance by date:

Previous
From:
Date:
Subject: RE: Reg. Postgres Unique contraint
Next
From: Tom Lane
Date:
Subject: Re: Question: consolidating strpos searches?