Re: BUG #4488: jdbc : DatabaseMetaData.getPrimaryKeys no result

From: Kris Jurka <books(at)ejurka(dot)com>
To: Marcel Petavy <petavy(at)gmx(dot)net>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #4488: jdbc : DatabaseMetaData.getPrimaryKeys no result
Date: 2008-10-21 21:18:47
Message-ID: Pine.BSO.4.64.0810211713460.30540@leary.csoft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Tue, 21 Oct 2008, Marcel Petavy wrote:

> Bug reference: 4488
> PostgreSQL version: 8.2.4
> Operating system: Windows XP
> Description: jdbc : DatabaseMetaData.getPrimaryKeys no result
> Details:
>
> 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.

It definitely does work, perhaps your table is really "TEST" instead of
"test"? If you still believe it's a driver problem, please post a
complete test case that shows the exact create table command and java code
calling getPrimaryKeys.

Kris Jurka

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2008-10-21 21:32:01 Re: BUG #4479: Incorrect TSearch2 results when inserting after deleting
Previous Message Tom Lane 2008-10-21 21:10:45 Re: BUG #4481: Big text insert/update using functions failed