Re: nested transactions

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
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073