Index: openacs-4/contrib/packages/project-manager/www/task-assign-add-edit-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/project-manager/www/Attic/task-assign-add-edit-postgresql.xql,v
diff -u -r1.4.2.1 -r1.4.2.2
--- openacs-4/contrib/packages/project-manager/www/task-assign-add-edit-postgresql.xql	10 Jan 2004 01:04:02 -0000	1.4.2.1
+++ openacs-4/contrib/packages/project-manager/www/task-assign-add-edit-postgresql.xql	14 Jan 2004 19:26:22 -0000	1.4.2.2
@@ -121,9 +121,12 @@
       select
         title
 	FROM
-        pm_projectsx
+        pm_projects p, cr_revisions r, cr_items i
         WHERE
-        item_id = :project_item_id
+        r.item_id = :project_item_id and
+        i.item_id = r.item_id and
+        p.project_id = i.live_revision and
+        p.project_id = r.revision_id
     </querytext>
   </fullquery>