tmptest=# SELECT * from pg_ts_cfg; ts_name | prs_name | locale -----------------+----------+-------------- default_russian | default | ru_RU.KOI8-R simple | default | default | default | [EMAIL PROTECTED] (3 righe)
tmptest=# SELECT to_tsvector ('ciao mamma'); ERROR: could not find tsearch config by localetmptest=# UPDATE pg_ts_cfg set locale = '[EMAIL PROTECTED]' where ts_name = 'default';
UPDATE 1 tmptest=# SELECT to_tsvector ('ciao mamma'); to_tsvector -------------------- 'ciao':1 'mamma':2 (1 riga)tmptest=# UPDATE pg_ts_cfg set locale = '[EMAIL PROTECTED]' where ts_name = 'default';
UPDATE 1 tmptest=# SELECT to_tsvector ('ciao mamma'); to_tsvector -------------------- 'ciao':1 'mamma':2 (1 riga) tmptest=# \qSo at first tsearch does not work. If I change it to [EMAIL PROTECTED] it works and if I switch back to [EMAIL PROTECTED] it then works even with that locale. I cannot understand the reason why it happens. By disconnecting from the db and connecting again the problem is still there. Do you have any idea why it happens?
I don't know if it matters, on the systems I have LANG="[EMAIL PROTECTED]" and LANGUAGE="it_IT"
Thanks, Ottavio PS: Im running a backport of postgresql 8.1 on debian sarge. -- Non c'e' piu' forza nella normalita', c'e' solo monotonia.
signature.asc
Description: OpenPGP digital signature