Re: pg_upgrade problem with invalid indexes

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: pg_upgrade problem with invalid indexes
Дата
Msg-id 20121207184914.GF8476@awork2.anarazel.de
обсуждение исходный текст
Ответ на Re: pg_upgrade problem with invalid indexes  (Josh Berkus <josh@agliodbs.com>)
Ответы Re: pg_upgrade problem with invalid indexes
Re: pg_upgrade problem with invalid indexes
Список pgsql-hackers
On 2012-12-07 10:44:53 -0800, Josh Berkus wrote:
>
> > I wonder though if we shouldn't ignore !indislive indexes in pg_dump
> > (and the respective bw-compat hack).

Obviously I wanted to ask whether we *should* ignore them in the future.

> Quite likely we shouldn't.  However, that is why it wasn't considered a
> problem.

!indislive indexes are created during DROP INDEX CONCURRENTLY. Thats a
different case than CREATE INDEX CONCURRENTLY. Accessing their
definition is actually problematic because i can vanish while youre
examing it which could cause errors both in the backend and in pg_dump.

Greetings,

Andres Freund

--Andres Freund                       http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training &
Services



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

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: pg_upgrade problem with invalid indexes
Следующее
От: Tom Lane
Дата:
Сообщение: Re: pg_upgrade problem with invalid indexes