On 7/2/2014 3:04 AM, Clemens Ladisch wrote:
If all else fails, one could try and simulate BEGIN IMMEDIATE by running
a dummy modifying statement right after BEGIN - e.g.
delete from table1 where 0;
Would this be atomic?
It would be part of the same transaction, wouldn't it? The idea is to
make the first statement a writer, so the transaction acquires write
locks from the start.
However, I have no reason to believe, other than your word, that BEGIN
IMMEDIATE would not just work in this case. What makes you think it
wouldn't?
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users