Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id 524B629F0D3 for ; Mon, 12 Mar 2012 12:06:42 -0300 (ADT) Received: from mail-pz0-f46.google.com ([209.85.210.46]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1S76pd-0003F6-9C for pgsql-admin@postgresql.org; Mon, 12 Mar 2012 15:06:41 +0000 Received: by dajr28 with SMTP id r28so5298760daj.19 for ; Mon, 12 Mar 2012 08:06:28 -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:cc:subject :references:in-reply-to:content-type:content-transfer-encoding; bh=x5QkQA1B0xeE2wrQWdsGyNhZ7pJgxlHZaBMHAijm5YI=; b=UBVyfJlgFZV1ErYLWAXyqIXwMKRFDovkr2wLRQ6p6jbVvG0QCGi6MomPnRu7YuPTTL dhXfPxdrDOK43c7PiV7f59F2EbKmGaLYX7GoQHxWhdzFr32AZJ0bjtNXhcKay89Uv+xB PLBwKBGKrf3d7uyWJlQxuy/t6F6j2gx9JMxGsy+d4jGp2COEieapNSB2nkSO6wNORK6A 1WYDGODWlgJlUVsyVj8JpbFFN7DH9EYLLF6YA/yQKw/9+B0SDFTpVDYUscx/KM4vEYP2 YFEhRDVqTeIGlhip/o7LOXY7V6hEqC29QJx4VUVogBxvY7vH4KGebeN7ys54hVSXgfZP kikQ== Received: by 10.68.136.97 with SMTP id pz1mr1713108pbb.30.1331564788577; Mon, 12 Mar 2012 08:06:28 -0700 (PDT) Received: from [192.168.11.3] ([114.95.165.117]) by mx.google.com with ESMTPS id 4sm10072948pbp.76.2012.03.12.08.06.17 (version=TLSv1/SSLv3 cipher=OTHER); Mon, 12 Mar 2012 08:06:27 -0700 (PDT) Message-ID: <4F5E10E3.20805@gmail.com> Date: Mon, 12 Mar 2012 23:06:11 +0800 From: Rural Hunter User-Agent: Mozilla/5.0 (Windows NT 6.1; rv:10.0.2) Gecko/20120216 Thunderbird/10.0.2 MIME-Version: 1.0 To: Kevin Grittner CC: pgsql-admin@postgresql.org Subject: Re: triggers are not shared between parent and child tables? References: <4F5D681C.7080006@gmail.com> <4F5DBDB402000025000460EC@gw.wicourts.gov> <4F5E0D20.9080406@gmail.com> <4F5DC8AE02000025000460FB@gw.wicourts.gov> In-Reply-To: <4F5DC8AE02000025000460FB@gw.wicourts.gov> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit X-Pg-Spam-Score: -2.6 (--) X-Archive-Number: 201203/73 X-Sequence-Number: 39261 hmm....if you ask me, I would like to suggest add this part in the fisrt step(create the master table) of 5.9.2 of this doc: http://www.postgresql.org/docs/9.1/static/ddl-partitioning.html The doc mentions here that there is no point to define indexes/constraints on parent table. But it didn't mention about triggers. 于2012年3月12日 22:58:06,Kevin Grittner写到: > Rural Hunter wrote: > >> is it worth mentioning in the doc? > > Do you have a suggestion for what language you would have found > helpful, or which section(s) of the docs should be modified? > > -Kevin >