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 <[email protected]> wrote: > From: D. Richard Hipp <[email protected]> > Subject: Re: [sqlite] Transaction within script > To: "General Discussion of SQLite Database" <[email protected]> > 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 > [email protected] > > > > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
