Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0007686Openbravo ERPA. Platformpublic2009-02-19 16:152009-04-22 00:00
rafaroda 
alostale 
highmajoralways
closedfixed 
20rPath Linux
pi 
2.50beta 
Core
No
0007686: AD_TABLE_TRG is no PostgreSQL ready
When 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 [^]
1) Check out trunk revision 13407 and PostgreSQL
2) Run: ant create.database -Dapply.modules.on.create=true
No tags attached.
related to defect 0007672pi closed alostale Table identifiers not properly calculated for upgraded customizations 
Issue History
2009-02-19 16:15rafarodaNew Issue
2009-02-19 16:15rafarodaAssigned To => rafaroda
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 [^]