Skip site navigation (1) Skip section navigation (2)

Re: [JDBC] Error in DatabaseMetaData.getColumns() with Views

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: Kris Jurka <books(at)ejurka(dot)com>
Cc: "Dario V(dot) Fassi" <software(at)sistemat(dot)com(dot)ar>,pgsql-jdbc(at)postgresql(dot)org, pgsql-bugs(at)postgresql(dot)org,pgsql-sql(at)postgresql(dot)org
Subject: Re: [JDBC] Error in DatabaseMetaData.getColumns() with Views
Date: 2004-07-04 22:51:21
Message-ID: 20040704153840.Y52747@megazone.bigpanda.com (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-jdbcpgsql-patchespgsql-sql
On Sun, 4 Jul 2004, Kris Jurka wrote:

> On Sat, 3 Jul 2004, Dario V. Fassi wrote:
>
> > In the sample adjunct, you can see that error arise at the time when the
> > view's sql text is parsed and saved in database catalog.
> > Then generic NUMERIC type is forced for every calculated column without
> > regard or precision.
> > And at execute time the f2 column has varying type decimals (in row 2
> > you can see 4 decimals and in other rows has 3 decimals), this is not a
> > behavior , this is an ERROR.

[Jumping in, because this was the first message of the thread I've seen]

Technically, the correct behavior by spec would be an
implementation-defined precision and a particular scale based on the
argument scales. So, having numeric(6,2)+numeric(6,2) return
numeric(65535, 2) is fine. Returning numeric(65535, 65531) isn't
technically, but I don't think this is an issue in the jdbc metadata
getting as much as an issue in the database proper.


In response to

Responses

pgsql-sql by date

Next:From: Dario V. FassiDate: 2004-07-04 23:28:02
Subject: Re: [JDBC] Error in DatabaseMetaData.getColumns() with Views
Previous:From: Markus BertheauDate: 2004-07-04 21:21:53
Subject: Why no exprs in format string to RAISE

pgsql-jdbc by date

Next:From: Dario V. FassiDate: 2004-07-04 23:28:02
Subject: Re: [JDBC] Error in DatabaseMetaData.getColumns() with Views
Previous:From: Dario V. FassiDate: 2004-07-04 20:58:17
Subject: Re: [JDBC] Error in DatabaseMetaData.getColumns() with Views

pgsql-bugs by date

Next:From: Dario V. FassiDate: 2004-07-04 23:28:02
Subject: Re: [JDBC] Error in DatabaseMetaData.getColumns() with Views
Previous:From: Dario V. FassiDate: 2004-07-04 20:58:17
Subject: Re: [JDBC] Error in DatabaseMetaData.getColumns() with Views

pgsql-patches by date

Next:From: Dario V. FassiDate: 2004-07-04 23:28:02
Subject: Re: [JDBC] Error in DatabaseMetaData.getColumns() with Views
Previous:From: Andrew DunstanDate: 2004-07-04 22:04:01
Subject: Re: [HACKERS] Compile failure in plperl

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group