pgsql: Restore REINDEX constraint validation. - Mailing list pgsql-committers

From Noah Misch
Subject pgsql: Restore REINDEX constraint validation.
Date
Msg-id E1V4JtU-0000Ul-16@gemulon.postgresql.org
Whole thread Raw
List 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_2_STABLE

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

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


pgsql-committers by date:

Previous
From: Noah Misch
Date:
Subject: pgsql: Restore REINDEX constraint validation.
Next
From: Noah Misch
Date:
Subject: pgsql: Restore REINDEX constraint validation.