On Sep 1, 2008, at 10:09 AM, Klaus Demleitner wrote:
> 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?
According to the comment in the code, it says that 7.4 should be
supported. John Fabiani wrote that code; John, can you address this?
> 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?
Tables without a PK cannot be updated. There is no way to find the
original record in order to apply any changes to it. Since the typical
purpose of a database app is to add/update records, PKs are generally
required.
> 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.
This was an issue that should have been fixed in a recent commit to
the subversion trunk. What version are you using? The easiest way to
get this information is to choose the Help/About... menu item from any
Dabo app, such as the Class Designer, click the button to copy the
info, and then paste it into the email.
-- Ed Leafe
_______________________________________________
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]
