The following bug has been logged online: Bug reference: 5818 Logged by: yulei Email address: yu...@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 ? -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
