Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0015151Openbravo ERPY. DBSourceManagerpublic2010-11-10 16:132011-10-29 17:59
ReporterFrancescoFinamore 
Assigned Tomarvintm 
PrioritynormalSeveritymajorReproducibilityalways
StatusscheduledResolutionopen 
PlatformOS20OS VersionCommunity Appliance
Product Version2.50MP18 
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
Summary0015151: View with Rules
DescriptionIf you create a view with rules for insert, delete and update (like the VIEW c_debt_payment_cancel i.e.) when launch the ant export.database , the task export only the definition of the view but not the definition of the rules.
Steps To ReproduceI suppose to have a module with DB-prefix "fire"
On database :
1) create a view fire_test
2) create a rule for insert fire_test_ins
3) create a rule for update fire_test_upd
4) create a rule for delete fire_test_del

On console :
Launch ant export.database

Result : only the file fire_test.xml
without definition of the rules.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
has duplicate defect 0010204 closed marvintm Problem with views and rules in postgresql 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-11-10 16:13FrancescoFinamoreNew Issue
2010-11-10 16:13FrancescoFinamoreAssigned To => marvintm
2010-11-11 12:20shuehnerIssue Monitored: shuehner
2010-11-11 12:21shuehnerNote Added: 0032551
2010-11-22 08:35alostaleStatusnew => scheduled
2011-10-29 17:59psarobeTypedefect => feature request
2012-01-30 10:36marvintmRelationship addedhas duplicate 0010204

Notes
(0032551)
shuehner   
2010-11-11 12:21   
Definition of rules on views is so far not supported by dbsourcemanager. So this would be a request for a new feature (to support defining,updating/exporting those and translating them transparently from/to pgsql/oracle)