Horton

Fix CREATE TABLE LIKE with not-valid check constraint

Peter Eisentraut <peter@eisentraut.org>

View on postgr.es
Commit: 33eec809402bfbf3eb0d01ad5b023d3d05fcb3bc
Author: Peter Eisentraut <peter@eisentraut.org>
Date: 2025-09-10T11:25:58Z
Releases: 19 (unreleased) 
Fix CREATE TABLE LIKE with not-valid check constraint

In CREATE TABLE ... LIKE, any check constraints copied from the source
table should be set to valid if they are ENFORCED (the default).

Bug introduced in commit ca87c415e2f.

Author: jian he <jian.universality@gmail.com>
Discussion: https://www.postgresql.org/message-id/CACJufxH%3D%2Bod8Wy0P4L3_GpapNwLUP3oAes5UFRJ7yTxrM_M5kg%40mail.gmail.com

Files

PathChange+/−
src/backend/parser/parse_utilcmd.c modified +1 −2
src/test/regress/expected/create_table_like.out modified +8 −0
src/test/regress/sql/create_table_like.sql modified +1 −0

Discussion