Re: Ignore invalid indexes in pg_dump.

Поиск
Список
Период
Сортировка
От anarazel@anarazel.de
Тема Re: Ignore invalid indexes in pg_dump.
Дата
Msg-id cbaae57b-116e-49eb-aabc-ea4a2d200cff@email.android.com
обсуждение исходный текст
Ответ на Re: Ignore invalid indexes in pg_dump.  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Ignore invalid indexes in pg_dump.  (Bruce Momjian <bruce@momjian.us>)
Re: Ignore invalid indexes in pg_dump.  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers

Tom Lane <tgl@sss.pgh.pa.us> schrieb:

>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.

You need to look at inisready in 9.2 since thats used for about to be dropped indexes. No?

Andres

---
Please excuse brevity and formatting - I am writing this on my mobile phone.



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Ignore invalid indexes in pg_dump.
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Ignore invalid indexes in pg_dump.