Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group