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

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to