MIME-Version: 1.0
References: <20200302185904.GA6528@panix.com>
 <30c3c06e-61fa-3210-666d-1696af320a75@aklaver.com>
 <20200302202829.GA19161@panix.com>
 <CAKFQuwaYuvQert-Szy7khu4tB6avCah0wqavsQzPDxX+-vjj_g@mail.gmail.com>
 <20200303174248.GB5019@panix.com>
 <7ac6f67e-f330-1825-02e3-fa5b5a1a2940@aklaver.com>
 <20200303213215.GA2023@panix.com>
 <5574e3a6-2245-42c4-77fd-6e51a7a65e0c@aklaver.com>
In-Reply-To: <5574e3a6-2245-42c4-77fd-6e51a7a65e0c@aklaver.com>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Tue, 3 Mar 2020 16:06:44 -0700
Message-ID: 
 <CAKFQuwbVOiAz7CSZUugmyrdBzdOayDNzUdOGd92TeK2Fhr94HQ@mail.gmail.com>
Subject: Re: Detecting which columns a query will modify in a function called
 by a trigger
To: Adrian Klaver <adrian.klaver@aklaver.com>
Cc: stan <stanb@panix.com>, pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000082ac98059ffb5cc2"
Precedence: bulk

--00000000000082ac98059ffb5cc2
Content-Type: text/plain; charset="UTF-8"

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.

--00000000000082ac98059ffb5cc2
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><div class=3D"gmail_default" style=3D"fon=
t-family:arial,helvetica,sans-serif"><span style=3D"font-family:Arial,Helve=
tica,sans-serif">On Tue, Mar 3, 2020 at 3:48 PM Adrian Klaver &lt;<a href=
=3D"mailto:adrian.klaver@aklaver.com">adrian.klaver@aklaver.com</a>&gt; wro=
te:</span><br></div></div><div class=3D"gmail_quote"><blockquote class=3D"g=
mail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204=
,204,204);padding-left:1ex">The link was for automatically updateable views=
. If you want to do <br>
something more involved then see:<br>
<br>
<a href=3D"https://www.postgresql.org/docs/12/rules-views.html#RULES-VIEWS-=
UPDATE" rel=3D"noreferrer" target=3D"_blank">https://www.postgresql.org/doc=
s/12/rules-views.html#RULES-VIEWS-UPDATE</a></blockquote><div><br></div><di=
v class=3D"gmail_default" style=3D"font-family:arial,helvetica,sans-serif">=
CREATE TRIGGER works with views; I usually see recommendations to start the=
re and avoid rules if at all possible.</div><div class=3D"gmail_default" st=
yle=3D"font-family:arial,helvetica,sans-serif"><br></div><div class=3D"gmai=
l_default" style=3D"font-family:arial,helvetica,sans-serif">David J.</div><=
div class=3D"gmail_default" style=3D"font-family:arial,helvetica,sans-serif=
"></div></div></div>

--00000000000082ac98059ffb5cc2--