> "Rolling back" means that the database is modified so that it looks > exactly like it did before the start of the transaction. How is SQLite > suppose to modify a read-only file?
I suppose it's a matter of expectations. In my mind, a database is ALWAYS consistent. Therefore, if a hot journal exists, the 'consistent state' is post rollback. So, I'd expect the rollback to occur before becoming read-only. If nothing else, I'd expect the Open with READONLY to fail if a hot journal exists. Marc _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
