| 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-001aNS-2s@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
------
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(-)
| 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. |