Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-jdbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group