2011/5/6 Jens Wilke <jens.wilke@xxxxxxxxxxxx>: > 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general