Thanks, I found a few more places that needed updating. It should be accurate now. Thanks for the report.
--------------------------------------------------------------------------- Oleg Bartunov wrote: > 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 [EMAIL PROTECTED] > >>>> > >>>>> > >>>>> --------------------------------------------------------------------------- > >>>>> > >>>>> 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: [EMAIL PROTECTED], 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: [EMAIL PROTECTED], 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: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/ > phone: +007(495)939-16-83, +007(495)939-23-83 -- Bruce Momjian <[EMAIL PROTECTED]> http://momjian.us EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
