Hello Paolo,
On Nov 19, 2004, at 10:24, P. Morandi wrote:
Hi everybody.
After using VACUUM on a sqlite db, the first time I try to do an INSERT in a table
(always the same table) I get the "DATABASE SCHEMA HAS CHANGED" error, but later
queries have no problems, only the first one.
If I don't pack the db (no using of VACUUM) no problem.
Does anyone have any idea of the causes of this error message?
I believe VACUUM changes the schema version numbering. After you VACUUM, your sqlite3 struct holds information about your previous database version. Solution: reopen the database and SQLite will pick up the new changes. After that, INSERT will not report an error (until you VACUUM again, that is.)
I hope this helps,
-- Tito