From: | Barry Lind <barry(at)xythos(dot)com> |
---|---|
To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
Cc: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: JDBC bug? |
Date: | 2001-11-26 20:34:43 |
Message-ID: | 3C02A763.4030300@xythos.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Bruce Momjian wrote:
>>I haven't seen any evidence in this thread of a JDBC bug. The original
>>posting refered to calls in the DatabaseMetaData classes doing
>>toLowerCase(). This is appropriate because the DatabaseMetaData class
>>is querying the pg_* tables to get information about database objects,
>>thus since the backend stores the identifiers in lower case, therefore
>>the jdbc code needs to do a toLowerCase(). The followup below is more
>>
>
> But the backend doesn't store identifiers in lowercase if they have
> created mixed-case identifiers with double-quotes, right? I am
> confused.
>
Correct. But if you ask the API to get information about table myTable,
you should get an answer back for a table created as (create table
myTable (foo text)). The only way to do this is to lowercase the input
to match what the database is storing (mytable in this case). I agree
that if the table is created with a mixed case identifier (create table
"myTable" (foo text)) then there isn't a need to lower case in the
driver. Therefore the fact that there are a bunch of calls to
toLowerCase() in the jdbc code for DatabaseMetaData doesn't mean that
there is a bug here as they are entirely appropriate under some
circumstances. If someone produces a test case that demonstrates a bug
I will be glad to look into it. But up to this point there has only
been a lot of speculation on code that may be entirely correct. Test
cases demonstrating a real problem would be much apprecieated in this case.
thanks,
--Barry
>
>
>>of a complaint on how SQL is case insensitive and if you have created
>>your objects with quoted mixed case identifiers you need to access them
>>via quoted mixed case identifiers. I haven't seen any evidence that
>>basic SQL operations (select, insert, update, delete) have a bug in them.
>>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Colin Freas | 2001-11-26 20:41:28 | Re: JDBC bug? |
Previous Message | Barry Lind | 2001-11-26 20:27:58 | Re: [Fwd: Re: Problems with truncated BLOB] |