On Thu, 27 Mar 2008 03:10:33 -0700, you wrote: >Can I know where/HOW the Journal file is being written so that i can >check on my switch whether I have >sufficient write privileges enabled for journal file.
Journal files are written in the same directory as the database file. The database file is only created after a commit of the first transaction (usually a CREATE TABLE statement). The database file for TEMPORARY TABLEs is created in the /tmp directory (can be another directory, depending on platform specific routines, you will find that in the source code). > >Moreover I am using ext3 tinyfilesystem .... >somewhat similar to busybox file system ! If you had to port the sources to a new OS it is easy to make mistakes in the platform specific file I/O routines. They might not return the correct status. -- ( Kees Nuyt ) c[_] _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
