Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0006392Openbravo ERPY. DBSourceManagerpublic2008-12-07 21:452009-04-22 00:00
Reportervillind 
Assigned Tomarvintm 
PrioritynormalSeveritytrivialReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0006392: View in different schema break the database update process
DescriptionIf there are views in different schema the database update breaks. Tables are handled properly, but views are not.

It seems that view name is read, but the view definition is not.
Steps To Reproduce
Proposed SolutionIgnore views that are not in search path (usually user+public).
Additional Information
Tagsdbsm_migrate
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-12-07 21:45villindNew Issue
2008-12-16 18:11rafarodaNote Added: 0011446
2008-12-16 18:11rafarodaStatusnew => feedback
2008-12-16 20:06villindNote Added: 0011456
2008-12-18 12:38jpabloaeSticky IssueNo => Yes
2008-12-18 12:39jpabloaeSticky IssueYes => No
2008-12-18 12:39jpabloaeTag Attached: dbsm_migrate
2008-12-18 12:41jpabloaeProject@4@ => Openbravo ERP
2008-12-18 12:41jpabloaeCategory => Y. DBSourceManager
2008-12-18 12:43jpabloaeAssigned To => marvintm
2009-01-05 18:48iciordiaStatusfeedback => scheduled
2009-01-05 18:48iciordiafix_in_branch => trunk
2009-01-05 18:50iciordiaNote Added: 0011925
2009-01-07 10:00svnbotCheckin
2009-01-07 10:00svnbotNote Added: 0011937
2009-01-07 10:00svnbotStatusscheduled => resolved
2009-01-07 10:00svnbotResolutionopen => fixed
2009-01-07 10:00svnbotsvn_revision => 199
2009-01-07 10:03svnbotCheckin
2009-01-07 10:03svnbotNote Added: 0011938
2009-01-07 10:03svnbotsvn_revision199 => 11670
2009-04-21 11:09psarobeStatusresolved => closed
2009-04-22 00:00anonymoussf_bug_id0 => 2777917

Notes
(0011446)
rafaroda   
2008-12-16 18:11   
Ville, could you please provide extended steps to reproduce this issue? Thank you.
(0011456)
villind   
2008-12-16 20:06   
CREATE SCHEMA import;

CREATE OR REPLACE VIEW import.v_test AS
 SELECT now()::timestamp without time zone AS now;

-------------
ant update.database
(0011925)
iciordia   
2009-01-05 18:50   
Antonio,

the problem seems to be that dbsourcemanager is querying postgresql dictionary without filtering by schema, at least when retrieving views.

Can you please check it?

Ismael
(0011937)
svnbot   
2009-01-07 10:00   
Repository: dbsourcemanager
Revision: 199
Author: marvintm
Date: 2009-01-07 10:00:16 +0100 (Wed, 07 Jan 2009)

Fixed bug 6392. Now only views of current schema will be loaded when loading the database model.

---
U trunk/src/org/apache/ddlutils/platform/postgresql/PostgreSqlModelLoader.java
---

https://dev.openbravo.com/websvn/dbsourcemanager/?rev=199&sc=1 [^]
(0011938)
svnbot   
2009-01-07 10:03   
Repository: openbravo
Revision: 11670
Author: marvintm
Date: 2009-01-07 10:03:34 +0100 (Wed, 07 Jan 2009)

Fixed bug 6392. Now only views of current schema will be loaded when loading the database model.

---
U trunk/src-db/database/lib/dbsourcemanager.jar
---

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