Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0002970
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementminoralways2008-05-16 23:332008-06-18 18:07
ReporterxanaguView Statuspublic 
Assigned Todalsasua 
PrioritynormalResolutionfixedFixed in Version2.40alpha-r2
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
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
Summary

0002970: 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.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0003684)
dalsasua (viewer)
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 (viewer)
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 (viewer)
2008-05-19 17:22
edited on: 2008-06-12 09:26

Logged In: YES
user_id=1500614
Originator: NO

Revision: 4330
(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 [^]

- Issue History
Date Modified Username Field Change
2008-06-18 18:07 psarobe Status resolved => closed


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker