Horton

Fix CREATE TABLE LIKE with not-valid check constraint

Peter Eisentraut <peter@eisentraut.org>

View on postgr.es
Commit: 21fdc37d219acebd298d2e7b309b111a5174ae4c
Author: Peter Eisentraut <peter@eisentraut.org>
Date: 2025-09-10T11:25:34Z
Releases: 18.0 
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