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

BUG #4488: jdbc : DatabaseMetaData.getPrimaryKeys no result

From
"Marcel Petavy"
Date:
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

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

From
Kris Jurka
Date:
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

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

From
davidsarmstrong
Date:
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.

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

From
Kris Jurka
Date:
On Mon, 29 Dec 2008, davidsarmstrong wrote:

> 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.

All I can say is the same as before, it works for me.  If you can post a
complete test case I'd be happy to look at it, but there's not much else I
can do.

Kris Jurka

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

From
davidsarmstrong
Date:
Hi Kris,

Thanks for responding. After further testing I realized that it was working,
but that I was looking at the wrong database :wistle:. I did send an email
but I should have responded to the post.

Happy New Year!

Dave


Kris Jurka wrote:
>
>
>
> On Mon, 29 Dec 2008, davidsarmstrong wrote:
>
>> 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.
>
> All I can say is the same as before, it works for me.  If you can post a
> complete test case I'd be happy to look at it, but there's not much else I
> can do.
>
> 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-tp20098673p21239580.html
Sent from the PostgreSQL - bugs mailing list archive at Nabble.com.