Re: Multiple NOTIFY is ignored

From: Markus Kolb <markus(dot)kolb+postgres(at)tower-net(dot)de>
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Multiple NOTIFY is ignored
Date: 2016-07-28 14:50:58
Message-ID: 4a110ae394ab6f7e14a607bf77f303f5@127.0.0.1
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rakesh Kumar 2016-07-28 14:50:59 Re: Uber migrated from Postgres to MySQL
Previous Message Adrian Klaver 2016-07-28 14:42:43 Re: Multiple NOTIFY is ignored