...
From https://www.postgresql.org/docs/9.3/static/sql-prepare-transaction.html :
| Panel | ||||
|---|---|---|---|---|
| ||||
| It is not currently allowed to PREPARE a transaction that has executed any operations involving temporary tables, created any cursors WITH HOLD, or executed LISTEN, UNLISTEN, or NOTIFY. Those features are too tightly tied to the current session to be useful in a transaction to be prepared. |
...