Savepoints are not the same as an autonomous transaction. Could that be what he really means by "nested transactions"?
Thanks for implementing savepoints they are a welcome addition to SQLITE ! --- On Fri, 1/2/09, D. Richard Hipp <d...@hwaci.com> wrote: > From: D. Richard Hipp <d...@hwaci.com> > Subject: Re: [sqlite] Transaction within script > To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> > Date: Friday, January 2, 2009, 9:39 AM > On Jan 2, 2009, at 10:37 AM, Sherief N. Farouk wrote: > > >> SAVEPOINTs is the way PostgreSQL and MySQL do it, > as well as many > >> other SQL database engines. We want to maximize > compatibility. > >> > >> We have discussed letting you used named > transactions using BEGIN. > >> We > >> might add that in the future. But for now, > SAVEPOINT seems to be the > >> safest way to do things - and the least likely to > cause compatibility > >> problems. > >> > > > > Makes perfect sense. I'm still hoping for nested > transactions > > sometime soon, > > hope the savepoint code makes it easier ;) > > > > SAVEPOINTs are nested transactions. > > 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
