View Single Post

   
  #1 (permalink)  
Old 04-15-2008, 11:39 PM
Kris Jurka
 
Posts: n/a
Default Re: "Conversion of interval failed" on PGInterval with



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

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Reply With Quote