I think SQLITE_SCHEMA can happen even if you run things like CREATE TABLE or ALTER TABLE on the same connection. Also ATTACH DATABASE and DETACH DATABASE should invalidate all statements prepared before that.
Pavel On Thu, Jun 28, 2012 at 9:58 AM, Marc L. Allen <[email protected]> wrote: > Oh.. you're positing a second party. Ok.. now I'm interested to see if there > was one. > > -----Original Message----- > From: [email protected] > [mailto:[email protected]] On Behalf Of Igor Tandetnik > Sent: Thursday, June 28, 2012 9:55 AM > To: [email protected] > Subject: Re: [sqlite] Not sure how to interrupt this > > Marc L. Allen <[email protected]> wrote: >> How could the schema have changed? > > Someone ran CREATE TABLE or VACUUM or similar on the database (possibly via a > different connection). > -- > Igor Tandetnik > > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
