sqlite3 views, if not exists clause

[Josh]

"Tim Golden" <Tim.Golden at viacom-outdoor.co.uk> wrote in message 
news:mailman.140.1163512445.32031.python-list at python.org...

| 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 the sqlite libs -- at least it fails on my 3.2.1 version of the
| sqlite3 commmand-line tool, but succeeds on the latest download (3.3.8).
|
| I presume therefore that you build of Python is linked against an
| older version of the sqlite libraries / DLL.

Exactly right. Since the sqlite3 interface hasn't changed, the fix was 
simply to copy the newest sqlite3.dll into the python dll directory. Now I 
no longer have to catch and ignore the "already exists" exception thrown by 
python. Thanks!