pgsql: Fix handling of expressions and predicates in REINDEX CONCURRENT

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Fix handling of expressions and predicates in REINDEX CONCURRENT
Date: 2019-07-29 01:08:33
Message-ID: E1hru9R-0004Kx-J8@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Fix handling of expressions and predicates in REINDEX CONCURRENTLY

When copying the definition of an index rebuilt concurrently for the new
entry, the index information was taken directly from the old index using
the relation cache. In this case, predicates and expressions have
some post-processing to prepare things for the planner, which loses some
information including the collations added in any of them.

This inconsistency can cause issues when attempting for example a table
rewrite, and makes the new indexes rebuilt concurrently inconsistent
with the old entries.

In order to fix the problem, fetch expressions and predicates directly
from the catalog of the old entry, and fill in IndexInfo for the new
index with that. This makes the process more consistent with
DefineIndex(), and the code is refactored with the addition of a routine
to create an IndexInfo node.

Reported-by: Manuel Rigger
Author: Michael Paquier
Discussion: https://postgr.es/m/CA+u7OA5Hp0ra235F3czPom_FyAd-3+XwSJmX95r1+sRPOJc9VQ@mail.gmail.com
Backpatch-through: 12

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/7cce159349ccdb39ade07f869f08e4929ef2fe0b

Modified Files
--------------
src/backend/catalog/index.c | 74 +++++++++++++++++++++++++++---
src/backend/commands/indexcmds.c | 46 ++++++-------------
src/backend/nodes/makefuncs.c | 52 ++++++++++++++++++++-
src/include/nodes/makefuncs.h | 7 ++-
src/test/regress/expected/create_index.out | 72 +++++++++++++++++++++++++++++
src/test/regress/sql/create_index.sql | 28 +++++++++++
6 files changed, 237 insertions(+), 42 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Michael Paquier 2019-07-29 03:38:47 pgsql: Fix inconsistencies and typos in the tree
Previous Message Thomas Munro 2019-07-28 22:26:23 pgsql: Avoid macro clash with LLVM 9.