Re: Apparent Problem With NULL in Restoring pg_dump

On 9/15/2011 3:17 PM, Rich Shepard wrote:
> On Thu, 15 Sep 2011, Alban Hertroys wrote:
>
>> You appear to have two tabs after "Depth to Water", which would be one
>> too many.
>
> Alban,
>
> I thought that I had caught all the double tabs. Thanks for seeing this
> one.
>
> Now I'm back to the tabs-in-real-columns issue:
>
> ERROR: invalid input syntax for type real: " "
> CONTEXT: COPY chemistry, line 47364, column quant: " "
>
> and here's the referenced line:
>
> \N GW-22 2004-12-17 Calcium 9.69999981 mg/L
> \N \N \N \N
>
> Removing the extra tab between 'Calcium' and 9.69999981 produces:
>
> ERROR: invalid input syntax for type numeric: "N N"
> CONTEXT: COPY chemistry, line 47364, column northing: "N N"
>
> There must be a better way to clean this table, but I don't know what it
> is.
>
> Thanks again,
>
> Rich
>

Yeah... I think your emacs foo messed up the file.  You should have used
VIM!

just kidding... had to be done :-)

-Andy