Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125])
	by mail.postgresql.org (Postfix) with ESMTP id 1C0B0F4B5D2
	for <pgsql-admin@postgresql.org>; Mon, 12 Mar 2012 00:06:29 -0300 (ADT)
Received: from mail-pz0-f46.google.com ([209.85.210.46])
	by makus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <ruralhunter@gmail.com>) id 1S6vad-0000Oj-DW
	for pgsql-admin@postgresql.org; Mon, 12 Mar 2012 03:06:29 +0000
Received: by dajr28 with SMTP id r28so4524632daj.19
	for <pgsql-admin@postgresql.org>; Sun, 11 Mar 2012 20:06:14 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113;
	h=message-id:date:from:user-agent:mime-version:to:subject
	:content-type:content-transfer-encoding;
	bh=pA7k7AKO5JZfNQF/uCdOlPLXzodC9+BCtJFWHmHmwXk=;
	b=IYxulkMNcNJMf64mQF+lpShdemDkHQSp5K799VVxrCJfdVr8zCO2UmvEDtrTJC7PfM
	+z2mSWYUP7sXf7k696xvLABzPTUES+ZjGeE55lbBV3dpd4/kTWwnFxLmLWHjjUaWIcS5
	2G+RM6XYKq5UqqUQY/yIlH89GAgKf6G/jJ5a8/Oh35b8sVO7n3R7sNnglq8Mflxeshs1
	crpiK8ybS4P1a1TxppdoAl/VqLGEhPvN9aGo2fJtH8Xczs0D3Xyq3mKm9mjn9YEQDs25
	x6viYskHI80vc4NaP2y8tyVKwsrBTw6ZUMuDwb6/MPMl9GL5DL1hLwpjG6O2MkUnNQz9
	kkaw==
Received: by 10.68.211.135 with SMTP id nc7mr16795671pbc.113.1331521574266;
	Sun, 11 Mar 2012 20:06:14 -0700 (PDT)
Received: from [192.168.1.46] ([116.226.41.123])
	by mx.google.com with ESMTPS id g4sm9277760pbs.17.2012.03.11.20.06.11
	(version=TLSv1/SSLv3 cipher=OTHER);
	Sun, 11 Mar 2012 20:06:13 -0700 (PDT)
Message-ID: <4F5D681C.7080006@gmail.com>
Date: Mon, 12 Mar 2012 11:06:04 +0800
From: Rural Hunter <ruralhunter@gmail.com>
User-Agent: Mozilla/5.0 (Windows NT 6.1;
	rv:10.0.2) Gecko/20120216 Thunderbird/10.0.2
MIME-Version: 1.0
To: pgsql-admin@postgresql.org
Subject: triggers are not shared between parent and child tables?
Content-Type: text/plain; charset=GB18030; format=flowed
Content-Transfer-Encoding: 7bit
X-Pg-Spam-Score: -2.6 (--)
X-Archive-Number: 201203/67
X-Sequence-Number: 39255

I implemented table partition recently and found that the tiggers on 
parent table are not working any more, except the before insert trigger 
which redirects data to children table. The after insert/update triggers 
are not working now. I understand the after insert trigger may not 
working since the before insert trigger redirects inserts to children 
table and returns null. But why the update triggers are also not 
working? I googled and found this 
article(http://www.peachpit.com/articles/article.aspx?p=31206&seqNum=3) 
mentions "triggers are not shared between parent and child tables". is 
it true? Maybe I overlooked but somehow I didn't find this in partition 
part of postgresql 
doc(http://www.postgresql.org/docs/9.1/static/ddl-partitioning.html).