Index: openacs-4/packages/acs-content-repository/sql/postgresql/content-image.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/postgresql/content-image.sql,v
diff -u -r1.7.2.4 -r1.7.2.5
--- openacs-4/packages/acs-content-repository/sql/postgresql/content-image.sql	1 Mar 2003 21:21:20 -0000	1.7.2.4
+++ openacs-4/packages/acs-content-repository/sql/postgresql/content-image.sql	10 Nov 2003 02:42:08 -0000	1.7.2.5
@@ -268,8 +268,7 @@
     return v_item_id;
 end; ' language 'plpgsql';
 
-create function image__new_revision(integer, integer, varchar, varchar, timestamptz, varchar, varchar,
-                                    integer, varchar, integer, integer) returns integer as '
+create or replace function image__new_revision(integer, integer, varchar, varchar, timestamptz, varchar, varchar, integer, varchar, integer, integer) returns integer as '
 declare
    p_item_id          alias for $1;
    p_revision_id      alias for $2;
@@ -282,11 +281,11 @@
    p_creation_ip      alias for $9;
    p_height           alias for $10;
    p_width            alias for $11;
-
+   v_revision_id      integer;
 begin
     -- We will let the caller fill in the LOB data or file path.
 
-    v_revision_id := content_revision__new (
+  v_revision_id := content_revision__new (
       p_title,
       p_description,
       p_publish_date,
Index: openacs-4/packages/acs-content-repository/sql/postgresql/content-item.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/postgresql/content-item.sql,v
diff -u -r1.39.2.5 -r1.39.2.6
--- openacs-4/packages/acs-content-repository/sql/postgresql/content-item.sql	7 Nov 2003 02:05:36 -0000	1.39.2.5
+++ openacs-4/packages/acs-content-repository/sql/postgresql/content-item.sql	10 Nov 2003 02:42:08 -0000	1.39.2.6
@@ -1682,9 +1682,6 @@
           content_item__get_content_type(content_symlink__resolve(move__item_id)),''f'') = ''t''
       then
     -- update the parent_id for the item
-    if move__name = '''' then
-	move__name := NULL;
-    end if;
 
     update cr_items 
       set parent_id = move__target_folder_id,