Search Postgresql Archives

Re: undead index

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread 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

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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux