Hi,
I am experimenting with EXCLUSIVE transactions today, and was confused
that after one connection began an EXCLUSIVE transaction, another one
could still execute a SELECT statement, because quoting from
https://www.sqlite.org/lang_transaction.html
"After a BEGIN EXCLUSIVE, no other database connection except for
read_uncommitted connections will be able to read the database and no
other connection without exception will be able to write the database
until the transaction is complete."
I do understand the concept of the different lock types and that a
SELECT statement does not implicitly start a transaction, but the quoted
paragraph does not make this clear in my mind, or am I reading it wrong?
Hearing your opinions on this is highly appreciated.
--
Carsten
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
