Forum OpenACS Q&A: Re: xowiki issue
While we are at it, I have another small issue. I'm using Postgresql v. 8.4. I think it is not the recommended version for OpenACS 5.6, but it works fine for me.
I just had to make a change related to database issues in xowiki so far.
In www/admin/list.tcl I had to change this database query, because apparently PG v. 8.4 doesn't like queries without fully qualified column names when more than one table is involved (my guess):
select object_id from syndication s, cr_items ci
where object_id = ci.live_revision and parent_id = :folder_id
select s.object_id from syndication s, cr_items ci
where s.object_id = ci.live_revision and parent_id = :folder_id
Anyhow, if it helps you, i'll modify the query, being more specific never hurts.