pgsql: Restore REINDEX constraint validation.

From: Noah Misch <noah(at)leadboat(dot)com>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Restore REINDEX constraint validation.
Date: 2013-07-31 00:03:56
Message-ID: E1V4JtU-0000Uo-2u@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Restore REINDEX constraint validation.

Refactoring as part of commit 8ceb24568054232696dddc1166a8563bc78c900a
had the unintended effect of making REINDEX TABLE and REINDEX DATABASE
no longer validate constraints enforced by the indexes in question;
REINDEX INDEX still did so. Indexes marked invalid remained so, and
constraint violations arising from data corruption went undetected.
Back-patch to 9.0, like the causative commit.

Branch
------
REL9_1_STABLE

Details
-------
http://git.postgresql.org/pg/commitdiff/ed33ad39a2f353acc3d38591a749f324de3b6c23

Modified Files
--------------
src/backend/commands/indexcmds.c | 8 ++++++--
src/test/regress/expected/create_index.out | 26 +++++++++++++++++++++++---
src/test/regress/sql/create_index.sql | 11 +++++++----
3 files changed, 36 insertions(+), 9 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Andres Freund 2013-07-31 01:39:14 Re: [COMMITTERS] pgsql: Add support for REFRESH MATERIALIZED VIEW CONCURRENTLY.
Previous Message Noah Misch 2013-07-31 00:03:55 pgsql: Restore REINDEX constraint validation.