Forum OpenACS Development: Re: News package notification bug
The sweeper query requires that the request creation_date <= notif_date which in this case is the publish date down to the day. See notification/tcl/sweep-procs-postgresql.xql
The same issue appears when the subset feature is used since the request is created ms after the item.
Ok so if someone requests notification for News at 10am on May 2 2012 then a new news item is created at 12pm on May 2 2012 the notification time is set to 12AM (00:00) on May 2, 2012 or time traveling back 12 hours to before the users subscribed.
OK, so the notification date for immediate publishing needs to be the creation timestamp correct?
This is the time that news should send to notifications pacakge.
I wouldn't worry about Oracle ...