Re: Updated tsearch documentation - Mailing list pgsql-hackers

On Thu, 26 Jul 2007, Bruce Momjian wrote:

> Oleg Bartunov wrote:
>> Bruce,
>>
>> I sent you link to my wiki page with summary of changes
>> http://www.sai.msu.su/~megera/wiki/ts_changes
>>
>> Your documentation looks rather old.
>
> I have updated it to reflect your changes:
>
>     http://momjian.us/expire/fulltext/HTML/textsearch-tables.html


Bruce, I noticed you miss many changes. For example,


options for stemmer has changed (it's documented in my ts_changes), 
so in 
http://momjian.us/expire/fulltext/HTML/textsearch-tables.html#TEXTSEARCH-TABLES-CONFIGURATION

ALTER TEXT SEARCH DICTIONARY en_stem SET OPTION 'english-utf8.stop';

should be


ALTER TEXT SEARCH DICTIONARY en_stem SET OPTION 
'StopFile=english-utf8.stop, Language=english';


Also, this is wrong

DROP TEXT SEARCH CONFIGURATION MAPPING ON pg FOR email, url, sfloat, uri, float;

it should be

ALTER TEXT SEARCH CONFIGURATION pg DROP MAPPING FOR email, url, sfloat, uri, float;

Configuration now doesn't have DEFAULT flag, so \dF should not display 'Y'


=> \dF
pg_catalog | russian  | Y
public     | pg       | Y


This is what I see now

postgres=# \dF public.*
List of fulltext configurations Schema | Name | Description
--------+------+------------- public | pg   |



>
> ---------------------------------------------------------------------------
>
>
>>
>> Oleg
>> On Tue, 24 Jul 2007, Bruce Momjian wrote:
>>
>>>
>>> I have added more documentation to try to show how full text search is
>>> used by user tables.  I think this the documentaiton is almost done:
>>>
>>>     http://momjian.us/expire/fulltext/HTML/textsearch-tables.html
>>>
>>> ---------------------------------------------------------------------------
>>>
>>> Oleg Bartunov wrote:
>>>> On Wed, 18 Jul 2007, Bruce Momjian wrote:
>>>>
>>>>> Oleg, Teodor,
>>>>>
>>>>> I am confused by the following example.  How does gin know to create a
>>>>> tsvector, or does it?  Does gist know too?
>>>>
>>>> No, gist doesn't know. I don't remember why, Teodor ?
>>>>
>>>> For GIN see http://archives.postgresql.org/pgsql-hackers/2007-05/msg00625.php
>>>> for discussion
>>>>
>>>>>
>>>>> FYI, at some point we need to chat via instant messenger or IRC to
>>>>> discuss the open items.  My chat information is here:
>>>>>
>>>>>     http://momjian.us/main/contact.html
>>>>
>>>> I send you invitation for google talk, I use only chat in gmail.
>>>> My gmail account is obartunov@gmail.com
>>>>
>>>>>
>>>>> ---------------------------------------------------------------------------
>>>>>
>>>>> SELECT title
>>>>> FROM pgweb
>>>>> WHERE textcat(title,body) @@ plainto_tsquery('create table')
>>>>> ORDER BY dlm DESC LIMIT 10;
>>>>>
>>>>> CREATE INDEX pgweb_idx ON pgweb USING gin(textcat(title,body));
>>>>>
>>>>>
>>>>
>>>>      Regards,
>>>>          Oleg
>>>> _____________________________________________________________
>>>> Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
>>>> Sternberg Astronomical Institute, Moscow University, Russia
>>>> Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
>>>> phone: +007(495)939-16-83, +007(495)939-23-83
>>>
>>>
>>
>>      Regards,
>>          Oleg
>> _____________________________________________________________
>> Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
>> Sternberg Astronomical Institute, Moscow University, Russia
>> Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
>> phone: +007(495)939-16-83, +007(495)939-23-83
>
>
    Regards,        Oleg
_____________________________________________________________
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83