Re: undead index

From: Jens Wilke <jens(dot)wilke(at)affinitas(dot)de>
To: Cédric Villemain <cedric(dot)villemain(dot)debian(at)gmail(dot)com>
Cc: "pgsql-general" <pgsql-general(at)postgresql(dot)org>
Subject: Re: undead index
Date: 2011-05-06 07:49:46
Message-ID: 201105060949.47051.jens.wilke@affinitas.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Cédric Villemain 2011-05-06 09:12:52 Re: undead index
Previous Message Nick Raj 2011-05-06 05:13:23 Debug Contrib/cube code