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 ?