projects / postgresql.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: e6da68a) | patch
Fix CREATE TABLE LIKE with not-valid check constraint
authorPeter Eisentraut <peter@eisentraut.org>
Wed, 10 Sep 2025 09:49:53 +0000 (11:49 +0200)
committerPeter Eisentraut <peter@eisentraut.org>
Wed, 10 Sep 2025 11:25:58 +0000 (13:25 +0200)
commit33eec809402bfbf3eb0d01ad5b023d3d05fcb3bc
tree02fa2b7dac90305329efd6f38e00133f5f5ad2a1tree
parente6da68a6e1d60a037b63a9c9ed36e5ef0a996769commit | diff
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
src/backend/parser/parse_utilcmd.c diff | blob | blame | history
src/test/regress/expected/create_table_like.out diff | blob | blame | history
src/test/regress/sql/create_table_like.sql diff | blob | blame | history
This is the main PostgreSQL git repository.