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