John, I'll direct this to you, since you've worked the most with
Postgres, but if anyone else knows the answers, please speak up!
I'm trying to connect to a database that unfortunately uses case-
sensitive names. IOW, I have to write SQL using:
select "Table"."ColumnOne", "Table"."ColumnTwo"
from "public"."Table"
...etc.
I can connect, but the getTables() call is failing. Here is the
complete traceback:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Traceback (most recent call last):
File "/Library/Python/2.5/site-packages/dabo/ui/uiwx/
dControlMixin.py", line 21, in _onWxHit
self.raiseEvent(dEvents.Hit, evt, *args, **kwargs)
File "/Library/Python/2.5/site-packages/dabo/ui/uiwx/dPemMixin.py",
line 894, in raiseEvent
super(dPemMixin, self).raiseEvent(eventClass, nativeEvent, *args,
**kwargs)
File "/Library/Python/2.5/site-packages/dabo/lib/eventMixin.py",
line 93, in raiseEvent
bindingFunction(event)
File "/Library/Python/2.5/site-packages/dabo/ui/dialogs/Wizard.py",
line 131, in onNext
self.CurrentPage += pg.nextPage()
File "/Library/Python/2.5/site-packages/dabo/ui/dialogs/Wizard.py",
line 302, in _setCurrPage
ok = self._pages[self._currentPage].onLeavePage(direction)
File "/Users/ed/projects/ide/wizards/QuickLayoutWizard.py", line
63, in onLeavePage
return self.Wizard.makeConnection()
File "/Users/ed/projects/ide/wizards/QuickLayoutWizard.py", line
745, in makeConnection
tbls = crs.getTables()
File "/Library/Python/2.5/site-packages/dabo/db/dCursorMixin.py",
line 1716, in getTables
return self.BackendObject.getTables(self.AuxCursor,
includeSystemTables)
File "/Library/Python/2.5/site-packages/dabo/db/dbPostgreSQL.py",
line 67, in getTables
cursor.execute(sqltablestr)
File "/Library/Python/2.5/site-packages/dabo/db/dCursorMixin.py",
line 314, in execute
raise dException.DBQueryException(e, sql)
dabo.dException.DBQueryException: relation
"public.acct_account_backup" does not exist
SQL: SELECT schemaname || '.' || tablename AS tablename FROM pg_tables
WHERE (schemaname not like 'pg_%' and schemaname not like 'information
%') and has_table_privilege('core_write', schemaname || '.' ||
tablename, 'SELECT')
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Any ideas?
-- Ed Leafe
_______________________________________________
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/dabo-dev/[EMAIL PROTECTED]
