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