Re: Invoke trigger after commit

On 5/10/07, Jan Strube <js@deriva.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.