From: Tom Lane <tgl@sss.pgh.pa.us>
To: mark@inomial.com
Cc: pgsql-docs@postgresql.org
Subject: Re: Prepare transaction doesn't mention NOTIFY
Date: Fri, 27 Oct 2017 10:59:00 -0400
Message-ID: <14803.1509116340@sss.pgh.pa.us> (raw)
In-Reply-To: <20171024010602.1488.80066@wrigleys.postgresql.org>
References: <20171024010602.1488.80066@wrigleys.postgresql.org>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-docs>
mark@inomial.com writes:
> 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.
Yup, that's an oversight --- fixed.
> 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,
The big problem is that we can't do anything at PREPARE time to guarantee
that the NOTIFY will succeed. Admittedly, the queue is large enough that
failure to insert the message isn't too likely, but "probably it will
work" is not the semantics we want from PREPARE.
regards, tom lane
--
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: tgl@sss.pgh.pa.us, mark@inomial.com
Subject: Re: Prepare transaction doesn't mention NOTIFY
In-Reply-To: <14803.1509116340@sss.pgh.pa.us>
* 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