Forum OpenACS CMS: dropping triggers on cr_revisions

Collapse
Posted by Tom Jackson on
I want to drop the triggers on cr_revisions which log changes into search_observer_queue so that OpenFTS can index the content.

If OpenFTS is not installed, this queue table fills up with rows which are never deleted.

Since I need to put a new trigger on cr_revisions which will update the cr_revisions table, it looks like this might affect the latest_revision field in cr_items, so that it is always the same as live_revision.

Does anyone know of any other bad effects which might result from dropping these triggers? They are named: 'content_search__i/u/dtrg'