From: | S Arvind <arvindwill(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Locale problem |
Date: | 2010-03-20 05:58:21 |
Message-ID: | abf9211d1003192258h5e8d9792x883c766a46a1b2c9@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello PG support,
Recently i am facing locale problem in postgres 8.3. In my home
machine i have 8.4 which have db schema as
CREATE DATABASE impulse_travel
WITH OWNER = postgres
ENCODING = 'UTF8'
LC_COLLATE = 'English_India.1252'
LC_CTYPE = 'English_India.1252'
CONNECTION LIMIT = -1;
But in production server we are limited to postgres 8.3 only. So while
creating db i cant able to provide LC_COLLATE , LC_CTYPE . So i did initdb
"initdb -W --locale=en_IN --lc-collate=en_IN --lc-ctype=en_IN
--lc-messages=en_IN --lc-monetary=en_IN --lc-numeric=en_IN --lc-time=en_IN
-D /var/lib/pgsql/data4" but even then it seems it doesnt set.
I used test query as
select 'Rs.6,000.00'::money;
this returns value in home pgsql 8.4 server but in the production server it
throws error as
template1=# select 'Rs.6,000.00'::money;
ERROR: invalid input syntax for type money: "Rs.6,000.00"
I want to know whether it is possible in postgres 8.3 and if yes where i
went wrong?
Thanks in advance,
Arvind S
"Many of lifes failure are people who did not realize how close they were to
success when they gave up."
-Thomas Edison
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas Kretschmer | 2010-03-20 07:13:03 | Re: Help me with this tricky join |
Previous Message | Pavel Stehule | 2010-03-20 05:06:54 | Re: returns 0 row from plpgsql function |