Re: duplicate key violates unique constraint pg_toast_635216540 - Mailing list pgsql-bugs

From Paul Laughlin
Subject Re: duplicate key violates unique constraint pg_toast_635216540
Date
Msg-id f41e66d10610161001k495c7b1brd2d1eb594b705b2a@mail.gmail.com
Whole thread Raw
In response to Re: duplicate key violates unique constraint pg_toast_635216540  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: duplicate key violates unique constraint pg_toast_635216540  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: David Fetter
Date:
Subject: Re: BUG #2683: spi_exec_query in plperl returns column names which are not marked as UTF8
Next
From: Tom Lane
Date:
Subject: Re: duplicate key violates unique constraint pg_toast_635216540