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(at)itc(dot)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
>