Re: For each statement trigger and update table
| От | Rene Romero Benavides |
|---|---|
| Тема | Re: For each statement trigger and update table |
| Дата | |
| Msg-id | CANaGW0-O3E0Pq5TnkWcobyH59YwPvVq7JMf=s75b2NeoWcra+g@mail.gmail.com обсуждение исходный текст |
| Ответ на | For each statement trigger and update table (Mike Martin <mike@redtux.plus.com>) |
| Ответы |
Re: For each statement trigger and update table
|
| Список | pgsql-sql |
> 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 possibleBasically I want to have a trigger which updates an array column in the same table when a column is updatedThis works as a row level trigger, but not as per statementI have hit the recursive issue (where update fires update trigger which fires etc)According to the docs I cannot use columns and relative tables togetherSo any suggestions? I can give code when I get home, but it's pretty simple stuff
В списке pgsql-sql по дате отправления: