On Friday 20 February 2009 08:04:07 pm tim awa wrote:
> Am getting the following error when doing "Add Controls from Data
> Environment" in ClassDesigner.
>
> File "C:\dabodev\dabo\db\dCursorMixin.py", line 1947, in getTables
> return self.BackendObject.getTables(self.AuxCursor,
> includeSystemTables) File "C:\dabodev\dabo\db\dbPostgreSQL.py", line 126,
> in getTables cursor.execute(" ".join(query))
> File "C:\dabodev\dabo\db\dCursorMixin.py", line 330, in execute
> raise dException.DBQueryException(errMsg, sql)
> dabo.dException.DBQueryException: schema "||schemaname||" does not exist
> SQL: SELECT schemaname||'.'||tablename AS tablename FROM pg_tables WHERE
> (schema
> name NOT LIKE 'pg_%' AND schemaname NOT LIKE 'information%') AND
> has_schema_priv
> ilege('||schemaname||', 'usage') AND
> has_table_privilege('||schemaname||.||table
> name||', 'select')
>
> I am on Python 2.5.4 (Windows) using dabo from subversion (Feb 21), and
> PostgreSQL 8.3.6-1 (Windows)
>
> My Bizobj is the following:
>
> class NameBizobj(dabo.biz.dBizobj):
> def afterInit(self):
> self.DataSource = "tblname"
> self.KeyField = "pkseq"
> self.UserSQL = """select pkseq, fullname from public.tblname
> """
Would you please give me the version of Postgres you are using and any other
settings you might have. It has been reported that statement is causing
trouble with the windows. Thanks for your report and help.
--
John Fabiani
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message:
http://leafe.com/archives/byMID/[email protected]
