"Ann W. Harrison" <aharrison@...> wrote:

>
> Under the Oracle model how would you handle the logging case
> I described originally?

Create one trigger to perform an update (i.e. insert) and another one for
the logging. Or combine their code in the single trigger.

> In the absence of 10 years of history, I'd agree with you. However
> for 10 years, the default state of simple views has been UPDATEABLE.

IMHO, the major result of these 10 years of history is that some people
stopped working with views at all once they couldn't make them updatable in
a logical way.


Dmitry