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 1uv7YZ-007f69-Nr for pgsql-docs@arkaria.postgresql.org; Sun, 07 Sep 2025 05:03:16 +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 1uv7YX-00G5rl-4N for pgsql-docs@arkaria.postgresql.org; Sun, 07 Sep 2025 05:03:13 +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 1uv7YW-00G5rd-RP for pgsql-docs@lists.postgresql.org; Sun, 07 Sep 2025 05:03:13 +0000 Received: from mail-oa1-x30.google.com ([2001:4860:4864:20::30]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uv7YR-000zAL-31 for pgsql-docs@lists.postgresql.org; Sun, 07 Sep 2025 05:03:11 +0000 Received: by mail-oa1-x30.google.com with SMTP id 586e51a60fabf-30cce86052cso2550377fac.1 for ; Sat, 06 Sep 2025 22:03:08 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1757221386; x=1757826186; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=pXbMxzBEeqh8sgv0kOMiX04iDFJMujtTNoLOYo7zeac=; b=busCVjIwMMVK01NAlq2PxGfsTvP9bqk/aBIKgP/iFY24mtXKd8IJ2YJujbjzAZXpgK xL5CQZJ5qEPpaaWR8BfNKWfM65+609rk7TWGlS9pPFkTOHx3qsUYZBZVbmK3xRz2HzjR a+d8YDkZ/cb0OlhaigeTkyzMo+YFWxsE5+kn3XhtOLok2jUAlaS1nCmjVRef2Y9C+9hL Px+DbaYC9wN9tFEptq4TiYNkVi1o56CmOfURNWpoWC9uFI6lU++dTE5tweb534WvCmPs oviCARU8x+3iD2guHAoM4YVx1nqqdlXDHfkl346U76BWxsyb8dexzX6/XLq6tfNZchS/ oAmg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1757221386; x=1757826186; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=pXbMxzBEeqh8sgv0kOMiX04iDFJMujtTNoLOYo7zeac=; b=I5BcIonnvcAnYg1vzrM/MngBKcrmWF7p3j4OnHBlKcGLVhRRFEF5MDEwluKEsdkKPt 0EfyJDq5pWLgS0Wi82o+Bh1kQiBz3e5Z5laZHP8vWa4c4zRdQK3WfPXUlKJC9Kmlr59e VlV3oO13lMZvsGqsYoAn5kjMgfRlS+koUjhzmOPtHVXVFbpUhHrbX6kEKDog7lkUkD06 GTX9c5Oyi45TJiY6KlC9ed1E9vDbJOEwxHvLzhhd59HA1M8D5CFwbAEI4+k+XoLkfvyZ /kGwou4a2sO4I3vOJb1/pLEsTWYQsqsFucBEUgFq9DHB95AYED/r5fjvPHNSKhgeIjGJ RFnQ== X-Gm-Message-State: AOJu0YzKDLyWrg72OOKVUVc2N/1EClOtZNghcaN888LJdHQc4a3LMz9z QcligInZpAJu5t4CSM2NvcT2kAMveiMcZ4bzrCOuN+YJrhWwGk5b15/WSb75gsuaCLtLQAwqB+/ nGVWeHiYm5dGtvccS3OhSALommT89CL8= X-Gm-Gg: ASbGnctuis5YDdUJSOg51DXxW0NHaCpMJEVW19zSSru0C+ISwv+Zy8a99z0e3jSwzs7 W6cCL2ngFW0JJ1W5r9iMZu6CmMfA9dRrVfOVCX5gzkZFCTic2Ah8dLtJOAPIIrpb1YZhZt7sNU4 7wkAq3W79/PUV7xvspVTWHDV7ZJ3Uhk5fu3hDEyT6BvdAlpO481QFgcQX0BhiJKwEBEXkyisyir TPHE+0T1Hfj8KYKoQ== X-Google-Smtp-Source: AGHT+IGeVxDA0i1ibEib4+HwywIUG7lXpbVlmImc/tzlk33qRl/RKhngwZefTtQM9xyoKKlK1mU84vP727171j98CpU= X-Received: by 2002:a05:6808:19aa:b0:438:257d:6663 with SMTP id 5614622812f47-43b29ba2498mr1467910b6e.48.1757221386468; Sat, 06 Sep 2025 22:03:06 -0700 (PDT) MIME-Version: 1.0 Received: by 2002:ac9:6a6f:0:b0:5df:b5f6:b71 with HTTP; Sat, 6 Sep 2025 22:03:05 -0700 (PDT) In-Reply-To: References: From: "David G. Johnston" Date: Sat, 6 Sep 2025 22:03:05 -0700 X-Gm-Features: Ac12FXyWlmvRuwVeaaCFEPLLjSIWLT9A4Myf8xpbH7nR5DoWYrZcs8WPiwSFK90 Message-ID: Subject: Re: CREATE TABLE LIKE(INCLUDING COMMENTS) description ignored STATISTICS To: jian he Cc: "pgsql-docs@lists.postgresql.org" Content-Type: multipart/alternative; boundary="000000000000884234063e2efcf4" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000884234063e2efcf4 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Saturday, September 6, 2025, jian he wrote= : > hi. > > https://www.postgresql.org/docs/devel/sql-createtable. > html#SQL-CREATETABLE-PARMS-LIKE-OPT-COMMENTS > """ > INCLUDING COMMENTS > Comments for the copied columns, constraints, and indexes will be copied. > The > default behavior is to exclude comments, resulting in the copied columns > and > constraints in the new table having no comments. > """ > > The above description should mention that comments on extended > statistics will be > copied as well? > > How about =E2=80=9CIf specified, existing comments on any copied elements a= re copied as well.=E2=80=9D ? Let=E2=80=99s fix this by removing the duplicat= ion of the list of things allowed to be copied, not by fixing the oversight the duplication permitted. David J. --000000000000884234063e2efcf4 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Saturday, September 6, 2025, jian he <jian.universality@gmail.com> wrote:
hi.

https://www.postgresq= l.org/docs/devel/sql-createtable.html#SQL-CREATETABLE-PARMS-= LIKE-OPT-COMMENTS
"""
INCLUDING COMMENTS
Comments for the copied columns, constraints, and indexes will be copied. T= he
default behavior is to exclude comments, resulting in the copied columns an= d
constraints in the new table having no comments.
"""

The above description should mention that comments on extended
statistics will be
copied as well?


How about =E2=80=9CIf specified, existing = comments on any copied elements are copied as well.=E2=80=9D ?=C2=A0 Let=E2= =80=99s fix this by removing the duplication of the list of things allowed = to be copied, not by fixing the oversight the duplication permitted.
<= div>
David J.

--000000000000884234063e2efcf4--