pgsql: Fix REINDEX CONCURRENTLY of partitions

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

pgsql: Fix REINDEX CONCURRENTLY of partitions

Peter Eisentraut-3
Fix REINDEX CONCURRENTLY of partitions

In case of a partition index, when swapping the old and new index, we
also need to attach the new index as a partition and detach the old
one.  Also, to handle partition indexes, we not only need to change
dependencies referencing the index, but also dependencies of the index
referencing something else.  The previous code did this only
specifically for a constraint, but we also need to do this for
partitioned indexes.  So instead write a generic function that does it
for all dependencies.

Author: Michael Paquier <[hidden email]>
Author: Peter Eisentraut <[hidden email]>
Discussion: https://www.postgresql.org/message-id/flat/DF4PR8401MB11964EDB77C860078C343BEBEE5A0%40DF4PR8401MB1196.NAMPRD84.PROD.OUTLOOK.COM#154df1fedb735190a773481765f7b874

Branch
------
master

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

Modified Files
--------------
src/backend/catalog/index.c                | 40 +++++++-------
src/backend/catalog/pg_depend.c            | 56 ++++++++++++++++++++
src/include/catalog/dependency.h           |  3 ++
src/test/regress/expected/create_index.out | 85 ++++++++++++++++++++++++++++++
src/test/regress/sql/create_index.sql      | 43 +++++++++++++++
5 files changed, 209 insertions(+), 18 deletions(-)