--
-- search__deindex_all/0
--
create or replace function search__deindex_all(
  
) returns int4 as $$

declare v_txt_row record;
begin

for v_txt_row in select tid from txt, acs_objects where
tid=object_id and object_type='content_revision'
loop
perform search_observer__enqueue(v_txt_row.tid,'DELETE');
end loop;
return 0;
end;$$ language plpgsql;