Re: Get current trasanction id - Mailing list pgsql-general

From Joachim Zobel
Subject Re: Get current trasanction id
Date
Msg-id 1104246353.22419.216.camel@localhost
Whole thread Raw
In response to Re: Get current trasanction id  (Marek Lewczuk <newsy@lewczuk.com>)
Responses Re: Get current trasanction id
List pgsql-general
Am Mo, den 27.12.2004 schrieb Marek Lewczuk um 20:54:
> Michael Fuhr napisał(a):
> > Why do you want the transaction ID?  What problem are you trying
> > to solve?
> >
> I've already solved the problem - I found somewhere on the web a very
> simple C function, which returns transaction id. I need transaction id
> for plperl functions setVar, getVar (using $_SHARED array). Functions
> can write/read variables which are available either for connection or
> transaction.

It would be nice to have that in pgplsql. I once needed a transaction Id
in oracle for a historisation trigger. It saves before copies of the
modified records on a per transaction basis.

Sincerely,
Joachim

--

"... ein Geschlecht erfinderischer Zwerge, die fuer alles gemietet werden
koennen."                            - Bertolt Brecht - Leben des Galilei


pgsql-general by date:

Previous
From: Vivek Khera
Date:
Subject: Re: Long-running performance (MVCC, Vacuum, etc.) - Any fix?
Next
From: Pierre-Frédéric Caillaud
Date:
Subject: Re: running a query file of 42MB