JP <[EMAIL PROTECTED]> wrote:
> I don't know if it is a bug or works as designed, but, should VACUUM be
> changing the format of the DB?
>
> I created a database with sqlite 3.2.7, and after a VACUUM in sqlite
> 3.3.6 I could no longer open it in the older program - error message #1,
> unsupported file format.
>
VACUUM does update the database to the latest file format.
You can prevent this using either a pragma
PRAGMA legacy_file_format=ON;
Or by compiling SQLite with -DSQLITE_DEFAULT_FILE_FORMAT=1
--
D. Richard Hipp <[EMAIL PROTECTED]>
