Re: Multiple NOTIFY is ignored - Mailing list pgsql-general

From Markus Kolb
Subject Re: Multiple NOTIFY is ignored
Date
Msg-id 4a110ae394ab6f7e14a607bf77f303f5@127.0.0.1
Whole thread Raw
In response to Re: Multiple NOTIFY is ignored  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: Multiple NOTIFY is ignored
List pgsql-general
Am 28.07.2016 16:42, schrieb Adrian Klaver:
> On 07/28/2016 07:29 AM, Markus Kolb wrote:

[...]
>> So why the 2nd notify is not delivered/recognized?
>
> At a guess the second NOTIFY is not completed by ;

It is no problem of syntax.
If this would be the case I would get an error/exception.
There is no exception.

I think dblink knows how to handle the missing ; at the end.
You need to use ; only between multiple commands.


pgsql-general by date:

Previous
From: Rakesh Kumar
Date:
Subject: Re: Uber migrated from Postgres to MySQL
Next
From: "Day, David"
Date:
Subject: Re: Server side backend permanent session memory usage ?