pgsql: Restore REINDEX constraint validation.

Lists: pgsql-committers
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: [email protected]
Views: Whole Thread | Raw Message | Download mbox | Resend email
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_3_STABLE

Details
-------
http://git.postgresql.org/pg/commitdiff/9a78f66fdccbc85442f992f2928b4a58ae451208

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(-)