Received: from davisson.uni2.net (davisson.uni2.net [129.142.7.104]) by hub.org (8.10.1/8.10.1) with ESMTP id e6KErGh29974 for ; Thu, 20 Jul 2000 10:53:16 -0400 (EDT) Received: from [130.228.196.18] ([130.228.196.18]) by davisson.uni2.net (8.10.0/8.9.1) with ESMTP id e6KErEs25160 for ; Thu, 20 Jul 2000 16:53:14 +0200 Mime-Version: 1.0 X-Sender: anders$simusoft.dk@pop.simusoft.dk Message-Id: Date: Thu, 20 Jul 2000 16:53:07 +0200 To: "pgsql-interfaces@postgresql.org" From: Anders Svensson Subject: Bug in JDBC driver V. 7.0 ? Content-Type: text/plain; charset="iso-8859-1" ; format="flowed" Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by hub.org id e6KErGh29977 X-Archive-Number: 200007/168 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. * *

The table type is: *

    *
  1. TABLE_TYPE String => table type. Typical types are "TABLE", * "VIEW", "SYSTEM TABLE", "GLOBAL TEMPORARY", * "LOCAL TEMPORARY", "ALIAS", "SYNONYM". *
* * @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