Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-jdbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group