Re: Silent insert lack

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