Index: openacs-4/contrib/obsolete-packages/ticket-tracker/www/ticket-add-2-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/ticket-tracker/www/ticket-add-2-postgresql.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/contrib/obsolete-packages/ticket-tracker/www/ticket-add-2-postgresql.xql	12 Jun 2001 06:25:49 -0000	1.2
+++ openacs-4/contrib/obsolete-packages/ticket-tracker/www/ticket-add-2-postgresql.xql	9 Jul 2001 15:42:52 -0000	1.3
@@ -6,10 +6,7 @@
 <fullquery name="insert_ticket">      
 <querytext>
 
-declare
-  v_ticket_id  acs_objects.object_id%TYPE;
-begin
-  v_ticket_id := ttracker_ticket__new (
+select ttracker_ticket__new (
 	null,				-- ticket_id
 	'ttracker_ticket',	-- object_type
     :package_id,		-- context_id    
@@ -24,15 +21,6 @@
     :creation_ip 		-- creation_ip  
   );
 
-  perform acs_permission__grant_permission(
-    v_ticket_id,		-- object_id
-    :user_id,			-- grantee_id
-    'write'				-- privilege
-  );        
-
-  return 0;
-end;
-
 </querytext>
 </fullquery>
 
Index: openacs-4/contrib/obsolete-packages/ticket-tracker/www/ticket-add-2.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/ticket-tracker/www/ticket-add-2.tcl,v
diff -u -r1.1 -r1.2
--- openacs-4/contrib/obsolete-packages/ticket-tracker/www/ticket-add-2.tcl	20 Apr 2001 20:51:25 -0000	1.1
+++ openacs-4/contrib/obsolete-packages/ticket-tracker/www/ticket-add-2.tcl	9 Jul 2001 15:42:52 -0000	1.2
@@ -20,9 +20,6 @@
 set package_id [ad_conn package_id]
 set creation_ip [ad_conn peeraddr]
 
-# We are granting 'write' permissions instead of 'admin' since
-# we do not want the user to have privileges of managing
-# permissions on this ticket. 
 db_exec_plsql insert_ticket {
     declare
         v_ticket_id  acs_objects.object_id%TYPE;
Index: openacs-4/contrib/obsolete-packages/ticket-tracker/www/tickets-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/ticket-tracker/www/tickets-postgresql.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/contrib/obsolete-packages/ticket-tracker/www/tickets-postgresql.xql	12 Jun 2001 06:25:49 -0000	1.1
+++ openacs-4/contrib/obsolete-packages/ticket-tracker/www/tickets-postgresql.xql	9 Jul 2001 15:42:52 -0000	1.2
@@ -151,7 +151,7 @@
                          where wta1.task_id = (select max(wt.task_id) 
                                                  from wf_tasks wt
                                                  where wt.case_id = wc.case_id and 
-                                                       wt.transition_key = 'resolve')) as tasks
+                                                       wt.transition_key = 'resolve'))
            $view_where
            [ad_dimensional_sql $dimensional]) results
 [ad_order_by_from_sort_spec $orderby $table_def]