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 BC9193F8E9F; Mon, 27 Dec 2004 10:04:43 +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 36620-04; Mon, 27 Dec 2004 10:04:38 +0000 (GMT) Received: from matrix.gatewaynet.com (matrix.gatewaynet.com [217.19.69.50]) by svr1.postgresql.org (Postfix) with ESMTP id F2CFF3F8E7B; Mon, 27 Dec 2004 10:04:37 +0000 (GMT) Received: from matrix.gatewaynet.com (localhost.localdomain [127.0.0.1]) by matrix.gatewaynet.com (8.12.8/8.12.8) with ESMTP id iBRAcYT5003264; Mon, 27 Dec 2004 12:38:34 +0200 Received: from localhost (achill@localhost) by matrix.gatewaynet.com (8.12.8/8.12.8/Submit) with ESMTP id iBRAcXsk003260; Mon, 27 Dec 2004 12:38:34 +0200 Date: Mon, 27 Dec 2004 12:38:33 +0200 (EET) From: Achilleus Mantzios To: Marek Lewczuk Cc: Lista dyskusyjna pgsql-general , Lista dyskusyjna pgsql-sql Subject: Re: [SQL] Get current trasanction id In-Reply-To: <41CFCD69.6010503@lewczuk.com> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=ISO-8859-7 Content-Transfer-Encoding: 8BIT X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200412/1209 X-Sequence-Number: 70821 O Marek Lewczuk έγραψε στις Dec 27, 2004 : > Hello, > is there any way to get current transaction id using plpgsql or sql ? Maybe write a C function which calls GetCurrentTransactionId(). > > Thanks in advance for any help. > > ML > > > > ---------------------------(end of broadcast)--------------------------- > TIP 8: explain analyze is your friend > -- -Achilleus