| From: | "Harpreet Dhaliwal" <harpreet(dot)dhaliwal01(at)gmail(dot)com> |
|---|---|
| To: | "Postgres General" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Duplicate Unique Key constraint error |
| Date: | 2007-07-10 05:14:08 |
| Message-ID: | d86a77ef0707092214j2f19d5c0yf1e1a0ea19c06122@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-odbc |
Hi,
I keep getting this duplicate unique key constraint error for my primary key
even
though I'm not inserting anything duplicate. It even inserts the records
properly
but my console throws this error that I'm sure of what it is all about.
Corruption of my Primary Key can be one of the possibilities but I'm really
not sure how
to get rid of this corruption and how to re-index the primary key.
Also, I was wondering what could be the cause of this PK corruption, if
possible and what does can this corruption lead to.
I mean what are its cons.
Thanks,
~Harpreet
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nikolay Samokhvalov | 2007-07-10 05:31:38 | Re: xpath_* namespace bug |
| Previous Message | alexander lunyov | 2007-07-10 04:40:24 | Re: russian case-insensitive regexp search not working |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ron St-Pierre | 2007-07-10 06:01:46 | Re: Duplicate Unique Key constraint error |
| Previous Message | Eric E | 2007-07-09 23:30:29 | Problem getting sequences under 8.02.03.00 driver |