BUG #5818: initdb lose the single quote of locale - Mailing list pgsql-bugs

From yulei
Subject BUG #5818: initdb lose the single quote of locale
Date
Msg-id 201101070642.p076ggoG059006@wwwmaster.postgresql.org
Whole thread Raw
Responses Re: BUG #5818: initdb lose the single quote of locale
Re: BUG #5818: initdb lose the single quote of locale
List pgsql-bugs
The following bug has been logged online:

Bug reference:      5818
Logged by:          yulei
Email address:      yu1ei@hotmail.com
PostgreSQL version: 9.0.2
Operating system:   Windows XP Service Pack 3
Description:        initdb lose the single quote of locale
Details:

Hi,dear developers!
I am using a chinses window xp os.
i run "initdb -E UTF-8 -D temp" in cmd,it can get the
locale:"Chinese_People's Republic of China.936"。

but when initdb  creating template1 , it lose the single quote of locale,it
use "Chinese_Peoples Republic of China.936"(notice that , it lose the '
after "Chinese_People" ) for the "template1" record's
“datcollate”,“datctype” Column in tablepg_database。

though "creating template1 database" is ok,but the initdb's next step
"initializing pg_authid ..." failed.
bucause the invalid locale "Chinese_People's Republic of China.936" is used
to run the command "REVOKE ALL on pg_authid FROM public;"。

and the cmd resule is :
creating template1 database in temp/base/1 ... ok
initializing pg_authid ... :  ݿʹõԻͲϵͳIJ
ϸϢ:  ݿ⼯Ⱥ LC_COLLATE "Chinese_Peoples Re
ʾ:  һԻ´ݿ⣬߰װʧԻ.
child process exited with exit code 1
initdb: removing data directory "temp"。

to support what i say , i test like:
add "
create pg_database_test 5158 ( datname = name )
open pg_database_test
insert OID = 1 ( "Chinese_People's Republic of China.936")
close pg_database_test
"
 to postgreSQLHOME/share/postgres.bki

run cmd "initdb -E UTF-8 -D temp --local=chs"

it can init successful,then i start the server,run sql:
"SELECT * from pg_database_test" ,the result show "Chinese_Peoples Republic
of China.936".
yes ,the single quote of test string "Chinese_People's Republic of
China.936" lose.

can you fix it ?

pgsql-bugs by date:

Previous
From: Gabe Nell
Date:
Subject: Re: BUG #5807: psql fails to launch with "Cannot read termcap database; using dumb terminal settings. Aborted"
Next
From: "yulei"
Date:
Subject: BUG #5819: Translation Error of initdb's zh_CN.po