Re: JDBC bug?

>> 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.
>>
>> 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.

I think Nate's being kind calling this an annoyance.  I may have missed
something in the docs, but I just spent a few frustrating hours confronting
a similar issue with tables of mixed case.  Everything was working correctly
with my servlet, except when I referenced a column with a name like
questionID in a where clause.  Note the casing.  I had no idea this is what
was wrong until, other ideas exhausted, I recreated my query text with
pgadmin's query wizard and it put quotes around everything in the SQL it
generated.

Is there a pqsql-jdbc log somewhere that this might have shown up?  I was so
sure it was my java code (which in the end it was, sort of :) I never
bothered to check any Postgres logs.  Would it have shown up somewhere
there?  Either way, personally, I think this isn't the best behavior.  I
don't want to get into a casing flame war, but, I would've expected an
exception if it couldn't figure out what was happening with the where
clause, something at least.

Colin Freas