| Lists: | pgsql-jdbc |
|---|
| From: | David Gommeren <david(at)umgenicomputer(dot)com> |
|---|---|
| To: | pgsql-jdbc(at)postgresql(dot)org |
| Subject: | getPrimaryKeys |
| Date: | 2006-02-21 10:33:52 |
| Message-ID: | 43FAEC90.40909@umgenicomputer.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-jdbc |
Hi,
Just discovered after messing around for two hours that the table-name
in DatabaseMetaData.getPrimaryKeys is case sensitive. I don't think this
should be.
JDBC version: 8.1-405 JDBC 2
Cheers,
David
| From: | Kris Jurka <books(at)ejurka(dot)com> |
|---|---|
| To: | David Gommeren <david(at)umgenicomputer(dot)com> |
| Cc: | pgsql-jdbc(at)postgresql(dot)org |
| Subject: | Re: getPrimaryKeys |
| Date: | 2006-02-21 17:16:24 |
| Message-ID: | Pine.BSO.4.63.0602211215030.32683@leary.csoft.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-jdbc |
On Tue, 21 Feb 2006, David Gommeren wrote:
> Just discovered after messing around for two hours that the table-name in
> DatabaseMetaData.getPrimaryKeys is case sensitive. I don't think this should
> be.
>
How else would you differentiate between these two:
CREATE TABLE tab (a int primary key);
CREATE TABLE "TaB" (a int primary key);
Kris Jurka