Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lrpBM-0000dm-9g for pgsql-bugs@arkaria.postgresql.org; Fri, 11 Jun 2021 21:59:16 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lrpBL-000788-9D for pgsql-bugs@arkaria.postgresql.org; Fri, 11 Jun 2021 21:59:15 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lrpBL-00077T-1z for pgsql-bugs@lists.postgresql.org; Fri, 11 Jun 2021 21:59:15 +0000 Received: from relay9-d.mail.gandi.net ([217.70.183.199]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lrpBI-0002fL-Dy for pgsql-bugs@lists.postgresql.org; Fri, 11 Jun 2021 21:59:14 +0000 Received: (Authenticated sender: adsend@dunslane.net) by relay9-d.mail.gandi.net (Postfix) with ESMTPSA id 6CAE5FF806; Fri, 11 Jun 2021 21:59:08 +0000 (UTC) Subject: Re: BUG #17056: Segmentation fault on altering the type of the foreign table column with a default To: Tom Lane Cc: exclusion@gmail.com, pgsql-bugs@lists.postgresql.org References: <17056-4f6f7243d322be6b@postgresql.org> <1806408.1623363029@sss.pgh.pa.us> <4726f847-68fb-a7fc-c5e9-7b9536046fc4@dunslane.net> <1816295.1623366663@sss.pgh.pa.us> From: Andrew Dunstan Message-ID: <43114f0b-69d8-b040-3a46-caedcc77b9fc@dunslane.net> Date: Fri, 11 Jun 2021 17:59:07 -0400 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101 Thunderbird/78.4.0 MIME-Version: 1.0 In-Reply-To: <1816295.1623366663@sss.pgh.pa.us> Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 6/10/21 7:11 PM, Tom Lane wrote: > Andrew Dunstan writes: >> On 6/10/21 6:10 PM, Tom Lane wrote: >>> Hmm. The equivalent DDL on a plain table works fine, but this is >>> crashing in the code that manipulates attmissingval. I suspect some >>> confusion about whether a foreign table column should even *have* >>> attmissingval. Andrew, any thoughts? >> My initial thought would be that it should not. If the foreign table has >> rows with missing columns then it should be up to the foreign server to >> supply them transparently. We have no notion what the foreign semantics >> of missing columns are. > Yeah, that was kind of what I thought. Probably only RELKIND_RELATION > rels should ever have attmissingval; but certainly, anything without > local storage should not. > >> I can take a look at a fix tomorrow. My inclination would be simply to >> skip setting attmissingval for foreign tables. > Seems like in addition to that, we'll need a defense in this specific > code to cope with the case where the foreign column already has an > attmissingval. Or maybe, the logic to not store a new one will be enough > to keep us from reaching this crash; but we need to be sure it is enough. The first piece could be fairly simply accomplished by something like this diff --git a/src/backend/catalog/heap.c b/src/backend/catalog/heap.c index afa830d924..ac89efefe8 100644 --- a/src/backend/catalog/heap.c +++ b/src/backend/catalog/heap.c @@ -2287,7 +2287,8 @@ StoreAttrDefault(Relation rel, AttrNumber attnum,         valuesAtt[Anum_pg_attribute_atthasdef - 1] = true;         replacesAtt[Anum_pg_attribute_atthasdef - 1] = true;   -       if (add_column_mode && !attgenerated) +       if (rel->rd_rel->relkind == RELKIND_RELATION  && add_column_mode && +           !attgenerated)         {             expr2 = expression_planner(expr2);             estate = CreateExecutorState(); I'm guessing we want to exclude materialized views and partitioned tables as well as things without local storage. How to ignore something that's got into the catalog that shouldn't be there is less clear. At the point where we fetch missing values all we have access to is a TupleDesc. cheers andrew -- Andrew Dunstan EDB: https://www.enterprisedb.com