Re: TSEARCH2: disable stemming in indexes and triggers

On Thu, 2007-05-31 at 20:27, Teodor Sigaev wrote:
> > I found out that using 'simple' instead of 'default' when using
> > to_tsvector() does excactly that, but I don't know how to change my
> > triggers and indexes to keep doing the same (using 'simple').
>
> Suppose, your database is initialized with C locale. So, just mark
> simple configuration as default:
>
> # update pg_ts_cfg set locale=null where ts_name='default';
> # update pg_ts_cfg set locale='C' where ts_name='simple';

Thanks Teodor.

That did the trick. :-)
At first I didn't see a change, but after reconnecting to the database
it worked for some reason beyound my meager knowledge.

Thanks to Oleg Bartunov too for his suggestion about writing my own
procedure.
This solution seemed simpler and worked the first time right away.

Thanks for your help!

Regards,
Erwin Moller

>
> If your locale setting is not C then mark needed configuration with your
> locale.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org/
>