Re: [sqlite] Locking in 3.0.5

[Wei Chin]

Darrell and everyone,

As I try this with SQLITE 3.0.4, I get "database is locked" error at 
step 4.

Are you not getting the lock out error?

Wei


[EMAIL PROTECTED] wrote on 9/1/2004, 10:04 AM:

 > Time    Process 1                                     Process 2
 > ---------------------------------------------------------------
 > 1      INSERT INTO t1
 >           VALUES (1, 'one');
 >
 > 2      INSERT INTO t2
 >           VALUES ('hello', 'world');
 >
 > 3                                                    BEGIN;
 >                                                       SELECT * FROM t2;
 >
 > 4      INSERT INTO t1
 >           VALUES (2, 'two');
 >
 > 5                                                    SELECT * FROM t1;
 >                                                       END TRANSACTION;