Index: openacs-4/packages/acs-content-repository/sql/postgresql/content-item.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/postgresql/content-item.sql,v diff -u -r1.60 -r1.61 --- openacs-4/packages/acs-content-repository/sql/postgresql/content-item.sql 5 Jan 2005 15:39:46 -0000 1.60 +++ openacs-4/packages/acs-content-repository/sql/postgresql/content-item.sql 6 Jan 2005 16:52:25 -0000 1.61 @@ -42,7 +42,7 @@ end;' language 'plpgsql' stable; --- new 19 param version of content_item__new +-- new 19 param version of content_item__new (now its 20 with package_id) select define_function_args('content_item__new','name,parent_id,item_id,locale,creation_date;now,creation_user,context_id,creation_ip,item_subtype;content_item,content_type;content_revision,title,description,mime_type;text/plain,nls_language,text,data,relation_tag,is_live;f,storage_type;lob,package_id'); @@ -1265,9 +1265,8 @@ 7) delete all associated comments */ -select define_function_args('content_item__delete','item_id'); - -create or replace function content_item__delete (integer) +select define_function_args('content_item__del','item_id'); +create or replace function content_item__del (integer) returns integer as ' declare delete__item_id alias for $1; @@ -1391,6 +1390,15 @@ return 0; end;' language 'plpgsql'; +select define_function_args('content_item__delete','item_id'); +create or replace function content_item__delete (integer) +returns integer as ' +declare + delete__item_id alias for $1; +begin + PERFORM content_item__del (delete__item_id); + return 0; +end;' language 'plpgsql'; select define_function_args('content_item__edit_name','item_id,name');