Re: sqlite3 views, if not exists clause

"Tim Golden" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] | Not a bug with the "sqlite3 api that comes with python 2.5." as such, | since .execute pretty much passes its parameters through to the database | engine. Rather, the syntax you're using is a relatively late addition | to

Re: sqlite3 views, if not exists clause

Fredrik Lundh wrote: > "Josh" wrote: > >> THIS DOES NOT WORK, but it should! > > Python 2.5 was released on September 19th, 2006, and support for CREATE > VIEW IF NOT EXISTS was added to sqlite on October 9th, 2006: So? "from __future__ import ..." should have supported this! <:o) -- Roberto

RE: sqlite3 views, if not exists clause

[Josh] | I'm running into a problem when trying to create a view in my sqlite | database in python. I think its a bug in the sqlite3 api that | comes with python 2.5. | THIS DOES NOT WORK, but it should! | conn = sqlite3.connect(':memory:') | conn.execute("create table foo (a int,b int)") |

Re: sqlite3 views, if not exists clause

"Josh" wrote: > THIS DOES NOT WORK, but it should! Python 2.5 was released on September 19th, 2006, and support for CREATE VIEW IF NOT EXISTS was added to sqlite on October 9th, 2006: http://www.sqlite.org/changes.html -- http://mail.python.org/mailman/listinfo/python-list