On Jan 29, 2009, at 3:13 AM, Chris Eich wrote: > I have read http://sqlite.org/atomiccommit.html which seems to imply > that > all db files in a transaction are locked at the same level as the > transaction progresses (i.e. all Reserved, then all Exclusive, ...). > This > makes sense when all the files are being changed, but I have a use > case > where I am only modifying one of the attached databases and would > like to > leave the main database unlocked.
That should happen automatically. You can use "PRAGMA lock_status" to query the locks held on each file at any time. Dan. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
