The following bug has been logged online:
Bug reference: 1218
Logged by: OU
Email address: [EMAIL PROTECTED]
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 [EMAIL PROTECTED])
