Igor Tandetnik wrote: > Yang Zhang <yanghates...@gmail.com> wrote: >> Pavel Ivanov wrote: >>> BTW, ACID that you mentioned has nothing to do with snapshot >>> isolation that you want to achieve. AFAIK only Oracle supports this >>> kind of statement isolation level. >> Actually, Oracle, Postgresql, SQL Server, Firebird, and others support >> snapshot isolation. http://en.wikipedia.org/wiki/Snapshot_isolation > > ... but not between two statements running within _the same > transaction_. Isolation level (snapshot or otherwise) describes how two > transactions are isolated from each other. In your example, you only > have one transaction, so any discussion of isolation levels is moot.
Right, I mean the whole reason why I originally wrote to this list was because I was under the (incorrect) impression that I was working with two separate transactions. -- Yang Zhang http://www.mit.edu/~y_z/ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users