LISTEN/NOTIFY

Cristóvão B. B. Dalla Costa <cbraga@bsi.com.br>

From: Cristóvão Dalla Costa <cbraga@bsi.com.br>
To: pgsql-general@postgresql.org
Date: 2002-10-04T20:49:55Z
Lists: pgsql-general
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". Also, I don't really like the vanilla Pg. So, my question 
to you is, is there another efficient way to accomplish notification of 
updates?

Thank you

Cristóvão