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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-bugs by date

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