Search Postgresql Archives

tsearch2 problem

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



we're using tsearch2 with the german dictionaryhttp://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/dicts/ispell/ispell-german-compound.tar.gzfor fulltext search.
the indexing is configured as follows:
CREATE TEXT SEARCH DICTIONARY public.german (    TEMPLATE = ispell,    DictFile = german,    AffFile = german,    StopWords = german);
CREATE TEXT SEARCH CONFIGURATION public.default ( COPY = pg_catalog.german );
ALTER TEXT SEARCH CONFIGURATION public.default    ALTER MAPPING FOR asciiword, asciihword, hword_asciipart,                      word, hword, hword_part    WITH public.german;
-------------------------
select * from ts_debug('default', 'hundshütte');works as expected: creates the two lexemes: "{hund,hütte}"
BUT
SELECT to_tsvector('default','lovely und bauarbeiter/in');looses a lot of stuff:"'bauarbeiter/in':2"
some more debugging shows:
SELECT * from ts_debug('default','lovely und bauarbeiter/in');
"asciiword";"Word, all ASCII";"lovely";"{german}";"german";"""blank";"Space symbols";" ";"{}";"";"""asciiword";"Word, all ASCII";"und";"{german}";"german";"{}""blank";"Space symbols";" ";"{}";"";"""file";"File or pathname";"bauarbeiter/in";"{simple}";"simple";"{bauarbeiter/in}"
a) unknown words are just beeing droppedb) words with slashes are interpreted as file paths and the first pathis beeing dropped.
any idea how we can fix this?
jodok
-- Jodok Batlogg, Vorstand
Lovely Systems AGTelefon +43 5572 908060, Fax +43 5572 908060-77, Mobil +43 664 9636963Schmelzhütterstraße 26a, 6850 Dornbirn, Austria
Sitz: Dornbirn, FB: Landesgericht Feldkirch, FN: 208859x, UID: ATU51736705Aufsichtsratsvorsitzender: Christian LutzVorstand: Jodok Batlogg, Manfred Schwendinger
-- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)To make changes to your subscription:http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux