diff --git a/doc/src/sgml/ref/alter_subscription.sgml b/doc/src/sgml/ref/alter_subscription.sgml index e021f87..58db97f 100644 --- a/doc/src/sgml/ref/alter_subscription.sgml +++ b/doc/src/sgml/ref/alter_subscription.sgml @@ -256,14 +256,15 @@ ALTER SUBSCRIPTION name RENAME TO < - The two_phase parameter can only be altered when the - subscription is disabled. When altering the parameter from true + The two_phase + parameter can only be altered when the subscription is disabled. + When altering the parameter from true to false, the backend process checks for any incomplete prepared transactions done by the logical replication worker (from when two_phase parameter was still true) - and, if any are found, this command is failed with an error. In this - case, you can resolve prepared transactions on the publisher node or - manually roll back them on the subscriber. After the altering from + and, if any are found, an error is reported. If this happens, you can + resolve prepared transactions on the publisher node or + manually roll back them on the subscriber, then try again. After the altering from true to false, the publisher will replicate transactions again when they are committed.