Re: BUG #2794: corrupted table pk index

From: "Heikki Linnakangas" <heikki(at)enterprisedb(dot)com>
To: <andres(dot)ortega(at)farmacity(dot)com(dot)co>
Cc: <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #2794: corrupted table pk index
Date: 2006-12-01 09:51:26
Message-ID: 456FFB1E.1010607@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

andres(dot)ortega(at)farmacity(dot)com(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Daniel Baldoni 2006-12-01 11:09:40 BUG #2798: Obsolete tiemzone data included
Previous Message yyang 2006-12-01 09:01:15 BUG #2797: Command: Listen and Notify