Received: from sss.pgh.pa.us ([192.204.191.242]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fAUFMIm92050 for ; Fri, 30 Nov 2001 10:22:19 -0500 (EST) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.4/8.11.4) with ESMTP id fAUFLpi07743; Fri, 30 Nov 2001 10:21:51 -0500 (EST) To: Oliver Vecernik cc: pgsql-admin@postgresql.org Subject: Re: locale question In-reply-to: <3C0788DE.9070004@aon.at> References: <3C0788DE.9070004@aon.at> Comments: In-reply-to Oliver Vecernik message dated "Fri, 30 Nov 2001 14:25:50 +0100" Date: Fri, 30 Nov 2001 10:21:51 -0500 Message-ID: <7740.1007133711@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200111/195 X-Sequence-Number: 2720 Oliver Vecernik writes: > ERROR: copy: line 1, Bad numeric input format '1018,11' > It seems the price with , is not recognized by psql, although LANG is set. IIRC, the only numerical datatype we have that allows locale-specific formatting is MONEY, which is deprecated for lack of sufficient range. I'm afraid you'll have to do some sed-hacking on your datafile. Sorry. regards, tom lane