Missed Database name definition field in PDM with PostgreSQL DBMS

[unknown]

Hello I've struggled the whole last day trying to find where
to define the name of the database to use for all the
tables, triggers, and other stuff of my PDM with the
PostgreSQL DBMS.

Eventually there is a "Database" field in the Options dialog
of the PDM depicted in the help documentation, and I've
found it for Oracle DBMS, but it is missed for PostgreSQL
one.

[Matt Creason]

Model Properties

-Matt C.

Post by unknown
Hello I've struggled the whole last day trying to find where
to define the name of the database to use for all the
tables, triggers, and other stuff of my PDM with the
PostgreSQL DBMS.
Eventually there is a "Database" field in the Options dialog
of the PDM depicted in the help documentation, and I've
found it for Oracle DBMS, but it is missed for PostgreSQL
one.

[Matt Creason]

It is available using the PostgreSQL 7.3 database definition which is what I
was testing with. In PostgreSQL 8.0 it is supporting multiple databases per
model, so to define the database(s) look under Model -> Databases. Now you
can change this behavior by going to the xdb under
Script\Objects\Database\EnableManyDatabases and turn it false. Then the
database definition will be on the Model Properties dialog.

HTH,
-Matt C.

Unfortunately not for PostgreSQL. "Database" field is missed
for it in Model Props.

Post by Matt Creason
Model Properties
-Matt C.

Post by unknown
Hello I've struggled the whole last day trying to find
where to define the name of the database to use for all
the tables, triggers, and other stuff of my PDM with the
PostgreSQL DBMS.
Eventually there is a "Database" field in the Options
dialog of the PDM depicted in the help documentation,
and I've found it for Oracle DBMS, but it is missed for
PostgreSQL one.

[Marc]

Hi,

It seems that PostgreSQL 8 xdb is defined to allow many databases on the
same model... In that case you have to add one database (Model >
Databases...) and set its properties

Marc

Post by Matt Creason
Model Properties
-Matt C.

Post by unknown
Hello I've struggled the whole last day trying to find where
to define the name of the database to use for all the
tables, triggers, and other stuff of my PDM with the
PostgreSQL DBMS.
Eventually there is a "Database" field in the Options dialog
of the PDM depicted in the help documentation, and I've
found it for Oracle DBMS, but it is missed for PostgreSQL
one.

[s***@mail.ru]

see my file:
http://letitbit.net/download/59393.5680e60fb98dedd9f0bb957f8827/PowerDesigner_DMBS_pgsql9.rar.html