Re: Reg. Postgres Unique contraint
| От | Vitalii Tymchyshyn |
|---|---|
| Тема | Re: Reg. Postgres Unique contraint |
| Дата | |
| Msg-id | CABWW-d2bpmz3o8y_bq+z0BeaU8Uu4XUY0BKXS94BgF=aP7yiWw@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Reg. Postgres Unique contraint (Sajjad Abid <abidsajjad@gmail.com>) |
| Список | pgsql-performance |
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.Version of Postgres is 12.9On 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 recordsuser_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
В списке pgsql-performance по дате отправления: