Atlassian uses cookies to improve your browsing experience, perform analytics and research, and conduct advertising. Accept all cookies to indicate that you agree to our use of cookies on your device. Atlassian cookies and tracking notice, (opens new window)
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
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.