Re: locale question

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Oliver Vecernik <vecernik(at)aon(dot)at>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: locale question
Date: 2001-11-30 15:21:51
Message-ID: 7740.1007133711@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Oliver Vecernik <vecernik(at)aon(dot)at> 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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Mike Smialek 2001-11-30 16:23:02 case sensititvity bug in foreign keys on cygwin
Previous Message Brian McCane 2001-11-30 14:52:37 Re: table test