Re: duplicate key violates unique constraint pg_toast_635216540

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: duplicate key violates unique constraint pg_toast_635216540
Дата
Msg-id 22989.1161018281@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: duplicate key violates unique constraint pg_toast_635216540  ("Paul Laughlin" <plaughlin@gmail.com>)
Список pgsql-bugs
"Paul Laughlin" <plaughlin@gmail.com> writes:
> We got it early last week and again this morning.  Before these two it was
> about six months ago.

A certain amount of clustering could be expected, if a lot of the
entries were made at the time of initial table load --- they'd have
nearby OIDs.  You can either ignore it (I doubt you need REINDEX, just
retry the update) or else update to PG 8.1 ...

            regards, tom lane

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

Предыдущее
От: "Paul Laughlin"
Дата:
Сообщение: Re: duplicate key violates unique constraint pg_toast_635216540
Следующее
От:
Дата:
Сообщение: 8.2beta1 (w32): server process crash (tsvector)