Re: MERGE PARTITIONS and DEPENDS ON EXTENSION.

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.

--
Matheus Alcantara
EDB: https://www.enterprisedb.com