From: Mike Rylander <mrylander@gmail.com>
To: Iain <iain@mst.co.jp>
Cc: pgsql-sql@postgresql.org
Subject: Re: implementing an out-of-transaction trigger
Date: Wed, 15 Sep 2004 12:03:11 -0400
Message-ID: <b918cf3d0409150903579bed18@mail.gmail.com> (raw)
In-Reply-To: <002f01c49ad0$9491e180$7201a8c0@mst1x5r347kymb>
References: <002f01c49ad0$9491e180$7201a8c0@mst1x5r347kymb>
>I've come across a situation where I'd like to use some kind of
"out-of-transaction
>trigger" to do some processing after changes to some tables, but
without extending
>the duration of the main transaction. Of course, it's important that
the processing be
>completed so it has to be, as far as possible, reliable and "safe". The extra
>processing should be completed within a reasonable time after the original
>transaction, but it needn't happen immediately.
Check out
http://www.postgresql.org/docs/7.4/static/sql-listen.html
and
http://www.postgresql.org/docs/7.4/static/sql-notify.html
Then look at the Rules system for generating a NOTIFY:
http://www.postgresql.org/docs/7.4/static/sql-createrule.html
--miker
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: mrylander@gmail.com, iain@mst.co.jp
Subject: Re: implementing an out-of-transaction trigger
In-Reply-To: <b918cf3d0409150903579bed18@mail.gmail.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