Re: [GENERAL] update view

Brian Haney wrote:

> I'm trying to update a table through a view and have read up on what
> constitutes an 'updatable' view. I created a simple test case and cannot
> get it to update the table through the view. In the transcript below,
> notice that when I update the view, I get 'UPDATE 0' with no error message
> or other complaints. What am I missing? Does PostgreSQL not support
> updating through views?

It does, but you must supply the RULE for what should happen in the event of
an INSERT, UPDATE, or DELETE. See Chapter 35 in the Programmer's Guide - The
Postgres Rule System, the section entitled "Rules on INSERT, UPDATE and
DELETE".

Hope that helps,

Mike