Index: openacs-4/contrib/packages/project-manager/tcl/calendar-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/project-manager/tcl/Attic/calendar-procs-postgresql.xql,v
diff -u -r1.1.2.1 -r1.1.2.2
--- openacs-4/contrib/packages/project-manager/tcl/calendar-procs-postgresql.xql	5 Aug 2004 00:03:45 -0000	1.1.2.1
+++ openacs-4/contrib/packages/project-manager/tcl/calendar-procs-postgresql.xql	6 Aug 2004 18:28:18 -0000	1.1.2.2
@@ -32,19 +32,25 @@
         to_char(t.earliest_start,'YYYY-MM-DD HH24:MI') as earliest_start,
         to_char(t.earliest_finish,'YYYY-MM-DD HH24:MI') as earliest_finish,
         to_char(t.latest_start,'YYYY-MM-DD HH24:MI') as latest_start,
-        to_char(t.latest_finish,'YYYY-MM-DD HH24:MI') as latest_finish
+        to_char(t.latest_finish,'YYYY-MM-DD HH24:MI') as latest_finish,
+        p.first_names || ' ' || p.last_name as full_name,
+        p.person_id
         FROM
         pm_tasks_active ts, 
         cr_items i,
         pm_tasks_revisionsx t 
+          LEFT JOIN pm_task_assignment ta
+          ON t.item_id = ta.task_id
+            LEFT JOIN persons p 
+            ON ta.party_id = p.person_id
         WHERE
         ts.task_id  = t.item_id and
         i.item_id   = t.item_id and
         t.task_revision_id = i.live_revision and
       t.latest_start >= :first_of_month_date and
       t.latest_start <= :last_of_month_date
       ORDER BY
-      t.earliest_start
+      t.earliest_start, ts.task_id, p.first_names, p.last_name
 </querytext>
 </fullquery>