pgsql: Ignore invalid indexes in pg_dump. - Mailing list pgsql-committers

From Tom Lane
Subject pgsql: Ignore invalid indexes in pg_dump.
Date
Msg-id E1UKbes-00018B-M0@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
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

Branch
------
REL8_4_STABLE

Details
-------
http://git.postgresql.org/pg/commitdiff/1173fa2a7e65a9ee65e89dcc1421a40adbb886d8

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


pgsql-committers by date:

Previous
From: Tom Lane
Date:
Subject: pgsql: Ignore invalid indexes in pg_dump.
Next
From: Tom Lane
Date:
Subject: pgsql: Fix grammatical errors in some new message strings.