Обсуждение: 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.
Murali Doss napsal(a): > 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 > Lc_collate and lc_ctype are possible setup only in initdb phase. see initdb --help or http://www.postgresql.org/docs/8.2/interactive/app-initdb.html More detail you can get on http://www.postgresql.org/docs/8.2/interactive/locale.html Please, this kind of question send to the general mailing list. This list is for bug reporting. Thanks Zdenek
On Wed, Jun 20, 2007 at 12:51:57PM +0000, Murali Doss wrote: > How to change the pg_setting from en_US.UTF-8 to "C". You need to set up your locale before doing initdb. This is covered in the manual. It's also not a bug, so it'd be nice if you stopped posting this to the bugs list. Use pgsql-novice instead, I think. A -- Andrew Sullivan | ajs@crankycanuck.ca Everything that happens in the world happens at some place. --Jane Jacobs