> I've found an annoyance with the postgresql JDBC driver (from the 7.1.3
> 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
> 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
In response to
- JDBC bug? at 2001-11-26 18:00:32 from Nate Gelbard
pgsql-jdbc by date
|Next:||From: Dave Cramer||Date: 2001-11-26 18:33:20|
|Subject: Re: CallableStatements|
|Previous:||From: Nate Gelbard||Date: 2001-11-26 18:00:32|
|Subject: JDBC bug?|