dabo Commit
Revision 5068
Date: 2009-02-21 07:50:37 -0800 (Sat, 21 Feb 2009)
Author: Johnf
Trac: http://trac.dabodev.com/changeset/5068
Changed:
U trunk/dabo/db/dbPostgreSQL.py
Log:
Changed the way schema field was being quoted. Was not working with
ClassDesigner.
Diff:
Modified: trunk/dabo/db/dbPostgreSQL.py
===================================================================
--- trunk/dabo/db/dbPostgreSQL.py 2009-02-20 18:48:04 UTC (rev 5067)
+++ trunk/dabo/db/dbPostgreSQL.py 2009-02-21 15:50:37 UTC (rev 5068)
@@ -121,8 +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')")
+ 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]
