pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedGet current trasanction id
7+ messages / 5 participants
[nested] [flat]
* Get current trasanction id
@ 2004-12-27 08:52 Marek Lewczuk <newsy@lewczuk.com>
2004-12-27 10:38 ` Re: [SQL] Get current trasanction id Achilleus Mantzios <achill@matrix.gatewaynet.com>
2004-12-27 12:07 ` Re: Get current trasanction id Martijn van Oosterhout <kleptog@svana.org>
2004-12-27 14:54 ` Re: Get current trasanction id Michael Fuhr <mike@fuhr.org>
0 siblings, 3 replies; 7+ messages in thread
From: Marek Lewczuk @ 2004-12-27 08:52 UTC (permalink / raw)
To: Lista dyskusyjna pgsql-general <pgsql-general@postgresql.org>; pgsql-sql
Hello,
is there any way to get current transaction id using plpgsql or sql ?
Thanks in advance for any help.
ML
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: [SQL] Get current trasanction id
2004-12-27 08:52 Get current trasanction id Marek Lewczuk <newsy@lewczuk.com>
@ 2004-12-27 10:38 ` Achilleus Mantzios <achill@matrix.gatewaynet.com>
2 siblings, 0 replies; 7+ messages in thread
From: Achilleus Mantzios @ 2004-12-27 10:38 UTC (permalink / raw)
To: Marek Lewczuk <newsy@lewczuk.com>; +Cc: Lista dyskusyjna pgsql-general <pgsql-general@postgresql.org>; pgsql-sql
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
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Get current trasanction id
2004-12-27 08:52 Get current trasanction id Marek Lewczuk <newsy@lewczuk.com>
@ 2004-12-27 12:07 ` Martijn van Oosterhout <kleptog@svana.org>
2 siblings, 0 replies; 7+ messages in thread
From: Martijn van Oosterhout @ 2004-12-27 12:07 UTC (permalink / raw)
To: Marek Lewczuk <newsy@lewczuk.com>; +Cc: Lista dyskusyjna pgsql-general <pgsql-general@postgresql.org>; pgsql-sql
I'm sure there's many tricky ways, but one simple way would be to
insert a row into a table and then grab its XMIN value...
Hope this helps,
On Mon, Dec 27, 2004 at 09:52:57AM +0100, Marek Lewczuk wrote:
> Hello,
> is there any way to get current transaction id using plpgsql or sql ?
>
> Thanks in advance for any help.
>
> ML
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Get current trasanction id
2004-12-27 08:52 Get current trasanction id Marek Lewczuk <newsy@lewczuk.com>
@ 2004-12-27 14:54 ` Michael Fuhr <mike@fuhr.org>
2004-12-27 19:54 ` Re: Get current trasanction id Marek Lewczuk <newsy@lewczuk.com>
2 siblings, 1 reply; 7+ messages in thread
From: Michael Fuhr @ 2004-12-27 14:54 UTC (permalink / raw)
To: Marek Lewczuk <newsy@lewczuk.com>; +Cc: Lista dyskusyjna pgsql-general <pgsql-general@postgresql.org>; pgsql-sql
On Mon, Dec 27, 2004 at 09:52:57AM +0100, Marek Lewczuk wrote:
> is there any way to get current transaction id using plpgsql or sql ?
A couple of people have posted suggestions but I'll ask a question:
Why do you want the transaction ID? What problem are you trying
to solve?
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Get current trasanction id
2004-12-27 08:52 Get current trasanction id Marek Lewczuk <newsy@lewczuk.com>
2004-12-27 14:54 ` Re: Get current trasanction id Michael Fuhr <mike@fuhr.org>
@ 2004-12-27 19:54 ` Marek Lewczuk <newsy@lewczuk.com>
2004-12-28 15:05 ` Re: Get current trasanction id Joachim Zobel <jzobel@heute-morgen.de>
0 siblings, 1 reply; 7+ messages in thread
From: Marek Lewczuk @ 2004-12-27 19:54 UTC (permalink / raw)
To: Michael Fuhr <mike@fuhr.org>; +Cc: Lista dyskusyjna pgsql-general <pgsql-general@postgresql.org>; pgsql-sql
Michael Fuhr napisał(a):
> On Mon, Dec 27, 2004 at 09:52:57AM +0100, Marek Lewczuk wrote:
>
>
>>is there any way to get current transaction id using plpgsql or sql ?
>
>
> A couple of people have posted suggestions but I'll ask a question:
>
> Why do you want the transaction ID? What problem are you trying
> to solve?
>
Michael,
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.
Regards,
ML
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Get current trasanction id
2004-12-27 08:52 Get current trasanction id Marek Lewczuk <newsy@lewczuk.com>
2004-12-27 14:54 ` Re: Get current trasanction id Michael Fuhr <mike@fuhr.org>
2004-12-27 19:54 ` Re: Get current trasanction id Marek Lewczuk <newsy@lewczuk.com>
@ 2004-12-28 15:05 ` Joachim Zobel <jzobel@heute-morgen.de>
2004-12-28 15:51 ` Re: Get current trasanction id Marek Lewczuk <newsy@lewczuk.com>
0 siblings, 1 reply; 7+ messages in thread
From: Joachim Zobel @ 2004-12-28 15:05 UTC (permalink / raw)
To: Marek Lewczuk <newsy@lewczuk.com>; +Cc: Lista dyskusyjna pgsql-general <pgsql-general@postgresql.org>
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
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Get current trasanction id
2004-12-27 08:52 Get current trasanction id Marek Lewczuk <newsy@lewczuk.com>
2004-12-27 14:54 ` Re: Get current trasanction id Michael Fuhr <mike@fuhr.org>
2004-12-27 19:54 ` Re: Get current trasanction id Marek Lewczuk <newsy@lewczuk.com>
2004-12-28 15:05 ` Re: Get current trasanction id Joachim Zobel <jzobel@heute-morgen.de>
@ 2004-12-28 15:51 ` Marek Lewczuk <newsy@lewczuk.com>
0 siblings, 0 replies; 7+ messages in thread
From: Marek Lewczuk @ 2004-12-28 15:51 UTC (permalink / raw)
To: jzobel@heute-morgen.de; +Cc: Lista dyskusyjna pgsql-general <pgsql-general@postgresql.org>
Joachim Zobel napisał(a):
> 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.
As I wrote before you can have it in plpgsql - you just need to install
special c function as e.g getCurrentTransactionId() and you will be able
to get id from within plpgsql - but I agree that this function should be
in base SQL functions or at least in contrib modules.
C function is very simple:
getcurrenttransactionid.c:
#include "postgres.h"
#include "access/xact.h"
Datum getcurrenttransactionid(PG_FUNCTION_ARGS)
{
TransactionId xid = GetCurrentTransactionId();
PG_RETURN_INT32((int32) xid);
}
getcurrenttransactionid.sql:
SET search_path = public;
CREATE FUNCTION getCurrentTransactionId()
RETURNS integer
AS 'MODULE_PATHNAME'
LANGUAGE 'c';
Regards,
Marek Lewczuk
^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2004-12-28 15:51 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-12-27 08:52 Get current trasanction id Marek Lewczuk <newsy@lewczuk.com>
2004-12-27 10:38 ` Achilleus Mantzios <achill@matrix.gatewaynet.com>
2004-12-27 12:07 ` Martijn van Oosterhout <kleptog@svana.org>
2004-12-27 14:54 ` Michael Fuhr <mike@fuhr.org>
2004-12-27 19:54 ` Marek Lewczuk <newsy@lewczuk.com>
2004-12-28 15:05 ` Joachim Zobel <jzobel@heute-morgen.de>
2004-12-28 15:51 ` Marek Lewczuk <newsy@lewczuk.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox