Dave Barnett (dave(at)lions(dot)med(dot)jhu(dot)edu) reports a bug with a severity of 2
The lower the number the more severe it is.
JDBC driver DatabaseMetaData.getTables() unconditionally lowercases tableName pattern
According to Chapter 2 of the User's Guide, NAMES may be quoted to preserve case. In the JDBC driver found in Postgres 7.0.2, jdbc2/DatabaseMetaData.java repeatedly converts the name pattern automatically to lowercase. Removing these improper conversions provides usable behavior.
I think the driver shouldn't be doing anything to the pattern, so that the user may handle case conversions as needed. Alternatively, the driver should simply not be doing this in the case that it is quoted.
1. modify driver code and recompile driver
2. provide a '%' tableName pattern and sift through all the tables in user code checking for proper matches
No file was uploaded with this report
pgsql-bugs by date
|Next:||From: thil||Date: 2000-11-13 21:42:46|
|Subject: libpq dependencies in redhat binary rpm|
|Previous:||From: Tom Lane||Date: 2000-11-13 15:37:41|
|Subject: Re: Security problem in psql frontends |