newsdev/elex-loader

Error loading results w/ postgres COPY

Closed this issue · 2 comments

jeremyjbowers commented 
Mar 23 01:01:08 int-elex-prd-east elex-loader-stderr.log:  ERROR:  unquoted newline found in data
Mar 23 01:01:08 int-elex-prd-east elex-loader-stderr.log:  HINT:  Use quoted CSV field to represent newline.
Mar 23 01:01:08 int-elex-prd-east elex-loader-stderr.log:  CONTEXT:  COPY results, line 165
jeremyjbowers commented

Something about the districts CSV is making Postgres upset. At least it fails nicely?

jeremyjbowers commented

Using \r instead of \n as the delimiter made our Postgres upset. Fixed with a patch to Elex.