Tom Lane writes:
> Some people seem to think that the system should try to intuit
> those rules for them, but I don't believe that's either possible
> or desirable. The entire point of a view is that it's not an
> exact image of the underlying data, so how is a machine going to
> figure out what you want an update on the view to do?
The SQL standard has pretty precise rules for when views are updatable and
how.
--
Peter Eisentraut Sernanders väg 10:115
peter_e@gmx.net 75262 Uppsala
http://yi.org/peter-e/ Sweden