The following bug has been logged online: Bug reference: 3894 Logged by: Adam Hardy Email address: [EMAIL PROTECTED] 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. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend