Re: Ignore invalid indexes in pg_dump.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "anarazel(at)anarazel(dot)de" <andres(at)anarazel(dot)de>
Cc: Bruce Momjian <bruce(at)momjian(dot)us>, PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org>
Subject: Re: Ignore invalid indexes in pg_dump.
Date: 2013-03-28 21:38:05
Message-ID: 24824.1364506685@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers pgsql-hackers

"anarazel(at)anarazel(dot)de" <andres(at)anarazel(dot)de> writes:
> Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> schrieb:
>> 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?

No, he doesn't need to look at indisready/indislive; if either of those
flags are off then indisvalid should certainly be off too. (If it
isn't, queries against the table are already in trouble.)

regards, tom lane

In response to

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message anarazel@anarazel.de 2013-03-28 21:47:55 Re: Ignore invalid indexes in pg_dump.
Previous Message Bruce Momjian 2013-03-28 21:35:08 Re: Ignore invalid indexes in pg_dump.

Browse pgsql-hackers by date

  From Date Subject
Next Message anarazel@anarazel.de 2013-03-28 21:47:55 Re: Ignore invalid indexes in pg_dump.
Previous Message Bruce Momjian 2013-03-28 21:35:08 Re: Ignore invalid indexes in pg_dump.