Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0038629Openbravo ERPA. Platformpublic2018-05-25 12:182018-06-13 15:25
Reporteralostale 
Assigned Toalostale 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0PR18Q3 
Merge Request Status
Review Assigned ToAugustoMauch
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0038629: do not use ad_session_status to disable PG triggers
DescriptionDetailed in http://wiki.openbravo.com/wiki/Projects:Improved_Trigger_Disabling_In_PostgreSQL [^]
Steps To Reproduce-
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
depends on defect 0038642 closed platform API change: removed ad_session_status table 
related to design defect 0054980 closed Triage Platform Base Audit Trail infrestrucuture is creating temporary tables that could end on getting the limit of elements created in postgresql 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2018-05-25 12:18alostaleNew Issue
2018-05-25 12:18alostaleAssigned To => alostale
2018-05-25 12:18alostaleOBNetwork customer => No
2018-05-25 12:18alostaleModules => Core
2018-05-25 12:18alostaleTriggers an Emergency Pack => No
2018-05-28 11:48alostaleDescription Updatedbug_revision_view_page.php?rev_id=17203#r17203
2018-05-28 11:48alostaleReview Assigned To => AugustoMauch
2018-05-28 12:25alostaleRelationship addeddepends on 0038642
2018-05-28 12:27hgbotCheckin
2018-05-28 12:27hgbotNote Added: 0104745
2018-05-28 12:27hgbotStatusnew => resolved
2018-05-28 12:27hgbotResolutionopen => fixed
2018-05-28 12:27hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/99114944648b6061b2f615ca02ec81bccaf34cec [^]
2018-06-13 15:25AugustoMauchNote Added: 0105129
2018-06-13 15:25AugustoMauchStatusresolved => closed
2018-06-13 15:25AugustoMauchFixed in Version => 3.0PR18Q3
2024-03-19 08:56alostaleRelationship addedrelated to 0054980

Notes
(0104745)
hgbot   
2018-05-28 12:27   
Repository: erp/devel/pi
Changeset: 99114944648b6061b2f615ca02ec81bccaf34cec
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Mon May 28 12:26:48 2018 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/99114944648b6061b2f615ca02ec81bccaf34cec [^]

fixes 38629: do not use ad_session_status to disable PG triggers

  * In PostgreSQL triggers are now disabled using session variables.
  * Oracle implementation remains as it was before

---
M src-db/database/lib/dbsourcemanager.jar
M src-db/database/model/excludeFilter.xml
M src-db/database/model/functions/C_INVOICETAX_ADJUSTMENT.xml
M src-db/database/model/functions/C_ORDERTAX_ADJUSTMENT.xml
M src-db/database/model/prescript-Oracle.sql
M src-db/database/model/prescript-PostgreSql.sql
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_ELEMENT.xml
M src-db/database/sourcedata/AD_TABLE.xml
M src/org/openbravo/dal/core/TriggerHandler.java
R src-db/database/model/functions/AD_ISTRIGGERENABLED.xml
R src-db/database/model/tables/AD_SESSION_STATUS.xml
---
(0105129)
AugustoMauch   
2018-06-13 15:25   
Code reviewed and verified