Re: BUG #2794: corrupted table pk index - Mailing list pgsql-bugs

From Heikki Linnakangas
Subject Re: BUG #2794: corrupted table pk index
Date
Msg-id 456FFB1E.1010607@enterprisedb.com
Whole thread Raw
In response to BUG #2794: corrupted table pk index  ("" <andres.ortega@farmacity.com.co>)
List pgsql-bugs
andres.ortega@farmacity.com.co wrote:
> this is a global database problem and pg_dump does not help
> how can i fix the database

I don't know how your table got into that state, but since there's only
17 duplicate rows, you could pg_dump, remove the duplicate rows by hand
from the dump-file, and restore.

--
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com

pgsql-bugs by date:

Previous
From: "Jeremy Haile"
Date:
Subject: Re: fsync and semctl errors with 8.1.5/win32
Next
From: "yyang"
Date:
Subject: BUG #2796: Command: Listen and Notify