From: | silly_sad <sad(at)bankir(dot)ru> |
---|---|
To: | pgsql-ru-general(at)postgresql(dot)org |
Subject: | Tsearch strange error (appendix) |
Date: | 2007-03-21 08:20:16 |
Message-ID: | 4600EAC0.2090207@bankir.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-ru-general |
и вот ещё эта информация будет полезной:
SELECT * from pg_ts_cfg;
ts_name | prs_name | locale
-----------------+----------+--------------
default | default | C
utf8_russian | default | ru_RU.UTF-8
simple | default |
default_russian | default | ru_RU.KOI8-R
инициализировано это было так
INSERT INTO pg_ts_dict
(SELECT 'ru_ispell',
dict_init,
'DictFile="/usr/local/cms1/sql/russian.dict",'
'AffFile="/usr/local/cms1/sql/russian.aff",'
'StopFile="/usr/local/cms1/sql/russian.stop"',
dict_lexize
FROM pg_ts_dict
WHERE dict_name = 'ispell_template');
UPDATE pg_ts_cfg SET locale = 'ru_RU.KOI8-R' WHERE ts_name =
'default_russian';
DELETE FROM pg_ts_cfgmap WHERE ts_name = 'default_russian';
INSERT INTO pg_ts_cfgmap VALUES ('default_russian', 'lhword',
'{ru_ispell,ru_stem_koi8}');
INSERT INTO pg_ts_cfgmap VALUES ('default_russian', 'lpart_hword',
'{ru_ispell,ru_stem_koi8}');
INSERT INTO pg_ts_cfgmap VALUES ('default_russian', 'lword',
'{ru_ispell,ru_stem_koi8}');
INSERT INTO pg_ts_cfgmap VALUES ('default_russian', 'url', '{simple}');
INSERT INTO pg_ts_cfgmap VALUES ('default_russian', 'host', '{simple}');
INSERT INTO pg_ts_cfgmap VALUES ('default_russian', 'sfloat', '{simple}');
INSERT INTO pg_ts_cfgmap VALUES ('default_russian', 'uri', '{simple}');
INSERT INTO pg_ts_cfgmap VALUES ('default_russian', 'int', '{simple}');
INSERT INTO pg_ts_cfgmap VALUES ('default_russian', 'float', '{simple}');
INSERT INTO pg_ts_cfgmap VALUES ('default_russian', 'email', '{simple}');
INSERT INTO pg_ts_cfgmap VALUES ('default_russian', 'word', '{simple}');
INSERT INTO pg_ts_cfgmap VALUES ('default_russian', 'hword',
'{ru_ispell,ru_stem_koi8}');
INSERT INTO pg_ts_cfgmap VALUES ('default_russian', 'nlword',
'{ru_ispell,ru_stem_koi8}');
INSERT INTO pg_ts_cfgmap VALUES ('default_russian', 'nlpart_hword',
'{ru_ispell,ru_stem_koi8}');
INSERT INTO pg_ts_cfgmap VALUES ('default_russian', 'part_hword',
'{simple}');
INSERT INTO pg_ts_cfgmap VALUES ('default_russian', 'nlhword',
'{ru_ispell,ru_stem_koi8}');
INSERT INTO pg_ts_cfgmap VALUES ('default_russian', 'file', '{simple}');
INSERT INTO pg_ts_cfgmap VALUES ('default_russian', 'uint', '{simple}');
INSERT INTO pg_ts_cfgmap VALUES ('default_russian', 'version', '{simple}');
Словари эти чудесно работали в 8.1.4
From | Date | Subject | |
---|---|---|---|
Next Message | Oleg Bartunov | 2007-03-21 10:50:25 | Re: Tsearch strange error |
Previous Message | silly_sad | 2007-03-21 07:59:25 | Re: Tsearch strange error |