-- -- enqueue_etp/0 -- create or replace function enqueue_etp( ) returns int4 as $$ declare v_etp_row record; begin for v_etp_row in select revision_id from cr_revisions where revision_id in (select live_revision from cr_items where content_type='etp_page_revision') loop perform search_observer__enqueue(v_etp_row.revision_id,'INSERT'); end loop; return 0; end;$$ language plpgsql;