Updateable VIEWS and the manual

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Updateable VIEWS and the manual
Date: 2012-11-28 22:43:25
Message-ID: k9641g$a8r$1@ger.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

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?

My understanding was that an INSTEAD OF trigger was preferred over a rule nowadays.

Regards
Thomas

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2012-11-28 22:50:15 Re: 'alternatives'
Previous Message Andres Freund 2012-11-28 22:32:38 Re: 'alternatives'