X-Original-To: pgsql-interfaces@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 5F5CE474E4F for ; Mon, 24 Feb 2003 09:25:53 -0500 (EST) Received: from postgresql.org ([64.49.215.8]) by localhost (postgresql.org [64.49.215.8:10024]) (amavisd-new) with SMTP id 72556-02 for ; Mon, 24 Feb 2003 09:25:42 -0500 (EST) Received: from fzkmail2.fzk.de (fzkmail2.fzk.de [141.52.27.52]) by postgresql.org (Postfix) with SMTP id 07C26474E42 for ; Mon, 24 Feb 2003 09:25:42 -0500 (EST) Received: FROM resy5.fzk.de BY fzkmail2.fzk.de ; Mon Feb 24 15:25:44 2003 +0100 Received: œby rodos.fzk.de with ESMTP (8.8.6 (PHNE_17135)/8.7.1) id PAA07560; Mon, 24 Feb 2003 15:25:44 +0100 (MET) Message-ID: <3E5A2B67.23B3A128@rodos.fzk.de> Date: Mon, 24 Feb 2003 15:25:44 +0100 From: Christoph Haller X-Mailer: Mozilla 4.77 [en] (X11; U; HP-UX B.10.20 9000/780) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-interfaces@postgresql.org Cc: mevanecek@yahoo.com Subject: Re: Using LISTEN/NOTIFY with ecpg Content-Type: text/plain; charset=iso-8859-2 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new X-Archive-Number: 200302/99 X-Sequence-Number: 3720 > > Does anyone have any examples of using LISTEN/NOTIFY with ecpg? Is that > a supported functionality? If not, is there a way to work around it? > No, I have no example and I don't know if it's supported at all. But the libpq interface offers Asynchronous Notification via the LISTEN and NOTIFY commands. See there. And it's no problem at all to use libpq functions from within embedded SQL programs. You have to link with -lpq anyway, so I'm pretty positive just using PQnotifies should work. Furthermore, there is an example program at Example 1-2. libpq Example Program 2 Test of the asynchronous notification interface Hope this helps. Regards, Christoph