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.
Thanks,
Scott