Getting current transaction id

From: Nicolai Petri <lists(at)petri(dot)cc>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Getting current transaction id
Date: 2006-07-24 17:06:23
Message-ID: 200607241906.24189.lists@petri.cc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello all

I'm in the need for my custom written replication engine to obtain the current
transaction id from a trigger function. As far as I'm told it's not possible
today. Would people object much if this functionality was added for 8.2 ?
It's the last piece of postgresql C code I have left in my application and I
think it would be a nice information in general to have available for users.
If not for anything else then for simple statistics.

I attached the function I use with great success today.

Best regards,
Nicolai Petri

-------------------------
PG_FUNCTION_INFO_V1(get_transaction_id);

Datum get_transaction_id(PG_FUNCTION_ARGS) {
TransactionId curxact;

curxact=GetTopTransactionId();
return Int32GetDatum(curxact);
}
------------------------

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Joshua D. Drake 2006-07-24 17:08:40 Re: plPHP and plRuby
Previous Message Andrew Dunstan 2006-07-24 17:02:03 Re: Adding a pgbench run to buildfarm