git.postgresql.org Git - postgresql.git/commit

git projects / postgresql.git / commit

Fix CREATE TABLE LIKE with not-valid check constraint

author Peter Eisentraut <peter@eisentraut.org>

2025年9月10日 09:49:53 +0000 (11:49 +0200)

committer Peter Eisentraut <peter@eisentraut.org>

2025年9月10日 11:25:58 +0000 (13:25 +0200)

commit 33eec809402bfbf3eb0d01ad5b023d3d05fcb3bc

tree 02fa2b7dac90305329efd6f38e00133f5f5ad2a1 tree

parent e6da68a6e1d60a037b63a9c9ed36e5ef0a996769 commit | 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.

RSS Atom