Index: openacs-4/packages/cms/tcl/item-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/cms/tcl/Attic/item-procs-postgresql.xql,v
diff -u -N -r1.3 -r1.4
--- openacs-4/packages/cms/tcl/item-procs-postgresql.xql	30 Aug 2001 01:46:05 -0000	1.3
+++ openacs-4/packages/cms/tcl/item-procs-postgresql.xql	31 Aug 2001 12:25:10 -0000	1.4
@@ -68,7 +68,8 @@
       
     select 't' from cr_revisions r, cr_items i
       where r.revision_id = :revision_id
-      and ((r.content is not null and i.storage_type in ('file','text')) or
+        and i.item_id = r.item_id
+        and ((r.content is not null and i.storage_type in ('file','text')) or
       (r.lob is not null and i.storage_type = 'lob'))
 
       </querytext>