Transaction ID in Triggers

From: David Saracini <dsaracini(at)yahoo(dot)com>
To: pgsql novice forum <pgsql-novice(at)postgresql(dot)org>
Subject: Transaction ID in Triggers
Date: 2009-08-14 19:39:41
Message-ID: 472930.60457.qm@web180316.mail.gq1.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hello All,

Is there a way to find out the current transaction id from within a Trigger? I'm interested in implementing a better audit trail mechanism and this would help me greatly.

Thanks in advance!

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2009-08-14 20:08:16 Re: Transaction ID in Triggers
Previous Message Michael Swierczek 2009-08-14 12:53:31 Re: Having trouble installing on Vista