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 -N -r1.11.2.1 -r1.11.2.2 --- openacs-4/packages/acs-content-repository/sql/postgresql/content-search.sql 13 Dec 2019 15:02:11 -0000 1.11.2.1 +++ openacs-4/packages/acs-content-repository/sql/postgresql/content-search.sql 13 Dec 2019 15:02:55 -0000 1.11.2.2 @@ -1,4 +1,4 @@ --- @cvs-id $Id$ +-- @cvs-id $Id$ ------------------------------------------------------------ -- declare CR as a content provider for search/indexing interface ------------------------------------------------------------ @@ -127,7 +127,7 @@ BEGIN if new.live_revision is not null and coalesce(old.live_revision,0) <> new.live_revision and (select publish_date from cr_revisions where revision_id=new.live_revision) <= current_timestamp then - perform search_observer__enqueue(new.live_revision,'INSERT'); + perform search_observer__enqueue(new.live_revision,'INSERT'); end if; if old.live_revision is not null and old.live_revision <> coalesce(new.live_revision,0) @@ -143,10 +143,10 @@ $$ LANGUAGE plpgsql; create trigger content_search__itrg after insert on cr_revisions -for each row execute procedure content_search__itrg (); +for each row execute procedure content_search__itrg (); create trigger content_search__utrg after update on cr_revisions -for each row execute procedure content_search__utrg (); +for each row execute procedure content_search__utrg (); create trigger content_item_search__utrg before update on cr_items