Thread: BUG #1218: COPY usage in script with CR/LF invoking from psql break after '\.'

The following bug has been logged online:

Bug reference:      1218
Logged by:          OU

Email address:      moebius444_mapson@hotmail.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;

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@hotmail.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@postgresql.org)
>

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