Re: pg_upgrade problem with invalid indexes - Mailing list pgsql-hackers

From Tom Lane
Subject Re: pg_upgrade problem with invalid indexes
Date
Msg-id 25107.1354898811@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_upgrade problem with invalid indexes  (Bruce Momjian <bruce@momjian.us>)
Responses Re: pg_upgrade problem with invalid indexes  (Bruce Momjian <bruce@momjian.us>)
List 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 by date:

Previous
From: Robert Haas
Date:
Subject: Re: ALTER TABLE ... NOREWRITE option
Next
From: Bruce Momjian
Date:
Subject: Re: pg_upgrade problem with invalid indexes