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.10 -r1.11
--- openacs-4/packages/acs-content-repository/sql/postgresql/content-image.sql	17 May 2003 09:43:09 -0000	1.10
+++ openacs-4/packages/acs-content-repository/sql/postgresql/content-image.sql	9 Nov 2003 03:33:00 -0000	1.11
@@ -269,7 +269,7 @@
 end; ' language 'plpgsql';
 
 
-create function image__new_revision(integer, integer, varchar, varchar, timestamptz, varchar, varchar,
+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;
@@ -283,7 +283,7 @@
    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.