Re: Let's play bash the search engine - Mailing list pgsql-general

From Magnus Hagander
Subject Re: Let's play bash the search engine
Date
Msg-id 20061219122401.GA10208@svr2.hagander.net
Whole thread Raw
In response to Re: Let's play bash the search engine  (Oleg Bartunov <oleg@sai.msu.su>)
Responses Re: Let's play bash the search engine  (Magnus Hagander <magnus@hagander.net>)
List 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

pgsql-general by date:

Previous
From: Hannes Dorbath
Date:
Subject: Don't split on underscore
Next
From: Magnus Hagander
Date:
Subject: Re: Let's play bash the search engine