Did I miss Sqlite getting nested transactions? I thought it only had one transaction, in which you can have multiple savepoints, which are kind of sort of like nested transactions, but they use SAVEPOINT and not BEGIN. Doesn't an abort rollback the full transaction?
David --- On Wed, 6/23/10, Simon Slavin <slav...@bigfraud.org> wrote: > From: Simon Slavin <slav...@bigfraud.org> > Subject: Re: [sqlite] marking transaction boundaries > To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> > Date: Wednesday, June 23, 2010, 1:02 PM > > On 23 Jun 2010, at 5:56pm, b s wrote: > > > I get the point that transactions can be nested and i > am assuming > > the begin transaction trigger only happens at the > outer most transaction. > > It still is the logical envelope which will be rolled > back on a default abort. > > (yes, i know one can back off to a save point). > > No. An abort will not roll back to the outmost > transaction. Generally it rolls back the innermost > transaction. And if there was a trigger when a > transaction began, it would be triggered as each nested > transaction began. Though you could probalby somehow > run a counter yourself which could figure out whether the > BEGIN was for an outmost transaction. > > Simon. > _______________________________________________ > 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
