pg.ddx.io pgsql-committers@postgresql.org mailing list archivehelp / color / mirror / Atom feed
pgsql: Fix CREATE TABLE LIKE with not-valid check constraint 2+ messages / 1 participants [nested] [flat]
* pgsql: Fix CREATE TABLE LIKE with not-valid check constraint @ 2025-09-10 11:39 Peter Eisentraut <peter@eisentraut.org> 0 siblings, 0 replies; 2+ messages in thread From: Peter Eisentraut @ 2025-09-10 11:39 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org 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... 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(-) ^ permalink raw reply [nested|flat] 2+ messages in thread
* pgsql: Fix CREATE TABLE LIKE with not-valid check constraint @ 2025-09-10 11:39 Peter Eisentraut <peter@eisentraut.org> 0 siblings, 0 replies; 2+ messages in thread From: Peter Eisentraut @ 2025-09-10 11:39 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org 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... Branch ------ REL_18_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/21fdc37d219acebd298d2e7b309b111a5174ae4c 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(-) ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2025-09-10 11:39 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2025-09-10 11:39 pgsql: Fix CREATE TABLE LIKE with not-valid check constraint Peter Eisentraut <peter@eisentraut.org> 2025-09-10 11:39 pgsql: Fix CREATE TABLE LIKE with not-valid check constraint Peter Eisentraut <peter@eisentraut.org>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox