Re: duplicate key violates unique constraint pg_toast_635216540

From: "Paul Laughlin" <plaughlin(at)gmail(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: duplicate key violates unique constraint pg_toast_635216540
Date: 2006-10-16 17:01:30
Message-ID: f41e66d10610161001k495c7b1brd2d1eb594b705b2a@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
> "Paul Laughlin" <plaughlin(at)gmail(dot)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
>

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2006-10-16 17:04:41 Re: duplicate key violates unique constraint pg_toast_635216540
Previous Message David Fetter 2006-10-16 16:54:24 Re: BUG #2683: spi_exec_query in plperl returns column names which are not marked as UTF8