Skip site navigation (1) Skip section navigation (2)

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

From: "Adam Hardy" <adam(dot)hardy(at)cyberspaceroad(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #3894: JDBC DatabaseMetaData.getTables is inconsistently case-sensitive with schema name
Date: 2008-01-22 23:42:17
Message-ID: 200801222342.m0MNgHEf083925@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
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.

Responses

pgsql-bugs by date

Next:From: Stephan SzaboDate: 2008-01-23 00:36:28
Subject: Re: bad message or bad privilege check in foreign key constraint
Previous:From: Tom LaneDate: 2008-01-22 17:56:14
Subject: Re: bad message or bad privilege check in foreign key constraint

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group