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
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
