From: Stephan Szabo <sszabo@megazone.bigpanda.com>
To: Dario V. Fassi <software@sistemat.com.ar>
Cc: Kris Jurka <books@ejurka.com>
Cc: pgsql-jdbc@postgresql.org
Cc: pgsql-bugs@postgresql.org
Cc: pgsql-sql@postgresql.org
Subject: Re: [JDBC] Error in DatabaseMetaData.getColumns() with Views
Date: Sun, 4 Jul 2004 18:41:29 -0700 (PDT)
Message-ID: <20040704183143.O56951@megazone.bigpanda.com> (raw)
In-Reply-To: <40E8AA9A.7020806@sistemat.com.ar>
References: <40E6088E.6030703@yahoo.com.ar>
<Pine.BSO.4.56.0407030343090.19721@leary.csoft.net>
<40E6E7AF.5020306@sistemat.com.ar>
<40E6FD7F.50801@sistemat.com.ar>
<Pine.BSO.4.56.0407041330180.26773@leary.csoft.net>
<20040704153840.Y52747@megazone.bigpanda.com>
<40E89282.9060306@sistemat.com.ar>
<20040704173258.Y55353@megazone.bigpanda.com>
<40E8AA9A.7020806@sistemat.com.ar>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: sszabo@megazone.bigpanda.com, software@sistemat.com.ar, books@ejurka.com, pgsql-jdbc@postgresql.org, pgsql-bugs@postgresql.org
Subject: Re: [JDBC] Error in DatabaseMetaData.getColumns() with Views
In-Reply-To: <20040704183143.O56951@megazone.bigpanda.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox