Search Postgresql Archives

Re: Let's play bash the search engine

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux