Re: pgsql 8.0 beta1 patch for token and timezone

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Zhong Jacky <jackyzhongxp(at)msn(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: pgsql 8.0 beta1 patch for token and timezone
Date: 2004-08-29 03:13:38
Message-ID: 200408290313.i7T3Dc906587@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


I do not see a patch. Did you forget to attach it?

---------------------------------------------------------------------------

Zhong Jacky wrote:
> Hi pgsql-bugs,
>
> I'm a Chinese and I am using WinXp Chs to compile pgsql 8.0 beta 1
> in the MinGW environment. I found 2 bugs and fix them, maybe you can
> merge the patch into the offical release, thanks.
>
> Part A) Below is the two bugs occur when we run initdb under WinXp Chs.
>
> 1) FATAL: syntax error in file "E:/Unix/Sys/Pgsql/data/postgresql.conf"
>
> line 261, near token "s"
>
> Reason: the string 'Chinese_People's Republic of China.936' should be
> 'Chinese_People\'s Republic of China.936', otherwise token mismatch. Plese
> remember the regular expression like sed and awk under Unix.
>
> Patch: I wrote a function to detect ' in string and insert a \ symbol
>
> 2) WARNING: could not find a match for Windows timezone "??????"
>
> Reason: "??????" is the string stands for "China Standard
> Time",
> which shows in Chinese language.
>
> Patch: use a scanzone() function to find and convert timezone to the
> English string in win32_tzmap[]. I can fix only Chinese because I only have
> WinXp Chs operating system, people can fix others in similar way.
>
> Part B) You can visit these 2 websites for more detail and get patch.
> 1) http://blog.csdn.net/chaoyuebetter/archive/2004/08/13/73785.aspx
> 2) http://www.smth.edu.cn/bbsgcon.php?board=NewSoftware&num=2548
>
> Part C) The patch is based on snap0812, but can work on snap0825, etc.
>
> Regards,
> Jacky
>
> _________________________________________________________________
> ???? MSN Explorer: http://explorer.msn.com/lccn/
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2004-08-29 15:07:53 Re: [BUGS] server crash in very big transaction [postgresql
Previous Message Bruce Momjian 2004-08-29 02:59:22 Re: server crash in very big transaction [postgresql 8.0beta1]