Prepare transaction doesn't mention NOTIFY

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.

Responses

Browse pgsql-docs by date

  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.