Re: For each statement trigger and update table

--00000000000033a6c8059b450b8b
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

According to the docs, not possible to use a transition table and column
list together

On Fri, 3 Jan 2020, 23:39 Rene Romero Benavides, <[email protected]>
wrote:

> >  I can give code when I get home, but it's pretty simple stuff
> please do so, along with your trigger definition. Are you aware that you
> can define your update trigger to fire on a specific column?
>
> https://www.postgresql.org/docs/current/sql-createtrigger.html
>
> For UPDATE events, it is possible to specify a list of columns using this
> syntax:
>
> UPDATE OF column_name1 [, column_name2 ... ]
>
>
>
> On Fri, Jan 3, 2020 at 5:21 PM Mike Martin <[email protected]> wrote:
>
>> Not sure if this is possible
>> Basically I want to have a trigger which updates an array column in the
>> same table when a column is updated
>> This works as a row level trigger, but not as per statement
>> I have hit the recursive issue (where update fires update trigger which
>> fires etc)
>> According to the docs I cannot use columns and relative tables together
>>
>> So any suggestions? I can give code when I get home, but it's pretty
>> simple stuff
>>
>
>
> --
> El genio es 1% inspiraci=C3=B3n y 99% transpiraci=C3=B3n.
> Thomas Alva Edison
> http://pglearn.blogspot.mx/
>
>

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

<div dir=3D"auto">According to the docs, not possible to use a transition t=
able and column list together=C2=A0</div><br><div class=3D"gmail_quote"><di=
v dir=3D"ltr" class=3D"gmail_attr">On Fri, 3 Jan 2020, 23:39 Rene Romero Be=
navides, &lt;<a href=3D"mailto:[email protected]">rene.romero.b@gmail=
.com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"mar=
gin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir=3D"ltr=
"><div dir=3D"ltr">&gt;=C2=A0 I can give code when I get home, but it&#39;s=
 pretty simple stuff=C2=A0</div><div>please do so, along with your trigger =
definition. Are you aware that you can define your update trigger to fire o=
n a specific column?</div><div><br></div><div><a href=3D"https://www.postgr=
esql.org/docs/current/sql-createtrigger.html" target=3D"_blank" rel=3D"nore=
ferrer">https://www.postgresql.org/docs/current/sql-createtrigger.html</a>=
=C2=A0=C2=A0<br></div><div><p style=3D"box-sizing:border-box;color:rgb(13,1=
0,11);font-family:&quot;Open Sans&quot;,sans-serif;font-size:14.4px;margin:=
1rem 0px 1rem 2rem">For=C2=A0<tt style=3D"box-sizing:border-box;border-radi=
us:0.25rem;margin:0.6rem 0px;font-size:0.9rem;color:inherit;background-colo=
r:rgb(248,249,250)">UPDATE</tt>=C2=A0events, it is possible to specify a li=
st of columns using this syntax:</p><pre style=3D"box-sizing:border-box;fon=
t-family:monospace,monospace;font-size:14.4px;overflow:auto;color:rgb(13,10=
,11);border-radius:0.25rem;border:1px solid rgb(206,212,218);margin-top:1re=
m;margin-bottom:1rem;margin-left:2rem;background-color:rgb(248,249,250);pad=
ding:0.8rem">UPDATE OF <tt style=3D"box-sizing:border-box;font-weight:900;f=
ont-style:italic;border-radius:0.25rem;margin:0.6rem 0px;font-size:0.9rem;c=
olor:inherit">column_name1</tt> [, <tt style=3D"box-sizing:border-box;font-=
weight:900;font-style:italic;border-radius:0.25rem;margin:0.6rem 0px;font-s=
ize:0.9rem;color:inherit">column_name2</tt> ... ]</pre></div><div><br></div=
></div><br><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr"=
>On Fri, Jan 3, 2020 at 5:21 PM Mike Martin &lt;<a href=3D"mailto:mike@redt=
ux.plus.com" target=3D"_blank" rel=3D"noreferrer">[email protected]</a>&=
gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0=
px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div =
dir=3D"auto">Not sure if this is possible<div dir=3D"auto">Basically I want=
 to have a trigger which updates an array column in the same table when a c=
olumn is updated</div><div dir=3D"auto">This works as a row level trigger, =
but not as per statement</div><div dir=3D"auto">I have hit the recursive is=
sue (where update fires update trigger which fires etc)</div><div dir=3D"au=
to">According to the docs I cannot use columns and relative tables together=
</div><div dir=3D"auto"><br></div><div dir=3D"auto">So any suggestions? I c=
an give code when I get home, but it&#39;s pretty simple stuff=C2=A0</div><=
/div>
</blockquote></div><br clear=3D"all"><div><br></div>-- <br><div dir=3D"ltr"=
>El genio es 1% inspiraci=C3=B3n y 99% transpiraci=C3=B3n.<br>Thomas Alva E=
dison<br><a href=3D"http://pglearn.blogspot.mx/" target=3D"_blank" rel=3D"n=
oreferrer">http://pglearn.blogspot.mx/</a><br><div style=3D"padding:0px;mar=
gin-left:0px;margin-top:0px;overflow:hidden;color:black;font-size:10px;text=
-align:left;line-height:130%"></div><div><br></div></div>
</blockquote></div>

--00000000000033a6c8059b450b8b--