Bruce Momjian wrote:
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 am going to work on nested transactions for 7.4.
Thanks,
Scott
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
