Re: [sqlite] ROLLBACK TO savepoint cancels earlier RELEASEs

2012-05-10 Thread ext-Esko.Hujanen
On 9 May 2012, at 10:33am, ext-esko.huja...@elektrobit.com wrote: 1: SAVEPOINT 1 2: insert A 3: RELEASE SAVEPOINT 1 4: SAVEPOINT 2 5: insert B 6: ROLLBACK TO SAVEPOINT 2 ROLLBACK in line 6 cancels also line 2 in addition to line 5. I want to cancel just line 5. What it does

[sqlite] ROLLBACK TO savepoint cancels earlier RELEASEs

2012-05-09 Thread ext-Esko.Hujanen
Hi All, 1: SAVEPOINT 1 2: insert A 3: RELEASE SAVEPOINT 1 4: SAVEPOINT 2 5: insert B 6: ROLLBACK TO SAVEPOINT 2 ROLLBACK in line 6 cancels also line 2 in addition to line 5. I want to cancel just line 5. What am I doing wrong ? br, Esko

Re: [sqlite] ROLLBACK TO savepoint cancels earlier RELEASEs

2012-05-09 Thread Simon Davies
On 9 May 2012 10:33, ext-esko.huja...@elektrobit.com wrote: Hi All, 1: SAVEPOINT 1 2: insert A 3: RELEASE SAVEPOINT 1 4: SAVEPOINT 2 5: insert B 6: ROLLBACK TO SAVEPOINT 2 ROLLBACK in line 6 cancels also line 2 in addition to line 5. I want to cancel just line 5. What am I doing

Re: [sqlite] ROLLBACK TO savepoint cancels earlier RELEASEs

2012-05-09 Thread Richard Hipp
On Wed, May 9, 2012 at 5:33 AM, ext-esko.huja...@elektrobit.com wrote: Hi All, 1: SAVEPOINT 1 2: insert A 3: RELEASE SAVEPOINT 1 4: SAVEPOINT 2 5: insert B 6: ROLLBACK TO SAVEPOINT 2 ROLLBACK in line 6 cancels also line 2 in addition to line 5. I want to cancel just line 5.

Re: [sqlite] ROLLBACK TO savepoint cancels earlier RELEASEs

2012-05-09 Thread Simon Slavin
On 9 May 2012, at 10:33am, ext-esko.huja...@elektrobit.com wrote: 1: SAVEPOINT 1 2: insert A 3: RELEASE SAVEPOINT 1 4: SAVEPOINT 2 5: insert B 6: ROLLBACK TO SAVEPOINT 2 ROLLBACK in line 6 cancels also line 2 in addition to line 5. I want to cancel just line 5. What it does