Re: duplicate key violates unique constraint pg_toast_635216540

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

On 10/16/06, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> "Paul Laughlin" <plaughlin@gmail.com> writes:
> > warehouse=# select count(distinct chunk_id) from
> > pg_toast.pg_toast_635216540;
> > count
> > -------
> > 74557
> > (1 row)
>
> > We're on version 8.0.7
>
> Well, 8.0 is definitely at risk for OID collisions in a toast table,
> but with so few entries I'd have thought the probability pretty low.
> How often do you see these errors?
>
>                         regards, tom lane
>

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

Предыдущее
От: David Fetter
Дата:
Сообщение: Re: BUG #2683: spi_exec_query in plperl returns column names which are not marked as UTF8
Следующее
От: Tom Lane
Дата:
Сообщение: Re: duplicate key violates unique constraint pg_toast_635216540