Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0004556Openbravo ERP05. Production managementpublic2008-08-01 16:562009-04-21 11:05
shuehner 
cromero 
normalminorhave not tried
closedfixed 
5
pi 
 
Core
No
0004556: The 'Insert Maintenances' process does not work on postgresql-8.3
This process gives the following error message when used with postgresql-8.3

      
Error:
function add_months(timestamp without time zone, double precision) does not exist
Setup some scheduled maintenance for a machine
Run the 'Insert Maintenance' process
insert maintenances, maintenances
Issue History
2008-08-01 16:56shuehnerNew Issue
2008-08-01 16:56shuehnerAssigned To => cromero
2008-08-01 16:56shuehnersf_bug_id0 => 2034995
2008-08-01 16:58svnbotCheckin
2008-08-01 16:58svnbotNote Added: 0008464
2008-08-01 16:58svnbotStatusnew => resolved
2008-08-01 16:58svnbotResolutionopen => fixed
2008-08-01 16:58svnbotsvn_revision => 6121
2008-09-25 23:32ewilliamsTag Attached: insert maintenances
2008-09-25 23:32ewilliamsTag Attached: maintenances
2008-09-25 23:51ewilliamsIssue Monitored: ewilliams
2009-04-21 11:05psarobeStatusresolved => closed

Notes
(0008464)
svnbot   
2008-08-01 16:58   
Repository: openbravo
Revision: 6121
Author: huehner
Date: 2008-08-01 16:58:38 +0200 (Fri, 01 Aug 2008)

Fixed bug 4556
Use explicit cast to number when calling the add_month function on pgsql-8.3

---
U trunk/src-db/database/model/functions/MA_MAINTENANCE_SCHEDULE.xml
---

https://dev.openbravo.com/websvn/openbravo/?rev=6121&sc=1 [^]