> -----Original Message----- > From: Igor Tandetnik [mailto:[EMAIL PROTECTED] > Sent: Friday, March 31, 2006 12:14 PM > To: SQLite > Subject: [sqlite] Re: Question regarding schema change error > ... > > > The thing is, in 99.9% > > of the time, the error would be received on the first call to > > sqlite3_step. > > 100% of the time, actually. Once step succeeds, and until > reset or finalize, there is a read transaction (a SHARED > lock) against the database. Any schema change is a write > operation and cannot proceed in the presence of active readers.
Ok, I was under the assumption that a schema change after one or more calls to step could cause the SQLITE_SCHEMA error. Thanks for pointing that out.
