On Jan 2, 2009, at 3:50 AM, Marco Bambini wrote: > Is there any documentation available about savepoints?
Not yet, but there will be soon, and definitely before the release. Meanwhile, you can use the SAVEPOINT documentation from PostgreSQL. SAVEPOINTs in SQLite should work exactly the same way. > > > -- > Marco Bambini > http://www.sqlabs.net > http://www.sqlabs.net/blog/ > http://www.sqlabs.net/realsqlserver/ > > > > > On Jan 2, 2009, at 2:19 AM, D. Richard Hipp wrote: > >> >> On Jan 1, 2009, at 7:25 PM, Igor Tandetnik wrote: >> >>> "Webb Sprague" <webb.spra...@gmail.com> >>> wrote in message >>> news:b11ea23c0901011622i23f7b583wd05f07104dd06...@mail.gmail.com >>>> I have a script containing the following, which works fine except >>>> that >>>> at the end of the script I get "SQL error near line 5: cannot >>>> commit - >>>> no transaction is active". The table specified in the file on >>>> line 2 >>>> gets created just fine, and populated just fine on line 4. I am >>>> using >>>> sqlite 3.6.7, custom built with new column limits and variable >>>> limits. >>> >>> I suspect .import directive invokes BEGIN and COMMIT internally. >>> SQLite >>> transactions don't nest. >> >> >> FWIW, nested transactions (in the form of SAVEPOINTs) will appear in >> the next SQLite release, which we hope to get out by mid-January. >> The >> SAVEPOINT code is already in CVS and is working well for all of our >> tests so far, in case anyone would like to take it out for a test >> drive. >> >> D. Richard Hipp >> d...@hwaci.com >> >> >> >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users D. Richard Hipp d...@hwaci.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
