Re: DatabaseMetaData.getPrimaryKeys()

From: Kris Jurka <books(at)ejurka(dot)com>
To: <SNarayan(at)automatedlogic(dot)com>
Cc: <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: DatabaseMetaData.getPrimaryKeys()
Date: 2003-08-06 04:50:08
Message-ID: Pine.LNX.4.33.0308060046550.26479-100000@leary.csoft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

On Tue, 5 Aug 2003 SNarayan(at)automatedlogic(dot)com wrote:

> I wrote earlier regarding a bug where getPrimaryKeys() returns an empty
> result set (in version PostgreSQL 7.3.3 JDBC3 jdbc driver build 112). The
> issue seems to be due to case sensitivity of the table name specified in
> the getPrimaryKeys method call.

This was a conscious decision. See:

http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&threadm=3DC4510E.266D9F3D%40ejurka.com&rnum=1&prev=/groups%3Fq%3DDatabaseMetaData%2Bcase%2Bsensitive%2Bgroup:comp.databases.postgresql.interfaces.jdbc%26hl%3Den%26lr%3D%26ie%3DUTF-8%26group%3Dcomp.databases.postgresql.interfaces.jdbc%26selm%3D3DC4510E.266D9F3D%2540ejurka.com%26rnum%3D1

Kris Jurka

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Barry Lind 2003-08-06 05:40:46 Re: [HACKERS] PostgreSQL JDBC driver Connection.setTransactionIsolation(Connection.TRANSACTION_SERIALIZABLE)
Previous Message LEON 2003-08-06 01:10:38 Re: [SQL] JDBC encoding problem