postgres.git / summary / log / commit / refs
commit f39fc2b27d2b61827d65562e222d5177a1b4dfe0
Author: Tom Lane <tgl@sss.pgh.pa.us>
Date: Fri Oct 27 14:46:07 2017 +0000
First released in: 11.0, 9.2.24, 9.3.20, 9.4.15, 9.5.10, 9.6.6, 10.1
Doc: mention that you can't PREPARE TRANSACTION after NOTIFY.
The NOTIFY page said this already, but the PREPARE TRANSACTION page
missed it.
Discussion: https://postgr.es/m/20171024010602.1488.80066@wrigleys.postgresql.org
doc/src/sgml/ref/prepare_transaction.sgml | 3 ++-
1 file changed, 2 insertions(+), 1 deletion(-)
diff --git a/doc/src/sgml/ref/prepare_transaction.sgml b/doc/src/sgml/ref/prepare_transaction.sgml
index a379819a0aa..3c554755409 100644
--- a/doc/src/sgml/ref/prepare_transaction.sgml
+++ b/doc/src/sgml/ref/prepare_transaction.sgml
@@ -100,7 +100,8 @@ PREPARE TRANSACTION <replaceable class="PARAMETER">transaction_id</replaceable>
It is not currently allowed to <command>PREPARE</> a transaction that
has executed any operations involving temporary tables,
created any cursors <literal>WITH HOLD</>, or executed
- <command>LISTEN</> or <command>UNLISTEN</>.
+ <command>LISTEN</>, <command>UNLISTEN</>, or
+ <command>NOTIFY</>.
Those features are too tightly
tied to the current session to be useful in a transaction to be prepared.
</para>
[parent: d5fb450aab74]