On 26 Aug 2010, at 4:59pm, Igor Tandetnik wrote: > Jay A. Kreibich <j...@kreibi.ch> wrote: >> On Thu, Aug 26, 2010 at 04:32:11PM +0100, Simon Slavin scratched on the wall: >>> >>> On 26 Aug 2010, at 3:36pm, Alan Chandler wrote: >>> >>>> On 26/08/10 13:38, Simon Slavin wrote: >>> >>> So you are trying to create a VIEW which does already exist. In that >>> case, there's no mystery about why you're getting an error message. >> >> No, he's trying the *PREPARE* a CREATE VIEW *statement* for a view >> that already exists. Prepare != execute. > > It's quite reasonable that the schema is checked at prepare time. For > example, you would expect an error on preparing, rather than executing, a > SELECT statement that mentions a non-existent table.
So someone can check it out. Try it with a VIEW that definitely doesn't exist, or use CREATE VIEW IF NOT EXISTS ... Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
