The following bug has been logged online:
Bug reference: 4488
Logged by: Marcel Petavy
Email address: petavy(at)gmx(dot)net
PostgreSQL version: 8.2.4
Operating system: Windows XP
Description: jdbc : DatabaseMetaData.getPrimaryKeys no result
Details:
Hi.
If I try to query the primary key via JDBC driver
"postgresql-8.3-603.jdbc4.jar" DatabaseMetaData.getPrimaryKeys I get not
result.
create table test (id integer not null primary key(id))
ResultSet rs = connection.getMetaData(null,null,"test");
rs gives no rows.
All other known JDBC drivers (jtds MS-SQL, ojdbc16 Oracle) reporting the
primary key "id".
Cya - Marcel