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

Kris,

I get the same error. I've verified the table name and the primary key. The
interesting part is, it seems to work in cases where the primary key is a
serial.

Thanks,

Dave Armstrong



Kris Jurka wrote:
>
>
>
> 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
>
> --
> Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs
>
>

--
View this message in context:
http://www.nabble.com/BUG--4488%3A-jdbc-%3A-DatabaseMetaData.getPrimaryKeys-no-result-tp20098673p21201506.html
Sent from the PostgreSQL - bugs mailing list archive at Nabble.com.