pgsql: Fix CREATE TABLE LIKE with not-valid check constraint

Started by Peter Eisentraut10 months ago1 messagescomitters
Jump to latest
#1Peter Eisentraut
peter_e@gmx.net

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: /messages/by-id/CACJufxH=+od8Wy0P4L3_GpapNwLUP3oAes5UFRJ7yTxrM_M5kg@mail.gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/33eec809402bfbf3eb0d01ad5b023d3d05fcb3bc

Modified Files
--------------
src/backend/parser/parse_utilcmd.c | 3 +--
src/test/regress/expected/create_table_like.out | 8 ++++++++
src/test/regress/sql/create_table_like.sql | 1 +
3 files changed, 10 insertions(+), 2 deletions(-)