From: | "Ross J(dot) Reedstrom" <reedstrm(at)rice(dot)edu> |
---|---|
To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
Cc: | Nate Gelbard <gelbardn(at)tripwire(dot)com>, pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: JDBC bug? |
Date: | 2001-11-26 19:17:52 |
Message-ID: | 20011126131752.A4857@rice.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Note that this is SQL92 standards compliant behavior: identifiers
are supposed to be case-insensitive, unless quoted.
Ross
On Mon, Nov 26, 2001 at 01:30:24PM -0500, Bruce Momjian wrote:
> > 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.
>
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Cramer | 2001-11-26 19:45:32 | Re: CallableStatements |
Previous Message | Bruce Momjian | 2001-11-26 19:17:31 | Re: JDBC bug? |