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

From Paul Laughlin
Subject duplicate key violates unique constraint pg_toast_635216540
Date
Msg-id f41e66d10610160916m77430fdfmda08ff2b5d0df728@mail.gmail.com
Whole thread Raw
Responses Re: duplicate key violates unique constraint pg_toast_635216540
List 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

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] BUG #2683: spi_exec_query in plperl returns
Next
From: Tom Lane
Date:
Subject: Re: duplicate key violates unique constraint pg_toast_635216540