[sqlite] sqlite vfs and wal mode

2015-03-08 Thread J Decker
I was trying to figure out what to do about this WAL journal_mode option... 1) my vfs does not (and cannot) have a shared memory interface... so those routines are NULL (so I would think WAL logic should prohibit flagging the database as wal...) 2) I tried to return error on the pragma, but

[sqlite] sqlite vfs and wal mode

2015-02-23 Thread Dan Kennedy
On 02/23/2015 12:42 PM, J Decker wrote: > I see; the first part... > > " result of the pragma or the error message if the pragma fails" I missed > the or part... or rather missed the part before the or. > > On Sun, Feb 22, 2015 at 8:13 PM, J Decker wrote: > >> So now that I have the added

[sqlite] sqlite vfs and wal mode

2015-02-22 Thread J Decker
I see; the first part... " result of the pragma or the error message if the pragma fails" I missed the or part... or rather missed the part before the or. On Sun, Feb 22, 2015 at 8:13 PM, J Decker wrote: > So now that I have the added complexity of my own vfs in which to make a > sqlite

[sqlite] sqlite vfs and wal mode

2015-02-22 Thread J Decker
So now that I have the added complexity of my own vfs in which to make a sqlite vfs... I'm having some issues. Hmm... One of the first things I do is 'pragma journal_mode=WAL' I return sqlite_ok; but the result has 0 columns, whereas my command line tool returns a column 'journal_mode' and a row