FYI, I added this to the patches queue because I think we decided full-text indexing should be in the core. If I am wrong, please let me know.
--------------------------------------------------------------------------- Teodor Sigaev wrote: > We (Oleg and me) are glad to present tsearch in core of pgsql patch. In > basic, > layout, functions, methods, types etc are the same as in current tsearch2 > with a > lot of improvements: > > - pg_ts_* tables now are in pg_catalog > - parsers, dictionaries, configurations now have owner and namespace > similar to > other pgsql's objects like tables, operator classes etc > - current tsearch configuration is managed with a help of GUC variable > tsearch_conf_name. > - choosing of tsearch cfg by locale may be done for each schema separately > - managing of tsearch configuration with a help of SQL commands, not with > insert/update/delete statements. This allows to drive dependencies, > correct dumping and dropping. > - psql support with a help of \dF* commands > - add all available Snowball stemmers and corresponding configuration > - correct memory freeing by any dictionary > > Work is sponsored by EnterpriseDB's PostgreSQL Development Fund. > > patch: http://www.sigaev.ru/misc/tsearch_core-0.33.gz > docs: http://mira.sai.msu.su/~megera/pgsql/ftsdoc/ (not yet completed and > it's > not yet a patch, just a SGML source) > > Implementation details: > - directory layout > src/backend/utils/adt/tsearch - all IO function and simple operations > src/backend/utils/tsearch - complex processing functions, including > language processing and dictionaries > - most of snowball dictionaries are placed in separate .so library and > they plug in into data base by similar way as character conversation > library does. > > If there aren't objections then we plan commit patch tomorrow or after > tomorrow. > Before committing, I'll changes oids from 5000+ to lower values to prevent > holes > in oids. And after that, I'll remove tsearch2 contrib module. > > -- > Teodor Sigaev E-mail: [EMAIL PROTECTED] > WWW: http://www.sigaev.ru/ > > ---------------------------(end of broadcast)--------------------------- > TIP 7: You can help support the PostgreSQL project by donating at > > http://www.postgresql.org/about/donate -- 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 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate