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

JDBC driver converts search string patterns to lowercase

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: JDBC driver converts search string patterns to lowercase
Date: 2001-08-14 22:47:16
Message-ID: 200108142247.f7EMlGH74145@hub.org (view raw or flat)
Thread:
Lists: pgsql-bugs
Bjorn Peterson (petbjo(at)bethel(dot)edu) reports a bug with a severity of 2
The lower the number the more severe it is.

Short Description
JDBC driver converts search string patterns to lowercase

Long Description
The metadata class of the Postgresql 7.1 JDBC driver converts search string patterns to all lowercase.  This means that if I want to use metadata.getColumns(null,null,tableName,"%") for example, the tableName will be converted to all lowercase, and will not match if my table names have any capital letters.  I tried quoting the table names, but that didn't work either.  I see no reason for the names to be converted to lower case, and it is extremely inconvenient to code a work-around for this.

Sample Code


No file was uploaded with this report


pgsql-bugs by date

Next:From: Hans SchouDate: 2001-08-14 22:58:34
Subject: linux-390-pgsql-7.1.2-make-check
Previous:From: Peter EisentrautDate: 2001-08-14 21:41:15
Subject: Re: -ltermcap needed for psql client build on OpenBSD 2.9

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