Postgres Pro
Downloads
Home   >   mailing lists

getPrimaryKeys() returns empty - Mailing list pgsql-jdbc

From SNarayan@automatedlogic.com
Subject getPrimaryKeys() returns empty
Date
Msg-id OFB9304C90.FAD4A6CF-ON85256D79.00538BAD-85256D79.0054F63D@automatedlogic.com
Whole thread Raw
List pgsql-jdbc
Tree view

Hi,
I am using the latest stable release JDBC driver (PostgreSQL 7.3.3 JDBC3 jdbc driver build 112) for PostgreSQL database, and using the method DatabaseMetaData.getPrimaryKeys(null, null, tableName) returns empty results even though the table has a primary key.

I also verified that a prior version of the driver (PostgreSQL 7.2 JDBC2) returns the primary key as expected.

Is this a bug in the latest driver version ? Is there a known work around at this time ?

I appreciate any information on this.

Thanks,
sundar.

pgsql-jdbc by date:

Previous
From: Kurt Overberg
Date:
Subject: JDBC encoding problem
Next
From: "LEON"
Date:
Subject: Re: [SQL] JDBC encoding problem