Re: Proposal for updatable views

URL added to TODO. I assume there has been no more progress on this patch.

---------------------------------------------------------------------------

Bernd Helmle wrote:
> Hi folks,
>
> Please find attached a patch that implements SQL92-compatible updatable
> views. The patch introduces new semantics into the rule system: implicit
> and explicit rules. Implicit rules are created to implement updatable views:
>
> _INSERT
> _NOTHING_INSERT (unconditional DO INSTEAD NOTHING rule)
> _DELETE
> _NOTHING_DELETE (unconditional DO INSTEAD NOTHING rule)
> _UPDATE
> _NOTHING_UPDATE (unconditional DO INSTEAD NOTHING rule)
>
> These rules are marked 'implicit' in pg_rewrite, the rewriter is teached to
> handle them different, depending on wether they are created with a rule
> condition (a view's CHECK OPTION) or not. The CHECK OPTION itself is
> implemented with a new system function and a conditional rule that
> evaluates the view's WHERE condition (pg_view_update_error()).
>
> The supported syntax is
>
> CREATE VIEW foo AS SELECT ... [WITH [LOCAL | CASCADED] CHECK OPTION];
>
> The LOCAL and CASCADED keywords are optional when a CHECK OPTION is
> specified, the default is CASCADED (this syntax creates a shift/reduce
> conflict in the grammar file i don't know how to fix).
>
> If a user wants his own rules with CREATE RULE to be created, the implicit
> rule gets dropped, depending what action the user selects.
>
> The patch introduces support for pg_dump as well.
>
> Please note that the patch isn't complete yet, but it seems it's necessary
> to discuss its implementation on -hackers now.
>
> Bernd

[ Attachment, skipping... ]

>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org

--
Bruce Momjian http://candle.pha.pa.us
EnterpriseDB http://www.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +