Re: [BUGS] BUG #1661: JDBC DatabaseMetaData.getExportedKeys() returns

#1

On Wed, 11 May 2005, Pavel Krupets wrote:

Quote:

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 (AT) postgresql (DOT) org

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: [BUGS] BUG #1661: JDBC DatabaseMetaData.getExportedKeys() returns

mailing.database.pgsql-bugs mailing.database.pgsql-bugs

Re: [BUGS] BUG #1661: JDBC DatabaseMetaData.getExportedKeys() returns - 05-17-2005 , 12:29 PM