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
---(end of broadcast)
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
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 = ''
WHERE
ts_name = 'default';
On 22.12.2006 11:55, Tarabas (Manuel Rorarius) wrote:
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
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
