Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dQsbn-0006Fa-KG for pgsql-hackers@arkaria.postgresql.org; Fri, 30 Jun 2017 09:53:03 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1dQsbm-00065A-Ve for pgsql-hackers@arkaria.postgresql.org; Fri, 30 Jun 2017 09:53:03 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1dQsbm-000650-2C for pgsql-hackers@postgresql.org; Fri, 30 Jun 2017 09:53:02 +0000 Received: from tama500.ecl.ntt.co.jp ([129.60.39.148]) by makus.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dQsbi-0002iK-GT for pgsql-hackers@postgresql.org; Fri, 30 Jun 2017 09:53:00 +0000 Received: from vc2.ecl.ntt.co.jp (vc2.ecl.ntt.co.jp [129.60.86.154]) by tama500.ecl.ntt.co.jp (8.13.8/8.13.8) with ESMTP id v5U9qol6023553; Fri, 30 Jun 2017 18:52:50 +0900 Received: from vc2.ecl.ntt.co.jp (localhost [127.0.0.1]) by vc2.ecl.ntt.co.jp (Postfix) with ESMTP id B65005F63F; Fri, 30 Jun 2017 18:52:50 +0900 (JST) Received: from jcms-pop21.ecl.ntt.co.jp (jcms-pop21.ecl.ntt.co.jp [129.60.87.134]) by vc2.ecl.ntt.co.jp (Postfix) with ESMTP id A81AA5F592; Fri, 30 Jun 2017 18:52:50 +0900 (JST) Received: from [IPv6:::1] (unknown [129.60.241.75]) by jcms-pop21.ecl.ntt.co.jp (Postfix) with ESMTPSA id 9F418400B0D; Fri, 30 Jun 2017 18:52:50 +0900 (JST) Subject: Re: Bug in ExecModifyTable function and trigger issues for foreign tables From: Etsuro Fujita References: <20170514150525.0346ba72@postgrespro.ru> <20170515121638.0c076bcc@wp.localdomain> <20170515165455.545dd3d6@wp.localdomain> <20170516150516.1b616230@wp.localdomain> <20170615180548.5e142ddc@wp.localdomain> <0bc9c28b-96ca-c875-871e-16af6f53ecd9@lab.ntt.co.jp> <428f1672-df54-de01-91da-b57365193bf4@lab.ntt.co.jp> Message-ID: Date: Fri, 30 Jun 2017 18:44:02 +0900 User-Agent: Mozilla/5.0 (Windows NT 6.0; rv:52.0) Gecko/20100101 Thunderbird/52.2.0 MIME-Version: 1.0 In-Reply-To: <428f1672-df54-de01-91da-b57365193bf4@lab.ntt.co.jp> Content-Type: text/plain; charset=utf-8; format=flowed Content-Language: en-US Content-Transfer-Encoding: 7bit To: Ashutosh Bapat Cc: Ildus Kurbangaliev , Dilip Kumar , PostgreSQL Hackers , Robert Haas X-TM-AS-MML: disable List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-hackers Precedence: bulk Sender: pgsql-hackers-owner@postgresql.org On 2017/06/16 21:29, Etsuro Fujita wrote: > On 2017/06/16 19:26, Ashutosh Bapat wrote: >> That issue has not been addressed. The reason stated was that it would >> make code complicated. But I have not had chance to look at how >> complicated would be and assess myself whether that's worth the >> trouble. > I have to admit that what I proposed upthread is a quick-and-dirty > kluge. One thing I thought to address your concern was to move > rewriteTargetListUD entirely from the rewriter to the planner when doing > inherited UPDATE/DELETE, but I'm not sure that's a good idea, because at > least I think that would need a lot more changes to the rewriter. I'll have second thought about this, so I'll mark this as waiting on author. Best regards, Etsuro Fujita -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers