> 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.
>
OK, I see what you mean. If you pass in myTable, you want to look for
mytable in pg_class. However, what if they pass in "myTable", with the
quotes? Do we skip the lowercase step?
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026