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 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
