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 -N -r1.8 -r1.9 --- openacs-4/packages/acs-content-repository/sql/postgresql/content-image.sql 30 Nov 2002 17:15:25 -0000 1.8 +++ openacs-4/packages/acs-content-repository/sql/postgresql/content-image.sql 21 Dec 2002 22:32:31 -0000 1.9 @@ -120,7 +120,7 @@ -- The Oracle version does allow a non-image type to be specified, as does my -- alternative down below. This needs a little more straightening out. -create function image__new (varchar,integer,integer,integer,varchar,integer,varchar,varchar,varchar,varchar,boolean,timestamp,varchar,integer,integer,integer +create function image__new (varchar,integer,integer,integer,varchar,integer,varchar,varchar,varchar,varchar,boolean,timestamp with time zone,varchar,integer,integer,integer ) returns integer as ' declare new__name alias for $1; @@ -284,7 +284,7 @@ return v_item_id; end; ' language 'plpgsql'; -create function image__new_revision(integer, integer, varchar, varchar, timestamp, varchar, varchar, +create function image__new_revision(integer, integer, varchar, varchar, timestamp with time zone, varchar, varchar, integer, varchar, integer, integer) returns integer as ' declare p_item_id alias for $1;