Index: openacs-4/packages/acs-content-repository/sql/postgresql/content-revision.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/postgresql/content-revision.sql,v
diff -u -r1.18 -r1.19
--- openacs-4/packages/acs-content-repository/sql/postgresql/content-revision.sql	13 May 2001 01:55:58 -0000	1.18
+++ openacs-4/packages/acs-content-repository/sql/postgresql/content-revision.sql	17 May 2001 03:59:04 -0000	1.19
@@ -327,7 +327,7 @@
   v_item_id              cr_items.item_id%TYPE;
   v_latest_revision      cr_revisions.revision_id%TYPE;
   v_live_revision        cr_revisions.revision_id%TYPE;
-                                        
+  v_rec                  record;                                      
 begin
 
   -- Get item id and latest/live revisions
@@ -346,7 +346,7 @@
   -- Recalculate latest revision
   if v_latest_revision = delete__revision_id then
       for v_rec in 
-          select r.revision_id into v_latest_revision 
+          select r.revision_id
             from cr_revisions r, acs_objects o
            where o.object_id = r.revision_id
              and r.item_id = v_item_id