Horton
Menu

Re: Reg. Postgres Unique contraint

shammat@gmx.net

View thread
From: shammat@gmx.net
To: pgsql-performance@lists.postgresql.org
Date: 2024-12-27T12:57:59Z
Lists: pgsql-performance 
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