pg.ddx.io pgsql-committers@postgresql.org mailing list archivehelp / color / mirror / Atom feed
pgsql: Invalidate partitions of table being attached/detached 6+ messages / 1 participants [nested] [flat]
* pgsql: Invalidate partitions of table being attached/detached @ 2021-10-18 22:12 Alvaro Herrera <alvherre@alvh.no-ip.org> 0 siblings, 0 replies; 6+ messages in thread From: Alvaro Herrera @ 2021-10-18 22:12 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org 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.fnst@fujitsu.com> Author: Amit Langote <amitlangote09@gmail.com> Author: Álvaro Herrera <alvherre@alvh.no-ip.org> Reviewed-by: Nitin Jadhav <nitinjadhavpostgres@gmail.com> Reviewed-by: Pavel Borisov <pashkin.elfe@gmail.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(+) ^ permalink raw reply [nested|flat] 6+ messages in thread
* pgsql: Invalidate partitions of table being attached/detached @ 2021-10-18 22:12 Alvaro Herrera <alvherre@alvh.no-ip.org> 0 siblings, 0 replies; 6+ messages in thread From: Alvaro Herrera @ 2021-10-18 22:12 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org 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.fnst@fujitsu.com> Author: Amit Langote <amitlangote09@gmail.com> Author: Álvaro Herrera <alvherre@alvh.no-ip.org> Reviewed-by: Nitin Jadhav <nitinjadhavpostgres@gmail.com> Reviewed-by: Pavel Borisov <pashkin.elfe@gmail.com> Discussion: https://postgr.es/m/OS3PR01MB5718DA1C4609A25186D1FBF194089%40OS3PR01MB5718.jpnprd01.prod.outlook.com Branch ------ REL_10_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/d36bdc4e9d3ecfc47d2db4fe4cc84eb5baa0cf9c Modified Files -------------- src/backend/commands/tablecmds.c | 36 +++++++++++++++++++++++++++++++ src/test/regress/expected/alter_table.out | 20 +++++++++++++++++ src/test/regress/sql/alter_table.sql | 19 ++++++++++++++++ 3 files changed, 75 insertions(+) ^ permalink raw reply [nested|flat] 6+ messages in thread
* pgsql: Invalidate partitions of table being attached/detached @ 2021-10-18 22:12 Alvaro Herrera <alvherre@alvh.no-ip.org> 0 siblings, 0 replies; 6+ messages in thread From: Alvaro Herrera @ 2021-10-18 22:12 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org 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.fnst@fujitsu.com> Author: Amit Langote <amitlangote09@gmail.com> Author: Álvaro Herrera <alvherre@alvh.no-ip.org> Reviewed-by: Nitin Jadhav <nitinjadhavpostgres@gmail.com> Reviewed-by: Pavel Borisov <pashkin.elfe@gmail.com> Discussion: https://postgr.es/m/OS3PR01MB5718DA1C4609A25186D1FBF194089%40OS3PR01MB5718.jpnprd01.prod.outlook.com Branch ------ REL_14_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/72d0642172571be7b44d54728deb609d7285d9d0 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(+) ^ permalink raw reply [nested|flat] 6+ messages in thread
* pgsql: Invalidate partitions of table being attached/detached @ 2021-10-18 22:12 Alvaro Herrera <alvherre@alvh.no-ip.org> 0 siblings, 0 replies; 6+ messages in thread From: Alvaro Herrera @ 2021-10-18 22:12 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org 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.fnst@fujitsu.com> Author: Amit Langote <amitlangote09@gmail.com> Author: Álvaro Herrera <alvherre@alvh.no-ip.org> Reviewed-by: Nitin Jadhav <nitinjadhavpostgres@gmail.com> Reviewed-by: Pavel Borisov <pashkin.elfe@gmail.com> Discussion: https://postgr.es/m/OS3PR01MB5718DA1C4609A25186D1FBF194089%40OS3PR01MB5718.jpnprd01.prod.outlook.com Branch ------ REL_12_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/8b26be8a32c31d45d3e11bcdab39526969201c88 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(+) ^ permalink raw reply [nested|flat] 6+ messages in thread
* pgsql: Invalidate partitions of table being attached/detached @ 2021-10-18 22:12 Alvaro Herrera <alvherre@alvh.no-ip.org> 0 siblings, 0 replies; 6+ messages in thread From: Alvaro Herrera @ 2021-10-18 22:12 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org 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.fnst@fujitsu.com> Author: Amit Langote <amitlangote09@gmail.com> Author: Álvaro Herrera <alvherre@alvh.no-ip.org> Reviewed-by: Nitin Jadhav <nitinjadhavpostgres@gmail.com> Reviewed-by: Pavel Borisov <pashkin.elfe@gmail.com> Discussion: https://postgr.es/m/OS3PR01MB5718DA1C4609A25186D1FBF194089%40OS3PR01MB5718.jpnprd01.prod.outlook.com Branch ------ REL_13_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/fe35528a5ed6934e0d60c19a02798236160d93f1 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(+) ^ permalink raw reply [nested|flat] 6+ messages in thread
* pgsql: Invalidate partitions of table being attached/detached @ 2021-10-18 22:12 Alvaro Herrera <alvherre@alvh.no-ip.org> 0 siblings, 0 replies; 6+ messages in thread From: Alvaro Herrera @ 2021-10-18 22:12 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org 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.fnst@fujitsu.com> Author: Amit Langote <amitlangote09@gmail.com> Author: Álvaro Herrera <alvherre@alvh.no-ip.org> Reviewed-by: Nitin Jadhav <nitinjadhavpostgres@gmail.com> Reviewed-by: Pavel Borisov <pashkin.elfe@gmail.com> Discussion: https://postgr.es/m/OS3PR01MB5718DA1C4609A25186D1FBF194089%40OS3PR01MB5718.jpnprd01.prod.outlook.com Branch ------ REL_11_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/b703b7d312a75ce3994c82dc71bf04eabb60c49c 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(+) ^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2021-10-18 22:12 UTC | newest] Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2021-10-18 22:12 pgsql: Invalidate partitions of table being attached/detached Alvaro Herrera <alvherre@alvh.no-ip.org> 2021-10-18 22:12 pgsql: Invalidate partitions of table being attached/detached Alvaro Herrera <alvherre@alvh.no-ip.org> 2021-10-18 22:12 pgsql: Invalidate partitions of table being attached/detached Alvaro Herrera <alvherre@alvh.no-ip.org> 2021-10-18 22:12 pgsql: Invalidate partitions of table being attached/detached Alvaro Herrera <alvherre@alvh.no-ip.org> 2021-10-18 22:12 pgsql: Invalidate partitions of table being attached/detached Alvaro Herrera <alvherre@alvh.no-ip.org> 2021-10-18 22:12 pgsql: Invalidate partitions of table being attached/detached Alvaro Herrera <alvherre@alvh.no-ip.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