From: Greg Stark <gsstark@mit.edu>
To: Iain <iain@mst.co.jp>
Cc: Mike Rylander <mrylander@gmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: implementing an out-of-transaction trigger
Date: 15 Sep 2004 23:57:39 -0400
Message-ID: <87sm9irhl8.fsf@stark.xeocode.com> (raw)
In-Reply-To: <008c01c49b91$361e86f0$7201a8c0@mst1x5r347kymb>
References: <002f01c49ad0$9491e180$7201a8c0@mst1x5r347kymb>
<b918cf3d0409150903579bed18@mail.gmail.com>
<008c01c49b91$361e86f0$7201a8c0@mst1x5r347kymb>
"Iain" <iain@mst.co.jp> writes:
> Though, as far as I can tell, there is no way to have the notify activate a
> pl/pgsql function directly. I'll still need to write a client program to
> create a session and actually do the listening, that is if I havn't missed
> anything else...
Right, presumably some sort of daemon that sits and waits for events. Much
like you would have with Oracle advanced queuing and such.
The big difference is that NOTIFY doesn't pass along any parameters. You will
need some way for your daemon to find any pending data it needs to process.
You might need some kind of queue table, or you might be able to get by
without one.
--
greg
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-sql@postgresql.org
Cc: gsstark@mit.edu, iain@mst.co.jp, mrylander@gmail.com
Subject: Re: implementing an out-of-transaction trigger
In-Reply-To: <87sm9irhl8.fsf@stark.xeocode.com>
* 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