Index: openacs-4/contrib/obsolete-packages/ticket-tracker/sql/postgresql/ticket-tracker-packages.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/ticket-tracker/sql/postgresql/ticket-tracker-packages.sql,v diff -u -N -r1.2 -r1.3 --- openacs-4/contrib/obsolete-packages/ticket-tracker/sql/postgresql/ticket-tracker-packages.sql 12 Jun 2001 06:25:48 -0000 1.2 +++ openacs-4/contrib/obsolete-packages/ticket-tracker/sql/postgresql/ticket-tracker-packages.sql 12 Jun 2001 06:27:49 -0000 1.3 @@ -17,7 +17,6 @@ -- create or replace package body ttracker_ticket -- as -drop function ttracker_ticket__new (integer,varchar,integer,varchar,varchar,varchar,integer,integer,integer,timestamp,integer,varchar); create function ttracker_ticket__new (integer,varchar,integer,varchar,varchar,varchar,integer,integer,integer,timestamp,integer,varchar) returns integer as ' declare @@ -37,7 +36,6 @@ v_case_id wf_cases.case_id%TYPE; begin -- create a new acs-message to hold the contents of the ticket -raise notice '' 1''; v_ticket_id := acs_message__new ( p_ticket_id, -- message_id null, -- reply_to @@ -56,7 +54,6 @@ p_object_type, -- object_type ''t'' -- is_live ); -raise notice '' 2''; -- insert additional ticket info insert into ttracker_tickets @@ -76,7 +73,6 @@ p_severity, p_priority); -raise notice '' 3''; -- create a new case v_case_id := workflow_case__new ( null, -- case_id @@ -88,7 +84,6 @@ p_creation_ip -- creation_ip ); -raise notice '' 4''; -- start the case perform workflow_case__start_case ( v_case_id, -- case_id @@ -97,7 +92,6 @@ null -- msg ); -raise notice '' 5''; return v_ticket_id; end;' language 'plpgsql'; @@ -645,7 +639,6 @@ return 0; end;' language 'plpgsql'; -drop function ttracker_callback__notification (integer,varchar,integer,integer,varchar,varchar); create function ttracker_callback__notification (integer,varchar,integer,integer,varchar,varchar) returns integer as ' declare