Re: set relispartition when attaching child index

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

Вложения

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

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