Re: Retrieve the postgres transaction id

From: Dave Cramer <pg(at)fastcrypt(dot)com>
To: Oliver Jowett <oliver(at)opencloud(dot)com>
Cc: Cédric_Coulon <cedric(dot)coulon(at)lina(dot)univ-nantes(dot)fr>, "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: Retrieve the postgres transaction id
Date: 2004-05-12 02:33:30
Message-ID: 1084329210.1534.145.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

That won't be true soon, nested transactions are coming ...

Just a heads up.
Dave
On Tue, 2004-05-11 at 19:39, Oliver Jowett wrote:
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
>
>
> !DSPAM:40a167fc177361515062736!
>
>
--
Dave Cramer
519 939 0336
ICQ # 14675561

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message David Wall 2004-05-12 03:07:12 Re: JDBC and processing large numbers of rows
Previous Message Sean Shanny 2004-05-12 01:29:06 Re: JDBC and processing large numbers of rows