From: | Alban Hertroys <haramrae(at)gmail(dot)com> |
---|---|
To: | Rich Shepard <rshepard(at)appl-ecosys(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Apparent Problem With NULL in Restoring pg_dump |
Date: | 2011-09-15 20:09:07 |
Message-ID: | 8DEAECFB-957E-46DA-84D0-A1504CDAC66E@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 15 Sep 2011, at 19:31, Rich Shepard wrote:
> The .sql file produced by pg_dump is properly terminated with '\.' as the
> last line, yet I continue to encounter this error:
>
> ERROR: invalid input syntax for type real: " "
> CONTEXT: COPY chemistry, line 47363, column quant: " "
>
> when trying to re-create the table.
>
> 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
>
> (It is a single line in emacs but wraps in alpine.)
You appear to have two tabs after "Depth to Water", which would be one too many.
Alban Hertroys
--
The scale of a problem often equals the size of an ego.
From | Date | Subject | |
---|---|---|---|
Next Message | Rich Shepard | 2011-09-15 20:10:56 | Re: Apparent Problem With NULL in Restoring pg_dump |
Previous Message | Andy Colson | 2011-09-15 20:08:20 | Re: Apparent Problem With NULL in Restoring pg_dump |