Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1t4D6C-00Gzva-Me for pgsql-general@arkaria.postgresql.org; Fri, 25 Oct 2024 05:43:00 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1t4D6A-00CbKe-6a for pgsql-general@arkaria.postgresql.org; Fri, 25 Oct 2024 05:42:58 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1t4D69-00CbKV-Rs for pgsql-general@lists.postgresql.org; Fri, 25 Oct 2024 05:42:58 +0000 Received: from sm-r-007-dus.org-dns.com ([84.19.1.235]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1t4D67-002jxn-4n for pgsql-general@lists.postgresql.org; Fri, 25 Oct 2024 05:42:57 +0000 Received: from smarthost-dus.org-dns.com (localhost [127.0.0.1]) by smarthost-dus.org-dns.com (Postfix) with ESMTP id B5EB9A12F6 for ; Fri, 25 Oct 2024 07:42:52 +0200 (CEST) Received: by smarthost-dus.org-dns.com (Postfix, from userid 1001) id A9F8EA130F; Fri, 25 Oct 2024 07:42:52 +0200 (CEST) X-Spam-Status: No, score=1.4 required=5.0 tests=AWL,BAYES_05,HTML_MESSAGE, KAM_INFOUSMEBIZ,MISSING_HEADERS,RCVD_IN_VALIDITY_CERTIFIED_BLOCKED, RCVD_IN_VALIDITY_RPBL_BLOCKED,SPF_HELO_PASS,SPF_PASS autolearn=no autolearn_force=no version=3.4.6 Received: from ha01s018.org-dns.com (ha01s018.org-dns.com [62.108.32.138]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange ECDHE (P-384) server-signature RSA-PSS (2048 bits) server-digest SHA256) (No client certificate requested) by smarthost-dus.org-dns.com (Postfix) with ESMTPS id 6581FA12F6 for ; Fri, 25 Oct 2024 07:42:52 +0200 (CEST) Authentication-Results: ha01s018.org-dns.com; spf=pass (sender IP is 46.253.189.53) smtp.mailfrom=thiemo@gelassene-pferde.biz smtp.helo=dummy.faircode.eu Received-SPF: pass (ha01s018.org-dns.com: connection is authenticated) Date: Fri, 25 Oct 2024 07:42:49 +0200 (GMT+02:00) From: Thiemo Kellner Cc: PostgreSQL General Message-ID: <7f97ac8c-39be-4bbb-881e-d1ba4cc74ad3@gelassene-pferde.biz> In-Reply-To: References: <20241024214702.Horde.hYZQZgT8lc-DKEIqL9Ai-E3@webmail.gelassene-pferde.biz> Subject: Re: Plans for partitioning of inheriting tables MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_9_78662252.1729834969187" X-Correlation-ID: <7f97ac8c-39be-4bbb-881e-d1ba4cc74ad3@gelassene-pferde.biz> X-PPP-Message-ID: <172983497227.1259008.15518614753561007531@ha01s018.org-dns.com> X-PPP-Vhost: gelassene-pferde.biz X-POWERED-BY: wint.global - AV:CLEAN SPAM:OK List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_9_78662252.1729834969187 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable 24.10.2024 22:58:39 David G. Johnston : >=20 > My impression of things is that directly using =E2=80=9Cinherit=E2=80=9D = for table creation is considered deprecated at this point.=C2=A0 No one has= interest in expanding on the feature nor even recommends it be used in new= development.=C2=A0 That particular unique feature of PostgreSQL hasn=E2=80= =99t caught on. >=20 > David J. > =C2=A0 Thanks for sharing your experience. I wonder if this is the general take on= inheritance for spreading common attributes throughout a database. ------=_Part_9_78662252.1729834969187 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable 24.10.2024 22:= 58:39 David G. Johnston <david.g.johnston@gmail.com>:

My impres= sion of things is that directly using =E2=80=9Cinherit=E2=80=9D for table c= reation is considered deprecated at this point.  No one has interest i= n expanding on the feature nor even recommends it be used in new developmen= t.  That particular unique feature of PostgreSQL hasn=E2=80=99t caught= on.

David J.<= /span>
 
T= hanks for sharing your experience. I wonder if this is the general take on = inheritance for spreading common attributes throughout a database.
------=_Part_9_78662252.1729834969187--