Re: pg_upgrade problem with invalid indexes

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pg_upgrade problem with invalid indexes
Дата
Msg-id 25107.1354898811@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:
> On Fri, Dec  7, 2012 at 10:29:22AM -0500, Tom Lane wrote:
>> On balance I am coming around to support the "just throw an error if
>> there are any invalid indexes" position.  Adding extra complication in
>> pg_dump and pg_upgrade to handle ignoring them doesn't seem like a good
>> idea --- for one thing, it will evidently weaken the strength of the
>> same-number-of-relations cross-check.

> The check would remain the same --- the change would be to prevent
> invalid indexes from being considered on both the old and new servers.

But that weakens the check.  For instance, if you had seven invalid
indexes in one cluster and eight in the other, you wouldn't notice.
        regards, tom lane



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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: ALTER TABLE ... NOREWRITE option
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: pg_upgrade problem with invalid indexes