On Sep 25, 2008, at 7:06 PM, Jeffrey Rennie (レニー) <[EMAIL PROTECTED]> wrote:
> I noticed this bug fix in 3.5.7: > - Store the statement journal in the temporary file directory > instead of > colocated with the database file. > > This seems fraught. Aren't temporary directories routinely purged? > If you > get unlucky and the temp directory is purged immediately after you > reboot, > then your DB will be corrupt. > You are confusing the statement journal with the rollback journal. The statement journal has nothing to do with database recovery - that is the task of the rollback journal. So the statement journal can be deleted at will without damaging the database. And, in fact, the statement journal is opened with delete-on-close. D. Richard Hipp [EMAIL PROTECTED] _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users