Re: duplicate key violates unique constraint pg_toast_635216540

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

"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 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
Previous Message Paul Laughlin 2006-10-16 16:45:35 Re: duplicate key violates unique constraint pg_toast_635216540