Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id E25654761E6 for ; Fri, 4 Oct 2002 16:50:09 -0400 (EDT) Received: from cwbone.bsi.com.br (cwbone.bsi.com.br [200.194.240.1]) by postgresql.org (Postfix) with ESMTP id 5ED4E476033 for ; Fri, 4 Oct 2002 16:50:08 -0400 (EDT) Received: from bsi.com.br (BSI16-200.bsi.com.br [200.189.16.200]) by cwbone.bsi.com.br (8.12.3/8.12.3) with ESMTP id g94KusWQ030831 for ; Fri, 4 Oct 2002 17:56:58 -0300 (BRT) Message-ID: <3D9DFEF3.6020509@bsi.com.br> Date: Fri, 04 Oct 2002 17:49:55 -0300 From: =?ISO-8859-1?Q?Crist=F3v=E3o_Dalla_Costa?= User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.2b) Gecko/20020927 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-general@postgresql.org Subject: LISTEN/NOTIFY Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200210/280 X-Sequence-Number: 31278 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