2016-08-03 15:20 GMT-03:00 JotaComm <jota.c...@gmail.com>: > > > 2016-08-03 15:15 GMT-03:00 JotaComm <jota.c...@gmail.com>: > >> Hello, >> >> 2016-08-03 14:21 GMT-03:00 David G. Johnston <david.g.johns...@gmail.com> >> : >> >>> On Wed, Aug 3, 2016 at 1:16 PM, Adrian Klaver <adrian.kla...@aklaver.com >>> > wrote: >>> >>>> 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.com >> > > > Thank you. > > -- > JotaComm > http://jotacomm.wordpress.com >
-- JotaComm http://jotacomm.wordpress.com
