PowerDesigner 9.5.0.648 generate PostgreSQL 7.3.4.

[sean_elliott]

I am a PostgreSQL novice. I didn't realise that the user
defined type facility was so weird/impractical. I think I
will avoid them.

> I am using PowerDesigner 9.5.0.648 to generate a physical
> database for PostgreSQL 7.3.4.
>
> The syntax generated for user defined datatypes is
> incorrect.
> I attach the sql file generated from it.
>
> [Attachment: postgre.sql]

[Mike Nicewarner]

Also, please, please download the latest maintenance patches from Sybase.
The current version of PowerDesigner is 9.5.2.920 EBF6.
With the huge number of fixes and enhancements from 9.5.0, you really are
missing out on a lot by not upgrading.

--
Mike Nicewarner [TeamSybase]
http://www.datamodel.org
mike@nospam!datamodel.org
Sybase product enhancement requests:
http://www.isug.com/cgi-bin/ISUG2/submit_enhancement

<Sean Elliott> wrote in message news:4034aa72.54...@sybase.com...

[sean_elliott]

I take it back - PowerDesigner is wrong!
It should be trying to create PostgreSQL domains rather than
user types. Domains are like domains in PowerDesigner. Types
are more like generic objects to be stored in the database.

[Mike Nicewarner]

The nice thing is that you can change the behavior.
It looks like you know the proper syntax to use with PostgreSQL.
Please, if you do get it to work, please share.

--
Mike Nicewarner [TeamSybase]
http://www.datamodel.org
mike@nospam!datamodel.org
Sybase product enhancement requests:
http://www.isug.com/cgi-bin/ISUG2/submit_enhancement

<Sean Elliott> wrote in message news:4045eede.49...@sybase.com...

[sean_elliott]

OK - You have to change the generation of SQL so that it
uses this type of syntax:

CREATE DOMAIN country_code char(2) NOT NULL;

in menu Database/Edit Current DBMS/Script/Object/Domain