I'm working with partitioning and I have one trigger for insert and update on parent table, but my trigger is not working for update operations. The problem is: the trigger is not executed for update just for insert. I put a raise notice message in my function to verify the update operation but the raise notice isn't printed on screen.
An answer is contingent on seeing the trigger code.
And the "CREATE TRIGGER" statement itself...
I created a specific trigger and the problem persists. The update trigger is not executed. My version is 9.4.
When I create a trigger for each child table the trigger works very well.
Try:
\d+ <tablename> on the relevant table and check/show the "Triggers: " section.
