 |
|
|
 |
|
 |
|
| Author |
Message |
|
|
Post subject: ER diagram not displaying crowfoot connector
 Posted: Sep 25, 2008 - 04:15 PM
|
|
Registered Member
Joined: Jan 28, 2006
Posts: 3
|
|
Hi folks
I have a small PostgreSQL db with a couple one-to-many relationships, but the "crowfoot" connector on the "many" side entity is not displaying in the ER diagram.
I believe that I have the foreign keys set correctly - the PK of "companies" (one) is set as a FK in "products" (many). Is the crowfoot supposed to display with a PostgreSQL db?
Any information will be appreciated.
thanks
Drew |
|
|
| |
|
|
|
 |
|
|
|
Post subject: RE: ER diagram not displaying crowfoot connector
Posted: Sep 25, 2008 - 07:07 PM
|
|
Moderator
Joined: Aug 21, 2004
Posts: 1294
|
|
Drew,
They should display fine. If I understand you correctly, you can see a connection but the decorator at the end is incorrect?
Could you please paste the SQL for the two involved tables here? Also, can you see the FK in the FK column of the Table / Object Info view for the table in question? |
_________________
Brian
MyEclipse Support
|
| |
|
|
|
|
|
|
|
Post subject: RE: ER diagram not displaying crowfoot connector
Posted: Oct 02, 2008 - 09:20 PM
|
|
Registered Member
Joined: Jan 28, 2006
Posts: 3
|
|
Hi Brian
thanks for your response. Fixed the problem by making sure the one-to-many relationships/foreign keys were correctly constructed in PostgreSQL tables.
appreciate your time
Drew |
|
|
| |
|
|
|
|
|
|
| |
|
|
 |
|
 |
|
|
|
|
Search
Register
Log in to check your private messages
