well, if stmt1 is a write transaction, it would aquire an exclusive lock. if stmt2 is a read transaction, it would fail acquiring a shared lock since the exclusive lock is not released. . unless sqlite decides to 'downgrade' the exclusive lock to a 'shared' lock.
Sreekumar On Feb 6, 2012 7:07 PM, "Igor Tandetnik" <itandet...@mvps.org> wrote: > Sreekumar TP <sreekumar...@gmail.com> wrote: > > Why is this treated as a a single transaction? > > Well, because that's how SQLite works. Why shouldn't it be? > -- > Igor Tandetnik > > _______________________________________________ > 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
