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 1vt6JG-002jsz-2B for pgsql-docs@arkaria.postgresql.org; Thu, 19 Feb 2026 15:51:22 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vt6JF-0048Ul-25 for pgsql-docs@arkaria.postgresql.org; Thu, 19 Feb 2026 15:51:21 +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.96) (envelope-from ) id 1vt6JF-0048Ud-1O for pgsql-docs@lists.postgresql.org; Thu, 19 Feb 2026 15:51:21 +0000 Received: from mail-oo1-xc2e.google.com ([2607:f8b0:4864:20::c2e]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1vt6JB-000000009yO-3IJK for pgsql-docs@lists.postgresql.org; Thu, 19 Feb 2026 15:51:20 +0000 Received: by mail-oo1-xc2e.google.com with SMTP id 006d021491bc7-66ee7b9af94so408920eaf.0 for ; Thu, 19 Feb 2026 07:51:18 -0800 (PST) ARC-Seal: i=1; a=rsa-sha256; t=1771516277; cv=none; d=google.com; s=arc-20240605; b=DsyaF35kKosjWoKE9pgKQB8M0WDY4nDiorKBGgIPvtjI+OK+9hkwrS5+/5LCaJ2HRX Y84PGNtOjR/ESeFNKWaoOGx0aX/F+r75lHvEApgnaJfIWKZ3KETouf9e3yzqlj+PqMyI O6YNXn5BA7n2nvl0cdu5JSJh6y2E5QP1mhfOzd67DMzeKPJcDLHpr7AYCO6xytcNPZG5 hCoWL4tkVaWytjd3YArVRvXkk9k5+2TTso15tEILEhjY0Ysasdi1tok9HgkJ4SOFfeGn FGxhGChMvLcB3BsKl7NONZX4CTrppkh8o0yAJZja2w3YOmXhuFyb+/FDso4v4AXvALo/ tvJw== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:dkim-signature; bh=9qnhYmkPynxB93vLcNpE0BRDaNcC3+ITDhbO/cwsaGo=; fh=MyWCkdjFMbgb+AmQQSh1eC35PIjGoxIVh1yuLL7/KsU=; b=OMx15Ug7rGMwMg9/rouPWNkfwn7eYcy2IcDYxfTI9Xr1pHL0m5xKWydwETl4kc9a3F D9rJPDiLPXFjV0BX8FUWb4mSl22Vbk4oEY2iebHE1Kewg/AJNFA9W+coVuTs1S+M2A9+ uqa6xYf6zyiuub+JMNXImrHMEgozq7KAgctTomJEIzwuiMf1j2CtjHMCJKgbbhHjUCVe O+V1pDyxiQI1mbYtILAY2Y1OyXpYpJqVWtZTsDWowTQwGEpGnOLG1V1/YkF0Cthq7bjc FZI5J0MdQzSOLYNflqxaSH2odMLjy5tzdsSzSg2DE+SzQXHqTpM1Mwx0wJwDM6u3mMAS vUYw==; darn=lists.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=20230601; t=1771516277; x=1772121077; darn=lists.postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=9qnhYmkPynxB93vLcNpE0BRDaNcC3+ITDhbO/cwsaGo=; b=SEbjOo5YaVdu4E1BrvudzB/T9EugOLBg96RWHbjYGyDc8ZkaMDIwn3kUD8Kk1D4Lgo yIGpFX1ZKR03DmSAY4HMmJ4XdqBIBzhW3Su8Anrlq+dGfA4PFITW01UQzlndtRjs4rBQ ZJ5QSGbOc6+d0fBRCiPNyz7SO+vosl38IE4R81NAmCHZQlCqXStefJvBwJP9LYBta7Bs 0uAoDLfriRKnnKEAo+bqIxBDp+wA2wtylwT7GtSFmhaHIckGiKy8WMZWEuU96B9NdDxy LhBUJkeIm013nP9XpBpniiEzwPQ0rezXl9Sep2ptSIPlW7z3BudzreGklEHjqB1YckN9 E6FA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1771516277; x=1772121077; h=content-transfer-encoding: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=9qnhYmkPynxB93vLcNpE0BRDaNcC3+ITDhbO/cwsaGo=; b=vLS44sXhmqYg11EIOhu65kd7ksf2GXOZjGAvyW8/NhPE+5d+2xahcJweX7xX6Bf+hH /RlSmlQPuGZgHzTE/WKPM1viZ9kUln4BNYkREQMFIkoZSIS2ccDM4wBSRJUcIHz9xqr+ 9BUItZOv1L/f1TDt1yfORhNki+vZMQZZtY9z3snp/f1DUAaZez8WNF6vWySUdtaRszXV 1YLLVksXG6d05gRtojTecl6qnwDhfjGaPiW04SMI5rbpeRi3KjjoEdx3qnniovaUwsGR es3nmab5LFerVSlxopT/tUgVvSUpKkebyVf2xmOkP/Y1Ez7TGBCF0Rg1wM0dBAhLKtJK 6mOA== X-Gm-Message-State: AOJu0YzYE7tsn1eT77Kv08OcePtLa90eoOu20jHrF7fOiq1qh4zb+Zxo qrJXUIHvsUvbC0aEYjwMzDezMerwUs557DurDTctVHMagkIRl+XqkvApHGfGYajGTYibicFV2ub st9Yr9XaUNiuL4MLlHhoaX1iylFMLfws= X-Gm-Gg: AZuq6aLoVHsGK6ogSxpvKsBojxKXw5lLAY5UWKe4Mo0uXeGtAIzjDbVchQ7i1DA7hFt +/09rYi9XBqK1M1WPz1MwTocQ18cEW1HSIJKYmTDlb+bWjjfrdlmtzoad7VhS1xCCyqEQAQW/0x fUCkXgLDexee6TFi/gWPDadbiQihvftXFU2WSnC1e0sZDqG6XTE4VnjXqSr3k0ofZR9G8JgSDru 7APBzwNbaNmmrNoy24IqqXV/aQUkia2SsXiYRJYEhyCdyqDN84o7LHyHsw6V9UVy2VwXDeQ4i7X AnUJgcVDppAg2VCQa5yFF/bykzrLy+nYGxhIishj X-Received: by 2002:a05:6820:c8d:b0:679:ae81:9b60 with SMTP id 006d021491bc7-679ae819d82mr1712906eaf.52.1771516276688; Thu, 19 Feb 2026 07:51:16 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: Fujii Masao Date: Fri, 20 Feb 2026 00:51:04 +0900 X-Gm-Features: AaiRm505zC6wvBd9NChGTjS3pZrKLGF6JoccqkDxxpqlWtNhhNO_dpA1QG0-c5A Message-ID: Subject: Re: Clarify INCLUDING COMMENTS behavior in CREATE TABLE and CREATE FOREIGN TABLE docs To: Matheus Alcantara Cc: pgsql-docs@lists.postgresql.org Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, Feb 20, 2026 at 12:10=E2=80=AFAM Matheus Alcantara wrote: > > On Tue Feb 17, 2026 at 11:36 AM -03, Fujii Masao wrote: > > Hi, > > > >> Comments for the copied columns, constraints, and indexes will be copi= ed. > > > > The above current description of INCLUDING COMMENTS in the CREATE TABLE= docs > > appears inaccurate and incomplete. It says that comments on constraints= are > > copied, but in practice only comments on CHECK and NOT NULL constraints > > are copied; comments on other constraints (such as primary keys) are no= t. > > In addition, comments on extended statistics are copied, but this is no= t > > documented. > > > > The CREATE FOREIGN TABLE docs has a similar omission: comments on exten= ded > > statistics are also copied, but this is not mentioned. > > > > Therefore I'd like to propose the attached patch to clarify the actual = behavior > > of INCLUDING COMMENTS. Thoughts? > > > > Hi, thanks for the patch. > > The changes make sense to me, it sounds more clear. I've performed some > tests and the documentation seems correct about what comments are > actually copied. Thanks for the review! Barring any objections, I will commit the patch. Regards, --=20 Fujii Masao