Re: "Conversion of interval failed" on PGInterval with

From: Kris Jurka <books(at)ejurka(dot)com>
To: Jean-Pierre Pelletier <pelletier_32(at)sympatico(dot)ca>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: "Conversion of interval failed" on PGInterval with
Date: 2005-09-29 21:12:18
Message-ID: Pine.BSO.4.61.0509291610170.29679@leary.csoft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

On Thu, 29 Sep 2005, Jean-Pierre Pelletier wrote:

> I've got PSQLException "Conversion of interval failed"
> throwned when trying to read an interval larger than
> 100 hours (101:12:00) into a PGInterval object.
> It was running fine with the build 312 jdbc3 driver.
>

OK, this is because 8.1 has separated hours and days in an interval
definition, previously 100 hours turned into '4 days 4 hours', but in 8.1
it remains 100 hours. I'll look at a fix...

Kris Jurka

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kris Jurka 2005-09-29 21:14:22 Re: setObject(col, blob) throws PSQLException
Previous Message Jean-Pierre Pelletier 2005-09-29 20:45:17 "Conversion of interval failed" on PGInterval with 8.1dev-401.jdbc3.jar