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

Re: [INTERFACES] LISTEN/NOTIFY

From: alex(at)pilosoft(dot)com
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org, <pgsql-interfaces(at)postgresql(dot)org>
Subject: Re: [INTERFACES] LISTEN/NOTIFY
Date: 2002-10-06 00:29:03
Message-ID: Pine.LNX.4.44.0210052026550.21062-100000@paix.pilosoft.com (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-interfaces
On Fri, 4 Oct 2002, Tom Lane wrote:

> =?ISO-8859-1?Q?Crist=F3v=E3o_Dalla_Costa?= <cbraga(at)bsi(dot)com(dot)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


In response to

Responses

pgsql-interfaces by date

Next:From: Tom LaneDate: 2002-10-06 01:08:28
Subject: Re: [INTERFACES] LISTEN/NOTIFY
Previous:From: victor3.lopesDate: 2002-10-05 21:31:40
Subject: interface PERL and return results

pgsql-general by date

Next:From: Tom LaneDate: 2002-10-06 00:39:39
Subject: Re: Server locale?
Previous:From: Martin WeinbergDate: 2002-10-05 23:05:36
Subject: Re: multi-column btree index for real values

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