Skip site navigation (1) Skip section navigation (2)

Re: Retrieve the postgres transaction id

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: Cédric Coulon <cedric(dot)coulon(at)lina(dot)univ-nantes(dot)fr>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Retrieve the postgres transaction id
Date: 2004-05-11 23:39:38
Message-ID: 40A1643A.3010308@opencloud.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
Cédric Coulon wrote:
> Thx for yours helps.
> But Isn't there a possibility that a backend has more than one 
> transaction with locks?

As I understand it, no. There is exactly one connection per backend, and 
one transaction per connection, and there is no way to change the 
transaction associated with a connection without committing/aborting the 
existing transaction.

-O

In response to

Responses

pgsql-jdbc by date

Next:From: David WallDate: 2004-05-12 00:14:29
Subject: Re: JDBC and processing large numbers of rows
Previous:From: Dave CramerDate: 2004-05-11 22:51:08
Subject: Re: JDBC and processing large numbers of rows

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group