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