Forum OpenACS Q&A: Re: Is there an easy way to trigger tsearch2 to re-index all content?

Collapse
3: Re: Is there an easy way to trigger tsearch2 to re-index all content? (response to 1)
Posted by Dave Bauer on 03/30/12 01:36 AM
That's weird, if you edited the item it should reindex it anyway.

So just insert the object_ids of the relevant entries by restricting the query you use to insert, for example using latest_revision from cr_items for the content type that matches xowiki files or parent_id of the xowiki folder.

Collapse
4: Re: Is there an easy way to trigger tsearch2 to re-index all content? (response to 3)
Posted by Richard Hamilton on 03/30/12 02:49 AM
Dave, thanks very much for the reply.

So if I use the object_id of an xowiki folder then it will re-index all the child objects too?

Is that driven by context_id, such that if I simply use the package_id for the xowiki instance it would re-index all the xowiki instance content?

Regards
Richard

Collapse
6: Re: Is there an easy way to trigger tsearch2 to re-index all content? (response to 4)
Posted by Gustaf Neumann on 03/30/12 11:15 AM
xowiki has a web-callable method .../xowiki/?reindex=1 for reindexing all content of an xowiki instance. Note, that it only indexes entries in the ready publish_status. I have just committed an update to handle folder structures as well.
Collapse
7: Re: Is there an easy way to trigger tsearch2 to re-index all content? (response to 6)
Posted by Richard Hamilton on 03/30/12 01:58 PM
Fantastic, thank you Gustaf. I will collect the update and try it.

Regards
Richard