Re: ADMIN Install Tsearch2 - new dic

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(at)frostconsultingllc(dot)com>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954