| From: | Magnus Hagander <magnus(at)hagander(dot)net> |
|---|---|
| To: | Oleg Bartunov <oleg(at)sai(dot)msu(dot)su> |
| Cc: | Gurjeet Singh <singh(dot)gurjeet(at)gmail(dot)com>, Henrik Zagerholm <henke(at)mac(dot)se>, "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Let's play bash the search engine |
| Date: | 2006-12-19 12:24:01 |
| Message-ID: | 20061219122401.GA10208@svr2.hagander.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, Dec 19, 2006 at 01:13:16PM +0300, Oleg Bartunov wrote:
> >Seems to_tsvecto() returns NULL for tsearch2 or for, as you say,
> >anything that ends in a digit.
> >
> >Oleg, can you comment on why this is happening? What can we do to fix
> >that?
>
> Most probably, token type 'word' just doesn't indexed. If you
> didnt' correct this from pgweb configuration:
>
> -- we won't index/search some tokens
> update pg_ts_cfgmap set dict_name = NULL
> where tok_alias in ('email', 'url', 'sfloat', 'uri', 'float','word')
> and ts_name = 'pg';
That sounds like it's the problem. I'll update the configuration, and I
assume I have to regenerate all the tsvectors as well, right?
Should I set it to 'simple' or one of the others?
//Magnus
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hannes Dorbath | 2006-12-19 12:25:23 | Don't split on underscore |
| Previous Message | Albe Laurenz | 2006-12-19 11:44:23 | Re: Stored Procedure and Trigger they puzzle me |