Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group