Re: Reg. Postgres Unique contraint

From: shammat(at)gmx(dot)net
To: pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re: Reg. Postgres Unique contraint
Date: 2024-12-27 12:57:59
Message-ID: f289bb30-f163-41b2-a76e-b364ef9fdc5a@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message jian he 2024-12-27 15:19:29 Re: Re: proposal: schema variables
Previous Message msalais 2024-12-27 11:54:52 RE: Reg. Postgres Unique contraint