On Wed, 2005-06-01 at 17:16 +0100, Ben Clewett wrote: > Some extra information: > > I also note I run a VACUUM every 50 minutes. Could this result in the > "database schema has changed" message I sometimes see? Possibly one > thread accessing database during VACUUM? >
Yes. Strange though it may seem, VACUUM changes the schema. What happens is that VACUUM moves tables and indices around inside the file. Even though the schema as seen by us humans remains the same, the way the schema is implemented on the inside does change. And it is the inside implementation that the SQLITE_SCHEMA error cares about. -- D. Richard Hipp <[EMAIL PROTECTED]>
