Re: undead index

On Wednesday 04 May 2011 17:32:50 Tom Lane wrote:

> Hmm, is this an autogenerated index?

I don't think so.
And to confirm, that i really deleted the new cluster between the pg_upgrade
run and the dump|restore i did it again and was able to revive this index
again:

foo=# \d+ foo.bar_idx
      Index "foo.bar_idx"
  Column  |         Type          | Definition | Storage  | Description
----------+-----------------------+------------+----------+-------------
 ulq_guid | character varying(24) | ulq_guid   | extended |
btree, for table "foo.foo"

But it's again not in the pg_dumpall output, using the same binary like for
the dump|restore.

Regards, Jens