DatabaseMetaData.getImportedKeys returning duplicate rows
От | Peter Royal |
---|---|
Тема | DatabaseMetaData.getImportedKeys returning duplicate rows |
Дата | |
Msg-id | CCE26486-4DE8-11D7-A64B-000393B61B56@pace2020.com обсуждение исходный текст |
Ответы |
Re: DatabaseMetaData.getImportedKeys returning duplicate rows
|
Список | pgsql-jdbc |
I am having a problem with the DatabaseMetaData.getImportedKeys() function. I am asking for the keys with respect to a specific table. All is fine, except when I have two columns in a table that are both foreign keys to another table, ie: Table A Table B ------- ------- col1 -----------pk col2 -----------/ The ResultSet returned from getImportedKeys is structured: col1 col2 col1 col2 If I execute the query that is generated behind the scenes in the psql command-line program, adding the DISTINCT keyword to the query causes it to return the proper number of rows. Is that a valid fix, or will that break something else? Should the duplicate-reduction be done inside the java code that creates the ResultSet? I have no problem making the fix, I just don't know enough about the jdbc internals (nor postgres itself, I'm a new user) to be confident enough to know exactly *what* to fix. Anyways great work thus far, I look forward to helping improve the driver! -pete -- peter royal -> proyal@pace2020.com
В списке pgsql-jdbc по дате отправления: