Fixes for JDBC's getColumns() in Postgresql 7.2 & CVS

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(