Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hudo6-0005cl-Qa for pgsql-docs@arkaria.postgresql.org; Mon, 05 Aug 2019 14:17:50 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hudo5-0002y1-HA for pgsql-docs@arkaria.postgresql.org; Mon, 05 Aug 2019 14:17:49 +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_SHA1:256) (Exim 4.89) (envelope-from ) id 1hudo5-0002xu-AL for pgsql-docs@lists.postgresql.org; Mon, 05 Aug 2019 14:17:49 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hudo2-0006Uc-IM for pgsql-docs@lists.postgresql.org; Mon, 05 Aug 2019 14:17:48 +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 x75EHeX0012463; Mon, 5 Aug 2019 10:17:40 -0400 From: Tom Lane To: martin@arp242.net cc: pgsql-docs@lists.postgresql.org Subject: Re: Is it wise to include table inheritence in the tutorial? In-reply-to: <156495686451.8638.382610819642178810@wrigleys.postgresql.org> References: <156495686451.8638.382610819642178810@wrigleys.postgresql.org> Comments: In-reply-to PG Doc comments form message dated "Sun, 04 Aug 2019 22:14:24 -0000" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <12461.1565014660.1@sss.pgh.pa.us> Date: Mon, 05 Aug 2019 10:17:40 -0400 Message-ID: <12462.1565014660@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk PG Doc comments form writes: > I was reading the tutorial here: > https://www.postgresql.org/docs/11/tutorial-inheritance.html > But on the "don't do this" Wiki, it is strongly advised not to use this: > https://wiki.postgresql.org/wiki/Don't_Do_This#Don.27t_use_table_inheritance That wiki entry is just some random person's opinion, it's not project policy. Having said that, the partitioning feature is approaching the point of being mature enough to recommend to novices, so maybe we should start thinking about adjusting the tutorial with that in mind. I wouldn't necessarily remove the inheritance section; it's talking about OOP-style inheritance, which you can't get with partitioning. regards, tom lane