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?
nate