Re: Savepoints

On Sep 29, 2009, at 12:34 PM, David E. Wheeler wrote:

> Compared to transactions, the statements look like this:
>
>  TRANSACTIONS  | SAVEPOINTS
> -------------------------------------
>  BEGIN;        | SAVEPOINT :name;
>  COMMIT;       | RELEASE :name;
>  ROLLBACK;     | ROLLBACK TO :name;

Apologies, I made a mistake. It should actually be:

  TRANSACTIONS  | SAVEPOINTS
-------------------------------------
  BEGIN;        | SAVEPOINT :name;
  COMMIT;       | RELEASE SAVEPOINT :name;
  ROLLBACK;     | ROLLBACK TO SAVEPOINT :name;

I still think that methods named savepoint(), release(), and  
rollback_to() are ideal, but I could also see an argument that the  
latter two be named release_savepoint() and rollback_to_savepoint(),  
though they're a bit long.

Best,

David