[MonetDB-users] copy into with primary key errors
I've been trying to bulk load a large set of data into a table with a compound primary key. Every time the copy into fails on the second file with an error about an "invalid input type". Even if I comment out the suspect file, the third file with have the same error. If I repeat the load and comment out the first file, then the third file will have the "invalid input type" error. Has anyone been able to use COPY INTO with a compound primary key and multiple files?
This looks like a bug. If I drop the primary key but
keep a unique index with the same columns the data
loads just fine.
The actual error is "ERROR =
!MALException:batmtime.EQ:Unexpected input type".
I'll get a test case together for a bug report.
--- Colin Foss
I've been trying to bulk load a large set of data into a table with a compound primary key.
Every time the copy into fails on the second file with an error about an "invalid input type". Even if I comment out the suspect file, the third file with have the same error.
If I repeat the load and comment out the first file, then the third file will have the "invalid input type" error.
Has anyone been able to use COPY INTO with a compound primary key and multiple files?
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net
participants (1)
-
Colin Foss