Re: Updateable VIEWS and the manual - Mailing list pgsql-general

From Tom Lane
Subject Re: Updateable VIEWS and the manual
Date
Msg-id 8196.1354483157@sss.pgh.pa.us
Whole thread Raw
In response to Updateable VIEWS and the manual  (Thomas Kellerer <spam_eater@gmx.net>)
List pgsql-general
Thomas Kellerer <spam_eater@gmx.net> writes:
> I just noticed the following statement in the CREATE VIEW documentation (9.2 and 9.1):

>      Currently, views are read only: the system will not allow an insert,
>      update, or delete on a view. You can get the effect of an updatable view by
>      creating rules that rewrite inserts, etc. on the view into appropriate actions
>      on other tables. For more information see CREATE RULE.

> Wouldn't it make more sense to refer to INSTEAD OF triggers?

Done, thanks for pointing it out.

            regards, tom lane


pgsql-general by date:

Previous
From: Guillaume Lelarge
Date:
Subject: Re: alter sequence
Next
From: rahul143
Date:
Subject: Exception Handling in C-Language Functions?