Re: Statement-level triggers and inheritance - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Statement-level triggers and inheritance
Date
Msg-id 3187.1227909559@sss.pgh.pa.us
Whole thread Raw
In response to Statement-level triggers and inheritance  ("Greg Sabino Mullane" <greg@turnstep.com>)
Responses Re: Statement-level triggers and inheritance
List pgsql-hackers
"Greg Sabino Mullane" <greg@turnstep.com> writes:
> Looks like inheritance causes a statement-level trigger to fire on
> the last evaluated table in the inheritance chain. Is this the
> desired behavior?

Hm, I think whoever wrote the statement-level trigger code completely
forgot to consider the possibility of multiple target relations.  It's
not even consistent between BEFORE and AFTER triggers for this case.

My feeling is that it ought to fire such triggers on *each* target.
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Greg Sabino Mullane"
Date:
Subject: Statement-level triggers and inheritance
Next
From: Greg Stark
Date:
Subject: Re: Fixing contrib/isn for float8-pass-by-value