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 1gEQdn-0004QG-0Q for pgsql-committers@arkaria.postgresql.org; Mon, 22 Oct 2018 03:12:27 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gEQdk-0002Ex-Jf for pgsql-committers@arkaria.postgresql.org; Mon, 22 Oct 2018 03:12:24 +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 1gEQdi-0002Eq-Mz for pgsql-committers@lists.postgresql.org; Mon, 22 Oct 2018 03:12:24 +0000 Received: from out3-smtp.messagingengine.com ([66.111.4.27]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1gEQde-0004KH-Hg for pgsql-committers@lists.postgresql.org; Mon, 22 Oct 2018 03:12:21 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.nyi.internal (Postfix) with ESMTP id 7CA5F211E6; Sun, 21 Oct 2018 23:12:17 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute4.internal (MEProxy); Sun, 21 Oct 2018 23:12:17 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= date:from:to:cc:subject:message-id:references:mime-version :content-type:in-reply-to; s=fm3; bh=EUGYUDCAh/je4+qQ1oR3fE2MXTP SrhE8XDEfyJql9/A=; b=YVwEQUF20x0z8s8GuAamxCQXk3LxXkK8tqx+kSRb/4h flbYzbToJAn35RjcfEA5lgqsS12YQXZbO0ImUKtfjznTJRgRdV7SXpz5E552lfqV JQIp0KEeRMlKiBTimNGTzkgacfeaCJPtXHwl45Eq6VTwXh/87TCSU55sD3LXAgRG xuxUi6g18ZK5vee+2/0ttWGGDXFNuutaVX9M798g+O40ay7mmch1Y8KR+qI7n/l1 vrBKz3f4PWLZlHwxMHoBrshmrASWh8GRhmVLxp93o4BNxKMlJmRDIdTMBmQ55roP fcqhLTwihQMWDvpJbmV/zu8C36m/l7xc9VAuAxjLwZw== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-me-proxy :x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm1; bh=EUGYUD CAh/je4+qQ1oR3fE2MXTPSrhE8XDEfyJql9/A=; b=vJt8c9nUQGRYTBfYYqMMOn hY/L6bWoHTB8/lxXEMUkH4cQWKrCp6kxOur3Q8OSKmDqu2spI+PNssbUZ3fuh+1V 9o8HMJ2Kbhyd9oL/loyqNhK6i2zmp9AC1XJHVUlHLyj1Ztgc8DZ37IchMzxaB2dC IvfhDbFOB58YrnsqIMsm7AVEhDq12achqVv0mBltB6gK101ifq08saRlpEuVR4az 4tJ1PvcCMN35++G69tsm8j6oJ+ycblfU2sfSuUcOaDpA2D2uYJj01HYGnJL5Kib6 wWa3mCERmh/kxZ889ygDJ7hkMN3OtyOClbnPkLJucOdlRHm7kEGSaqmvCWiuVwng == X-ME-Sender: X-ME-Proxy: Received: from paquier.xyz (c137162.net61215.cablenet.ne.jp [61.215.137.162]) by mail.messagingengine.com (Postfix) with ESMTPA id 1F650E455C; Sun, 21 Oct 2018 23:12:14 -0400 (EDT) Date: Mon, 22 Oct 2018 12:12:12 +0900 From: Michael Paquier To: Tom Lane Cc: pgsql-committers@lists.postgresql.org Subject: Re: pgsql: Set pg_class.relhassubclass for partitioned indexes Message-ID: <20181022031212.GF14282@paquier.xyz> References: <82470.1540177167@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="xHbokkKX1kTiQeDC" Content-Disposition: inline In-Reply-To: <82470.1540177167@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --xHbokkKX1kTiQeDC Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Sun, Oct 21, 2018 at 10:59:27PM -0400, Tom Lane wrote: > Michael Paquier writes: >> Set pg_class.relhassubclass for partitioned indexes >=20 > 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? 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? For relhassubclass, perhaps we could do a bit more than just referring to children... What about the following: "True if relation has (or once had) any inheritance children or partitions" Here is the current formulation: "True if table has (or once had) any inheritance children" And this should be changed in v10~ additionally? -- Michael --xHbokkKX1kTiQeDC Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAlvNQAwACgkQnvQgOdby QH2gCA/+JbyaEilBepmTcOvsWaOl4OeOnZnNZN9605rKxfEPn9vwDY3vg3SEt2FL xsrCuMYU5cnUnpGcU2gQzfMrhH6uGiKcUpj/FN7a4cdU+KAYpjoaf/sECGtulGdJ 1xfczxravZ/MM1G8ArHkXcx2kacefNl0hYC2s0eA3mDGUb0J2H4Jkmbk+lFsZ+Fh H43jxQMYNdwffbVkNRW+R5WJiZsnZzhtKI3ehpU8dARALXwHImbkNNbTzQ++3bp9 YHlb66VTnTGizy4dZ5gtbk1b7Y9FgKndnrFKrgQM54zDmB8YkT66FHL2X9VG7OKr qOgGirSugJZidUzmpW45PL0dxEcJDBnFgM5wYQm0xm1UMQJkyBTyv0XcV1PZO+kI WjtRSZC1NfjMbDNR+82yDAKLdF9il5e0SJv5+xrj/ybkWeDTsgLArt25JxBYPdzo evdk3twXblOQ+VXcDQVtG178ptqtUrGU/aD4Xlvx4qfHWkPOo9KRQssRl/nr9I/Y EZalXXSnTWGH3wtlqiXj9e52Rd/T54AqEeE4aUoGa4i33KUDJunmFrdPdm6gMeML 6mOFMEv5ku9DTGg9pVGr3Ul2N5LMeW77YgEQd9uMElewvFRji7TlkSUHFZNn+Bvn M7CYJBIU51H8qbZyAVJgZa+aETuzNolZqQUVkFdw3SHkA9EZsrc= =Ug5W -----END PGP SIGNATURE----- --xHbokkKX1kTiQeDC--