Index: openacs-4/contrib/obsolete-packages/wf-ticket-tracker/sql/postgresql/wf-ticket-tracker-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/wf-ticket-tracker/sql/postgresql/wf-ticket-tracker-create.sql,v
diff -u -r1.3 -r1.3.4.1
--- openacs-4/contrib/obsolete-packages/wf-ticket-tracker/sql/postgresql/wf-ticket-tracker-create.sql	4 Mar 2002 16:38:40 -0000	1.3
+++ openacs-4/contrib/obsolete-packages/wf-ticket-tracker/sql/postgresql/wf-ticket-tracker-create.sql	2 Mar 2003 22:56:15 -0000	1.3.4.1
@@ -32,7 +32,7 @@
         varchar,	-- description  in wf_tickets.description%TYPE,
 	integer,	-- severity	in wf_tickets.severity%TYPE default 3,
 	integer,	-- priority 	in wf_tickets.priority%TYPE default 3,
-	timestamp,	-- creation_date   in acs_objects.creation_date%TYPE default sysdate,
+	timestamptz,	-- creation_date   in acs_objects.creation_date%TYPE default sysdate,
 	integer,	-- creation_user in acs_objects.creation_user%TYPE default null,
 	varchar		-- creation_ip	in acs_objects.creation_ip%TYPE default null
     ) returns integer as '
@@ -45,7 +45,7 @@
 	new__creation_date	alias for $6;
 	new__creation_user	alias for $7;
 	new__creation_ip	alias for $8;
-	v_creation_date		timestamp;
+	v_creation_date		timestamptz;
         v_ticket_id number;
 	v_case_id number;
     begin
@@ -107,4 +107,4 @@
 	from   wf_tickets
 	where  ticket_id = name__ticket_id;
 	return v_subject;
-    end;' language 'plpgsql';
\ No newline at end of file
+    end;' language 'plpgsql';
