>The only consequence of losing -mjXXXX file is that in a multi-database >transaction (which can only be in rollback mode, not in WAL mode) if you >lose power and come back up without the -mjXXXX file, then the transaction >might commit to some of the database files, but not to others.
Are you only stating that an -mjXXXX file cannot support transaction rollback across WAL dbs in a recovery situation (e.g power failure), or are you also stating that cross database atomic behavior cannot be supported for WAL databases, period? Surely the ram db's connection (that attached the WAL db and begun the transaction) also 'transacts' (begin, cancel, commit) changes made to the WAL db on that very same connection? Thanks. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users