RE: Bug in JDBC driver V. 7.0 ?

I'll check. That one should be working...

--
Peter Mount
Enterprise Support
Maidstone Borough Council
Any views stated are my own, and not those of Maidstone Borough Council


-----Original Message-----
From: Anders Svensson [mailto:anders@simusoft.dk]
Sent: Thursday, July 20, 2000 3:53 PM
To: pgsql-interfaces@postgresql.org
Subject: [INTERFACES] Bug in JDBC driver V. 7.0 ?


When I call the method getTableTypes() in java.sql.DatabaseMetaData, 
all that's returned is:

SYSTEM INDEX.


The code for org.posgresql.DatabaseMetaData suggest that I should get at
least
  /**   * Get the table types available in this database.  The results   * are ordered by table type.   *   * <P>The
tabletype is:   *  <OL>   *    <LI><B>TABLE_TYPE</B> String => table type.  Typical types are
 
"TABLE",   *            "VIEW",    "SYSTEM TABLE", "GLOBAL TEMPORARY",   *            "LOCAL TEMPORARY", "ALIAS",
"SYNONYM".  *  </OL>   *   * @return ResultSet each row has a single String column that is a   * table type   */
 

but not the one (only) I get returned

snip:

java.sql.ResultSet rs = dbmd.getTableTypes ();

while (rs.next())  System.out.println(rs.getString(1));

just to rule out a codeing problem

-- 
Simu Soft
v/Anders Svensson
Nørrebrogade 140, 4 th
2200 København N
e-mail     : Anders@simusoft.dk
tlf.    : +45 3583 8126