dabo Commit
Revision 5008
Date: 2009-02-01 06:41:45 -0800 (Sun, 01 Feb 2009)
Author: Ed
Trac: http://trac.dabodev.com/changeset/5008
Changed:
U trunk/dabo/db/dbPostgreSQL.py
Log:
Appllied the fix to the getTables() method suggested by Raffaele Candeliere to
handle case-sensitive table names in the schema.
Diff:
Modified: trunk/dabo/db/dbPostgreSQL.py
===================================================================
--- trunk/dabo/db/dbPostgreSQL.py 2009-02-01 02:00:03 UTC (rev 5007)
+++ trunk/dabo/db/dbPostgreSQL.py 2009-02-01 14:41:45 UTC (rev 5008)
@@ -121,9 +121,9 @@
if not includeSystemTables:
query.append("(schemaname NOT LIKE 'pg_%' AND "
"schemaname NOT LIKE 'information%')
AND")
- query.append("has_schema_privilege(schemaname, 'usage') AND "
-
"has_table_privilege(schemaname||'.'||tablename, 'select')")
- cursor.execute(' '.join(query))
+ query.append("has_schema_privilege('"'||schemaname||'"',
'usage') AND "
+
"has_table_privilege('"'||schemaname||'"."'||tablename||'"', 'select')")
+ cursor.execute(" ".join(query))
return tuple(record["tablename"] for record in
cursor.getDataSet())
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
Searchable Archives: http://leafe.com/archives/search/dabo-dev
This message:
http://leafe.com/archives/byMID/[email protected]
