Re: tsearch2: more than one index per table? - Mailing list pgsql-general

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@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83