Re: [sqlite] ROLLBACK TO savepoint cancels earlier RELEASEs

2012-05-10 Thread ext-Esko.Hujanen
>On 9 May 2012, at 10:33am, 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 depends on whe

Re: [sqlite] ROLLBACK TO savepoint cancels earlier RELEASEs

2012-05-09 Thread Simon Slavin
On 9 May 2012, at 10:33am, 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 depends on whether there's a

Re: [sqlite] ROLLBACK TO savepoint cancels earlier RELEASEs

2012-05-09 Thread Richard Hipp
On Wed, May 9, 2012 at 5:33 AM, 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. > I did thi

Re: [sqlite] ROLLBACK TO savepoint cancels earlier RELEASEs

2012-05-09 Thread Simon Davies
On 9 May 2012 10:33, 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 wrong ? > > br, > > E

[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 ---