Commit91ad8b4

committed

doc: Document commands that cannot be run in a transaction block

Mainly covering the new CREATE SUBSCRIPTION and DROP SUBSCRIPTION, butALTER DATABASE SET TABLESPACE was also missing.

1 parent8d92602 commit91ad8b4Copy full SHA for 91ad8b4

File tree

+14

-5

lines changed

+14

-5

lines changed

Lines changed: 4 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -164,6 +164,10 @@ ALTER DATABASE <replaceable class="PARAMETER">name</replaceable> RESET ALL`
`164`	`164`	`<para>`
`165`	`165`	`The new default tablespace of the database.`
`166`	`166`	`</para>`
	`167`	`+`
	`168`	`+ <para>`
	`169`	`+ This form of the command cannot be executed inside a transaction block.`
	`170`	`+ </para>`
`167`	`171`	`</listitem>`
`168`	`172`	`</varlistentry>`
`169`	`173`

Lines changed: 5 additions & 5 deletions

Original file line number	Diff line number	Diff line change
`@@ -48,11 +48,6 @@ CREATE SUBSCRIPTION <replaceable class="PARAMETER">subscription_name</replaceabl`
`48`	`48`	`subscription at the commit of the transaction where this command is run.`
`49`	`49`	`</para>`
`50`	`50`
`51`		`- <para>`
`52`		`- <command>CREATE SUBSCRIPTION</command> cannot be executed inside a`
`53`		`- transaction block when the parameter <literal>create_slot</literal> is specified.`
`54`		`- </para>`
`55`		`-`
`56`	`51`	`<para>`
`57`	`52`	`Additional info about subscriptions and logical replication as a whole`
`58`	`53`	`can is available at <xref linkend="logical-replication-subscription"> and`
`@@ -227,6 +222,11 @@ CREATE SUBSCRIPTION <replaceable class="PARAMETER">subscription_name</replaceabl`
`227`	`222`	`publication instance.`
`228`	`223`	`</para>`
`229`	`224`
	`225`	`+ <para>`
	`226`	`+ When creating a replication slot (the default behavior), <command>CREATE`
	`227`	`+ SUBSCRIPTION</command> cannot be executed inside a transaction block.`
	`228`	`+ </para>`
	`229`	`+`
`230`	`230`	`<para>`
`231`	`231`	`Creating a subscription that connects to the same database cluster (for`
`232`	`232`	`example, to replicate between databases in the same cluster or to replicate`

Lines changed: 5 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -93,6 +93,11 @@ DROP SUBSCRIPTION [ IF EXISTS ] <replaceable class="parameter">name</replaceable`
`93`	`93`	`reserve WAL and might eventually cause the disk to fill up. See`
`94`	`94`	`also <xref linkend="logical-replication-subscription-slot">.`
`95`	`95`	`</para>`
	`96`	`+`
	`97`	`+ <para>`
	`98`	`+ If a subscription is associated with a replication slot, then <command>DROP`
	`99`	`+ SUBSCRIPTION</command> cannot be executed inside a transaction block.`
	`100`	`+ </para>`
`96`	`101`	`</refsect1>`
`97`	`102`
`98`	`103`	`<refsect1>`

Comments

(0)