Re: nested transactions - Mailing list pgsql-hackers

From snpe
Subject Re: nested transactions
Date
Msg-id 200211221747.29492.snpe@snpe.co.yu
Whole thread Raw
In response to Re: nested transactions  (Scott Lamb <slamb@slamb.org>)
List pgsql-hackers
On Friday 22 November 2002 04:36 pm, Scott Lamb wrote:
> Bruce Momjian wrote:
> > I am going to work on nested transactions for 7.4.
>
> If you're going to do a lot of reworking of how transactions are
> handled, maybe this is a good time to beg for cursors that stay open
> across commits. It looks like the JDBC driver is moving to using cursors
> with ResultSet.CLOSE_CURSORS_AT_COMMIT, for the advantage of not having
> to fetch the entire result immediately and hold it in memory. If this
> were implemented, the same could be done for
> ResultSet.HOLD_CURSORS_OVER_COMMIT, which I think a lot of JDBC code needs.
>

I agree.It is my favorite features - and if you set savepoint I think that stay first solution
(begin; ... ; begin; ...; begin; ...;comit; ...;commit;...; commit;

Thanks 
Haris Peco


pgsql-hackers by date:

Previous
From: Scott Lamb
Date:
Subject: Re: nested transactions
Next
From: Joe Conway
Date:
Subject: quote_ident and schemas (was Re: connectby with schema)