Index: openacs-4/packages/edit-this-page/www/doc/searching.html =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/edit-this-page/www/doc/searching.html,v diff -u -r1.2 -r1.3 --- openacs-4/packages/edit-this-page/www/doc/searching.html 4 Apr 2003 16:00:05 -0000 1.2 +++ openacs-4/packages/edit-this-page/www/doc/searching.html 9 Jan 2004 16:24:11 -0000 1.3 @@ -50,7 +50,20 @@ } }
- ++To add previosuly created items to the search index execute the following query in psql: +
+insert into search_observer_queue +(select revision_id, + current_timestamp, + 'INSERT' + from cr_revisions r, + cr_items i + where r.item_id=i.item_id + and i.content_type='etp_page_revision' + and r.revision_id = i.live_revision; ++