Index: openacs-4/packages/acs-content-repository/sql/postgresql/content-search.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/postgresql/content-search.sql,v diff -u -r1.4.4.1 -r1.4.4.2 --- openacs-4/packages/acs-content-repository/sql/postgresql/content-search.sql 27 Sep 2002 15:32:49 -0000 1.4.4.1 +++ openacs-4/packages/acs-content-repository/sql/postgresql/content-search.sql 3 Oct 2002 19:30:19 -0000 1.4.4.2 @@ -142,6 +142,7 @@ create trigger content_search__utrg after update on cr_revisions for each row execute procedure content_search__utrg (); -drop trigger content_item_search__utrg on cr_items; +-- JCD: on create this trigger should not exist so lets not drop it +-- drop trigger content_item_search__utrg on cr_items; create trigger content_item_search__utrg before update on cr_items for each row execute procedure content_item_search__utrg ();