Re: behavior of getTables() wrt capitalization of type

I had a look at the documentation, and it is suggested that the table
types s/b uppercase. Does anyone know what the correct answer is here?

Currently the driver only supports uppercase table types

Dave

-----Original Message-----
From: pgsql-jdbc-owner@postgresql.org
[mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of brian zimmer
Sent: Wednesday, January 09, 2002 1:54 AM
To: pgsql-jdbc@postgresql.org
Subject: [JDBC] behavior of getTables() wrt capitalization of type


Hello,

There seems to be a bug in DatabaseMetaData.getTables() with respect to
the capitalization of the values in the 'types' array.  I apologize for
not having the latest source, but I looked at some slightly older source
and found that there is an static final array of types (VIEW, TABLE,
...) and the corresponding sql clause to query it.  When the type values
are capitalized all works fine, but if they are not then the exception
below occurs.  It seems as though each value in the types array should
be capitalized when doing the comparison with the values in the static
final array.

I tried figuring it out dynamically through the various supports*() and
stores*() methods on DMD but only supportsMixedCaseIdentifiers()
returned true and from my testing this does not seem to be the case.  I
did download and test with the latest developer snapshot but the same
bug occurs.

Results from running the enclosed test case:

Attempting type [TABLE]
 table: zxtesting
SUCCESS with type [TABLE]

Attempting type [table]
 ERROR:  parser: parse error at or near ")"
FAILURE with type [table]

thanks,

brian