Kevin Brown wrote: > My question is: how do you see cursors working with nested > transactions? > > Right now you can't do cursors outside of transactions. > Subtransactions would complicate things a bit: > > BEGIN; > DECLARE CURSOR x ... > BEGIN > (is cursor x visible here? What are the implications of using it if > it is?) > ... > COMMIT; > ... > COMMIT; > > > Would we only allow cursors within the innermost transactions? If we > allow them anywhere else, why retain the requirement that they be used > within transactions at all?
I talked to Tom and he feels it will be too hard to rollback a subtransaction that affects cursors so we will disable use of cursors in subtransactions, at least in the first implementation. -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(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
