Robert Lehr <[EMAIL PROTECTED]> wrote: > RE: "Doctor, it hurts..." > > this seems to imply that the question does not warrant analysis. > that > is incorrect. such scenarios can occur. if I were to ask the > question, > I would have been seeking to understand how SQLite copes with it
You don't quote any context, but I'll guess you are talking about a situation where a) a process crashes in the middle of a transaction, and b) somehow the rollback journal file gets deleted. SQLite does not cope with this situation. The database is corrupted. SQLite may or may not be able to detect this corruption: if you are lucky, you'll get an error when opening the database; otherwise, it'll open successfully and you will work with inconsistent data. So, don't delete the journal file (except when also deleting the database file). Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
