24 Oct
2016
24 Oct
'16
9:31 p.m.
On 24-10-16 23:06, Niels Nes wrote:
On Mon, Oct 24, 2016 at 10:58:28PM +0200, Eyal Rozenberg wrote:
In that case, how can I load an integer (not a varchar) field from a CSV where some lines are missing that field is occasionally missing? I was mistakenly assuming that if I interpreted the empty string as null, and specified a default value, I could essentially interpret the missing values
Simply remove the 'NOT NULL' constraint. If this is not possible you will need to load your data into a temporary table without this constraint.
Feature Request: https://www.monetdb.org/bugzilla/show_bug.cgi?id=6107 Eyal