Re: MERGE PARTITIONS and DEPENDS ON EXTENSION.

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)?

>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 ...

With best regards,
Dmitry Koval

Postgres Professional: http://postgrespro.com