Tom Lane wrote:
BTW, I've been more or less ignoring the nearby debate about whether cursors ought to roll back at subxact abort or not, because right now I don't know how to implement *either* behavior. Unless we have credible theories about how to implement both, it's a bit useless to debate which is better.
If/when you have a choice -- the JDBC driver code gets easier if you don't roll back at abort. If rollback of cursor state can happen, then the driver will need to preserve client-side state associated with each cursor (i.e. the driver's idea of its position) at the start of each subtransaction so it can restore it on rollback -- or always use FETCH ABSOLUTE (which I think needs SCROLL cursors?)
-O
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
