We are alreaady using Dezign from Datanamic. Unfortunately, it does not handle the PG use of triggers to implement foreign key referential integrity. We can generate the PG database from Dezign without problem not using triggers for foreign keys.
Our main objective is to be able to implement changes in a production data base and then be able to update the model so that we have updated documentation and a model which can generate a script to create the database.
If the DB model program can create scripts to alter [non-destructively] a database based upon changes to the model, then we could use this also.
We are looking for a DB design program which can reverse engineer a PG database. We want to use this to create revised documentation for the database after changes are made. PG outputs a creation SQL script which uses triggers to define foreign keys and this seems to be unusual and has caused a problem with one software.
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
