PostgreSQL 8.1 – New ER using DB Explorer no relationship

MyEclipse Archived

>

Database Tools (DB Explorer, Hibernate, etc.)

This topic has 4 replies, 2 voices, and was last updated 17 years, 6 months ago by Welly.

Viewing 5 posts - 1 through 5 (of 5 total)

Author

Posts
April 10, 2007 at 11:29 am #268647 Reply

Welly
Member

I tried to create a new ER diagram from existing schema in PostgreSQL 8.1.3 but the resulting diagram (.mer) does not show the relationship.
It just shows the tables.
It worked fine with PostgreSQL 8.0.x.
It is OK if I create a new ER from Oracle database.
Any idea???

April 11, 2007 at 12:26 am #268673 Reply

Haris Peco
Member

Have you seen foreign keys in Db Explorer ?

Regards

April 12, 2007 at 11:54 am #268751 Reply

Welly
Member

No.
It looks like DB Explorer can’t see some Postgres’ data dictionary belong to information_schema.
Even on my own schema, I can’t browse stored procedures.

April 12, 2007 at 1:02 pm #268762 Reply

Haris Peco
Member

MyEclipse doesn’t support PostgreSQL’s stored procedures in DB browser (you can execute stored procedure in SQL editor).

If you haven’t seen foreign keys in Table/Info view then you have problem with jdbc drivers.Try newer version.
I have tested with jdbc driver 8.1 build 407.

Regards,

April 12, 2007 at 3:02 pm #268767 Reply

Welly
Member

Sweet!!!
Using JDBC 8.1 build 408 solved the problem.
Thank you!
Author

Posts

Viewing 5 posts - 1 through 5 (of 5 total)