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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
