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: "Dario V(dot) Fassi" <software(at)sistemat(dot)com(dot)ar>
Cc: Kris Jurka <books(at)ejurka(dot)com>, 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-05 01:41:29
Message-ID: 20040704183143.O56951@megazone.bigpanda.com (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-jdbcpgsql-patchespgsql-sql
On Sun, 4 Jul 2004, Dario V. Fassi wrote:

> Stephan, look at the samples I send in previous posts , from PgSql and Db2.

I don't see any samples apart from the original view descriptions and the
getColumns results.  I see some implication about db2 but no details.  My
guess is that the messages are more recent than the last archives update
and since I'm not on -jdbc I wouldn't have seen them.  That's pretty much
why I asked.

> I know it's a no ease task to change all that behavior , but you must
> agree that a Numeric column with the fractional part varing from row to
> row are different data types and break relational rules.

Maybe, but without seeing the example, it's hard to say.  For example,
your views from the head of what I see for this on archives, consistently
give me output with a scale of 3.

In addition, PostgreSQL provides a numeric with effectively undefined
precision and scale. This is a non-conforming definition, but means that
while the number of digits after the decimal are different, it's the same
type, numeric with undefined precision and scale.


In response to

pgsql-sql by date

Next:From: Richard HuxtonDate: 2004-07-05 11:34:04
Subject: Re: Why no exprs in format string to RAISE
Previous:From: Dario V. FassiDate: 2004-07-05 01:10:50
Subject: Re: [JDBC] Error in DatabaseMetaData.getColumns() with Views

pgsql-jdbc by date

Next:From: Oliver JowettDate: 2004-07-05 03:16:22
Subject: patch: complain obviously about unknown transaction states
Previous:From: Dario V. FassiDate: 2004-07-05 01:10:50
Subject: Re: [JDBC] Error in DatabaseMetaData.getColumns() with Views

pgsql-bugs by date

Next:From: Michael MeskesDate: 2004-07-05 18:55:09
Subject: Re: [CHECKER] 4 memory leaks in Postgresql 7.4.2
Previous:From: Dario V. FassiDate: 2004-07-05 01:10:50
Subject: Re: [JDBC] Error in DatabaseMetaData.getColumns() with Views

pgsql-patches by date

Next:From: Bruce MomjianDate: 2004-07-05 02:18:04
Subject: Re: [HACKERS] Compile failure in plperl
Previous:From: Michael GlaesemannDate: 2004-07-05 01:19:44
Subject: Type typo in parameter of pgsql function

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