Postgres Pro
Downloads
Home   >   mailing lists

Re: Detecting which columns a query will modify in a function calledby a trigger - Mailing list pgsql-general

From David G. Johnston
Subject Re: Detecting which columns a query will modify in a function calledby a trigger
Date
Msg-id CAKFQuwbVOiAz7CSZUugmyrdBzdOayDNzUdOGd92TeK2Fhr94HQ@mail.gmail.com
Whole thread Raw
In response to Re: Detecting which columns a query will modify in a function calledby a trigger  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: Detecting which columns a query will modify in a function calledby a trigger  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Tree view
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 by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Detecting which columns a query will modify in a function calledby a trigger
Next
From: Adrian Klaver
Date:
Subject: Re: Detecting which columns a query will modify in a function calledby a trigger