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 -r1.9
--- openacs-4/contrib/packages/project-manager/sql/postgresql/project-manager-functions-create.sql	29 Aug 2003 00:35:35 -0000	1.8
+++ openacs-4/contrib/packages/project-manager/sql/postgresql/project-manager-functions-create.sql	26 Nov 2003 13:33:23 -0000	1.9
@@ -19,9 +19,9 @@
 returns varchar as '
 declare
     p_pm_project_id      alias for $1;
-    v_pm_project_name    pm_projects.project_name%TYPE;
+    v_pm_project_name    varchar;
 begin
-        select project_name || ''_'' || p_pm_project_id into v_pm_project_name
+        select project_code || ''_'' || p_pm_project_id into v_pm_project_name
                 from pm_projects
                 where project_id = p_pm_project_id;
     return v_pm_project_name;
@@ -402,7 +402,7 @@
 returns varchar as '
 declare
     p_pm_task_id         alias for $1;
-    v_pm_task_name       pm_tasks.title%TYPE;
+    v_pm_task_name       cr_items.name%TYPE;
 begin
         select i.name || ''_'' || p_pm_task_id into v_pm_project_name
                 from cr_items i