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.10.2.1 -r1.10.2.2 --- openacs-4/packages/acs-content-repository/sql/postgresql/content-search.sql 2 Feb 2016 13:27:52 -0000 1.10.2.1 +++ openacs-4/packages/acs-content-repository/sql/postgresql/content-search.sql 11 Feb 2016 08:07:03 -0000 1.10.2.2 @@ -81,8 +81,10 @@ -- DaveB: We only want to index live_revisions 2002-09-26 +-- +-- procedure content_search__itrg/0 +-- - CREATE OR REPLACE FUNCTION content_search__itrg () RETURNS trigger AS $$ BEGIN if (select live_revision from cr_items where item_id=new.item_id) = new.revision_id and new.publish_date >= current_timestamp then @@ -92,15 +94,7 @@ END; $$ LANGUAGE plpgsql; -CREATE OR REPLACE FUNCTION content_search__dtrg () RETURNS trigger AS $$ -BEGIN - perform search_observer__enqueue(old.revision_id,'DELETE'); - return old; -END; -$$ LANGUAGE plpgsql; - - -- -- procedure content_search__utrg/0 -- @@ -151,9 +145,6 @@ create trigger content_search__itrg after insert on cr_revisions for each row execute procedure content_search__itrg (); -create trigger content_search__dtrg after delete on cr_revisions -for each row execute procedure content_search__dtrg (); - create trigger content_search__utrg after update on cr_revisions for each row execute procedure content_search__utrg ();