MIME-Version: 1.0
From: Fujii Masao <masao.fujii@gmail.com>
Date: Tue, 17 Feb 2026 23:36:33 +0900
Message-ID: 
 <CAHGQGwHSOSGcaYDvHF8EYCUCfGPjbRwGFsJ23cx5KbJ1X6JouQ@mail.gmail.com>
Subject: Clarify INCLUDING COMMENTS behavior in CREATE TABLE and CREATE
 FOREIGN TABLE docs
To: pgsql-docs@lists.postgresql.org
Content-Type: multipart/mixed; boundary="0000000000003ce0b2064b060012"
Archived-At: 
 <https://www.postgresql.org/message-id/CAHGQGwHSOSGcaYDvHF8EYCUCfGPjbRwGFsJ23cx5KbJ1X6JouQ%40mail.gmail.com>
Precedence: bulk

--0000000000003ce0b2064b060012
Content-Type: text/plain; charset="UTF-8"

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

--0000000000003ce0b2064b060012
Content-Type: application/octet-stream;
	name="v1-0001-doc-Clarify-INCLUDING-COMMENTS-behavior-in-CREATE.patch"
Content-Disposition: attachment;
	filename="v1-0001-doc-Clarify-INCLUDING-COMMENTS-behavior-in-CREATE.patch"
Content-Transfer-Encoding: base64
Content-ID: <f_mlqphzac0>
X-Attachment-Id: f_mlqphzac0

RnJvbSBkMTM5NTVkYjhiMWUwM2VjY2FjZDg2MDA3MjVkODI5YmRmOTQ0NmFjIE1vbiBTZXAgMTcg
MDA6MDA6MDAgMjAwMQpGcm9tOiBGdWppaSBNYXNhbyA8ZnVqaWlAcG9zdGdyZXNxbC5vcmc+CkRh
dGU6IFR1ZSwgMTcgRmViIDIwMjYgMjI6MDk6MDkgKzA5MDAKU3ViamVjdDogW1BBVENIIHYxXSBk
b2M6IENsYXJpZnkgSU5DTFVESU5HIENPTU1FTlRTIGJlaGF2aW9yIGluIENSRUFURSBUQUJMRQog
TElLRS4KClRoZSBkb2N1bWVudGF0aW9uIGZvciB0aGUgSU5DTFVESU5HIENPTU1FTlRTIG9wdGlv
biBvZiB0aGUgTElLRSBjbGF1c2UKaW4gQ1JFQVRFIFRBQkxFIHdhcyBpbmFjY3VyYXRlIGFuZCBp
bmNvbXBsZXRlLiBJdCBzdGF0ZWQgdGhhdCBjb21tZW50cyBmb3IKY29waWVkIGNvbHVtbnMsIGNv
bnN0cmFpbnRzLCBhbmQgaW5kZXhlcyBhcmUgY29waWVkLCBidXQgcmVnYXJkaW5nIGNvbW1lbnRz
Cm9uIGNvbnN0cmFpbnRzIGluIHJlYWxpdHkgb25seSBjb21tZW50cyBvbiBDSEVDSyBhbmQgTk9U
IE5VTEwgY29uc3RyYWludHMKYXJlIGNvcGllZDsgY29tbWVudHMgb24gb3RoZXIgY29uc3RyYWlu
dHMgKHN1Y2ggYXMgcHJpbWFyeSBrZXlzKSBhcmUgbm90LgpJbiBhZGRpdGlvbiwgY29tbWVudHMg
b24gZXh0ZW5kZWQgc3RhdGlzdGljcyBhcmUgY29waWVkLCBidXQgdGhpcyB3YXMgbm90CmRvY3Vt
ZW50ZWQuCgpUaGUgQ1JFQVRFIEZPUkVJR04gVEFCTEUgZG9jdW1lbnRhdGlvbiBoYWQgYSBzaW1p
bGFyIG9taXNzaW9uOiBjb21tZW50cwpvbiBleHRlbmRlZCBzdGF0aXN0aWNzIGFyZSBhbHNvIGNv
cGllZCwgYnV0IHRoaXMgd2FzIG5vdCBtZW50aW9uZWQuCgpUaGlzIGNvbW1pdCB1cGRhdGVzIHRo
ZSBkb2N1bWVudGF0aW9uIHRvIGNsYXJpZnkgdGhlIGFjdHVhbCBiZWhhdmlvci4KVGhlIENSRUFU
RSBUQUJMRSByZWZlcmVuY2Ugbm93IHNwZWNpZmllcyB0aGF0IGNvbW1lbnRzIG9uIGNvcGllZCBj
b2x1bW5zLApDSEVDSyBjb25zdHJhaW50cywgTk9UIE5VTEwgY29uc3RyYWludHMsIGluZGV4ZXMs
IGFuZCBleHRlbmRlZCBzdGF0aXN0aWNzIGFyZQpjb3BpZWQuIFRoZSBDUkVBVEUgRk9SRUlHTiBU
QUJMRSByZWZlcmVuY2Ugbm93IG5vdGVzIHRoYXQgY29tbWVudHMgb24KZXh0ZW5kZWQgc3RhdGlz
dGljcyBhcmUgY29waWVkIGFzIHdlbGwuCi0tLQogZG9jL3NyYy9zZ21sL3JlZi9jcmVhdGVfZm9y
ZWlnbl90YWJsZS5zZ21sIHwgNiArKystLS0KIGRvYy9zcmMvc2dtbC9yZWYvY3JlYXRlX3RhYmxl
LnNnbWwgICAgICAgICB8IDUgKysrLS0KIDIgZmlsZXMgY2hhbmdlZCwgNiBpbnNlcnRpb25zKCsp
LCA1IGRlbGV0aW9ucygtKQoKZGlmZiAtLWdpdCBhL2RvYy9zcmMvc2dtbC9yZWYvY3JlYXRlX2Zv
cmVpZ25fdGFibGUuc2dtbCBiL2RvYy9zcmMvc2dtbC9yZWYvY3JlYXRlX2ZvcmVpZ25fdGFibGUu
c2dtbAppbmRleCAwOGE4Y2VlYWU3NS4uZDMxNjZlNTY5YWIgMTAwNjQ0Ci0tLSBhL2RvYy9zcmMv
c2dtbC9yZWYvY3JlYXRlX2ZvcmVpZ25fdGFibGUuc2dtbAorKysgYi9kb2Mvc3JjL3NnbWwvcmVm
L2NyZWF0ZV9mb3JlaWduX3RhYmxlLnNnbWwKQEAgLTIzMiw5ICsyMzIsOSBAQCBXSVRIICggTU9E
VUxVUyA8cmVwbGFjZWFibGUgY2xhc3M9InBhcmFtZXRlciI+bnVtZXJpY19saXRlcmFsPC9yZXBs
YWNlYWJsZT4sIFJFTQogICAgICAgICA8dGVybT48bGl0ZXJhbD5JTkNMVURJTkcgQ09NTUVOVFM8
L2xpdGVyYWw+PC90ZXJtPgogICAgICAgICA8bGlzdGl0ZW0+CiAgICAgICAgICA8cGFyYT4KLSAg
ICAgICAgICBDb21tZW50cyBmb3IgdGhlIGNvcGllZCBjb2x1bW5zIGFuZCBjb25zdHJhaW50cyB3
aWxsIGJlCi0gICAgICAgICAgY29waWVkLiAgVGhlIGRlZmF1bHQgYmVoYXZpb3IgaXMgdG8gZXhj
bHVkZSBjb21tZW50cywgcmVzdWx0aW5nIGluCi0gICAgICAgICAgdGhlIGNvcGllZCBjb2x1bW5z
IGFuZCBjb25zdHJhaW50cyBpbiB0aGUgbmV3IHRhYmxlIGhhdmluZyBubworICAgICAgICAgIENv
bW1lbnRzIGZvciB0aGUgY29waWVkIGNvbHVtbnMsIGNvbnN0cmFpbnRzLCBhbmQgZXh0ZW5kZWQg
c3RhdGlzdGljcworICAgICAgICAgIHdpbGwgYmUgY29waWVkLiAgVGhlIGRlZmF1bHQgYmVoYXZp
b3IgaXMgdG8gZXhjbHVkZSBjb21tZW50cywKKyAgICAgICAgICByZXN1bHRpbmcgaW4gdGhlIGNv
cnJlc3BvbmRpbmcgb2JqZWN0cyBpbiB0aGUgbmV3IHRhYmxlIGhhdmluZyBubwogICAgICAgICAg
IGNvbW1lbnRzLgogICAgICAgICAgPC9wYXJhPgogICAgICAgICA8L2xpc3RpdGVtPgpkaWZmIC0t
Z2l0IGEvZG9jL3NyYy9zZ21sL3JlZi9jcmVhdGVfdGFibGUuc2dtbCBiL2RvYy9zcmMvc2dtbC9y
ZWYvY3JlYXRlX3RhYmxlLnNnbWwKaW5kZXggNzdjNWE3NjNkNDUuLjk4MjUzMmZlNzI1IDEwMDY0
NAotLS0gYS9kb2Mvc3JjL3NnbWwvcmVmL2NyZWF0ZV90YWJsZS5zZ21sCisrKyBiL2RvYy9zcmMv
c2dtbC9yZWYvY3JlYXRlX3RhYmxlLnNnbWwKQEAgLTY3Miw5ICs2NzIsMTAgQEAgV0lUSCAoIE1P
RFVMVVMgPHJlcGxhY2VhYmxlIGNsYXNzPSJwYXJhbWV0ZXIiPm51bWVyaWNfbGl0ZXJhbDwvcmVw
bGFjZWFibGU+LCBSRU0KICAgICAgICAgPHRlcm0+PGxpdGVyYWw+SU5DTFVESU5HIENPTU1FTlRT
PC9saXRlcmFsPjwvdGVybT4KICAgICAgICAgPGxpc3RpdGVtPgogICAgICAgICAgPHBhcmE+Ci0g
ICAgICAgICAgQ29tbWVudHMgZm9yIHRoZSBjb3BpZWQgY29sdW1ucywgY29uc3RyYWludHMsIGFu
ZCBpbmRleGVzIHdpbGwgYmUKKyAgICAgICAgICBDb21tZW50cyBmb3IgdGhlIGNvcGllZCBjb2x1
bW5zLCBjaGVjayBjb25zdHJhaW50cywKKyAgICAgICAgICBub3QtbnVsbCBjb25zdHJhaW50cywg
aW5kZXhlcywgYW5kIGV4dGVuZGVkIHN0YXRpc3RpY3Mgd2lsbCBiZQogICAgICAgICAgIGNvcGll
ZC4gIFRoZSBkZWZhdWx0IGJlaGF2aW9yIGlzIHRvIGV4Y2x1ZGUgY29tbWVudHMsIHJlc3VsdGlu
ZyBpbgotICAgICAgICAgIHRoZSBjb3BpZWQgY29sdW1ucyBhbmQgY29uc3RyYWludHMgaW4gdGhl
IG5ldyB0YWJsZSBoYXZpbmcgbm8KKyAgICAgICAgICB0aGUgY29ycmVzcG9uZGluZyBvYmplY3Rz
IGluIHRoZSBuZXcgdGFibGUgaGF2aW5nIG5vCiAgICAgICAgICAgY29tbWVudHMuCiAgICAgICAg
ICA8L3BhcmE+CiAgICAgICAgIDwvbGlzdGl0ZW0+Ci0tIAoyLjUxLjIKCg==
--0000000000003ce0b2064b060012--