Re: [GENERAL] LISTEN/NOTIFY - Mailing list pgsql-interfaces

From alex@pilosoft.com
Subject Re: [GENERAL] LISTEN/NOTIFY
Date
Msg-id Pine.LNX.4.44.0210052026550.21062-100000@paix.pilosoft.com
Whole thread Raw
In response to Re: [GENERAL] LISTEN/NOTIFY  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [GENERAL] LISTEN/NOTIFY
List pgsql-interfaces
On Fri, 4 Oct 2002, Tom Lane wrote:

> =?ISO-8859-1?Q?Crist=F3v=E3o_Dalla_Costa?= <cbraga@bsi.com.br> writes:
> > I'm developing an e-commerce site using Apache/mod_perl and, for
> > performance, I intend to cache rows such as user and product information
> > inside Perl. I think the LISTEN/NOTIFY interface would be perfect for
> > invalidating the cache when a product/user gets updated, yet I have not
> > found a way to access it from Perl -- DBI, or DBD::Pg even, offer no way
> > to "listen".
See this:
http://archives.postgresql.org/pgsql-interfaces/2002-01/msg00018.php


> I don't know what the DBI/DBD design philosophy is regarding
> database-specific extensions --- but it would seem reasonable to me for
> DBD::Pg to offer some way to get at LISTEN functionality.  Can anyone
> suggest how to do this in the context of DBI?
It uses generic func() interface...

> I suggest moving any followups to pgsql-interfaces, where this
> discussion would be more on-topic.
-alex


pgsql-interfaces by date:

Previous
From: "victor3.lopes@voila.fr"
Date:
Subject: interface PERL and return results
Next
From: Tom Lane
Date:
Subject: Re: [GENERAL] LISTEN/NOTIFY