Patrice Le Gurun <patrice.le-gurun@wanadoo.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@maverick-dbms.org
-------------------------------------------------------------
MaVerick - Open Source MultiValue Database Management System
Check out the website -> http://www.maverick-dbms.org