Markus Kolb <markus.kolb+postgres@tower-net.de> 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.
contrib_regression=# SELECT dblink_connect('myconn',connection_parameters());
dblink_connect
----------------
OK
(1 row)
contrib_regression=# select dblink('myconn', $$notify foo,'0|UPDATE|A|'; notify foo,'0|DELETE|A|'$$);
dblink
----------
(NOTIFY)
(1 row)
Over in another session that's done "LISTEN foo":
contrib_regression=# select 1;
?column?
----------
1
(1 row)
Asynchronous notification "foo" with payload "0|UPDATE|A|" received from server process with PID 19442.
Asynchronous notification "foo" with payload "0|DELETE|A|" received from server process with PID 19442.
regards, tom lane