From: Samba GUEYE <samba.gueye@intesens.com>
To: Robert Haas <robertmhaas@gmail.com>
Cc: Jim Nasby <jim@nasby.net>
Cc: Postgre Performance <pgsql-performance@postgresql.org>
Subject: Re: Table partitioning problem
Date: Mon, 14 Mar 2011 17:42:06 +0100
Message-ID: <4D7E455E.5050908@intesens.com> (raw)
In-Reply-To: <AANLkTikxt=JTY+dMq769vGOnTYQRmk2O1hJ0YsD5vKLW@mail.gmail.com>
References: <4D764F04.7020400@intesens.com>
<04931568-A1CA-4B5D-B907-E061713E1B54@nasby.net>
<4D788AE2.7010004@intesens.com>
<AANLkTikxt=JTY+dMq769vGOnTYQRmk2O1hJ0YsD5vKLW@mail.gmail.com>
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<samba.gueye@intesens.com> 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.
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: samba.gueye@intesens.com, robertmhaas@gmail.com, jim@nasby.net
Subject: Re: Table partitioning problem
In-Reply-To: <4D7E455E.5050908@intesens.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox