Error in DatabaseMetaData TableColumn lenght.dec information - Mailing list pgsql-jdbc

From Dario V. Fassi
Subject Error in DatabaseMetaData TableColumn lenght.dec information
Date
Msg-id 40E6076C.30105@sistemat.com.ar
Whole thread Raw
Responses Re: Error in DatabaseMetaData TableColumn lenght.dec
List pgsql-jdbc
Hi, I whish to report a erroneous information returned by   DatabaseMetaData.getColumns()  method.

This happens with ResultSet's column (7) COLUMN_SIZE  and  (9) DECIMAL_DIGITS ,
when DatabaseMetaData.getColumns() inform about a VIEW with columns formed with :
coalesce , case or numeric operations over DECIMAL fields.

Suppose

CREATE TABLE A (  f1 DEC(6,3), f2 dec(6,3) );
CREATE VIEW B as ( select ( f1 + f2 ) as f from a;

Then DatabaseMetaData.getColumns() returns:

VIEW B
    F   NUMERIC(  65535 ,  -65531 )

This error its very molest because if you are trying to do CodeGeneration tools from DatabaseMetaData , you get lost.

Any suggestion will be appreciated.
Best regards,

    Dario V. Fassi


SISTEMATICA ingenieria de software  srl
Ituzaingo 1628  (2000)  Rosario, Santa Fe, Argentina.
Tel / Fax:  +54 (341) 485.1432 / 485.1353



pgsql-jdbc by date:

Previous
From: Dario Fassi
Date:
Subject: Error in DatabaseMetaData.getColumns() with Views
Next
From: tania gutierrez
Date:
Subject: error en coneccion a postgresql