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 2351.1354841637@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
List 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 by date:

Previous
From: Jeff Davis
Date:
Subject: Re: Commits 8de72b and 5457a1 (COPY FREEZE)
Next
From: Jeff Davis
Date:
Subject: Re: pg_upgrade problem with invalid indexes