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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
