scott.marlowe wrote:
> The attached file produces this problem. Note it's a blank trailing field
> that looks to be causing it. The error for this .sql file is:
>
> ERROR: literal carriage return found in data
> HINT: Use "\r" to represent carriage return.
> CONTEXT: COPY FROM, line 2
>
> Note that loading this into pico and saving it back out fixes the problem.
>
> If I remove the preceding row that doesn't end in a blank field, I get a
> different error, this one:
>
> ERROR: end-of-copy marker does not match previous newline style
> CONTEXT: COPY FROM, line 2
OK, 'vi' shows it as:
COPY people2 (id, persons) FROM stdin;
59 Chance Terry--S
60 ^M
\.
which is _exactly the case the error was supposed to catch. Now, the
big question is where did this dump come from? Pg version? OS platform?
--
Bruce Momjian | http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
