Event Analysis Report should be usable on postgres older than 8.4
Description
The Event-Analysis report contains GENERATE_SERIES(DATE_TRUNC('hours',NOW())-INTERVAL '30 days', NOW(),'1 hours') this function is only available in postgres 8.4+. Find a replacement for postgres < 8.4. This functions are used in the charts events per hour and events per day chart.
Environment
OpenNMS 1.8.12
Acceptance / Success Criteria
None
Lucidchart Diagrams
Activity
Show:
Benjamin Reed June 12, 2011 at 10:22 AM
I went ahead and backported this to 1.8 and 1.10. Also, you forgot to mark as resolved.
Ronny Trommer June 12, 2011 at 8:31 AM
Fixed in master with commit 079610fdb06c2e7153a2041d0d048a46bf6d2e91
The Event-Analysis report contains GENERATE_SERIES(DATE_TRUNC('hours',NOW())-INTERVAL '30 days', NOW(),'1 hours') this function is only available in postgres 8.4+. Find a replacement for postgres < 8.4. This functions are used in the charts events per hour and events per day chart.