Hi,
I tried to apply the step-by-step-guide to tables in a postgresql
database, version 7.4.
When creating the user interface using ClassDesigner.py (chapter 3)
error messages
appeared as listed below. Dabo version is 0.8.4, Python version 2.5.1.
It might be that the error was caused by using the postgres function
"generate_series"
in the sql string starting at line 110 of dbPostgreSQL.py. This function
is not available
in version 7.4 of postgresql.
Is this a known problem? Is the only way to avoid it to upgrade to a
newer version of
postgresql? Is the information from generate_series essential?
Another prerequisite for postgresql appears to be that all tables used
have a primary key.
This is not the case for some of my databases? If the only consequence
is that tables
without primary key are not utilized by the (e.g.) ClassDesigner it does
not hurt that much.
What are in fact the consequences?
I am using Dabo under Windows XP. I found that the box appearing after
right-clicking on the
designer window does not show the first 6 lines (sizers to custom
classes) properly.
I could just see the first letter at the very right of the selection box.
-- Thank you and regards
Klaus
---------------------------------------------------------------
System messages
Dabo Info Log: Mon Sep 01 16:32:00 2008: 1 database connection definition(s)
loaded.
Dabo Info Log: Mon Sep 01 16:32:00 2008: User interface already set to 'wx', so
dApp didn't touch it.
Dabo Info Log: Mon Sep 01 16:32:01 2008: wxPython Version: 2.8.1.1 wxMSW
(unicode)
sqltablestr = SELECT schemaname || '.' || tablename AS tablename
FROM pg_tables
WHERE (schemaname not like 'pg_%'
and schemaname not like
'information%')
and has_table_privilege('pem',
schemaname || '.' || tablename, 'SELECT')
conn_user = pem
Traceback (most recent call last):
File
"c:\python25\lib\site-packages\Dabo-0.8.4-py2.5.egg\dabo\ui\uiwx\dControlMixin.py",
line 26, in _onWxHit
self.raiseEvent(dEvents.Hit, evt, *args, **kwargs)
File
"c:\python25\lib\site-packages\Dabo-0.8.4-py2.5.egg\dabo\ui\uiwx\dPemMixin.py",
line 915, in raiseEvent
super(dPemMixin, self).raiseEvent(eventClass, nativeEvent, *args, **kwargs)
File
"c:\python25\lib\site-packages\Dabo-0.8.4-py2.5.egg\dabo\lib\eventMixin.py",
line 93, in raiseEvent
bindingFunction(event)
File
"c:\python25\lib\site-packages\Dabo-0.8.4-py2.5.egg\dabo\ui\dialogs\Wizard.py",
line 131, in onNext
self.CurrentPage += pg.nextPage()
File
"c:\python25\lib\site-packages\Dabo-0.8.4-py2.5.egg\dabo\ui\dialogs\Wizard.py",
line 302, in _setCurrPage
ok = self._pages[self._currentPage].onLeavePage(direction)
File
"C:\daten_consult\Entwicklung\python\Dabo\ide\wizards\QuickLayoutWizard.py",
line 63, in onLeavePage
return self.Wizard.makeConnection()
File
"C:\daten_consult\Entwicklung\python\Dabo\ide\wizards\QuickLayoutWizard.py",
line 749, in makeConnection
flds = crs.getFields(tb)
File
"c:\python25\lib\site-packages\Dabo-0.8.4-py2.5.egg\dabo\db\dCursorMixin.py",
line 1810, in getFields
flds = self.BackendObject.getFields(tableName, self.AuxCursor)
File
"c:\python25\lib\site-packages\Dabo-0.8.4-py2.5.egg\dabo\db\dbPostgreSQL.py",
line 120, in getFields
cursor.execute(sqlstr)
File
"c:\python25\lib\site-packages\Dabo-0.8.4-py2.5.egg\dabo\db\dCursorMixin.py",
line 331, in execute
raise dException.DBQueryException(e, sql)
dabo.dException.DBQueryException
_______________________________________________
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]
