Re: multiple sqlite structures

"D. Richard Hipp" <drh@...> writes:

> Jimmy Pritts wrote:
> > Hi,
> > 
> > I have a program that has 3 sqlite structures open at one time.
> > I am not multithreading.  In do the following the in this order...
> > 
> > 1. Open sqlite structure 1
> > 2. Create 2 tables with sqlite structure 1
> > 3. Open sqlite structure 2
> > 4. Create 1 table with sqlite structure 2
> > 5. Open sqlite structure 3
> > 6. Create 1 table with sqlite structure 3
> > **7. Insert 1 row into a table created with sqlite structure 1
> > 
> > Step 7 is where sqlite returns the error:
> > "database schema has changed"
> > 
> > I compiled sqlite with the preprocessor macro THREADSAFE=1 just to 
> > be sure that was not the problem.  Am I doing something not allowed?
> > 
> 
> This has nothing to do with threadsafety.  When you have an SQLite
> database open and some other process (or another connection to the
> same database within the same process) changes the schema for the
> database, the first time you try to access the database you will
> get a return code of SQLITE_SCHEMA.  All this means is that SQLite
> needs to reread the schema (because it has changed) which it will
> do automatically the next time you call sqlite_exec().