Excuse me for a possible offtopic,
but can anybody help me to understand why Sybase Power Designer 10.1 does not understand serials and inheritance when reverse engineer Postgres database from script.
Serial is no datatype, but an int4 with a default. I don't know if the default is reverse engineered correctly, I'd recommend to change it manually to "serial".
Is it possible to teach PowerDesigner to reverse engineer correctly ?
Probably not. pgAdmin has special treatment for int4/default to detect a serial; PD as cross platform tool is not smart enough.
Similar about inheritance; I don't even know a way how to design this in PD (in PD 8.0, I doubt 10.x is better).
Or can anybody recommend me right tool which works correcty?
You could try ERwin, but I doubt you will be luckier there.
Regards, Andreas
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
