OK, here is the fix for ACS Events to work with PostgreSQL ( PG ) 8.1
The fix was made available with the great help from Michael Steigman.
======= 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';
becomes =========>
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; ( missing ";" )
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';
becomes =========>
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; ( missing ";" )
return v_status_summary;
end;' language 'plpgsql';
============================
So, this *all* you need to make ACS Events work with PG 8.1
Thanks Ricardo Jorge
