BUG #3397: change the pg_setting

The following bug has been logged online:

Bug reference:      3397
Logged by:          Murali Doss
Email address:      murali.doss@mphasis.com
PostgreSQL version: 8.1.8
Operating system:   Linux
Description:        change the pg_setting
Details:

Dear All,

How to change the pg_setting from en_US.UTF-8 to "C".

lc_collate    - en_US.UTF-8
lc_ctype    - en_US.UTF-8
lc_messages    - en_US.UTF-8
lc_monetary    - en_US.UTF-8
lc_numeric    - en_US.UTF-8
lc_time    - en_US.UTF-8

Regards
Murali Doss T.S.