Index: openacs-4/packages/acs-content-repository/sql/postgresql/upgrade/upgrade-4.5-4.6.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/postgresql/upgrade/upgrade-4.5-4.6.sql,v
diff -u -r1.1.2.1 -r1.1.2.2
--- openacs-4/packages/acs-content-repository/sql/postgresql/upgrade/upgrade-4.5-4.6.sql	29 Oct 2002 01:51:39 -0000	1.1.2.1
+++ openacs-4/packages/acs-content-repository/sql/postgresql/upgrade/upgrade-4.5-4.6.sql	5 Mar 2003 14:50:05 -0000	1.1.2.2
@@ -191,24 +191,10 @@
 -- we need new triggers on cr_items to index when a live revision
 -- changes
 
-create or replace function content_item_search__utrg ()
-returns opaque as '
-begin
-    if new.live_revision is not null and coalesce(old.live_revision,0) <> new.live_revision then
-	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) then
-	perform search_observer__enqueue(old.live_revision,''DELETE'');
-    end if;
+-- LARS: REMOVED
 
-    return new;
-end;' language 'plpgsql';
 
-create trigger content_item_search__utrg before update on cr_items
-for each row execute procedure content_item_search__utrg (); 
-
-
 -- content-type.sql
 
 create or replace function content_type__trigger_insert_statement (varchar)