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 <burcinyaz...@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 <abidsaj...@gmail.com> wrote: > > > > Version of Postgres is 12.9 > > On Wed, Nov 27, 2024 at 9:49 AM Diomedes Dominguez < > diomedes.doming...@gmail.com> wrote: > >> Which version of Postgres are you using? >> >> El mié, 27 de nov de 2024, 00:14, Sajjad Abid <abidsaj...@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* > >
