Re: implementing asynchronous notifications PLEASE CONFIRM

From: Kris Jurka <books(at)ejurka(dot)com>
To: David Gagnon <dgagnon(at)siunik(dot)com>
Cc: Andres Olarte <olarte(dot)andres(at)gmail(dot)com>, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: implementing asynchronous notifications PLEASE CONFIRM
Date: 2005-08-26 19:41:49
Message-ID: Pine.BSO.4.62.0508261439210.30039@leary.csoft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Heikki Linnakangas 2005-08-28 07:34:17 XADataSource implementation
Previous Message David Gagnon 2005-08-26 18:19:17 Re: implementing asynchronous notifications PLEASE CONFIRM MY