Re: MERGE PARTITIONS and DEPENDS ON EXTENSION. - Mailing list pgsql-hackers

On 22/04/26 08:34, Alexander Korotkov wrote:
> On Wed, Apr 22, 2026 at 2:30 PM Matheus Alcantara
> <matheusssilv97@gmail.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!
> 

Thank you!

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