Re: Errors when update a view with conditional-INSTEAD rules

Поиск
Список
Период
Сортировка
От Pengzhou Tang
Тема Re: Errors when update a view with conditional-INSTEAD rules
Дата
Msg-id CAG4reARgyiAM6EtvEqu0q9-X32fowR9_+So0gNU=FjBZ=D35+A@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Errors when update a view with conditional-INSTEAD rules  (Dean Rasheed <dean.a.rasheed@gmail.com>)
Список pgsql-hackers


> I am wondering whether a simple auto-updatable view can have a conditional update instead rule.

Well, the decision reached in [1] was that we wouldn't allow that. We
could decide to allow it now as a new feature enhancement, but it
wouldn't be a back-patchable bug-fix, and to be honest I wouldn't be
particularly excited about adding such a feature now. We already get
enough reports related to multiple rule actions behaving in
counter-intuitive ways that trip up users. I don't think we should be
enhancing the rule system, but rather encouraging users not to use it
and use triggers instead.

Ok, that makes sense, thanks for the explanation. 
 

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

Предыдущее
От: Surafel Temesgen
Дата:
Сообщение: Re: FETCH FIRST clause WITH TIES option
Следующее
От: Pavel Stehule
Дата:
Сообщение: Re: [Proposal] Global temporary tables