Index: openacs-4/packages/ratings/sql/postgresql/ratings-procs.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/ratings/sql/postgresql/ratings-procs.sql,v diff -u -r1.3 -r1.3.2.1 --- openacs-4/packages/ratings/sql/postgresql/ratings-procs.sql 21 May 2004 22:53:02 -0000 1.3 +++ openacs-4/packages/ratings/sql/postgresql/ratings-procs.sql 29 Jul 2005 23:08:24 -0000 1.3.2.1 @@ -23,7 +23,6 @@ p_range_high alias for $6; p_label_low alias for $7; p_label_high alias for $8; - p_package_id alias for $9; p_creation_date alias for $10; -- default now() p_creation_user alias for $11; -- default null @@ -41,8 +40,8 @@ p_context_id, ''t''); - insert into rating_dimensions (dimension_id,dimension_key,description,range_low,range_high,label_low,label_high) - values (v_dimension_id,p_dimension_key,p_description,p_range_low,p_range_high,p_label_low,p_label_high); + insert into rating_dimensions (dimension_id,dimension_key,description,range_low,range_high,label_low,label_high,title) + values (v_dimension_id,p_dimension_key,p_description,p_range_low,p_range_high,p_label_low,p_label_high,p_title); return v_dimension_id; @@ -82,6 +81,9 @@ raise NOTICE ''rating_dimension__delete object_id % does not exist or is not a rating_dimension'',p_dimension_id; return 0; end if; + + delete from rating_dimensions where dimension_id = p_dimension_id; + end;' language 'plpgsql';