Postgres Pro
Downloads
Home   >   mailing lists

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

From David G. Johnston
Subject Re: Detecting which columns a query will modify in a function called by a trigger
Date
Msg-id CAKFQuwbtcpu2-7CfuqeRbkRp8t7OPv-U0vif-Uz7sjtJxaB=xQ@mail.gmail.com
Whole thread Raw
In response to Re: Detecting which columns a query will modify in a function calledby a trigger  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
Tree view
On Tue, Mar 3, 2020 at 4:19 PM David G. Johnston <david.g.johnston@gmail.com> wrote:
On Tue, Mar 3, 2020 at 4:11 PM Adrian Klaver <adrian.klaver@aklaver.com> wrote:
On 3/3/20 3:06 PM, David G. Johnston wrote:
> On Tue, Mar 3, 2020 at 3:48 PM Adrian Klaver <adrian.klaver@aklaver.com
> <mailto: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.

The above suggests triggers then rules.

Yeah, I see the buried in there.  The link itself and the page itself is something like 95% rules coverage so it still seems worth pointing out even in hindsight.

Maybe add a link to the CREATE TRIGGER section in there...

Minor doc patch for this attached for consideration.

David J.
Attachment

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Rows removed on child table when updating parent partitioned table.
Next
From: Brajendra Pratap Singh
Date:
Subject: Profile Creation