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