Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1e8Fd4-0000q7-MQ for pgsql-bugs@arkaria.postgresql.org; Sat, 28 Oct 2017 01:09:38 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1e8Fd3-0000Nj-Pq for pgsql-bugs@arkaria.postgresql.org; Sat, 28 Oct 2017 01:09:37 +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.84_2) (envelope-from ) id 1e8Fd2-0000Mp-TC for pgsql-bugs@postgresql.org; Sat, 28 Oct 2017 01:09:36 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1e8Fct-0003aT-0K for pgsql-bugs@postgresql.org; Sat, 28 Oct 2017 01:09:34 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.4/8.14.4) with ESMTP id v9S19N6L031243; Fri, 27 Oct 2017 21:09:23 -0400 From: Tom Lane To: Michael Paquier cc: samuel.horwitz@gmail.com, PostgreSQL mailing lists Subject: Re: BUG #14876: Segmentation fault with JSONB column used in store proc that gets used by view and later altered In-reply-to: References: <20171026184035.1471.82810@wrigleys.postgresql.org> <26672.1509050556@sss.pgh.pa.us> <31441.1509055499@sss.pgh.pa.us> Comments: In-reply-to Michael Paquier message dated "Fri, 27 Oct 2017 17:37:29 -0700" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <31241.1509152963.1@sss.pgh.pa.us> Date: Fri, 27 Oct 2017 21:09:23 -0400 Message-ID: <31242.1509152963@sss.pgh.pa.us> List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-bugs Precedence: bulk Sender: pgsql-bugs-owner@postgresql.org Michael Paquier writes: > Sorry for coming up late in the game. I can see that you have pushed a > patch as d5b760e, but back-paddled a bit on d76886c. After some > analysis of things around, I think that you got it right. One comment > I have first though is that you could have used forboth as there is no > point to go through the target list entries once there are no more > aliases. Or target list entries marked as resjunk do not have an > expended reference name? Right, there's no entry in the outer RTE for resjunk columns. (In practice, resjunk entries are at the end of the tlist so that it wouldn't really matter, but I try to keep code from assuming that.) regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs