Re: Committing rolling back many objects at once?

[prev] [thread] [next] [Date index for 2005/01/21]

Perrin Harkins wrote:
> No, you can only rollback or commit everything you did on a certain
> database connection.

Some databases (even MySQL/InnoDB!) also support SQL SAVEPOINTS.

So you can mark multiple points through your transactions and then later
go back with ROLLBACK TO SAVEPOINT FOO;

They might not release any row-level locks / consistent read copies
held.

Of course, you should be highly suspicious of even normal ROLLBACK,
one of those features difficult to get right and seldom tested to the
levels that are required.  SAVEPOINTS will no doubt be even worse.  But
that's just the pessimist in me speaking :-).
        -- 
        Sam Vilain, sam /\T vilain |><>T net, PGP key ID: 0x05B52F13
(include my PGP key ID in personal replies to avoid spam filtering)