0019057: DO INSTEAD on view

Description

When working with views, it is not possible to delete/update/insert on them (in PostgreSQL).
There is a way to bypass this problem by creating a 'DO INSTEAD' rule on the view such as reported in the postgreSQL documentation

CREATE RULE name
     AS ON event
     TO object [ WHERE condition ]
     DO [ INSTEAD ] [ action | NOTHING ]

in my case, 'name' is the name of my rule, 'event' is DELETE, 'object' is my view and the action is 'DO INSTEAD DELETE FROM ...'

When the context is exported (ant export.database), this rule is not exported. This causes a big problem because after each update, the rule is lost and I have to recreate it manually.

Steps To Reproduce

1. Create the rule
2. ant export.database
3. the rule is deleted from in the database

Proposed Solution

The rules have to be saved with the context (export.database)

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

Notes
There are no notes attached to this issue.

Issue History
Date Modified	Username	Field	Change
2011-11-14 08:22	neil_smith	New Issue
2011-11-14 08:22	neil_smith	Assigned To	=> alostale
2011-11-14 08:22	neil_smith	Modules	=> Core
2011-11-14 12:01	shuehner	Category	00. Application dictionary => Y. DBSourceManager
2011-11-14 12:01	shuehner	Type	defect => feature request
2011-11-14 16:44	alostale	Assigned To	alostale => marvintm