Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 25CDA475FC5
	for <pgsql-sql@postgresql.org>; Wed, 11 Dec 2002 13:59:09 -0500 (EST)
Received: from email01.aon.at (WARSL402PIP3.highway.telekom.at [195.3.96.97])
	by postgresql.org (Postfix) with SMTP id 4FF40475F5E
	for <pgsql-sql@postgresql.org>; Wed, 11 Dec 2002 13:59:08 -0500 (EST)
Received: (qmail 342496 invoked from network); 11 Dec 2002 18:59:07 -0000
Received: from m155p014.dipool.highway.telekom.at (HELO cantor) ([62.46.9.78])
	(envelope-sender <mkoi-pg@aon.at>)
	by qmail1rs.highway.telekom.at (qmail-ldap-1.03) with SMTP
	for <mzmaxmail@libero.it>; 11 Dec 2002 18:59:07 -0000
From: Manfred Koizar <mkoi-pg@aon.at>
To: "mzmaxmail@libero.it" <mzmaxmail@libero.it>
Cc: "pgsql-sql" <pgsql-sql@postgresql.org>
Subject: Re: error in copy table from file
Date: Wed, 11 Dec 2002 19:59:00 +0100
Message-ID: <gm2fvuk830v2d3jmft1575fha32igrja2t@4ax.com>
References: <H6YUG0$F8E94BAAD19150F488C52E174AF2FFB7@libero.it>
In-Reply-To: <H6YUG0$F8E94BAAD19150F488C52E174AF2FFB7@libero.it>
X-Mailer: Forte Agent 1.8/32.548
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200212/136
X-Sequence-Number: 10724

On Wed, 11 Dec 2002 18:40:48 +0100, "mzmaxmail@libero.it"
<mzmaxmail@libero.it> wrote:
>copy table from 'path/file' using delimiters ';'
>
>it returns the following:
>
>'RROR:  copy: line 1, Bad float8 input format '-0.123
 ^
This belongs to the end of the error message.  Finding it here at the
beginning of the line makes me think your file has DOS style end of
lines (CR/LF).  Convert them to Unix style (LF only).

Servus
 Manfred