On 07/28/2016 07:50 AM, Markus Kolb wrote:
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 ca
Markus Kolb writes:
> 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.
I can't duplicate this.
contri
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of David G. Johnston
Sent: Thursday, July 28, 2016 11:05 AM
To: Markus Kolb
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Multiple NOTIFY is ignored
On Thu, Jul 28, 2016 at 10:29 AM, Markus
On Thu, Jul 28, 2016 at 10:29 AM, Markus Kolb <
markus.kolb+postg...@tower-net.de> wrote:
> 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
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
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}');
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
dbli
