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

pgsql: Ignore invalid indexes in pg_dump.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Ignore invalid indexes in pg_dump.
Date: 2013-03-26 21:43:54
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-committerspgsql-hackers
Ignore invalid indexes in pg_dump.

Dumping invalid indexes can cause problems at restore time, for example
if the reason the index creation failed was because it tried to enforce
a uniqueness condition not satisfied by the table's data.  Also, if the
index creation is in fact still in progress, it seems reasonable to
consider it to be an uncommitted DDL change, which pg_dump wouldn't be
expected to dump anyway.

Back-patch to all active versions, and teach them to ignore invalid
indexes in servers back to 8.2, where the concept was introduced.

Michael Paquier



Modified Files
src/bin/pg_dump/pg_dump.c |    2 ++
1 files changed, 2 insertions(+), 0 deletions(-)


pgsql-hackers by date

Next:From: Kevin GrittnerDate: 2013-03-26 21:46:11
Subject: Re: Drastic performance loss in assert-enabled build in HEAD
Previous:From: Tom LaneDate: 2013-03-26 21:18:42
Subject: Re: spoonbill vs. -HEAD

pgsql-committers by date

Next:From: Tom LaneDate: 2013-03-26 21:52:09
Subject: pgsql: Fix grammatical errors in some new message strings.
Previous:From: Andres FreundDate: 2013-03-26 20:20:19
Subject: Re: [COMMITTERS] pgsql: Add PF_PRINTF_ATTRIBUTE to on_exit_msg_fmt.

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