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

#1

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:

Quote:

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.pa.us | (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 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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

mailing.database.pgsql-bugs mailing.database.pgsql-bugs

Re: [BUGS] BUG #1218: COPY usage in script with CR/LF invoking from - 08-15-2004 , 07:19 PM