Postgres Pro
Downloads
Home   >   mailing lists

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

From Teodor Sigaev
Subject Re: tsearch2: more than one index per table?
Date
Msg-id 43841C0D.1030407@sigaev.ru
Whole thread Raw
In response to tsearch2: more than one index per table?  ("Rick Schumeyer" <rschumeyer@ieee.org>)
Responses Re: tsearch2: more than one index per table?  (Oleg Bartunov <oleg@sai.msu.su>)
List pgsql-general
Tree view 
> 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.


--
Teodor Sigaev                                   E-mail: teodor@sigaev.ru
                                                    WWW: http://www.sigaev.ru/

pgsql-general by date:

Previous
From: "Thomas F. O'Connell"
Date:
Subject: Re: Index Administration: pg_index vs. pg_get_indexdef()
Next
From: Script Head
Date:
Subject: Strugging with NEW and OLD records.