Re: [sqlite] Table is locked error
On Apr 1, 2010, at 2:39 PM, Radovan Antloga wrote: > I did not find any info about my situation in page > http://www.sqlite.org/lockingv3.html > > I would just like a confirmation if this is expected > behaviour. > > I have locking mode = normal. Steps are: > > 1. open database > 2. open statement (simple select from T1) >and doing 1 step > 3. execute statement (drop table T2) > > I get SQLite error 6 database table is locked. > > So while statements are in progress it is not possible > to drop any tables. That is correct. It is not possible to do a DROP TABLE if the database handle has any active statements (apart from the "DROP TABLE" statement itself of course). ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Table is locked error
I did not find any info about my situation in page http://www.sqlite.org/lockingv3.html I would just like a confirmation if this is expected behaviour. I have locking mode = normal. Steps are: 1. open database 2. open statement (simple select from T1) and doing 1 step 3. execute statement (drop table T2) I get SQLite error 6 database table is locked. So while statements are in progress it is not possible to drop any tables. Best Regards Radovan Antloga __ Informacija od ESET NOD32 Antivirus, zbirka virusnih definicij 4990 (20100401) __ To sporočilo je preveril ESET NOD32 Antivirus. http://www.eset.si ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users