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.burcinOn 27 Nov 2024, at 07:28, Sajjad Abid <abidsajjad@gmail.com> wrote: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 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
On 27 Nov 2024, at 07:28, Sajjad Abid <abidsajjad@gmail.com> wrote:
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 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
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
Which version of Postgres are you using?
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
pgsql-performance by date:
Соглашаюсь с условиями обработки персональных данных
