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(at)simusoft(dot)dk]
Sent: Thursday, July 20, 2000 3:53 PM
To: pgsql-interfaces(at)postgresql(dot)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 table type 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(at)simusoft(dot)dk
tlf. : +45 3583 8126