how to create "trigger after update of a table on multiple column" in postgresql?

Question

I'm going to create a trigger before/after update on specific columns of a table in postgresql but i can't do that.

i can bind trigger to fire after update a specific column of a specific table but i can't do that for more than one column. i want to know is it possible?

i don't want to solve it using writing IF(UPDATE(column series)) in my trigger function

--i tried below code but it give me error near ','

    create trigger save_information after update of table_name on day, month
    for each row
               execute procedure save_function();

-- but below code (by mentioning just a single column) works fine:

    create trigger save_information after update of table_name on day
    for each row
               execute procedure save_function();

i don't want to change my save_function to solve it or use 'IF(update(column series)' statement. excuse me for my weak writing.

the exact error is: ERROR: syntax error at or near "," LINE 28: ...formation after update of table_name on day , month... ^ SQL state: 42601 Character: 1061 — milad
– milad, Commented Apr 3, 2019 at 9:36

user330315 · Accepted Answer · 2019-04-03 06:42:17Z

12

As documented in the manual the column name(s) are listed after the OF keyword.

So it should be:

create trigger save_information 
     after update of day, month
     on table_name 
for each row execute procedure save_function();

answered Apr 3, 2019 at 6:42

user330315

Sign up to request clarification or add additional context in comments.

1 Comment

milad Over a year ago

thank you very very much. it solved the problem. excuse me if it was so simple:|

Collectives™ on Stack Overflow

how to create "trigger after update of a table on multiple column" in postgresql?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related