Re: [GENERAL] Invoke trigger after commit

2007-05-10 Thread Sim Zacks
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

Re: [GENERAL] Invoke trigger after commit

2007-05-10 Thread Alexander Staubo
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