Index: openacs-4/packages/acs-tcl/tcl/apm-file-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-tcl/tcl/apm-file-procs-postgresql.xql,v
diff -u -r1.10 -r1.11
--- openacs-4/packages/acs-tcl/tcl/apm-file-procs-postgresql.xql	6 May 2001 14:30:08 -0000	1.10
+++ openacs-4/packages/acs-tcl/tcl/apm-file-procs-postgresql.xql	12 May 2001 05:09:48 -0000	1.11
@@ -83,11 +83,12 @@
 <fullquery name="apm_extract_tarball.distribution_tar_ball_select">      
       <querytext>
 
-   select '[cr_fs_path]' || content as content, storage_type
-     from cr_revisions 
-    where revision_id = (select content_item__get_latest_revision(item_id)
-                           from apm_package_versions 
-                          where version_id = :version_id)
+   select '[cr_fs_path]' || r.content as content, i.storage_type
+     from cr_revisions r, cr_items i
+    where r.item_id = i.item_id
+      and r.revision_id = (select content_item__get_latest_revision(item_id)
+                             from apm_package_versions 
+                            where version_id = :version_id)
 
       </querytext>
 </fullquery>