Re: Fwd: Diffrence between 8.0.3 and 8.1.3 - Mailing list pgsql-jdbc

From Yann PICHOT
Subject Re: Fwd: Diffrence between 8.0.3 and 8.1.3
Date
Msg-id 6ff7932d0607060617mda3ffb4sffdc8af30878a5eb@mail.gmail.com
Whole thread Raw
In response to Re: Fwd: Diffrence between 8.0.3 and 8.1.3  (Kris Jurka <books@ejurka.com>)
List pgsql-jdbc


2006/7/5, Kris Jurka <books@ejurka.com>:


On Wed, 5 Jul 2006, Yann PICHOT wrote:

> When i use this SQL request : SELECT col1, cast(' ' as varchar(3)) as mycol
> FROM mytable, getColumnDisplaySize return -5.
> When i use this SQL request : SELECT col1, cast(' ' as varchar(3)) as mycol,
> getColumnDisplaySize return 3 !!!!
>

OK, I misunderstood your test case and was only looking at the second
version which works.  As you noted earlier the server is responding with a
different typmod value, so this is not a JDBC problem, but a server
regression and I've forwarded this on to the -bugs list.  To summarize for
them:

In 8.0 "SELECT ' '::varchar(3) FROM tab" retained the typmod value
specified in the query, but in 8.1 it is lost and -1 is used instead.

Kris Jurka


Thanks, i'll follow the problem in the bug list.

--
Yann

pgsql-jdbc by date:

Previous
From: Kris Jurka
Date:
Subject: Re: JDBC Driver for Postgres. I add a little cache for al less lot
Next
From: "Sebastien DIAZ"
Date:
Subject: JDBC Driver for Postgres. I add a little cache for al less lot of Metadata request