On Thu, Jul 8, 2010 at 10:50 AM, Alexey Pechnikov <pechni...@mobigroup.ru>wrote:
> 2010/7/8 Richard Hipp <d...@sqlite.org> > > > In the current implementation, if you call "PRAGMA wal_checkpoint" just > > prior to closing the database, the WAL file will be deleted > automatically. > > But it keeps the database in WAL mode, so the WAL is recreated the next > > time > > you open and write to the database. > > > It's not helpful for backward compability. How about version downgrade of > the Android or some other mobile OS and as result impossibility to open any > SQLite database?.. > Presumably the version downgrade comes with a script. (Otherwise, other changes such as schema changes would go uncorrected.) That script merely has to run PRAGMA journal_mode=DELETE; on every database. Problem solved. > > -- > 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 > -- --------------------- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users