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.25 -r1.26
--- openacs-4/packages/acs-content-repository/sql/postgresql/content-revision.sql	30 Aug 2001 04:01:35 -0000	1.25
+++ openacs-4/packages/acs-content-repository/sql/postgresql/content-revision.sql	31 Aug 2001 02:28:40 -0000	1.26
@@ -205,7 +205,7 @@
     cols := cols || '', '' || attr_rec.attribute_name;
   end loop;
 
-  execute ''insert into '' || v_table_name || '' select '' || copy_id || 
+  execute ''insert into '' || v_table_name || '' select '' || copy_attributes__copy_id || 
           '' as '' || v_id_column || cols || '' from '' || 
           v_table_name || '' where '' || v_id_column || '' = '' || 
           copy_attributes__revision_id;
@@ -265,10 +265,16 @@
   -- create the basic revision (using v_target_item_id)
   insert into cr_revisions 
       select 
-        v_copy_id as revision_id, v_target_item_id as item_id, title, 
-        description, publish_date, 
-        mime_type, nls_language, 
-	content
+        v_copy_id as revision_id, 
+        v_target_item_id as item_id, 
+        title, 
+        description, 
+        publish_date, 
+        mime_type, 
+        nls_language, 
+        lob,
+	content,
+        content_length
       from 
         cr_revisions 
       where
Index: openacs-4/packages/cms/www/modules/templates/index-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/cms/www/modules/templates/index-postgresql.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/cms/www/modules/templates/index-postgresql.xql	8 Jun 2001 01:44:53 -0000	1.1
+++ openacs-4/packages/cms/www/modules/templates/index-postgresql.xql	31 Aug 2001 02:28:40 -0000	1.2
@@ -35,7 +35,7 @@
   select
     t.template_id, i.name, 
     to_char(o.last_modified, 'MM/DD/YY HH:MI AM') as modified,
-    coalesce(round(r.content_length::float8 / 1000), 0) || ' KB' as file_size
+    coalesce(round(r.content_length::float8 / 1000,2), 0)::float8::text || ' KB'::text as file_size
   from
     cr_templates t, acs_objects o, 
     cr_revisions r 
Index: openacs-4/packages/cms/www/modules/templates/revisions-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/cms/www/modules/templates/revisions-postgresql.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/cms/www/modules/templates/revisions-postgresql.xql	8 Jun 2001 01:44:53 -0000	1.1
+++ openacs-4/packages/cms/www/modules/templates/revisions-postgresql.xql	31 Aug 2001 02:28:40 -0000	1.2
@@ -9,7 +9,7 @@
   select
     revision_id,
     to_char(o.creation_date, 'MM/DD/YY HH:MI AM') as modified,
-    (round(r.content_length::float8 / 1000.0) || ' KB') as file_size,
+    (round(r.content_length::float8 / 1000.0,2)::float8::text || ' KB'::text) as file_size,
     case when coalesce(p.person_id, 0) = 0 
             then '-' 
             else substr(p.first_names, 1, 1) || substr(p.last_name, 1, 1) end as modified_by,