Index: openacs-4/packages/tsearch2-driver/www/doc/index.html =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/tsearch2-driver/www/doc/index.html,v diff -u -r1.3 -r1.4 --- openacs-4/packages/tsearch2-driver/www/doc/index.html 29 Dec 2004 18:39:23 -0000 1.3 +++ openacs-4/packages/tsearch2-driver/www/doc/index.html 25 Jul 2006 07:00:28 -0000 1.4 @@ -1,40 +1,52 @@ TSEARCH2 PostgreSQL FtsEngineDriver for OpenACS 5.x

TSEARCH2 PostgreSQL FtsEngineDriver for - OpenACS 5.x

Installing

You'll need PostgreSQL 7.3 or - newer. The tsearch2 from contrib needs to be compiled. In addition - tsearch2.sql needs to be loaded into your database. In addition be - sure to mount the Search package somewhere. The indexer will not run - is Search is not mounted. The FtsEngineDriver parameter of the - search package must be changes to "tsearch2-driver". + OpenACS 5.x

Installing

+

tsearch2-driver requires:

+

Using

- If you install tsearch2-driver and mount search, go ahead and add - some content. Weblogger or edit-this-page will generate indexed - cotent. I had to manually load lars-blogger-sc-create.sql to get - Weblogger to register the service contract implementation to index - the content. After that it worked fine. +

+ 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. +

-

Index old content

-If your old content has not been indexed before (e.g. because you had no -search package mounted before), all is fine. Otherwise you have to inform the -search package to reindex.
-insert into search_observer_queue ( select my_id, now(),'INSERT' from -my_table);
+

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);
+    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 to prove that - tsearch2 can be used for indexing. There are many configuration - options that will be avaialble as parameters in the future. It is - also clear that the current service contract definitions are not +

+ 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 not be available until after the search package is - also updated. - - Dave Bauer dave@thedesignexperience.org 2004-06-05 \ No newline at end of file + some features may require making some improvements to the search package also. +

+

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