| Kris Jurka 2005-05-17, 1:24 pm |
|
On Wed, 11 May 2005, Pavel Krupets wrote:
> Bug reference: 1661
> PostgreSQL version: 8.0.2
> Description: JDBC DatabaseMetaData.getExportedKeys() returns invalid
> keys.
>
> If I ask getExportedKeys(null
, "bc4jgen_test_04", "table_03") to return
> exported foreign keys it will return 'fk_table_05_2_table
_03' key. But this
> key isn't exported. table_05 does not references table_03's primary key,
> just a unique one! Please check javadocs excerpts below.
>
I guess we consider this a feature, not a bug. Otherwise there is no way
to retrieve foreign key information for foreign keys to unique
constraints. If you've got a concrete reason why this is a bad thing
please let us know. The javadoc does indeed say primary key, but I don't
see why including unique ones as well is a problem.
Kris Jurka
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql
.org
|