Re: Get current trasanction id - Mailing 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