diff --git a/doc/src/sgml/ref/alter_publication.sgml b/doc/src/sgml/ref/alter_publication.sgml index 44ae7e0e87..dedf30ec12 100644 --- a/doc/src/sgml/ref/alter_publication.sgml +++ b/doc/src/sgml/ref/alter_publication.sgml @@ -154,6 +154,22 @@ ALTER PUBLICATION name RENAME TO . See there for more information. + + + When the partition root table is explicitly specified as the replication + target instead of its leaf, altering the + publish_via_partition_root during the replication can + lead to data loss or duplication. This is because the publisher + replicates changes as the partitioned table after the altering, but it + is not listed in + pg_subscription_rel. + + + To prevent the issue, you can avoid modifying the partitioned root table + between the ALTER PUBLICATION ... SET and + ALTER SUBSCRIPTION ... REFRESH PUBLICATION. + +