X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id F02D53AC062 for ; Tue, 28 Dec 2004 15:06:09 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 78706-03 for ; Tue, 28 Dec 2004 15:05:57 +0000 (GMT) Received: from mail.heute-morgen.de (mail.heute-morgen.de [83.151.18.208]) by svr1.postgresql.org (Postfix) with ESMTP id C48BE3AC353 for ; Tue, 28 Dec 2004 15:05:58 +0000 (GMT) Received: from p54875550.dip.t-dialin.net ([84.135.85.80] helo=dilbert.crrrwg.de ident=mail) by mail.heute-morgen.de with asmtp (Cipher TLSv1:EDH-RSA-DES-CBC3-SHA:168) (Exim 3.35 #1 (Debian)) id 1CjIv1-0001Ba-00; Tue, 28 Dec 2004 16:05:51 +0100 Received: from asus.crrrwg.de ([192.168.201.92] ident=jo) by dilbert.crrrwg.de with esmtp (Exim 3.35 #1 (Debian)) id 1CjIv2-000454-00; Tue, 28 Dec 2004 16:05:52 +0100 Subject: Re: Get current trasanction id From: Joachim Zobel Reply-To: jzobel@heute-morgen.de To: Marek Lewczuk Cc: Lista dyskusyjna pgsql-general In-Reply-To: <41D06889.9040503@lewczuk.com> References: <41CFCD69.6010503@lewczuk.com> <20041227145406.GA73681@winnie.fuhr.org> <41D06889.9040503@lewczuk.com> Content-Type: text/plain; charset=iso-8859-2 Organization: Heute Morgen Message-Id: <1104246353.22419.216.camel@localhost> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 Date: Tue, 28 Dec 2004 16:05:53 +0100 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.05 tagged_above=0 required=5 tests=FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200412/1232 X-Sequence-Number: 70844 Am Mo, den 27.12.2004 schrieb Marek Lewczuk um 20:54: > Michael Fuhr napisa=B3(a): > > Why do you want the transaction ID? What problem are you trying > > to solve? > >=20 > I've already solved the problem - I found somewhere on the web a very=20 > simple C function, which returns transaction id. I need transaction id=20 > for plperl functions setVar, getVar (using $_SHARED array). Functions=20 > can write/read variables which are available either for connection or=20 > 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 -- =20 "... ein Geschlecht erfinderischer Zwerge, die fuer alles gemietet werden=20 koennen." - Bertolt Brecht - Leben des Galilei=20