Re: Possible problems with Date & McGoveran View Updating

From: Alfredo Novoa <alfredo_at_ncs.es>
Date: 9 Sep 2003 15:32:04 -0700
Message-ID: <e4330f45.0309091432.6b5629a6_at_posting.google.com>


"Mikito Harakiri" <mikharakiri_at_ywho.com> wrote in message news:<OTa7b.30$741.269_at_news.oracle.com>...

> No, I'm not suggesting to arbitrarily extend the view.
>
> The system must just reject any attempt updating ambiguous system of views.

Agreed, but some systems of views may be ambiguous for some updates (inserts), and not for others (deletes).

By the principle of interchangeability views are as updateable as base relation variables, but some views (and relvars) are updateable in zero or few circumstances.

Many views not updateable by inserts are updateable by deletes.

We must consider the acceptablity of each updating attempt individually.

Regards
  Alfredo Received on Wed Sep 10 2003 - 00:32:04 CEST

Original text of this message