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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-jdbc by date

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