BUG #4488: jdbc : DatabaseMetaData.getPrimaryKeys no result - Mailing list pgsql-bugs

The following bug has been logged online:

Bug reference:      4488
Logged by:          Marcel Petavy
Email address:      petavy@gmx.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