Re: set relispartition when attaching child index
Amit Langote <amitlangote09@gmail.com>
From: Amit Langote <amitlangote09@gmail.com>
To: Alvaro Herrera <alvherre@2ndquadrant.com>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2019-04-24T15:38:02Z
Lists: pgsql-hackers
On Thu, Apr 25, 2019 at 12:35 AM Alvaro Herrera <alvherre@2ndquadrant.com> wrote: > On 2019-Apr-25, Amit Langote wrote: > > > It seems that DefineIndex() is forgetting to update_relispartition() > > on a partition's index when it's attached to an index being added to > > the parent. That results in unexpected behavior when adding a foreign > > key referencing the parent. > > BTW, maybe IndexSetParentIndex ought to be the one calling > update_relispartition() ... I thought so too, but other sites are doing what I did in the patch. Thanks, Amit
Commits
-
Fix partitioned index attachment
- b1f570b57ccc 11.3 landed
- 05b38c7e63d1 12.0 landed