Greetings,
I have a related postgres/OpenACS question. The index.tcl file in
my www directory
runs this query:
db_multirow nodies site_nodes {}
which is in index-postgresql.xql as:
fullquery name="dbqd.www.index.site_nodes"
querytext
select site_node__url(node_id) as url, acs_object__name(object_id)
as name
etc.
It seems that no matter what I do to change the query in the .xql or
.tcl file for that matter nothing changes (index.xql doesn't have
the query in it). The query seems to be stored somewhere
permanently. I even put deliberate errors in the .xql file and
restart the server
and still no change. Does anybody have an idea why? Where else
could this query be stored?
Thanks, Zack.