Thread: pgsql: Preserve replica identity index across ALTER TABLE rewrite
Preserve replica identity index across ALTER TABLE rewrite If an index was explicitly set as replica identity index, this setting was lost when a table was rewritten by ALTER TABLE. Because this setting is part of pg_index but actually controlled by ALTER TABLE (not part of CREATE INDEX, say), we have to do some extra work to restore it. Based-on-patch-by: Quan Zongliang <quanzongliang@gmail.com> Reviewed-by: Euler Taveira <euler.taveira@2ndquadrant.com> Discussion: https://www.postgresql.org/message-id/flat/c70fcab2-4866-0d9f-1d01-e75e189db342@gmail.com Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/1cc9c2412cc9a2fbe6a381170097d315fd40ccca Modified Files -------------- src/backend/commands/tablecmds.c | 42 +++++++++++++++++++++++ src/backend/utils/cache/lsyscache.c | 23 +++++++++++++ src/include/utils/lsyscache.h | 1 + src/test/regress/expected/replica_identity.out | 46 ++++++++++++++++++++++++++ src/test/regress/sql/replica_identity.sql | 21 ++++++++++++ 5 files changed, 133 insertions(+)