Skip site navigation (1) Skip section navigation (2)

Re: Ignore invalid indexes in pg_dump.

From: "anarazel(at)anarazel(dot)de" <andres(at)anarazel(dot)de>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>,Bruce Momjian <bruce(at)momjian(dot)us>
Cc: PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org>
Subject: Re: Ignore invalid indexes in pg_dump.
Date: 2013-03-28 21:31:51
Message-ID: cbaae57b-116e-49eb-aabc-ea4a2d200cff@email.android.com (view raw or flat)
Thread:
Lists: pgsql-committerspgsql-hackers

Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> schrieb:

>Bruce Momjian <bruce(at)momjian(dot)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.


In response to

Responses

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2013-03-28 21:35:08
Subject: Re: Ignore invalid indexes in pg_dump.
Previous:From: Tom LaneDate: 2013-03-28 21:27:28
Subject: Re: Ignore invalid indexes in pg_dump.

pgsql-committers by date

Next:From: Bruce MomjianDate: 2013-03-28 21:35:08
Subject: Re: Ignore invalid indexes in pg_dump.
Previous:From: Tom LaneDate: 2013-03-28 21:27:28
Subject: Re: Ignore invalid indexes in pg_dump.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group