Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group