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@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