Re: [HACKERS] suitable text search configuration

2007-10-25 Thread Tom Lane
Have we got consensus that initdb should just look at the first component of the locale name to choose a text search configuration (at least for 8.3)? If so, who's going to make the change? I can do it but don't want to duplicate effort if someone else was already on it.

Re: [HACKERS] suitable text search configuration

2007-10-25 Thread Alvaro Herrera
Tom Lane wrote: Have we got consensus that initdb should just look at the first component of the locale name to choose a text search configuration (at least for 8.3)? If so, who's going to make the change? I can do it but don't want to duplicate effort if someone else was already on it.

Re: [HACKERS] suitable text search configuration

2007-10-24 Thread Tom Lane
Alvaro Herrera [EMAIL PROTECTED] writes: ... oh, I see there's a table in initdb.c Are we supposed to add entries to it, one for each country? I'm wondering if we should try to match the part before the _ using just the language, if the complete match fails. (i.e. match es_CL using just

Re: [HACKERS] suitable text search configuration

2007-10-24 Thread Andrew Dunstan
Tom Lane wrote: Alvaro Herrera [EMAIL PROTECTED] writes: ... oh, I see there's a table in initdb.c Are we supposed to add entries to it, one for each country? I'm wondering if we should try to match the part before the _ using just the language, if the complete match fails.

Re: [HACKERS] suitable text search configuration

2007-10-24 Thread Tom Lane
Andrew Dunstan [EMAIL PROTECTED] writes: Tom Lane wrote: Actually, looking at the examples so far, I'm thinking we should just consider the string up to the first _, period. Can anyone point to a real world example where country by country would make sense? For the current set of built-in

Re: [HACKERS] suitable text search configuration

2007-10-24 Thread Alvaro Herrera
Andrew Dunstan wrote: Tom Lane wrote: Actually, looking at the examples so far, I'm thinking we should just consider the string up to the first _, period. I studied the standards a bit to see if they mandated that the locale names must be in the form language_COUNTRY, and couldn't find

Re: [HACKERS] suitable text search configuration

2007-10-24 Thread Tom Lane
Alvaro Herrera [EMAIL PROTECTED] writes: Andrew Dunstan wrote: Can anyone point to a real world example where country by country would make sense? If we need to distinguish flavors of some languages, I would not be at all surprised if this was not by country anyway. pt_BR versus pt_PT.

Re: [HACKERS] suitable text search configuration

2007-10-24 Thread Alvaro Herrera
Tom Lane wrote: Alvaro Herrera [EMAIL PROTECTED] writes: ... oh, I see there's a table in initdb.c Are we supposed to add entries to it, one for each country? I'm wondering if we should try to match the part before the _ using just the language, if the complete match fails. (i.e.