Commit0ff56a5

committed

Doc: mention that you can't PREPARE TRANSACTION after NOTIFY.

The NOTIFY page said this already, but the PREPARE TRANSACTION pagemissed it.Discussion:https://postgr.es/m/20171024010602.1488.80066@wrigleys.postgresql.org

1 parent036b6bd commit0ff56a5Copy full SHA for 0ff56a5

File tree

-1

lines changed

-1

lines changed

Lines changed: 2 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -100,7 +100,8 @@ PREPARE TRANSACTION <replaceable class="PARAMETER">transaction_id</replaceable>`
`100`	`100`	`It is not currently allowed to <command>PREPARE</> a transaction that`
`101`	`101`	`has executed any operations involving temporary tables,`
`102`	`102`	`created any cursors <literal>WITH HOLD</>, or executed`
`103`		`- <command>LISTEN</> or <command>UNLISTEN</>.`
	`103`	`+ <command>LISTEN</>, <command>UNLISTEN</>, or`
	`104`	`+ <command>NOTIFY</>.`
`104`	`105`	`Those features are too tightly`
`105`	`106`	`tied to the current session to be useful in a transaction to be prepared.`
`106`	`107`	`</para>`

Comments

(0)