Issue 117654 - No way to insert/modify rows of a view
Summary: No way to insert/modify rows of a view
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 3.3
Hardware: PC Mac OS X 10
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2011-04-01 19:27 UTC by kubaober
Modified: 2013-02-07 22:43 UTC (History)
1 user (show)

See Also:
Issue Type: FEATURE
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description kubaober 2011-04-01 19:27:43 UTC
To support complex queries in base, one can use views. The problem is that the views are not updateable even if the database is set up with triggers in place so that if you try to actually INSERT, UPDATE or DELETE on the view, it succeeds.

As a kludgey workaround, I've been using writable materialized views. They are physical tables, with primary keys (so that base allows updates), with a set of triggers that bidirectionally keep them in sync with source tables.

It would seem that the only information missing from base to support writeable views is the set of columns to be used for primary keys. Setting this on a view should enable modification of said view. This would remove the need for the writeable materialized views workaround.
Comment 1 Oliver-Rainer Wittmann 2012-06-13 12:31:11 UTC
getting rid of value "enhancement" for field "severity".
For enhancement the field "issue type" shall be used.