From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Nate Gelbard <gelbardn(at)tripwire(dot)com> |
Cc: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: JDBC bug? |
Date: | 2001-11-26 18:30:24 |
Message-ID: | 200111261830.fAQIUOH29986@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
> Hi,
>
> I've found an annoyance with the postgresql JDBC driver (from the 7.1.3
> release).
>
> Pardon if this has been asked before, but the web archives are offline...
>
> In org/postgresql/jdbc2/DatabaseMetaData.java, there are several lines
> that call toLowerCase() on the table string names. This causes 'table
> unknown' erros when accessing tables with mixed case in the name. This
> popped out at me when trying to use the XML-DBMS package and also
> DbVisualizer.
>
> Also, when using the pgsql shell, \d createdBy returns table unknown,
> but \d "createBy" returns the right info.
>
> So does postgres not support mixed case in table names, or the backend
> does but the clients dont, or what?
Well, we support mixed case identifiers, but they need to be
double-quoted, as you saw. The \d behavior looks correct. The jdbc
issue looks more complicated because we are forcing lowercase in the
jdbc code. Perhaps some jdbc folks can comment on that.
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Cramer | 2001-11-26 18:33:20 | Re: CallableStatements |
Previous Message | Nate Gelbard | 2001-11-26 18:00:32 | JDBC bug? |