Re: [sqlite] unable to set 'PRAGMA journal_mode = off' for vfs

2016-07-05 Thread Zsbán Ambrus
On Tue, Jul 5, 2016 at 4:46 PM, Dobrean, Adrian 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?

Re: [sqlite] unable to set 'PRAGMA journal_mode = off' for vfs

2016-07-05 Thread R Smith
On 2016/07/05 5:18 PM, Dobrean, Adrian wrote: My understanding is that as result of this command " PRAGMA journal_mode = off" the journal mode should get set to "PAGER_JOURNALMODE_OFF". However in my case even though I get no error and the journal_mode stays set to "0" instead of

Re: [sqlite] unable to set 'PRAGMA journal_mode = off' for vfs

2016-07-05 Thread Dobrean, Adrian
9 AM To: SQLite mailing list Subject: Re: [sqlite] unable to set 'PRAGMA journal_mode = off' for vfs My understanding is that as result of this command " PRAGMA journal_mode = off" the journal mode should get set to "PAGER_JOURNALMODE_OFF". However in my case even though I

Re: [sqlite] unable to set 'PRAGMA journal_mode = off' for vfs

2016-07-05 Thread Dobrean, Adrian
esday, July 05, 2016 11:13 AM To: SQLite mailing list Subject: Re: [sqlite] unable to set 'PRAGMA journal_mode = off' for vfs On 5 Jul 2016, at 4:05pm, Dobrean, Adrian <adrian.dobr...@emc.com> wrote: > I am not getting any error, i.e. sqlite3_exec returns 0 and zErrMsg is NULL. That ind

Re: [sqlite] unable to set 'PRAGMA journal_mode = off' for vfs

2016-07-05 Thread Simon Slavin
On 5 Jul 2016, at 4:05pm, Dobrean, Adrian wrote: > I am not getting any error, i.e. sqlite3_exec returns 0 and zErrMsg is NULL. That indicates your command worked correctly. What makes you think your command is failing ? After executing PRAGMA journal_mode = off

Re: [sqlite] unable to set 'PRAGMA journal_mode = off' for vfs

2016-07-05 Thread Dobrean, Adrian
users-boun...@mailinglists.sqlite.org] On Behalf Of Richard Hipp Sent: Tuesday, July 05, 2016 11:02 AM To: SQLite mailing list Subject: Re: [sqlite] unable to set 'PRAGMA journal_mode = off' for vfs On 7/5/16, Dobrean, Adrian <adrian.dobr...@emc.com> wrote: > Hi, > > I am unable to tu

Re: [sqlite] unable to set 'PRAGMA journal_mode = off' for vfs

2016-07-05 Thread Richard Hipp
On 7/5/16, Dobrean, Adrian wrote: > Hi, > > 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). Maybe you could tell us what the error is? >

[sqlite] unable to set 'PRAGMA journal_mode = off' for vfs

2016-07-05 Thread Dobrean, Adrian
Hi, 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", ,