2011/5/6 Jens Wilke <jens.wilke@affinitas.de>:
> 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.
Okay! (I didn't understood correctly), please check the question from Tom.
--
Cédric Villemain 2ndQuadrant
http://2ndQuadrant.fr/ PostgreSQL : Expertise, Formation et Support