Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fkvAW-0006aI-RA for pgsql-hackers@arkaria.postgresql.org; Wed, 01 Aug 2018 17:44:17 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fkvAU-0008QQ-Fz for pgsql-hackers@arkaria.postgresql.org; Wed, 01 Aug 2018 17:44:14 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fkvAU-0008QJ-7H for pgsql-hackers@lists.postgresql.org; Wed, 01 Aug 2018 17:44:14 +0000 Received: from mail-lj1-x22b.google.com ([2a00:1450:4864:20::22b]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1fkvAQ-0003sM-Ts for pgsql-hackers@postgresql.org; Wed, 01 Aug 2018 17:44:13 +0000 Received: by mail-lj1-x22b.google.com with SMTP id p10-v6so17587230ljg.2 for ; Wed, 01 Aug 2018 10:44:10 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :cc; bh=7SuMIi45xWYXjiZICgC+m+/OJEo9QAy4KtMV6WmWca8=; b=bROrNSvrwgxthpxqDYlp6a1+R45RTPbZ+9D8M9zPgfae1Q5WphXGM/Lf744wZENU+B M0QX284D/YlmdyfHbeTL4zwUrQrqlpD2Pbk1SrE2AFo8/7+Xv+egCkDlbBycJsefhMDN EwDwpLIRO/XfGQZYyAcDSfrvJmcXVr7yhAk9AmoJsRuFXrnENCOjCqfwj5oyWNfuauTD mxk1xD+RO+9EGgFRlex2aLw+ImYOGTnqtl90sJgeMbRxIqWS+NwHzr894q5QFSH+IOBy K14IXp1d4JqZ4vaVzh43txTFYIa/WYho9R3oB8vmgKxx4ZzVrhHa+9kLVJ97pfltZABw B0og== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to:cc; bh=7SuMIi45xWYXjiZICgC+m+/OJEo9QAy4KtMV6WmWca8=; b=jm13yadw4T1N/35RvLZ/Fa74kyaBne31GS7y5iGW6Md0qvb8Nortcr+NwnH+sAFPXT Zob2O9bLB5WFHoZWwUhnynQoFSCvVvv+LyqiRXVLheNlZ23+04Nr7NcfXwcBst7O+1RA NRR4HzBLQq1xbMddts2ZRr0RTtVl0lK2czwF+BV/pdmz91Yd+iZD81zLQgaSl9O8meQr VzrSsIqfu+pJbJ7RIRr2BNW1L9ogRv4pcq0vc6dzrxayNe/4QPZq+/apf0y0p8rItHwr eb5iZLy461xaslNrCrJ3OdgTNKR6R7zt6MmpjMAJtfGlrMD5ad1biRW5Jv6BE5c6A0aQ 2uhg== X-Gm-Message-State: AOUpUlF2ryWabh6f/9GggJwC4uwMQerFghz7j0Au+Vvb9RjP73tjKDts G4p2lMsUY5Mq30dzuziB04xgDADYcf9elzUmSOI= X-Google-Smtp-Source: AAOMgpf6cLCIn9owD/mLCDhN9sw5E/LppVxPt1RrxqAzLcj6nwVYHr3eUH85Q15ZPsjrKs173n7KJhYI/2S1x9YLK4I= X-Received: by 2002:a2e:9645:: with SMTP id z5-v6mr16520012ljh.127.1533145448577; Wed, 01 Aug 2018 10:44:08 -0700 (PDT) MIME-Version: 1.0 Received: by 2002:a19:e508:0:0:0:0:0 with HTTP; Wed, 1 Aug 2018 10:44:07 -0700 (PDT) In-Reply-To: <5B619DA8.30801@lab.ntt.co.jp> References: <20180731203124.xuyvcahqgryn63mz@alvherre.pgsql> <5B619DA8.30801@lab.ntt.co.jp> From: Robert Haas Date: Wed, 1 Aug 2018 13:44:07 -0400 Message-ID: Subject: Re: Expression errors with "FOR UPDATE" and postgres_fdw with partition wise join enabled. To: Etsuro Fujita Cc: Alvaro Herrera , Andres Freund , Ashutosh Bapat , Rajkumar Raghuwanshi , pgsql-hackers Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On Wed, Aug 1, 2018 at 7:46 AM, Etsuro Fujita wrote: > I posted the updated patch [1]. Etsuro-san: I really think we should just go with what Ashutosh had proposed. Tom, Ashutosh, and I all seem to agree that we shouldn't try to re-jigger things at create-plan time. I think that a 3-1 consensus against your proposal is sufficient to say we shouldn't go that way. Now, here you've got a new approach which avoids that, which I have not yet reviewed. I'll try to spend some time on it this afternoon, but really, I think it's too late for this. This bug was reported in February, and we're supposed to be pushing 11 final out the door in not much more than a month. Proposing a new approach in August is not good. Can't we just do what Ashutosh proposed for now and revisit this for v12? -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company