Re: [sqlite] Is it safe to read or write a table while being indexed?

[Tito Ciuro]

On 16/04/2006, at 3:52, [EMAIL PROTECTED] wrote:

Tito Ciuro <[EMAIL PROTECTED]> wrote:

- Does SQLite acquire an EXCLUSIVE lock when indexing?

Yes

- If I'm not mistaken, an EXCLUSIVE lock does not stop other readers
from accessing the database.

You are mistaken.  An EXCLUSIVE lock means that only the connection
holding the lock is able to access the file.

Thanks for the clarification.

Regards,

-- Tito