Postgres Pro
Downloads
Home   >   mailing lists

Re: Current transaction ID? - Mailing list pgsql-general

From Bruce Momjian
Subject Re: Current transaction ID?
Date
Msg-id 200506142341.j5ENfBc14189@candle.pha.pa.us
Whole thread Raw
In response to Current transaction ID?  ("Steve - DND" <postgres@digitalnothing.com>)
Responses Re: Current transaction ID?  ("Steve - DND" <postgres@digitalnothing.com>)
Re: Current transaction ID?  (Alvaro Herrera <alvherre@surnet.cl>)
List pgsql-general
Tree view 
Steve - DND wrote:
> Simple question I'm sure, but how can I get the transaction ID that a query
> is currently running in? I can find all kinds of documentation talking about
> transaction ids, but nothing about how to get the current one.

You can look at the xmin of a tuple you created or an xmax of a tuple
you deleted.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

pgsql-general by date:

Previous
From: "Steve - DND"
Date:
Subject: Current transaction ID?
Next
From: "Steve - DND"
Date:
Subject: Re: Current transaction ID?