Changeset 4162

Timestamp:

06/19/2008 08:40:14 AM (2 months ago)

Author:

johnf

Message:

removed some debug info
apparently I changed a SQL statement some time ago in some prior commit. Don't recall why that was done.

Files:

• trunk/dabo/db/dbPostgreSQL.py (modified) (3 diffs)

trunk/dabo/db/dbPostgreSQL.py

@@ -63 +63 @@
-            sqltablestr = (("SELECT schemaname || '.' || tablename AS tablename FROM pg_tables WHERE has_table_privilege('%s', schemaname || '.' || tablename, 'SELECT')") % self.conn_user)
-        else:
-
-
+#
+
-            sqltablestr = (("""SELECT schemaname || '.' || tablename AS tablename 
-                    FROM pg_tables 
@@ -71 +71 @@
-                    and has_table_privilege('%s', schemaname || '.' || tablename, 'SELECT')
-                    """) % ('%','%',self.conn_user))
-#       if includeSystemTables:
-#           sqltablestr = ("select relname from pg_class where relkind= 'r' ")
-#       else:
-#           sqltablestr = ("select relname from pg_class where relkind= 'r' and relname not like 'pg_%' and relname not like 'sql_%' ")
-        
-        print
-        print "sqltablestr = ", sqltablestr
-        print "conn_user = ", self.conn_user
-        print
-        cursor.execute(sqltablestr)
-        rs = cursor.getDataSet()
@@ -85 +76 @@
-        for record in rs:
-            tables.append(record["tablename"])
-#           tables.append(record["relname"])
-        return tuple(tables)
-