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 -N -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;
+
+


Dave Bauer