Re: duplicate key violates unique constraint. (repost)

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: duplicate key violates unique constraint. (repost)
Дата
Msg-id 24214.1121882889@sss.pgh.pa.us
обсуждение исходный текст
Ответ на duplicate key violates unique constraint. (repost)  (Michael Guerin <guerin@rentec.com>)
Ответы Re: duplicate key violates unique constraint. (repost)  (Michael Guerin <guerin@rentec.com>)
Multiple Inserts  (<operationsengineer1@yahoo.com>)
Список pgsql-novice
Michael Guerin <guerin@rentec.com> writes:
> We're starting to get a number of complaints about "duplicate key
> violations" on a index for one of the toast tables.  It started
> happening after our server was brought down over the weekend, so I
> suspect postgresql wasn't shutdown properly.  Below is the description
> of the index.

> I'm doing a re-index on the user table that is associated with the toast
> table, is this the right thing to do?  Is there something else I should do?

I don't think that will touch the toast table --- you should reindex the
toast table or index explicitly.

            regards, tom lane

В списке pgsql-novice по дате отправления:

Предыдущее
От: Michael Guerin
Дата:
Сообщение: duplicate key violates unique constraint. (repost)
Следующее
От: Shawn Garbett
Дата:
Сообщение: Extending SQL with C, shared library problem