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 -N --- openacs-4/packages/notifications/www/manage-postgresql.xql 18 Jun 2018 15:03:46 -0000 1.7 +++ /dev/null 1 Jan 1970 00:00:00 -0000 @@ -1,26 +0,0 @@ - - - - postgresql7.1 - - - - select nr.request_id, - nr.type_id, - nt.pretty_name as type, - acs_object__name(nr.object_id) as object_name, - ni.name as interval, - nr.object_id - from notification_requests nr, - notification_intervals ni, - notification_types nt - where nr.user_id = :user_id - and nr.interval_id = ni.interval_id - and nr.type_id = nt.type_id - and nr.user_id is not null - and nr.dynamic_p = 'f' - order by lower(nt.pretty_name), object_name - - - -