Received: from news.tht.net (news.hub.org [216.126.91.242]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fAUDcjm85825 for ; Fri, 30 Nov 2001 08:38:45 -0500 (EST) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.4/8.11.4) id fAUDRAi17625 for pgsql-admin@postgresql.org; Fri, 30 Nov 2001 08:27:10 -0500 (EST) (envelope-from news) From: Oliver Vecernik X-Newsgroups: comp.databases.postgresql.admin Subject: locale question Date: Fri, 30 Nov 2001 14:25:50 +0100 Organization: Hub.Org Networking Services (http://www.hub.org) Lines: 21 Message-ID: <3C0788DE.9070004@aon.at> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: scrappy@hub.org User-Agent: Mozilla/5.0 (X11; U; Linux i686; de-AT; rv:0.9.4) Gecko/20010923 X-Accept-Language: de-AT, en To: pgsql-admin@postgresql.org X-Archive-Number: 200111/193 X-Sequence-Number: 2718 Hi, I've got SuSE 7.3 with PostgreSQL 7.1.3 server an a system where LANG=de_DE@euro. I tried to import some data with: \copy im from '/usr/share/data/pricelist.csv' using delimiters '|' and got following message: \. ERROR: copy: line 1, Bad numeric input format '1018,11' PQendcopy: resetting connection It seems the price with , is not recognized by psql, although LANG is set. Can I check if PostgreSQL was compiled --with-locale option (I believe it is after checking the Source RPM)? Can anybody give me a hint? Best Regards, Oliver