Re: Detecting which columns a query will modify in a function calledby a trigger

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Detecting which columns a query will modify in a function calledby a trigger
Дата
Msg-id CAKFQuwbVOiAz7CSZUugmyrdBzdOayDNzUdOGd92TeK2Fhr94HQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Detecting which columns a query will modify in a function calledby a trigger  (Adrian Klaver <adrian.klaver@aklaver.com>)
Ответы Re: Detecting which columns a query will modify in a function calledby a trigger
Список pgsql-general
Дерево обсуждения
On Tue, Mar 3, 2020 at 3:48 PM Adrian Klaver <adrian.klaver@aklaver.com> wrote:
The link was for automatically updateable views. If you want to do
something more involved then see:

https://www.postgresql.org/docs/12/rules-views.html#RULES-VIEWS-UPDATE

CREATE TRIGGER works with views; I usually see recommendations to start there and avoid rules if at all possible.

David J.

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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Detecting which columns a query will modify in a function calledby a trigger
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Detecting which columns a query will modify in a function calledby a trigger