Re: DELETE and UPDATE triggers on parent table of partioned table not firing.

"Plugge, Joe R." <JRPlugge@west.com> wrote:

> Using postgres 9.0.7 on RHEL 5.4.  I have a parent table that is
> partitioned by day.  My inserts are working correctly and are
> being directed to the correct child table.  I also have both an
> UPDATE and DELETE trigger on the parent table that are defined as
> AFTER triggers.  The actual update and delete operation works,
> however the triggers do not seem to be firing.  What am I doing
> wrong?

The DELETE and UPDATE triggers need to be on the child tables.  An
operation on a child doesn't fire the triggers of the parent.

-Kevin