Hello UTF8 is supported from 8.2 version
Regards Pavel Stehule On 17/04/2008, Ottavio Campana <[EMAIL PROTECTED]> wrote: > 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 > 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=# 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=# \q > > 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" > > 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. > > > -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general