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
