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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs pgsql-jdbc pgsql-patches pgsql-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.
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Meskes | 2004-07-05 18:55:09 | Re: [CHECKER] 4 memory leaks in Postgresql 7.4.2 |
Previous Message | Dario V. Fassi | 2004-07-05 01:10:50 | Re: [JDBC] Error in DatabaseMetaData.getColumns() with Views |
From | Date | Subject | |
---|---|---|---|
Next Message | Oliver Jowett | 2004-07-05 03:16:22 | patch: complain obviously about unknown transaction states |
Previous Message | Dario V. Fassi | 2004-07-05 01:10:50 | Re: [JDBC] Error in DatabaseMetaData.getColumns() with Views |
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2004-07-05 02:18:04 | Re: [HACKERS] Compile failure in plperl |
Previous Message | Michael Glaesemann | 2004-07-05 01:19:44 | Type typo in parameter of pgsql function |
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Huxton | 2004-07-05 11:34:04 | Re: Why no exprs in format string to RAISE |
Previous Message | Dario V. Fassi | 2004-07-05 01:10:50 | Re: [JDBC] Error in DatabaseMetaData.getColumns() with Views |