I had a case where attempts to access a table in a user's db gave "no such table", where 60 mins previously (according to the log) querying that table gave no problems. About a day and a half later the user's machine had what he described as a "bad crash", so I'm suspecting he has a failing disk. Due to a separate coincidence, this meant the app could not restart.
Now, I want to protect against this or give better warning, and I am wondering whether corruption looking like a missing table would be caught by the integrity_check pragma. -- Cheers -- Tim
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users