On 9 Nov 2013, at 10:07am, Dan Kennedy <danielk1...@gmail.com> wrote:
> On 11/09/2013 04:58 PM, L. Wood wrote: >>> Richard Hipp <d...@sqlite.org> wrote: >>> Rollback journal files might be closed and reopened. [snip] >> >> [snip]* 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. Given that the journal file is closed-and-reopened only between transactions, if SQLite is unable to reopen the journal file (because it was moved/deleted) then it will either create a new one or return an error, right ? No corruption of the database will result. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users