"James Moe" <[EMAIL PROTECTED]> writes:
> this bizarre error message is produced in psql:

> ": can't parse "ne 1, pg_atoi: error in "1

That's unrelated to your NULL issue.  It looks like you have
Windows-style newlines (\r\n) in your data.  COPY only likes
Unix-style newlines (\n).  It thinks the \r is a data character.

I think this is finally relaxed for 7.4, but in all current releases
you need to get rid of the carriage return characters.

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Reply via email to