| From: | Burcin Yazici <burcinyazici(at)gmail(dot)com> |
|---|---|
| To: | Sajjad Abid <abidsajjad(at)gmail(dot)com> |
| Cc: | Diomedes Dominguez <diomedes(dot)dominguez(at)gmail(dot)com>, pgsql-performance(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Reg. Postgres Unique contraint |
| Date: | 2024-11-27 06:22:36 |
| Message-ID: | F795AEE1-D253-432C-B4A0-A13C83A63E33@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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 <abidsajjad(at)gmail(dot)com> wrote:
Version of Postgres is 12.9
On Wed, Nov 27, 2024 at 9:49 AM Diomedes Dominguez <diomedes(dot)dominguez(at)gmail(dot)com> wrote:
Which version of Postgres are you using?
El mié, 27 de nov de 2024, 00:14, Sajjad Abid <abidsajjad(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vitalii Tymchyshyn | 2024-11-27 07:13:03 | Re: Reg. Postgres Unique contraint |
| Previous Message | Sajjad Abid | 2024-11-27 04:27:48 | Re: Reg. Postgres Unique contraint |