From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Markus Kolb <markus(dot)kolb+postgres(at)tower-net(dot)de>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Multiple NOTIFY is ignored |
Date: | 2016-07-28 14:42:43 |
Message-ID: | 91fc6bbc-4086-c7a2-b9ce-9be040b7cfca@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 07/28/2016 07:29 AM, Markus Kolb wrote:
> Hi,
>
> I've a question to the pgsql NOTIFY feature...
>
> I use something like
>
> SELECT dblink_connect('{0}', '{1}'); SELECT dblink('{2}', '{3}'); SELECT
> dblink_disconnect('{4}');
> where {3} is
> NOTIFY upd_pgm, '0|UPDATE|A|'
>
> SELECT dblink_connect('{0}', '{1}'); SELECT dblink('{2}', '{3}'); SELECT
> dblink_disconnect('{4}');
> where {3} is
> NOTIFY upd_pgm, '0|DELETE|A|'
>
> This works. Both notify are recognized.
>
> If I only do one
> SELECT dblink_connect('{0}', '{1}'); SELECT dblink('{2}', '{3}'); SELECT
> dblink_disconnect('{4}');
> where {3} is
> NOTIFY upd_pgm, '0|UPDATE|A|'; NOTIFY upd_pgm, '0|DELETE|A|'
>
> only the notify with UPDATE is recognized.
>
> For further explanation... the working solution uses separate dblink
> connections and calls for each notify.
> Where as the not working tries to use only one dblink connection and call.
>
> As far as I can read from the documentation...
> "If the same channel name is signaled multiple times from the same
> transaction with identical payload strings, the database server can
> decide to deliver a single notification only. On the other hand,
> notifications with distinct payload strings will always be delivered as
> distinct notifications."
> (https://www.postgresql.org/docs/current/static/sql-notify.html)
>
> Here the channel name is identical, but the payload differs with
> UPDATE/DELETE.
>
> So why the 2nd notify is not delivered/recognized?
At a guess the second NOTIFY is not completed by ;
>
> Thanks
> Markus
>
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Markus Kolb | 2016-07-28 14:50:58 | Re: Multiple NOTIFY is ignored |
Previous Message | Moreno Andreo | 2016-07-28 14:41:28 | Re: WAL directory size calculation |