On Thu, Nov 7, 2013 at 10:31 AM, L. Wood <lwoo...@live.com> wrote:

>
> QUESTION: What error codes can each of the following functions possibly
> return while the database file is renamed/moved during the execution of the
> function?
>

No errors are returned.  SQLite never notices that the database file has
been renamed.

In Unix, once a file is opened, the process only deals with the file
descriptor.  The underlying filename can change or even deleted (unlinked)
and the application will never know.

Note that renaming or unlinking a database file while it is being written,
then killing the writer process or turning the power off, can corrupt the
database file since it leave the associated journal file with a different
name.  See http://www.sqlite.org/howtocorrupt.html#unlink for additional
information.

-- 
D. Richard Hipp
d...@sqlite.org
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to