diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2017-10-27 10:46:06 -0400 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2017-10-27 10:46:06 -0400 |
| commit | 0ff56a59d2496a8f896362b91d1faa9b14f6a6d9 (patch) | |
| tree | 3a85e2ea9ea16cc6cf02a9656bd134a3baccd273 | |
| parent | 036b6bd50365b9ae6ec0b4cb21d172510ef440a9 (diff) | |
| download | postgresql-0ff56a59d2496a8f896362b91d1faa9b14f6a6d9.tar.gz postgresql-0ff56a59d2496a8f896362b91d1faa9b14f6a6d9.zip | |
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
| -rw-r--r-- | doc/src/sgml/ref/prepare_transaction.sgml | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/doc/src/sgml/ref/prepare_transaction.sgml b/doc/src/sgml/ref/prepare_transaction.sgml index 626753f5762..50a93b45dd3 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> |