PG-friendly CASE/modeling tool?

Hello. We are new to Postgres, and are in the process of migrating our
project's app from Oracle.

I have been using Embarcadero's ER/Studio as a data modeling/DDL tool
for >15 years (and love it!), but its support for Postgres 8.4 is weak
(e.g., missing many datatypes, no function-based indexes, no partial
indexes, etc, etc). I don't get the impression that they're in a rush to
improve it, either.

Can anyone recommend a mature modeling/CASE tool with good support for
recent Postgres features?

Thanks much!

/mcr