Postgres Pro
Downloads
Home   >   mailing lists

Re: DELETE and UPDATE triggers on parent table of partioned table not firing. - Mailing list pgsql-admin

From Kevin Grittner
Subject Re: DELETE and UPDATE triggers on parent table of partioned table not firing.
Date
Msg-id 4FA280010200002500047826@gw.wicourts.gov
Whole thread Raw
In response to DELETE and UPDATE triggers on parent table of partioned table not firing.  ("Plugge, Joe R." <JRPlugge@west.com>)
List pgsql-admin
Tree view 
"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

pgsql-admin by date:

Previous
From: "Plugge, Joe R."
Date:
Subject: DELETE and UPDATE triggers on parent table of partioned table not firing.
Next
From: "Gnanakumar"
Date:
Subject: Re: Very long " in transaction" query