Is anyone successfully using the NOTIFY/LISTEN mechanism in pgsql 7.0?

Regards,
Ed Loehr

Wed, 07 Jun 2000 21:37:14 -0500
Ed Loehr <eloehr@austin.rr.com>
[GENERAL]  NOTIFY/LISTEN in pgsql 7.0
Ed Loehr <eloehr@austin.rr.com> writes:
> Is anyone successfully using the NOTIFY/LISTEN mechanism in pgsql 7.0?

It still works AFAICT.  Why, are you seeing a problem?

			regards, tom lane

Thu, 08 Jun 2000 10:14:54 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: [GENERAL] NOTIFY/LISTEN in pgsql 7.0 
Tom Lane wrote:
> 
> Ed Loehr <eloehr@austin.rr.com> writes:
> > Is anyone successfully using the NOTIFY/LISTEN mechanism in pgsql 7.0?
> 
> It still works AFAICT.  Why, are you seeing a problem?

No.  I just hadn't recalled any discussion of it in 6 months and wondered
if it was "bit-rotting".  The context was a discussion on pgsql-sql re
how to enable table-based caching of results in a modperl/DBI app.  More
specifically, use of NOTIFY/LISTEN to alert the apps when a table had
been changed in order to invalidate cached results dependent on that
table.  After a closer look, I'm wondering how it would fit (if at all)
with the mod_perl/DBI API/model.  [BTW, I still haven't heard anything to
dissuade me from thinking that server-side shared-mem result-set caching
would be a huge performance win for many, many apps, including mine.  I
wish I better understood the lack of enthusiasm for that idea...]

Regards,
Ed Loehr

Thu, 08 Jun 2000 09:56:01 -0500
Ed Loehr <eloehr@austin.rr.com>
Re: [GENERAL] NOTIFY/LISTEN in pgsql 7.0