Duplicate Unique Key constraint error

Поиск
Список
Период
Сортировка
От Harpreet Dhaliwal
Тема Duplicate Unique Key constraint error
Дата
Msg-id d86a77ef0707092214j2f19d5c0yf1e1a0ea19c06122@mail.gmail.com
обсуждение исходный текст
Ответы Re: Duplicate Unique Key constraint error  (Ron St-Pierre <ron.pgsql@shaw.ca>)
Список 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 по дате отправления:

Предыдущее
От: alexander lunyov
Дата:
Сообщение: Re: russian case-insensitive regexp search not working
Следующее
От: "Postgres User"
Дата:
Сообщение: How to join materalized view to child tables