Re: tsearch2: more than one index per table?

On Wed, 23 Nov 2005, Teodor Sigaev wrote:

>> ERROR: could not find tsearch config by locale
>> UPDATE t SET idxA=to_tsvector('default', a);
>>
>
> Is it working
> select to_tsvector('foo bar')?
>
> I suppose, no. In that case tsearch can't find configuration for current
> database locale, update pg_ts_cfg.locale in wished row to correct value.

Actually, it's described in tsearch2 introduction.
Make sure pg_ts_cfg.locale matched server's locale (see 'show all')

Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83