Hi John,
> What I don't understand is the file:
>
>/packages/notes/postgresql/notes-sc-create.sql
>
>acs_sc_impl__new
>function notes__itrg
>trigger note_itrg
That file is meant to set up search services for the notes package. Site wide search is set up through things called service contracts (sc). See
the acs-service-contract docs for more info.
Basically the search package publishes a contract that other packages have to fulfill if they want their content to be available to site wide search. the ac_sc_impl* calls notify openacs that notes is fulfilling those contracts.
The triggers run everytime you insert, update or delete a note and inform the search package of the change in the data.