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