-- -- category_tree__del/1 -- create or replace function category_tree__del( integer ) returns int4 as $$ declare p_tree_id alias for $1; begin delete from category_tree_map where tree_id = p_tree_id; delete from category_object_map where category_id in (select category_id from categories where tree_id = p_tree_id); delete from category_translations where category_id in (select category_id from categories where tree_id = p_tree_id); delete from categories where tree_id = p_tree_id; delete from acs_objects where context_id = p_tree_id; delete from acs_permissions where object_id = p_tree_id; delete from category_tree_translations where tree_id = p_tree_id; delete from category_trees where tree_id = p_tree_id; perform acs_object__delete(p_tree_id); return 0; end; $$ language plpgsql;