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 1t4Cwx-00GzHN-Rj for pgsql-general@arkaria.postgresql.org; Fri, 25 Oct 2024 05:33:27 +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 1t4Cwv-00CUWm-5S for pgsql-general@arkaria.postgresql.org; Fri, 25 Oct 2024 05:33:25 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1t4Cwu-00CUW1-QU for pgsql-general@lists.postgresql.org; Fri, 25 Oct 2024 05:33:25 +0000 Received: from sm-r-016-dus.org-dns.com ([89.107.70.6]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1t4Cws-002rJT-E6 for pgsql-general@lists.postgresql.org; Fri, 25 Oct 2024 05:33:24 +0000 Received: from smarthost-dus.org-dns.com (localhost [127.0.0.1]) by smarthost-dus.org-dns.com (Postfix) with ESMTP id 17CFEA079A for ; Fri, 25 Oct 2024 07:33:21 +0200 (CEST) Received: by smarthost-dus.org-dns.com (Postfix, from userid 1001) id 0B68BA10D4; Fri, 25 Oct 2024 07:33:21 +0200 (CEST) X-Spam-Status: No, score=0.9 required=5.0 tests=AWL,BAYES_00,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 B5399A079A for ; Fri, 25 Oct 2024 07:33:20 +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:33:16 +0200 (GMT+02:00) From: Thiemo Kellner Cc: PostgreSQL General Message-ID: In-Reply-To: <797b23aa-f54b-4849-80a7-9a6b322fa53b@aklaver.com> References: <20241024214702.Horde.hYZQZgT8lc-DKEIqL9Ai-E3@webmail.gelassene-pferde.biz> <797b23aa-f54b-4849-80a7-9a6b322fa53b@aklaver.com> Subject: Re: Plans for partitioning of inheriting tables MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit X-Correlation-ID: X-PPP-Message-ID: <172983440052.1251568.11003391236729792667@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 Thanks for taking this up. 24.10.2024 22:44:11 Adrian Klaver : > > 1) Have you looked at?: > > https://www.postgresql.org/docs/current/ddl-partitioning.html#DDL-PARTITIONING-USING-INHERITANCE I do not feel it applies to my case. I tried to create a partitioned table that inherits columns from a base table. The documentation you provided the URL seems to speak of realising partitioning by using inheritance. > > 2) Provide the SQL you ran that got the above error? https://sourceforge.net/p/treintaytres/code/HEAD/tree/trunk/code_files/data_storage/PostgreSQL/tables/TEMPLATE_TECH.pg_sql