PS_NITPICKS_20240717_2PC_V180003.txt
text/plain
Filename: PS_NITPICKS_20240717_2PC_V180003.txt
Type: text/plain
Part: 0
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 <replaceable class="parameter">name</replaceable> RENAME TO <
</para>
<para>
- The <literal>two_phase</literal> parameter can only be altered when the
- subscription is disabled. When altering the parameter from <literal>true</literal>
+ The <link linkend="sql-createsubscription-params-with-two-phase"><literal>two_phase</literal></link>
+ parameter can only be altered when the subscription is disabled.
+ When altering the parameter from <literal>true</literal>
to <literal>false</literal>, the backend process checks for any incomplete
prepared transactions done by the logical replication worker (from when
<literal>two_phase</literal> parameter was still <literal>true</literal>)
- 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
<literal>true</literal> to <literal>false</literal>, the publisher will
replicate transactions again when they are committed.
</para>