Re: Error: duplicate key violates unique constraint - "pg_toast_3270368541_index - Mailing list pgsql-admin

From Tom Lane
Subject Re: Error: duplicate key violates unique constraint - "pg_toast_3270368541_index
Date
Msg-id 4149.1195145384@sss.pgh.pa.us
Whole thread Raw
In response to Re: Error: duplicate key violates unique constraint - "pg_toast_3270368541_index  ("Tomeh, Husam" <HTomeh@facorelogic.com>)
List pgsql-admin
"Tomeh, Husam" <HTomeh@facorelogic.com> writes:
> Thanks Tom. As a temporarily solution though, would reorging the table
> (pgdump,drop/truncate, reload) resolve the OID collision issue and buy
> us some time until we get the upgrade going?

Probably.  I wouldn't bother with pg_dump, just INSERT ... SELECT
the data into a new table and then rename that one into place.

            regards, tom lane

pgsql-admin by date:

Previous
From: "Chris Hoover"
Date:
Subject: Re: any way to make query use index?
Next
From: Tom Lane
Date:
Subject: Re: any way to make query use index?