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
grow.db
grow.db-shm
grow.db-wal

$ sqlite3 grow.db 'pragma journal_mode'
delete

$ ls|grep grow
grow.db


-- 
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to