I have enjoyed using TDM for modeling PostgreSQL databases for a couple of years now, but I keep missing better support for inheritance (and the associated caveats). Many very helpful features and improvements have been added, these issues are just the last bits that still make me do an occational google search for TDM alternatives:
While it’s a great help to be able to name inherited tables, (and have them generated in the right order) I’d really like a way to see this relationship visually in the physical model.
Also, only attributes themselves are inherited. Contraints need to be explicitly added for each child table…TDM could be a real lifesaver by supporting this somehow.
Currently I’m trying to figure out if I can add these through a custom script during the DDL generation.
Oh and the C-style comments in the beginning of the generated DDL has always forced me to write shellscripts scripts to handle the import