Re: undead index - Mailing list pgsql-general

From Jens Wilke
Subject Re: undead index
Date
Msg-id 201105060949.47051.jens.wilke@affinitas.de
Whole thread Raw
In response to Re: undead index  (Cédric Villemain <cedric.villemain.debian@gmail.com>)
Responses Re: undead index  (Cédric Villemain <cedric.villemain.debian@gmail.com>)
List pgsql-general
On Thursday 05 May 2011 16:46:05 Cédric Villemain wrote:

> I understood that you droped an index and when you dump/restore you
> get your index again.

Yes, that's it, after the pg_upgrade error, i removed the target data
directory, and initialzed a new target DB.
After pg_dumpall|pg_dump i got an index that is not visible in the source DB.
It had either been deleted weeks ago or disappeared from the system catalog
for any other reason.
I can't find this index in a new pg_dumpall output from the source DB.

Regards, Jens

pgsql-general by date:

Previous
From: Nick Raj
Date:
Subject: Debug Contrib/cube code
Next
From: Cédric Villemain
Date:
Subject: Re: undead index