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

From Tom Lane
Subject Re: Trigger definition . . . puzzled
Date
Msg-id 13236.1197563633@sss.pgh.pa.us
Whole thread Raw
In response to Re: Trigger definition . . . puzzled  ("Rolf A. de By" <deby@itc.nl>)
Responses Re: Trigger definition . . . puzzled
List pgsql-sql
"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: "Rolf A. de By"
Date:
Subject: Re: Trigger definition . . . puzzled
Next
From: "Rolf A. de By"
Date:
Subject: Re: Trigger definition . . . puzzled