Re: [sqlite] Isolation level of deferred transactions

2005-09-17 Thread D. Richard Hipp
On Sun, 2005-09-18 at 01:03 +0400, Alexander J. Kozlovsky wrote: > Hence, SQLite deferred transactions is not serializable ones. > Your understanding is incorrect. SQLite does *not* release locks in the middle of a transaction - ever. It is always serializable. -- D. Richard Hipp <[EMAIL

Re: [sqlite] Isolation level of deferred transactions

2005-09-17 Thread Alexander J. Kozlovsky
Yes, I understand now. Thanks for explanation! Best regards, Alexander mailto:[EMAIL PROTECTED]

Re: [sqlite] Isolation level of deferred transactions

2005-09-17 Thread Alexander J. Kozlovsky
> SQLite transactions are always serializable. Serializable mode requires two-phase locking protocol. In practice it means all locks (for read and for write) hold until transaction end. Deferred transaction drop SHARED lock in middle of transaction and replace it with