| From: | Peter Eisentraut <peter(at)eisentraut(dot)org> |
|---|---|
| To: | pgsql-committers(at)lists(dot)postgresql(dot)org |
| Subject: | pgsql: Fix CREATE TABLE LIKE with not-valid check constraint |
| Date: | 2025-09-10 11:39:46 |
| Message-ID: | E1uwJAw-001aNU-2w@gemulon.postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-committers |
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(dot)universality(at)gmail(dot)com>
Discussion: https://www.postgresql.org/message-id/CACJufxH%3D%2Bod8Wy0P4L3_GpapNwLUP3oAes5UFRJ7yTxrM_M5kg%40mail.gmail.com
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(-)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nathan Bossart | 2025-09-10 16:22:33 | pgsql: meson: Build numeric.c with -ftree-vectorize. |
| Previous Message | Amit Kapila | 2025-09-10 09:10:55 | Re: pgsql: Preserve conflict-relevant data during logical replication. |