pg.ddx.io pgsql-docs@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Prepare transaction doesn't mention NOTIFY 2+ messages / 2 participants [nested] [flat]
Commits from this thread: 2017-10-27 7b233fce1b 55429227ce 0ff56a59d2 1c715f1713 7102efd9d7 f39fc2b27d e4fbf22831 Doc: mention that you can't PREPARE TRANSACTION after NOTIFY.
* Prepare transaction doesn't mention NOTIFY @ 2017-10-24 01:06 mark@inomial.com 0 siblings, 1 reply; 2+ messages in thread From: mark@inomial.com @ 2017-10-24 01:06 UTC (permalink / raw) To: pgsql-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 ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Prepare transaction doesn't mention NOTIFY @ 2017-10-27 14:59 Tom Lane <tgl@sss.pgh.pa.us> parent: mark@inomial.com 0 siblings, 0 replies; 2+ messages in thread From: Tom Lane @ 2017-10-27 14:59 UTC (permalink / raw) To: mark@inomial.com; +Cc: pgsql-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 ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2017-10-27 14:59 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2017-10-24 01:06 Prepare transaction doesn't mention NOTIFY mark@inomial.com 2017-10-27 14:59 ` Tom Lane <tgl@sss.pgh.pa.us>
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