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 17:04:41
Message-ID: 22989.1161018281@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:
> 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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message stig erikson 2006-10-16 17:29:04 8.1.5 rpms for FC5
Previous Message Paul Laughlin 2006-10-16 17:01:30 Re: duplicate key violates unique constraint pg_toast_635216540