Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0007686Openbravo ERPA. Platformpublic2009-02-19 16:152009-04-22 00:00
Reporterrafaroda 
Assigned Toalostale 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionrPath Linux
Product Versionpi 
Target VersionFixed in Version2.50beta 
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
Summary0007686: AD_TABLE_TRG is no PostgreSQL ready
DescriptionWhen create.database with PostgreSQL the following error message displays when creating AD_TABLE_TRG:
SQL Command failed with: ERROR: subquery in FROM must have an alias
http://pastebin.com/f65279535 [^]
Steps To Reproduce1) Check out trunk revision 13407 and PostgreSQL
2) Run: ant create.database -Dapply.modules.on.create=true
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0007672pi closed alostale Table identifiers not properly calculated for upgraded customizations 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-02-19 16:15rafarodaNew Issue
2009-02-19 16:15rafarodaAssigned To => rafaroda
2009-02-19 16:15rafarodaOBNetwork customer => No
2009-02-19 16:15rafarodaRegression testing => No
2009-02-19 16:17rafarodaAssigned Torafaroda => alostale
2009-02-19 16:17rafarodaStatusnew => scheduled
2009-02-19 16:27rafarodaRelationship addedrelated to 0007672
2009-02-19 17:06svnbotCheckin
2009-02-19 17:06svnbotNote Added: 0013753
2009-02-19 17:06svnbotStatusscheduled => resolved
2009-02-19 17:06svnbotResolutionopen => fixed
2009-02-19 17:06svnbotsvn_revision => 13410
2009-04-21 10:33psarobeStatusresolved => closed
2009-04-22 00:00anonymoussf_bug_id0 => 2777969

Notes
(0013753)
svnbot   
2009-02-19 17:06   
Repository: openbravo
Revision: 13410
Author: rafaroda
Date: 2009-02-19 17:06:46 +0100 (Thu, 19 Feb 2009)

Fixes bug 0007686 AD_TABLE_TRG is now PostgreSQL ready

---
U trunk/src-db/database/model/triggers/AD_TABLE_TRG.xml
---

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