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.96) (envelope-from ) id 1wHcoL-007MYw-0d for pgsql-hackers@arkaria.postgresql.org; Tue, 28 Apr 2026 07:24:49 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wHcoK-00Gefr-1M for pgsql-hackers@arkaria.postgresql.org; Tue, 28 Apr 2026 07:24:48 +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.96) (envelope-from ) id 1wHcoK-00GefZ-0P for pgsql-hackers@lists.postgresql.org; Tue, 28 Apr 2026 07:24:48 +0000 Received: from mail-dy1-x1341.google.com ([2607:f8b0:4864:20::1341]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wHcoH-000000039bg-1vMG for pgsql-hackers@postgresql.org; Tue, 28 Apr 2026 07:24:47 +0000 Received: by mail-dy1-x1341.google.com with SMTP id 5a478bee46e88-2ecf9e398f4so2656836eec.1 for ; Tue, 28 Apr 2026 00:24:45 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1777361085; cv=none; d=google.com; s=arc-20240605; b=C6QoaY9x7rkt/lUqAXBbhAS4UWivFd0eNGxdDLgn1YCro8e3Q/ddRrSr0rsPt75tza io9xJJLUbGcdZsufxOgyTfk/7ZTfD/ZyluqNxA5EAEUy9gut87HpZ/x4LjGCEr/C92ZD QC9tHdGrcPWo2LgpUkuc4+Gky7T46QY+FXoKmry0OpKJ1jvS1Tke3zyJrz7gMphrpJ4v ZPuageonWg8Nu+ouSqxZnRCFvql3RUK5xxVLHpHvf2QPbGiNmt43LOYDenM8ZDSG723d KJ++U4CPsts2dRcv5+ScRYSWQMiHxTq3TE/5a/dMibSeMsxv4nduBRdqKSxjyCAu0aTZ Zx3g== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:dkim-signature; bh=4cJYTjK1lwGJ8aZTTkXw02cBS5jWhkRUEFtshc/M7AM=; fh=HVoRtOQjyuSZSaucgfgEzFuzy8MkPtYHNWKgW/3TZqY=; b=I4hB26Ov8jZhGn6YW9xyCR6aKh3l0usiaTruHf8OiUwIwrAlXEVK9FX4s8tnlu7R79 03snJtFDMYfrVD1yDCOCk2CeUMgly3HRAKhewqRB3/Csb9paDP0X2We/EfeowRKDcrsX DUQ0ZqAAeCkZcZzIdap4XjQxvklKO4TQoR+lm8b9ptJlYu+vyqgRkAHxfUWsmQJvDziU 3NLFyxc+20Uz5uNUJklUjja24CuB4IXQZZCZypbSH68y1Ek6sMsDDMPLQtzavoNI6dvq L/rBTkR1vg3dLHB+hQ1AWDCGLDMElLKDr+cyCljXFr5RqsEPUOnd3dBr/lA1AvPhxyQK IIDQ==; darn=postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1777361085; x=1777965885; darn=postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=4cJYTjK1lwGJ8aZTTkXw02cBS5jWhkRUEFtshc/M7AM=; b=K4WUwGZNNlWDhbmlIYQB8825VSjd/mqqW/rDHtrSmeA7JhqJ6h/geHUvS86wwNtiDW JPi40AUV5QMyuV7Ie7z/Llri7+HZu9iX5kkDGIV2x4HMXAuUo2jA3cTfaLuANQwoTl83 d2CuB+BbeuyBSog6iYLLVqRgqnkXMj9RBcGD72Sj+JjcPze4vIqunpouAmXx1Bk/87lB lWMMyWU35PFzMZW/CuHz79VntuAdjgEkPn5fF/TnvYuhGrAfSiLKf2nOkH7u/yxrXrDW pC/1khzlFAeUre4BM2UC7Km2TTV0KTl4Xdzl8CBW8CtV79bOLKGbClgZ1YcEJLaXWgMQ oGBQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1777361085; x=1777965885; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-gg:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=4cJYTjK1lwGJ8aZTTkXw02cBS5jWhkRUEFtshc/M7AM=; b=onZjQDHiTca2yCgKYTuEnDgzcLCBclbvRSL9/a4W3NGlyOHpU/YTMEuCBzgrZfD1Tj UimnIF/BTYx7Wk/U+LOSCZZ7ixUT/CGJwT5WHw8Dv0iIb61we5wi169mbUYywX6Klv0W iXxA91yikhoXmx4V1dUuPBdSntSrYBYMyM9X+b8d+8d0UEvT8LpGgczH+i/lSXHjU2mc NFziwfAgbEYGI1CUhNLYiu4wdViIh2J9sbo0p+Kesck5ps7ngzqvwU1AZKKLhjStzHJO 1Oz8TPqQfeBgTidpUkYovy6TUbhkHrZdgehY1wgPHUeUknSF8snKiANmCIQYTz8K+5UU v3WQ== X-Gm-Message-State: AOJu0YyWawNM/7z7dlLnwFIdP3LI03L2xXJc8rwQtCCbVdXrZW84u0c3 ZiXIo/bK05mVAZ+DjwK2n6cMwYGZ/4rfE108QIQNBBnYGlo2vPhP7PhmV+GFuCb6rJnItBjU8f3 v/PKi9ekd7Uz+rN8JQnTqzZmKdSVGEFE= X-Gm-Gg: AeBDieteeC7QjgOdysXz5vbXwAfHLWu7zyHpd9YtNm2PUeG49np04Aw5PiCtWVd5b88 VPryvBvT5A3Zn8mdvl5MCnWAMip6GLkWEiqlA3WNZl/8lDoXYUBii4yIFfGG2L8ZUUsKix/s9Bp Yp0d/vynW3v4He124i2Racga1sQ6SaLsINPUfYnp9kaghXHWa+MV+xIQVK2pOQqa2zJbII6l6JS dqY/KmKki9C/qW+EoiT+7/H456XbafXVARMckkgpbGIWyJZoSr841XyPpEWxCNIjlBWeZH/Gf2c NsDZcxI2z/+CuRZaPw== X-Received: by 2002:a05:7301:1293:b0:2be:142f:d499 with SMTP id 5a478bee46e88-2ed0a09f504mr883944eec.16.1777361084828; Tue, 28 Apr 2026 00:24:44 -0700 (PDT) MIME-Version: 1.0 References: <0d2d7026-a34f-44bf-b22d-ae9be5e48575@app.fastmail.com> In-Reply-To: From: lakshmi Date: Tue, 28 Apr 2026 12:58:53 +0530 X-Gm-Features: AVHnY4J4dVoTSMOgg3yCnlekRnyKIBXWXgddcT1U2ksptBlRKVm3YUy8C3TifKI Message-ID: Subject: Re: create table like including storage parameter To: jian he Cc: pgsql-hackers Content-Type: multipart/alternative; boundary="000000000000194e4d0650802060" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000194e4d0650802060 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Hi all, I tested the patch on current HEAD. INCLUDING PARAMETERS works as expected. It correctly copies storage parameters. Duplicate parameters raise an error, and existing LIKE behavior remains unchanged. When used with a VIEW, parameters are ignored (since they are not valid for tables), and the command completes without error. Overall, the feature looks good from my testing. It might be worth documenting the behavior for VIEWs. Regards, Lakshmi G On Tue, Apr 28, 2026 at 12:49=E2=80=AFPM jian he wrote: > Hi. > > Because of https://cfbot.cputube.org/patch_6088.log > A trivial rebase is attached. > > > -- > jian > https://www.enterprisedb.com/ > --000000000000194e4d0650802060 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable

Hi all,

I tested the patch on current HEAD.

INCLUDING PARAMETERS works as expe= cted. It correctly copies storage parameters. Duplicate parameters raise an= error, and existing LIKE behavior remains unchang= ed.

When used with a VIEW, parameters a= re ignored (since they are not valid for tables), and the command completes= without error.

Overall, the feature looks good from my testing. It m= ight be worth documenting the behavior for VIEWs.

Regards,
Lakshm= i G


On Tue, Apr 28, 2026 at 12:49=E2=80=AFP= M jian he <jian.universal= ity@gmail.com> wrote:
Hi.

Because of https://cfbot.cputube.org/patch_6088.log
A trivial rebase is attached.


--
jian
https://www.enterprisedb.com/
--000000000000194e4d0650802060--