Clarify INCLUDING COMMENTS behavior in CREATE TABLE and CREATE FOREIGN TABLE docs

From: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
To: pgsql-docs(at)lists(dot)postgresql(dot)org
Subject: Clarify INCLUDING COMMENTS behavior in CREATE TABLE and CREATE FOREIGN TABLE docs
Date: 2026-02-17 14:36:33
Message-ID: CAHGQGwHSOSGcaYDvHF8EYCUCfGPjbRwGFsJ23cx5KbJ1X6JouQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-docs

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?

Regards,

--
Fujii Masao

Attachment Content-Type Size
v1-0001-doc-Clarify-INCLUDING-COMMENTS-behavior-in-CREATE.patch application/octet-stream 3.1 KB

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message PG Doc comments form 2026-02-19 06:57:45 Typo
Previous Message Alexey Shishkin 2026-02-17 14:33:28 Re: OS system version upgrade (glibc / libicu version change)