Re: Clarify INCLUDING COMMENTS behavior in CREATE TABLE and CREATE FOREIGN TABLE docs
Fujii Masao <masao.fujii@gmail.com>
From: Fujii Masao <masao.fujii@gmail.com>
To: Matheus Alcantara <matheusssilv97@gmail.com>
Cc: pgsql-docs@lists.postgresql.org
Date: 2026-02-19T15:51:04Z
Lists: pgsql-docs
On Fri, Feb 20, 2026 at 12:10 AM Matheus Alcantara <matheusssilv97@gmail.com> 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 copied. > > > > 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 not. > > In addition, comments on extended statistics are copied, but this is not > > documented. > > > > The CREATE FOREIGN TABLE docs has a similar omission: comments on extended > > 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, -- Fujii Masao
Commits
-
doc: Clarify INCLUDING COMMENTS behavior in CREATE TABLE LIKE.
- ec84a1f16f28 14.23 landed
- e81c61ee4a8e 15.18 landed
- fe99a0338953 16.14 landed
- df927d3d08b1 17.10 landed
- 315b0f3e87ff 18.4 landed
- b2ff2a0b5296 19 (unreleased) landed