I wrote earlier regarding a bug where getPrimaryKeys() returns an empty
result set (in version PostgreSQL 7.3.3 JDBC3 jdbc driver build 112). The
issue seems to be due to case sensitivity of the table name specified in
the getPrimaryKeys method call.
databaseMetaData.getPrimaryKeys(null, null, 'TESTTABLE') returns empty
result set,
However, databaseMetaData.getPrimaryKeys(null, null, 'testtable') returned
the primary keys I expected.
The same issue seems to be present for the getIndexInfo() method also.
Hope this work around helps others for now,
sundar.