Re: Two features left

Jean-Luc Lachance wrote:
> Bruce,
>
> I assume one will be able to ABORT the current transaction without
> aborting the higher transaction and ABORT ALL to abort all if needed.

Right. I hadn't planned on ABORT ALL, but it could be done to abort the
entire transaction. Is there any standard on that?

>
> What syntax will be available to the upper transaction to detect a lower
> ABORT?
> While there be something ? la Java ( try catch)?

My initial implementation will be simple:

BEGIN;
SELECT ...
BEGIN;
UPDATE ...
ABORT;
DELETE ...
COMMIT;

and later savepoints which allow you to abort back to a saved spot in your
transaction.

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