I have a (hopefully simple) question regarding locale.
I am migrating a postgresql database from a server running FC1 &
PostgreSQL 7.4 to a newer machine running FC2 and PostgreSQL 8.0. I
dumped the data from the old server using pg_dumpall and restored it to
the new server with no problems, an
Oliver Vecernik <[EMAIL PROTECTED]> 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 l
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: resettin
