Hello,
I have an INSERT which does not behave the same under jdbc and psql.
With psql, INSERTing a poperly formed VARCHAR into an inet column
would work, eg.:
=# \d user_record;
Table "user_record"
Column | Type | Modifiers
----------------------+------------------------+-----------
id | integer |
username | character varying(64) |
registered_ip | inet |
INSERT INTO user_record (0, 'abc', '127.0.0.1') is valid and works.
The string is automagically casted as an inet value.
Using jdbc, this is not the case, and causes me loads of trouble (and
exceptions).
Is there a way around it?
I do not have access to the java source code, there is thus no way to
update the code to programatically force a CAST.
Thanks for any help,
Guillaume