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: [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]) > -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (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
