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

OK. A partial answer to my own question is that the postgres query
in the .xql file "full query name" should be named without the "."s
And it seems .xql files in the www directory only get loaded after
restarting the server.  Also the queries get stored somewhere in
memory when they are valid; so if I make a deliberate error in the
.xql query after the good query has been loaded once, the good query
is already in memory somewhere so the erroneous query is ignored.

So in summary to change an .xql query in the www directory change
the query then start or restart nsd.  Hope thats good info - if not
please correct me so others that come along and read this won't be
misled.  Thanks,  Zack.