The following bug has been logged online:
Bug reference: 3894
Logged by: Adam Hardy
Email address: adam(dot)hardy(at)cyberspaceroad(dot)com
PostgreSQL version: 8.2.5
Operating system: Linux
Description: JDBC DatabaseMetaData.getTables is inconsistently
case-sensitive with schema name
Details:
I created a schema with this cmd:
create schema DEV;
set search_path to DEV;
but then DatabaseMetaData.getTables(null, "DEV", "%", new String[]
{"TABLE"}) returned an empty resultset.
However giving it the schema name "dev" returns the full resultset.
It took me 4 hours to isolate this problem which was hidden in the code of
DbUnit.