| 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: | Whole Thread | Raw Message | 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
| 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 |
| 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: |
| 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 |
| 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 |