Re: Apparent Problem With NULL in Restoring pg_dump [UPDATE]

On Thu, 15 Sep 2011, Rich Shepard wrote:

> It appears that this error is generated when a row has a missing value in
> the 'quant' column and the column contains '\N' in the text file. For
> example,
>
> \N GW-22 2005-03-09 Depth to Water \N Feet \N
> \N \N \N

Something strange is going on here. I moved the above line from row 47363
(within the COPY block) to row 2. This produced this error:

ERROR: extra data after last expected column
CONTEXT: COPY chemistry, line 2: "\N GW-22 2005-03-09 Depth to
Water \N Feet \N \N \N \N"

I created a blank line just beneath this one and entered the same data on
this new row, ensuring that there are no extra data after column #10. The
results are the same:

ERROR: extra data after last expected column
CONTEXT: COPY chemistry, line 2: "\N GW-22 2005-03-09 Depth to
Water \N Feet \N \N \N \N"

What could possibly be going on here? This row was not modified by me
after running pg_dump on the chemistry table, so why will it not be
restored?

Totally confused,

Rich