Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id CBCE91C2F15 for ; Thu, 3 May 2012 14:54:44 -0300 (ADT) Received: from gwmta.wicourts.gov ([165.219.244.99] helo=gw.wicourts.gov) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1SQ0El-0008Uf-QW for pgsql-admin@postgresql.org; Thu, 03 May 2012 17:54:44 +0000 Received: from Courts-MTA by gw.wicourts.gov with Novell_GroupWise; Thu, 03 May 2012 12:54:30 -0500 Message-Id: <4FA280010200002500047826@gw.wicourts.gov> X-Mailer: Novell GroupWise Internet Agent 8.0.2 Date: Thu, 03 May 2012 12:54:25 -0500 From: "Kevin Grittner" To: "pgsql-admin@postgresql.org" , "Joe R. Plugge" Subject: Re: DELETE and UPDATE triggers on parent table of partioned table not firing. References: In-Reply-To: Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Pg-Spam-Score: -4.2 (----) X-Archive-Number: 201205/17 X-Sequence-Number: 39506 "Plugge, Joe R." 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