From: Christoph Haller <ch@rodos.fzk.de>
To: pgsql-interfaces@postgresql.org
Cc: mevanecek@yahoo.com
Subject: Re: Using LISTEN/NOTIFY with ecpg
Date: Mon, 24 Feb 2003 15:25:44 +0100
Message-ID: <3E5A2B67.23B3A128@rodos.fzk.de> (raw)
>
> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: ch@rodos.fzk.de, mevanecek@yahoo.com
Subject: Re: Using LISTEN/NOTIFY with ecpg
In-Reply-To: <3E5A2B67.23B3A128@rodos.fzk.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox