Re: Tsearch2 default locale on postgres 8.2

I think the best way is to adjust the locale for your default config:

Type:
SHOW lc_ctype; (or some other lc_* variables) in psql.

to find your cluster locale, then:

UPDATE
   public.pg_ts_cfg
SET
   locale = '<your_locale>'
WHERE
   ts_name = 'default';


On 22.12.2006 11:55, Tarabas (Manuel Rorarius) wrote:
>    I am having a tsearch2 problem on postgres 8.2 again ...
>    when I try to set the default config for tsearch2 with
>
>    "select set_curcfg('default'); it works fine in the same pgadmin
>    session when i use "select show_curcfg();" afterwards. The correct
>    OID is shown.
>
>    If i then close the query window and open a new one and then try
>    the "select show_curcfg();" again, it states
>    "ERROR:  could not find tsearch config by locale"
>
>    Any idea why the configuration is not saved correctly?

--
Regards,
Hannes Dorbath