On Wed, Sep 21, 2016 at 9:57 AM, Stepan Zakharov <vau...@hotmail.com> 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 sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users