On Wed, Sep 21, 2016 at 9:57 AM, Stepan Zakharov <[email protected]> wrote:
> We are using VFS however, may be that can be ill-implemented somehow so it
> makes PRAGMA not to work..
It can. And I think you're the third person on the mailing list to
fall into that trap.
From an earlier mail
("http://mailinglists.sqlite.org/cgi-bin/mailman/private/sqlite-users/2015-April/059108.html")
> could you check if it's your
> vfs that is handling those pragmas? The documentation at
> "http://sqlite.org/c3ref/c_fcntl_busyhandler.html#sqlitefcntlpragma"
> describes that when you run a PRAGMA statement on a database, sqlite
> will call the xFileControl method of the vfs file handle (as given in
> a sqlite3_io_methods structure) with SQLITE_FCNTL_PRAGMA as the second
> parameter. If that method returns SQLITE_OK, then sqlite will assume
> the vfs has handled the pragma, and will not handle it itself. This
> could cause pragmas to fail silently.
-- Ambrus
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users