On 29 Mar 2011, at 10:48am, Boris Kolpackov wrote: > If I add IMMEDIATE (or EXCLUSIVE) to the first transaction > (three INSERTs), nothing changes, [snip] > > If I add IMMEDIATE to the second transaction (SELECT then UPDATE), then > the deadlocks go away for both transaction as one would expect.
In your testing, did you test adding IMMEDIATE to /both/ transactions ? Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
