pgsql: Add regression test for ATTACH PARTITION

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Add regression test for ATTACH PARTITION
Date: 2018-10-07 15:08:33
Message-ID: E1g9AfZ-0008C4-If@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(+)

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2018-10-07 18:33:27 pgsql: Remove some unnecessary fields from Plan trees.
Previous Message Alvaro Herrera 2018-10-07 01:14:04 pgsql: Fix catalog insertion order for ATTACH PARTITION