Re: implementing asynchronous notifications PLEASE CONFIRM - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: implementing asynchronous notifications PLEASE CONFIRM
Date
Msg-id Pine.BSO.4.62.0508261439210.30039@leary.csoft.net
Whole thread Raw
In response to Re: implementing asynchronous notifications PLEASE CONFIRM MY  (David Gagnon <dgagnon@siunik.com>)
List pgsql-jdbc

On Fri, 26 Aug 2005, David Gagnon wrote:

> I tought of another solution .. but again I have no Idea what is the
> performance cost or if it's feseable at all.  Perl (don't know perl at all
> :-(() allows global variables
> http://www.postgresql.org/docs/8.0/static/plperl-global.html
>

These globabl variables are not truly global, they are per connection, so
you can't store something in one connection, issue a NOTIFY and pick it up
from the LISTENing connection.  You would need to put these actions into a
real table to make it available to more than one connection.

Kris Jurka

pgsql-jdbc by date:

Previous
From: David Gagnon
Date:
Subject: Re: implementing asynchronous notifications PLEASE CONFIRM MY
Next
From: Heikki Linnakangas
Date:
Subject: XADataSource implementation