|
|
|
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
[Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Programming PHP] [Kernel Newbies] [PHP Classes] [Find Someone Nice] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]
![]() |
![]() |