Re: Unique transaction ID - Mailing list pgsql-general

From Jaime Casanova
Subject Re: Unique transaction ID
Date
Msg-id c2d9e70e0601040736g19e8a51i6be9255ad6ab8edd@mail.gmail.com
Whole thread Raw
In response to Unique transaction ID  (Robert Osowiecki <robson@cavern.pl>)
Responses Re: Unique transaction ID  (Robert Osowiecki <robson@cavern.pl>)
List pgsql-general
On 1/4/06, Robert Osowiecki <robson@cavern.pl> wrote:
> Apart from now() function, is there some kind of sequence that advances
> with each transaction started? If not: is it possible to implement that
> using sequences?
>
> Robson.
>
>

it exists a transaction id called XID, you can't get it via sql
though, you need to make a c function and invoke GetTopTransactionId()
(or GetCurrentTransactionId() in versions prior to 8.0)

--
regards,
Jaime Casanova
(DBA: DataBase Aniquilator ;)

pgsql-general by date:

Previous
From: hubert depesz lubaczewski
Date:
Subject: problem with partitioning and indexed order by
Next
From: Andrew - Supernews
Date:
Subject: Re: When it is better to use "timestamp without time zone"?