Re: TSEARCH2: disable stemming in indexes and triggers

From: Teodor Sigaev <teodor(at)sigaev(dot)ru>
To: erwin(at)darwine(dot)nl
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: TSEARCH2: disable stemming in indexes and triggers
Date: 2007-05-31 18:27:06
Message-ID: 465F137A.9010002@sigaev.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> 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';

If your locale setting is not C then mark needed configuration with your
locale.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Anton 2007-05-31 18:49:28 how to use array with "holes" ?
Previous Message Oleg Bartunov 2007-05-31 18:23:21 Re: TSEARCH2: disable stemming in indexes and triggers