Re: [sqlite] The point of BEGIN DEFERRED

Nikolaus Rath wrote: > Now I am wondering: in which situation do I actually want to use BEGIN > DEFERRED? For a read-only transaction, of course. Igor Tandetnik ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailm

[sqlite] The point of BEGIN DEFERRED

Hello, If I understand the documentation right, the following SQL snippet can cause deadlocks when running multi-threaded, because both threads can acquire and hold the SHARED lock at the same time, but then no thread can get the EXCLUSIVE lock anymore (note that the SELECT and INSERT are meant to