Updateable VIEWS and the manual

Поиск
Список
Период
Сортировка
От Thomas Kellerer
Тема Updateable VIEWS and the manual
Дата
Msg-id k9641g$a8r$1@ger.gmane.org
обсуждение исходный текст
Ответы Re: Updateable VIEWS and the manual  (Merlin Moncure <mmoncure@gmail.com>)
Re: Updateable VIEWS and the manual  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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

В списке pgsql-general по дате отправления:

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: 'alternatives'
Следующее
От: Tom Lane
Дата:
Сообщение: Re: 'alternatives'