From: | Pete Jewell <pete(at)example(dot)compulink(dot)co(dot)uk> |
---|---|
To: | <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Re: Uppercase problem in jdbc2 DatabaseMetaData.getColumns() |
Date: | 2001-05-31 15:20:18 |
Message-ID: | m3lmnd1r65.fsf@softhome.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Patrice Le Gurun | 2001-05-31 15:40:00 | Re: Uppercase problem in jdbc2 DatabaseMetaData.getColumns() |
Previous Message | Patrice Le Gurun | 2001-05-31 13:40:00 | Uppercase problem in jdbc2 DatabaseMetaData.getColumns() |