On 7/1/2014 4:55 PM, Clemens Ladisch wrote:
To prevent deadlocks, transactions that will modify the database should be started with BEGIN IMMEDIATE. (This kind of lock is not available in shared cache mode.)
Are you sure? Nothing in the documentation appears to suggest that. But I must admit I haven't tried it myself.
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; -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
