From: mark@inomial.com
To: pgsql-docs@postgresql.org
Subject: Prepare transaction doesn't mention NOTIFY
Date: Tue, 24 Oct 2017 01:06:02 +0000
Message-ID: <20171024010602.1488.80066@wrigleys.postgresql.org> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-docs>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: mark@inomial.com
Subject: Re: Prepare transaction doesn't mention NOTIFY
In-Reply-To: <20171024010602.1488.80066@wrigleys.postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox