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

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