Thread: pgsql: Fix REINDEX CONCURRENTLY of partitions
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 <michael@paquier.xyz> Author: Peter Eisentraut <peter.eisentraut@2ndquadrant.com> 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(-)