Re: Retrieve the postgres transaction id - Mailing list pgsql-jdbc

From Oliver Jowett
Subject Re: Retrieve the postgres transaction id
Date
Msg-id 40A1643A.3010308@opencloud.com
Whole thread Raw
In response to Re: Retrieve the postgres transaction id  (Cédric Coulon <cedric.coulon@lina.univ-nantes.fr>)
Responses Re: Retrieve the postgres transaction id
Re: Retrieve the postgres transaction id
List 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

pgsql-jdbc by date:

Previous
From: Dave Cramer
Date:
Subject: Re: JDBC and processing large numbers of rows
Next
From: "David Wall"
Date:
Subject: Re: JDBC and processing large numbers of rows