DatabaseMetaData.getImportedKeys returning duplicate rows

From: Peter Royal <proyal(at)pace2020(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: DatabaseMetaData.getImportedKeys returning duplicate rows
Date: 2003-03-04 02:27:09
Message-ID: CCE26486-4DE8-11D7-A64B-000393B61B56@pace2020.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)pace2020(dot)com

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Daniel Bruce Lynes 2003-03-04 06:53:00 Re: I can't insert the chinese words.
Previous Message Dirk Bromberg 2003-03-03 21:24:39 Postgres PooledConnection...