Horton

Make CREATE TABLE LIKE copy comments on NOT NULL constraints when requested.

Fujii Masao <fujii@postgresql.org>

View on postgr.es
Commit: 81ce602d48e8b9cbc3c3a7d5b9d9ddbea7789c02
Author: Fujii Masao <fujii@postgresql.org>
Date: 2025-06-26T11:25:34Z
Releases: 18.0 
Make CREATE TABLE LIKE copy comments on NOT NULL constraints when requested.

Commit 14e87ffa5c5 introduced support for adding comments to NOT NULL
constraints. However, CREATE TABLE LIKE INCLUDING COMMENTS did not copy
these comments to the new table. This was an oversight in that commit.

This commit corrects the behavior by ensuring CREATE TABLE LIKE to also copy
the comments on NOT NULL constraints when INCLUDING COMMENTS is specified.

Author: Jian He <jian.universality@gmail.com>
Co-authored-by: Álvaro Herrera <alvherre@kurilemu.de>
Reviewed-by: Fujii Masao <masao.fujii@gmail.com>
Discussion: https://postgr.es/m/127debef-e558-4784-9e24-0d5eaf91e2d1@oss.nttdata.com

Files

PathChange+/−
src/backend/parser/parse_utilcmd.c modified +22 −0
src/test/regress/expected/create_table_like.out modified +26 −4
src/test/regress/sql/create_table_like.sql modified +14 −2

Discussion