Re: Uppercase problem in jdbc2 DatabaseMetaData.getColumns()

Patrice Le Gurun <patrice(dot)le-gurun(at)wanadoo(dot)fr> writes:

> Hello everybody !
>
> I currently work on a project based on Java and PostgreSQL. This morning I
> "discovered" a bug in DatabaseMetaData.getColumns() that did not retrieve
> columns's informations when the table's name containt some uppercase
> characters. It's a big problem for me because I must work with some tables
> with uppercase char.
>
> After some looks on the CVS tree, it seems that the tablename pattern is
> converted to lowercase in the request. Is it possible to not convert the
> pattern to lowercase or use a insensitive case search ?

That's odd - I thought pgsql was case insensitive when it came to
table and column names? Ie,

SELECT ID FROM TESTDB;

and

select id from testdb;

are functionally equivalent?

BTW - great piece of s/w guys! We're using it as one of the db
drivers in the MaVerick project (DataBasic compiler) - can't wait for
update-able resultsets & rs.getArray(1) :-)

--
Pete

pete(at)maverick-dbms(dot)org
-------------------------------------------------------------
MaVerick - Open Source MultiValue Database Management System
Check out the website -> http://www.maverick-dbms.org