Following patches are against the current CVS version (HEAD) as of 2002-04-16.
Especially the current CVS version of DatabaseMetaData.getColumns() doesn't
work at all because the CVS version 1.50 of
org/postgresql/jdbc2/DatabaseMetaData.java has accidentally wiped out the row:
v.addElement(tuple);
- Panu
PS. Only the JDBC2 version was tested !!
---------------------------------------------------------------------------
--- org/postgresql/jdbc2/DatabaseMetaData.java.org Tue Apr 16 11:17:34 2002
+++ org/postgresql/jdbc2/DatabaseMetaData.java Tue Apr 16 11:32:12 2002
@@ -2053,12 +2053,12 @@
if ((tableNamePattern != null) && ! tableNamePattern.equals("%"))
{
- sql.append(" and c.relname like \'" + tableNamePattern + "\'");
+ sql.append(" and c.relname like \'" + tableNamePattern.toLowerCase() +
"\'");
}
if ((columnNamePattern != null) && ! columnNamePattern.equals("%"))
{
- sql.append(" and a.attname like \'" + columnNamePattern + "\'");
+ sql.append(" and a.attname like \'" + columnNamePattern.toLowerCase() +
"\'");
}
sql.append(
@@ -2146,6 +2146,7 @@
tuple[16] = r.getBytes(5); // ordinal position
tuple[17] = (nullFlag.equals("f") ? "YES" : "NO").getBytes(); // Is
nullable
+ v.addElement(tuple);
}
r.close();
--- org/postgresql/jdbc1/DatabaseMetaData.java.org Tue Mar 5 05:02:47 2002
+++ org/postgresql/jdbc1/DatabaseMetaData.java Tue Apr 16 11:45:15 2002
@@ -1953,12 +1953,12 @@
if ((tableNamePattern != null) && ! tableNamePattern.equals("%"))
{
- sql.append(" and c.relname like \'" + tableNamePattern +
"\'");
+ sql.append(" and c.relname like \'" +
tableNamePattern.toLowerCase() + "\'");
}
if ((columnNamePattern != null) && ! columnNamePattern.equals("%"))
{
- sql.append(" and a.attname like \'" + columnNamePattern
+ "\'");
+ sql.append(" and a.attname like \'" +
columnNamePattern.toLowerCase() + "\'");
}
sql.append(
