[GENERAL] problem with tsearch and utf-8 on postgresql 8.1

[Ottavio Campana]

I created a database with locale [EMAIL PROTECTED], and I'm facing a weird problem with tsearch. Let me show it:

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 locale

UPDATE 1
tmptest=# SELECT to_tsvector ('ciao mamma');
    to_tsvector
--------------------
 'ciao':1 'mamma':2
(1 riga)


UPDATE 1
tmptest=# SELECT to_tsvector ('ciao mamma');
    to_tsvector
--------------------
 'ciao':1 'mamma':2
(1 riga)

tmptest=# \q





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.

tmptest=# UPDATE pg_ts_cfg set locale = '[EMAIL PROTECTED]' where ts_name = 'default'; tmptest=# UPDATE pg_ts_cfg set locale = '[EMAIL PROTECTED]' where ts_name = 'default'; So 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"

signature.asc
Description: OpenPGP digital signature