Invoke trigger after commit

From: Jan Strube <js(at)deriva(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Invoke trigger after commit
Date: 2007-05-10 11:14:27
Message-ID: 4642FE93.9000704@deriva.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

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.

Thanks in advance
Jan

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alexander Staubo 2007-05-10 11:43:14 Re: Invoke trigger after commit
Previous Message David Gagnon 2007-05-10 11:07:47 how to convert a string array to a string. fct array_to_string seem to work only for INT array??