postgres.git / summary / log / commit / refs

commit    e114289e1e4774dfc3371372e36b3f0fed66b741
Author:   Peter Eisentraut <peter_e@gmx.net>
Date:     Fri Sep 22 19:01:13 2017 +0000

    doc: Document commands that cannot be run in a transaction block
    
    Mainly covering the new CREATE SUBSCRIPTION and DROP SUBSCRIPTION, but
    ALTER DATABASE SET TABLESPACE was also missing.


 doc/src/sgml/ref/alter_database.sgml      |  4 ++++
 doc/src/sgml/ref/create_subscription.sgml | 10 +++++-----
 doc/src/sgml/ref/drop_subscription.sgml   |  5 +++++
 3 files changed, 14 insertions(+), 5 deletions(-)

diff --git a/doc/src/sgml/ref/alter_database.sgml b/doc/src/sgml/ref/alter_database.sgml
index cfc28cf9a77..9ab86127afa 100644
--- a/doc/src/sgml/ref/alter_database.sgml
+++ b/doc/src/sgml/ref/alter_database.sgml
@@ -164,6 +164,10 @@ ALTER DATABASE <replaceable class="PARAMETER">name</replaceable> RESET ALL
      <para>
       The new default tablespace of the database.
      </para>
+
+     <para>
+      This form of the command cannot be executed inside a transaction block.
+     </para>
     </listitem>
    </varlistentry>
 
diff --git a/doc/src/sgml/ref/create_subscription.sgml b/doc/src/sgml/ref/create_subscription.sgml
index 9f45b6f574a..de505ea8d37 100644
--- a/doc/src/sgml/ref/create_subscription.sgml
+++ b/doc/src/sgml/ref/create_subscription.sgml
@@ -48,11 +48,6 @@ CREATE SUBSCRIPTION <replaceable class="PARAMETER">subscription_name</replaceabl
    subscription at the commit of the transaction where this command is run.
   </para>
 
-  <para>
-   <command>CREATE SUBSCRIPTION</command> cannot be executed inside a
-   transaction block when the parameter <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
@@ -227,6 +222,11 @@ CREATE SUBSCRIPTION <replaceable class="PARAMETER">subscription_name</replaceabl
    publication instance.
   </para>
 
+  <para>
+   When creating a replication slot (the default behavior), <command>CREATE
+   SUBSCRIPTION</command> cannot be executed inside a transaction block.
+  </para>
+
   <para>
    Creating a subscription that connects to the same database cluster (for
    example, to replicate between databases in the same cluster or to replicate
diff --git a/doc/src/sgml/ref/drop_subscription.sgml b/doc/src/sgml/ref/drop_subscription.sgml
index f535c000c40..f5734e6f300 100644
--- a/doc/src/sgml/ref/drop_subscription.sgml
+++ b/doc/src/sgml/ref/drop_subscription.sgml
@@ -93,6 +93,11 @@ DROP SUBSCRIPTION [ IF EXISTS ] <replaceable class="parameter">name</replaceable
    reserve WAL and might eventually cause the disk to fill up.  See
    also <xref linkend="logical-replication-subscription-slot">.
   </para>
+
+  <para>
+   If a subscription is associated with a replication slot, then <command>DROP
+   SUBSCRIPTION</command> cannot be executed inside a transaction block.
+  </para>
  </refsect1>
 
  <refsect1>


[parent: 1a44df007c9b]