pgsql-bugs@postgresql.org writes:
> 'insert' statement using a view seems to be accepted with no error message:
Yup, many people have been confused by this before you. The data does
actually get inserted into the physical table that underlies the view
--- whereupon you can never see it again, because anytime you try to
select from that table, the ON SELECT view rule fires.
7.1 will disallow insert into a view unless you provide a suitable ON
rule to rewrite the insert into something else.
regards, tom lane
