On 2/3/2014 2:04 PM, Simon Slavin wrote:
1) How does a transaction affect SELECTs? If I start a transaction and do
an UPDATE/DELETE/INSERT, what data will a SELECT in the same transaction
see?
You can change it ...
<http://www.sqlite.org/pragma.html#pragma_read_uncommitted>
A transaction always sees its own changes, no pragma necessary or possible.
pragma read_uncommitted only applies to multiple connections in the same
process, running in shared cache mode (
http://www.sqlite.org/sharedcache.html ).
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
