The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/10/static/sql-prepare-transaction.html Description:
Hi, in prepare transaction documentation in PG10 and earlier, it says that you can't prepare a transaction with LISTEN or UNLISTEN but it doesn't mention NOTIFY. The NOTIFY documentation *does* mention that it won't work with PREPARE, so it's just that the explicit mention of LISTEN and not NOTIFY is confusing. I know this isn't the place to ask (and I'll never see the answer :) but I'm baffled by the lack of support for NOTIFY in prepared transactions, and it's causing me loads of grief, looks like I'm going to have to use a poll based solution over a large number of databases, which is really unfortunate in terms of resource utilisation. -- Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs
