I just updated the PostgreSQLFullText pages on the wiki with the triggers to keep the parsed document columns updated whenever there is a change to the dependent columns.
Here are the commands for adding the triggers to keep the textsearchable columns corresponding to attachments.subject/content and objectcustomfieldvalues.largecontent up to date: CREATE TRIGGER tsvectorupdate BEFORE INSERT OR UPDATE ON attachments FOR EACH ROW EXECUTE PROCEDURE tsvector_update_trigger(textsearchable, 'pg_catalog.english', subject, content); CREATE TRIGGER tsvectorupdate BEFORE INSERT OR UPDATE ON objectcustomfieldvalues FOR EACH ROW EXECUTE PROCEDURE tsvector_update_trigger(textsearchable, 'pg_catalog.english', largecontent); Please let me know if there are any problems and bon voyage. Ken _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
