If nobody fix todays problems ( issues ), we will never move to the next step.
Besides package ACS Events, I can tell that working with PostgreSQL 8.1 is not that difficult, nor impossible.
I already help fix issues with News Aggregator and Forums is also working.
I am testing tsearch2 and it seems to be working fine, but I also want to install Lars Blogger that needs ACS Events.
The problem with package ACS Events, seems to be related to these 2 functions:
======== First ===============
declare
get_html_p__event_id alias for $1; -- in acs_events.event_id%TYPE
v_html_p acs_events.html_p%TYPE;
begin
select coalesce(e.html_p, a.html_p) into v_html_p
from acs_events e
left join acs_activities a
on (e.activity_id = a.activity_id)
where e.event_id = get_html_p__event_id
return v_html_p;
end;' language 'plpgsql';
========== Second ===========
declare
get_status_summary__event_id alias for $1; -- acs_events.event_id%TYPE
v_status_summary acs_events.status_summary%TYPE;
begin
select coalesce(e.status_summary, a.status_summary) into v_status_summary
from acs_events e
left join acs_activities a
on (e.activity_id = a.activity_id)
where e.event_id = get_status_summary__event_id
return v_status_summary;
end;' language 'plpgsql';
Let's see what else can be done. Thanks Ricardo Jorge
