[SQL-CVS] r450 - trunk/SQLObject/sqlobject/postgres

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

Author: phd
Date: 2004-12-06 22:46:33 +0000 (Mon, 06 Dec 2004)
New Revision: 450

Modified:
   trunk/SQLObject/sqlobject/postgres/pgconnection.py
Log:
Fixed tableExists(): use sqlrepr() to quote tableName; removed a comment.


Modified: trunk/SQLObject/sqlobject/postgres/pgconnection.py
===================================================================
--- trunk/SQLObject/sqlobject/postgres/pgconnection.py	2004-12-06 13:51:10 UTC (rev 449)
+++ trunk/SQLObject/sqlobject/postgres/pgconnection.py	2004-12-06 22:46:33 UTC (rev 450)
@@ -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):