Re: Tsearch + polish ispell + polish locale
От | |
---|---|
Тема | Re: Tsearch + polish ispell + polish locale |
Дата | |
Msg-id | EA6A3F5C1E4BC14D91D93A344436440C010D330F@MXMBON01.grupa.onet обсуждение исходный текст |
Ответ на | Re: Tsearch + polish ispell + polish locale (Teodor Sigaev <teodor@sigaev.ru>) |
Ответы |
Re: Tsearch + polish ispell + polish locale
|
Список | pgsql-hackers |
Hi, > > I do not know how, but in some strange, random cases function isalpha() > stops return true value for polish letters, and that is when RS_compile() > returns error. > Hmm, very strange. Which OS do you use? > Pls, show exact > # show lc_ctype; > # show lc_collate; > and tsearch2 configuration Linux 2.6.14.4-dl380 lc_ctype ----------------pl_PL.iso88592 lc_collate ----------------pl_PL.iso88592 The other interesting thing is that, although tolower() and isalpha() functionality is broken, sorting polish letters worksfine ... Tsearch2 is configured as follows: INSERT INTO pg_ts_cfg (...) VALUES ('default_polish', 'default', 'pl_PL'); INSERT INTO pg_ts_cfgmap (...) VALUES( 'default_polish', 'url', '{simple}'); INSERT INTO pg_ts_cfgmap (...) VALUES( 'default_polish', 'host', '{simple}'); INSERT INTO pg_ts_cfgmap (...) VALUES( 'default_polish', 'sfloat', '{simple}'); INSERT INTO pg_ts_cfgmap (...) VALUES( 'default_polish', 'uri', '{simple}'); INSERT INTO pg_ts_cfgmap (...) VALUES( 'default_polish', 'int', '{simple}'); INSERT INTO pg_ts_cfgmap (...) VALUES( 'default_polish', 'float', '{simple}'); INSERT INTO pg_ts_cfgmap (...) VALUES( 'default_polish', 'email', '{simple}'); INSERT INTO pg_ts_cfgmap (...) VALUES( 'default_polish', 'word', '{simple}'); INSERT INTO pg_ts_cfgmap (...) VALUES( 'default_polish', 'hword', '{simple}'); INSERT INTO pg_ts_cfgmap (...) VALUES( 'default_polish', 'nlword', '{simple}'); INSERT INTO pg_ts_cfgmap (...) VALUES( 'default_polish', 'nlpart_hword', '{simple}'); INSERT INTO pg_ts_cfgmap (...) VALUES( 'default_polish', 'part_hword', '{simple}'); INSERT INTO pg_ts_cfgmap (...) VALUES( 'default_polish', 'nlhword', '{simple}'); INSERT INTO pg_ts_cfgmap (...) VALUES( 'default_polish', 'file', '{simple}'); INSERT INTO pg_ts_cfgmap (...) VALUES( 'default_polish', 'uint', '{simple}'); INSERT INTO pg_ts_cfgmap (...) VALUES( 'default_polish', 'version', '{simple}'); INSERT INTO pg_ts_cfgmap (...) VALUES( 'default_polish', 'lhword', '{pl_ispell,simple}'); INSERT INTO pg_ts_cfgmap (...) VALUES( 'default_polish', 'lpart_hword','{pl_ispell,simple}'); INSERT INTO pg_ts_cfgmap (...) VALUES( 'default_polish', 'lword', '{pl_ispell,simple}'); INSERT INTO pg_ts_dict (SELECT 'pl_ispell', dict_init, 'DictFile="/home/astaron/lib/ispell/polish.dic",' 'AffFile="/home/astaron/lib/ispell/polish.aff",' 'StopFile="/home/astaron/lib/ispell/polish.stop"', dict_lexize FROM pg_ts_dict WHERE dict_name = 'ispell_template'); If there is anything, I can do to help you to debug this issue (logs, tests, code changes..), please let me know. As for now I will run 8.2 and see if the problem persists ... Best regards,Arek.
В списке pgsql-hackers по дате отправления: