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