Re: BUG #1656: ResultSetMetaData.getColumnDisplaySize()

On Tue, 10 May 2005, Sergio Lob wrote:

> 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.

> 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