On Fri, Jan 7, 2011 at 1:42 AM, yulei <yu...@hotmail.com> wrote: > > 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 ?
I don't see any responses to this bug. Do we have a quoting problem somewhere? -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
