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:55:31Z
Lists: pgsql-hackers
Attachments
- IndexSetParentIndex-update_relispartition.patch (application/octet-stream) patch
On Thu, Apr 25, 2019 at 12:39 AM Amit Langote <amitlangote09@gmail.com> wrote: > On Thu, Apr 25, 2019 at 12:38 AM Amit Langote <amitlangote09@gmail.com> wrote: > > 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. > > Although, we wouldn't have this bug if it was IndexSetParentIndex > calling it. Maybe a good idea to do that now. I tried that in the attached. Thanks, Amit
Commits
-
Fix partitioned index attachment
- b1f570b57ccc 11.3 landed
- 05b38c7e63d1 12.0 landed