"B V, Phanisekhar" <[EMAIL PROTECTED]> wrote: > > A database is in the EXCLUSIVE state if one of the processes has an > > EXCLUSIVE lock. Only *one* process at a time can hold an EX- CLUSIVE > > lock. The process holding the EXCLUSIVE lock is currently writing to > > the database file. Every other process must hold *no* lock. No other > > > process can acquire a lock of any kind. > > Does this apply to hot journal? > > http://www.sqlite.org/lockingv3.html > In the above link the following is mentioned as the last step in dealing > with hot journals. > Drop the EXCLUSIVE and PENDING locks but retain the SHARED lock. > > Does the above sentence means it can hold EXCLUSIVE, PENDING and SHARED > lock together? >
If you are implementing your own private locking mechanism, you can do it either way. It makes no difference for the final outcome. -- D. Richard Hipp <[EMAIL PROTECTED]> ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------