pg.ddx.io  pgsql-committers@postgresql.org mailing list archive  
help / 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_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_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_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_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

* 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


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