From: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
---|---|
To: | pgsql-committers(at)lists(dot)postgresql(dot)org |
Subject: | pgsql: Invalidate partitions of table being attached/detached |
Date: | 2021-10-18 22:12:32 |
Message-ID: | E1mcarw-0004A8-1m@gemulon.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers |
Invalidate partitions of table being attached/detached
Failing to do that, any direct inserts/updates of those partitions
would fail to enforce the correct constraint, that is, one that
considers the new partition constraint of their parent table.
Backpatch to 10.
Reported by: Hou Zhijie <houzj(dot)fnst(at)fujitsu(dot)com>
Author: Amit Langote <amitlangote09(at)gmail(dot)com>
Author: Álvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
Reviewed-by: Nitin Jadhav <nitinjadhavpostgres(at)gmail(dot)com>
Reviewed-by: Pavel Borisov <pashkin(dot)elfe(at)gmail(dot)com>
Discussion: https://postgr.es/m/OS3PR01MB5718DA1C4609A25186D1FBF194089%40OS3PR01MB5718.jpnprd01.prod.outlook.com
Branch
------
master
Details
-------
https://git.postgresql.org/pg/commitdiff/d6f1e16c8fe27100e371a15aeeb498faa680ceed
Modified Files
--------------
src/backend/commands/tablecmds.c | 35 +++++++++++++++++++++++++++++++
src/test/regress/expected/alter_table.out | 20 ++++++++++++++++++
src/test/regress/sql/alter_table.sql | 19 +++++++++++++++++
3 files changed, 74 insertions(+)
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Paquier | 2021-10-19 02:07:54 | pgsql: Block ALTER INDEX/TABLE index_name ALTER COLUMN colname SET (opt |
Previous Message | Heikki Linnakangas | 2021-10-18 17:49:09 | pgsql: Fix parallel sort, broken by the balanced merge patch. |