Re: What's ETA for read/write Views?

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