Re: Trigger definition . . . puzzled - Mailing list pgsql-sql

From Rolf A. de By
Subject Re: Trigger definition . . . puzzled
Date
Msg-id 47619476.9060100@itc.nl
Whole thread Raw
In response to Re: Trigger definition . . . puzzled  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Ouch, that hurts!  It suddenly dawns on me . . . Big difference on table 
that you specify and table where it
actually takes effect.  Confusing at first.   Thanks a million, Tom.
> "Rolf A. de By" <deby@itc.nl> writes:
>   
>> Yes, this is an inheritance set-up.  But actually no: I am executing all 
>> my data changes against the parent table, and want the trigger on that 
>> parent table to fire for an insert on the parent table as it does.  But 
>> I also want the trigger to fire when an update on the parent table is 
>> executed, and this does not happen.
>>     
>
> There is no update on any row in the parent table.  The update is on a
> row in a child table.
>
>             regards, tom lane
>   


pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Trigger definition . . . puzzled
Next
From: Steve Midgley
Date:
Subject: Re: Query design assistance - getting daily totals