Postgres Pro
Downloads
Home   >   mailing lists

Re: For each statement trigger and update table - Mailing list pgsql-sql

From Rene Romero Benavides
Subject Re: For each statement trigger and update table
Date
Msg-id CANaGW0-O3E0Pq5TnkWcobyH59YwPvVq7JMf=s75b2NeoWcra+g@mail.gmail.com
Whole thread Raw
In response to For each statement trigger and update table  (Mike Martin <mike@redtux.plus.com>)
Responses Re: For each statement trigger and update table  (Mike Martin <mike@redtux.plus.com>)
List pgsql-sql
Tree view
>  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?

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 <mike@redtux.plus.com> 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ón y 99% transpiración.
Thomas Alva Edison
http://pglearn.blogspot.mx/

pgsql-sql by date:

Previous
From: Mike Martin
Date:
Subject: For each statement trigger and update table
Next
From: Mike Martin
Date:
Subject: Re: For each statement trigger and update table