keys missing in reference display in DbVisualizer

From: Andreas Plesch <plesch(at)fas(dot)harvard(dot)edu>
To: pgsql-novice(at)postgresql(dot)org
Subject: keys missing in reference display in DbVisualizer
Date: 2003-02-05 21:02:27
Message-ID: 3E417BE3.4070901@fas.harvard.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi,

I found DbVisualizer at www.minq.se to be a fantastic and free tool.
Here is a problem I encountered. Consider a db with these three tables:

CREATE TABLE alternatives( alt_id serial,
PRIMARY KEY(alt_id));
CREATE TABLE ver2( ver_id serial,
PRIMARY KEY(ver_id));
CREATE TABLE ver_alt( alt_id int,
ver_id int,
FOREIGN KEY(ver_id) REFERENCES ver2(ver_id),
FOREIGN KEY(alt_id) REFERENCES alternatives(alt_id));

The references display in DbVis shows correctly 2 arrows pointing to
ver_alt from the two source tables.

Now create a new db with the same 3 tables and add a fourth table:

CREATE TABLE ver3( alt_id int,
FOREIGN KEY(alt_id) REFERENCES alternatives(alt_id));

Now the references displays shows correctly one arrow from alternatives
to ver3 but only one arrow to ver_alt which happens to originate from ver2.

What happened to the alternatives->ver_alt reference ? Could this be a
db design error, a db error, a jdbc error or a DbVisualizer error ? I
cannot find exception to the above schema a but I am not an experienced
db architect.

The db has the keys correctly stored as checked by using psql locally.
I use postgresql7.3.1 on redhat 7.3 with the postgresql jdbc driver.

Thanks for any insight,

Andreas

Browse pgsql-novice by date

  From Date Subject
Next Message Andrew McMillan 2003-02-05 21:23:16 Re: Postgres performace with large tables.
Previous Message Greg Sabino Mullane 2003-02-05 20:51:01 Re: How can I speed up with query?