Can you please file a bug report on this at bugs.monetdb.org? Thanks. On 12/24/2014 06:46 AM, Tim Burress wrote:
Hello,
I'm using MonetDB Oct2014-SP1 and have run into another problem with the inet datatype. When the data value is a network specification (address + prefix length in CIDR notation), it is possible to insert/update values using INSERT or UPDATE, but COPY INTO fails. For example, the following works fine:
create "testing" ( network inet ); insert into "testing" values('192.168.0.1/24');
However if you create a file for bulk loading:
copy 1 records into "sys"."testing" from stdin using delimiters '\t','\n','"' 192.168.0.1
and then try to load it, it fails:
mclient -d test
It seems like the parser for COPY INTO has a problem. Thus, among other things, it's impossible to use msqldump to save the content of a table and then restore it.
This also has big impact on my application at least, since individual inserts take much longer than COPY INTO.
Just thought I'd let you know!
Tim
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
-- Sjoerd Mullender