On Tue, Jul 5, 2016 at 4:46 PM, Dobrean, Adrian <adrian.dobr...@emc.com> wrote:
> I am unable to turn off journal for vfs (I am using SQLite version 3.8.7.2).
> I am not getting any error and the journal mode does not get set (i.e. to
> PAGER_JOURNALMODE_OFF).
> Any idea what am I doing wrong? (it used to work in 3.7.5)
>
>
> sqlite3_open_v2("/path/mysqfile", &ddDB, SQLITE_OPEN_READWRITE |
> SQLITE_OPEN_CREATE, "myvfs");
> sqlite3_exec(ddDB, "PRAGMA journal_mode = off",NULL, 0, &zErrMsg);
>
On Tue, Jul 5, 2016 at 5:05 PM, Dobrean, Adrian <adrian.dobr...@emc.com> wrote:
> I am not getting any error, i.e. sqlite3_exec returns 0 and zErrMsg is NULL.
If you define your custom vfs, make sure to check what your
xFileControl method (in the sqlite3_io_methods structure) does when
called with SQLITE_FCNTL_PRAGMA as its second argument. This vfs
method can override pragmas that should normally be handled by the
sqlite3 core, not the vfs. See
https://www.sqlite.org/c3ref/c_fcntl_busyhandler.html#sqlitefcntlpragma
for documentation.
-- Ambrus
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
