From: Iain <iain@mst.co.jp>
To: Greg Stark <gsstark@mit.edu>
Cc: Mike Rylander <mrylander@gmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: implementing an out-of-transaction trigger
Date: Thu, 16 Sep 2004 14:15:39 +0900
Message-ID: <00ba01c49bac$358511d0$7201a8c0@mst1x5r347kymb> (raw)
References: <002f01c49ad0$9491e180$7201a8c0@mst1x5r347kymb>
<b918cf3d0409150903579bed18@mail.gmail.com>
<008c01c49b91$361e86f0$7201a8c0@mst1x5r347kymb>
<87sm9irhl8.fsf@stark.xeocode.com>
Hi Greg,
I would have like to have avoided writing a daemon if possible, but
presumably it should be possible to write one flexible enough to be used in
a variety of situations.
If I didn't use notify, I'd would just be checking for the presence of data
in "transfer areas" or queue tables as you called them on a periodic basis.
This wouldn't change so much using notify, except that instead of writing
the process so as to sleep and periodically check, I can just have it wake
up when the data actually gets there. A minor saving perhaps, but at least I
could use the name of the notification to determine what processing to
activate.
Thanks,
Iain
----- Original Message -----
From: "Greg Stark" <gsstark@mit.edu>
To: "Iain" <iain@mst.co.jp>
Cc: "Mike Rylander" <mrylander@gmail.com>; <pgsql-sql@postgresql.org>
Sent: Thursday, September 16, 2004 12:57 PM
Subject: Re: [SQL] implementing an out-of-transaction trigger
>
> "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: iain@mst.co.jp, gsstark@mit.edu, mrylander@gmail.com
Subject: Re: implementing an out-of-transaction trigger
In-Reply-To: <00ba01c49bac$358511d0$7201a8c0@mst1x5r347kymb>
* 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