logo       

Re: Database is locked error on 2nd conn: msg#00040

python.db.pysqlite.user

Subject: Re: Database is locked error on 2nd conn

Gerhard Häring wrote:
>
> David Pratt wrote:
>> [...] In posgres and psycopg I am using an isolation level of
>> serializable. What is equivalent for SQLite? I have not specified an
>> isolation on my connection, does this mean an isolation level of
>> none?
>
> pysqlite's default setting for isolation level is "DEFERRED". I
> can't say
> how it compares to PostgreSQL's isolation levels, but I think that
> they
> work differently.

A ha, so with regard to the isolation_level parameter, "DEFERRED" is
the same as "" (empty string)? The latter is the initial value.


<Prev in Thread] Current Thread [Next in Thread>
Google Custom Search

News | FAQ | advertise