2016-08-03 15:20 GMT-03:00 JotaComm <jota.comm@xxxxxxxxx>:
2016-08-03 15:15 GMT-03:00 JotaComm <jota.comm@xxxxxxxxx>:Hello,2016-08-03 14:21 GMT-03:00 David G. Johnston <david.g.johnston@xxxxxxxxx>:On 08/03/2016 10:12 AM, JotaComm wrote:
Hello,
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.David J.Best regards
--JotaComm
http://jotacomm.wordpress.comThank you.
--JotaComm
http://jotacomm.wordpress.com
--
JotaComm
http://jotacomm.wordpress.com
http://jotacomm.wordpress.com
