Index: openacs-4/contrib/obsolete-packages/acs-workflow/sql/postgresql/workflow-case-package-body.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/sql/postgresql/workflow-case-package-body.sql,v diff -u -r1.5 -r1.6 --- openacs-4/contrib/obsolete-packages/acs-workflow/sql/postgresql/workflow-case-package-body.sql 12 Feb 2002 01:35:16 -0000 1.5 +++ openacs-4/contrib/obsolete-packages/acs-workflow/sql/postgresql/workflow-case-package-body.sql 21 Dec 2002 22:30:11 -0000 1.6 @@ -1,6 +1,6 @@ -- create or replace package body workflow_case -- function new -create function workflow_case__new (integer,varchar,varchar,integer,timestamp,integer,varchar) +create function workflow_case__new (integer,varchar,varchar,integer,timestamp with time zone,integer,varchar) returns integer as ' declare new__case_id alias for $1; -- default null @@ -855,7 +855,7 @@ -- procedure set_case_deadline -create function workflow_case__set_case_deadline (integer,varchar,timestamp) +create function workflow_case__set_case_deadline (integer,varchar,timestamp with time zone) returns integer as ' declare set_case_deadline__case_id alias for $1; @@ -2063,8 +2063,6 @@ if not found then raise error ''Case % has no transition with key %'', get_task_id__case_id, get_task_id__transition_key; - return v_task_id; + return v_task_id;end;' language 'plpgsql'; -end;' language 'plpgsql'; -