Re: MERGE PARTITIONS and DEPENDS ON EXTENSION.

On Sun Apr 19, 2026 at 9:04 PM -03, Dmitry Koval wrote:
> Hi Matheus!
>
> >v3-0001-Preserve-extension-dependencies-on-indexes-during.patch
>
> I looked patch and did not find problems. But there is one point:
> extensions btree_gist, btree_gin, citext are not included by default.
> So command
>
> > ./configure --enable-debug --enable-cassert --prefix `pwd`/install
> > >/dev/null && make -s && make install -s && make check
>
> generates errors like
>
> ERROR: extension "btree_gist" is not available
> ERROR: extension "btree_gin" is not available
> ERROR: extension "citext" is not available
>
> Might be it would be better to use for tests extensions from the
> catalog src/test/modules/test_extensions (see test
> src/test/modules/test_extensions/sql/test_extdepend.sql)?
>

Thanks for looking at this!

Yeah, some build farm animals will not be happy with these new tests.
Fixed on new attached v4 to use extensions from
src/test/modules/test_extensions.

> >extension dependencies on parent partitioned indexes don't seem to
> >prevent DROP EXTENSION, but dependencies on child partition indexes
> >do. ...
>
> I agree, it looks strange ...
>

I'll start a new thread to discuss this.

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