I believe the issue with misparsing of floats/doubles/etc has
been correctly identified as a locale issue and *incorrectly*
identified as a carriage-return/linefeed issue.
Somewhere I thought I saw Bruce say that it's already fixed...
From 7.3b2, psql as started:
rovero=# show lc_numeric
rovero-# ;
lc_numeric
-------------
en_US.UTF-8
Copy of floats in "236.555" format will fail.
Copy of floats in "236,555" format works.....
rovero=# set lc_numeric='C';
SET
rovero=# show lc_numeric;
lc_numeric
------------
C
Copy of floats in "235.555" format works.....
--
P. J. "Josh" Rovero Sonalysts, Inc.
Email: rovero@sonalysts.com www.sonalysts.com 215 Parkway North
Work: (860)326-3671 or 442-4355 Waterford CT 06385
***********************************************************************