Обсуждение: initdb problen
I successed to compile and run PostgreSQL for mingw but bootstrap_template1 function in initdb.c made a problem to locale. In PostgeSQL, if value of LC_COLLATE is not C then sortting is not work when use korean language. I used this command to make db. initdb -D data --no-locale this command successed. but pg_controldata command returned incorrect values. LC_COLLATE: Korean_Korea.949 LC_CTYPE: Korean_Korea.949 My windows box is korean XP. How I can change above these values to C?
This bug is about setlocale function in win32. please check and fix.
What if you instead try: initdb --locale=C Looks like "--no-locale" is not "equivalent to --locale=C", at least under win32. Cheers, Claudio > -----Original Message----- > From: Korea PostgreSQL Users' Group [mailto:pgsql-kr@postgresql.or.kr] > Sent: Friday, 12 March 2004 5:30 PM > To: pgsql-hackers-win32@postgresql.org > Subject: [pgsql-hackers-win32] initdb problen > > > I successed to compile and run PostgreSQL for mingw > but > bootstrap_template1 function in initdb.c made a problem to locale. > > In PostgeSQL, > if value of LC_COLLATE is not C > then sortting is not work when use korean language. > > I used this command to make db. > > initdb -D data --no-locale > > this command successed. > but pg_controldata command returned incorrect values. > > LC_COLLATE: Korean_Korea.949 > LC_CTYPE: Korean_Korea.949 > > My windows box is korean XP. > > How I can change above these values to C? > ---------------------------(end of > broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org > --- Certain disclaimers and policies apply to all email sent from Memetrics. For the full text of these disclaimers and policies see <a href="http://www.memetrics.com/emailpolicy.html">http://www.memetrics.com/em ailpolicy.html</a>
it works still problem. setlocale() function is not equivalent between unix and win32 plz check. multibyte text is not sorted. ----- Original Message ----- From: "Claudio Natoli" <claudio.natoli@memetrics.com> To: "'Korea PostgreSQL Users' Group'" <pgsql-kr@postgresql.or.kr>; <pgsql-hackers-win32@postgresql.org> Sent: Friday, March 12, 2004 5:04 PM Subject: RE: [pgsql-hackers-win32] initdb problen > What if you instead try: > > initdb --locale=C > > Looks like "--no-locale" is not "equivalent to --locale=C", at least under > win32. > > Cheers, > Claudio > >
the answer is very probably here: http://archives.postgresql.org/pgsql-hackers-win32/2003-10/msg00024.php I thought Bruce said he had this covered, but it hasn't been fixed. I will prepare a patch in the next day or so if someone else doesn't beat me to it. cheers andrew Korea PostgreSQL Users' Group wrote: >it works still problem. > >setlocale() function is not equivalent between unix and win32 > >plz check. > >multibyte text is not sorted. > > >----- Original Message ----- >From: "Claudio Natoli" <claudio.natoli@memetrics.com> >To: "'Korea PostgreSQL Users' Group'" <pgsql-kr@postgresql.or.kr>; <pgsql-hackers-win32@postgresql.org> >Sent: Friday, March 12, 2004 5:04 PM >Subject: RE: [pgsql-hackers-win32] initdb problen > > > > >>What if you instead try: >> >>initdb --locale=C >> >>Looks like "--no-locale" is not "equivalent to --locale=C", at least under >>win32. >> >>Cheers, >>Claudio >> >> >> >> > >---------------------------(end of broadcast)--------------------------- >TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly > > >
Andrew Dunstan wrote: > > the answer is very probably here: > http://archives.postgresql.org/pgsql-hackers-win32/2003-10/msg00024.php > > I thought Bruce said he had this covered, but it hasn't been fixed. I > will prepare a patch in the next day or so if someone else doesn't beat > me to it. Sorry, I don't remember this issue. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073