pgsql: Preserve pg_index.indisclustered across REINDEX CONCURRENTLY

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Preserve pg_index.indisclustered across REINDEX CONCURRENTLY
Date: 2020-03-03 01:13:31
Message-ID: E1j8w7n-0004Mm-7D@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Preserve pg_index.indisclustered across REINDEX CONCURRENTLY

If the flag value is lost, a CLUSTER query following REINDEX
CONCURRENTLY could fail. Non-concurrent REINDEX is already handling
this case consistently.

Author: Justin Pryzby
Discussion: https://postgr.es/m/20200229024202.GH29456@telsasoft.com
Backpatch-through: 12

Branch
------
REL_12_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/f087d63a45b5935b5c15cecb7d88f140d5cc8b7c

Modified Files
--------------
src/backend/catalog/index.c | 8 +++++++-
src/test/regress/expected/create_index.out | 13 +++++++++++++
src/test/regress/sql/create_index.sql | 9 +++++++++
3 files changed, 29 insertions(+), 1 deletion(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Fujii Masao 2020-03-03 03:05:24 pgsql: Report progress of streaming base backup.
Previous Message Tom Lane 2020-03-02 23:41:56 pgsql: Fix possibly-uninitialized variable.