Use a Listen/Notify daemon application and put the Notify on the last line of
the transaction.
If it does the notify that means that the transaction was completed
successfully.
Sim
Jan Strube wrote:
Hi,
is there a way to invoke a trigger only if the current transaction is
committed?
The pro
On 5/10/07, Jan Strube <[EMAIL PROTECTED]> 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 n