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