I'm using the PostgreSQL 7.2.1 server and JDBC drivers distributed
with Red Hat 7.3. When I create a series of tables and foreign keys, and
then use the JDBC DatabaseMetaData calls getImportedKeys and
getExportedKeys, the results are incorrect. In some cases, I get the
primary key table with the foreign key column and vice versa, while in
other cases the primary key table *and* column are in the foreign key
positions and vice versa.
I'm not sure if there's a more specific place to report issues
with the JDBC driver, but I'll be happy to provide more detail including
SQL to create the tables and keys and the Java code to display the
incorrect results if you'll point me to the right place.
P.S. I guess I'm speculating that this is a JDBC issue not a DB issue...
I haven't tried inserting some bad data. :)
pgsql-bugs by date
|Next:||From: Josh Goldberg||Date: 2002-06-17 22:39:39|
|Subject: referential integrity through inherited tables|
|Previous:||From: Karel Zak||Date: 2002-06-17 09:08:32|
|Subject: Re: to_date bug|