Skip site navigation (1) Skip section navigation (2)

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

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: OU <moebius444_mapson(at)hotmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #1218: COPY usage in script with CR/LF invoking from
Date: 2004-08-16 00:18:28
Message-ID: 200408160018.i7G0ISS28697@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
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(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(dot)pa(dot)us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

In response to

pgsql-bugs by date

Next:From: Bruce MomjianDate: 2004-08-16 01:28:37
Subject: Re: 8.0: Absolute path required for INITDB?
Previous:From: Andreas PflugDate: 2004-08-15 21:33:38
Subject: Re: postgresql 8 (pgAdminIII) crashes when login form X is

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group