From:
Josh Berkus <josh(at)agliodbs(dot)com>
To:
Emmanuel Cecchet <manu(at)asterdata(dot)com>
Cc:
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Alvaro Herrera <alvherre(at)commandprompt(dot)com>,
Nikhil Sontakke <nikhil(dot)sontakke(at)enterprisedb(dot)com>,
Jaime Casanova <jcasanov(at)systemguards(dot)com(dot)ec>,
Kedar Potdar <kedar(dot)potdar(at)gmail(dot)com>,
Emmanuel Cecchet <Emmanuel(dot)Cecchet(at)asterdata(dot)com>,
pgsql-hackers(at)postgresql(dot)org, Amit Gupta <amit(dot)pc(dot)gupta(at)gmail(dot)com>
Subject:
Re: Partitioning feature ...
Date:
2009-03-31 17:16:49
Message-ID:
49D25001.5080003@agliodbs.com (view raw or flat )
Thread:
2009-03-23 09:45:12 from Kedar Potdar <kedar(dot)potdar(at)gmail(dot)com>
2009-03-23 11:39:18 from Nikhil Sontakke <nikhil(dot)sontakke(at)enterprisedb(dot)com>
2009-03-24 12:16:17 from Kedar Potdar <kedar(dot)potdar(at)gmail(dot)com>
2009-03-26 22:08:02 from Emmanuel Cecchet <manu(at)asterdata(dot)com>
2009-03-30 11:51:21 from Kedar Potdar <kedar(dot)potdar(at)gmail(dot)com>
2009-03-30 14:59:05 from Jaime Casanova <jcasanov(at)systemguards(dot)com(dot)ec>
2009-03-30 15:42:53 from Emmanuel Cecchet <manu(at)frogthinker(dot)org>
2009-03-31 14:03:44 from Nikhil Sontakke <nikhil(dot)sontakke(at)enterprisedb(dot)com>
2009-03-31 14:46:59 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2009-03-31 15:21:01 from Jaime Casanova <jcasanov(at)systemguards(dot)com(dot)ec>
2009-03-31 15:40:16 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-03-31 15:59:45 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2009-04-01 05:07:44 from Nikhil Sontakke <nikhil(dot)sontakke(at)enterprisedb(dot)com>
2009-03-31 16:45:17 from Emmanuel Cecchet <manu(at)asterdata(dot)com>
2009-03-31 16:55:38 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-03-31 17:16:49 from Josh Berkus <josh(at)agliodbs(dot)com>
Lists:
pgsql-hackers
On 3/31/09 9:45 AM, Emmanuel Cecchet wrote:
> Yes, there is a good reason. As a trigger can update the tuple value,
> this can change the routing decision. If you have a user trigger that
> tries to change the key value after the partition choice has been made,
> this will lead to an integrity constraint violation which is probably
> not what the user expects.
Actually, it's worse. Depending on the timing of the triggers, it's
possible to bypass the FK check entirely, and you can end up with
inconsistent data.
--Josh
In response to
pgsql-hackers by date
Next :From: justinDate: 2009-03-31 17:44:19Subject : Re: string_to_array with empty inputPrevious :From : Alvaro HerreraDate : 2009-03-31 17:14:20Subject : Re: can't load plpython
