Re: Let's play bash the search engine

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 13:16:13
Message-ID: 20061219131613.GA10319@svr2.hagander.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Dec 19, 2006 at 01:24:01PM +0100, Magnus Hagander wrote:
> 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?

This has now been fixed for both website and archive search. So now you
can search for the technology that made the search possible in the first
place again :-)

//Magnus

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Clodoaldo 2006-12-19 13:37:49 Re: Regular expression and Group By
Previous Message Hannes Dorbath 2006-12-19 12:25:23 Don't split on underscore