If I create table MY_TABLE (unquoted uppercase), then my_table
(lowercase) is actually created. This is clearly documented, so fine.
But now if I use .getTables(null, null, "MY_TABLE", null) to ask
whether this table actually exists, the answer is "no" (empty) because
.getTables() acts like I quoted the MY_TABLE identifier.
It's quite annoying to create a table and not be able to see it...
Tested with postgresql-server.i686 8.0.7-1PGDG and 8.2dev-503
Maybe this is a server-side issue?
pgsql-jdbc by date
|Next:||From: Marc Herbert||Date: 2006-07-20 18:52:49|
|Subject: "prepared" statements (Re: Limit vs setMaxRows issue)|
|Previous:||From: Dave Cramer||Date: 2006-07-18 17:25:16|
|Subject: Re: Prepared Statement Memory Size|