On 11/09/2013 04:58 PM, L. Wood wrote:
Richard Hipp <d...@sqlite.org> wrote:
Rollback journal files might be closed and reopened. But the main database
file is opened once and held open until sqlite3_close() (or DETACH if the
file was originally opened using ATTACH).
Thanks for this information. But suppose, while a journal file is open, it is
moved (along with the main database file) to a new directory.
* The next close() of the journal will work just fine, I assume?
* But what about the next open() of a new journal file? Will it use the new
location of the database file or the old one?
The old one.
When it starts up, SQLite calculates the full paths
to the database and journal files and stores them
in memory. So if the journal file is opened, moved,
closed and then reopened, it will be the original
location that is opened both times.
Dan.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
