Index: openacs-4/packages/bug-tracker/sql/postgresql/bug-tracker-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/bug-tracker/sql/postgresql/bug-tracker-create.sql,v
diff -u -N -r1.5.2.7 -r1.5.2.8
--- openacs-4/packages/bug-tracker/sql/postgresql/bug-tracker-create.sql	5 May 2003 18:05:53 -0000	1.5.2.7
+++ openacs-4/packages/bug-tracker/sql/postgresql/bug-tracker-create.sql	11 May 2003 21:47:23 -0000	1.5.2.8
@@ -502,7 +502,7 @@
     from   workflow_cases 
     where  object_id = p_bug_id;
 
-    perform workflow_case__delete(v_case_id);
+    perform workflow_case_pkg__delete(v_case_id);
 
     -- Every bug may have notifications attached to it
     -- and there is one column in the notificaitons datamodel that doesn''t
Index: openacs-4/packages/bug-tracker/sql/postgresql/upgrade-1.2d9-1.2d10.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/bug-tracker/sql/postgresql/upgrade-1.2d9-1.2d10.sql,v
diff -u -N
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/bug-tracker/sql/postgresql/upgrade-1.2d9-1.2d10.sql	11 May 2003 21:47:23 -0000	1.1.2.1
@@ -0,0 +1,44 @@
+-- Fixing the implementation of the bt_bug__delete function to work with 
+-- renamed workflow_case_pkg__delete function.
+--
+-- @author Lars Pind (lars@collaboraid.biz)
+--
+-- $Id: upgrade-1.2d9-1.2d10.sql,v 1.1.2.1 2003/05/11 21:47:23 lars Exp $
+
+create or replace function bt_bug__delete(
+   integer                      -- bug_id
+) returns integer
+as '
+declare
+    p_bug_id                    alias for $1;
+    v_case_id                   integer;
+    rec                         record;
+begin
+    -- Every bug is associated with a workflow case
+    select case_id 
+    into   v_case_id 
+    from   workflow_cases 
+    where  object_id = p_bug_id;
+
+    perform workflow_case_pkg__delete(v_case_id);
+
+    -- Every bug may have notifications attached to it
+    -- and there is one column in the notificaitons datamodel that doesn''t
+    -- cascade
+    for rec in select notification_id from notifications 
+               where response_id = p_bug_id loop
+
+        perform notification__delete (rec.notification_id);
+    end loop;
+
+    -- unset live & latest revision
+--    update cr_items
+--    set    live_revision = null,
+--           latest_revision = null
+--    where  item_id = p_bug_id;
+
+    perform content_item__delete(p_bug_id);
+
+    return 0;
+end;
+' language 'plpgsql';