Index: openacs-4/packages/acs-kernel/sql/postgresql/apm-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/apm-create.sql,v
diff -u -r1.29.2.1 -r1.29.2.2
--- openacs-4/packages/acs-kernel/sql/postgresql/apm-create.sql	29 Oct 2002 01:51:45 -0000	1.29.2.1
+++ openacs-4/packages/acs-kernel/sql/postgresql/apm-create.sql	21 Jan 2003 13:46:20 -0000	1.29.2.2
@@ -1636,7 +1636,7 @@
 
 
 -- function new
-create function apm_package__new (integer,varchar,varchar,varchar,timestamp,integer,varchar,integer)
+create function apm_package__new (integer,varchar,varchar,varchar,timestamp with time zone,integer,varchar,integer)
 returns integer as '
 declare
   new__package_id             alias for $1;  -- default null  
@@ -1864,7 +1864,7 @@
 end;' language 'plpgsql';
 
 -- create or replace package body apm_package_version 
-create function apm_package_version__new (integer,varchar,varchar,varchar,varchar,varchar,varchar,timestamp,varchar,varchar,boolean,boolean) returns integer as '
+create function apm_package_version__new (integer,varchar,varchar,varchar,varchar,varchar,varchar,timestamp with time zone,varchar,varchar,boolean,boolean) returns integer as '
 declare
       apm_pkg_ver__version_id           alias for $1;  -- default null
       apm_pkg_ver__package_key		alias for $2;
@@ -1880,7 +1880,7 @@
       apm_pkg_ver__data_model_loaded_p	alias for $12; -- default ''f''
       v_version_id                      apm_package_versions.version_id%TYPE;
 begin
-      if apm_pkg_ver__version_id = '''' or apm_pkg_ver__version_id is null then
+      if apm_pkg_ver__version_id is null then
          select nextval(''t_acs_object_id_seq'')
 	 into v_version_id
 	 from dual;
@@ -2015,7 +2015,7 @@
 
 
 -- function edit
-create function apm_package_version__edit (integer,integer,varchar,varchar,varchar,varchar,varchar,timestamp,varchar,varchar,boolean,boolean)
+create function apm_package_version__edit (integer,integer,varchar,varchar,varchar,varchar,varchar,timestamp with time zone,varchar,varchar,boolean,boolean)
 returns integer as '
 declare
   edit__new_version_id         alias for $1;  -- default null  
@@ -2559,7 +2559,7 @@
 
 
 -- function new
-create function apm_application__new (integer,varchar,varchar,varchar,timestamp,integer,varchar,integer)
+create function apm_application__new (integer,varchar,varchar,varchar,timestamp with time zone,integer,varchar,integer)
 returns integer as '
 declare
   application_id         alias for $1;  -- default null  
@@ -2609,7 +2609,7 @@
 
 -- create or replace package body apm_service
 -- function new
-create function apm_service__new (integer,varchar,varchar,varchar,timestamp,integer,varchar,integer)
+create function apm_service__new (integer,varchar,varchar,varchar,timestamp with time zone,integer,varchar,integer)
 returns integer as '
 declare
   service_id             alias for $1;  -- default null