Re: 9.0 JDBC driver reporting invalid primary key meta data

From: "Adam Rauch" <adam(at)labkey(dot)com>
To: "'Kris Jurka'" <books(at)ejurka(dot)com>
Cc: <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: 9.0 JDBC driver reporting invalid primary key meta data
Date: 2010-08-06 23:34:25
Message-ID: 01d201cb35bf$e95ccd70$bc166850$@com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Preliminary testing shows that this driver fixes the problem! I'll keep
testing, but it looks great so far.

Thanks so much,
Adam

-----Original Message-----
From: Kris Jurka [mailto:books(at)ejurka(dot)com]
Sent: Friday, August 06, 2010 3:07 PM
To: Adam Rauch
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: [JDBC] 9.0 JDBC driver reporting invalid primary key meta data

On Tue, 3 Aug 2010, Adam Rauch wrote:

>
> Requesting primary key meta data via the JDBC driver [i.e.,
> conn.getMetaData().getPrimaryKeys()] against PostgreSQL 9.0 reports
> incorrect meta data for tables whose PK column(s) has been renamed.

I've just checked in a fix for this problem. Also affected are
getIndexInfo and getBestRowIdentifier.

I've posted a jar file if you'd like to test this on your application.

http://www.ejurka.com/pgsql/jars/ar/

Kris Jurka

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message James William Pye 2010-08-07 00:45:15 Re: [HACKERS] Trouble with COPY IN
Previous Message Kris Jurka 2010-08-06 23:31:45 Re: [HACKERS] Trouble with COPY IN