PostgreSQL JDBC - Re: "Conversion of interval failed" on PGInterval with

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Re: "Conversion of interval failed" on PGInterval with

Kris Jurka

2005-09-29, 8:24 pm

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

Sponsored Links