Fernando Nasser <fnasser@cygnus.com> writes:
> BTW, it seems we have a SQL non-conformance issue here: views that are
> only projections+selections of a single base table are SQL-updatable.
Indeed. In Postgres terms I think this means that if a CREATE VIEW
describes a view that meets the spec's constraints to be "updatable",
we should automatically create a default set of insert/update/delete
rules for it. This is (or should be) on the TODO list.
regards, tom lane