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

Re: Get current trasanction id

From: Joachim Zobel <jzobel(at)heute-morgen(dot)de>
To: Marek Lewczuk <newsy(at)lewczuk(dot)com>
Cc: Lista dyskusyjna pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Get current trasanction id
Date: 2004-12-28 15:05:53
Message-ID: 1104246353.22419.216.camel@localhost (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-sql
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 


In response to

Responses

pgsql-sql by date

Next:From: Marek LewczukDate: 2004-12-28 15:51:36
Subject: Re: Get current trasanction id
Previous:From: Dennis SacksDate: 2004-12-28 00:20:06
Subject: simulating global temp tables in plpgsql functions

pgsql-general by date

Next:From: Pierre-Frédéric CaillaudDate: 2004-12-28 15:09:59
Subject: Re: running a query file of 42MB
Previous:From: Vivek KheraDate: 2004-12-28 15:01:20
Subject: Re: Long-running performance (MVCC, Vacuum, etc.) - Any fix?

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