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