Re: JDBC bug?

> 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