Index: openacs.org-dev/packages/notifications/www/manage-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs.org-dev/packages/notifications/www/manage-postgresql.xql,v
diff -u -r1.1 -r1.2
--- openacs.org-dev/packages/notifications/www/manage-postgresql.xql	8 Oct 2002 15:47:15 -0000	1.1
+++ openacs.org-dev/packages/notifications/www/manage-postgresql.xql	14 Jan 2003 22:57:25 -0000	1.2
@@ -5,11 +5,32 @@
 
 <fullquery name="select_notifications">      
       <querytext>
-	select request_id, 
+	select request_id,
+	       type_id,
 	  (select pretty_name
 	   from notification_types
 	   where notification_types.type_id =
 	         notification_requests.type_id) as type, 
+                acs_object__name(notification_requests.object_id)
+                     as object_name,
+	   (select name
+	   from notification_intervals
+	   where notification_intervals.interval_id =
+	         notification_requests.interval_id) as interval,
+	   object_id
+	from notification_requests
+	where user_id = :user_id
+      </querytext>
+</fullquery>
+
+<fullquery name="select_notifications_saved">      
+      <querytext>
+	select request_id,
+	       type_id,
+	  (select pretty_name
+	   from notification_types
+	   where notification_types.type_id =
+	         notification_requests.type_id) as type, 
            case when (select short_name 
 	           from notification_types 
                    where notification_types.type_id =