Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0004637Openbravo ERP00. Application dictionarypublic2008-08-18 18:252008-09-04 10:27
Reporteriperdomo 
Assigned Toiperdomo 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS Version2.6.23-gentoo-r9
Product Version 
Target VersionpiFixed in Version2.40 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0004637: The function update_dateFormat in the PostgreSQL pre-script must be volatile
DescriptionThe function update_dateFormat in the PostgreSQL pre-script must be VOLATILE since it recreates the dateFormat() function
A STABLE or IMMUTABLE function cannot modify the database [1]

[1] http://www.postgresql.org/docs/8.0/static/xfunc-volatility.html [^]
Steps To Reproduce
Proposed SolutionChange the function to VOLATILE
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-08-18 18:25iperdomoNew Issue
2008-08-18 18:25iperdomoAssigned To => iperdomo
2008-08-18 18:25iperdomosf_bug_id0 => 2057886
2008-08-18 18:25iperdomoOBNetwork customer => No
2008-08-18 18:25iperdomoRegression testing => No
2008-08-18 18:26iperdomoStatusnew => scheduled
2008-08-18 18:26iperdomofix_in_branch => trunk
2008-08-18 18:27svnbotCheckin
2008-08-18 18:27svnbotNote Added: 0008597
2008-08-18 18:27svnbotStatusscheduled => resolved
2008-08-18 18:27svnbotResolutionopen => fixed
2008-08-18 18:27svnbotsvn_revision => 6383
2008-09-01 10:40svnbotCheckin
2008-09-01 10:40svnbotNote Added: 0008800
2008-09-01 10:40svnbotsvn_revision6383 => 6680
2008-09-04 10:27psarobeStatusresolved => closed
2008-09-04 10:27psarobeFixed in Version => 2.40

Notes
(0008597)
svnbot   
2008-08-18 18:27   
Repository: openbravo
Revision: 6383
Author: iperdomo
Date: 2008-08-18 18:27:24 +0200 (Mon, 18 Aug 2008)

Fixes bug 4637: Changed function type to volatile

---
U trunk/src-db/database/model/prescript-PostgreSql.sql
---

https://dev.openbravo.com/websvn/openbravo/?rev=6383&sc=1 [^]
(0008800)
svnbot   
2008-09-01 10:40   
Repository: openbravo
Revision: 6680
Author: iperdomo
Date: 2008-09-01 10:40:47 +0200 (Mon, 01 Sep 2008)

Related to issue 4637: Changed function to be volatile

---
U branches/r2.5x/src-db/database/model/prescript-PostgreSql.sql
---

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