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

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>, "Joe R(dot) Plugge" <JRPlugge(at)west(dot)com>
Subject: Re: DELETE and UPDATE triggers on parent table of partioned table not firing.
Date: 2012-05-03 17:54:25
Message-ID: 4FA280010200002500047826@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Plugge, Joe R." <JRPlugge(at)west(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Gnanakumar 2012-05-04 09:52:47 Re: Very long "<IDLE> in transaction" query
Previous Message Plugge, Joe R. 2012-05-03 16:40:59 DELETE and UPDATE triggers on parent table of partioned table not firing.