Re: Help:updateRow() with CIDR types - Mailing list pgsql-jdbc

Moray Taylor wrote:
> Hi,
>
> I'm having some trouble updating CIDR types using jdbc, I use
> updateObject() to change it, which goes OK, but when I do an
> updateRow(), I get this error
>
> java.sql.SQLException: ERROR: invalid cidr value: "1.1.1.1/4"
>     at
> org.postgresql.jdbc2.AbstractJdbc2ResultSet.updateRow(AbstractJdbc2Resul
> tSet.java:1117)

What object type and SQL typecode are you passing to updateObject()? Can
we see that bit of code?

Turn on log_statement on the backend; what is the entire query that errors?

 From memory the driver doesn't really have support for CIDR types other
than as raw strings, but that might have changed..

-O