Re: ADMIN Install Tsearch2 - new dic
От | Jeff Frost |
---|---|
Тема | Re: ADMIN Install Tsearch2 - new dic |
Дата | |
Msg-id | Pine.LNX.4.64.0702020919480.4629@discord.home.frostconsultingllc.com обсуждение исходный текст |
Ответ на | Re: ADMIN Install Tsearch2 - new dic ("Alexander B." <burbello3000@yahoo.com.br>) |
Список | pgsql-admin |
below, you'll need to change every mention of english to portuguese and you'll also need to find an ispell dictionary for portuguese. Also, this INSERT: INSERT INTO pg_ts_cfg (ts_name , prs_name, locale ) values ( 'default_english', 'default', 'en_US'); would need to match your locale, so replace default_english with default_portuguese and en_US with your locale (pt_PT?). On Fri, 2 Feb 2007, Alexander B. wrote: > Sorry for insist, but how can I add a new language, specially portuguese? > I could execute the file "tsearch2.sql", but I need to configure in my > language. > > Thanks in advance. > > > > > > > Jeff Frost escreveu: >> BTW, this was for an RPM installed version of postgresql. As Shoab >> mentions in another mail, if you have compiled postgresql from >> tarball, you'll have to cd into the contrib/tsearch2 dir and make && >> make install before you can do this stuff. >> >> On Thu, 1 Feb 2007, Jeff Frost wrote: >> >>> I believe I followed these instructions the last time I enabled >>> tsearch2: >>> >>> http://www.sai.msu.su/~megera/wiki/tsearch-v2-intro >>> >>> These are my crib notes for the English version, you'll have to >>> update paths etc: >>> >>> wget >>> http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/dicts/ispell/ispell-english.tar.gz >>> >>> cd /usr/local/lib >>> sudo tar xvfz /usr/local/src/TARFILES/ispell-english.tar.gz >>> >>> psql -f /usr/share/pgsql/contrib/tsearch2.sql ftstest >>> >>> INSERT INTO pg_ts_cfg (ts_name , prs_name, locale ) values ( >>> 'default_english', 'default', 'en_US'); >>> >>> INSERT INTO pg_ts_dict >>> (SELECT 'en_ispell', >>> dict_init, >>> 'DictFile="/usr/local/lib/english.dict",' >>> 'AffFile="/usr/local/lib/english.aff",' >>> 'StopFile="/usr/share/pgsql/contrib/english.stop"', >>> dict_lexize >>> FROM pg_ts_dict >>> WHERE dict_name = 'ispell_template'); >>> >>> INSERT INTO pg_ts_cfgmap (ts_name, tok_alias, dict_name) >>> VALUES ('default_english', 'lhword', '{en_ispell,en_stem}'); >>> INSERT INTO pg_ts_cfgmap (ts_name, tok_alias, dict_name) >>> VALUES ('default_english', 'lpart_hword', '{en_ispell,en_stem}'); >>> INSERT INTO pg_ts_cfgmap (ts_name, tok_alias, dict_name) >>> VALUES ('default_english', 'lword', '{en_ispell,en_stem}'); >>> >>> INSERT INTO pg_ts_cfgmap >>> VALUES ('default_english', 'url', '{simple}'); >>> INSERT INTO pg_ts_cfgmap >>> VALUES ('default_english', 'host', '{simple}'); >>> INSERT INTO pg_ts_cfgmap >>> VALUES ('default_english', 'sfloat', '{simple}'); >>> INSERT INTO pg_ts_cfgmap >>> VALUES ('default_english', 'uri', '{simple}'); >>> INSERT INTO pg_ts_cfgmap >>> VALUES ('default_english', 'int', '{simple}'); >>> INSERT INTO pg_ts_cfgmap >>> VALUES ('default_english', 'float', '{simple}'); >>> INSERT INTO pg_ts_cfgmap >>> VALUES ('default_english', 'email', '{simple}'); >>> INSERT INTO pg_ts_cfgmap >>> VALUES ('default_english', 'word', '{simple}'); >>> INSERT INTO pg_ts_cfgmap >>> VALUES ('default_english', 'hword', '{simple}'); >>> INSERT INTO pg_ts_cfgmap >>> VALUES ('default_english', 'nlword', '{simple}'); >>> INSERT INTO pg_ts_cfgmap >>> VALUES ('default_english', 'nlpart_hword', '{simple}'); >>> INSERT INTO pg_ts_cfgmap >>> VALUES ('default_english', 'part_hword', '{simple}'); >>> INSERT INTO pg_ts_cfgmap >>> VALUES ('default_english', 'nlhword', '{simple}'); >>> INSERT INTO pg_ts_cfgmap >>> VALUES ('default_english', 'file', '{simple}'); >>> INSERT INTO pg_ts_cfgmap >>> VALUES ('default_english', 'uint', '{simple}'); >>> INSERT INTO pg_ts_cfgmap >>> VALUES ('default_english', 'version', '{simple}'); >>> >>> ALTER TABLE album ADD COLUMN idxFTI tsvector; >>> UPDATE album SET idxFTI=to_tsvector(name); >>> CREATE INDEX album_idxFTI_idx ON album USING gist(idxFTI); >>> >>> CREATE TRIGGER album_tsvectorupdate BEFORE UPDATE OR INSERT ON album >>> FOR EACH ROW EXECUTE PROCEDURE tsearch2(idxFTI, name); >>> >>> SELECT * FROM album WHERE idxfti @@ to_tsquery('spiderman'); >>> >>> >>> Hopefully that helps... >>> >>> On Thu, 1 Feb 2007, Alexander B. wrote: >>> >>>> Hi, >>>> >>>> I need to install tsearch2, but I couldn't find a procedure >>>> (step-by-step). >>>> Could you recomend some site or some steps to install. >>>> >>>> I used PG 8 on Suse and Debian, and I installed postgres by source. >>>> >>>> Thanks in advance. >>>> >>>> >>>> >>>> >>>> >>>> _______________________________________________________ >>>> Yahoo! Mail - Sempre a melhor op??o para voc?! >>>> Experimente j? e veja as novidades. >>>> http://br.yahoo.com/mailbeta/tudonovo/ >>>> >>>> ---------------------------(end of >>>> broadcast)--------------------------- >>>> TIP 7: You can help support the PostgreSQL project by donating at >>>> >>>> http://www.postgresql.org/about/donate >>>> >>>> >>> >>> >> > > > > _______________________________________________________ > Yahoo! Mail - Sempre a melhor opção para você! > Experimente já e veja as novidades. > http://br.yahoo.com/mailbeta/tudonovo/ > > > > ---------------------------(end of broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster > > -- Jeff Frost, Owner <jeff@frostconsultingllc.com> Frost Consulting, LLC http://www.frostconsultingllc.com/ Phone: 650-780-7908 FAX: 650-649-1954
В списке pgsql-admin по дате отправления: