On Tue, Mar 29, 2005 at 07:30:13PM +0200, Bernd Helmle wrote:
Well, the patch is far away from being ready for -patches, but if you want to "preview" you can get our latest patch against HEAD at
http://www.oopsware.de/pgsql_viewupdate.html
Well, that description there says what the patch doesn't do, but it would be helpful to say what does it do.
Implemented is:
- Create rules for SQL92-compliant updateable views. This creates implicit rules
for DELETE, UPDATE and INSERT actions named
_DELETE,
_DELETE_NOTHING,
_UPDATE,
_UPDATE_NOTHING,
_INSERT and
_INSERT_NOTHING
and marks them with a new column in pg_rewrite as an impicit created update rule.
The patch supports system columns and functions in the view's target list rudimentary and allows CASCADED updates to base tables, since rules are created in cascaded manner on the underlying relations (which is changed, when we cover LOCAL | CASCADED CHECK OPTION). The WITH CHECK OPTION is implemented and creates all mentioned update rules with a rule condition added, which calls a new system function that elogs() an error if the passed view condition is not evaluated to true.
I'm sure not all corner cases are covered for this yet, but it's still a work in progress....
--
Bernd
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
