Re: [sqlite] Problem to switch between WAL and delete journal modes

Alexey Pechnikov wrote: > Some times database can return journal_mode=delete when exists WAL journal: Why shouldn't it? journal_mode reports the kind of journal this connection is going to write for upcoming transactions - not the kind of journal that the previous

Re: [sqlite] Problem to switch between WAL and delete journal modes

On 8 Jul 2010, at 11:50am, Simon Slavin wrote: > That 'sqlite3' command does not refer to the grow.db database Whoops. Sorry, I should have read your post more carefully. Simon. ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Problem to switch between WAL and delete journal modes

On 8 Jul 2010, at 7:46am, Alexey Pechnikov wrote: > $ ls|grep grow > grow.db > grow.db-shm > grow.db-wal > > $ sqlite3 > SQLite version 3.7.0 > Enter ".help" for instructions > Enter SQL statements terminated with a ";" > sqlite> pragma journal_mode; > delete > sqlite> .q That 'sqlite3'

[sqlite] Problem to switch between WAL and delete journal modes

Some times database can return journal_mode=delete when exists WAL journal: $ ls|grep grow grow.db grow.db-shm grow.db-wal $ sqlite3 SQLite version 3.7.0 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> pragma journal_mode; delete sqlite> .q $ ls|grep grow