TSEARCH2 PostgreSQL FtsEngineDriver for OpenACS 5.x

Installing

tsearch2-driver requires:

• PostgreSQL 7.3 or newer
• PostgreSQL's tsearch2 module
• PostgreSQL versions 7.3 and 7.4 require tsearch2.sql to be loaded into the database
• search package to be mounted somewhere.
• FtsEngineDriver parameter of search package set to "tsearch2-driver".

Using

Once tsearch2-driver is installed, add some content to be indexed. Weblogger or edit-this-page has code to generate indexed content. Lars-blogger package may require manually loading lars-blogger-sc-create.sql to get Weblogger to register the service contract implementation that indexes the content.

Indexing pre-existing content that has been indexed before

If your pre-existing content has been indexed before (e.g. because the search package was mounted before as part of a previous search service), you have to tell the search package to reindex:

    insert into search_observer_queue (
            select my_id, now(),'INSERT' from my_table
            );
  

For forums and ETP this looks like:

    insert into search_observer_queue (
            select message_id, now(), 'INSERT' from forums_messages
            );
    insert into search_observer_queue (
            select live_revision, now(), 'INSERT' from (
                    select live_revision from cr_items where content_type = 'etp_page_revision'
                    ) 
            etp );

Features

This version includes only the most basic features. Many options are possible by adding admin configurable parameters. The current service contract definitions are not flexible enough to work well with every possible search driver, so some features may require making some improvements to the search package also.

Dave Bauer dave@thedesignexperience.org 2004-06-05