On Mon, 21 Jan 2019 at 07:21, Keith Medcalf <kmedc...@dessus.com> wrote:

> In DELETE or TRUNCATE (that is, all modes except WAL) a READ transaction
> in progress blocks a WRITE transaction and a WRITE transaction in progress
> blocks all other attempts to commence a transaction of any type on any
> other connection.
>

Nitpick: an active READ transaction blocks the COMMIT stage of a WRITE
transaction. An active WRITE transaction blocks all attempts to start
another WRITE transaction, and once it is ready to COMMIT blocks attempts
to start READ transactions.

-Rowan
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to