Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1gEQlL-0004gC-7d for pgsql-committers@arkaria.postgresql.org; Mon, 22 Oct 2018 03:20:15 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gEQlJ-0002oH-CG for pgsql-committers@arkaria.postgresql.org; Mon, 22 Oct 2018 03:20:13 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1gEQlJ-0002o8-3j for pgsql-committers@lists.postgresql.org; Mon, 22 Oct 2018 03:20:13 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1gEQlC-0004SY-HJ for pgsql-committers@lists.postgresql.org; Mon, 22 Oct 2018 03:20:11 +0000 Received: from pro.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.4/8.14.4) with ESMTP id w9M3K4xR005644; Sun, 21 Oct 2018 23:20:04 -0400 From: Tom Lane To: Michael Paquier cc: pgsql-committers@lists.postgresql.org Subject: Re: pgsql: Set pg_class.relhassubclass for partitioned indexes In-reply-to: <20181022031212.GF14282@paquier.xyz> References: <82470.1540177167@sss.pgh.pa.us> <20181022031212.GF14282@paquier.xyz> Comments: In-reply-to Michael Paquier message dated "Mon, 22 Oct 2018 12:12:12 +0900" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <82548.1540178404.1@sss.pgh.pa.us> Date: Sun, 21 Oct 2018 23:20:04 -0400 Message-ID: <82549.1540178404@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Michael Paquier writes: > On Sun, Oct 21, 2018 at 10:59:27PM -0400, Tom Lane wrote: >> Seems like this commit should have touched the catalogs.sgml description >> for that column, as well as the pg_class.h comment for it. Neither of >> those are worded in a way that suggests it could be set for non-table >> relations. > The pg_class.h comment looked fine for me first. How would you reword > it? Well, the question is what "derived class" means, but I'd tend to think it means something that has an associated composite type; which indexes do not. So maybe instead of "has (or has had) derived classes", we could write "has (or has had) child tables or indexes"? I'm not wedded to particular wording for this, but I think what's there now is a bit misleading. > relispartition tells "True if table is a partition", which is not > actually true as it can apply to indexes. So this should be changed in > v11 as well, no? Good point, that column's description is obsolete as well. regards, tom lane