On 5/10/07, Jan Strube <js(at)deriva(dot)de> wrote:
> is there a way to invoke a trigger only if the current transaction is
> committed?
> The problem is that my trigger does some kind of logging outside the
> database and therefore must not be invoked if the transaction is rolled
> back.
PostgreSQL does not implement a kind of "on commit" trigger, but you
can simulate them using "notify" and "listen", which are
transactional:
http://www.postgresql.org/docs/8.2/interactive/sql-notify.html
Alexander.