BUG #3894: JDBC DatabaseMetaData.getTables is inconsistently case-sensitive with schema name

The following bug has been logged online:

Bug reference:      3894
Logged by:          Adam Hardy
Email address:      adam.hardy@cyberspaceroad.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.