subject:"\[sqlite\] Savepoint Questions"

Re: [sqlite] Savepoint Questions

2016-05-27 Thread Richard Hipp

On 5/27/16, Paul Medynski wrote: > > begin transaction; > ... Work A ... > savepoint Foo; > ... Work B ... > savepoint Foo;<--- Allowed by #1 > ... Work C ... > rollback to savepoint Foo;<--- Rolls back Work C, but leaves the >

[sqlite] Savepoint Questions

2016-05-27 Thread Paul Medynski

Hello all, I have some questions and comments about savepoints, documented here: https://www.sqlite.org/lang_savepoint.html Here are some excerpts from that documentation that are relevant to my questions/comments: 1. "The SAVEPOINT command starts a new transaction with a name. The