pgsql: Add regression test for ATTACH PARTITION - Mailing list pgsql-committers

From Michael Paquier
Subject pgsql: Add regression test for ATTACH PARTITION
Date
Msg-id E1g9AfZ-0008C4-If@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Add regression test for ATTACH PARTITION

This test case uses a SQL function as partitioning operator, whose
evaluation results in the table's relcache being rebuilt partway
through the execution of an ATTACH PARTITION command.

It is extracted from 39808e8, which fixed a bug where this test case
failed on master and REL_11_STABLE, but passed on REL_10_STABLE.  The
partitioning code has changed a lot during v11 development, so this
makes sure that any patch applied to REL_10_STABLE fixing a
partition-related bug does not break it again.

Author: Amit Langote
Reviewed-by: Michaël Paquier, Álvaro Herrera
Discussion: https://postgr.es/m/CAKcux6=nTz9KSfTr_6Z2mpzLJ_09JN-rK6=dWic6gGyTSWueyQ@mail.gmail.com

Branch
------
REL_10_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/afe9b9e68afb93b6831a939a7a18973ee5286d68

Modified Files
--------------
src/test/regress/expected/alter_table.out | 15 +++++++++++++++
src/test/regress/sql/alter_table.sql      | 16 ++++++++++++++++
2 files changed, 31 insertions(+)


pgsql-committers by date:

Previous
From: Alvaro Herrera
Date:
Subject: pgsql: Fix catalog insertion order for ATTACH PARTITION
Next
From: Tom Lane
Date:
Subject: pgsql: Remove some unnecessary fields from Plan trees.