[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 th

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 ne

[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 scr

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 a

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 a

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 com

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 er

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 looks

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 e

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

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

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

Re: [HACKERS] msvc and vista fun

2007-06-24 Thread Michael Paesold
Andrew Dunstan wrote: Relevant perl code executed by buildfarm: chdir "$pgsql/src/tools/msvc"; @makeout = `build 2>&1`; chdir $branch_root; my $status = $? >>8; I know the docs say otherwise, but would it be possible that "chdir" somehow resets $? on windows, some