Index: openacs-4/contrib/packages/project-manager/sql/postgresql/project-manager-functions-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/project-manager/sql/postgresql/Attic/project-manager-functions-create.sql,v
diff -u -r1.8.2.3 -r1.8.2.4
--- openacs-4/contrib/packages/project-manager/sql/postgresql/project-manager-functions-create.sql	13 Dec 2003 01:19:54 -0000	1.8.2.3
+++ openacs-4/contrib/packages/project-manager/sql/postgresql/project-manager-functions-create.sql	10 Jan 2004 01:04:02 -0000	1.8.2.4
@@ -260,6 +260,9 @@
 begin
         raise NOTICE ''Deleting pm_project...'';
 
+        delete from acs_permissions
+                where object_id = p_project_id;
+
         for v_child in select 
                 item_id
                 from 
@@ -599,6 +602,11 @@
 declare
         p_task_id                               alias for $1;
 begin
+        -- will not work because permissions are on revision_id not
+        -- item_id
+        -- delete from acs_permissions
+        --      where object_id = p_task_id;
+
         delete from pm_tasks_revisions
                 where task_revision_id in (select revision_id from pm_tasks_revisionsx where item_id = p_task_id);