Re: undead index

Поиск
Список
Период
Сортировка
От Jens Wilke
Тема Re: undead index
Дата
Msg-id 201105061737.43264.jens.wilke@affinitas.de
обсуждение исходный текст
Ответ на Re: undead index  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: undead index
Список pgsql-general
On Friday 06 May 2011 17:18:29 Tom Lane wrote:

Hi Tom,

> Possibly if
> you showed us the actual (not obfuscated) table declaration, associated
> constraint declarations, and resulting index definition, things would be
> clearer.

Thanks Tom, yes, the index is named
Indexes:
    "concurrently" btree (ulq_guid)
In the 8.4 cluster and 9.0.4's pg_dumpall dumps it as

CREATE INDEX concurrently ON foo USING btree (ulq_guid);

That's it.
But shouldn't pg_upgrade be able to handle this?

Regards, Jens

В списке pgsql-general по дате отправления:

Предыдущее
От: Alan Hodgson
Дата:
Сообщение: Re: Locale and UTF8 for template1 in 8.4.4
Следующее
От: Tom Lane
Дата:
Сообщение: Re: undead index