Re: Ignore invalid indexes in pg_dump.

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Ignore invalid indexes in pg_dump.
Дата
Msg-id 24486.1364506048@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Ignore invalid indexes in pg_dump.  (Bruce Momjian <bruce@momjian.us>)
Ответы Re: Ignore invalid indexes in pg_dump.  ("anarazel@anarazel.de" <andres@anarazel.de>)
Fix for pg_upgrade and invalid indexes  (Bruce Momjian <bruce@momjian.us>)
Список pgsql-hackers
Bruce Momjian <bruce@momjian.us> writes:
> Should I just patch pg_upgrade to remove the "indisvalid", skip
> "indisvalid" indexes, and backpatch it?  Users should be using the
> version of pg_upgrade to match new pg_dump.  Is there any case where
> they don't match?  Do I still need to check for "indisready"?

Yeah, if you can just ignore !indisvalid indexes that should work fine.
I see no need to look at indisready if you're doing that.
        regards, tom lane



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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: pg_upgrade segfaults when given an invalid PGSERVICE value
Следующее
От: "anarazel@anarazel.de"
Дата:
Сообщение: Re: Ignore invalid indexes in pg_dump.