Re: pg_upgrade problem with invalid indexes

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pg_upgrade problem with invalid indexes
Дата
Msg-id 2351.1354841637@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: pg_upgrade problem with invalid indexes  (Bruce Momjian <bruce@momjian.us>)
Ответы Re: pg_upgrade problem with invalid indexes
Список pgsql-hackers
Bruce Momjian <bruce@momjian.us> writes:
> Yes, I thought of not dumping it.  The problem is that we don't delete
> the index when it fails, so I assumed we didn't want to lose the index
> creation information.  I need to understand why we did that.

Because CREATE INDEX CONCURRENTLY can't drop the index if it's already
failed.  It's not because we want to do that, it's an implementation
restriction of the horrid kluge that is CREATE/DROP INDEX CONCURRENTLY.
        regards, tom lane



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

Предыдущее
От: Jeff Davis
Дата:
Сообщение: Re: Commits 8de72b and 5457a1 (COPY FREEZE)
Следующее
От: Jeff Davis
Дата:
Сообщение: Re: pg_upgrade problem with invalid indexes