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: >>>> >>>> On 26 Aug 2010, at 12:12pm, Alan Chandler wrote: >>>> >>>>> This time it reported that the view it would have created failed because >>>>> the table (view) already existed. >>>> >>>> I'm sorry to ask this, but can you check for us whether a VIEW by that >>>> name really does exist ? Don't forget, VIEWs get saved >>>> in the file, they're not part of the attachment. >>> >>> Yes it does >> >> 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. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users