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

duplicate key violates unique constraint pg_toast_635216540

From: "Paul Laughlin" <plaughlin(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: duplicate key violates unique constraint pg_toast_635216540
Date: 2006-10-16 16:16:46
Message-ID: f41e66d10610160916m77430fdfmda08ff2b5d0df728@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-bugs
Hi,

For the last 6 months or so we've had an intermittent issue while doing a
data import with a simple update statement.  The fix that we've found for
this issue is to REINDEX TABLE <tablename>;


Has anyone seen this error before?

Again, the error is: duplicate key violates unique constraint pg_toast_<>

Thanks,

Paul

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2006-10-16 16:25:12
Subject: Re: duplicate key violates unique constraint pg_toast_635216540
Previous:From: Ergin OzekesDate: 2006-10-16 14:52:08
Subject: BUG #2696: odbc driver cannot connect

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