locale question - Mailing list pgsql-admin

From Oliver Vecernik
Subject locale question
Date
Msg-id 3C0788DE.9070004@aon.at
Whole thread Raw
Responses Re: locale question
List pgsql-admin
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


pgsql-admin by date:

Previous
From: "Nick Fankhauser"
Date:
Subject: Re: table test
Next
From: Brian McCane
Date:
Subject: Re: table test