[HACKERS] Winner of naming discussions: Synchronous Commit

2007-06-24 Thread Simon Riggs
Thank you to everyone for input on the naming of Feature X. The clear winner of the parameter naming was synchronous_commit, which would imply we refer to the new feature as Asynchronous Commit in the release notes and general discussions. I will be now be starting to make changes throughout the

Re: [HACKERS] Bugtraq: Having Fun With PostgreSQL

2007-06-24 Thread Tom Lane
Steve Atkins [EMAIL PROTECTED] writes: On Jun 23, 2007, at 11:03 AM, Magnus Hagander wrote: Out of curiosity, how do other databases deal with this? MySQL installs with an empty root password for access from localhost or the machines own IP address. It also installs an account with network

[HACKERS] msvc and vista fun

2007-06-24 Thread Andrew Dunstan
I am still very unhappy about the way the MSVC builds work. Although we have managed to make it sort of work with the buildfarm script, it is distinctly fragile. Last night, for example, I had a build failure due to a badly installed zlib. The error state didn't come back to the buildfarm

Re: [HACKERS] Bugtraq: Having Fun With PostgreSQL

2007-06-24 Thread Andrew Dunstan
Tom Lane wrote: Steve Atkins [EMAIL PROTECTED] writes: On Jun 23, 2007, at 11:03 AM, Magnus Hagander wrote: Out of curiosity, how do other databases deal with this? MySQL installs with an empty root password for access from localhost or the machines own IP address. It

Re: [HACKERS] msvc and vista fun

2007-06-24 Thread Dave Page
Andrew Dunstan wrote: On a somewhat related note, I have had spectacular lack of success in getting either MSVC or MinGW builds to work on Vista - so much so that I have currently abandoned my attempts on that platform and I resorted to resuscitating an old XP box for testing. Following some

Re: [HACKERS] msvc and vista fun

2007-06-24 Thread Magnus Hagander
Andrew Dunstan wrote: I am still very unhappy about the way the MSVC builds work. Although we have managed to make it sort of work with the buildfarm script, it is distinctly fragile. Last night, for example, I had a build failure due to a badly installed zlib. The error state didn't come

Re: [HACKERS] msvc and vista fun

2007-06-24 Thread Andrew Dunstan
Magnus Hagander wrote: Andrew Dunstan wrote: I am still very unhappy about the way the MSVC builds work. Although we have managed to make it sort of work with the buildfarm script, it is distinctly fragile. Last night, for example, I had a build failure due to a badly installed zlib. The

Re: [HACKERS] msvc and vista fun

2007-06-24 Thread Andrew Dunstan
Dave Page wrote: Perhaps someone would like to tell me how I can remedy these problems. More importantly, this should be in an FAQ or some such. Also, I would like to know if we have really tested out on Vista the privilege surrendering code that is is supposed to work in Windows. It

Re: [HACKERS] Server-side support of all encodings

2007-06-24 Thread William ZHANG
Tom Lane [EMAIL PROTECTED] ITAGAKI Takahiro [EMAIL PROTECTED] writes: PostgreSQL suppots SJIS, BIG5, GBK, UHC and GB18030 as client encodings, but we cannot use them as server encodings. Are there any reason for it? Very much so --- they aren't safe ASCII-supersets, and thus for example the

Re: [Fwd: Re: [HACKERS] tsearch in core patch]

2007-06-24 Thread Tatsuo Ishii
Tatsuo Ishii wrote: japanese '{ja_JP, C}' How would we know C - japanese? You can't do that. You can't have different languages (not locales) mapping to the same 'tsearch language' because the stemmer doesn't know that a specific word is in english or japanese. So you have two

Re: [HACKERS] tsearch in core patch

2007-06-24 Thread Tatsuo Ishii
I would be surprised if C locale defaulted to anything except English. Don't be surprised. The mechanism of collation is too simple for Japanse Kanji, and locale is not usefull for Japanse anyway. That's why Japanese installations of PostgreSQL tend to use C locale. -- Tatsuo Ishii SRA OSS, Inc.

Re: [HACKERS] Server-side support of all encodings

2007-06-24 Thread Tom Lane
William ZHANG [EMAIL PROTECTED] writes: Sorry. I still cannot understand why backend encodings must have this property. AFAIK, the parser treats characters as ASCII. So any multi-byte characters will be treated as two or more ASCII characters. But if the multi-byte encoding doesnot use any

Re: [Fwd: Re: [HACKERS] tsearch in core patch]

2007-06-24 Thread Tom Lane
Tatsuo Ishii [EMAIL PROTECTED] writes: Ok, probably we need to copy the English stemming rule to the one for Japanese. Pardon my ignorance here, but is the concept of stemming even relevant to Japanese/Chinese/Korean? What little I know about ideographic languages suggests it wouldn't work

Re: [Fwd: Re: [HACKERS] tsearch in core patch]

2007-06-24 Thread Tatsuo Ishii
Tatsuo Ishii [EMAIL PROTECTED] writes: Ok, probably we need to copy the English stemming rule to the one for Japanese. Pardon my ignorance here, but is the concept of stemming even relevant to Japanese/Chinese/Korean? What little I know about ideographic languages suggests it wouldn't