Eclipse Community Forums: DTP » Reverse Engineering for PostgreSQL

Help

Home

Home » Eclipse Projects » DTP » Reverse Engineering for PostgreSQL

Show: Today's Messages :: Show Polls :: Message Navigator

Reverse Engineering for PostgreSQL [message #39005]

Fri, 23 November 2007 16:00

Eclipse User

Originally posted by: mcervera.integranova.com

Hello.

I am working on reverse engineering with a PostgreSQL Database and I've
run into a couple of problems that have prevented me from achieving the
expected result.

I've connected to the database successfully and managed to get an object
of the metaclass "database" so all I have to do is add it to a resource
and save it to get the XML code that allows me to visualize the
resulting tree model. Here are my problems:

- I get Index elements instead of Unique elements when I define a unique
constraint in my postgres database.

- The property "Referenced Members" of the Foreign Keys is not set.

- I am not getting the CheckConstraint elements when I add a constraint
in my postgres database.

Are these problems bugs? What can I do to solve them? Any help would be
really appreciated.

Thanks :).

Mario

Report message to a moderator

Re: Reverse Engineering for PostgreSQL [message #39432 is a reply to message #39005]

Thu, 29 November 2007 19:13

Larry Dunnell

Messages: 19
Registered: July 2009

Junior Member

Mario,

These problems are most likely caused by a lack of PostgreSQL-specific
support.
Currently, the reverse engineering is relying on the generic support
which relies on the JDBC metadata. Some of the other databases such as
Derby provide custom support to provide richer reverse engineering. DTP
relies on community contributions for PostgreSQL support.

If you are interested contributing in this area, the first area to look at
is the generic support in the org.eclipse.datatools.connectivity.sqm.core
plug-in to see if the problem cannot be solved there. Otherwise, the
Derby plug-ins provide a good example of providing database specific
support.

Larry

Report message to a moderator