Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0002970Openbravo ERP09. Financial managementpublic2008-05-16 23:332008-06-18 18:07
Reporterxanagu 
Assigned Todalsasua 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version2.40alpha-r2 
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
Summary0002970: trigger cause failed inserts in postgres
DescriptionI just found what i can't create new banks because the 'before' trigger assigned is looking for 'old' values.

The conditions inside the trigger treat the same way the insert and updates.

Meanwhile :

 - In the case of the trigger for create new banks, u can just change the 'IF' contidion for Update only and compile the trigger.
 - In others cases, i dunno O__o, depends of a mayor review of the trigger.

P.D. I dont remember well if Oracle fill with Null the records needed. In that case, should be no problem.

-----------------------
WINDOWS SERVER 2003
APACHE TOMCAT 5.5
APACHE ANT 2.2
OPENBRAVO2.40 ALPHA r4089
POSTGRES SQL 8.2.9
NVIDIA MSI 3SLI 6800GTX
-----------------------

Cyaa.
Steps To Reproduce
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-06-18 18:07psarobeStatusresolved => closed

Notes
(0006559)
user71   
2005-06-01 00:00   
(edited on: 2008-06-12 09:43)
This bug was originally reported in SourceForge bug tracker and then migrated to Mantis.

You can see the original bug report in:
https://sourceforge.net/support/tracker.php?aid=1965674 [^]
(0003684)
dalsasua   
2008-05-19 13:27   
(edited on: 2008-06-12 09:26)
Logged In: YES
user_id=1924288
Originator: NO

We have tested this bug in the subversion repository and it has just been fixed.

Note that the only supported version of the application is the one in subversion. So it is possible that this was a bug in a previous version that is already fixed.
(0003685)
dalsasua   
2008-05-19 13:27   
(edited on: 2008-06-12 09:26)
Logged In: YES
user_id=1924288
Originator: NO

C_BANKACCOUNTIBAN_TRG and C_BANKCOUNTRY_TRG triggers modified
(0003686)
cromero   
2008-05-19 17:22   
(edited on: 2008-06-12 09:26)
Logged In: YES
user_id=1500614
Originator: NO

Revision: 4330