Re: BUG #1218: COPY usage in script with CR/LF invoking from

Yea, we just found this failure and the fix will be in beta2 and is in
CVS now. To work around it, convert it to unix newlines.

---------------------------------------------------------------------------

PostgreSQL Bugs List wrote:
>
> The following bug has been logged online:
>
> Bug reference: 1218
> Logged by: OU
>
> Email address: moebius444_mapson(at)hotmail(dot)com
>
> PostgreSQL version: 8.0 Beta
>
> Operating system: Windows XP
>
> Description: COPY usage in script with CR/LF invoking from psql break
> after '\.'
>
> Details:
>
> My Pg version: PostgreSQL 8.0.0beta1 on i686-pc-mingw32...
> runs on wxp.
>
> Running the following content in a script with CR/LF by a '\i script_name'
> call in psql returns nothing (ok with LF):
>
> =========8<-----------------------------------
> CREATE TABLE test (
> id INTEGER NOT NULL DEFAULT 0,
> value INTEGER NOT NULL DEFAULT 0
> );
>
> COPY test FROM STDIN;
> 1 0
> 2 0
> \.
>
> SELECT count(*) FROM test;
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073