Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id D169B1336FA7 for ; Mon, 14 Mar 2011 13:42:33 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 28091-01-10 for ; Mon, 14 Mar 2011 16:42:26 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from smtp2.infomaniak.ch (smtp2.infomaniak.ch [84.16.68.90]) by mail.postgresql.org (Postfix) with ESMTP id 2F6741337C47 for ; Mon, 14 Mar 2011 13:42:21 -0300 (ADT) Received: from [192.168.25.106] (reverse.completel.net [92.103.1.80] (may be forged)) (authenticated bits=0) by smtp2.infomaniak.ch (8.14.2/8.14.2) with ESMTP id p2EGgCpW026670 (version=TLSv1/SSLv3 cipher=AES256-SHA bits=256 verify=NO); Mon, 14 Mar 2011 17:42:13 +0100 Message-ID: <4D7E455E.5050908@intesens.com> Date: Mon, 14 Mar 2011 17:42:06 +0100 From: Samba GUEYE User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.1; fr; rv:1.9.2.15) Gecko/20110303 Thunderbird/3.1.9 MIME-Version: 1.0 To: Robert Haas CC: Jim Nasby , Postgre Performance Subject: Re: Table partitioning problem References: <4D764F04.7020400@intesens.com> <04931568-A1CA-4B5D-B907-E061713E1B54@nasby.net> <4D788AE2.7010004@intesens.com> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.61 tagged_above=-10 required=5 tests=BAYES_00=-1.9, MAY_BE_FORGED=0.29, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201103/138 X-Sequence-Number: 42817 Yeah but is there a workaround to force the root table to propagate the foreign key to the partitionned table because right now all foreign keys to partitionned table throws constraints violation and it's a big problem for me Le 11/03/2011 19:31, Robert Haas a écrit : > On Thu, Mar 10, 2011 at 3:25 AM, Samba GUEYE wrote: >> The measure insertion is successful but problems raise up when inserting in >> the simpleMeasure table because it can't find the foreign key inserted the >> measure table and do not look at the partitionned tables > Yes, that's how it works. >