On Tue, 10 May 2005, Sergio Lob wrote:
Quote:
Bug reference: 1656
PostgreSQL version: 8.0.1
Description: ResultSetMetaData.getColumnDisplaySize() returns value
-1
Details:
ResultSetMetaData.getColumnDisplaySize() returns value -1 for several
columns of answer set generated by DatabaseMetaData.getTables() method. |
ResultSetMetaData.getColumnDisplaySize() returns -1 for any column that
has an unknown size. Consider the REMARKS column of getTables(). This
data comes from the system's pg_description.description column which is of
type "text". There is no defined length for this, so we have decided to
return -1.
Quote:
Additionally, I don't understand why the data type of column 1 is described
as "OTHER", as opposed to all the other columns, which are of type "VARCHAR"
(attained through ResultSetMetaData.getColumnType() method). |
TABLE_CAT is generated by an untyped "SELECT NULL", we should probably
cast this to name, or report the currently connected database name here.
Kris Jurka
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo (AT) postgresql (DOT) org)