Re: set relispartition when attaching child index

Поиск
Список
Период
Сортировка
От Amit Langote
Тема Re: set relispartition when attaching child index
Дата
Msg-id CA+HiwqFJViPKwQ-WxstxqOwNEBXte+ApdzJ=ab5-h6tLOogdzA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: set relispartition when attaching child index  (Amit Langote <amitlangote09@gmail.com>)
Ответы Re: set relispartition when attaching child index  (Amit Langote <amitlangote09@gmail.com>)
Список pgsql-hackers
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.

Thanks,
Amit



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Amit Langote
Дата:
Сообщение: Re: set relispartition when attaching child index
Следующее
От: Amit Langote
Дата:
Сообщение: Re: set relispartition when attaching child index