Re: Stemming not working with tsearch2() function

On 4/30/07, Oleg Bartunov <oleg(at)sai(dot)msu(dot)su> wrote:
>
> On Mon, 30 Apr 2007, psql psql wrote:
>
> > On 4/30/07, Oleg Bartunov <oleg(at)sai(dot)msu(dot)su> wrote:
> >>
> >> On Mon, 30 Apr 2007, psql psql wrote:
> >>
> >> > Anyone know why to_tsvector('sausages') might return "sausages" while
> >> > to_tsvector('default','sausages') correctly returns "sausag"?
> >> >
> >> > This is causing me a fairly major headache. I am guessing that the
> >> > tsearch2() function used in my trigger is not specifying "default"
> when
> >> > creating the tsvector since the words be put into the vector are not
> >> > correctly stemmed (if that is the correct term).
> >> >
> >> > I figure this may be something to do with locale settings, other
> info:
> >>
> >> it'is. Read http://www.sai.msu.su/~megera/wiki/Tsearch_V2_Notes
> >
> >
> > Thanks for the link.
> >
> > select * from pg_ts_cfg where oid=show_curcfg();
> > ts_name | prs_name | locale
> > ---------+----------+-------------
> > simple | default | en_US.UTF-8
> >
> >
> > That's helped me understand that the default config used by the
> > tsearch2() function
> > is not 'default' but 'simple' but I still don't understand why 'simple'
> is
> > not working when both default and simple have the same locale set in
> > pg_ts_cfg
> > (en_US.UTF-8). Am i missing something?
>
> at present, having several configurations matching the same locale leads
> to unpredictable results. Leave only one.
> In 8.3 we have special flag to mark fts config
> which could be selectable as default.
> http://www.sai.msu.su/~megera/postgres/fts/doc/fts-cfg.html

Ah thanks.
Is tsearch2() hard coded to use 'simple', or could i delete 'simple'
and just use 'default'
somehow?
It's not a big issue if I have to use simple, I will just have to redeploy
some code that is currently using 'default'.
Matt.