Re: DatabaseMetaData.getImportedKeys returning duplicate

Peter,

I didn't see your first message ??

Yes this is a valid fix.

Dave
On Sun, 2003-03-16 at 21:39, Peter Royal wrote:
> Anyone? Is a specific testcase needed? Is no-one else using this
> metadata?
> thanks.
> -pete
>
> On Monday, March 3, 2003, at 09:27 PM, Peter Royal wrote:
>
> > 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
> >
> >
> > ---------------------------(end of
> > broadcast)---------------------------
> > TIP 4: Don't 'kill -9' the postmaster
> >
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
--
Dave Cramer <davec(at)fastcrypt(dot)com>
Cramer Consulting
--
Dave Cramer <Dave(at)micro-automation(dot)net>