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.28 -r1.29
--- openacs-4/packages/acs-content-repository/sql/postgresql/content-revision.sql	8 Dec 2001 01:17:59 -0000	1.28
+++ openacs-4/packages/acs-content-repository/sql/postgresql/content-revision.sql	27 Feb 2002 05:02:35 -0000	1.29
@@ -667,7 +667,7 @@
   v_lob_id                            integer;
   v_data                              text;
 begin
-       select i.storage_type, r.lob, 
+       select i.storage_type, r.lob 
          into v_storage_type, v_lob_id
          from cr_items i, cr_revisions r
         where i.item_id = r.item_id 
@@ -678,12 +678,11 @@
         else 
            return content
              from cr_revisions
-            where revision_id = get_content_revision_id;
+            where revision_id = get_content__revision_id;
         end if;
 
 end;' language 'plpgsql';
 
-
 -- show errors
 
 -- Trigger to maintain latest_revision in cr_items