Index: openacs-4/packages/notifications/www/manage-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/notifications/www/manage-postgresql.xql,v
diff -u -r1.1 -r1.1.2.1
--- openacs-4/packages/notifications/www/manage-postgresql.xql	20 Sep 2002 21:19:01 -0000	1.1
+++ openacs-4/packages/notifications/www/manage-postgresql.xql	20 Nov 2002 23:07:13 -0000	1.1.2.1
@@ -9,28 +9,8 @@
 	  (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 = 
-                         notification_requests.type_id) = 'forums_forum_notif'
-                then     
-                   (select name 
-	            from forums_forums 
-		    where forum_id = 
-                    notification_requests.object_id)
-                when  (select short_name 
-	           from notification_types 
-                   where notification_types.type_id = 
-                         notification_requests.type_id) = 'forums_message_notif'
-                then 
-                    (select subject 
-                     from forums_messages 
-                     where message_id = 
-                     notification_requests.object_id)
-                else 
-                    acs_object__name(notification_requests.object_id)
-                end as object_name,
+	         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 =