victorsubervi at gmail.com
Sun Aug 16 17:30:34 CEST 2009
This is strange because I actually had "if exists" in my code:
sqlKWDrop = 'DROP TABLE IF EXISTS ' + kwTable + ';'
where kwTable, in the instance cited below, becomes "judaism_128". What
On Sun, Aug 9, 2009 at 7:57 PM, Dennis Lee Bieber <wlfraed at ix.netcom.com>wrote:
> On Sun, 9 Aug 2009 15:21:43 -0500, Victor Subervi
> <victorsubervi at gmail.com> declaimed the following in
> > Hi:
> > I get a ton of warnings like this from a program I run:
> > Warning (from warnings module):
> > File "C:\Python25\read.py", line 67
> > cursor.execute(sqlKWDrop)
> > Warning: Unknown table 'judaism_128'
> Personally -- I'd suggest fixing the database so that the table
> Ah, but then -- it appears from the name, that the purpose of this
> SQL statement is to delete the table... In which case use a database
> that supports (for example, current versions of MySQL, SQLite, and
> PostgreSQL) "drop table IF EXISTS tbl_name" which suppress the
> warning/error message and update the SQL as appropriate.
> Appears that M$ SQL Server does NOT implement that syntax... Nor
> could I find it for Firebird.
> If the application is specific for one database engine, it might be
> worth it to find out what features permit discovering if a table exists
> and bypassing the drop if it doesn't...
> Wulfraed Dennis Lee Bieber KD6MOG
> wlfraed at ix.netcom.com HTTP://wlfraed.home.netcom.com/
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Python-list