Index: openacs-4/packages/assessment/sql/postgresql/upgrade/upgrade-0.22d3-0.22d4.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/sql/postgresql/upgrade/upgrade-0.22d3-0.22d4.sql,v diff -u -r1.3 -r1.3.6.1 --- openacs-4/packages/assessment/sql/postgresql/upgrade/upgrade-0.22d3-0.22d4.sql 7 Oct 2007 22:36:54 -0000 1.3 +++ openacs-4/packages/assessment/sql/postgresql/upgrade/upgrade-0.22d3-0.22d4.sql 18 Aug 2014 20:37:48 -0000 1.3.6.1 @@ -99,11 +99,16 @@ select define_function_args ('as_action__del','action_id'); -create or replace function as_action__del (integer) -returns integer as ' -declare - del__action_id alias for $1; -begin + + +-- +-- procedure as_action__del/1 +-- +CREATE OR REPLACE FUNCTION as_action__del( + del__action_id integer +) RETURNS integer AS $$ +DECLARE +BEGIN delete from as_action_params where action_id=del__action_id; @@ -113,7 +118,8 @@ PERFORM acs_object__delete (del__action_id); return del__action_id; -end;' language 'plpgsql'; +END; +$$ LANGUAGE plpgsql; alter table as_session_items drop constraint as_session_items_item_fk; alter table as_session_items drop constraint as_session_items_section_fk;