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'