postgres.git / summary / log / commit / refs

commit    7102efd9d71f1398bdd9d695c2d1e730deaeb4d2
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: 0cf721244a81]