Re: MERGE PARTITIONS and DEPENDS ON EXTENSION.

On Wed, Apr 22, 2026 at 2:30 PM Matheus Alcantara
<matheusssilv97(at)gmail(dot)com> wrote:
> On 22/04/26 08:24, Alexander Korotkov wrote:
> >>> +-- An index created directly on a partition has no parent in the partitioned
> >>> +-- index tree; merge must ignore such indexes (they disappear with the old
> >>> +-- partition).
> >>> +CREATE INDEX part_extdep_3_extra_idx ON part_extdep_3(x);
> >>> +ALTER TABLE part_extdep MERGE PARTITIONS (part_extdep_merged, part_extdep_3)
> >>> + INTO part_extdep_merged2;
> >>> +SELECT relname FROM pg_class
> >>> +WHERE relname LIKE 'part_extdep_merged2%idx' ORDER BY relname;
> >>
> >> Looks like this test is also redundant? This does not test new DEPENDS ON logic.
> >
> > I've added the dependency on this index to check index disappears with
> > its dependency. I think this would make this test more relevant.
> >
> > Kirill, Matheus, are you ok with these change?
> >
> It works for me.

Thank you, pushed!

------
Regards,
Alexander Korotkov
Supabase