Forum OpenACS Development: Response to Basic question. How to run a pg stored procedure from tcl

Zack, you don't need to restart the server everytime you change a
cached .tcl or .xql file.  You should use the very slick "watch"
feature of the APM, which will tell the server to source the file
every time it's accessed. To try it: alter an .xql or .tcl file,
just add a space or something, then go to /acs-admin/apm/?&supertype=all and there wil be a "reload" link. The watch will stay in effect until the server is restarted. Note that watching files slows everything down therefore should not be used on production servers.