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 1t70mZ-00GzRf-R4 for pgsql-general@arkaria.postgresql.org; Fri, 01 Nov 2024 23:10:19 +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 1t70mY-001FCJ-1K for pgsql-general@arkaria.postgresql.org; Fri, 01 Nov 2024 23:10:18 +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 1t70mX-001FAs-MC for pgsql-general@lists.postgresql.org; Fri, 01 Nov 2024 23:10:18 +0000 Received: from sm-r-002-dus.org-dns.com ([89.107.70.11]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1t70mV-004GKC-OO for pgsql-general@lists.postgresql.org; Fri, 01 Nov 2024 23:10:17 +0000 Received: from smarthost-dus.org-dns.com (localhost [127.0.0.1]) by smarthost-dus.org-dns.com (Postfix) with ESMTP id D5102A21DC for ; Sat, 2 Nov 2024 00:10:14 +0100 (CET) Received: by smarthost-dus.org-dns.com (Postfix, from userid 1001) id C8D0BA21F2; Sat, 2 Nov 2024 00:10:14 +0100 (CET) X-Spam-Status: No, score=-1.1 required=5.0 tests=AWL,BAYES_00,KAM_INFOUSMEBIZ, 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 94A49A21DC for ; Sat, 2 Nov 2024 00:10:14 +0100 (CET) Authentication-Results: ha01s018.org-dns.com; spf=pass (sender IP is 127.0.0.1) smtp.mailfrom=thiemo@gelassene-pferde.biz smtp.helo=ha01s018.org-dns.com Received-SPF: pass (ha01s018.org-dns.com: connection is authenticated) Received: from [5.83.191.177] ([5.83.191.177]) by webmail.gelassene-pferde.biz (Horde Framework) with HTTPS; Sat, 02 Nov 2024 00:10:13 +0100 Date: Sat, 02 Nov 2024 00:10:13 +0100 Message-ID: <20241102001013.Horde.g70bTplHNWnh_M3vk9I-edj@webmail.gelassene-pferde.biz> From: thiemo@gelassene-pferde.biz To: PostgreSQL General Subject: Re: Plans for partitioning of inheriting tables References: <5757acdc-39ed-4642-a449-26e47b1bcf95@gelassene-pferde.biz> <20241101094106.Horde.TwPSs9YUgJ5v-_M-4ltwoeh@webmail.gelassene-pferde.biz> <14c1eb8c-a853-43b3-a1ea-b105bfd6c99b@aklaver.com> <20241101182110.Horde.P_w6KptTjJNeM1X9Asg5bE3@webmail.gelassene-pferde.biz> <6bc57377-52e1-496a-b9d6-4cd9dc84d92e@aklaver.com> <20241101201600.Horde.Br4fPP8BFAAwzFoMaM8_eJS@webmail.gelassene-pferde.biz> <666c82fe-be27-4f32-99ad-8952a56f2282@aklaver.com> <8791c3bf-6fff-4db4-a29e-2679d2de0960@gelassene-pferde.biz> In-Reply-To: Accept-Language: de Content-Type: text/plain; charset=utf-8; format=flowed; DelSp=Yes MIME-Version: 1.0 Content-Disposition: inline Content-Transfer-Encoding: 8bit X-PPP-Message-ID: <173050261445.4006933.3248895518087640281@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 Adrian Klaver escribió: > On 11/1/24 13:47, Thiemo Kellner wrote: >> It looks to me basically to be a "create table A as select * from B >> where false". > > No it more capable then that. Yes, I wrote basically, not exactly. > CREATE TABLE LIKE has like_option which > allows to transfer over more attributes of the table, for example > defaults, constraints, indexes, etc. But, to my understanding, no primary nor unique nor foreign constraint.