Locale problem

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

Browse pgsql-general by date

  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