Index: openacs-4/contrib/packages/survey/sql/postgresql/survey-package-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/survey/sql/postgresql/Attic/survey-package-create.sql,v diff -u -N -r1.2 -r1.2.2.1 --- openacs-4/contrib/packages/survey/sql/postgresql/survey-package-create.sql 26 Jan 2004 15:39:41 -0000 1.2 +++ openacs-4/contrib/packages/survey/sql/postgresql/survey-package-create.sql 19 Mar 2004 10:46:40 -0000 1.2.2.1 @@ -128,22 +128,22 @@ create or replace function survey_section__remove (integer) returns integer as ' declare - remove__section_id alias for $1; + remove_section_id alias for $1; v_question_row survey_questions%ROWTYPE; begin - delete from survey_branches where section_id=remove.section_id; - delete from survey_conditions where question_id in (select question_id from survey_questions where section_id=remove.section_id); + delete from survey_branches where section_id=remove_section_id; + delete from survey_conditions where question_id in (select question_id from survey_questions where section_id=remove_section_id); for v_question_row in select question_id from survey_questions - where section_id=remove__section_id + where section_id=remove_section_id loop PERFORM survey_question__remove(v_question_row.question_id); end loop; delete from survey_sections - where section_id = remove__section_id; + where section_id = remove_section_id; - PERFORM acs_object__delete(remove__section_id); + PERFORM acs_object__delete(remove_section_id); return 0;