From: | mark(at)inomial(dot)com |
---|---|
To: | pgsql-docs(at)postgresql(dot)org |
Subject: | Prepare transaction doesn't mention NOTIFY |
Date: | 2017-10-24 01:06:02 |
Message-ID: | 20171024010602.1488.80066@wrigleys.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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.
From | Date | Subject | |
---|---|---|---|
Next Message | Tomonari Katsumata | 2017-10-24 03:59:25 | Re: Behavior of recovery_target_inclusive. |
Previous Message | Michael Paquier | 2017-10-24 00:45:31 | Re: Behavior of recovery_target_inclusive. |