Обсуждение: Tsearch2 default locale on postgres 8.2

Hi!

   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?

Best regards
Manuel ...

set_curcfg() is working only for current session

Tarabas (Manuel Rorarius) wrote:
> Hi!
>
>    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?
>
> Best regards
> Manuel ...
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster

--
Teodor Sigaev                                   E-mail: teodor@sigaev.ru
                                                    WWW: http://www.sigaev.ru/

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

Hi,

right ... i had a typo in the locale, it was set to "de_DE.UTF8" but
should have been set to "de_DE.UTF-8".

After that change, the "select set_curcfg('default');" worked fine.

thanx a lot...

Best regards
Manuel

Friday, December 22, 2006, 12:35:41 PM, you wrote:

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

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

HD> to find your cluster locale, then:

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


HD> 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?

I don't think calling set_curcfg() is necessary for anything in that
case then..

On 22.12.2006 12:36, Tarabas (Manuel Rorarius) wrote:
> After that change, the "select set_curcfg('default');" worked fine.


--
Regards,
Hannes Dorbath