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

From Tom Lane
Subject Re: duplicate key violates unique constraint pg_toast_635216540
Date
Msg-id 22989.1161018281@sss.pgh.pa.us
Whole thread Raw
In response to Re: duplicate key violates unique constraint pg_toast_635216540  ("Paul Laughlin" <plaughlin@gmail.com>)
List pgsql-bugs
"Paul Laughlin" <plaughlin@gmail.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

pgsql-bugs by date:

Previous
From: "Paul Laughlin"
Date:
Subject: Re: duplicate key violates unique constraint pg_toast_635216540
Next
From:
Date:
Subject: 8.2beta1 (w32): server process crash (tsvector)