Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0010417Openbravo ERPY. DBSourceManagerpublic2009-08-27 11:002012-01-30 10:33
Reporterrafademiguel 
Assigned Tomarvintm 
PrioritynormalSeverityminorReproducibilityalways
StatusacknowledgedResolutionopen 
PlatformOS20OS VersionUbuntu 8.04
Product Version2.40MP3 
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
Summary0010417: DBSourceManager identify the materialized views as tables
DescriptionDBSourceManager identify the materialized views as tables so when you run "ant export.database" a new (in-existent) table (xml file) is created on /model/tables/

Later when you run "ant update.database" tries to create the table without success (because already exists an object with this name) but if you run an "ant create.database" it creates the table so then you have to drop the table in order to create your materialized view again.
Steps To ReproduceCreate a materialized view

Proposed Solution1.- Create a materialized view on database

2.- Run ant export.database
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-08-27 11:00rafademiguelNew Issue
2009-08-27 11:00rafademiguelAssigned To => marvintm
2009-08-28 15:32rafarodaNote Added: 0019272
2009-08-28 15:32rafarodaStatusnew => acknowledged
2012-01-30 10:33marvintmNote Added: 0044681
2012-01-30 10:33marvintmTypedefect => feature request

Notes
(0019272)
rafaroda   
2009-08-28 15:32   
Antonio,

Can you please comment on this issue?

Thanks.
(0044681)
marvintm   
2012-01-30 10:33   
This is indeed correct, but I'm going to mark it as a feature request, as materialized views are not a supported feature of dbsourcemanager currently.