Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group