Thread: getPrimaryKeys() returns empty

getPrimaryKeys() returns empty

From

SNarayan@automatedlogic.com

Date:

06 August 2003, 03:11:43

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.