Postgres Pro
Downloads
Home   >   mailing lists

Thread: Reg. Postgres Unique contraint

Reg. Postgres Unique contraint

From
Sajjad Abid
Date:
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

Re: Reg. Postgres Unique contraint

From
Diomedes Dominguez
Date:

Which version of Postgres are you using?

El mié, 27 de nov de 2024, 00:14, Sajjad Abid <abidsajjad@gmail.com> 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

Re: Reg. Postgres Unique contraint

From
Sajjad Abid
Date:
Version of Postgres is 12.9

On Wed, Nov 27, 2024 at 9:49 AM Diomedes Dominguez <diomedes.dominguez@gmail.com> wrote:

Which version of Postgres are you using?

El mié, 27 de nov de 2024, 00:14, Sajjad Abid <abidsajjad@gmail.com> 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

Re: Reg. Postgres Unique contraint

From
Vitalii Tymchyshyn
Date:
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 <burcinyazici@gmail.com> пише:
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 <abidsajjad@gmail.com> wrote:


Version of Postgres is 12.9

On Wed, Nov 27, 2024 at 9:49 AM Diomedes Dominguez <diomedes.dominguez@gmail.com> wrote:

Which version of Postgres are you using?

El mié, 27 de nov de 2024, 00:14, Sajjad Abid <abidsajjad@gmail.com> 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

RE: Reg. Postgres Unique contraint

From
Date:

Hi,

 

Does the following query return something:

 

Select user_name, count(*) from your_table group by user_name having count(*) > 1

 

Best regards

 

Michel SALAIS

 

De : Sajjad Abid <abidsajjad@gmail.com>
Envoyé : mercredi 27 novembre 2024 05:28
À : Diomedes Dominguez <diomedes.dominguez@gmail.com>
Cc : pgsql-performance@lists.postgresql.org
Objet : Re: Reg. Postgres Unique contraint

 

Version of Postgres is 12.9

 

On Wed, Nov 27, 2024 at 9:49 AM Diomedes Dominguez <diomedes.dominguez@gmail.com> wrote:

Which version of Postgres are you using?

 

El mié, 27 de nov de 2024, 00:14, Sajjad Abid <abidsajjad@gmail.com> 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

Re: Reg. Postgres Unique contraint

From
shammat@gmx.net
Date:
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