[GENERAL] tsearch2 in multilingual database?

2007-07-04 Thread Joshua N Pritikin
Sometime in the future, I anticipate storing other languages in addition 
to English in my database to be indexed with tsearch2. set_curcfg() 
seems to be per-session. Will I need to call set_curcfg() every time I 
switch languages?

-- 
Make April 15 just another day, visit http://fairtax.org

---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster


Re: [GENERAL] tsearch2 in multilingual database?

2007-07-05 Thread Hannes Dorbath

On 04.07.2007 11:20, Joshua N Pritikin wrote:
Sometime in the future, I anticipate storing other languages in addition 
to English in my database to be indexed with tsearch2. set_curcfg() 
seems to be per-session. Will I need to call set_curcfg() every time I 
switch languages?


You *should* create a TSearch config for each language, at least if 
you'd like to use stemming, compound words etc. When you have a 
multilingual project, I'm sure you have a `languages' table already 
somewhere. Just extent that table with a tsearch_config field, so you 
know what config to use for what language.. and yes, you have to set 
that every time.



--
Regards,
Hannes Dorbath

---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster