Received-SPF: pass (ha01s018.org-dns.com: connection is authenticated)
Date: Sat, 2 Nov 2024 08:13:34 +0100 (GMT+01:00)
From: Thiemo Kellner <thiemo@gelassene-pferde.biz>
To: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Message-ID: <97798840-f7e0-4d6d-8326-1c2043e9cde9@gelassene-pferde.biz>
In-Reply-To: <5466153d-3bc3-4553-a5b2-d4c5050fb1d5@aklaver.com>
References: <ea963edb-5437-4de6-bd2c-97c141a391b8@gelassene-pferde.biz>
 <5757acdc-39ed-4642-a449-26e47b1bcf95@gelassene-pferde.biz>
 <d9d6a2f4-379b-45f3-9005-ab047625c1a4@aklaver.com>
 <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>
 <CAKkG4_nV-+6rz-01pA-S5vD7ai2h_ujF1cDFoOBG10CCHgRfmg@mail.gmail.com>
 <20241101201600.Horde.Br4fPP8BFAAwzFoMaM8_eJS@webmail.gelassene-pferde.biz>
 <666c82fe-be27-4f32-99ad-8952a56f2282@aklaver.com>
 <8791c3bf-6fff-4db4-a29e-2679d2de0960@gelassene-pferde.biz>
 <ce5f42dd-9513-479a-b64f-2d05b0d22135@aklaver.com>
 <20241102001013.Horde.g70bTplHNWnh_M3vk9I-edj@webmail.gelassene-pferde.biz>
 <5466153d-3bc3-4553-a5b2-d4c5050fb1d5@aklaver.com>
Subject: Re: Plans for partitioning of inheriting tables
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
Archived-At: <https://www.postgresql.org/message-id/97798840-f7e0-4d6d-8326-1c2043e9cde9%40gelassene-pferde.biz>
Precedence: bulk

My bad. I was expecting primary and unique to be mentioned here, so I did n=
ot read on.


**INCLUDING CONSTRAINTS*** **#[https://www.postgresql.org/docs/current/sql-=
createtable.html#SQL-CREATETABLE-PARMS-LIKE-OPT-CONSTRAINTS]*

/*CHECK*// constraints will be copied. No distinction is made between colum=
n constraints and table constraints. Not-null constraints are always copied=
 to the new table./


02.11.2024 00:53:53 Adrian Klaver <adrian.klaver@aklaver.com>:

> On 11/1/24 16:10, thiemo@gelassene-pferde.biz wrote:
>> Adrian Klaver <adrian.klaver@aklaver.com> escribi=C3=B3:
>> On 11/1/24 13:47, Thiemo Kellner wrote:
>>>> It looks to me basically to be a "create table A as select * from B wh=
ere false".
>>>=20
>>> No it more capable then that.
>> Yes, I wrote basically, not exactly.
>> CREATE TABLE <some_tbl> LIKE <some_other_tbl> has=C2=A0 like_option whic=
h allows to transfer over more attributes of the table, for example default=
s, constraints, indexes, etc.
>> But, to my understanding, no primary nor unique nor foreign constraint.
>>=20
>=20
>=20
> "INCLUDING INDEXES
>=20
> =C2=A0=C2=A0=C2=A0=C2=A0 Indexes, PRIMARY KEY, UNIQUE, and EXCLUDE constr=
aints on the original table will be created on the new table. Names for the=
 new indexes and constraints are chosen according to the default rules, reg=
ardless of how the originals were named. (This behavior avoids possible dup=
licate-name failures for the new indexes.)
> "
>=20
> FK's are not in the the INCLUDINGs, nor triggers.
>=20
>=20
> --=20
> Adrian Klaver
> adrian.klaver@aklaver.com