#1188: getTables() in dbPostgreSQL can fail with inaccessible schemas
--------------------------------+-------------------------------------------
Reporter: cito | Owner: somebody
Type: defect | Status: new
Priority: major | Milestone: 0.9
Component: ui | Version: 0.8.4
Keywords: postgres getTables |
--------------------------------+-------------------------------------------
When the Postgres database contains an inaccessible schema, the
`getTables()` method will fail with an exception. This is because the SQL
function `has_table_privilege()` raises an error when called on a table
that is not accessible. The problem can be solved by filtering such
schemas with `has_schema_privilege()`.
I have attached a patch that fixes this problem and also simplifies the
SQL and Python code a bit (note that Py 2.4 is required now since dabo
0.9, so you can often code more nicely and efficiently).
--
Ticket URL: <http://trac.dabodev.com/ticket/1188>
Dabo Trac <http://trac.dabodev.com>
Trac Page for Dabo
_______________________________________________
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]
