Error in DatabaseMetaData.getColumns() with Views

From: Dario Fassi <dariovfassi(at)yahoo(dot)com(dot)ar>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Error in DatabaseMetaData.getColumns() with Views
Date: 2004-07-03 01:14:54
Message-ID: 40E6088E.6030703@yahoo.com.ar
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-jdbc pgsql-patches pgsql-sql

Hi, I wish 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 from DatabaseMetaData.

Any suggestion will be appreciated.
Best regards,
Dario Fassi

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Kris Jurka 2004-07-03 08:45:45 Re: Error in DatabaseMetaData.getColumns() with Views
Previous Message Edoardo Ceccarelli 2004-07-02 18:50:26 finding a max value

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kris Jurka 2004-07-03 08:45:45 Re: Error in DatabaseMetaData.getColumns() with Views
Previous Message Dave Cramer 2004-07-03 01:12:59 Re:

Browse pgsql-patches by date

  From Date Subject
Next Message Gavin Sherry 2004-07-03 06:18:13 Docs additions: tablespace examples
Previous Message Joe Conway 2004-07-02 19:01:44 Re: pg_tablespace_databases

Browse pgsql-sql by date

  From Date Subject
Next Message Kris Jurka 2004-07-03 08:45:45 Re: Error in DatabaseMetaData.getColumns() with Views
Previous Message George Siganos 2004-07-02 17:39:14 Re: Question about a CIDR based query