Duplicate Unique Key constraint error - Mailing list pgsql-general

From Harpreet Dhaliwal
Subject Duplicate Unique Key constraint error
Date
Msg-id d86a77ef0707092214j2f19d5c0yf1e1a0ea19c06122@mail.gmail.com
Whole thread Raw
Responses Re: Duplicate Unique Key constraint error
List pgsql-general
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

pgsql-general by date:

Previous
From: alexander lunyov
Date:
Subject: Re: russian case-insensitive regexp search not working
Next
From: "Postgres User"
Date:
Subject: How to join materalized view to child tables