[SQL-CVS] r451 - home/phd/SQLObject/inheritance/sqlobject/postgres

[<sub...@co...>]

Author: phd
Date: 2004-12-06 22:50:45 +0000 (Mon, 06 Dec 2004)
New Revision: 451

Modified:
   home/phd/SQLObject/inheritance/sqlobject/postgres/pgconnection.py
Log:
Merged patch from revisions 449:450: fixed tableExists(): use sqlrepr() to quote tableName; removed a comment.


Modified: home/phd/SQLObject/inheritance/sqlobject/postgres/pgconnection.py
===================================================================
--- home/phd/SQLObject/inheritance/sqlobject/postgres/pgconnection.py	2004-12-06 22:46:33 UTC (rev 450)
+++ home/phd/SQLObject/inheritance/sqlobject/postgres/pgconnection.py	2004-12-06 22:50:45 UTC (rev 451)
@@ -105,9 +105,8 @@
         return 'INT NOT NULL'
 
     def tableExists(self, tableName):
-        # @@: obviously broken
-        result = self.queryOne("SELECT COUNT(relname) FROM pg_class WHERE relname = '%s'"
-                               % tableName)
+        result = self.queryOne("SELECT COUNT(relname) FROM pg_class WHERE relname = %s"
+                               % self.sqlrepr(tableName))
         return result[0]
 
     def addColumn(self, tableName, column):