diff options
| author | Peter Eisentraut <peter_e@gmx.net> | 2017-03-03 23:25:34 -0500 |
|---|---|---|
| committer | Peter Eisentraut <peter_e@gmx.net> | 2017-03-03 23:29:13 -0500 |
| commit | 272adf4f9cd67df323ae57ff3dee238b649d3b73 (patch) | |
| tree | cc7f778f7a2cb49ed7f3dcf46eefb61e1aece4a4 /doc | |
| parent | 347302730dc3092143ccbc1c29b47ac3354f924b (diff) | |
Disallow CREATE/DROP SUBSCRIPTION in transaction block
Disallow CREATE SUBSCRIPTION and DROP SUBSCRIPTION in a transaction
block when the replication slot is to be created or dropped, since that
cannot be rolled back.
based on patch by Masahiko Sawada <sawada.mshk@gmail.com>
Diffstat (limited to 'doc')
| -rw-r--r-- | doc/src/sgml/ref/create_subscription.sgml | 5 | ||||
| -rw-r--r-- | doc/src/sgml/ref/drop_subscription.sgml | 4 |
2 files changed, 7 insertions, 2 deletions
diff --git a/doc/src/sgml/ref/create_subscription.sgml b/doc/src/sgml/ref/create_subscription.sgml index 250806f981b..9bed26219c6 100644 --- a/doc/src/sgml/ref/create_subscription.sgml +++ b/doc/src/sgml/ref/create_subscription.sgml @@ -52,6 +52,11 @@ CREATE SUBSCRIPTION <replaceable class="PARAMETER">subscription_name</replaceabl </para> <para> + <command>CREATE SUBSCRIPTION</command> cannot be executed inside a + transaction block when <literal>CREATE SLOT</literal> is specified. + </para> + + <para> Additional info about subscriptions and logical replication as a whole can is available at <xref linkend="logical-replication-subscription"> and <xref linkend="logical-replication">. diff --git a/doc/src/sgml/ref/drop_subscription.sgml b/doc/src/sgml/ref/drop_subscription.sgml index 9f2fb93275c..4228f1a2533 100644 --- a/doc/src/sgml/ref/drop_subscription.sgml +++ b/doc/src/sgml/ref/drop_subscription.sgml @@ -38,8 +38,8 @@ DROP SUBSCRIPTION [ IF EXISTS ] <replaceable class="parameter">name</replaceable </para> <para> - The replication worker associated with the subscription will not stop until - after the transaction that issued this command has committed. + <command>DROP SUBSCRIPTION</command> cannot be executed inside a + transaction block when <literal>DROP SLOT</literal> is specified. </para> </refsect1> |